create table ACK_TB (
   OID bigint generated by default as identity,
   REASON varchar(500),
   PROJECT varchar(100),
   ORDERING smallint not null,
   FK_PERSON bigint,
   FK_SUBMISSION bigint not null,
   primary key (OID)
)
create table ANNOTATION_IMAGE_DTB (
   OID bigint generated by default as identity,
   PURPOSE varchar(50) not null,
   FORMAT varchar(100),
   FILENAME varchar(250) not null,
   STRENGTH varchar(100) not null,
   X_LOW smallint not null,
   X_HIGH smallint not null,
   Y_LOW smallint not null,
   Y_HIGH smallint not null,
   Z_LOW smallint not null,
   Z_HIGH smallint not null,
   FK_SUBMISSION_ACCESSION bigint not null,
   primary key (OID)
)
create table ANNOTATION_TEXT_DTB (
   OID bigint generated by default as identity,
   PURPOSE varchar(50) not null,
   TISSUE_ACCESSION varchar(100) not null,
   STRENGTH varchar(100) not null,
   FK_SUBMISSION_ACCESSION bigint not null,
   primary key (OID)
)
create table ANTIBODY_REAGENT_TB (
   FK_WET_IHC bigint not null,
   ANTIBODY_REAGENT varchar(100) not null,
   ORDERING integer not null,
   primary key (FK_WET_IHC, ORDERING)
)
create table ANTIBODY_TB (
   OID_PROBE bigint not null,
   LABEL varchar(100),
   ANTIBODY_TYPE varchar(100),
   RAISED_IN varchar(100),
   SUPPLIER varchar(100),
   CATALOGUE_NO varchar(100),
   FK_SEQUENCE bigint,
   primary key (OID_PROBE)
)
create table CELL_LINE_TB (
   OID bigint generated by default as identity,
   NAME varchar(100),
   ACCESSION varchar(100),
   FK_NOTE bigint,
   primary key (OID)
)
create table CONTEXT_TB (
   OID bigint generated by default as identity,
   DB_NAME varchar(100),
   DB_VERSION varchar(100),
   SPECIES varchar(100) not null,
   STAGE_TYPE varchar(100) not null,
   IMAGE_ROOT varchar(250) not null,
   IMAGE_SEGMENT_ROOT varchar(250) not null,
   SUBMISSION_ACCESSION_PREFIX varchar(100) not null,
   primary key (OID)
)
create table EXPERIMENT_TB (
   OID bigint generated by default as identity,
   FIXATION_REAGENT varchar(100),
   CLEARING_METHOD varchar(100),
   EMBEDDING_REAGENT varchar(100),
   SIGNAL_DETECT_METHOD varchar(100),
   SPECIMEN_TYPE varchar(100),
   FK_SPECIMEN_NOTE bigint,
   FK_PROBE_NOTE bigint,
   FK_GENE bigint not null,
   FK_ORGANISM bigint not null,
   primary key (OID)
)
create table EXPRESSION_TEXT_TB (
   OID bigint generated by default as identity,
   TISSUE_ACCESSION varchar(100) not null,
   PATTERN varchar(100),
   STRENGTH varchar(100) not null,
   LOCATION varchar(250),
   ORDERING smallint not null,
   FK_NOTE bigint,
   FK_SUBMISSION bigint not null,
   primary key (OID)
)
create table GENE_SYNONYM_TB (
   FK_GENE bigint not null,
   SYNONYM varchar(150) not null,
   primary key (FK_GENE, SYNONYM)
)
create table GENE_TB (
   OID bigint generated by default as identity,
   NAME varchar(250),
   SYMBOL varchar(100) not null,
   ACCESSION varchar(100),
   primary key (OID)
)
create table HISTORY_TB (
   OID bigint generated by default as identity,
   HISTORY_TYPE varchar(100),
   RESOURCE varchar(100),
   ACCESSION varchar(100),
   WEB_URL varchar(250),
   ORDERING smallint not null,
   FK_SUBMISSION bigint not null,
   primary key (OID)
)
create table IMAGE_POSITION_TB (
   OID bigint generated by default as identity,
   NAME varchar(100),
   FK_IMAGE bigint not null,
   FK_SECTION_POSITION bigint not null,
   primary key (OID)
)
create table IMAGE_TB (
   OID bigint generated by default as identity,
   PURPOSE varchar(50) not null,
   WIDTH smallint,
   HEIGHT smallint,
   FORMAT varchar(100),
   NAME varchar(100),
   FILENAME varchar(250) not null,
   METHOD varchar(100),
   CATEGORY smallint,
   ORDERING smallint not null,
   FK_NOTE bigint,
   FK_SUBMISSION bigint not null,
   primary key (OID)
)
create table LINK_TB (
   OID bigint generated by default as identity,
   LINK_TYPE varchar(100),
   ACCESSION varchar(100),
   WEB_URL varchar(250),
   ORDERING smallint not null,
   FK_SUBMISSION bigint not null,
   primary key (OID)
)
create table LONG_TEXT_TB (
   OID bigint generated by default as identity,
   TEXT varchar(2000) not null unique,
   primary key (OID)
)
create table MAPPED_IMAGE_POSITION_TB (
   OID bigint generated by default as identity,
   NAME varchar(100),
   FK_SECTION_POSITION bigint not null,
   FK_MAPPED_IMAGE bigint not null,
   primary key (OID)
)
create table MAPPED_IMAGE_TB (
   OID bigint generated by default as identity,
   PURPOSE varchar(50) not null,
   FORMAT varchar(100),
   NAME varchar(100),
   FILENAME varchar(250) not null,
   PATTERN varchar(100),
   STRENGTH varchar(100) not null,
   ORDERING smallint not null,
   FK_NOTE bigint,
   FK_SUBMISSION bigint not null,
   primary key (OID)
)
create table MUTANT_TB (
   OID bigint generated by default as identity,
   GENE varchar(100) not null,
   PARENT_ONE varchar(100),
   PARENT_TWO varchar(100),
   FK_ORGANISM bigint not null,
   primary key (OID)
)
create table ORGANISM_TB (
   OID bigint generated by default as identity,
   STRAIN varchar(250),
   SPECIES varchar(100),
   NAME varchar(200),
   ACCESSION varchar(100),
   SEX varchar(50),
   STAGE_VALUE varchar(100),
   STAGING_METHOD varchar(100),
   WILD_TYPE smallint,
   primary key (OID)
)
create table ORGANIZATION_TB (
   OID bigint generated by default as identity,
   NAME varchar(100),
   TEL varchar(100),
   FAX varchar(100),
   WEB_URL varchar(250),
   ADDRESS varchar(150),
   CITY varchar(100),
   POSTCODE varchar(100),
   COUNTRY varchar(100),
   primary key (OID)
)
create table PERSON_TB (
   OID bigint generated by default as identity,
   NAME varchar(100),
   TEL varchar(100),
   EMAIL varchar(100),
   FK_ORGANIZATION bigint not null,
   primary key (OID)
)
create table PROBE_ISH_TB (
   OID_PROBE bigint not null,
   TEMPLATE_TYPE varchar(100),
   CLONE_NAME varchar(100),
   CHEMISTRY varchar(100),
   primary key (OID_PROBE)
)
create table PROBE_SEQ_MMTB (
   OID bigint generated by default as identity,
   FK_PROBE bigint not null,
   FK_SEQUENCE bigint not null,
   primary key (OID)
)
create table PROBE_TB (
   OID bigint generated by default as identity,
   NAME varchar(100),
   ORIGIN_TYPE varchar(100),
   SEQUENCE_TYPE varchar(100),
   ACCESSION varchar(100),
   FK_CELL_LINE bigint,
   FK_ORGANISM bigint,
   primary key (OID)
)
create table PUBLICATION_TB (
   OID bigint generated by default as identity,
   PAGES varchar(100),
   TITLE varchar(250),
   ACCESSION varchar(100),
   AUTHORS varchar(350),
   FK_PUBLICATION_INFO bigint not null,
   primary key (OID)
)
create table PUBLICATION_VOLUME_TB (
   OID bigint generated by default as identity,
   NAME varchar(100),
   PUBLISHER varchar(100),
   AUTHORS varchar(100),
   PUBLICATION_YEAR varchar(100),
   VOLUME varchar(100),
   ISSUE varchar(100),
   primary key (OID)
)
create table REGION_2_NODE_DTB (
   OID bigint generated by default as identity,
   TISSUE_ACCESSION varchar(100) not null,
   STRENGTH varchar(100) not null,
   FK_SUBMISSION_ACCESSION bigint not null,
   VOLUME bigint not null,
   PERCENTAGE float not null,
   primary key (OID)
)
create table REGION_TB (
   FK_PROBE bigint not null,
   REGION varchar(100) not null,
   primary key (FK_PROBE, REGION)
)
create table SECTION_POSITION_TB (
   OID bigint generated by default as identity,
   X float not null,
   Y float not null,
   Z float not null,
   THETA float not null,
   PHI float not null,
   DISTANCE float not null,
   primary key (OID)
)
create table SEQUENCE_TB (
   OID bigint generated by default as identity,
   ACCESSION varchar(100),
   START_LOC bigint,
   END_LOC bigint,
   FK_SEQUENCE_DETAIL bigint,
   primary key (OID)
)
create table SUBMISSION_COMMENT_TB (
   FK_SUBMISSION bigint not null,
   COMMENT varchar(1024) not null,
   ORDERING integer not null,
   primary key (FK_SUBMISSION, ORDERING)
)
create table SUBMISSION_SUMMARY_DTB (
   OID bigint generated by default as identity,
   ACCESSION bigint not null unique,
   STAGE varchar(100),
   GENE_SYMBOL varchar(100),
   ASSAY_QUALITY varchar(100),
   PROBE_ID varchar(100),
   USER_STAGE varchar(100),
   ASSAY_TYPE varchar(100),
   SPECIMEN_TYPE varchar(100),
   GENOTYPE varchar(100),
   primary key (OID)
)
create table SUBMISSION_TB (
   OID bigint generated by default as identity,
   ACCESSION bigint not null unique,
   CREATION_TIME varchar(100) not null,
   STATUS varchar(100),
   AUTHORS varchar(500),
   REFERENCE_STAGE varchar(50),
   VALIDATION varchar(100),
   ASSAY_QUALITY varchar(100),
   STAGING_QUALITY varchar(100),
   PROJECT varchar(100),
   FK_INVESTIGATOR bigint not null,
   FK_CURATOR bigint,
   FK_EXPERIMENT bigint not null,
   primary key (OID)
)
create table SUB_PUB_MMTB (
   OID bigint generated by default as identity,
   ORDERING smallint not null,
   FK_PUBLICATION bigint not null,
   FK_SUBMISSION bigint not null,
   primary key (OID)
)
create table WET_IHC_TB (
   OID_EXPERIMENT bigint not null,
   FK_PROBE bigint not null,
   primary key (OID_EXPERIMENT)
)
create table WET_ISH_TB (
   OID_EXPERIMENT bigint not null,
   LABEL varchar(100),
   DIRECTION varchar(100),
   FK_PROBE bigint not null,
   primary key (OID_EXPERIMENT)
)
create table WET_REPORTER_TB (
   OID_EXPERIMENT bigint not null,
   EXPERIMENT_ID varchar(100) not null,
   REPORTER varchar(100) not null,
   primary key (OID_EXPERIMENT)
)
alter table ACK_TB add constraint ACK_SUB_C foreign key (FK_SUBMISSION) references SUBMISSION_TB
alter table ACK_TB add constraint ACK_PERSON_C foreign key (FK_PERSON) references PERSON_TB
alter table ANTIBODY_REAGENT_TB add constraint REAGENT_IHC_C foreign key (FK_WET_IHC) references WET_IHC_TB
alter table ANTIBODY_TB add constraint ANTIBODY_PROBE_C foreign key (OID_PROBE) references PROBE_TB
alter table ANTIBODY_TB add constraint ANTIBODY_SEQ_C foreign key (FK_SEQUENCE) references SEQUENCE_TB
alter table CELL_LINE_TB add constraint CELL_LINE_NOTE_C foreign key (FK_NOTE) references LONG_TEXT_TB
alter table EXPERIMENT_TB add constraint WET_GENE_C foreign key (FK_GENE) references GENE_TB
alter table EXPERIMENT_TB add constraint PROBE_NOTE_C foreign key (FK_PROBE_NOTE) references LONG_TEXT_TB
alter table EXPERIMENT_TB add constraint WET_SPECIMEN_C foreign key (FK_ORGANISM) references ORGANISM_TB
alter table EXPERIMENT_TB add constraint SPECIMEN_NOTE_C foreign key (FK_SPECIMEN_NOTE) references LONG_TEXT_TB
alter table EXPRESSION_TEXT_TB add constraint EXPRESSION_NOTE_C foreign key (FK_NOTE) references LONG_TEXT_TB
alter table EXPRESSION_TEXT_TB add constraint EXP_TEXT_SUB_C foreign key (FK_SUBMISSION) references SUBMISSION_TB
alter table GENE_SYNONYM_TB add constraint GENE_SYNONYM_C foreign key (FK_GENE) references GENE_TB
alter table HISTORY_TB add constraint HISTORY_SUB_C foreign key (FK_SUBMISSION) references SUBMISSION_TB
alter table IMAGE_POSITION_TB add constraint ASSAY_POS_C foreign key (FK_IMAGE) references IMAGE_TB
alter table IMAGE_POSITION_TB add constraint IMAGE_POS_C foreign key (FK_SECTION_POSITION) references SECTION_POSITION_TB
alter table IMAGE_TB add constraint IMAGE_NOTE_C foreign key (FK_NOTE) references LONG_TEXT_TB
alter table IMAGE_TB add constraint SUB_IMAGE_C foreign key (FK_SUBMISSION) references SUBMISSION_TB
alter table LINK_TB add constraint LINK_SUB_C foreign key (FK_SUBMISSION) references SUBMISSION_TB
alter table MAPPED_IMAGE_POSITION_TB add constraint EXP_POSITION_C foreign key (FK_MAPPED_IMAGE) references MAPPED_IMAGE_TB
alter table MAPPED_IMAGE_POSITION_TB add constraint EXP_IMAGE_POS_C foreign key (FK_SECTION_POSITION) references SECTION_POSITION_TB
alter table MAPPED_IMAGE_TB add constraint MAPPED_NOTE_C foreign key (FK_NOTE) references LONG_TEXT_TB
alter table MAPPED_IMAGE_TB add constraint IMAGE_EXP_SUB_C foreign key (FK_SUBMISSION) references SUBMISSION_TB
alter table MUTANT_TB add constraint ORGANISM_MUTANT_C foreign key (FK_ORGANISM) references ORGANISM_TB
alter table PERSON_TB add constraint PERSON_ORG_C foreign key (FK_ORGANIZATION) references ORGANIZATION_TB
alter table PROBE_ISH_TB add constraint ISH_PROBE_C foreign key (OID_PROBE) references PROBE_TB
alter table PROBE_SEQ_MMTB add constraint SEQ_ISH_C foreign key (FK_PROBE) references PROBE_ISH_TB
alter table PROBE_SEQ_MMTB add constraint ISH_SEQ_C foreign key (FK_SEQUENCE) references SEQUENCE_TB
alter table PROBE_TB add constraint PROBE_CELL_C foreign key (FK_CELL_LINE) references CELL_LINE_TB
alter table PROBE_TB add constraint PROBE_ORGANISM_C foreign key (FK_ORGANISM) references ORGANISM_TB
alter table PUBLICATION_TB add constraint PUB_JPURNAL_C foreign key (FK_PUBLICATION_INFO) references PUBLICATION_VOLUME_TB
alter table REGION_TB add constraint ISH_REGION_C foreign key (FK_PROBE) references PROBE_ISH_TB
alter table SEQUENCE_TB add constraint SEQUENCE_DETAIL_C foreign key (FK_SEQUENCE_DETAIL) references LONG_TEXT_TB
alter table SUBMISSION_COMMENT_TB add constraint SUB_COMMENT_C foreign key (FK_SUBMISSION) references SUBMISSION_TB
alter table SUBMISSION_TB add constraint SUB_CURATOR_C foreign key (FK_CURATOR) references PERSON_TB
alter table SUBMISSION_TB add constraint SUB_EXPERIMENT_C foreign key (FK_EXPERIMENT) references EXPERIMENT_TB
alter table SUBMISSION_TB add constraint SUB_INVESTIGATOR_C foreign key (FK_INVESTIGATOR) references PERSON_TB
alter table SUB_PUB_MMTB add constraint PUB_SUB_C foreign key (FK_PUBLICATION) references PUBLICATION_TB
alter table SUB_PUB_MMTB add constraint SUB_PUB_C foreign key (FK_SUBMISSION) references SUBMISSION_TB
alter table WET_IHC_TB add constraint IHC_PROBE_C foreign key (FK_PROBE) references ANTIBODY_TB
alter table WET_IHC_TB add constraint IHC_EXPERIMENT_C foreign key (OID_EXPERIMENT) references EXPERIMENT_TB
alter table WET_ISH_TB add constraint ISH_PROBE_C foreign key (FK_PROBE) references PROBE_ISH_TB
alter table WET_ISH_TB add constraint ISH_EXPERIMENT_C foreign key (OID_EXPERIMENT) references EXPERIMENT_TB
alter table WET_REPORTER_TB add constraint REPORTER_WET_C foreign key (OID_EXPERIMENT) references EXPERIMENT_TB