CREATE TABLE iby_val_assignments (
    VALIDATION_ASSIGNMENT_ID      NUMBER(18, 0) ,
    FIELD_NAME_CODE               VARCHAR2(120) ,
    VALIDATION_SET_CODE           VARCHAR2(120)     NOT NULL,
    VAL_ASSIGNMENT_ENTITY_TYPE    VARCHAR2(120)     NOT NULL,
    ASSIGNMENT_ENTITY_ID          VARCHAR2(120)     NOT NULL,
    INACTIVE_DATE                 DATE          ,
    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) ,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)      NOT NULL,
    TERRITORY_CODE                VARCHAR2(8)   ,
    PAYMENT_METHOD_CODE           VARCHAR2(120) ,
    START_DATE                    DATE              NOT NULL,
    END_DATE                      DATE              NOT NULL,
    SEED_DATA_SOURCE              VARCHAR2(2048),
    ORA_SEED_SET1                 VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                 VARCHAR2(4)       NOT NULL,
    VALIDATION_ASSIGNMENT_ID      NUMBER(18, 0) ,
    FIELD_NAME_CODE               VARCHAR2(120) ,
    VALIDATION_SET_CODE           VARCHAR2(120)     NOT NULL,
    VAL_ASSIGNMENT_ENTITY_TYPE    VARCHAR2(120)     NOT NULL,
    ASSIGNMENT_ENTITY_ID          VARCHAR2(120)     NOT NULL,
    INACTIVE_DATE                 DATE          ,
    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) ,
    OBJECT_VERSION_NUMBER         NUMBER(9, 0)      NOT NULL,
    TERRITORY_CODE                VARCHAR2(8)   ,
    PAYMENT_METHOD_CODE           VARCHAR2(120) ,
    START_DATE                    DATE              NOT NULL,
    END_DATE                      DATE              NOT NULL,
    SEED_DATA_SOURCE              VARCHAR2(2048),
    ORA_SEED_SET1                 VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                 VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_iby_val_assignments PRIMARY KEY (VALIDATION_ASSIGNMENT_ID, VALIDATION_ASSIGNMENT_ID)
);
