OpenACS Users & Groups

[group_element_index]

6

1556

This table is for internal use by the parties system. It as an auxiliary table, a denormalization of data, that is used to improve performance. Do not query on this table or insert into it. Query on group_element_map instead. And insert by using the API's for membership_rel, composition_rel, or some sub-type of those relationship types.

[group_types]

2

3

This table holds additional knowledge level attributes for the group type and its subtypes.

[groups]

3

18

OpenACS Groups, sub-type of party (every group is also a "party").

[parties]

3

450

Party is the supertype of person and organization. It exists because many other types of object can have relationships to parties.

[party_approved_member_map]

3

2366

Denormalized index of parties belonging to groups and their sub-groups.

[persons]

8

193

Being a sub-class of "party", a "person" additionally defines a first and last name. This table is used to store DynField extensions for users.

[postal_addresses]

9

0

Master address table for OpenACS. Not use by ]po[.

[postal_types]

2

4

Not used by ]po[.

[user_preferences]

7

242

Locale and timezone preferences of each user.

[users]

20

193

Sub-class of "person". Represents user accounts that can log on to ]po[. Defines username, password, salt and the ]po[ skin for the user.