Histórico da Página

create table ENG_SYNC_NOTIF_ALERT (
    ID        varchar2(36)    NOT NULL,
    TIMESTAMP        date,
    APPLICATION        varchar2(500),
    RELEASES        varchar2(200),
    STATUS        varchar2(50),
    START_PERIOD        date,
    END_PERIOD        date,
    CONTENT        clob,
    CONTENT_TYPE varchar2(50),
    CONTENT_TITLE varchar2(255),
    CONTENT_MESSAGE varchar2(1000),
    CONTENT_URL varchar2(255),
    CONSTRAINT ENG_SYNC_NOTIF_ALERT_PK PRIMARY KEY (ID));

create table ENG_USER_NOTIF_ALERT (
    ID        varchar2(36)    NOT NULL,
    USER_IDENTIFIER        varchar2(10)    NOT NULL,
    CREATED_AT        date,
    NOTIFIED_AT        date,
    VIEWED_AT        date,
    CANCELED_AT        date,
    CONSTRAINT ENG_USER_NOTIF_ALERT_PK PRIMARY KEY (ID,USER_IDENTIFIER));

alter table ENG_USER_NOTIF_ALERT add constraint ENG_USER_NOTIF_ALERT1_FK_ENG_S foreign key  (ID) references ENG_SYNC_NOTIF_ALERT;