14.1 sp800_user_roles
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This tables represents the link between users within sp085_users and the authorisation roles (e.g. Service Resource, Service Resource Manager, or Planner) associated with them.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| user_id | varchar2(50) |  | |
| role_id | number | |
Keys
primary key (user_id, role_id)
foreign key (user_id) references 14.1 sp085_users (user_id)
foreign key (role_id) references 14.1 sp808_role_definition (role_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| user_id | User identifier. |
| role_id | Role identifier. |