CREATE TABLE hts_shifts_b_ (
    SHIFT_ID                 NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)  ,
    ENTERPRISE_ID            NUMBER(18, 0) ,
    SHIFT_CODE               VARCHAR2(120) ,
    START_TIME_OFFSET        NUMBER(9, 0)  ,
    END_TIME_OFFSET          NUMBER(9, 0)  ,
    WORK_DURATION            NUMBER(9, 0)  ,
    BREAK_DURATION           NUMBER(9, 0)  ,
    END_PLUS_DAYS            NUMBER(9, 0)  ,
    SHIFT_CATEGORY           VARCHAR2(120) ,
    ACTIVE_FLAG              VARCHAR2(4)   ,
    CREATED_BY               VARCHAR2(256) ,
    CREATION_DATE            TIMESTAMP(6)  ,
    LAST_UPDATED_BY          VARCHAR2(256) ,
    LAST_UPDATE_DATE         TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    AUDIT_ACTION_TYPE_       VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_    VARCHAR2(4000),
    AUDIT_IMPERSONATOR_      VARCHAR2(256) ,
    SHIFT_ID                 NUMBER(18, 0) ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)  ,
    ENTERPRISE_ID            NUMBER(18, 0) ,
    SHIFT_CODE               VARCHAR2(120) ,
    START_TIME_OFFSET        NUMBER(9, 0)  ,
    END_TIME_OFFSET          NUMBER(9, 0)  ,
    WORK_DURATION            NUMBER(9, 0)  ,
    BREAK_DURATION           NUMBER(9, 0)  ,
    END_PLUS_DAYS            NUMBER(9, 0)  ,
    SHIFT_CATEGORY           VARCHAR2(120) ,
    ACTIVE_FLAG              VARCHAR2(4)   ,
    CREATED_BY               VARCHAR2(256) ,
    CREATION_DATE            TIMESTAMP(6)  ,
    LAST_UPDATED_BY          VARCHAR2(256) ,
    LAST_UPDATE_DATE         TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN        VARCHAR2(128) ,
    AUDIT_ACTION_TYPE_       VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_    VARCHAR2(4000),
    AUDIT_IMPERSONATOR_      VARCHAR2(256) ,
    CONSTRAINT pk_hts_shifts_b_ PRIMARY KEY (SHIFT_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, SHIFT_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE)
);
