
CREATE TABLE ABSTRACT ( 
  ABSTRACT_ID  NUMBER        NOT NULL, 
  CITATION_ID  NUMBER (10), 
  ABSTRACT     LONG, 
  CONSTRAINT PK71
  PRIMARY KEY ( ABSTRACT_ID ) ) ; 

CREATE TABLE ACTUAL_SEQUENCE ( 
  ACTUAL_SEQUENCE_ID    NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_ID      NUMBER (10), 
  IUPAC_SEQUENCE_ID     NUMBER (10), 
  DB_XREF_ID            NUMBER (10), 
  ACTUAL_SEQUENCE_NAME  VARCHAR2 (40)  NOT NULL, 
  ACTUAL_SEQUENCE_TYPE  VARCHAR2 (50)  NOT NULL, 
  SEQUENCE_LENGTH       NUMBER (10), 
  CONSTRAINT PK25
  PRIMARY KEY ( ACTUAL_SEQUENCE_ID ) ) ; 

CREATE TABLE ANALYSIS_DESCRIPTION ( 
  ANALYSIS_DESCRIPTION_ID  NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID        NUMBER (10), 
  ANALYSIS_DESCRIPTION     LONG, 
  CONSTRAINT PK42
  PRIMARY KEY ( ANALYSIS_DESCRIPTION_ID ) ) ; 

CREATE TABLE ARRAY_ELEMENT ( 
  ARRAY_ELEMENT_ID           NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_TYPE         VARCHAR2 (25)  NOT NULL, 
  ARRAY_ELEMENT_NAME         VARCHAR2 (30), 
  DIAMETER_ACTUAL            NUMBER (10), 
  ARRAY_ELEMENT_BLOCK        NUMBER (10), 
  ARRAY_ELEMENT_ROW          NUMBER (10), 
  ARRAY_ELEMENT_COLUMN       NUMBER (10), 
  X_MICRONS                  NUMBER (10), 
  Y_MICRONS                  NUMBER (10), 
  ARRAY_ELEMENT_DESCRIPTION  LONG, 
  CONSTRAINT PK24
  PRIMARY KEY ( ARRAY_ELEMENT_ID ) ) ; 

CREATE TABLE ARRAY_ELEMENT_LIST ( 
  ARRAY_ELEMENT_LIST_ID  NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_ID       NUMBER (10)   NOT NULL, 
  ARRAY_PLATFORM_ID      NUMBER (10), 
  PROTOCOL_ID            NUMBER (10), 
  STRANDEDNESS           VARCHAR2 (15)  NOT NULL, 
  DERIVATION             VARCHAR2 (15), 
  ATTACHMENT             VARCHAR2 (15), 
  DIAMETER_TARGET        VARCHAR2 (15), 
  CONSTRAINT PK83
  PRIMARY KEY ( ARRAY_ELEMENT_LIST_ID, ARRAY_ELEMENT_ID ) ) ; 

CREATE TABLE ARRAY_ELEMENT_MEASUREMENTS ( 
  MEASUREMENT_ID    NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_ID  NUMBER (10), 
  CONSTRAINT PK85
  PRIMARY KEY ( MEASUREMENT_ID ) ) ; 

CREATE TABLE ARRAY_ELEMENT_PARAMETERS ( 
  PARAMETER_ID      NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_ID  NUMBER (10), 
  CONSTRAINT PK84
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE ARRAY_PLATFORM ( 
  ARRAY_PLATFORM_ID           NUMBER (10)   NOT NULL, 
  MAML_ID                     NUMBER (10), 
  MODEL_NAME                  VARCHAR2 (50), 
  VERSION                     VARCHAR2 (15), 
  CONTACT_ID                  NUMBER (10), 
  PROTOCOL_ID                 NUMBER (10), 
  PUBLICATION_ID              NUMBER (10), 
  SURFACE_TYPE                VARCHAR2 (25)  NOT NULL, 
  SURFACE_TYPE_NAME           VARCHAR2 (30), 
  NUMBER_OF_ELEMENTS          NUMBER (10), 
  SHORT_AXIS_LENGTH           VARCHAR2 (10), 
  LONG_AXIS_LENGTH            VARCHAR2 (10), 
  ARRAY_PLATFORM_URI          VARCHAR2 (80), 
  DB_XREF_ID                  NUMBER (10), 
  ARRAY_PLATFORM_DESCRIPTION  LONG, 
  CONSTRAINT PK20
  PRIMARY KEY ( ARRAY_PLATFORM_ID ) ) ; 

CREATE TABLE ARRAY_PLATFORM_PARAMETERS ( 
  PARAMETER_ID       NUMBER (10)   NOT NULL, 
  ARRAY_PLATFORM_ID  NUMBER (10), 
  CONSTRAINT PK82
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE ASCII_DATA_EXTERNAL ( 
  ASCII_DATA_EXTERNAL_ID        NUMBER (10)   NOT NULL, 
  DATA_SET_ID                   NUMBER (10), 
  ASCII_DATA_EXTERNAL_FILE_URI  VARCHAR2 (80), 
  CONSTRAINT PK68
  PRIMARY KEY ( ASCII_DATA_EXTERNAL_ID ) ) ; 

CREATE TABLE ASCII_DATA_INTERNAL ( 
  ASCII_DATA_INTERNAL_ID  NUMBER (10)   NOT NULL, 
  DATA_SET_ID             NUMBER (10), 
  ASCII_DATA_INTERNAL     LONG, 
  CONSTRAINT PK67
  PRIMARY KEY ( ASCII_DATA_INTERNAL_ID ) ) ; 

CREATE TABLE BINARY_DATA_EXTERNAL ( 
  BINARY_DATA_EXTERNAL_ID        NUMBER (10)   NOT NULL, 
  DATA_SET_ID                    NUMBER (10), 
  BINARY_DATA_EXTERNAL_FILE_URI  VARCHAR2 (80), 
  CONSTRAINT PK69
  PRIMARY KEY ( BINARY_DATA_EXTERNAL_ID ) ) ; 

CREATE TABLE BIOLOGY_DESCRIPTION ( 
  BIOLOGY_DESCRIPTION_ID  NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID       NUMBER (10), 
  BIOLOGY_DESCRIPTION     LONG, 
  CONSTRAINT PK41
  PRIMARY KEY ( BIOLOGY_DESCRIPTION_ID ) ) ; 

CREATE TABLE CITATION ( 
  CITATION_ID   NUMBER (10)   NOT NULL, 
  JOURNAL       VARCHAR2 (80), 
  YEAR          VARCHAR2 (4), 
  VOLUME        VARCHAR2 (15), 
  ISSUE         VARCHAR2 (15), 
  PAGE          VARCHAR2 (5), 
  AUTHORS       VARCHAR2 (100), 
  PUBLISHER     VARCHAR2 (50), 
  EDITOR        VARCHAR2 (50), 
  CITATION_URI  VARCHAR2 (80), 
  CONSTRAINT PK70
  PRIMARY KEY ( CITATION_ID ) ) ; 

CREATE TABLE CLONE ( 
  CLONE_ID               NUMBER        NOT NULL, 
  ARRAY_ELEMENT_ID       NUMBER (10), 
  CLONE_NAME             VARCHAR2 (50), 
  CLONE_DESCRIPTION      LONG, 
  ACTUAL_SEQUENCE_ID     NUMBER (10), 
  REFERENCE_SEQUENCE_ID  NUMBER (10), 
  CONSTRAINT PK28
  PRIMARY KEY ( CLONE_ID ) ) ; 

CREATE TABLE CLONE_DB_XREFS ( 
  DB_XREF_ID  NUMBER (10)   NOT NULL, 
  CLONE_ID    NUMBER, 
  CONSTRAINT PK86
  PRIMARY KEY ( DB_XREF_ID ) ) ; 

CREATE TABLE COMPOSITE_ELEMENT ( 
  COMPOSITE_ELEMENT_ID    NUMBER (10)   NOT NULL, 
  MAML_ID                 NUMBER (10), 
  COMPOSITE_ELEMENT_NAME  VARCHAR2 (50), 
  PROTOCOL_ID             NUMBER (10), 
  CONSTRAINT PK59
  PRIMARY KEY ( COMPOSITE_ELEMENT_ID ) ) ; 

CREATE TABLE COMPOSITE_IMAGE ( 
  COMPOSITE_IMAGE_ID    NUMBER (10)   NOT NULL, 
  MAML_ID               NUMBER (10), 
  COMPOSITE_IMAGE_NAME  VARCHAR2 (50), 
  PROTOCOL_ID           NUMBER (10), 
  CONSTRAINT PK58
  PRIMARY KEY ( COMPOSITE_IMAGE_ID ) ) ; 

CREATE TABLE COMPOSITE_QUANTITATION ( 
  COMPOSITE_QUANTITATION_ID    NUMBER (10)   NOT NULL, 
  MAML_ID                      NUMBER (10), 
  COMPOSITE_QUANTITATION_NAME  VARCHAR2 (50), 
  PROTOCOL_ID                  NUMBER (10), 
  CONSTRAINT PK57
  PRIMARY KEY ( COMPOSITE_QUANTITATION_ID ) ) ; 

CREATE TABLE COMP_ELEM_ARRAY_ELEM ( 
  ARRAY_ELEMENT_ID      NUMBER (10)   NOT NULL, 
  COMPOSITE_ELEMENT_ID  NUMBER (10), 
  CONSTRAINT PK103
  PRIMARY KEY ( ARRAY_ELEMENT_ID ) ) ; 

CREATE TABLE COMP_IMAGE_IMAGES ( 
  IMAGE_ID            NUMBER (10)   NOT NULL, 
  COMPOSITE_IMAGE_ID  NUMBER (10), 
  CONSTRAINT PK102
  PRIMARY KEY ( IMAGE_ID ) ) ; 

CREATE TABLE COMP_QUAN_QUANTITATION_IDS ( 
  QUANTITATION_ID            NUMBER (10)   NOT NULL, 
  COMPOSITE_QUANTITATION_ID  NUMBER (10), 
  CONSTRAINT PK101
  PRIMARY KEY ( QUANTITATION_ID ) ) ; 

CREATE TABLE CONTACT ( 
  CONTACT_ID      NUMBER (10)   NOT NULL, 
  MAML_ID         NUMBER (10), 
  LAST_NAME       VARCHAR2 (25), 
  FIRST_NAME      VARCHAR2 (25), 
  MIDDLE_NAME     VARCHAR2 (25), 
  CONTACT_TYPE    VARCHAR2 (25)  NOT NULL, 
  LAB             VARCHAR2 (50), 
  DEPARTMENT      VARCHAR2 (25), 
  ORGANIZATION    VARCHAR2 (25), 
  STREET          VARCHAR2 (25), 
  CITY            VARCHAR2 (25), 
  PROVINCE_STATE  VARCHAR2 (25), 
  COUNTRY         VARCHAR2 (25), 
  POSTAL_CODE     VARCHAR2 (10), 
  PHONE           VARCHAR2 (15), 
  FAX             VARCHAR2 (15), 
  EMAIL           VARCHAR2 (80), 
  CONTACT_URI     VARCHAR2 (80), 
  CONSTRAINT PK13
  PRIMARY KEY ( CONTACT_ID ) ) ; 

CREATE TABLE CONTACT_PARAMETERS ( 
  PARAMETER_ID  NUMBER (10)   NOT NULL, 
  CONTACT_ID    NUMBER (10), 
  CONSTRAINT PK72
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE CONTROL_ELEMENT ( 
  CONTROL_ELEMENT_ID  NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID   NUMBER (10), 
  EXPECTED_VALUE      VARCHAR2 (100), 
  QUANTITATION_ID     NUMBER (10), 
  ARRAY_ELEMENT_ID    NUMBER (10), 
  CONSTRAINT PK49
  PRIMARY KEY ( CONTROL_ELEMENT_ID ) ) ; 

CREATE TABLE CREATION_INFO ( 
  CREATION_INFO_ID  NUMBER (10)   NOT NULL, 
  MAML_ID           NUMBER (10), 
  DATE_ISO          DATE, 
  CONTACT_ID        NUMBER (10), 
  SOFTWARE_ID       NUMBER (10), 
  CONSTRAINT PK7
  PRIMARY KEY ( CREATION_INFO_ID ) ) ; 

CREATE TABLE DATA_SET ( 
  DATA_SET_ID    NUMBER (10)   NOT NULL, 
  MAML_ID        NUMBER (10), 
  DATA_SET_NAME  VARCHAR2 (50), 
  SYNOPSIS       VARCHAR2 (100), 
  CONSTRAINT PK11
  PRIMARY KEY ( DATA_SET_ID ) ) ; 

CREATE TABLE DB_XREF ( 
  DB_XREF_ID         NUMBER (10)   NOT NULL, 
  DATABASE_NAME      VARCHAR2 (50), 
  DATABASE_VERSION   VARCHAR2 (25), 
  XREF_DATE_ISO      DATE, 
  ACCESSION          CHAR (50), 
  ACCESSION_VERSION  VARCHAR2 (15), 
  DB_XREF_URI        VARCHAR2 (80), 
  CONSTRAINT PK80
  PRIMARY KEY ( DB_XREF_ID ) ) ; 

CREATE TABLE DB_XREF_PARAMETERS ( 
  PARAMETER_ID  NUMBER (10)   NOT NULL, 
  DB_XREF_ID    NUMBER (10), 
  CONSTRAINT PK81
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE DERIVED_SAMPLE ( 
  DERIVED_SAMPLE_ID  NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID  NUMBER (10), 
  SAMPLE_LIST_ID     NUMBER (10), 
  CONSTRAINT PK51
  PRIMARY KEY ( DERIVED_SAMPLE_ID ) ) ; 

CREATE TABLE EXPERIMENTAL_FACTORS ( 
  EXPERIMENTAL_FACTORS_ID  NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID        NUMBER (10), 
  EXPERIMENTAL_FACTORS     LONG, 
  CONSTRAINT PK43
  PRIMARY KEY ( EXPERIMENTAL_FACTORS_ID ) ) ; 

CREATE TABLE EXPERIMENT_SET ( 
  EXPERIMENT_SET_ID    NUMBER (10)   NOT NULL, 
  MAML_ID              NUMBER (10), 
  EXPERIMENT_SET_TYPE  VARCHAR2 (20)  NOT NULL, 
  PUBLICATION_ID       NUMBER (10), 
  CONTACT_ID           NUMBER (10), 
  DB_XREF_ID           NUMBER (10), 
  CONSTRAINT PK34
  PRIMARY KEY ( EXPERIMENT_SET_ID ) ) ; 

CREATE TABLE EXPERIMENT_SET_PARAMETERS ( 
  PARAMETER_ID       NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID  NUMBER (10), 
  CONSTRAINT PK88
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE EXTRACT ( 
  EXTRACT_ID           NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID    NUMBER (10), 
  EXTRACT_NAME         VARCHAR2 (50), 
  EXTRACT_TYPE         VARCHAR2 (15)  NOT NULL, 
  PROTOCOL_ID          NUMBER (10), 
  EXTRACT_DESCRIPTION  LONG, 
  CONSTRAINT PK36
  PRIMARY KEY ( EXTRACT_ID ) ) ; 

CREATE TABLE EXTRACT_PARAMETERS ( 
  PARAMETER_ID  NUMBER (10)   NOT NULL, 
  EXTRACT_ID    NUMBER (10), 
  CONSTRAINT PK97
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE EXTRACT_SAMPLE_IDS ( 
  SAMPLE_LIST_ID  NUMBER (10)   NOT NULL, 
  EXTRACT_ID      NUMBER (10), 
  CONSTRAINT PK98
  PRIMARY KEY ( SAMPLE_LIST_ID ) ) ; 

CREATE TABLE GENE ( 
  GENE_ID                NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_ID       NUMBER (10), 
  GENE_NAME              VARCHAR2 (80), 
  GENE_DESCRIPTION       LONG, 
  ACTUAL_SEQUENCE_ID     NUMBER (10), 
  REFERENCE_SEQUENCE_ID  NUMBER (10), 
  CONSTRAINT PK29
  PRIMARY KEY ( GENE_ID ) ) ; 

CREATE TABLE GENE_DB_XREFS ( 
  DB_XREF_ID  NUMBER (10)   NOT NULL, 
  GENE_ID     NUMBER (10), 
  CONSTRAINT PK87
  PRIMARY KEY ( DB_XREF_ID ) ) ; 

CREATE TABLE GENE_EXPRESSION ( 
  MAML_ID  NUMBER (10)   NOT NULL, 
  CONSTRAINT PK1
  PRIMARY KEY ( MAML_ID ) ) ; 

CREATE TABLE HARDWARE ( 
  HARDWARE_ID           NUMBER (10)   NOT NULL, 
  MAML_ID               NUMBER (10), 
  CONTACT_ID            NUMBER (10), 
  HARDWARE_TYPE         CHAR (25), 
  MAKE                  CHAR (25), 
  MODEL                 CHAR (25), 
  SERIAL_NUMBER         CHAR (25), 
  HARDWARE_YEAR         CHAR (4), 
  HARDWARE_URI          CHAR (80), 
  HARDWARE_DESCRIPTION  LONG, 
  CONSTRAINT PK14
  PRIMARY KEY ( HARDWARE_ID ) ) ; 

CREATE TABLE HARDWARE_PARAMETERS ( 
  PARAMETER_ID  NUMBER (10)   NOT NULL, 
  HARDWARE_ID   NUMBER (10), 
  CONSTRAINT PK75
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE HYBRIDIZATION ( 
  HYBRIDIZATION_ID    NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID   NUMBER (10), 
  HYBRIDIZATION_NAME  VARCHAR2 (25), 
  CONSTRAINT PK47
  PRIMARY KEY ( HYBRIDIZATION_ID ) ) ; 

CREATE TABLE HYBRIDIZATION_ARRAY_PLATFORM ( 
  ARRAY_PLATFORM_ID  NUMBER (10)   NOT NULL, 
  HYBRIDIZATION_ID   NUMBER (10), 
  CONSTRAINT PK92
  PRIMARY KEY ( ARRAY_PLATFORM_ID ) ) ; 

CREATE TABLE HYBRIDIZATION_CONTROL_ELEMENT ( 
  CONTROL_ELEMENT_ID  NUMBER (10)   NOT NULL, 
  HYBRIDIZATION_ID    NUMBER (10), 
  CONSTRAINT PK91
  PRIMARY KEY ( CONTROL_ELEMENT_ID ) ) ; 

CREATE TABLE HYBRIDIZATION_LABELED_EXTRACT ( 
  LABELED_EXTRACT_ID  NUMBER (10)   NOT NULL, 
  HYBRIDIZATION_ID    NUMBER (10), 
  CONSTRAINT PK90
  PRIMARY KEY ( LABELED_EXTRACT_ID ) ) ; 

CREATE TABLE HYBRIDIZATION_PROTOCOL ( 
  PROTOCOL_ID       NUMBER (10)   NOT NULL, 
  HYBRIDIZATION_ID  NUMBER (10), 
  CONSTRAINT PK89
  PRIMARY KEY ( PROTOCOL_ID ) ) ; 

CREATE TABLE IMAGE ( 
  IMAGE_ID           NUMBER (10)   NOT NULL, 
  HYBRIDIZATION_ID   NUMBER (10), 
  PROTOCOL_ID        NUMBER (10), 
  IMAGE_FILE_URI     VARCHAR2 (80)  NOT NULL, 
  FILE_HEADER        VARCHAR2 (50), 
  MICRONS_PER_PIXEL  NUMBER (10), 
  CONSTRAINT PK48
  PRIMARY KEY ( IMAGE_ID ) ) ; 

CREATE TABLE IUPAC_SEQUENCE ( 
  IUPAC_SEQUENCE_ID  NUMBER (10)   NOT NULL, 
  IUPAC_SEQUENCE     LONG, 
  CONSTRAINT PK32
  PRIMARY KEY ( IUPAC_SEQUENCE_ID ) ) ; 

CREATE TABLE LABELED_EXTRACT ( 
  LABELED_EXTRACT_ID           NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID            NUMBER (10), 
  LABEL_NAME                   VARCHAR2 (10)  NOT NULL, 
  PROTOCOL_ID                  NUMBER (10), 
  EXTRACT_ID                   NUMBER (10), 
  LABELED_EXTRACT_DESCRIPTION  LONG, 
  CONSTRAINT PK39
  PRIMARY KEY ( LABELED_EXTRACT_ID ) ) ; 

CREATE TABLE LABELED_EXTRACT_PARAMETERS ( 
  PARAMETER_ID        NUMBER (10)   NOT NULL, 
  LABELED_EXTRACT_ID  NUMBER (10), 
  CONSTRAINT PK100
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE MATRIX ( 
  MATRIX_ID         NUMBER (10)   NOT NULL, 
  DATA_SET_ID       NUMBER (10), 
  ARRAY_ELEMENT_ID  NUMBER (10), 
  IMAGE_ID          NUMBER (10), 
  QUANTITATION_ID   NUMBER (10), 
  CONSTRAINT PK66
  PRIMARY KEY ( MATRIX_ID ) ) ; 

CREATE TABLE MATRIX_COLUMN ( 
  MATRIX_COLUMN_ID      NUMBER (10)   NOT NULL, 
  DATA_SET_ID           NUMBER (10), 
  MATRIX_COLUMN_NUMBER  NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_ID      NUMBER (10), 
  IMAGE_ID              NUMBER (10), 
  QUANTITATION_ID       NUMBER (10), 
  CONSTRAINT PK65
  PRIMARY KEY ( MATRIX_COLUMN_ID ) ) ; 

CREATE TABLE MATRIX_ROW ( 
  MATRIX_ROW_ID      NUMBER (10)   NOT NULL, 
  DATA_SET_ID        NUMBER (10), 
  MATRIX_ROW_NUMBER  NUMBER        NOT NULL, 
  ARRAY_ELEMENT_ID   NUMBER (10), 
  IMAGE_ID           NUMBER (10), 
  QUANTITATION_ID    NUMBER (10), 
  CONSTRAINT PK64
  PRIMARY KEY ( MATRIX_ROW_ID ) ) ; 

CREATE TABLE MEASUREMENT ( 
  MEASUREMENT_ID            NUMBER (10)   NOT NULL, 
  MEASUREMENT_ELEMENT_TYPE  VARCHAR2 (20)  NOT NULL, 
  MEASUREMENT_TYPE          VARCHAR2 (10), 
  MEASUREMENT_NAME          VARCHAR2 (25), 
  MEASUREMENT_VALUE         CHAR (25)     NOT NULL, 
  UNIT                      VARCHAR2 (15)  NOT NULL, 
  VECTOR_AXIS_NAME          VARCHAR2 (25), 
  CONSTRAINT PK31
  PRIMARY KEY ( MEASUREMENT_ID ) ) ; 

CREATE TABLE OLIGO_SEQUENCE ( 
  OLIGO_SEQUENCE_ID  NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_ID   NUMBER (10), 
  OLIGO_SEQUENCE     LONG, 
  CONSTRAINT PK27
  PRIMARY KEY ( OLIGO_SEQUENCE_ID ) ) ; 

CREATE TABLE PARAMETER ( 
  PARAMETER_ID     NUMBER (10)   NOT NULL, 
  PARAMETER_VALUE  CHAR (40), 
  PARAMETER_NAME   CHAR (20), 
  CONSTRAINT PK74
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE PARENT_SAMPLE_IDS ( 
  PRIMARY_SAMPLE_ID  NUMBER (10)   NOT NULL, 
  DERIVED_SAMPLE_ID  NUMBER (10), 
  CONSTRAINT PK95
  PRIMARY KEY ( PRIMARY_SAMPLE_ID ) ) ; 

CREATE TABLE PRIMARY_SAMPLE ( 
  PRIMARY_SAMPLE_ID  NUMBER (10)   NOT NULL, 
  ORGANISM_NCBI      VARCHAR2 (50), 
  ORGANISM_OTHER     VARCHAR2 (100), 
  CELL_SOURCE        VARCHAR2 (50), 
  CELL_TYPE          VARCHAR2 (50), 
  SEX                VARCHAR2 (1), 
  MATING_TYPE        VARCHAR2 (20), 
  AGE                VARCHAR2 (15), 
  DEVELOPMENT_STAGE  VARCHAR2 (40), 
  TISSUE             VARCHAR2 (50), 
  STRAIN             VARCHAR2 (50), 
  CULTIVAR           VARCHAR2 (50), 
  GENOTYPE           VARCHAR2 (50), 
  INDIVIDUAL         VARCHAR2 (50), 
  DISEASE_STATE      VARCHAR2 (50), 
  CELL_LINE          VARCHAR2 (50), 
  SAMPLE_LIST_ID     NUMBER (10), 
  CONSTRAINT PK50
  PRIMARY KEY ( PRIMARY_SAMPLE_ID ) ) ; 

CREATE TABLE PRIMARY_SAMPLE_MEASUREMENTS ( 
  MEASUREMENT_ID     NUMBER (10)   NOT NULL, 
  PRIMARY_SAMPLE_ID  NUMBER (10), 
  CONSTRAINT PK94
  PRIMARY KEY ( MEASUREMENT_ID ) ) ; 

CREATE TABLE PRIMARY_SAMPLE_PARAMETERS ( 
  PARAMETER_ID       NUMBER (10)   NOT NULL, 
  PRIMARY_SAMPLE_ID  NUMBER (10), 
  CONSTRAINT PK93
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE PROTOCOL ( 
  PROTOCOL_ID    NUMBER (10)   NOT NULL, 
  MAML_ID        NUMBER (10), 
  PROTOCOL_NAME  VARCHAR2 (25), 
  PROTOCOL_TYPE  VARCHAR2 (25)  NOT NULL, 
  DB_XREF_ID     NUMBER (10), 
  CONSTRAINT PK16
  PRIMARY KEY ( PROTOCOL_ID ) ) ; 

CREATE TABLE PROTOCOL_ABSTRACTS ( 
  PROTOCOL_ABSTRACT_ID  NUMBER (10)   NOT NULL, 
  PROTOCOL_ID           NUMBER (10), 
  PROTOCOL_ABSTRACT     LONG, 
  CONSTRAINT PK19
  PRIMARY KEY ( PROTOCOL_ABSTRACT_ID ) ) ; 

CREATE TABLE PROTOCOL_DEVIATIONS ( 
  PROTOCOL_DEVIATIONS_ID  NUMBER (10)   NOT NULL, 
  PROTOCOL_ID             NUMBER (10), 
  PROTOCOL_DEVIATIONS     LONG, 
  CONSTRAINT PK18
  PRIMARY KEY ( PROTOCOL_DEVIATIONS_ID ) ) ; 

CREATE TABLE PROTOCOL_HARDWARE ( 
  HARDWARE_ID  NUMBER (10)   NOT NULL, 
  PROTOCOL_ID  NUMBER (10), 
  CONSTRAINT PK78
  PRIMARY KEY ( HARDWARE_ID ) ) ; 

CREATE TABLE PROTOCOL_SOFTWARE ( 
  SOFTWARE_ID  NUMBER (10)   NOT NULL, 
  PROTOCOL_ID  NUMBER (10), 
  CONSTRAINT PK79
  PRIMARY KEY ( SOFTWARE_ID ) ) ; 

CREATE TABLE PUBLICATION ( 
  PUBLICATION_ID  NUMBER (10)   NOT NULL, 
  MAML_ID         NUMBER (10), 
  CITATION_ID     NUMBER (10), 
  DB_XREF_ID      NUMBER (10), 
  CONSTRAINT PK8
  PRIMARY KEY ( PUBLICATION_ID ) ) ; 

CREATE TABLE QUALITY ( 
  QUALITY_ID         NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID  NUMBER (10), 
  HAS_REPLICATES     VARCHAR2 (1), 
  PEER_REVIEWED      VARCHAR2 (1), 
  CONSTRAINT PK44
  PRIMARY KEY ( QUALITY_ID ) ) ; 

CREATE TABLE QUALITY_INFO ( 
  QUALITY_INFO_ID  NUMBER (10)   NOT NULL, 
  QUALITY_ID       NUMBER (10), 
  QUALITY_INFO     LONG, 
  CONSTRAINT PK45
  PRIMARY KEY ( QUALITY_INFO_ID ) ) ; 

CREATE TABLE QUANTITATION ( 
  QUANTITATION_ID    NUMBER (10)   NOT NULL, 
  MAML_ID            NUMBER (10), 
  QUANTITATION_NAME  VARCHAR2 (50), 
  PROTOCOL_ID        NUMBER (10), 
  CONSTRAINT PK56
  PRIMARY KEY ( QUANTITATION_ID ) ) ; 

CREATE TABLE REFERENCE_SEQUENCE ( 
  REFERENCE_SEQUENCE_ID      NUMBER (10)   NOT NULL, 
  ARRAY_ELEMENT_ID           NUMBER (10), 
  IUPAC_SEQUENCE_ID          NUMBER (10), 
  DB_XREF_ID                 NUMBER (10), 
  REFERENCE_SEQUENCE_NAME    VARCHAR2 (30), 
  REFERENCE_SEQUENCE_TYPE    VARCHAR2 (15)  NOT NULL, 
  REFERENCE_SEQUENCE_LENGTH  NUMBER (10), 
  REFERENCE_SEQUENCE_START   VARCHAR2 (10), 
  REFERENCE_SEQUENCE_STOP    VARCHAR2 (10), 
  CONSTRAINT PK26
  PRIMARY KEY ( REFERENCE_SEQUENCE_ID ) ) ; 

CREATE TABLE REPLICATE_INFO ( 
  REPLICATE_INFO_ID  NUMBER (10)   NOT NULL, 
  QUALITY_ID         NUMBER (10), 
  REPLICATE_INFO     LONG, 
  CONSTRAINT PK46
  PRIMARY KEY ( REPLICATE_INFO_ID ) ) ; 

CREATE TABLE SAMPLE_LIST ( 
  SAMPLE_LIST_ID     NUMBER (10)   NOT NULL, 
  EXPERIMENT_SET_ID  NUMBER (10), 
  CONSTRAINT PK99
  PRIMARY KEY ( SAMPLE_LIST_ID ) ) ; 

CREATE TABLE SOFTWARE ( 
  SOFTWARE_ID           NUMBER (10)   NOT NULL, 
  MAML_ID               NUMBER (10), 
  CONTACT_ID            NUMBER (10), 
  SOFTWARE_TYPE         VARCHAR2 (25)  NOT NULL, 
  SOFTWARE_NAME         VARCHAR2 (25), 
  VERSION               VARCHAR2 (25), 
  SOFTWARE_YEAR         VARCHAR2 (4), 
  OPERATING_SYSTEM      VARCHAR2 (25), 
  SOFTWARE_URI          VARCHAR2 (80), 
  SOFTWARE_DESCRIPTION  LONG, 
  CONSTRAINT PK15
  PRIMARY KEY ( SOFTWARE_ID ) ) ; 

CREATE TABLE SOFTWARE_HARDWARE ( 
  HARDWARE_ID  NUMBER (10)   NOT NULL, 
  SOFTWARE_ID  NUMBER (10), 
  CONSTRAINT PK76
  PRIMARY KEY ( HARDWARE_ID ) ) ; 

CREATE TABLE SOFTWARE_PARAMETERS ( 
  PARAMETER_ID  NUMBER (10)   NOT NULL, 
  SOFTWARE_ID   NUMBER (10), 
  CONSTRAINT PK77
  PRIMARY KEY ( PARAMETER_ID ) ) ; 

CREATE TABLE STANDARD_PROTOCOL ( 
  PROTOCOL_ID        NUMBER (10)   NOT NULL, 
  STANDARD_PROTOCOL  LONG, 
  CONSTRAINT PK17
  PRIMARY KEY ( PROTOCOL_ID ) ) ; 

CREATE TABLE TAGGED_DATA_EXTERNAL ( 
  TAGGED_DATA_EXTERNAL_ID        NUMBER (10)   NOT NULL, 
  DATA_SET_ID                    NUMBER (10), 
  TAGGED_DATA_EXTERNAL_FILE_URI  VARCHAR2 (80), 
  CONSTRAINT PK63
  PRIMARY KEY ( TAGGED_DATA_EXTERNAL_ID ) ) ; 

CREATE TABLE TAGGED_DATA_INTERNAL ( 
  TAGGED_DATA_INTERNAL_ID     NUMBER (10)   NOT NULL, 
  DATA_SET_ID                 NUMBER (10), 
  ARRAY_ELEMENT_ID            NUMBER (10), 
  IMAGE_ID                    NUMBER (10), 
  QUANTITATION_ID             NUMBER (10), 
  TAGGED_DATA_INTERNAL_VALUE  VARCHAR2 (50), 
  CONSTRAINT PK62
  PRIMARY KEY ( TAGGED_DATA_INTERNAL_ID ) ) ; 

CREATE TABLE TREATMENT ( 
  TREATMENT_ID       NUMBER (10)   NOT NULL, 
  DERIVED_SAMPLE_ID  NUMBER (10)   NOT NULL, 
  TREATMENT_ACTION   VARCHAR2 (100), 
  TREATMENT_ORDER    VARCHAR2 (50), 
  TREATMENT_OBJECT   VARCHAR2 (50), 
  PROTOCOL_ID        NUMBER (10), 
  CONSTRAINT PK53
  PRIMARY KEY ( TREATMENT_ID ) ) ; 

CREATE TABLE TREATMENT_MEASUREMENTS ( 
  MEASUREMENT_ID  NUMBER (10)   NOT NULL, 
  TREATMENT_ID    NUMBER (10), 
  CONSTRAINT PK96
  PRIMARY KEY ( MEASUREMENT_ID ) ) ; 

ALTER TABLE ABSTRACT ADD  CONSTRAINT REFCITATION92
 FOREIGN KEY (CITATION_ID) 
  REFERENCES DC.CITATION (CITATION_ID) ;

ALTER TABLE ACTUAL_SEQUENCE ADD  CONSTRAINT REFARRAY_ELEMENT34
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE ACTUAL_SEQUENCE ADD  CONSTRAINT REFDB_XREF139
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE ACTUAL_SEQUENCE ADD  CONSTRAINT REFIUPAC_SEQUENCE46
 FOREIGN KEY (IUPAC_SEQUENCE_ID) 
  REFERENCES DC.IUPAC_SEQUENCE (IUPAC_SEQUENCE_ID) ;

ALTER TABLE ANALYSIS_DESCRIPTION ADD  CONSTRAINT REFEXPERIMENT_SET62
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE ARRAY_ELEMENT_LIST ADD  CONSTRAINT REFARRAY_ELEMENT133
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE ARRAY_ELEMENT_LIST ADD  CONSTRAINT REFARRAY_PLATFORM134
 FOREIGN KEY (ARRAY_PLATFORM_ID) 
  REFERENCES DC.ARRAY_PLATFORM (ARRAY_PLATFORM_ID) ;

ALTER TABLE ARRAY_ELEMENT_LIST ADD  CONSTRAINT REFPROTOCOL132
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE ARRAY_ELEMENT_MEASUREMENTS ADD  CONSTRAINT REFARRAY_ELEMENT137
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE ARRAY_ELEMENT_MEASUREMENTS ADD  CONSTRAINT REFMEASUREMENT138
 FOREIGN KEY (MEASUREMENT_ID) 
  REFERENCES DC.MEASUREMENT (MEASUREMENT_ID) ;

ALTER TABLE ARRAY_ELEMENT_PARAMETERS ADD  CONSTRAINT REFARRAY_ELEMENT135
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE ARRAY_ELEMENT_PARAMETERS ADD  CONSTRAINT REFPARAMETER136
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE ARRAY_PLATFORM ADD  CONSTRAINT REFCONTACT125
 FOREIGN KEY (CONTACT_ID) 
  REFERENCES DC.CONTACT (CONTACT_ID) ;

ALTER TABLE ARRAY_PLATFORM ADD  CONSTRAINT REFDB_XREF128
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE ARRAY_PLATFORM ADD  CONSTRAINT REFGENE_EXPRESSION124
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE ARRAY_PLATFORM ADD  CONSTRAINT REFPROTOCOL126
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE ARRAY_PLATFORM ADD  CONSTRAINT REFPUBLICATION127
 FOREIGN KEY (PUBLICATION_ID) 
  REFERENCES DC.PUBLICATION (PUBLICATION_ID) ;

ALTER TABLE ARRAY_PLATFORM_PARAMETERS ADD  CONSTRAINT REFARRAY_PLATFORM130
 FOREIGN KEY (ARRAY_PLATFORM_ID) 
  REFERENCES DC.ARRAY_PLATFORM (ARRAY_PLATFORM_ID) ;

ALTER TABLE ARRAY_PLATFORM_PARAMETERS ADD  CONSTRAINT REFPARAMETER129
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE ASCII_DATA_EXTERNAL ADD  CONSTRAINT REFDATA_SET89
 FOREIGN KEY (DATA_SET_ID) 
  REFERENCES DC.DATA_SET (DATA_SET_ID) ;

ALTER TABLE ASCII_DATA_INTERNAL ADD  CONSTRAINT REFDATA_SET88
 FOREIGN KEY (DATA_SET_ID) 
  REFERENCES DC.DATA_SET (DATA_SET_ID) ;

ALTER TABLE BINARY_DATA_EXTERNAL ADD  CONSTRAINT REFDATA_SET90
 FOREIGN KEY (DATA_SET_ID) 
  REFERENCES DC.DATA_SET (DATA_SET_ID) ;

ALTER TABLE BIOLOGY_DESCRIPTION ADD  CONSTRAINT REFEXPERIMENT_SET61
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE CLONE ADD  CONSTRAINT REFACTUAL_SEQUENCE141
 FOREIGN KEY (ACTUAL_SEQUENCE_ID) 
  REFERENCES DC.ACTUAL_SEQUENCE (ACTUAL_SEQUENCE_ID) ;

ALTER TABLE CLONE ADD  CONSTRAINT REFARRAY_ELEMENT37
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE CLONE ADD  CONSTRAINT REFREFERENCE_SEQUENCE142
 FOREIGN KEY (REFERENCE_SEQUENCE_ID) 
  REFERENCES DC.REFERENCE_SEQUENCE (REFERENCE_SEQUENCE_ID) ;

ALTER TABLE CLONE_DB_XREFS ADD  CONSTRAINT REFCLONE143
 FOREIGN KEY (CLONE_ID) 
  REFERENCES DC.CLONE (CLONE_ID) ;

ALTER TABLE CLONE_DB_XREFS ADD  CONSTRAINT REFDB_XREF144
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE COMPOSITE_ELEMENT ADD  CONSTRAINT REFGENE_EXPRESSION190
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE COMPOSITE_ELEMENT ADD  CONSTRAINT REFPROTOCOL203
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE COMPOSITE_IMAGE ADD  CONSTRAINT REFGENE_EXPRESSION193
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE COMPOSITE_IMAGE ADD  CONSTRAINT REFPROTOCOL198
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE COMPOSITE_QUANTITATION ADD  CONSTRAINT REFGENE_EXPRESSION192
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE COMPOSITE_QUANTITATION ADD  CONSTRAINT REFPROTOCOL195
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE COMP_ELEM_ARRAY_ELEM ADD  CONSTRAINT REFARRAY_ELEMENT202
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE COMP_ELEM_ARRAY_ELEM ADD  CONSTRAINT REFCOMPOSITE_ELEMENT201
 FOREIGN KEY (COMPOSITE_ELEMENT_ID) 
  REFERENCES DC.COMPOSITE_ELEMENT (COMPOSITE_ELEMENT_ID) ;

ALTER TABLE COMP_IMAGE_IMAGES ADD  CONSTRAINT REFCOMPOSITE_IMAGE199
 FOREIGN KEY (COMPOSITE_IMAGE_ID) 
  REFERENCES DC.COMPOSITE_IMAGE (COMPOSITE_IMAGE_ID) ;

ALTER TABLE COMP_IMAGE_IMAGES ADD  CONSTRAINT REFIMAGE200
 FOREIGN KEY (IMAGE_ID) 
  REFERENCES DC.IMAGE (IMAGE_ID) ;

ALTER TABLE COMP_QUAN_QUANTITATION_IDS ADD  CONSTRAINT REFCOMPOSITE_QUANTITATION196
 FOREIGN KEY (COMPOSITE_QUANTITATION_ID) 
  REFERENCES DC.COMPOSITE_QUANTITATION (COMPOSITE_QUANTITATION_ID) ;

ALTER TABLE COMP_QUAN_QUANTITATION_IDS ADD  CONSTRAINT REFQUANTITATION197
 FOREIGN KEY (QUANTITATION_ID) 
  REFERENCES DC.QUANTITATION (QUANTITATION_ID) ;

ALTER TABLE CONTACT ADD  CONSTRAINT REFGENE_EXPRESSION93
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE CONTACT_PARAMETERS ADD  CONSTRAINT REFCONTACT94
 FOREIGN KEY (CONTACT_ID) 
  REFERENCES DC.CONTACT (CONTACT_ID) ;

ALTER TABLE CONTACT_PARAMETERS ADD  CONSTRAINT REFPARAMETER95
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE CONTROL_ELEMENT ADD  CONSTRAINT REFARRAY_ELEMENT167
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE CONTROL_ELEMENT ADD  CONSTRAINT REFEXPERIMENT_SET165
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE CONTROL_ELEMENT ADD  CONSTRAINT REFQUANTITATION166
 FOREIGN KEY (QUANTITATION_ID) 
  REFERENCES DC.QUANTITATION (QUANTITATION_ID) ;

ALTER TABLE CREATION_INFO ADD  CONSTRAINT REFCONTACT122
 FOREIGN KEY (CONTACT_ID) 
  REFERENCES DC.CONTACT (CONTACT_ID) ;

ALTER TABLE CREATION_INFO ADD  CONSTRAINT REFGENE_EXPRESSION13
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE CREATION_INFO ADD  CONSTRAINT REFSOFTWARE123
 FOREIGN KEY (SOFTWARE_ID) 
  REFERENCES DC.SOFTWARE (SOFTWARE_ID) ;

ALTER TABLE DATA_SET ADD  CONSTRAINT REFGENE_EXPRESSION17
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE DB_XREF_PARAMETERS ADD  CONSTRAINT REFDB_XREF121
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE DB_XREF_PARAMETERS ADD  CONSTRAINT REFPARAMETER120
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE DERIVED_SAMPLE ADD  CONSTRAINT REFEXPERIMENT_SET72
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE DERIVED_SAMPLE ADD  CONSTRAINT REFSAMPLE_LIST183
 FOREIGN KEY (SAMPLE_LIST_ID) 
  REFERENCES DC.SAMPLE_LIST (SAMPLE_LIST_ID) ;

ALTER TABLE EXPERIMENTAL_FACTORS ADD  CONSTRAINT REFEXPERIMENT_SET63
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE EXPERIMENT_SET ADD  CONSTRAINT REFCONTACT151
 FOREIGN KEY (CONTACT_ID) 
  REFERENCES DC.CONTACT (CONTACT_ID) ;

ALTER TABLE EXPERIMENT_SET ADD  CONSTRAINT REFDB_XREF152
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE EXPERIMENT_SET ADD  CONSTRAINT REFGENE_EXPRESSION149
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE EXPERIMENT_SET ADD  CONSTRAINT REFPUBLICATION150
 FOREIGN KEY (PUBLICATION_ID) 
  REFERENCES DC.PUBLICATION (PUBLICATION_ID) ;

ALTER TABLE EXPERIMENT_SET_PARAMETERS ADD  CONSTRAINT REFEXPERIMENT_SET153
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE EXPERIMENT_SET_PARAMETERS ADD  CONSTRAINT REFPARAMETER154
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE EXTRACT ADD  CONSTRAINT REFEXPERIMENT_SET51
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE EXTRACT ADD  CONSTRAINT REFPROTOCOL177
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE EXTRACT_PARAMETERS ADD  CONSTRAINT REFEXTRACT178
 FOREIGN KEY (EXTRACT_ID) 
  REFERENCES DC.EXTRACT (EXTRACT_ID) ;

ALTER TABLE EXTRACT_PARAMETERS ADD  CONSTRAINT REFPARAMETER180
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE EXTRACT_SAMPLE_IDS ADD  CONSTRAINT REFEXTRACT179
 FOREIGN KEY (EXTRACT_ID) 
  REFERENCES DC.EXTRACT (EXTRACT_ID) ;

ALTER TABLE EXTRACT_SAMPLE_IDS ADD  CONSTRAINT REFSAMPLE_LIST184
 FOREIGN KEY (SAMPLE_LIST_ID) 
  REFERENCES DC.SAMPLE_LIST (SAMPLE_LIST_ID) ;

ALTER TABLE GENE ADD  CONSTRAINT REFACTUAL_SEQUENCE145
 FOREIGN KEY (ACTUAL_SEQUENCE_ID) 
  REFERENCES DC.ACTUAL_SEQUENCE (ACTUAL_SEQUENCE_ID) ;

ALTER TABLE GENE ADD  CONSTRAINT REFARRAY_ELEMENT38
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE GENE ADD  CONSTRAINT REFREFERENCE_SEQUENCE146
 FOREIGN KEY (REFERENCE_SEQUENCE_ID) 
  REFERENCES DC.REFERENCE_SEQUENCE (REFERENCE_SEQUENCE_ID) ;

ALTER TABLE GENE_DB_XREFS ADD  CONSTRAINT REFDB_XREF148
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE GENE_DB_XREFS ADD  CONSTRAINT REFGENE147
 FOREIGN KEY (GENE_ID) 
  REFERENCES DC.GENE (GENE_ID) ;

ALTER TABLE HARDWARE ADD  CONSTRAINT REFCONTACT99
 FOREIGN KEY (CONTACT_ID) 
  REFERENCES DC.CONTACT (CONTACT_ID) ;

ALTER TABLE HARDWARE ADD  CONSTRAINT REFGENE_EXPRESSION96
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE HARDWARE_PARAMETERS ADD  CONSTRAINT REFHARDWARE97
 FOREIGN KEY (HARDWARE_ID) 
  REFERENCES DC.HARDWARE (HARDWARE_ID) ;

ALTER TABLE HARDWARE_PARAMETERS ADD  CONSTRAINT REFPARAMETER98
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE HYBRIDIZATION ADD  CONSTRAINT REFEXPERIMENT_SET74
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE HYBRIDIZATION_ARRAY_PLATFORM ADD  CONSTRAINT REFARRAY_PLATFORM163
 FOREIGN KEY (ARRAY_PLATFORM_ID) 
  REFERENCES DC.ARRAY_PLATFORM (ARRAY_PLATFORM_ID) ;

ALTER TABLE HYBRIDIZATION_ARRAY_PLATFORM ADD  CONSTRAINT REFHYBRIDIZATION155
 FOREIGN KEY (HYBRIDIZATION_ID) 
  REFERENCES DC.HYBRIDIZATION (HYBRIDIZATION_ID) ;

ALTER TABLE HYBRIDIZATION_CONTROL_ELEMENT ADD  CONSTRAINT REFCONTROL_ELEMENT162
 FOREIGN KEY (CONTROL_ELEMENT_ID) 
  REFERENCES DC.CONTROL_ELEMENT (CONTROL_ELEMENT_ID) ;

ALTER TABLE HYBRIDIZATION_CONTROL_ELEMENT ADD  CONSTRAINT REFHYBRIDIZATION157
 FOREIGN KEY (HYBRIDIZATION_ID) 
  REFERENCES DC.HYBRIDIZATION (HYBRIDIZATION_ID) ;

ALTER TABLE HYBRIDIZATION_LABELED_EXTRACT ADD  CONSTRAINT REFHYBRIDIZATION158
 FOREIGN KEY (HYBRIDIZATION_ID) 
  REFERENCES DC.HYBRIDIZATION (HYBRIDIZATION_ID) ;

ALTER TABLE HYBRIDIZATION_LABELED_EXTRACT ADD  CONSTRAINT REFLABELED_EXTRACT161
 FOREIGN KEY (LABELED_EXTRACT_ID) 
  REFERENCES DC.LABELED_EXTRACT (LABELED_EXTRACT_ID) ;

ALTER TABLE HYBRIDIZATION_PROTOCOL ADD  CONSTRAINT REFHYBRIDIZATION156
 FOREIGN KEY (HYBRIDIZATION_ID) 
  REFERENCES DC.HYBRIDIZATION (HYBRIDIZATION_ID) ;

ALTER TABLE HYBRIDIZATION_PROTOCOL ADD  CONSTRAINT REFPROTOCOL159
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE IMAGE ADD  CONSTRAINT REFHYBRIDIZATION75
 FOREIGN KEY (HYBRIDIZATION_ID) 
  REFERENCES DC.HYBRIDIZATION (HYBRIDIZATION_ID) ;

ALTER TABLE IMAGE ADD  CONSTRAINT REFPROTOCOL164
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE LABELED_EXTRACT ADD  CONSTRAINT REFEXPERIMENT_SET55
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE LABELED_EXTRACT ADD  CONSTRAINT REFEXTRACT186
 FOREIGN KEY (EXTRACT_ID) 
  REFERENCES DC.EXTRACT (EXTRACT_ID) ;

ALTER TABLE LABELED_EXTRACT ADD  CONSTRAINT REFPROTOCOL185
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE LABELED_EXTRACT_PARAMETERS ADD  CONSTRAINT REFLABELED_EXTRACT187
 FOREIGN KEY (LABELED_EXTRACT_ID) 
  REFERENCES DC.LABELED_EXTRACT (LABELED_EXTRACT_ID) ;

ALTER TABLE LABELED_EXTRACT_PARAMETERS ADD  CONSTRAINT REFPARAMETER188
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE MATRIX ADD  CONSTRAINT REFARRAY_ELEMENT216
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE MATRIX ADD  CONSTRAINT REFDATA_SET207
 FOREIGN KEY (DATA_SET_ID) 
  REFERENCES DC.DATA_SET (DATA_SET_ID) ;

ALTER TABLE MATRIX ADD  CONSTRAINT REFIMAGE217
 FOREIGN KEY (IMAGE_ID) 
  REFERENCES DC.IMAGE (IMAGE_ID) ;

ALTER TABLE MATRIX ADD  CONSTRAINT REFQUANTITATION218
 FOREIGN KEY (QUANTITATION_ID) 
  REFERENCES DC.QUANTITATION (QUANTITATION_ID) ;

ALTER TABLE MATRIX_COLUMN ADD  CONSTRAINT REFARRAY_ELEMENT212
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE MATRIX_COLUMN ADD  CONSTRAINT REFDATA_SET206
 FOREIGN KEY (DATA_SET_ID) 
  REFERENCES DC.DATA_SET (DATA_SET_ID) ;

ALTER TABLE MATRIX_COLUMN ADD  CONSTRAINT REFIMAGE213
 FOREIGN KEY (IMAGE_ID) 
  REFERENCES DC.IMAGE (IMAGE_ID) ;

ALTER TABLE MATRIX_COLUMN ADD  CONSTRAINT REFQUANTITATION214
 FOREIGN KEY (QUANTITATION_ID) 
  REFERENCES DC.QUANTITATION (QUANTITATION_ID) ;

ALTER TABLE MATRIX_ROW ADD  CONSTRAINT REFARRAY_ELEMENT209
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE MATRIX_ROW ADD  CONSTRAINT REFDATA_SET204
 FOREIGN KEY (DATA_SET_ID) 
  REFERENCES DC.DATA_SET (DATA_SET_ID) ;

ALTER TABLE MATRIX_ROW ADD  CONSTRAINT REFIMAGE210
 FOREIGN KEY (IMAGE_ID) 
  REFERENCES DC.IMAGE (IMAGE_ID) ;

ALTER TABLE MATRIX_ROW ADD  CONSTRAINT REFQUANTITATION211
 FOREIGN KEY (QUANTITATION_ID) 
  REFERENCES DC.QUANTITATION (QUANTITATION_ID) ;

ALTER TABLE OLIGO_SEQUENCE ADD  CONSTRAINT REFARRAY_ELEMENT36
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE PARENT_SAMPLE_IDS ADD  CONSTRAINT REFDERIVED_SAMPLE173
 FOREIGN KEY (DERIVED_SAMPLE_ID) 
  REFERENCES DC.DERIVED_SAMPLE (DERIVED_SAMPLE_ID) ;

ALTER TABLE PARENT_SAMPLE_IDS ADD  CONSTRAINT REFPRIMARY_SAMPLE172
 FOREIGN KEY (PRIMARY_SAMPLE_ID) 
  REFERENCES DC.PRIMARY_SAMPLE (PRIMARY_SAMPLE_ID) ;

ALTER TABLE PRIMARY_SAMPLE ADD  CONSTRAINT REFSAMPLE_LIST182
 FOREIGN KEY (SAMPLE_LIST_ID) 
  REFERENCES DC.SAMPLE_LIST (SAMPLE_LIST_ID) ;

ALTER TABLE PRIMARY_SAMPLE_MEASUREMENTS ADD  CONSTRAINT REFMEASUREMENT171
 FOREIGN KEY (MEASUREMENT_ID) 
  REFERENCES DC.MEASUREMENT (MEASUREMENT_ID) ;

ALTER TABLE PRIMARY_SAMPLE_MEASUREMENTS ADD  CONSTRAINT REFPRIMARY_SAMPLE169
 FOREIGN KEY (PRIMARY_SAMPLE_ID) 
  REFERENCES DC.PRIMARY_SAMPLE (PRIMARY_SAMPLE_ID) ;

ALTER TABLE PRIMARY_SAMPLE_PARAMETERS ADD  CONSTRAINT REFPARAMETER170
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE PRIMARY_SAMPLE_PARAMETERS ADD  CONSTRAINT REFPRIMARY_SAMPLE168
 FOREIGN KEY (PRIMARY_SAMPLE_ID) 
  REFERENCES DC.PRIMARY_SAMPLE (PRIMARY_SAMPLE_ID) ;

ALTER TABLE PROTOCOL ADD  CONSTRAINT REFDB_XREF119
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE PROTOCOL ADD  CONSTRAINT REFGENE_EXPRESSION109
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE PROTOCOL_ABSTRACTS ADD  CONSTRAINT REFPROTOCOL23
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE PROTOCOL_DEVIATIONS ADD  CONSTRAINT REFPROTOCOL22
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE PROTOCOL_HARDWARE ADD  CONSTRAINT REFHARDWARE116
 FOREIGN KEY (HARDWARE_ID) 
  REFERENCES DC.HARDWARE (HARDWARE_ID) ;

ALTER TABLE PROTOCOL_HARDWARE ADD  CONSTRAINT REFPROTOCOL112
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE PROTOCOL_SOFTWARE ADD  CONSTRAINT REFPROTOCOL114
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE PROTOCOL_SOFTWARE ADD  CONSTRAINT REFSOFTWARE118
 FOREIGN KEY (SOFTWARE_ID) 
  REFERENCES DC.SOFTWARE (SOFTWARE_ID) ;

ALTER TABLE PUBLICATION ADD  CONSTRAINT REFCITATION91
 FOREIGN KEY (CITATION_ID) 
  REFERENCES DC.CITATION (CITATION_ID) ;

ALTER TABLE PUBLICATION ADD  CONSTRAINT REFDB_XREF225
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE PUBLICATION ADD  CONSTRAINT REFGENE_EXPRESSION14
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE QUALITY ADD  CONSTRAINT REFEXPERIMENT_SET64
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE QUALITY_INFO ADD  CONSTRAINT REFQUALITY65
 FOREIGN KEY (QUALITY_ID) 
  REFERENCES DC.QUALITY (QUALITY_ID) ;

ALTER TABLE QUANTITATION ADD  CONSTRAINT REFGENE_EXPRESSION191
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE QUANTITATION ADD  CONSTRAINT REFPROTOCOL194
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE REFERENCE_SEQUENCE ADD  CONSTRAINT REFARRAY_ELEMENT35
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE REFERENCE_SEQUENCE ADD  CONSTRAINT REFDB_XREF140
 FOREIGN KEY (DB_XREF_ID) 
  REFERENCES DC.DB_XREF (DB_XREF_ID) ;

ALTER TABLE REFERENCE_SEQUENCE ADD  CONSTRAINT REFIUPAC_SEQUENCE47
 FOREIGN KEY (IUPAC_SEQUENCE_ID) 
  REFERENCES DC.IUPAC_SEQUENCE (IUPAC_SEQUENCE_ID) ;

ALTER TABLE REPLICATE_INFO ADD  CONSTRAINT REFQUALITY66
 FOREIGN KEY (QUALITY_ID) 
  REFERENCES DC.QUALITY (QUALITY_ID) ;

ALTER TABLE SAMPLE_LIST ADD  CONSTRAINT REFEXPERIMENT_SET181
 FOREIGN KEY (EXPERIMENT_SET_ID) 
  REFERENCES DC.EXPERIMENT_SET (EXPERIMENT_SET_ID) ;

ALTER TABLE SOFTWARE ADD  CONSTRAINT REFCONTACT101
 FOREIGN KEY (CONTACT_ID) 
  REFERENCES DC.CONTACT (CONTACT_ID) ;

ALTER TABLE SOFTWARE ADD  CONSTRAINT REFGENE_EXPRESSION100
 FOREIGN KEY (MAML_ID) 
  REFERENCES DC.GENE_EXPRESSION (MAML_ID) ;

ALTER TABLE SOFTWARE_HARDWARE ADD  CONSTRAINT REFHARDWARE117
 FOREIGN KEY (HARDWARE_ID) 
  REFERENCES DC.HARDWARE (HARDWARE_ID) ;

ALTER TABLE SOFTWARE_HARDWARE ADD  CONSTRAINT REFSOFTWARE105
 FOREIGN KEY (SOFTWARE_ID) 
  REFERENCES DC.SOFTWARE (SOFTWARE_ID) ;

ALTER TABLE SOFTWARE_PARAMETERS ADD  CONSTRAINT REFPARAMETER108
 FOREIGN KEY (PARAMETER_ID) 
  REFERENCES DC.PARAMETER (PARAMETER_ID) ;

ALTER TABLE SOFTWARE_PARAMETERS ADD  CONSTRAINT REFSOFTWARE107
 FOREIGN KEY (SOFTWARE_ID) 
  REFERENCES DC.SOFTWARE (SOFTWARE_ID) ;

ALTER TABLE STANDARD_PROTOCOL ADD  CONSTRAINT REFPROTOCOL21
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE TAGGED_DATA_EXTERNAL ADD  CONSTRAINT REFDATA_SET84
 FOREIGN KEY (DATA_SET_ID) 
  REFERENCES DC.DATA_SET (DATA_SET_ID) ;

ALTER TABLE TAGGED_DATA_INTERNAL ADD  CONSTRAINT REFARRAY_ELEMENT221
 FOREIGN KEY (ARRAY_ELEMENT_ID) 
  REFERENCES DC.ARRAY_ELEMENT (ARRAY_ELEMENT_ID) ;

ALTER TABLE TAGGED_DATA_INTERNAL ADD  CONSTRAINT REFDATA_SET83
 FOREIGN KEY (DATA_SET_ID) 
  REFERENCES DC.DATA_SET (DATA_SET_ID) ;

ALTER TABLE TAGGED_DATA_INTERNAL ADD  CONSTRAINT REFIMAGE222
 FOREIGN KEY (IMAGE_ID) 
  REFERENCES DC.IMAGE (IMAGE_ID) ;

ALTER TABLE TAGGED_DATA_INTERNAL ADD  CONSTRAINT REFQUANTITATION224
 FOREIGN KEY (QUANTITATION_ID) 
  REFERENCES DC.QUANTITATION (QUANTITATION_ID) ;

ALTER TABLE TREATMENT ADD  CONSTRAINT REFDERIVED_SAMPLE73
 FOREIGN KEY (DERIVED_SAMPLE_ID) 
  REFERENCES DC.DERIVED_SAMPLE (DERIVED_SAMPLE_ID) ;

ALTER TABLE TREATMENT ADD  CONSTRAINT REFPROTOCOL174
 FOREIGN KEY (PROTOCOL_ID) 
  REFERENCES DC.PROTOCOL (PROTOCOL_ID) ;

ALTER TABLE TREATMENT_MEASUREMENTS ADD  CONSTRAINT REFMEASUREMENT176
 FOREIGN KEY (MEASUREMENT_ID) 
  REFERENCES DC.MEASUREMENT (MEASUREMENT_ID) ;

ALTER TABLE TREATMENT_MEASUREMENTS ADD  CONSTRAINT REFTREATMENT175
 FOREIGN KEY (TREATMENT_ID) 
  REFERENCES DC.TREATMENT (TREATMENT_ID) ;

