    REASON varchar(50) not null,
    primary key (IDENTIFIER)
 );
-create table CATISSUE_CDE (
-   PUBLIC_ID varchar(30) not null,
-   LONG_NAME varchar(200),
-   DEFINITION text,
-   VERSION varchar(50),
-   LAST_UPDATED date,
-   primary key (PUBLIC_ID)
-);
 create table CATISSUE_SPECIMEN_REQUIREMENT (
    IDENTIFIER bigint not null auto_increment,
    SPECIMEN_CLASS varchar(255) not null,
    SPECIMEN_TYPE varchar(50),
    TISSUE_SITE varchar(150),
    PATHOLOGY_STATUS varchar(50),
+   QUANTITY_ID bigint,
    QUANTITY double precision,
    primary key (IDENTIFIER)
 );

   COMMENTS text,
   primary key (IDENTIFIER)
);
create table CATISSUE_DISTRIBUTED_ITEM (
   IDENTIFIER bigint not null auto_increment,
   QUANTITY double precision,

   IDENTIFIER bigint not null,
   RECEIVED_QUALITY varchar(255),
   primary key (IDENTIFIER)
);
create table CATISSUE_RACE (
   PARTICIPANT_ID bigint not null,
   RACE_NAME varchar(50)
);
create table CATISSUE_CLINICAL_REPORT (
   IDENTIFIER bigint not null auto_increment,
