Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 13 Roles : role_users

role_users
The role_users table holds information about which roles are defined on the system, and which queues are assigned to them.
Structure
The role_users table has the following structure:
TABLE role_users (
node_id INTEGER NOT NULL,
role_id INTEGER NOT NULL,
role_name VARCHAR(15) NOT NULL,
usernode_name VARCHAR(49) NOT NULL)
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following index is defined for this table.
Table Activity
The role_users table contains one row for each role defined on the system.
Rows are added, updated and deleted in the following situations.
a Move System Information is performed, if the flag_table indicates that the Roles data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_role_users table.
a Move System Information is performed, if the flag_table indicates that the Roles data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_role_users table.

Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved