 create table CATISSUE_DISTRIBUTION (
    IDENTIFIER number(19,0) not null,
    TO_SITE_ID number(19,0),
-   FROM_SITE_ID number(19,0),
    DISTRIBUTION_PROTOCOL_ID number(19,0),
    ACTIVITY_STATUS varchar2(50),
+   SPECIMEN_ID number(19,0),
+   EVENT_TIMESTAMP date,
+   USER_ID number(19,0),
+   COMMENTS varchar2(500),
    primary key (IDENTIFIER)
 );
 create table CATISSUE_AUDIT_EVENT_DETAILS (

alter table CATISSUE_STORAGE_CONTAINER drop constraint FK28429D0159A3CE5C;
alter table CATISSUE_STORAGE_CONTAINER drop constraint FK28429D01DB097B2E;
alter table CATISSUE_CELL_SPE_REVIEW_PARAM drop constraint FK52F40EDEBC7298A9;
alter table CATISSUE_DISTRIBUTION drop constraint FK542766806B1F36E7;
alter table CATISSUE_DISTRIBUTION drop constraint FK542766801DBE834F;
alter table CATISSUE_DISTRIBUTION drop constraint FK54276680BC7298A9;
alter table CATISSUE_DISTRIBUTION drop constraint FK54276680FB9AE97E;
alter table CATISSUE_AUDIT_EVENT_DETAILS drop constraint FK5C07745D34FFD77F;
alter table CATISSUE_PROCEDURE_EVENT_PARAM drop constraint FKEC6B4260BC7298A9;
alter table CATISSUE_DISTRIBUTION_PROTOCOL drop constraint FKC8999977BC7298A9;

alter table CATISSUE_STORAGE_CONTAINER add constraint FK28429D0159A3CE5C foreign key (STORAGE_TYPE_ID) references CATISSUE_STORAGE_TYPE;
alter table CATISSUE_STORAGE_CONTAINER add constraint FK28429D01DB097B2E foreign key (PARENT_CONTAINER_ID) references CATISSUE_STORAGE_CONTAINER;
alter table CATISSUE_CELL_SPE_REVIEW_PARAM add constraint FK52F40EDEBC7298A9 foreign key (IDENTIFIER) references CATISSUE_EVENT_PARAM;
alter table CATISSUE_DISTRIBUTION add constraint FK542766802206F20F foreign key (USER_ID) references CATISSUE_USER;
alter table CATISSUE_DISTRIBUTION add constraint FK542766806B1F36E7 foreign key (DISTRIBUTION_PROTOCOL_ID) references CATISSUE_DISTRIBUTION_PROTOCOL;
alter table CATISSUE_DISTRIBUTION add constraint FK542766801DBE834F foreign key (TO_SITE_ID) references CATISSUE_SITE;
alter table CATISSUE_DISTRIBUTION add constraint FK5427668060773DB2 foreign key (SPECIMEN_ID) references CATISSUE_SPECIMEN;
alter table CATISSUE_AUDIT_EVENT_DETAILS add constraint FK5C07745D34FFD77F foreign key (AUDIT_EVENT_LOG_ID) references CATISSUE_AUDIT_EVENT_LOG;
alter table CATISSUE_PROCEDURE_EVENT_PARAM add constraint FKEC6B4260BC7298A9 foreign key (IDENTIFIER) references CATISSUE_SPECIMEN_EVENT_PARAM;
alter table CATISSUE_DISTRIBUTION_PROTOCOL add constraint FKC8999977BC7298A9 foreign key (IDENTIFIER) references CATISSUE_SPECIMEN_PROTOCOL;
