The vdsAssignedAdminRoles table stores the assignment mapping between defined administrator roles and user accounts they are assigned to.
Columns
| Column name | Data type | Primary key | Nullable | Description |
|---|---|---|---|---|
| vdsTemplateID | varchar(60) | Yes | No | Auto-generated ID to uniquely identify the admin role. |
| vdsUserId | varchar(255) | Yes | No | The ID of the user account that has this administrator role assigned. |
| vdsDomain | varchar(255) | Yes | No | The user domain. |
| vdsCreateTime | timestamp | No | No | The date and time the data record was created. |
| vdsModifyTime | timestamp | No | No | The date and time the data record was last modified. |
| vdsVersion | integer | No | Yes | The current data schema version of the data record. |
Keys
Primary key: (vdsTemplateID, vdsUserId, vdsDomain)
Foreign keys:
(vdsTemplateID) references vdsAdminRole (vdsTemplateID)
(vdsUserId, vdsDomain) references vdsUser (vdsUserId, vdsDomain)
Indexes
| Index name | Included fields |
|---|---|
| Level 0 (default) | |
vdsassignedadminrolesidx | vdsDomain vdsUserId |