Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The unique ID for the relation. |
||||
SERVICE_OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The ID of the Service 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) |
---|---|---|---|
SERVICE_ROLE_PK | Primary key | Asc | OBJECT_ID |