CREATE TABLE COI_NOTIFICATION
(
      NOTIFICATION_ID NUMBER(20)
        , NOTIFICATION_TYPE_ID NUMBER(6) NOT NULL
        , DOCUMENT_NUMBER VARCHAR2(40) NOT NULL
        , OWNING_DOCUMENT_ID_FK NUMBER(12) NOT NULL
        , RECIPIENTS VARCHAR2(1000)
        , SUBJECT VARCHAR2(1000)
        , MESSAGE VARCHAR2(4000)
        , UPDATE_USER VARCHAR2(60) NOT NULL
        , UPDATE_TIMESTAMP DATE NOT NULL
        , VER_NBR NUMBER(8) default 1 NOT NULL
        , OBJ_ID VARCHAR2(36) NOT NULL
)
/
ALTER TABLE COI_NOTIFICATION
    ADD CONSTRAINT COI_NOTIFICATIONP1
PRIMARY KEY (NOTIFICATION_ID)
/

Store sent notifications for tracking purposes
KRACOEUS-6002: Store sent notifications for tracking purposes
