CREATE TABLE aca_relationships_int (
    INTERFACE_TABLE_UNIQUE_ID    NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    TRANSACTION_TYPE             VARCHAR2(40)      NOT NULL,
    OBJECT_NUMBER                VARCHAR2(2000),
    OBJECT_ORG_CODE              VARCHAR2(72)  ,
    OBJECT_ID                    NUMBER(18, 0) ,
    OBJECT_TYPE                  VARCHAR2(120) ,
    RELATIONSHIP_TYPE            VARCHAR2(120) ,
    RELATED_OBJ_NUMBER           VARCHAR2(2000),
    RELATED_OBJ_TYPE             VARCHAR2(120) ,
    RELATED_OBJ_ORG_CODE         VARCHAR2(72)  ,
    RELATED_OBJ_ID               NUMBER(18, 0) ,
    RELATIONSHIP_ID              NUMBER(18, 0) ,
    LOAD_REQUEST_ID              NUMBER(18, 0) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    BATCH_ID                     NUMBER(18, 0) ,
    PROCESS_STATUS               VARCHAR2(12)  ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CREATED_BY                   VARCHAR2(256) ,
    CREATION_DATE                TIMESTAMP(6)  ,
    LAST_UPDATED_BY              VARCHAR2(256) ,
    LAST_UPDATE_DATE             TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    INTERFACE_TABLE_UNIQUE_ID    NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    TRANSACTION_TYPE             VARCHAR2(40)      NOT NULL,
    OBJECT_NUMBER                VARCHAR2(2000),
    OBJECT_ORG_CODE              VARCHAR2(72)  ,
    OBJECT_ID                    NUMBER(18, 0) ,
    OBJECT_TYPE                  VARCHAR2(120) ,
    RELATIONSHIP_TYPE            VARCHAR2(120) ,
    RELATED_OBJ_NUMBER           VARCHAR2(2000),
    RELATED_OBJ_TYPE             VARCHAR2(120) ,
    RELATED_OBJ_ORG_CODE         VARCHAR2(72)  ,
    RELATED_OBJ_ID               NUMBER(18, 0) ,
    RELATIONSHIP_ID              NUMBER(18, 0) ,
    LOAD_REQUEST_ID              NUMBER(18, 0) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    BATCH_ID                     NUMBER(18, 0) ,
    PROCESS_STATUS               VARCHAR2(12)  ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    CREATED_BY                   VARCHAR2(256) ,
    CREATION_DATE                TIMESTAMP(6)  ,
    LAST_UPDATED_BY              VARCHAR2(256) ,
    LAST_UPDATE_DATE             TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    CONSTRAINT pk_aca_relationships_int PRIMARY KEY (INTERFACE_TABLE_UNIQUE_ID, INTERFACE_TABLE_UNIQUE_ID)
);
