create table ACK_TB (
        OID bigint generated by default as identity,
        ORDERING smallint not null,
        PROJECT varchar(100),
        REASON varchar(500),
        FK_PERSON bigint,
        FK_SUBMISSION bigint not null,
        primary key (OID)
    )

    create table ANNOTATION_IMAGE_DTB (
        PURPOSE varchar(50) not null,
        OID bigint generated by default as identity,
        FILENAME varchar(250) not null,
        FORMAT varchar(100),
        STAGE varchar(50) not null,
        STRENGTH varchar(100) not null,
        FK_SUBMISSION_ACCESSION bigint not null,
        X_HIGH smallint not null,
        X_LOW smallint not null,
        Y_HIGH smallint not null,
        Y_LOW smallint not null,
        Z_HIGH smallint not null,
        Z_LOW smallint not null,
        primary key (OID)
    )

    create table ANNOTATION_TEXT_DTB (
        PURPOSE varchar(50) not null,
        OID bigint generated by default as identity,
        PERCENTAGE float,
        STRENGTH varchar(100) not null,
        FK_SUBMISSION_ACCESSION bigint not null,
        TISSUE_ACCESSION varchar(100) not null,
        TISSUE_NAME varchar(100),
        VOLUME bigint,
        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 (
        ANTIBODY_TYPE varchar(100),
        CATALOGUE_NO varchar(100),
        LABEL varchar(100),
        RAISED_IN varchar(100),
        SUPPLIER varchar(100),
        OID_PROBE bigint not null,
        FK_SEQUENCE bigint,
        primary key (OID_PROBE)
    )

    create table CELL_LINE_TB (
        OID bigint generated by default as identity,
        ACCESSION varchar(100),
        NAME 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),
        GENE_IMAGE_ROOT varchar(250) not null,
        GENE_IMAGE_SEGMENT_ROOT varchar(250) not null,
        IMAGE_ROOT varchar(250) not null,
        IMAGE_SEGMENT_ROOT varchar(250) not null,
        SPECIES varchar(100) not null,
        STAGE_TYPE varchar(100) not null,
        SUBMISSION_ACCESSION_PREFIX varchar(100) not null,
        primary key (OID)
    )

    create table EXPERIMENT_TB (
        OID bigint generated by default as identity,
        CLEARING_METHOD varchar(100),
        EMBEDDING_REAGENT varchar(100),
        FIXATION_REAGENT varchar(100),
        SIGNAL_DETECT_METHOD varchar(100),
        SPECIMEN_TYPE varchar(100),
        FK_GENE bigint not null,
        FK_PROBE_NOTE bigint,
        FK_ORGANISM bigint not null,
        FK_SPECIMEN_NOTE bigint,
        primary key (OID)
    )

    create table EXPRESSION_TEXT_TB (
        OID bigint generated by default as identity,
        LOCATION varchar(250),
        ORDERING smallint not null,
        PATTERN varchar(100),
        STRENGTH varchar(100) not null,
        TISSUE_ACCESSION varchar(100) not null,
        FK_NOTE bigint,
        FK_SUBMISSION bigint not null,
        primary key (OID)
    )

    create table GENE_MAP_ATB (
        OID bigint generated by default as identity,
        ACCESSION varchar(100) not null,
        MODERATE_FILE_NAME varchar(250),
        MODERATE_ONTOLOGY_NAME varchar(1000),
        NOT_DETECT_FILE_NAME varchar(250),
        NOT_DETECT_ONTOLOGY_NAME varchar(1000),
        POSSIBLE_FILE_NAME varchar(250),
        POSSIBLE_ONTOLOGY_NAME varchar(1000),
        STAGE varchar(100) not null,
        STATUS varchar(100),
        STRONG_FILE_NAME varchar(250),
        STRONG_ONTOLOGY_NAME varchar(1000),
        SUB_ACCESSION varchar(1000),
        SYMBOL varchar(100),
        VIEW_FILE_NAME varchar(100),
        VIEW_ONTOLOGY_NAME varchar(1000),
        WEAK_FILE_NAME varchar(250),
        WEAK_ONTOLOGY_NAME varchar(1000),
        primary key (OID)
    )

    create table GENE_SYNONYM_TB (
        FK_GENE bigint not null,
        SYNONYM varchar(250)
    )

    create table GENE_TB (
        OID bigint generated by default as identity,
        ACCESSION varchar(100),
        NAME varchar(250),
        SYMBOL varchar(100) not null,
        primary key (OID)
    )

    create table GO_GENE_ITB (
        OID bigint generated by default as identity,
        GO_GENE_MAPPING varchar(100) not null,
        FK_GENE bigint not null,
        FK_GO bigint not null,
        primary key (OID)
    )

    create table GO_ITB (
        OID bigint generated by default as identity,
        GO_ACCESSION varchar(100) not null,
        GO_NAME varchar(250) not null,
        GO_TYPE varchar(100) not null,
        primary key (OID)
    )

    create table HISTORY_TB (
        OID bigint generated by default as identity,
        ACCESSION varchar(100),
        ORDERING smallint not null,
        RESOURCE varchar(100),
        HISTORY_TYPE varchar(100),
        WEB_URL varchar(250),
        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,
        CATEGORY smallint,
        FILENAME varchar(250) not null,
        FORMAT varchar(100),
        HEIGHT smallint,
        METHOD varchar(100),
        NAME varchar(100),
        ORDERING smallint not null,
        WIDTH smallint,
        FK_NOTE bigint,
        FK_SUBMISSION bigint not null,
        primary key (OID)
    )

    create table LARGE_TB (
        OID bigint generated by default as identity,
        CONTENT varchar(12000) not null,
        primary key (OID)
    )

    create table LINK_TB (
        OID bigint generated by default as identity,
        ACCESSION varchar(100),
        ORDERING smallint not null,
        LINK_TYPE varchar(100),
        WEB_URL varchar(250),
        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,
        primary key (OID)
    )

    create table MAPPED_IMAGE_POSITION_TB (
        OID bigint generated by default as identity,
        NAME varchar(100),
        FK_MAPPED_IMAGE bigint not null,
        FK_SECTION_POSITION bigint not null,
        primary key (OID)
    )

    create table MAPPED_IMAGE_TB (
        PURPOSE varchar(50) not null,
        OID bigint generated by default as identity,
        FILENAME varchar(250) not null,
        FORMAT varchar(100),
        NAME varchar(100),
        ORDERING smallint not null,
        PATTERN varchar(100),
        STRENGTH varchar(100) 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,
        ACCESSION varchar(100),
        NAME varchar(300),
        SEX varchar(50),
        SPECIES varchar(100),
        STAGE_VALUE varchar(100),
        STAGING_METHOD varchar(100),
        STRAIN varchar(250),
        WILD_TYPE smallint,
        primary key (OID)
    )

    create table ORGANIZATION_TB (
        OID bigint generated by default as identity,
        ADDRESS varchar(200),
        CITY varchar(100),
        COUNTRY varchar(100),
        FAX varchar(100),
        NAME varchar(100),
        POSTCODE varchar(100),
        TEL varchar(100),
        WEB_URL varchar(250),
        primary key (OID)
    )

    create table PERSON_TB (
        OID bigint generated by default as identity,
        EMAIL varchar(100),
        NAME varchar(100),
        TEL varchar(100),
        FK_ORGANIZATION bigint not null,
        primary key (OID)
    )

    create table PROBE_ISH_TB (
        CHEMISTRY varchar(100),
        CLONE_NAME varchar(100),
        LABEL varchar(100),
        TEMPLATE_TYPE varchar(100),
        OID_PROBE bigint not null,
        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,
        ACCESSION varchar(100),
        NAME varchar(100),
        ORIGIN_TYPE varchar(100),
        SEQUENCE_TYPE varchar(100),
        FK_CELL_LINE bigint,
        FK_ORGANISM bigint,
        primary key (OID)
    )

    create table PUBLICATION_TB (
        OID bigint generated by default as identity,
        ACCESSION varchar(100),
        AUTHORS varchar(500),
        PAGES varchar(100),
        TITLE varchar(250),
        FK_PUBLICATION_INFO bigint not null,
        primary key (OID)
    )

    create table PUBLICATION_VOLUME_TB (
        OID bigint generated by default as identity,
        AUTHORS varchar(100),
        ISSUE varchar(100),
        NAME varchar(100),
        PUBLISHER varchar(100),
        VOLUME varchar(100),
        PUBLICATION_YEAR varchar(100),
        primary key (OID)
    )

    create table REGION_TB (
        FK_PROBE bigint not null,
        REGION varchar(100)
    )

    create table SECTION_POSITION_TB (
        OID bigint generated by default as identity,
        DISTANCE float not null,
        PHI float not null,
        THETA float not null,
        X float not null,
        Y float not null,
        Z float not null,
        primary key (OID)
    )

    create table SEQUENCE_TB (
        OID bigint generated by default as identity,
        ACCESSION varchar(100),
        END_LOC bigint,
        START_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,
        ASSAY_QUALITY varchar(100),
        ASSAY_TYPE varchar(100),
        GENE_SYMBOL varchar(100),
        GENOTYPE varchar(100),
        PROBE_ID varchar(100),
        RECENT_HISTORY varchar(100),
        SPECIMEN_STRAIN varchar(200),
        SPECIMEN_TYPE varchar(100),
        STAGE varchar(100),
        STAGING_QUALITY varchar(100),
        USER_STAGE varchar(100),
        primary key (OID)
    )

    create table SUBMISSION_TB (
        OID bigint generated by default as identity,
        ACCESSION bigint not null unique,
        ASSAY_QUALITY varchar(100),
        AUTHORS varchar(800),
        CREATION_TIME varchar(100) not null,
        PROJECT varchar(100),
        REFERENCE_STAGE varchar(50),
        STAGING_QUALITY varchar(100),
        STATUS varchar(100),
        VALIDATION varchar(100),
        FK_CURATOR bigint,
        FK_EXPERIMENT bigint not null,
        FK_INVESTIGATOR 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 (
        DIRECTION varchar(100),
        OID_EXPERIMENT bigint not null,
        FK_PROBE bigint not null,
        primary key (OID_EXPERIMENT)
    )

    create table WET_REPORTER_TB (
        EXPERIMENT_ID varchar(100),
        REPORTER varchar(100),
        OID_EXPERIMENT bigint not null,
        primary key (OID_EXPERIMENT)
    )

    alter table ACK_TB 
        add constraint ACK_PERSON_C 
        foreign key (FK_PERSON) 
        references PERSON_TB

    alter table ACK_TB 
        add constraint ACK_SUB_C 
        foreign key (FK_SUBMISSION) 
        references SUBMISSION_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_SEQ_C 
        foreign key (FK_SEQUENCE) 
        references SEQUENCE_TB

    alter table ANTIBODY_TB 
        add constraint ANTIBODY_PROBE_C 
        foreign key (OID_PROBE) 
        references PROBE_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_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 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 EXPRESSION_TEXT_TB 
        add constraint EXP_TEXT_SUB_C 
        foreign key (FK_SUBMISSION) 
        references SUBMISSION_TB

    alter table EXPRESSION_TEXT_TB 
        add constraint EXPRESSION_NOTE_C 
        foreign key (FK_NOTE) 
        references LONG_TEXT_TB

    alter table GENE_SYNONYM_TB 
        add constraint GENE_SYNONYM_C 
        foreign key (FK_GENE) 
        references GENE_TB

    alter table GO_GENE_ITB 
        add constraint GENE_GO_C 
        foreign key (FK_GENE) 
        references GENE_TB

    alter table GO_GENE_ITB 
        add constraint GO_GENE_C 
        foreign key (FK_GO) 
        references GO_ITB

    alter table HISTORY_TB 
        add constraint HISTORY_SUB_C 
        foreign key (FK_SUBMISSION) 
        references SUBMISSION_TB

    alter table IMAGE_POSITION_TB 
        add constraint IMAGE_POS_C 
        foreign key (FK_SECTION_POSITION) 
        references SECTION_POSITION_TB

    alter table IMAGE_POSITION_TB 
        add constraint ASSAY_POS_C 
        foreign key (FK_IMAGE) 
        references IMAGE_TB

    alter table IMAGE_TB 
        add constraint SUB_IMAGE_C 
        foreign key (FK_SUBMISSION) 
        references SUBMISSION_TB

    alter table IMAGE_TB 
        add constraint IMAGE_NOTE_C 
        foreign key (FK_NOTE) 
        references LONG_TEXT_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_IMAGE_POS_C 
        foreign key (FK_SECTION_POSITION) 
        references SECTION_POSITION_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_TB 
        add constraint IMAGE_EXP_SUB_C 
        foreign key (FK_SUBMISSION) 
        references SUBMISSION_TB

    alter table MAPPED_IMAGE_TB 
        add constraint MAPPED_NOTE_C 
        foreign key (FK_NOTE) 
        references LONG_TEXT_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 ISH_SEQ_C 
        foreign key (FK_SEQUENCE) 
        references SEQUENCE_TB

    alter table PROBE_SEQ_MMTB 
        add constraint SEQ_ISH_C 
        foreign key (FK_PROBE) 
        references PROBE_ISH_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_JOURNAL_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 LARGE_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_INVESTIGATOR_C 
        foreign key (FK_INVESTIGATOR) 
        references PERSON_TB

    alter table SUBMISSION_TB 
        add constraint SUB_EXPERIMENT_C 
        foreign key (FK_EXPERIMENT) 
        references EXPERIMENT_TB

    alter table SUB_PUB_MMTB 
        add constraint SUB_PUB_C 
        foreign key (FK_SUBMISSION) 
        references SUBMISSION_TB

    alter table SUB_PUB_MMTB 
        add constraint PUB_SUB_C 
        foreign key (FK_PUBLICATION) 
        references PUBLICATION_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