CREATE TABLE atc_prodspec_char_values_ (
    CHAR_VALUE_ID                   NUMBER(18, 0) ,
    DEFAULT_FLAG                    VARCHAR2(4)   ,
    RANGE_INTERVAL                  VARCHAR2(800) ,
    REGEX                           VARCHAR2(800) ,
    VALUE_FROM                      VARCHAR2(800) ,
    VALUE_TO                        VARCHAR2(800) ,
    VALUE_TYPE_CODE                 VARCHAR2(800) ,
    VALUE                           VARCHAR2(4000),
    PROD_SPEC_CHAR_VALUE            CLOB          ,
    VALUE_RESTRICTION_FLAG          VARCHAR2(4)   ,
    PARENT_CHAR_NAME                VARCHAR2(800) ,
    UNIT_OF_MEASURE                 VARCHAR2(800) ,
    VALUE_CODE                      VARCHAR2(800) ,
    SPEC_CHAR_VALUE_RELATIONSHIP    CLOB          ,
    AT_TYPE                         VARCHAR2(800) ,
    AT_BASE_TYPE                    VARCHAR2(800) ,
    AT_SCHEMA_LOCATION              VARCHAR2(4000),
    START_DATE_TIME                 TIMESTAMP(6)  ,
    END_DATE_TIME                   TIMESTAMP(6)  ,
    ENTITY_NAME                     VARCHAR2(400) ,
    ENTITY_ID                       NUMBER(18, 0) ,
    CREATED_BY                      VARCHAR2(256) ,
    CREATION_DATE                   TIMESTAMP(6)  ,
    LAST_UPDATED_BY                 VARCHAR2(256) ,
    LAST_UPDATE_DATE                TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)  ,
    CHAR_VALUE_SEQ                  NUMBER(18, 0) ,
    AUDIT_ACTION_TYPE_              VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_           VARCHAR2(4000),
    AUDIT_IMPERSONATOR_             VARCHAR2(256) ,
    CHAR_VALUE_ID                   NUMBER(18, 0) ,
    DEFAULT_FLAG                    VARCHAR2(4)   ,
    RANGE_INTERVAL                  VARCHAR2(800) ,
    REGEX                           VARCHAR2(800) ,
    VALUE_FROM                      VARCHAR2(800) ,
    VALUE_TO                        VARCHAR2(800) ,
    VALUE_TYPE_CODE                 VARCHAR2(800) ,
    VALUE                           VARCHAR2(4000),
    PROD_SPEC_CHAR_VALUE            CLOB          ,
    VALUE_RESTRICTION_FLAG          VARCHAR2(4)   ,
    PARENT_CHAR_NAME                VARCHAR2(800) ,
    UNIT_OF_MEASURE                 VARCHAR2(800) ,
    VALUE_CODE                      VARCHAR2(800) ,
    SPEC_CHAR_VALUE_RELATIONSHIP    CLOB          ,
    AT_TYPE                         VARCHAR2(800) ,
    AT_BASE_TYPE                    VARCHAR2(800) ,
    AT_SCHEMA_LOCATION              VARCHAR2(4000),
    START_DATE_TIME                 TIMESTAMP(6)  ,
    END_DATE_TIME                   TIMESTAMP(6)  ,
    ENTITY_NAME                     VARCHAR2(400) ,
    ENTITY_ID                       NUMBER(18, 0) ,
    CREATED_BY                      VARCHAR2(256) ,
    CREATION_DATE                   TIMESTAMP(6)  ,
    LAST_UPDATED_BY                 VARCHAR2(256) ,
    LAST_UPDATE_DATE                TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN               VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER           NUMBER(9, 0)  ,
    CHAR_VALUE_SEQ                  NUMBER(18, 0) ,
    AUDIT_ACTION_TYPE_              VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_           VARCHAR2(4000),
    AUDIT_IMPERSONATOR_             VARCHAR2(256) ,
    CONSTRAINT pk_atc_prodspec_char_values_ PRIMARY KEY (CHAR_VALUE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, CHAR_VALUE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE)
);
