    CONSENT_SIGN_DATE datetime,
    CONSENT_DOC_URL varchar(500),
    CONSENT_WITNESS bigint,
-   BARCODE varchar(255) unique,
+   BARCODE varchar(255),
    DATE_OFFSET integer
 );
 

   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)

   COLLECTION_POINT_LABEL varchar(255),
   STUDY_CALENDAR_EVENT_POINT double precision,
   COLLECTION_PROTOCOL_ID numeric(20),
   LABELFORMAT varchar(255) default NULL
);

create table CATISSUE_SPECIMEN_COLL_GROUP (
   IDENTIFIER numeric(20) not null identity,
   NAME varchar(255), 
   BARCODE varchar(255), 
   COMMENTS varchar(2000),
   ENCOUNTER_TIMESTAMP datetime,
   COLLECTION_PROTOCOL_REG_ID numeric(20),
