CREATE TABLE irc_cx_app_drafts (
    APP_DRAFT_ID               NUMBER(18, 0) ,
    DRAFT_SOURCE               VARCHAR2(960) ,
    LAST_ACCESSED_ON           VARCHAR2(4000),
    LEGAL_DESC_VERSION_ID      NUMBER(18, 0) ,
    SITE_NUMBER                VARCHAR2(960) ,
    OBJECT_STATUS              VARCHAR2(160)     NOT NULL,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)      NOT NULL,
    REQUISITION_NUMBER         VARCHAR2(2048)    NOT NULL,
    PHONE_NUMBER               VARCHAR2(240) ,
    EMAIL_ADDRESS              VARCHAR2(960) ,
    COUNTRY_CODE               VARCHAR2(120) ,
    AREA_CODE                  VARCHAR2(120) ,
    CONTENT                    CLOB          ,
    CANDIDATE_NUMBER           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) ,
    LAST_JOB_EXECUTION_DATE    TIMESTAMP(6)  ,
    CONTENT_LANGUAGE           VARCHAR2(120) ,
    PROPOSED_CAND_NUM          VARCHAR2(120) ,
    PREFERRED_CHANNEL          VARCHAR2(120) ,
    MODIFICATION_DATE          TIMESTAMP(6)  ,
    JOB_STATUS                 VARCHAR2(160)     NOT NULL,
    APPLY_FLOW_ID              NUMBER(18, 0) ,
    SUBMISSION_ID              NUMBER(18, 0) ,
    STEP_ACTION_USAGE_ID       NUMBER(18, 0) ,
    EXTRA_INFO1                VARCHAR2(4000),
    EXTRA_INFO2                VARCHAR2(4000),
    EXTRA_INFO3                VARCHAR2(4000),
    EXTRA_INFO4                VARCHAR2(4000),
    EXTRA_INFO5                VARCHAR2(4000),
    APP_DRAFT_ID               NUMBER(18, 0) ,
    LEGAL_DESC_VERSION_ID      NUMBER(18, 0) ,
    SITE_NUMBER                VARCHAR2(960) ,
    OBJECT_STATUS              VARCHAR2(160)     NOT NULL,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)      NOT NULL,
    REQUISITION_NUMBER         VARCHAR2(2048)    NOT NULL,
    PHONE_NUMBER               VARCHAR2(240) ,
    EMAIL_ADDRESS              VARCHAR2(960) ,
    COUNTRY_CODE               VARCHAR2(120) ,
    AREA_CODE                  VARCHAR2(120) ,
    CONTENT                    CLOB          ,
    CANDIDATE_NUMBER           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) ,
    LAST_JOB_EXECUTION_DATE    TIMESTAMP(6)  ,
    CONTENT_LANGUAGE           VARCHAR2(120) ,
    PROPOSED_CAND_NUM          VARCHAR2(120) ,
    PREFERRED_CHANNEL          VARCHAR2(120) ,
    MODIFICATION_DATE          TIMESTAMP(6)  ,
    JOB_STATUS                 VARCHAR2(160)     NOT NULL,
    APPLY_FLOW_ID              NUMBER(18, 0) ,
    SUBMISSION_ID              NUMBER(18, 0) ,
    STEP_ACTION_USAGE_ID       NUMBER(18, 0) ,
    DRAFT_SOURCE               VARCHAR2(960) ,
    LAST_ACCESSED_ON           VARCHAR2(4000),
    EXTRA_INFO1                VARCHAR2(4000),
    EXTRA_INFO2                VARCHAR2(4000),
    EXTRA_INFO3                VARCHAR2(4000),
    EXTRA_INFO4                VARCHAR2(4000),
    EXTRA_INFO5                VARCHAR2(4000),
    CONSTRAINT pk_irc_cx_app_drafts PRIMARY KEY (APP_DRAFT_ID, APP_DRAFT_ID)
);
