User Directory Tables

User Directory Tables

The Personalization module uses the following tables to store information about the organizations and roles that make up a user directory. The tables shown here correspond to external users. A parallel set of tables, with the prefix dpi, exists for internal users.

dps_child_folder

This table stores a list of a role folder’s child folders.

Column	Data Type	Constraint
`folder_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for this role folder. References `dps_folder(folder_id)`.
`child_folder_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for the child folder. References `dps_folder(folder_id)`.

dps_folder

This table stores information that defines a folder in the user directory.

Column	Data Type	Constraint
`folder_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for this folder.
`type`	INT	NOT NULL
	Identifies the type of folder. Values can be as follows: `2000` (`genericFolder`), `2001` (`roleFolder`), or `2002` (`orgFolder`)
`name`	WVARCHAR(254)	NOT NULL
	The user-specified name for this folder.
`parent`	VARCHAR(40)	NULL
	The ID of this folder’s parent folder. References `dps_folder(folder_id)`.
`description`	WVARCHAR(254)	NULL
	The user-specified description for this folder.

dps_organization

This table stores information that defines a user directory organization.

Column	Data Type	Constraint
`org_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for this organization.
`name`	WVARCHAR(254)	NOT NULL
	The user-specified name for this organization.
`description`	WVARCHAR(254)	NULL
	The user-specified description for this organization.
`parent_org`	VARCHAR(40)	NULL
	The ID of this organization’s parent organization. References `dps_organization(org_id)`.

dps_org_ancestors

This table stores a list of an organization’s ancestor organizations.

Column	Data Type	Constraint
`org_Id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of this organization. References `dps_organization(org_id)`.
`sequence_num`	INT	NOT NULL
(primary key)	The index of this ancestor organization in the list.
`anc_org`	VARCHAR(40)	NOT NULL
	The unique identifier of the ancestor organization. References `dps_organization(org_id)`

dps_org_chldorg

This table stores a list of an organization’s child organizations.

Column	Data Type	Constraint
`org_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for this organization. References `dps_organization(org_id)`.
`child_org_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for the child organization. References `dps_organization(org_id)`.

dps_org_role

This table stores a list of roles assigned to an organization.

Column	Data Type	Constraint
`org_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for this organization. References `dps_organization(org_id)`.
`atg_role`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of the role. References `dps_role(role_id)`.

dps_relativerole

This table stores information that defines an organizational role.

Column	Data Type	Constraint
`role_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID of this organizational role. References `dps_role(role_id)`.
`dps_function`	WVARCHAR(40)	NOT NULL
	The value of the `function` property of this organizational role.
`relative_to`	VARCHAR(40)	NOT NULL
	The organization to which this role is relative. References `dps_organization(org_id)`.

dps_role

This table stores information that defines a global or organizational role.

Column	Data Type	Constraint
`role_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID of this role.
`type`	INT	NOT NULL
	The type of role. The value can be 2000 (global role) or 2001 (organizational role).
`version`	INT	NOT NULL
	The revision number for this role.
`name`	WVARCHAR(254)	NOT NULL )
	The user-specified name for this role.
`description`	WVARCHAR(254)	NULL
	The user-specified description for this role.

dps_rolefold_chld

This table stores a list of the global roles in a role folder.

Column	Data Type	Constraint
`rolefold_id`	VARCHAR(40)	NOT NULL
(primary key)	The ID of this role folder. References `dps_folder(folder_id)`.
`role_id`	VARCHAR(40	NOT NULL
(primary key)	The ID of this role. References `dps_role(role_id)`.

dps_role_rel_org

This table stores a list of the organizational roles assigned to an organization.

Column	Data Type	Constraint
`organization`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for this organization. References `dps_organization(org_id)`.
`sequence_num`	INT	NOT NULL
(primary key)	The index of this organizational role in the list.
`role_id`	VARCHAR(40)	NOT NULL
	The unique identifier for this organizational role. References `dps_role(role_id)`.

dps_user_org

This table stores a list of the users who are assigned to an organization.

Column	Data Type	Constraint
`organization`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for this organization. References `dps_organization(org_id)`.
`user_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for the user assigned to the organization. References `dps_user(id)`.

dps_user_org_anc

This table stores a list of a user’s ancestor organizations.

Column	Data Type	Constraint
`user_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier of this user. References `dps_user(id)`.
`sequence_num`	INT	NOT NULL
(primary key)	The index of this ancestor organization in the user’s list.
`anc_org`	VARCHAR(40)	NOT NULL
	The unique identifier of the ancestor organization. References `dps_organization(org_id)`.

dps_user_roles

This table extends the user profile to include references to roles assigned to this user.

Column	Data Type	Constraint
`user_id`	VARCHAR(40)	NOT NULL
(primary key)	The unique identifier for this user. References `dps_user(id)`.
`atg_role`	VARCHAR(40)	NOT NULL
(primary key)	A role assigned to this user. References `dps_role(role_id)`.

Contents
Search

loading table of contents...