CREATE TABLE cse_tracked_object_refs (
    TRACKED_OBJECT_REF_ID    NUMBER(18, 0),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    ASSET_ID                 NUMBER(18, 0)    NOT NULL,
    TRANSACTION_ID           NUMBER(18, 0)    NOT NULL,
    GEN_OBJECT_ID            NUMBER(18, 0),
    TRACKED_OBJECT_CODE      VARCHAR2(120)    NOT NULL,
    PK_VALUE1                VARCHAR2(960),
    UK_VALUE1                VARCHAR2(960),
    PK_VALUE2                VARCHAR2(960),
    UK_VALUE2                VARCHAR2(960),
    PK_VALUE3                VARCHAR2(960),
    UK_VALUE3                VARCHAR2(960),
    PK_VALUE4                VARCHAR2(960),
    UK_VALUE4                VARCHAR2(960),
    PK_VALUE5                VARCHAR2(960),
    UK_VALUE5                VARCHAR2(960),
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    TRACKED_OBJECT_REF_ID    NUMBER(18, 0),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    ASSET_ID                 NUMBER(18, 0)    NOT NULL,
    TRANSACTION_ID           NUMBER(18, 0)    NOT NULL,
    GEN_OBJECT_ID            NUMBER(18, 0),
    TRACKED_OBJECT_CODE      VARCHAR2(120)    NOT NULL,
    PK_VALUE1                VARCHAR2(960),
    UK_VALUE1                VARCHAR2(960),
    PK_VALUE2                VARCHAR2(960),
    UK_VALUE2                VARCHAR2(960),
    PK_VALUE3                VARCHAR2(960),
    UK_VALUE3                VARCHAR2(960),
    PK_VALUE4                VARCHAR2(960),
    UK_VALUE4                VARCHAR2(960),
    PK_VALUE5                VARCHAR2(960),
    UK_VALUE5                VARCHAR2(960),
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    CONSTRAINT pk_cse_tracked_object_refs PRIMARY KEY (TRACKED_OBJECT_REF_ID, TRACKED_OBJECT_REF_ID)
);
