While this table does not have a field defined as a primary key, the USERROLEID field should be unique and considered a primary key.
Added in Version 7.2
The USERROLE table stores user information for security roles created in the Application Architect Security Explorer. This table contains information for the user that is assigned to a Web security role.
|
|
While this table does not have a field defined as a primary key, the USERROLEID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
USERROLEID |
char(12) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
USERID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ROLEID (FK) |
char(12) |
NULLS |
|
(Many) to (One) |