CREATE TABLE cmf_fd_references_int (
    FD_REFERENCES_INT_ID         NUMBER(18, 0) ,
    FD_HEADERS_INT_ID            NUMBER(18, 0) ,
    DOCUMENT_REF_ATTR_ID         NUMBER(18, 0) ,
    DOCUMENT_HEADER_ID           NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    REF_DOCUMENT_HEADER_ID       NUMBER(18, 0) ,
    REF_ACCESS_KEY_NUMBER        VARCHAR2(256) ,
    REF_DOCUMENT_NUMBER          VARCHAR2(256) ,
    REF_FD_DOCUMENT_TYPE         VARCHAR2(120) ,
    REF_SERIES                   VARCHAR2(256) ,
    REF_ISSUE_DATE               VARCHAR2(16)  ,
    REF_FD_ISSUE_DATE            DATE          ,
    REF_MODEL                    VARCHAR2(256) ,
    REF_ISSUER_TAXPAYER_ID       VARCHAR2(256) ,
    REF_ISSUER_ID                NUMBER(18, 0) ,
    REF_ISSUER_STATE             VARCHAR2(8)   ,
    VALIDATION_STATUS            VARCHAR2(40)  ,
    EXTERNAL_SYSTEM_REFERENCE    VARCHAR2(960) ,
    EXTERNAL_SYSTEM_REF_ID       VARCHAR2(120) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    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) ,
    FD_REFERENCES_INT_ID         NUMBER(18, 0) ,
    FD_HEADERS_INT_ID            NUMBER(18, 0) ,
    DOCUMENT_REF_ATTR_ID         NUMBER(18, 0) ,
    DOCUMENT_HEADER_ID           NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    REF_DOCUMENT_HEADER_ID       NUMBER(18, 0) ,
    REF_ACCESS_KEY_NUMBER        VARCHAR2(256) ,
    REF_DOCUMENT_NUMBER          VARCHAR2(256) ,
    REF_FD_DOCUMENT_TYPE         VARCHAR2(120) ,
    REF_SERIES                   VARCHAR2(256) ,
    REF_ISSUE_DATE               VARCHAR2(16)  ,
    REF_MODEL                    VARCHAR2(256) ,
    REF_ISSUER_TAXPAYER_ID       VARCHAR2(256) ,
    REF_ISSUER_ID                NUMBER(18, 0) ,
    REF_ISSUER_STATE             VARCHAR2(8)   ,
    VALIDATION_STATUS            VARCHAR2(40)  ,
    EXTERNAL_SYSTEM_REFERENCE    VARCHAR2(960) ,
    EXTERNAL_SYSTEM_REF_ID       VARCHAR2(120) ,
    REQUEST_ID                   NUMBER(18, 0) ,
    JOB_DEFINITION_NAME          VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE       VARCHAR2(3600),
    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) ,
    REF_FD_ISSUE_DATE            DATE          ,
    CONSTRAINT pk_cmf_fd_references_int PRIMARY KEY (FD_REFERENCES_INT_ID, FD_REFERENCES_INT_ID)
);
