CREATE TABLE ffs_activity_tmpl_log (
    LOG_ID                   NUMBER(19, 0) ,
    ACTION_ID                NUMBER(19, 0) ,
    TEMPLATE_ID              NUMBER(8, 0)      NOT NULL,
    USER_ID                  NUMBER(18, 0) ,
    CREATED                  TIMESTAMP(0)  ,
    PARENT_TEMPLATE_ID       NUMBER(8, 0)  ,
    MASTER_TEMPLATE_ID       NUMBER(8, 0)      NOT NULL,
    TEAM_RESOURCE_ID         NUMBER(8, 0)  ,
    SHIFT_ID                 NUMBER(8, 0)  ,
    TYPE_ID                  NUMBER(5, 0)  ,
    WORK_ZONE_ID             NUMBER(8, 0)  ,
    DURATION                 NUMBER(5, 0)  ,
    TIME_SLOT_ID             NUMBER(5, 0)  ,
    SERVICE_WINDOW_START     NUMBER(5, 0)  ,
    SERVICE_WINDOW_END       NUMBER(5, 0)  ,
    ACTIVITY_NUMBER          VARCHAR2(640) ,
    CUSTOMER_NUMBER          VARCHAR2(640) ,
    CUSTOMER_NAME            VARCHAR2(4000),
    LOCATION_ID              NUMBER(10, 0) ,
    STREET_ADDRESS           VARCHAR2(3840),
    CITY                     VARCHAR2(960) ,
    POSTAL_CODE              VARCHAR2(960) ,
    STATE_PROVINCE           VARCHAR2(960) ,
    CUSTOMER_PHONE           VARCHAR2(3840),
    CUSTOMER_EMAIL           VARCHAR2(4000),
    CUSTOMER_CELL            VARCHAR2(3840),
    LANGUAGE_ID              NUMBER(3, 0)      NOT NULL,
    REMINDER_TIME            NUMBER(5, 0)  ,
    TIME_ZONE_ID             NUMBER(3, 0)  ,
    TRAVEL_AREA_ID           NUMBER(8, 0)  ,
    TRAVEL_KEY               VARCHAR2(800) ,
    DURATION_KEY             VARCHAR2(800) ,
    COORD_STATUS             VARCHAR2(36)  ,
    COORD_ACCURACY           NUMBER(3, 0)      NOT NULL,
    COORD_X                  NUMBER(8, 5)  ,
    COORD_Y                  NUMBER(8, 5)  ,
    OPTIONS                  NUMBER(5, 0)  ,
    START_DATE               DATE          ,
    END_DATE                 DATE          ,
    RECURRENCE               VARCHAR2(24)  ,
    WEEKDAYS                 NUMBER(3, 0)  ,
    RECUR_EVERY              NUMBER(3, 0)  ,
    SLA_START                TIMESTAMP(0)  ,
    SLA_END                  TIMESTAMP(0)  ,
    FEATURES                 NUMBER(10, 0) ,
    POINTS                   NUMBER(5, 0)  ,
    TIME_OF_BOOKING          TIMESTAMP(0)  ,
    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) ,
    COORD_VIEWPORT_RADIUS    NUMBER(6, 0)  ,
    LOG_ID                   NUMBER(19, 0) ,
    ACTION_ID                NUMBER(19, 0) ,
    TEMPLATE_ID              NUMBER(8, 0)      NOT NULL,
    USER_ID                  NUMBER(18, 0) ,
    CREATED                  TIMESTAMP(0)  ,
    PARENT_TEMPLATE_ID       NUMBER(8, 0)  ,
    MASTER_TEMPLATE_ID       NUMBER(8, 0)      NOT NULL,
    TEAM_RESOURCE_ID         NUMBER(8, 0)  ,
    SHIFT_ID                 NUMBER(8, 0)  ,
    TYPE_ID                  NUMBER(5, 0)  ,
    WORK_ZONE_ID             NUMBER(8, 0)  ,
    DURATION                 NUMBER(5, 0)  ,
    TIME_SLOT_ID             NUMBER(5, 0)  ,
    SERVICE_WINDOW_START     NUMBER(5, 0)  ,
    SERVICE_WINDOW_END       NUMBER(5, 0)  ,
    ACTIVITY_NUMBER          VARCHAR2(640) ,
    CUSTOMER_NUMBER          VARCHAR2(640) ,
    CUSTOMER_NAME            VARCHAR2(4000),
    LOCATION_ID              NUMBER(10, 0) ,
    STREET_ADDRESS           VARCHAR2(3840),
    CITY                     VARCHAR2(960) ,
    POSTAL_CODE              VARCHAR2(960) ,
    STATE_PROVINCE           VARCHAR2(960) ,
    CUSTOMER_PHONE           VARCHAR2(3840),
    CUSTOMER_EMAIL           VARCHAR2(4000),
    CUSTOMER_CELL            VARCHAR2(3840),
    LANGUAGE_ID              NUMBER(3, 0)      NOT NULL,
    REMINDER_TIME            NUMBER(5, 0)  ,
    TIME_ZONE_ID             NUMBER(3, 0)  ,
    TRAVEL_AREA_ID           NUMBER(8, 0)  ,
    TRAVEL_KEY               VARCHAR2(800) ,
    DURATION_KEY             VARCHAR2(800) ,
    COORD_STATUS             VARCHAR2(36)  ,
    COORD_ACCURACY           NUMBER(3, 0)      NOT NULL,
    COORD_X                  NUMBER(8, 5)  ,
    COORD_Y                  NUMBER(8, 5)  ,
    OPTIONS                  NUMBER(5, 0)  ,
    START_DATE               DATE          ,
    END_DATE                 DATE          ,
    RECURRENCE               VARCHAR2(24)  ,
    WEEKDAYS                 NUMBER(3, 0)  ,
    RECUR_EVERY              NUMBER(3, 0)  ,
    SLA_START                TIMESTAMP(0)  ,
    SLA_END                  TIMESTAMP(0)  ,
    FEATURES                 NUMBER(10, 0) ,
    POINTS                   NUMBER(5, 0)  ,
    TIME_OF_BOOKING          TIMESTAMP(0)  ,
    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) ,
    COORD_VIEWPORT_RADIUS    NUMBER(6, 0)  ,
    CONSTRAINT pk_ffs_activity_tmpl_log PRIMARY KEY (LOG_ID, LOG_ID)
);
