While this table does not have a field defined as a primary key, the ROLEID field should be unique and considered a primary key.
Added in Version 7.2
The ROLE table stores information for Web security roles created in the Application Architect Security Explorer. The table contains information entered on the Role tab, such as the role name and description.
|
|
While this table does not have a field defined as a primary key, the ROLEID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
ROLEID (FK) |
char(12) |
NOT NULL |
|
(One) to (Many) |
SECUREDACTIONROLE.ROLEID |
|
(One) to (Many) |
|||||
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
ROLENAME |
varchar(64) |
NULLS |
|
|
|
|
ROLEDESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
ERPEXTID |
varchar(64) |
NULLS |
|||
|
ALTERNATEKEYSUFFIX |
varchar(64) |
NULLS |
|||
|
ALTERNATEKEYPREFIX |
varchar(64) |
NULLS |
|||
|
ERPACCOUNTINGENTITYID |
varchar(64) |
NULLS |
|||
|
ERPUNIQUEID |
varchar(64) |
NULLS |
|||
|
ERPVARIATIONID |
varchar(64) |
NULLS |
|||
|
SYNCSTATUS |
varchar(64) |
NULLS |
|||
|
ERPSTATUS |
varchar(64) |
NULLS |
|||
|
ERPEXTID |
varchar(64) |
NULLS |
|||
|
ERPROLENAME |
varchar(64) |
NULLS |
|||
|
ERPLOGICALID |
varchar(64) |
NULLS |