Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The unique ID for the relation. |
||||
OPERATION_OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The ID of the operation associated |
||||
ORGANIZATION_OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The ID of the Organization 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) |
---|---|---|---|
OPERATION_ORGANIZATION_PK | Primary key | Asc | OBJECT_ID |
OPER_ORG_UNIQUE | Must be unique | Asc/Asc | OPERATION_OBJECT_ID + ORGANIZATION_OBJECT_ID |