    COMMENTS text,
    primary key (IDENTIFIER)
 );
+create table CATISSUE_SPECIMEN_ARRAY (
+   IDENTIFIER bigint not null,
+   CREATED_BY_ID bigint,
+   SPECIMEN_ARRAY_TYPE_ID bigint,
+   STORAGE_CONTAINER_ID bigint,
+   DISTRIBUTION_ID bigint,
+   primary key (IDENTIFIER)
+);
+create table CATISSUE_SPECIMEN_ARRAY_TYPE (
+   IDENTIFIER bigint not null,
+   SPECIMEN_CLASS varchar(50),
+   primary key (IDENTIFIER)
+);
 create table CATISSUE_DISTRIBUTED_ITEM (
    IDENTIFIER bigint not null auto_increment,
    QUANTITY double precision,

   NAME varchar(50) not null unique,
   primary key (IDENTIFIER)
);
create table CATISSUE_AUDIT_EVENT (
   IDENTIFIER bigint not null auto_increment,
   IP_ADDRESS varchar(20),
   EVENT_TIMESTAMP datetime,
   USER_ID bigint,
   COMMENTS text,
   primary key (IDENTIFIER)
);
create table CATISSUE_STORAGE_CONT_CAPACITY (
   IDENTIFIER bigint not null auto_increment,
   ONE_DIMENSION_CAPACITY integer,
   TWO_DIMENSION_CAPACITY integer,
   primary key (IDENTIFIER)
);
create table CATISSUE_FLUID_SPE_EVENT_PARAM (
   IDENTIFIER bigint not null,
   CELL_COUNT double precision,
   primary key (IDENTIFIER)
);
create table CATISSUE_SPECIMEN_PROTOCOL (
   IDENTIFIER bigint not null auto_increment,
   PRINCIPAL_INVESTIGATOR_ID bigint,
   TITLE varchar(50) not null unique,
   SHORT_TITLE varchar(50),
   IRB_IDENTIFIER varchar(50),
   START_DATE date,

drop table if exists CATISSUE_SPECIMEN;
drop table if exists CATISSUE_USER;
drop table if exists CATISSUE_TIS_SPE_EVENT_PARAM;
drop table if exists CATISSUE_STORAGE_CONT_COLL_PROT_REL;
drop table if exists CATISSUE_SPECIMEN_COLL_GROUP;
drop table if exists CATISSUE_SPECIMEN_TYPE;
create table CATISSUE_PERMISSIBLE_VALUE (
   IDENTIFIER bigint not null auto_increment,
   CONCEPT_CODE varchar(40),
