Forum OpenACS Development: Response to Porting Notes - Take 2

Collapse
Posted by Tom Jackson on

The email is not a primary key in the parties table, but it does have a uniqueness constraint. The primary key is party_id and is used as an identifier throughout the system and doesn't need to change.

Note also that all objects in ACS 4 reference an acs_object(object_id). I think the hierarchy for a acs_user is:

acs_objects
 parties
  persons
   users
    acs_users