]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

 · · · Index · Login/Register

Contents





1 registered user
 in last 24 hours

OpenACS Users & Groups

OpenACS defines a group hierarchy (a group can contain users and other groups) and several types of users:

 

­ 

Table

Cols

Rows

Description

[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.

­

Please take a moment to complete this form to help us improve our service.

Did this page help you to achieve your goal?
 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?
 1  2  3  4  5
Not
useful		       Extremely
useful
 
Privacy Policy
References to this Page: en:object_type_im_employee, en:list_tables, en:list_plsql_users_groups, en:object_type_person Categories: Database Tables (Contents)