CREATE TABLE atc_relative_effectivities (
    REL_EFFECTIVITY_ID       NUMBER(18, 0)    NOT NULL,
    START_REL_EVENT          VARCHAR2(800),
    START_REL_OFFSET_UNIT    VARCHAR2(800),
    START_REL_OFFSET_VAL     NUMBER       ,
    END_REL_EVENT            VARCHAR2(800),
    END_REL_OFFSET_UNIT      VARCHAR2(800),
    END_REL_OFFSET_VAL       NUMBER       ,
    ENTITY_ID                NUMBER(18, 0)    NOT NULL,
    ENTITY_TYPE              VARCHAR2(800),
    ENTITY_NAME              VARCHAR2(400)    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),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    REL_EFFECTIVITY_ID       NUMBER(18, 0)    NOT NULL,
    START_REL_EVENT          VARCHAR2(800),
    START_REL_OFFSET_UNIT    VARCHAR2(800),
    START_REL_OFFSET_VAL     NUMBER       ,
    END_REL_EVENT            VARCHAR2(800),
    END_REL_OFFSET_UNIT      VARCHAR2(800),
    END_REL_OFFSET_VAL       NUMBER       ,
    ENTITY_ID                NUMBER(18, 0)    NOT NULL,
    ENTITY_TYPE              VARCHAR2(800),
    ENTITY_NAME              VARCHAR2(400)    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),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL
);
