CREATE TABLE irc_is_interviews (
    SCHEDULE_INTERVIEW_ID            NUMBER(18, 0) ,
    MEETING_HOST_TYPE                VARCHAR2(960) ,
    INTERVIEW_MEETING_PROVIDER       VARCHAR2(256) ,
    SCHEDULE_ID                      NUMBER(18, 0) ,
    INTERVIEW_NOTES                  CLOB          ,
    INTERVIEW_GUIDELINES             CLOB          ,
    IS_SCHEDULED                     VARCHAR2(4)   ,
    START_DATE                       TIMESTAMP(6)  ,
    END_DATE                         TIMESTAMP(6)  ,
    SCHEDULE_LOCATION_ID             NUMBER(18, 0) ,
    LAST_REMINDER_DATE               TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 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) ,
    OFFICE365_USER_ID                VARCHAR2(1024),
    OFFICE365_CALENDAR_ID            VARCHAR2(1024),
    OFFICE365_CALENDAR_EVENT_ID      VARCHAR2(1024),
    OFFICE365_CAL_EV_IMMUTABLE_ID    VARCHAR2(1024),
    OFFICE365_LAST_UPDATE_DATE       TIMESTAMP(6)  ,
    OFFICE365_LAST_SYNC_TIME         TIMESTAMP(6)  ,
    ESS_REQUEST_ID                   NUMBER(18, 0) ,
    TOTAL_SEATS_COUNT                NUMBER(9, 0)  ,
    IS_COMPLETED                     VARCHAR2(4)   ,
    MEETING_LINK_URL                 VARCHAR2(2000),
    MEETING_HTTP_CONTENT             CLOB          ,
    ZOOM_MEETING_ID                  NUMBER(18, 0) ,
    GOOGLE_USER_ID                   VARCHAR2(1024),
    GOOGLE_CALENDAR_ID               VARCHAR2(1024),
    GOOGLE_CALENDAR_EVENT_ID         VARCHAR2(1024),
    GOOGLE_LAST_UPDATE_DATE          TIMESTAMP(6)  ,
    GOOGLE_LAST_SYNC_DATE            TIMESTAMP(6)  ,
    SCHEDULE_INTERVIEW_ID            NUMBER(18, 0) ,
    SUBMISSION_ID                    NUMBER(18, 0) ,
    SCHEDULE_ID                      NUMBER(18, 0) ,
    IS_SCHEDULED                     VARCHAR2(4)   ,
    START_DATE                       TIMESTAMP(6)  ,
    END_DATE                         TIMESTAMP(6)  ,
    SCHEDULE_LOCATION_ID             NUMBER(18, 0) ,
    LAST_REMINDER_DATE               TIMESTAMP(6)  ,
    OBJECT_VERSION_NUMBER            NUMBER(9, 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) ,
    INTERVIEW_NOTES                  CLOB          ,
    OFFICE365_USER_ID                VARCHAR2(1024),
    OFFICE365_CALENDAR_ID            VARCHAR2(1024),
    OFFICE365_CALENDAR_EVENT_ID      VARCHAR2(1024),
    TOTAL_SEATS_COUNT                NUMBER(9, 0)  ,
    IS_COMPLETED                     VARCHAR2(4)   ,
    INTERVIEW_MEETING_PROVIDER       VARCHAR2(256) ,
    MEETING_LINK_URL                 VARCHAR2(2000),
    MEETING_HTTP_CONTENT             CLOB          ,
    OFFICE365_CAL_EV_IMMUTABLE_ID    VARCHAR2(1024),
    OFFICE365_LAST_UPDATE_DATE       TIMESTAMP(6)  ,
    OFFICE365_LAST_SYNC_TIME         TIMESTAMP(6)  ,
    ESS_REQUEST_ID                   NUMBER(18, 0) ,
    ZOOM_MEETING_ID                  NUMBER(18, 0) ,
    MEETING_HOST_TYPE                VARCHAR2(960) ,
    GOOGLE_USER_ID                   VARCHAR2(1024),
    GOOGLE_CALENDAR_ID               VARCHAR2(1024),
    GOOGLE_CALENDAR_EVENT_ID         VARCHAR2(1024),
    GOOGLE_LAST_UPDATE_DATE          TIMESTAMP(6)  ,
    GOOGLE_LAST_SYNC_DATE            TIMESTAMP(6)  ,
    INTERVIEW_GUIDELINES             CLOB          ,
    CONSTRAINT pk_irc_is_interviews PRIMARY KEY (SCHEDULE_INTERVIEW_ID, SCHEDULE_INTERVIEW_ID)
);
