REM Copyright (c) 2003 Konrad Buessow

REM This program is free software; you can redistribute and/or modify 
REM it under the terms of the GNU General Public Licence as published by
REM the Free Software Foundation; eiher version 2, or (at your option) any
REM later version.

REM This program is distributed in the hope that it will be useful, but 
REM WITHOUT ANY WARRANTY; without even the implied warranty of 
REM MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
REM GNU General Public Licence for more details. 

REM You should have received a copy of the GNU General Public Licence 
REM along with this program; if not, write to the Free Software 
REM Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA

-- 
-- TABLE: ACTION_TYPES 
--

ALTER TABLE ACTION_TYPES ADD CONSTRAINT SYS_C006835 
    FOREIGN KEY (PLABOCONTENTID)
    REFERENCES PLABO_CONTENT(CONTENT_ID)
;



-- 
-- TABLE: BARCODE 
--

ALTER TABLE BARCODE ADD CONSTRAINT BC_EXP_REF 
    FOREIGN KEY (EXPERIMENTATOR)
    REFERENCES EXPERIMENTATOR(ID)
;

ALTER TABLE BARCODE ADD CONSTRAINT BC_PLABO_REF 
    FOREIGN KEY (PLATESBOXESID)
    REFERENCES PLATESBOXES(PLATESBOXESID)
;

ALTER TABLE BARCODE ADD CONSTRAINT BC_PLABOADMINID_REF 
    FOREIGN KEY (PLABO_ADMINID)
    REFERENCES PLATESBOXESADMIN(PLATESBOXESADMINID)
;

ALTER TABLE BARCODE ADD CONSTRAINT BC_RECI_REF 
    FOREIGN KEY (RECIPIENT)
    REFERENCES EXPERIMENTATOR(ID)
;


-- 
-- TABLE: CHROMAT 
--

ALTER TABLE CHROMAT ADD CONSTRAINT A216C503E_1612_11D4_9641_00606 
    FOREIGN KEY (COLUMN_)
    REFERENCES COLUMNS_(COLUMN_ID)
;

ALTER TABLE CHROMAT ADD CONSTRAINT CHROMAT_FK4999880288288 
    FOREIGN KEY (BUFFERA)
    REFERENCES BUFFERS(BUFFER_ID)
;

ALTER TABLE CHROMAT ADD CONSTRAINT CHROMAT_FK61030354155373 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE CHROMAT ADD CONSTRAINT CHROMAT_FK6999880543715 
    FOREIGN KEY (BUFFERB)
    REFERENCES BUFFERS(BUFFER_ID)
;

ALTER TABLE CHROMAT ADD CONSTRAINT CHROMAT_FK71030460827929 
    FOREIGN KEY (EXPERIMENTATOR_ID)
    REFERENCES EXPERIMENTATOR(ID)
;


-- 
-- TABLE: CLONE_SEQDB 
--

ALTER TABLE CLONE_SEQDB ADD CONSTRAINT CLONE_SEQDB_REFCLONEID 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;


-- 
-- TABLE: CLONEIMAGE 
--

ALTER TABLE CLONEIMAGE ADD CONSTRAINT CLONEIMAGE_FK31030358226327 
    FOREIGN KEY (RZPD_IMAGE_LIB)
    REFERENCES IMAGE_LIB(ID_LIB)
;

ALTER TABLE CLONEIMAGE ADD CONSTRAINT CLONEINDEXCLONEIMAGE 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;


-- 
-- TABLE: CLONELIGATION 
--

ALTER TABLE CLONELIGATION ADD CONSTRAINT CLONELIG_TRAFO_REF 
    FOREIGN KEY (TRAFO_ID)
    REFERENCES TRANSFORMATIONS(TRAFO_ID)
;

ALTER TABLE CLONELIGATION ADD CONSTRAINT CLONELIGATION_FK71030458157469 
    FOREIGN KEY (EXPERIMENTATOR_ID)
    REFERENCES EXPERIMENTATOR(ID)
;

ALTER TABLE CLONELIGATION ADD CONSTRAINT REFERENCE13 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;


-- 
-- TABLE: CLONEOTHER 
--

ALTER TABLE CLONEOTHER ADD CONSTRAINT CLONEOTHER_CLONEID_REF 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE CLONEOTHER ADD CONSTRAINT CO_HELP_REF 
    FOREIGN KEY (HELPERPLASMIDID)
    REFERENCES VECTORS(VECTORID)
;

ALTER TABLE CLONEOTHER ADD CONSTRAINT CO_STRAIN_REF 
    FOREIGN KEY (STRAINID)
    REFERENCES STRAINS(STRAINID)
;

ALTER TABLE CLONEOTHER ADD CONSTRAINT CO_VEC_REF 
    FOREIGN KEY (VECTORID)
    REFERENCES VECTORS(VECTORID)
;


-- 
-- TABLE: CLONESRZPD 
--

ALTER TABLE CLONESRZPD ADD CONSTRAINT REFERENCE12 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE CLONESRZPD ADD CONSTRAINT REFERENCE2 
    FOREIGN KEY (LIBNO)
    REFERENCES LIBRARIES(LIBNO)
;


-- 
-- TABLE: COLUMNS_ 
--

ALTER TABLE COLUMNS_ ADD CONSTRAINT A216C5030_1612_11D4_9641_00606 
    FOREIGN KEY (EMPTYCOLUMNTYPE)
    REFERENCES EMPTYCOLUMNTYPES(ID)
;

ALTER TABLE COLUMNS_ ADD CONSTRAINT A216C5031_1612_11D4_9641_00606 
    FOREIGN KEY (MEDIUM)
    REFERENCES RESIN(ID)
;


-- 
-- TABLE: DNA_ACTION 
--

ALTER TABLE DNA_ACTION ADD CONSTRAINT DNA_ACTION_FK9999870546650 
    FOREIGN KEY (PLABOID)
    REFERENCES PLATESBOXES(PLATESBOXESID) ON DELETE CASCADE
;

ALTER TABLE DNA_ACTION ADD CONSTRAINT DNAAC_EXP 
    FOREIGN KEY (EXPERIMENTATORID)
    REFERENCES EXPERIMENTATOR(ID)
;


-- 
-- TABLE: DNADIGEST 
--

ALTER TABLE DNADIGEST ADD CONSTRAINT DNADIGEST_FK41030357765745 
    FOREIGN KEY (DNA_ACTIONID)
    REFERENCES DNA_ACTION(DNAACTIONID)
;

ALTER TABLE DNADIGEST ADD CONSTRAINT SYS_C006831 
    FOREIGN KEY (FIRSTENZYME)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;

ALTER TABLE DNADIGEST ADD CONSTRAINT SYS_C006832 
    FOREIGN KEY (SECONDENZYME)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;


-- 
-- TABLE: DNALANES 
--


ALTER TABLE DNALANES ADD CONSTRAINT BLABLABLA 
    FOREIGN KEY (PLATESBOXESID)
    REFERENCES PLATESBOXES(PLATESBOXESID)
;

ALTER TABLE DNALANES ADD CONSTRAINT DNALANES_FK41030383744480 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;


-- 
-- TABLE: DNAPURIFY 
--

ALTER TABLE DNAPURIFY ADD CONSTRAINT DNAPURIFY_FK31030444591722 
    FOREIGN KEY (DNA_ACTIONID)
    REFERENCES DNA_ACTION(DNAACTIONID)
;

ALTER TABLE DNAPURIFY ADD CONSTRAINT SYS_C006833 
    FOREIGN KEY (CLEANINGMETHODID)
    REFERENCES OLIGOCLEANINGKITS(ID)
;


-- 
-- TABLE: DNAQUANTIFICATION 
--

ALTER TABLE DNAQUANTIFICATION ADD CONSTRAINT DNAQUANTIFICA_FK21030444435648 
    FOREIGN KEY (DNA_ACTIONID)
    REFERENCES DNA_ACTION(DNAACTIONID)
;


-- 
-- TABLE: EXPRESSIONCLONES 
--

ALTER TABLE EXPRESSIONCLONES ADD CONSTRAINT REFERENCE4 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;


-- 
-- TABLE: GENBANKENTRIES 
--

ALTER TABLE GENBANKENTRIES ADD CONSTRAINT GB_SEQDNA_REF 
    FOREIGN KEY (SEQDNA_ID)
    REFERENCES SEQ_DNA(SEQDNA_ID)
;

ALTER TABLE GENBANKENTRIES ADD CONSTRAINT GB_SEQPEP_ID 
    FOREIGN KEY (SEQPEP_ID)
    REFERENCES SEQ_PEP(SEQPEP_ID)
;

ALTER TABLE GENBANKENTRIES ADD CONSTRAINT GB_SPECIES_REF 
    FOREIGN KEY (SPECIESNO)
    REFERENCES SPECIES(SPECIESNO)
;


-- 
-- TABLE: IMAGE_LIB 
--

ALTER TABLE IMAGE_LIB ADD CONSTRAINT IMAGELIB_VECTOR_REF 
    FOREIGN KEY (VECTOR_ID)
    REFERENCES VECTORS(VECTORID)
;


-- 
-- TABLE: LIBRARIES 
--

ALTER TABLE LIBRARIES ADD CONSTRAINT LIB_HELP_REF 
    FOREIGN KEY (HELPER_VEC_ID)
    REFERENCES VECTORS(VECTORID)
;

ALTER TABLE LIBRARIES ADD CONSTRAINT LIB_STRAIN_REF 
    FOREIGN KEY (STRAIN_ID)
    REFERENCES STRAINS(STRAINID)
;

ALTER TABLE LIBRARIES ADD CONSTRAINT LIB_VEC_REF 
    FOREIGN KEY (VECTOR_ID)
    REFERENCES VECTORS(VECTORID)
;


-- 
-- TABLE: LIGATION 
--

ALTER TABLE LIGATION ADD CONSTRAINT LIG_CLONEID_REF 
    FOREIGN KEY (INSERTCLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE LIGATION ADD CONSTRAINT LIG_EXPTOR_REF 
    FOREIGN KEY (EXPERIMENTATORID)
    REFERENCES EXPERIMENTATOR(ID)
;

ALTER TABLE LIGATION ADD CONSTRAINT LIG_PCREXP_REF 
    FOREIGN KEY (PCREXPID)
    REFERENCES PCREXPERIMENT(PCREXPERIMENTID)
;

ALTER TABLE LIGATION ADD CONSTRAINT RE1INSERT_REF 
    FOREIGN KEY (RE1INSERT)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;

ALTER TABLE LIGATION ADD CONSTRAINT RE2INSERT_REF 
    FOREIGN KEY (RE2INSERT)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;

ALTER TABLE LIGATION ADD CONSTRAINT REFERENCE16 
    FOREIGN KEY (RE2VECTOR)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;

ALTER TABLE LIGATION ADD CONSTRAINT REFERENCE21 
    FOREIGN KEY (VECTORID)
    REFERENCES VECTORS(VECTORID)
;

ALTER TABLE LIGATION ADD CONSTRAINT REFERENCE3 
    FOREIGN KEY (RE1VECTOR)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;


-- 
-- TABLE: PAGE 
--

ALTER TABLE PAGE ADD CONSTRAINT PAGE_EXTOR_REF 
    FOREIGN KEY (EXPERIMENTATOR_ID)
    REFERENCES EXPERIMENTATOR(ID)
;

ALTER TABLE PAGE ADD CONSTRAINT PAGE_FK41030382110200 
    FOREIGN KEY (FPLCRUN_ID)
    REFERENCES CHROMAT(FPLC_ID)
;


ALTER TABLE PAGE ADD CONSTRAINT PAGE_FK51030383124669 
    FOREIGN KEY (EXPERIMENTID)
    REFERENCES EXPERIMENTS(EXP_ID)
;


-- 
-- TABLE: PAGELANES 
--

ALTER TABLE PAGELANES ADD CONSTRAINT PAGELANES_CLONEID_REF 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE PAGELANES ADD CONSTRAINT PAGELANES_PAGE_REFERENCE 
    FOREIGN KEY (PAGE)
    REFERENCES PAGE(PAGEID)
;


-- 
-- TABLE: PCR_ACTION 
--

ALTER TABLE PCR_ACTION ADD CONSTRAINT PCR_ACTION_FK71018009854538 
    FOREIGN KEY (PCREXPERIMENTID)
    REFERENCES PCREXPERIMENT(PCREXPERIMENTID) ON DELETE CASCADE
;


-- 
-- TABLE: PCREXPERIMENT 
--

ALTER TABLE PCREXPERIMENT ADD CONSTRAINT A216C5032_1612_11D4_9641_00606 
    FOREIGN KEY (CLEANED_WITH)
    REFERENCES OLIGOCLEANINGKITS(ID)
;

ALTER TABLE PCREXPERIMENT ADD CONSTRAINT A216C5043_1612_11D4_9641_00606 
    FOREIGN KEY (PCRPROTOCOLID)
    REFERENCES PCRPROTOCOL(ID)
;

ALTER TABLE PCREXPERIMENT ADD CONSTRAINT A216C5044_1612_11D4_9641_00606 
    FOREIGN KEY (ENDPRIMERID5)
    REFERENCES PCRPRIMER(ID)
;

ALTER TABLE PCREXPERIMENT ADD CONSTRAINT PCREXP_CLONEID_REF 
    FOREIGN KEY (TEMPLATECLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE PCREXPERIMENT ADD CONSTRAINT PRIMER3_REF 
    FOREIGN KEY (ENDPRIMERID3)
    REFERENCES PCRPRIMER(ID)
;


-- 
-- TABLE: PCRPRIMER 
--

ALTER TABLE PCRPRIMER ADD CONSTRAINT PCRPRI_ENZYME_REF 
    FOREIGN KEY (ENZYMEID)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;

ALTER TABLE PCRPRIMER ADD CONSTRAINT PCRPRIMER_FK61007479563936 
    FOREIGN KEY (EXPERIMENTATOR)
    REFERENCES EXPERIMENTATOR(ID)
;

ALTER TABLE PCRPRIMER ADD CONSTRAINT PCRPRIMER_FK61030382054811 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE PCRPRIMER ADD CONSTRAINT PCRPRIMER_FK71030383068138 
    FOREIGN KEY (MANUFACTURERID)
    REFERENCES FLAG_COL(ID)
;

ALTER TABLE PCRPRIMER ADD CONSTRAINT PCRPRIMER_FK81030383068138 
    FOREIGN KEY (APRIMEMOD)
    REFERENCES FLAG_COL(ID)
;


-- 
-- TABLE: PCRPROT 
--

ALTER TABLE PCRPROT ADD CONSTRAINT PCRPROT_FK51031644728603 
    FOREIGN KEY (SEQDNA_ID)
    REFERENCES SEQ_DNA(SEQDNA_ID)
;

ALTER TABLE PCRPROT ADD CONSTRAINT PCRPROT_PCRPRID_REF 
    FOREIGN KEY (PCRPRID)
    REFERENCES PCRPRIMER(ID)
;


-- 
-- TABLE: PLATESBOXES 
--

ALTER TABLE PLATESBOXES ADD CONSTRAINT LIG_PLABO 
    FOREIGN KEY (LIGATIONID)
    REFERENCES LIGATION(LIGATIONID)
;

ALTER TABLE PLATESBOXES ADD CONSTRAINT PLABO_PROTID_REF 
    FOREIGN KEY (PROTEIN_ID)
    REFERENCES PROT_PREPS(PROTEIN_ID)
;

ALTER TABLE PLATESBOXES ADD CONSTRAINT PLATESBOXES_FK71030357218578 
    FOREIGN KEY (PLATESBOXESADMINID)
    REFERENCES PLATESBOXESADMIN(PLATESBOXESADMINID)
;

ALTER TABLE PLATESBOXES ADD CONSTRAINT PLATESBOXES_FK81030383709340 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;


-- 
-- TABLE: PLATESBOXESADMIN 
--

ALTER TABLE PLATESBOXESADMIN ADD CONSTRAINT PLATESBOXESAD_FK21030371923252 
    FOREIGN KEY (CONTENTID)
    REFERENCES PLABO_CONTENT(CONTENT_ID)
;


-- 
-- TABLE: PROT_EXPRESS 
--

ALTER TABLE PROT_EXPRESS ADD CONSTRAINT PROTEXPR_PAGE_REF 
    FOREIGN KEY (PAGE_ID)
    REFERENCES PAGE(PAGEID)
;

ALTER TABLE PROT_EXPRESS ADD CONSTRAINT PROTEXPRESS_CLONEID_REF 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE PROT_EXPRESS ADD CONSTRAINT PROTEXPRESS_EXPERIMENTATOR_REF 
    FOREIGN KEY (EXPERIMENTATOR_ID)
    REFERENCES EXPERIMENTATOR(ID)
;

ALTER TABLE PROT_EXPRESS ADD CONSTRAINT PROTEXPRESS_SNSPL_REF 
    FOREIGN KEY (SNS_PAGELANE)
    REFERENCES PAGELANES(ID)
;

ALTER TABLE PROT_EXPRESS ADD CONSTRAINT PROTEXPRESS_SPSPL_REF 
    FOREIGN KEY (SPS_PAGELANE)
    REFERENCES PAGELANES(ID)
;

ALTER TABLE PROT_EXPRESS ADD CONSTRAINT PROTEXPRESS_WNSPL_REF 
    FOREIGN KEY (WNS_PAGELANE)
    REFERENCES PAGELANES(ID)
;

ALTER TABLE PROT_EXPRESS ADD CONSTRAINT PROTEXPRESS_WPSPL_REF 
    FOREIGN KEY (WPS_PAGELANE)
    REFERENCES PAGELANES(ID)
;


-- 
-- TABLE: PROT_PREPS 
--

ALTER TABLE PROT_PREPS ADD CONSTRAINT PROT_CLONEID_REF 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE PROT_PREPS ADD CONSTRAINT PROT_PREPS_FK3999880580388 
    FOREIGN KEY (BUFFER)
    REFERENCES BUFFERS(BUFFER_ID)
;

ALTER TABLE PROT_PREPS ADD CONSTRAINT PROT_PREPS_FK5999880605544 
    FOREIGN KEY (EXPERIMENT_ID)
    REFERENCES EXPERIMENTS(EXP_ID)
;

ALTER TABLE PROT_PREPS ADD CONSTRAINT PROT_PREPS_FK7999880625923 
    FOREIGN KEY (EXPERIMENTATOR)
    REFERENCES EXPERIMENTATOR(ID)
;


-- 
-- TABLE: ROBOT_JOBS 
--

ALTER TABLE ROBOT_JOBS ADD CONSTRAINT JOB_EXID_EX 
    FOREIGN KEY (EXPERIMENTID)
    REFERENCES EXPERIMENTS(EXP_ID)
;

ALTER TABLE ROBOT_JOBS ADD CONSTRAINT ROBOT_JOBS_FK31030381370967 
    FOREIGN KEY (EXPERIMENTATORID)
    REFERENCES EXPERIMENTATOR(ID)
;


-- 
-- TABLE: ROBOT_JOBTYPE 
--

ALTER TABLE ROBOT_JOBTYPE ADD CONSTRAINT JT_LO 
    FOREIGN KEY (LAYOUT)
    REFERENCES ROBOT_LAYOUT(ID)
;


-- 
-- TABLE: ROBOT_REARRAY 
--

ALTER TABLE ROBOT_REARRAY ADD CONSTRAINT CODEST_BARCODE 
    FOREIGN KEY (DEST_BARCODE)
    REFERENCES BARCODE(BARCODE)
;

ALTER TABLE ROBOT_REARRAY ADD CONSTRAINT COPLABO 
    FOREIGN KEY (PLATESBOXESID)
    REFERENCES PLATESBOXES(PLATESBOXESID) ON DELETE CASCADE
;

ALTER TABLE ROBOT_REARRAY ADD CONSTRAINT COSRC_BARCODE 
    FOREIGN KEY (SRC_BARCODE)
    REFERENCES BARCODE(BARCODE)
;

ALTER TABLE ROBOT_REARRAY ADD CONSTRAINT JOBID_ROBOTJOB_ID 
    FOREIGN KEY (JOB_ID)
    REFERENCES ROBOT_JOBS(ID) ON DELETE CASCADE
;

ALTER TABLE ROBOT_REARRAY ADD CONSTRAINT JOBTYPE_ROBOTJOBS 
    FOREIGN KEY (JOB_TYPE)
    REFERENCES ROBOT_JOBTYPE(ID)
;

ALTER TABLE ROBOT_REARRAY ADD CONSTRAINT ROBOT_REARRAY_FK11999871927596 
    FOREIGN KEY (SRC_PLATESBOXESID)
    REFERENCES PLATESBOXES(PLATESBOXESID) ON DELETE CASCADE
;


-- 
-- TABLE: SEQUENCING 
--

ALTER TABLE SEQUENCING ADD CONSTRAINT SEQUENCING_FK111013599194401 
    FOREIGN KEY (MASKED_ID)
    REFERENCES SEQ_DNA(SEQDNA_ID)
;

ALTER TABLE SEQUENCING ADD CONSTRAINT SEQUENCING_FK51002643862328 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE SEQUENCING ADD CONSTRAINT SEQUENCING_FK91013599177767 
    FOREIGN KEY (SEQDNA_ID)
    REFERENCES SEQ_DNA(SEQDNA_ID)
;

ALTER TABLE SEQUENCING ADD CONSTRAINT SEQUENCING_PRIID_REF 
    FOREIGN KEY (PRIMER_ID)
    REFERENCES PCRPRIMER(ID)
;


-- 
-- TABLE: STRAINS 
--

ALTER TABLE STRAINS ADD CONSTRAINT STRAINS_CLONEID_REF 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEOTHER(CLONEID)
;


-- 
-- TABLE: TRANSFORMATIONS 
--

ALTER TABLE TRANSFORMATIONS ADD CONSTRAINT LIGID_REF 
    FOREIGN KEY (LIGATION_ID)
    REFERENCES LIGATION(LIGATIONID)
;

ALTER TABLE TRANSFORMATIONS ADD CONSTRAINT TRAFO_EXPID_REFE 
    FOREIGN KEY (EXPERIMENT_ID)
    REFERENCES EXPERIMENTS(EXP_ID)
;

ALTER TABLE TRANSFORMATIONS ADD CONSTRAINT TRAFO_HELPER_REF 
    FOREIGN KEY (HELPERPLASMID_ID)
    REFERENCES VECTORS(VECTORID)
;

ALTER TABLE TRANSFORMATIONS ADD CONSTRAINT TRAFO_PLASMIDCLONEID_REF 
    FOREIGN KEY (PLASMID_CLONEID_SOURCE)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE TRANSFORMATIONS ADD CONSTRAINT TRAFO_STRAIN_REF 
    FOREIGN KEY (STRAINID)
    REFERENCES STRAINS(STRAINID)
;

ALTER TABLE TRANSFORMATIONS ADD CONSTRAINT TRANSFORMATIO_FK81030459383422 
    FOREIGN KEY (EXPERIMENTATOR_ID)
    REFERENCES EXPERIMENTATOR(ID)
;


-- 
-- TABLE: VECTORS 
--

ALTER TABLE VECTORS ADD CONSTRAINT REFERENCE18 
    FOREIGN KEY (RESISTENCEMARKER)
    REFERENCES ANTIBIOTICS(ID)
;

ALTER TABLE VECTORS ADD CONSTRAINT REFERENCE19 
    FOREIGN KEY (DEFAULTRE1)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;

ALTER TABLE VECTORS ADD CONSTRAINT REFERENCE20 
    FOREIGN KEY (DEFAULTRE2)
    REFERENCES RESTRICTIONENZYMES(ENZYMEID)
;

ALTER TABLE VECTORS ADD CONSTRAINT SEQDNA_REF 
    FOREIGN KEY (SEQDNA_ID)
    REFERENCES SEQ_DNA(SEQDNA_ID)
;

ALTER TABLE VECTORS ADD CONSTRAINT VEC_CLONEID_REF 
    FOREIGN KEY (CLONEID)
    REFERENCES CLONEINDEX(CLONEID)
;

ALTER TABLE VECTORS ADD CONSTRAINT VECTORS_FK101030382500011 
    FOREIGN KEY (ORIGIN)
    REFERENCES FLAG_COL(ID)
;

ALTER TABLE EXPERIMENTS ADD CONSTRAINT EXPERI_EXP_REF 
    FOREIGN KEY (EXPERIMENTATOR_ID) 
    REFERENCES EXPERIMENTATOR(ID)
;