Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The unique ID for the relation. |
||||
PROFILE_OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The ID of the Profile associated |
||||
ROLE_OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The ID of the Role associated |
||||
ACTIVE | CHAR | 1 | √ | null |
|
|
Indicates if this Relationship is active or deleted |
|||
LAST_CHANGED | TIMESTAMP(6) | 11,6 | √ | null |
|
|
The date and time of the last change of the record. |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PROFILE_ROLE_PK | Primary key | Asc | OBJECT_ID |
PRF_ROL_UNIQUE | Must be unique | Asc/Asc | PROFILE_OBJECT_ID + ROLE_OBJECT_ID |