CREATE TABLE hwm_ds_scripts_f (
    SCRIPT_ID                NUMBER(18, 0) ,
    EFFECTIVE_START_DATE     DATE          ,
    EFFECTIVE_END_DATE       DATE          ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    DS_CLASS_ID              NUMBER(18, 0)     NOT NULL,
    SCRIPT_UNQ_ID            NUMBER(18, 0)     NOT NULL,
    SCRIPT_LANGUAGE          VARCHAR2(120)     NOT NULL,
    SCRIPT_NAME              VARCHAR2(320)     NOT NULL,
    SCRIPT_STATUS            VARCHAR2(40)  ,
    DESCRIPTION              VARCHAR2(4000),
    SCRIPT_TEXT              CLOB          ,
    ENTERPRISE_ID            NUMBER(18, 0)     NOT NULL,
    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) ,
    MODULE_ID                VARCHAR2(128) ,
    SCRIPT_ID                NUMBER(18, 0) ,
    EFFECTIVE_START_DATE     DATE          ,
    EFFECTIVE_END_DATE       DATE          ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)      NOT NULL,
    DS_CLASS_ID              NUMBER(18, 0)     NOT NULL,
    SCRIPT_UNQ_ID            NUMBER(18, 0)     NOT NULL,
    SCRIPT_LANGUAGE          VARCHAR2(120)     NOT NULL,
    SCRIPT_NAME              VARCHAR2(320)     NOT NULL,
    SCRIPT_STATUS            VARCHAR2(40)  ,
    DESCRIPTION              VARCHAR2(4000),
    SCRIPT_TEXT              CLOB          ,
    ENTERPRISE_ID            NUMBER(18, 0)     NOT NULL,
    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) ,
    MODULE_ID                VARCHAR2(128) ,
    CONSTRAINT pk_hwm_ds_scripts_f PRIMARY KEY (SCRIPT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, SCRIPT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE)
);
