The relationships table is used to store information such as: - Groups relationship to their parent group (group-to-group) - User group membership (User-to-Group) - Document to Folder relationships - Portal sub-administration roles
| Column Name | Column Datatype | Column Null Option | Column Comment |
| parentkey | integer | not null | The objectkey of the parent object in the tree structure. |
| childkey | integer | not null | The objectkey of the child object in the tree structure. |
| sortorder | integer | not null | Overloaded field used to show the type of role a user has a
group such as group admin, user admin or normal.
Role Values: ROLE_NONE = 0 ROLE_GROUP_ADMIN = 1 ROLE_USER_ADMIN = 2 ROLE_GROUP_USER_ADMIN = 3 |
| relationshiptype | integer | not null | Integer value representing the type of relationship between
the parent and child. For example, it could mean that a user
is a member of a group, a group is a member of a group or a
folder is a member of another folder.
Valid Values: TYPE_GROUP_USER=0 TYPE_FOLDER_DOCUMENTFOLDER=1 TYPE_USERGROUP_PUBLISHER=3 TYPE_GROUP_GROUP=10 |
Product Name: Portal
Table Type: Table