 create table CATISSUE_CONTAINER_TYPE (
    IDENTIFIER bigint not null identity,
    CAPACITY_ID bigint,
-   NAME varchar(255) unique,
+   NAME varchar(255),
    ONE_DIMENSION_LABEL varchar(255),
    TWO_DIMENSION_LABEL varchar(255),
    COMMENTS varchar(500),

   GENDER varchar(20),
   GENOTYPE varchar(50),
   ETHNICITY varchar(50),
   SOCIAL_SECURITY_NUMBER varchar(50) unique,
   ACTIVITY_STATUS varchar(50),
   DEATH_DATE smalldatetime,
   VITAL_STATUS varchar(50)

CREATE TABLE CATISSUE_SPECIMEN
(                                                                                                                 
     IDENTIFIER numeric(20) NOT NULL identity,
     LABEL varchar(255),                                                                                                               
     AVAILABLE numeric(1,0),                                                                                                         
     BARCODE varchar(255),
     COMMENTS varchar(500),
     ACTIVITY_STATUS varchar(50),                                                                                              
     SPECIMEN_COLLECTION_GROUP_ID numeric(20),     
