The ADMINROLES table stores information about the administrative role profiles that determine which functions a user can perform in the Administrator. Administrative users are given access rights based on their assigned administrative role. This table stores the role ID, role name, and security code ID.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ROLEID (PK) |
STANDARDID |
NOT NULL |
ADMINROLES_ROLEID_PK (CA) |
|
|
|
ROLENAME |
varchar(30) |
NULLS |
|
|
|
|
SECCODEID (FK) |
STANDARDID |
NULLS |
|
(One) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |