CREATE TABLE hts_schedule_shifts (
    SCHEDULE_SHIFT_ID                 NUMBER(18, 0) ,
    SCHEDULE_ID                       NUMBER(18, 0)     NOT NULL,
    SCHEDULE_UNIT_ID                  NUMBER(18, 0)     NOT NULL,
    APPROVAL_REQ_TO_CLAIM_FLAG        VARCHAR2(4)   ,
    SKILL_ID                          NUMBER(18, 0)     NOT NULL,
    PERSON_ID                         NUMBER(18, 0)     NOT NULL,
    ASSIGNMENT_ID                     NUMBER(18, 0)     NOT NULL,
    SHIFT_TYPE                        VARCHAR2(120) ,
    SHIFT_TYPE_ID                     NUMBER(18, 0) ,
    SHIFT_ID                          NUMBER(18, 0) ,
    START_DATE_TIME                   TIMESTAMP(6)      NOT NULL,
    END_DATE_TIME                     TIMESTAMP(6)      NOT NULL,
    START_TIME_TZ_OFFSET              NUMBER(3, 0)  ,
    END_TIME_TZ_OFFSET                NUMBER(3, 0)  ,
    REF_DATE                          DATE              NOT NULL,
    WORK_DURATION                     NUMBER(9, 0)  ,
    BREAK_DURATION                    NUMBER(9, 0)  ,
    SOURCE                            VARCHAR2(120) ,
    LOCKED_FLAG                       VARCHAR2(4)   ,
    ASSIGNMENT_MODE                   VARCHAR2(120) ,
    SHIFT_CATEGORY                    VARCHAR2(120) ,
    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,
    ENTERPRISE_ID                     NUMBER(18, 0)     NOT NULL,
    COMMENTS                          VARCHAR2(4000),
    ASSIGNED_BY                       NUMBER(18, 0) ,
    ASSIGNMENT_DATE                   TIMESTAMP(6)  ,
    PREMIUM_SHIFT_CODE                VARCHAR2(120) ,
    OPPORTUNITY_TYPE                  VARCHAR2(120) ,
    AVAIL_TO_OTHER_DEPT_FLAG          VARCHAR2(4)   ,
    SHIFT_GROUP_ID                    NUMBER(18, 0) ,
    SHIFT_INCENTIVE                   NUMBER(9, 3)  ,
    ALLOW_OVERTIME_FLAG               VARCHAR2(4)   ,
    PAID_BREAK_DURATION               NUMBER(9, 0)  ,
    MANUAL_PAID_BREAK_DURATION        NUMBER(9, 0)  ,
    EXTERNAL_SYSTEM_REFERENCE         VARCHAR2(480) ,
    ORIGINAL_SOURCE                   VARCHAR2(240) ,
    IMPORT_PROVIDER                   VARCHAR2(120) ,
    ALLOW_CLAIM_PARTIAL_SHIFT_FLAG    VARCHAR2(4)   ,
    OPPORTUNITY_ROTATION_FLAG         VARCHAR2(4)   ,
    MOCK_DISCRIMINATOR                VARCHAR2(4)   ,
    ATTRIBUTE_CATEGORY                VARCHAR2(320) ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1                 NUMBER        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_DATE1                   DATE          ,
    ATTRIBUTE_DATE2                   DATE          ,
    ATTRIBUTE_DATE3                   DATE          ,
    ATTRIBUTE_DATE4                   DATE          ,
    ATTRIBUTE_DATE5                   DATE          ,
    SCHEDULE_SHIFT_ID                 NUMBER(18, 0) ,
    SCHEDULE_ID                       NUMBER(18, 0)     NOT NULL,
    SCHEDULE_UNIT_ID                  NUMBER(18, 0)     NOT NULL,
    SKILL_ID                          NUMBER(18, 0)     NOT NULL,
    PERSON_ID                         NUMBER(18, 0)     NOT NULL,
    ASSIGNMENT_ID                     NUMBER(18, 0)     NOT NULL,
    SHIFT_ID                          NUMBER(18, 0) ,
    START_DATE_TIME                   TIMESTAMP(6)      NOT NULL,
    END_DATE_TIME                     TIMESTAMP(6)      NOT NULL,
    START_TIME_TZ_OFFSET              NUMBER(3, 0)  ,
    END_TIME_TZ_OFFSET                NUMBER(3, 0)  ,
    REF_DATE                          DATE              NOT NULL,
    WORK_DURATION                     NUMBER(9, 0)  ,
    BREAK_DURATION                    NUMBER(9, 0)  ,
    SOURCE                            VARCHAR2(120) ,
    LOCKED_FLAG                       VARCHAR2(4)   ,
    ASSIGNMENT_MODE                   VARCHAR2(120) ,
    SHIFT_CATEGORY                    VARCHAR2(120) ,
    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,
    ENTERPRISE_ID                     NUMBER(18, 0)     NOT NULL,
    COMMENTS                          VARCHAR2(4000),
    SHIFT_TYPE                        VARCHAR2(120) ,
    SHIFT_TYPE_ID                     NUMBER(18, 0) ,
    APPROVAL_REQ_TO_CLAIM_FLAG        VARCHAR2(4)   ,
    ASSIGNED_BY                       NUMBER(18, 0) ,
    ASSIGNMENT_DATE                   TIMESTAMP(6)  ,
    PREMIUM_SHIFT_CODE                VARCHAR2(120) ,
    OPPORTUNITY_TYPE                  VARCHAR2(120) ,
    AVAIL_TO_OTHER_DEPT_FLAG          VARCHAR2(4)   ,
    SHIFT_GROUP_ID                    NUMBER(18, 0) ,
    SHIFT_INCENTIVE                   NUMBER(9, 3)  ,
    ALLOW_OVERTIME_FLAG               VARCHAR2(4)   ,
    PAID_BREAK_DURATION               NUMBER(9, 0)  ,
    MANUAL_PAID_BREAK_DURATION        NUMBER(9, 0)  ,
    EXTERNAL_SYSTEM_REFERENCE         VARCHAR2(480) ,
    ORIGINAL_SOURCE                   VARCHAR2(240) ,
    IMPORT_PROVIDER                   VARCHAR2(120) ,
    ALLOW_CLAIM_PARTIAL_SHIFT_FLAG    VARCHAR2(4)   ,
    OPPORTUNITY_ROTATION_FLAG         VARCHAR2(4)   ,
    MOCK_DISCRIMINATOR                VARCHAR2(4)   ,
    ATTRIBUTE_CATEGORY                VARCHAR2(320) ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE_NUMBER1                 NUMBER        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_DATE1                   DATE          ,
    ATTRIBUTE_DATE2                   DATE          ,
    ATTRIBUTE_DATE3                   DATE          ,
    ATTRIBUTE_DATE4                   DATE          ,
    ATTRIBUTE_DATE5                   DATE          ,
    CONSTRAINT pk_hts_schedule_shifts PRIMARY KEY (SCHEDULE_SHIFT_ID, SCHEDULE_SHIFT_ID)
);
