OPERATION_ORGANIZATION

42 rows


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
OPERATION.OBJECT_ID FK_ASS_5R

The ID of the operation associated

ORGANIZATION_OBJECT_ID VARCHAR2 30 null
ORGANIZATION.OBJECT_ID FK_ASS_6R

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

Relationships