
CREATE TABLE ACTIONPROTOCOLTYPE
(
  ACTION_ID         NUMBER                      NOT NULL,
  PROTOCOL_TYPE_ID  NUMBER                      NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AFFYBACKGROUND
(
  ID            NUMBER                          NOT NULL,
  BGND_AVG      FLOAT(126),
  BGND_STD      FLOAT(126),
  BGND_MIN      FLOAT(126),
  BGND_MAX      FLOAT(126),
  NOISE_AVG     FLOAT(126),
  NOISE_STD     FLOAT(126),
  NOISE_MIN     FLOAT(126),
  NOISE_MAX     FLOAT(126),
  CORNER_P_AVG  FLOAT(126),
  CORNER_P_CNT  NUMBER,
  CORNER_N_AVG  FLOAT(126),
  CORNER_N_CNT  NUMBER,
  CENTRAL_AVG   FLOAT(126),
  CENTRAL_CNT   NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AFFYCALLSUMMARY
(
  ID                  NUMBER                    NOT NULL,
  TOTALPROBESETS      NUMBER,
  NUMBERPRESENT       NUMBER,
  PERCENTAGEPRESENT   FLOAT(126),
  NUMBERABSENT        NUMBER,
  PERCENTAGEABSENT    FLOAT(126),
  NUMBERMARGINAL      NUMBER,
  PERCENTAGEMARGINAL  FLOAT(126),
  AVERAGESIGNALP      FLOAT(126),
  AVERAGESIGNALA      FLOAT(126),
  AVERAGESIGNALM      FLOAT(126),
  AVERAGESIGNALALL    FLOAT(126)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AFFYCONTROL
(
  ID            NUMBER                          NOT NULL,
  PROBESETNAME  VARCHAR2(100),
  SIG_3         FLOAT(126),
  SIG_5         FLOAT(126),
  SIG_M         FLOAT(126),
  SIG_ALL       FLOAT(126),
  SIG_3_5       FLOAT(126),
  DEC_3         VARCHAR2(100),
  DEC_5         VARCHAR2(100),
  DEC_M         VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AFFYHOUSEKEEPINGCONTROL
(
  PROBESETNAME  VARCHAR2(100),
  SIG_3         FLOAT(126),
  SIG_5         FLOAT(126),
  SIG_M         FLOAT(126),
  SIG_ALL       FLOAT(126),
  SIG_3_5       FLOAT(126),
  DEC_3         VARCHAR2(100),
  DEC_5         VARCHAR2(100),
  DEC_M         VARCHAR2(100),
  ID            NUMBER                          NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AFFYMETRIX
(
  ID              NUMBER                        NOT NULL,
  BACKGROUND_ID   NUMBER,
  CALLSUMMARY_ID  NUMBER,
  PROBEARRAYTYPE  VARCHAR2(100),
  ALGORITHM       VARCHAR2(100),
  PROBEPAIRTHR    NUMBER,
  CONTROLS        VARCHAR2(100),
  ALPHA1          FLOAT(126),
  ALPHA2          FLOAT(126),
  TAU             FLOAT(126),
  NOISE           FLOAT(126),
  SCALEFACTOR     FLOAT(126),
  TGTVALUE        FLOAT(126),
  NORMFACTOR      FLOAT(126),
  PROBEMASKFILE   VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AFFYSPIKECONTROL
(
  PROBESETNAME  VARCHAR2(100),
  SIG_3         FLOAT(126),
  SIG_5         FLOAT(126),
  SIG_M         FLOAT(126),
  SIG_ALL       FLOAT(126),
  SIG_3_5       FLOAT(126),
  DEC_3         VARCHAR2(100),
  DEC_5         VARCHAR2(100),
  DEC_M         VARCHAR2(100),
  ID            NUMBER                          NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AGILENT
(
  ID                          NUMBER            NOT NULL,
  ALLCOLORPRENTSAT            FLOAT(126),
  ANYCOLORPRCNTBGNONUNIFOL    FLOAT(126),
  ANYCOLORPRCNTBGPOPNOL       FLOAT(126),
  ANYCOLORPRCNTFEATPOPNOL     FLOAT(126),
  ANYCOLORPRENTFEATNONUNIFOL  FLOAT(126),
  ANYCOLORPRENTSAT            FLOAT(126),
  DYENORMDIMENSIONLESSRMS     FLOAT(126),
  DYENORMUNITWEIGHTEDRMS      FLOAT(126),
  GBGADJUST                   FLOAT(126),
  GDARKOFFSETAVERAGE          FLOAT(126),
  GDARKOFFSETMEDIAN           FLOAT(126),
  GDARKOFFSETNUMPTS           NUMBER,
  GDARKOFFSETSTDDEV           FLOAT(126),
  GGLOBALBGINLIERAVE          FLOAT(126),
  GGLOBALBGINLIERNUM          NUMBER,
  GGLOBALBGINLIERSDEV         FLOAT(126),
  GGLOBALFEATINLIERAVE        FLOAT(126),
  GGLOBALFEATINLIERNUM        FLOAT(126),
  GGLOBALFEATINLIERSDEV       FLOAT(126),
  GLINEARDYENORMFACTOR        FLOAT(126),
  GLOCALBGINLIERAVE           FLOAT(126),
  GLOCALBGINLIERNUM           NUMBER,
  GLOCALBGINLIERSDEV          FLOAT(126),
  GNEGCTRLSEQUSED             NUMBER,
  GNEGCTRLSIGLEVEL            FLOAT(126),
  GNUMFEATURENONUNIFOL        NUMBER,
  GNUMNEGBGSUBFEAT            NUMBER,
  GNUMNONUNIFBGOL             NUMBER,
  GNUMPOPNBGOL                NUMBER,
  GNUMPOPNOL                  NUMBER,
  GNUMSATFEAT                 NUMBER,
  GOFFSETUSED                 FLOAT(126),
  RBGADJUST                   FLOAT(126),
  RDARKOFFSETAVERAGE          FLOAT(126),
  RDARKOFFSETMEDIAN           FLOAT(126),
  RDARKOFFSETNUMPTS           NUMBER,
  RDARKOFFSETSTDDEV           FLOAT(126),
  RGLOBALBGINLIERAVE          FLOAT(126),
  RGLOBALBGINLIERNUM          NUMBER,
  RGLOBALBGINLIERSDEV         FLOAT(126),
  RGLOBALFEATINLIERAVE        FLOAT(126),
  RGLOBALFEATINLIERNUM        FLOAT(126),
  RGLOBALFEATINLIERSDEV       FLOAT(126),
  RLINEARDYENORMFACTOR        FLOAT(126),
  RLOCALBGINLIERAVE           FLOAT(126),
  RLOCALBGINLIERNUM           NUMBER,
  RLOCALBGINLIERSDEV          FLOAT(126),
  RNEGCTRLSEQUSED             NUMBER,
  RNEGCTRLSIGLEVEL            FLOAT(126),
  RNUMFEATURENONUNIFOL        NUMBER,
  RNUMNEGBGSUBFEAT            NUMBER,
  RNUMNONUNIFBGOL             NUMBER,
  RNUMPOPNBGOL                NUMBER,
  RNUMPOPNOL                  NUMBER,
  RNUMSATFEAT                 NUMBER,
  ROFFSETUSED                 FLOAT(126),
  TOTALPRCNTFEATOL            FLOAT(126)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ANALYSISRESULTS
(
  EXPERIMENT_ID             NUMBER              NOT NULL,
  BIOASSAY_DATA_CLUSTER_ID  NUMBER              NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE APPLICATIONPERFORMER
(
  PROTOCOL_APPLICATION_ID  NUMBER               NOT NULL,
  PERSON_ID                NUMBER               NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAY
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  IDENTIFIER            VARCHAR2(255)           NOT NULL,
  NAME                  VARCHAR2(100),
  ARRAY_DESIGN_ID       NUMBER,
  INFORMATION_ID        NUMBER,
  ARRAY_MANUFACTURE_ID  NUMBER,
  ARRAYIDENTIFIER       VARCHAR2(100),
  ARRAYXORIGIN          FLOAT(126),
  ARRAYYORIGIN          FLOAT(126),
  ORIGINRELATIVETO      VARCHAR2(100),
  ARRAY_GROUP_ID        NUMBER,
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYDESIGN
(
  ID                              NUMBER        NOT NULL,
  DESC_SECURITY_ID                NUMBER,
  IDENTIFIER                      VARCHAR2(255) NOT NULL,
  NAME                            VARCHAR2(100),
  VERSION                         VARCHAR2(24),
  NUMBEROFFEATURES                NUMBER,
  SURFACE_TYPE_ID                 NUMBER,
  OJBCONCRETECLASS                VARCHAR2(100),
  SECURED_ELEMENT_ID              VARCHAR2(100),
  REPORTERFILELOCATION            VARCHAR2(200),
  REPORTERFILETYPE                VARCHAR2(20),
  ADDITIONALREPORTERFILELOCATION  VARCHAR2(250),
  DELETED                         NUMBER        DEFAULT 0
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYDESIGNCOMPOSITEGRP
(
  ARRAY_DESIGN_ID     NUMBER                    NOT NULL,
  COMPOSITE_GROUP_ID  NUMBER                    NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYDESIGNFEATUREGRP
(
  ARRAY_DESIGN_ID   NUMBER                      NOT NULL,
  FEATURE_GROUP_ID  NUMBER                      NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYDESIGNPROVIDER
(
  ARRAY_DESIGN_ID  NUMBER                       NOT NULL,
  CONTACT_ID       NUMBER                       NOT NULL,
  ROLE_ID          NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYDESIGNREPORTERGRP
(
  ARRAY_DESIGN_ID    NUMBER                     NOT NULL,
  REPORTER_GROUP_ID  NUMBER                     NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYGROUP
(
  ID                       NUMBER               NOT NULL,
  DESC_SECURITY_ID         NUMBER,
  IDENTIFIER               VARCHAR2(255)        NOT NULL,
  NAME                     VARCHAR2(100),
  SUBSTRATE_TYPE_ID        NUMBER,
  DISTANCE_UNIT_ID         NUMBER,
  BARCODE                  VARCHAR2(100),
  ARRAYSPACINGX            FLOAT(126),
  ARRAYSPACINGY            FLOAT(126),
  NUMARRAYS                NUMBER,
  ORIENTATIONMARK          VARCHAR2(100),
  ORIENTATIONMARKPOSITION  VARCHAR2(100),
  WIDTH                    FLOAT(126),
  LENGTH                   FLOAT(126),
  SECURED_ELEMENT_ID       VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYMANUFACTURE
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  MANUFACTURINGDATE   DATE,
  TOLERANCE           FLOAT(126),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYMANUFACTUREDEVIATION
(
  ID                  NUMBER                    NOT NULL,
  ARRAY_ID            NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ARRAYMANUFACTURER
(
  ARRAY_MANUFACTURE_ID  NUMBER                  NOT NULL,
  CONTACT_ID            NUMBER                  NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_APPLICATION
(
  APPLICATION_ID    NUMBER                      NOT NULL,
  APPLICATION_NAME  VARCHAR2(100),
  APPLICATION_DESC  VARCHAR2(200),
  DECLARATIVE_FLAG  VARCHAR2(1),
  ACTIVE_FLAG       VARCHAR2(1),
  UPDATE_DATE       NUMBER                      NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_APPLICATION_PRIVILEGE
(
  UPDATE_DATE               NUMBER              NOT NULL,
  APPLICATION_ID            NUMBER              NOT NULL,
  PRIVILEGE_ID              NUMBER              NOT NULL,
  APPLICATION_PRIVILEGE_ID  NUMBER              NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_APP_PROTECTION_ELEMENT
(
  UPDATE_DATE                NUMBER             NOT NULL,
  APPLICATION_ID             NUMBER             NOT NULL,
  PROTECTION_ELEMENT_ID      NUMBER             NOT NULL,
  APP_PROTECTION_ELEMENT_ID  NUMBER             NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_APP_PROTECTION_GROUP
(
  UPDATE_DATE              NUMBER               NOT NULL,
  PROTECTION_GROUP_ID      NUMBER               NOT NULL,
  APPLICATION_ID           NUMBER               NOT NULL,
  APP_PROTECTION_GROUP_ID  NUMBER               NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_LOG
(
  TIMESTAMP                    NUMBER           NOT NULL,
  TABLE_NAME                   VARCHAR2(100)    NOT NULL,
  RECORD_ID                    NUMBER           NOT NULL,
  ACTION_TYPE                  VARCHAR2(1),
  ATTRIBUTE_NAME               VARCHAR2(80)     NOT NULL,
  OLD_VALUE                    VARCHAR2(1000),
  NEW_VALUE                    VARCHAR2(1000),
  LOG_ID                       NUMBER           NOT NULL,
  PROTECTION_GROUP_ID          NUMBER,
  ACTION_USER_ID               NUMBER           NOT NULL,
  PROTECTION_GROUP_ELEMENT_ID  NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_PRIVILEGE
(
  PRIVILEGE_ID    NUMBER                        NOT NULL,
  PRIVILEGE_NAME  VARCHAR2(100),
  PRIVILEGE_DESC  VARCHAR2(200),
  UPDATE_DATE     NUMBER                        NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_PROTECTION_ELEMENT
(
  PROTECTION_ELEMENT_ID    NUMBER               NOT NULL,
  OBJECT_ID                VARCHAR2(100)        NOT NULL,
  ATTRIBUTE                VARCHAR2(50),
  PROTECTION_ELEMENT_NAME  VARCHAR2(100),
  PROTECTION_ELEMENT_DESC  VARCHAR2(200),
  UPDATE_DATE              NUMBER               NOT NULL,
  USER_ID                  NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_PROTECTION_GROUP
(
  PROTECTION_GROUP_ID       NUMBER              NOT NULL,
  PROTECTION_GROUP_NAME     VARCHAR2(100),
  PROTECTION_GROUP_DESC     VARCHAR2(200),
  LARGE_ELEMENT_COUNT_FLAG  VARCHAR2(1),
  UPDATE_DATE               NUMBER              NOT NULL,
  PROTECTION_GROUP_TYPE_ID  NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_PROTECTION_GROUP_ELEMENT
(
  UPDATE_DATE                  NUMBER           NOT NULL,
  PROTECTION_GROUP_ID          NUMBER           NOT NULL,
  PROTECTION_ELEMENT_ID        NUMBER           NOT NULL,
  PROTECTION_GROUP_ELEMENT_ID  NUMBER           NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_PROTECTION_GROUP_TYPE
(
  PROTECTION_GROUP_TYPE_ID    NUMBER            NOT NULL,
  PROTECTION_GROUP_TYPE_DESC  VARCHAR2(200),
  UPDATE_DATE                 NUMBER            NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_PROTECTION_TYPE
(
  PROTECTION_TYPE_ID    NUMBER                  NOT NULL,
  PROTECTION_TYPE_NAME  VARCHAR2(100)           NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_ROLE
(
  ROLE_ID         NUMBER                        NOT NULL,
  ROLE_NAME       VARCHAR2(100),
  ROLE_DESC       VARCHAR2(200),
  ACTIVE_FLAG     VARCHAR2(1),
  UPDATE_DATE     NUMBER                        NOT NULL,
  APPLICATION_ID  NUMBER                        NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_ROLE_PRIVILEGE
(
  UPDATE_DATE     NUMBER                        NOT NULL,
  ROLE_ID         NUMBER                        NOT NULL,
  PRIVILEGE_ID    NUMBER                        NOT NULL,
  ROLE_PRIVILEGE  NUMBER                        NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_USER
(
  USER_ID       NUMBER                          NOT NULL,
  LOGIN_NAME    VARCHAR2(30),
  FIRST_NAME    VARCHAR2(35),
  LAST_NAME     VARCHAR2(35),
  TITLE         VARCHAR2(35),
  PHONE_NUMBER  VARCHAR2(15),
  EMAIL         VARCHAR2(70),
  ORGANIZATION  VARCHAR2(35),
  DEPT          VARCHAR2(35),
  LOCATION      VARCHAR2(35),
  UPDATE_DATE   NUMBER                          NOT NULL,
  START_DATE    NUMBER,
  PASSWORD      VARCHAR2(30),
  END_DATE      NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AS_USER_ROLE_PROTECT_APP
(
  URPA_ID                NUMBER                 NOT NULL,
  UPDATE_DATE            NUMBER                 NOT NULL,
  ROLE_ID                NUMBER                 NOT NULL,
  APPLICATION_ID         NUMBER                 NOT NULL,
  PROTECTION_GROUP_ID    NUMBER                 NOT NULL,
  USER_ID                NUMBER,
  PROTECTION_ELEMENT_ID  NUMBER,
  PROTECTION_TYPE_ID     NUMBER,
  START_DATE             NUMBER,
  END_DATE               NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE AUDIT_TBL
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  PERFORMER_ID        NUMBER,
  DESCRIBABLE_ID      NUMBER,
  AUDIT_DATE          DATE,
  ACTION              VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIBLIOGRAPHICREFERENCE
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  DESCRIPTION_ID      NUMBER,
  TITLE               VARCHAR2(100),
  AUTHORS             VARCHAR2(200),
  PUBLICATION         VARCHAR2(100),
  PUBLISHER           VARCHAR2(100),
  EDITOR              VARCHAR2(100),
  YEAR                DATE,
  VOLUME              VARCHAR2(100),
  ISSUE               VARCHAR2(50),
  PAGES               VARCHAR2(100),
  URI                 VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAY
(
  ID                     NUMBER                 NOT NULL,
  DESC_SECURITY_ID       NUMBER,
  IDENTIFIER             VARCHAR2(255)          NOT NULL,
  NAME                   VARCHAR2(100),
  TYPE_ID                NUMBER,
  FEATURE_EXTRACTION_ID  NUMBER,
  BIOASSAY_CREATION_ID   NUMBER,
  OJBCONCRETECLASS       VARCHAR2(100),
  SECURED_ELEMENT_ID     VARCHAR2(100),
  DELETED                NUMBER                 DEFAULT 0
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYCHANNEL
(
  BIOASSAY_ID  NUMBER                           NOT NULL,
  CHANNEL_ID   NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYCREATION
(
  ID                           NUMBER           NOT NULL,
  DESC_SECURITY_ID             NUMBER,
  IDENTIFIER                   VARCHAR2(255)    NOT NULL,
  NAME                         VARCHAR2(100),
  ARRAY_ID                     NUMBER,
  PHYSICAL_BIOASSAY_TARGET_ID  NUMBER,
  OJBCONCRETECLASS             VARCHAR2(100),
  SECURED_ELEMENT_ID           VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYDATA
(
  ID                              NUMBER        NOT NULL,
  DESC_SECURITY_ID                NUMBER,
  IDENTIFIER                      VARCHAR2(255) NOT NULL,
  NAME                            VARCHAR2(100),
  BIOASSAY_DIMENSION_ID           NUMBER,
  DESIGN_ELEMENT_DIMENSION_ID     NUMBER,
  QUANTITATION_TYPE_DIMENSION_ID  NUMBER,
  BIODATA_VALUES_ID               NUMBER,
  PRODUCER_TRANSFORMATION_ID      NUMBER,
  OJBCONCRETECLASS                VARCHAR2(100),
  SECURED_ELEMENT_ID              VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYDATACLUSTER
(
  ID                        NUMBER              NOT NULL,
  DESC_SECURITY_ID          NUMBER,
  IDENTIFIER                VARCHAR2(255)       NOT NULL,
  NAME                      VARCHAR2(100),
  CLUSTER_BIOASSAY_DATA_ID  NUMBER,
  SECURED_ELEMENT_ID        VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYDIMENSION
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYDIMENSIONBIOASSAY
(
  BIOASSAY_DIMENSION_ID  NUMBER                 NOT NULL,
  BIOASSAY_ID            NUMBER                 NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYFACTORVALUE
(
  BIOASSAY_ID      NUMBER                       NOT NULL,
  FACTOR_VALUE_ID  NUMBER                       NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYMAP
(
  ID                   NUMBER                   NOT NULL,
  DESC_SECURITY_ID     NUMBER,
  IDENTIFIER           VARCHAR2(255)            NOT NULL,
  NAME                 VARCHAR2(100),
  DERIVED_BIOASSAY_ID  NUMBER,
  SECURED_ELEMENT_ID   VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYMAPBIOASSAY
(
  BIOASSAY_MAP_ID  NUMBER                       NOT NULL,
  BIOASSAY_ID      NUMBER                       NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYMAPPING
(
  ID                  NUMBER                    NOT NULL,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYMAPS
(
  BIOASSAY_MAPPING_ID  NUMBER                   NOT NULL,
  BIOASSAY_MAP_ID      NUMBER                   NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYTREATMENT
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  IDENTIFIER            VARCHAR2(255)           NOT NULL,
  NAME                  VARCHAR2(100),
  TARGET_ID             NUMBER,
  PHYSICAL_BIOASSAY_ID  NUMBER,
  OJBCONCRETECLASS      VARCHAR2(100),
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOASSAYTUPLE
(
  ID                  NUMBER                    NOT NULL,
  BIOASSAY_ID         NUMBER,
  BIO_DATA_TUPLES_ID  NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIODATAVALUES
(
  ID                  NUMBER                    NOT NULL,
  DATA_INTERNAL_ID    NUMBER,
  DATA_EXTERNAL_ID    NUMBER,
  BIODATACUBE_ORDER   VARCHAR2(100),
  OJBCONCRETECLASS    VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOLOGICALCHARACTERISTICS
(
  COMPOSITE_SEQUENCE_ID  NUMBER                 NOT NULL,
  BIOSEQUENCE_ID         NUMBER                 NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOMATERIAL
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  MATERIAL_TYPE_ID    NUMBER,
  TYPE_ID             NUMBER,
  OJBCONCRETECLASS    VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100),
  IMPORTED            NUMBER(1)                 DEFAULT 0
)
NOLOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON COLUMN BIOMATERIAL.IMPORTED IS 'If this contains 1, it
indicates this BioMaterial was imported from MAGEML. Default is 0';


CREATE TABLE BIOMATERIALCHARACTERISTICS
(
  BIOMATERIAL_ID     NUMBER                     NOT NULL,
  ONTOLOGY_ENTRY_ID  NUMBER                     NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOMATERIALMEASUREMENT
(
  ID                    NUMBER                  NOT NULL,
  BIOMATERIAL_ID        NUMBER,
  MEASUREMENT_ID        NUMBER,
  TREATMENT_ID          NUMBER,
  BIOASSAY_CREATION_ID  NUMBER,
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOSEQUENCE
(
  ID                   NUMBER                   NOT NULL,
  DESC_SECURITY_ID     NUMBER,
  IDENTIFIER           VARCHAR2(255)            NOT NULL,
  NAME                 VARCHAR2(1000),
  POLYMER_TYPE_ID      NUMBER,
  TYPE_ID              NUMBER,
  SPECIES_ID           NUMBER,
  LENGTH               NUMBER,
  ISAPPROXIMATELENGTH  NUMBER,
  ISCIRCULAR           NUMBER,
  SEQUENCE             LONG,
  SECURED_ELEMENT_ID   VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE BIOSEQUENCEONTOLOGYENTRY
(
  BIOSEQUENCE_ID     NUMBER                     NOT NULL,
  ONTOLOGY_ENTRY_ID  NUMBER                     NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE BIOSEQUENCEONTOLOGYENTRY IS 'This table contains 1:n
associations b/w OntologyEntry and BioSequence that represent a
BioSequence''s ontology entries.';


CREATE TABLE BIOSOURCECONTACT
(
  BIOSOURCE_ID  NUMBER                          NOT NULL,
  CONTACT_ID    NUMBER                          NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CA_ADDITIONALFILE
(
  ID             NUMBER                         NOT NULL,
  DESCRIPTION    VARCHAR2(500),
  LOCATION       VARCHAR2(200),
  EXPERIMENT_ID  NUMBER                         NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CA_ADDITIONALPROCESSFILE
(
  ID                       NUMBER               NOT NULL,
  LOCATION                 VARCHAR2(200),
  PROTOCOL_APPLICATION_ID  NUMBER               NOT NULL,
  EXPERIMENT_ID            NUMBER               NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CA_CHANNELONEFACTORVALUES
(
  HYBRIDIZATION_FILE_UPLOAD_ID  NUMBER          NOT NULL,
  FACTOR_VALUE_ID               NUMBER          NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CA_CHANNELTWOFACTORVALUES
(
  HYBRIDIZATION_FILE_UPLOAD_ID  NUMBER          NOT NULL,
  FACTOR_VALUE_ID               NUMBER          NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CA_HYBRIDIZATIONFILEUPLOAD
(
  ID                             NUMBER         NOT NULL,
  EXPERIMENT_ID                  NUMBER         NOT NULL,
  MEASURED_BIOASSAY_ID           NUMBER         NOT NULL,
  DERIVED_BIOASSAY_ID            NUMBER,
  EXTRACT_ID                     NUMBER,
  SPIKED_CONTROL_ID              NUMBER,
  CHANNEL_TWO_EXTRACT_ID         NUMBER,
  CHANNEL_TWO_SPIKED_CONTROL_ID  NUMBER,
  CELFILELOCATION                VARCHAR2(200),
  EXPFILELOCATION                VARCHAR2(200),
  TXTFILELOCATION                VARCHAR2(200),
  CHPFILELOCATION                VARCHAR2(200),
  GPRFILELOCATION                VARCHAR2(200),
  GPSFILELOCATION                VARCHAR2(200),
  ARRAYIDENTIFIER                VARCHAR2(100),
  ARRAYBATCHNAME                 VARCHAR2(100),
  UPLOADGROUPNAME                VARCHAR2(100)
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CHANNEL
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  IMAGE_ID            NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CHANNELCOMPOUND
(
  CHANNEL_ID   NUMBER                           NOT NULL,
  COMPOUND_ID  NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CHROMOSOMALABERRATIONTYPE
(
  CHROMOSOMAL_ABERRATION_ID  NUMBER,
  ONTOLOGY_ENTRY_ID          NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE COMPOSITESEQUENCE
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  CONTROL_TYPE_ID     NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100),
  COMPOSITE_GROUP_ID  NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE COMPOUND
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  EXTERNAL_LIMS_ID    NUMBER,
  ISSOLVENT           NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE COMPOUNDMEASUREMENT
(
  ID                  NUMBER                    NOT NULL,
  MEASUREMENT_ID      NUMBER,
  TREATMENT_ID        NUMBER,
  COMPOUND_ID         NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100),
  PARENT_COMPOUND_ID  NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE COMPSEQDIMENSIONCOMPSEQ
(
  COMP_SEQ_DIMENSION_ID  NUMBER                 NOT NULL,
  COMP_SEQ_ID            NUMBER                 NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE CONTACT
(
  ID          NUMBER                            NOT NULL,
  CLASS_NAME  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DATABASE
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  VERSION             VARCHAR2(24),
  URI                 VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100),
  CATEGORY            VARCHAR2(100),
  USERDEFINED         NUMBER(1)                 DEFAULT 0
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DATABASECONTACT
(
  DATABASE_ID  NUMBER                           NOT NULL,
  CONTACT_ID   NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DATABASEENTRY
(
  ID                          NUMBER            NOT NULL,
  TYPE_ID                     NUMBER,
  DATABASE_ID                 NUMBER,
  DESCRIPTION_ID              NUMBER,
  BIOSEQUENCE_ID              NUMBER,
  ACCESSION                   VARCHAR2(1000),
  ACCESSIONVERSION            VARCHAR2(100),
  URI                         VARCHAR2(100),
  SECURED_ELEMENT_ID          VARCHAR2(100),
  BIBLIOGRAPHIC_REFERENCE_ID  NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DATAEXTERNAL
(
  ID                  NUMBER                    NOT NULL,
  DATAFORMAT          VARCHAR2(100),
  DATAFORMATINFOURI   VARCHAR2(100),
  FILENAMEURI         VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DATAINTERNAL
(
  ID                  NUMBER                    NOT NULL,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DATUM
(
  ID                  NUMBER                    NOT NULL,
  VALUE               LONG RAW,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DERIVEDBIOASSAYDATA
(
  BIOASSAY_ID       NUMBER                      NOT NULL,
  BIOASSAY_DATA_ID  NUMBER                      NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DESCRIPTION
(
  ID                     NUMBER                 NOT NULL,
  DESC_SECURITY_ID       NUMBER,
  DESCRIBABLE_ID         NUMBER,
  EXTERNAL_REFERENCE_ID  NUMBER,
  TEXT                   VARCHAR2(2000),
  URI                    VARCHAR2(100),
  SECURED_ELEMENT_ID     VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DESCRIPTIONONTOLOGYENTRY
(
  DESCRIPTION_ID     NUMBER                     NOT NULL,
  ONTOLOGY_ENTRY_ID  NUMBER                     NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DESIGNELEMENTDIMENSION
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  OJBCONCRETECLASS    VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DESIGNELEMENTGROUP
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  SPECIES_ID          NUMBER,
  TECHNOLOGY_TYPE_ID  NUMBER,
  FEATURE_SHAPE_ID    NUMBER,
  DISTANCE_UNIT_ID    NUMBER,
  FEATUREWIDTH        FLOAT(126),
  FEATURELENGTH       FLOAT(126),
  FEATUREHEIGHT       FLOAT(126),
  OJBCONCRETECLASS    VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DESIGNELEMENTGROUPTYPES
(
  DESIGN_ELEMENT_GROUP_ID  NUMBER               NOT NULL,
  ONTOLOGY_ENTRY_ID        NUMBER               NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE DESIGNELEMENTGROUPTYPES IS 'This table contains m:n
associations b/w DesignElementGroup and OntologyEntry that represent a
DesignElementGroup''s types.';


CREATE TABLE DESIGNELEMENTMAP
(
  ID                     NUMBER                 NOT NULL,
  DESC_SECURITY_ID       NUMBER,
  IDENTIFIER             VARCHAR2(255)          NOT NULL,
  NAME                   VARCHAR2(100),
  COMPOSITE_SEQUENCE_ID  NUMBER,
  REPORTER_ID            NUMBER,
  OJBCONCRETECLASS       VARCHAR2(100),
  SECURED_ELEMENT_ID     VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DESIGNELEMENTMAPPING
(
  ID                  NUMBER                    NOT NULL,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DESIGNELEMENTMAPS
(
  DESIGN_ELEMENT_MAPPING_ID  NUMBER             NOT NULL,
  DESIGN_ELEMENT_MAP_ID      NUMBER             NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE DESIGNELEMENTTUPLE
(
  ID                  NUMBER                    NOT NULL,
  BIOASSAY_TUPLE_ID   NUMBER,
  DESIGN_ELEMENT_ID   NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON COLUMN DESIGNELEMENTTUPLE.DESIGN_ELEMENT_ID IS 'This column is implicitly constrained to be an existing FEATURE, REPORTER or COMPOSITESEQUENCE record. This eliminates the need for inserting into a super-type table the keys of those records so this column can be constrained to, significantly improving the performance for insertion of a large number of DesignElements';


CREATE TABLE EXPERIMENT
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100),
  DELETED             NUMBER                    DEFAULT 0
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE EXPERIMENTALFACTOR
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  IDENTIFIER            VARCHAR2(255)           NOT NULL,
  NAME                  VARCHAR2(100),
  CATEGORY_ID           NUMBER,
  EXPERIMENT_DESIGN_ID  NUMBER,
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE EXPERIMENTBIOASSAY
(
  EXPERIMENT_ID  NUMBER                         NOT NULL,
  BIOASSAY_ID    NUMBER                         NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE EXPERIMENTBIOASSAYDATA
(
  EXPERIMENT_ID     NUMBER                      NOT NULL,
  BIOASSAY_DATA_ID  NUMBER                      NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE EXPERIMENTDESIGN
(
  ID                              NUMBER        NOT NULL,
  DESC_SECURITY_ID                NUMBER,
  QUALITY_CONTROL_DESCRIPTION_ID  NUMBER,
  NORMALIZATION_DESCRIPTION_ID    NUMBER,
  REPLICATE_DESCRIPTION_ID        NUMBER,
  EXPERIMENT_ID                   NUMBER        NOT NULL,
  SECURED_ELEMENT_ID              VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE EXPERIMENTDESIGNTYPE
(
  EXPERIMENT_DESIGN_ID  NUMBER                  NOT NULL,
  ONTOLOGY_ENTRY_ID     NUMBER                  NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE EXPERIMENTPROVIDER
(
  EXPERIMENT_ID  NUMBER                         NOT NULL,
  CONTACT_ID     NUMBER                         NOT NULL,
  ROLE_ID        NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE EXTERNALREFERENCE
(
  ID                  NUMBER                    NOT NULL,
  EXPORTEDFROMSERVER  VARCHAR2(100),
  EXPORTEDFROMDB      VARCHAR2(100),
  EXPORTID            VARCHAR2(100),
  EXPORTNAME          VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FACTORVALUE
(
  ID                      NUMBER                NOT NULL,
  DESC_SECURITY_ID        NUMBER,
  IDENTIFIER              VARCHAR2(255)         NOT NULL,
  NAME                    VARCHAR2(100),
  MEASUREMENT_ID          NUMBER,
  VALUE_ID                NUMBER,
  EXPERIMENTAL_FACTOR_ID  NUMBER,
  SECURED_ELEMENT_ID      VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FEATURE
(
  ID                   NUMBER                   NOT NULL,
  DESC_SECURITY_ID     NUMBER,
  IDENTIFIER           VARCHAR2(255)            NOT NULL,
  NAME                 VARCHAR2(100),
  CONTROL_TYPE_ID      NUMBER,
  FEATURE_LOCATION_ID  NUMBER,
  POSITION_ID          NUMBER,
  ZONE_ID              NUMBER,
  FEATURE_GROUP_ID     NUMBER,
  SECURED_ELEMENT_ID   VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FEATURECONTROLFEATURE
(
  FEATURE_ID          NUMBER                    NOT NULL,
  CONTROL_FEATURE_ID  NUMBER                    NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FEATURECONTROLLEDFEATURE
(
  FEATURE_ID             NUMBER                 NOT NULL,
  CONTROLLED_FEATURE_ID  NUMBER                 NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FEATUREDEFECT
(
  ID                              NUMBER        NOT NULL,
  ARRAY_MANUFACTURE_DEVIATION_ID  NUMBER,
  DEFECT_TYPE_ID                  NUMBER,
  POSITION_DELTA_ID               NUMBER,
  FEATURE_ID                      NUMBER,
  SECURED_ELEMENT_ID              VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FEATUREDIMENSIONFEATURE
(
  FEATURE_DIMENSION_ID  NUMBER                  NOT NULL,
  FEATURE_ID            NUMBER                  NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FEATUREEXTRACTION
(
  ID                           NUMBER           NOT NULL,
  DESC_SECURITY_ID             NUMBER,
  IDENTIFIER                   VARCHAR2(255)    NOT NULL,
  NAME                         VARCHAR2(100),
  PHYSICAL_BIOASSAY_SOURCE_ID  NUMBER,
  MEASURED_BIOASSAY_TARGET_ID  NUMBER,
  SECURED_ELEMENT_ID           VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FEATUREINFORMATION
(
  ID                       NUMBER               NOT NULL,
  FEATURE_ID               NUMBER,
  FEATURE_REPORTER_MAP_ID  NUMBER,
  SECURED_ELEMENT_ID       VARCHAR2(100),
  FEATURE_INFORMATION_ID   NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FEATURELOCATION
(
  ID                  NUMBER                    NOT NULL,
  LOCATION_ROW        NUMBER,
  LOCATION_COLUMN     NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE FIDUCIAL
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  ARRAY_GROUP_ID      NUMBER,
  FIDUCIAL_TYPE_ID    NUMBER,
  DISTANCE_UNIT_ID    NUMBER,
  POSITION_ID         NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE HARDWARE
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  URI                 VARCHAR2(100),
  TYPE_ID             NUMBER,
  MODEL               VARCHAR2(100),
  MAKE                VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE HARDWARE2SOFTWARE
(
  HARDWARE_ID  NUMBER                           NOT NULL,
  SOFTWARE_ID  NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE HARDWARE2SOFTWARE IS 'This table contains m:n associations b/w Hardware and Software that is targeted/compatible for the Hardware';


CREATE TABLE HARDWAREAPPLICATION
(
  ID                       NUMBER               NOT NULL,
  DESC_SECURITY_ID         NUMBER,
  HARDWARE_ID              NUMBER               NOT NULL,
  PROTOCOL_APPLICATION_ID  NUMBER,
  SERIALNUMBER             VARCHAR2(100),
  SECURED_ELEMENT_ID       VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE HARDWAREMANUFACTURERS
(
  HARDWARE_ID  NUMBER                           NOT NULL,
  CONTACT_ID   NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE IMAGE
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  IDENTIFIER            VARCHAR2(255)           NOT NULL,
  NAME                  VARCHAR2(100),
  FORMAT_ID             NUMBER,
  IMAGE_ACQUISITION_ID  NUMBER,
  PHYSICAL_BIOASSAY_ID  NUMBER,
  URI                   VARCHAR2(100),
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE IMMOBILIZEDCHARACTERISTICS
(
  REPORTER_ID     NUMBER                        NOT NULL,
  BIOSEQUENCE_ID  NUMBER                        NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE LABELEDEXTRACTCOMPOUND
(
  LABELED_EXTRACT_ID  NUMBER                    NOT NULL,
  COMPOUND_ID         NUMBER                    NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE MANUFACTURELIMS
(
  ID                          NUMBER            NOT NULL,
  DESC_SECURITY_ID            NUMBER,
  ARRAY_MANUFACTURE_ID        NUMBER,
  FEATURE_ID                  NUMBER,
  BIOMATERIAL_ID              NUMBER,
  IDENTIFIER_LIMS_ID          NUMBER,
  QUALITY                     VARCHAR2(100),
  BIOMATERIALPLATEIDENTIFIER  VARCHAR2(100),
  BIOMATERIALPLATEROW         VARCHAR2(100),
  BIOMATERIALPLATECOL         VARCHAR2(100),
  OJBCONCRETECLASS            VARCHAR2(100),
  SECURED_ELEMENT_ID          VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE MEASUREDBIOASSAYDATA
(
  BIOASSAY_ID       NUMBER                      NOT NULL,
  BIOASSAY_DATA_ID  NUMBER                      NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE MEASUREMENT
(
  ID                  NUMBER                    NOT NULL,
  UNIT_ID             NUMBER,
  TYPE                VARCHAR2(100),
  VALUE               VARCHAR2(100),
  KINDCV              VARCHAR2(100),
  OTHERKIND           VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE MISMATCHINFORMATION
(
  ID                      NUMBER                NOT NULL,
  COMPOSITE_POSITION_ID   NUMBER,
  REPORTER_POSITION_ID    NUMBER,
  FEATURE_INFORMATION_ID  NUMBER,
  STARTCOORD              NUMBER,
  NEWSEQUENCE             VARCHAR2(500),
  REPLACEDLENGTH          NUMBER,
  SECURED_ELEMENT_ID      VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE MOM_MESSAGEDATA
(
  ID          NUMBER(38)                        NOT NULL,
  QUEUE_NAME  VARCHAR2(200)                     NOT NULL,
  DATA        BLOB                              NOT NULL,
  WAIT_TIME   NUMBER(38)                        NOT NULL,
  HOST_IP     VARCHAR2(15)
)
LOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE NAMEVALUETYPE
(
  ID                    NUMBER                  NOT NULL,
  EXTENDABLE_ID         NUMBER,
  NAME_VALUE_TYPE_ID    NUMBER,
  ARRAY_MANUFACTURE_ID  NUMBER,
  BIOMATERIAL_ID        NUMBER,
  BIOASSAY_DATA_ID      NUMBER,
  NAME                  VARCHAR2(500),
  VALUE                 VARCHAR2(4000),
  TYPE                  VARCHAR2(500),
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON COLUMN NAMEVALUETYPE.EXTENDABLE_ID IS 'This column is implicitly constrained to be an existing record in any one of EXTENDABLE subtype tables which are almost all MAGEstk tables. This eliminates the need for inserting into a super-type table the keys of those records so this column can be constrained to, significantly improving the performance for insertion of a large number of such records';


CREATE TABLE NODE
(
  ID                        NUMBER              NOT NULL,
  DESC_SECURITY_ID          NUMBER,
  BIOASSAY_DATA_CLUSTER_ID  NUMBER,
  NODE_ID                   NUMBER,
  SECURED_ELEMENT_ID        VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE NODECONTENTS
(
  ID                           NUMBER           NOT NULL,
  DESC_SECURITY_ID             NUMBER,
  NODE_ID                      NUMBER,
  BIOASSAY_DIMENSION_ID        NUMBER,
  DESIGN_ELEMENT_DIMENSION_ID  NUMBER,
  QUANTITATION_DIMENSION_ID    NUMBER,
  SECURED_ELEMENT_ID           VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE NODEVALUE
(
  ID                  NUMBER                    NOT NULL,
  NODE_ID             NUMBER,
  TYPE_ID             NUMBER,
  SCALE_ID            NUMBER,
  DATA_TYPE_ID        NUMBER,
  NAME                VARCHAR2(100),
  VALUE               LONG RAW,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE OJB_HL_SEQ
(
  TABLENAME  VARCHAR2(175)                      NOT NULL,
  FIELDNAME  VARCHAR2(70)                       NOT NULL,
  MAX_KEY    NUMBER,
  GRAB_SIZE  NUMBER,
  VERSION    NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ONTOLOGYENTRY
(
  ID                          NUMBER            NOT NULL,
  SECURED_ELEMENT_ID          VARCHAR2(100),
  CATEGORY                    VARCHAR2(200),
  VALUE                       VARCHAR2(1000),
  CONTACT_ID                  NUMBER,
  ONTOLOGY_REFERENCE_ID       NUMBER,
  EXPERIMENTAL_FACTOR_ID      NUMBER,
  COMPOUND_ID                 NUMBER,
  DESCRIPTION                 VARCHAR2(1000),
  OJBCONCRETECLASS            VARCHAR2(100)     DEFAULT 'org.biomage.Description.OntologyEntry' NOT NULL,
  AGE_VALUE_ID                NUMBER,
  MEASUREMENT_ID              NUMBER,
  MIN_VALUE_ID                NUMBER,
  MIN_MEASUREMENT_ID          NUMBER,
  MAX_VALUE_ID                NUMBER,
  MAX_MEASUREMENT_ID          NUMBER,
  INITIAL_TIME_POINT_ID       NUMBER,
  WEIGHT_ID                   NUMBER,
  WEIGHT_MEASUREMENT_ID       NUMBER,
  HEIGHT_ID                   NUMBER,
  HEIGHT_MEASUREMENT_ID       NUMBER,
  BIBLIOGRAPHIC_REFERENCE_ID  NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ONTOLOGYENTRYCHILDREN
(
  ONTOLOGY_ENTRY_ID        NUMBER               NOT NULL,
  CHILD_ONTOLOGY_ENTRY_ID  NUMBER               NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE ONTOLOGYENTRYCHILDREN IS 'This table contains m:n
associations b/w OntologyEntry and children OntologyEntry that represent a
OntologyEntry''s associations.';


CREATE TABLE ORGANIZATION
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  IDENTIFIER            VARCHAR2(255)           NOT NULL,
  NAME                  VARCHAR2(100),
  ARRAY_MANUFACTURE_ID  NUMBER,
  URI                   VARCHAR2(100),
  ADDRESS               VARCHAR2(100),
  PHONE                 VARCHAR2(24),
  TOLLFREEPHONE         VARCHAR2(24),
  EMAIL                 VARCHAR2(100),
  FAX                   VARCHAR2(24),
  PARENT_ID             NUMBER,
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE PARAMETER
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  DATA_TYPE_ID        NUMBER,
  DEFAULT_VALUE_ID    NUMBER,
  PARAMETERIZABLE_ID  NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE PARAMETERIZABLE
(
  ID          NUMBER                            NOT NULL,
  CLASS_NAME  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE PARAMETERIZABLEAPPLICATION
(
  ID          NUMBER                            NOT NULL,
  CLASS_NAME  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE PARAMETERVALUE
(
  ID                              NUMBER        NOT NULL,
  PARAMETERIZABLE_APPLICATION_ID  NUMBER,
  PARAMETER_TYPE_ID               NUMBER,
  VALUE                           VARCHAR2(100),
  SECURED_ELEMENT_ID              VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE PERSON
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  IDENTIFIER            VARCHAR2(255)           NOT NULL,
  NAME                  VARCHAR2(100),
  ARRAY_MANUFACTURE_ID  NUMBER,
  URI                   VARCHAR2(100),
  ADDRESS               VARCHAR2(100),
  PHONE                 VARCHAR2(24),
  TOLLFREEPHONE         VARCHAR2(24),
  EMAIL                 VARCHAR2(100),
  FAX                   VARCHAR2(24),
  AFFILIATION_ID        NUMBER,
  LASTNAME              VARCHAR2(100),
  FIRSTNAME             VARCHAR2(100),
  MIDINITIALS           VARCHAR2(24),
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE POSITION
(
  ID                  NUMBER                    NOT NULL,
  DISTANCE_UNIT_ID    NUMBER,
  X                   FLOAT(126),
  Y                   FLOAT(126),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE POSITIONDELTA
(
  ID                  NUMBER                    NOT NULL,
  DISTANCE_UNIT_ID    NUMBER,
  DELTAX              FLOAT(126),
  DELTAY              FLOAT(126),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE PROTOCOL
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  URI                 VARCHAR2(100),
  TYPE_ID             NUMBER,
  TEXT                VARCHAR2(4000),
  TITLE               VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE PROTOCOLAPPLICATION
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  ARRAY_DESIGN_ID       NUMBER,
  ARRAY_MANUFACTURE_ID  NUMBER,
  BIOEVENT_ID           NUMBER,
  PROTOCOL_ID           NUMBER                  NOT NULL,
  ACTIVITYDATE          DATE,
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON COLUMN PROTOCOLAPPLICATION.BIOEVENT_ID IS 'This column is implicitly constrained to be an existing record in any one of BIOEVENT subtype tables including BioAssayCreation, BioAssayTreatment, FeatureExtraction, BioAssayMap, DesignElementMap, QuantitationTypeMap, Transformation, and Treatment. This eliminates the need for inserting into a super-type table the keys of those records so this column can be constrained to, significantly improving the performance for insertion of a large number of such records';


CREATE TABLE PROTOCOLHARDWARE
(
  PROTOCOL_ID  NUMBER                           NOT NULL,
  HARDWARE_ID  NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE PROTOCOLSOFTWARE
(
  PROTOCOL_ID  NUMBER                           NOT NULL,
  SOFTWARE_ID  NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE QUANTITATIONTYPE
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  IDENTIFIER            VARCHAR2(255)           NOT NULL,
  NAME                  VARCHAR2(100),
  CHANNEL_ID            NUMBER,
  SCALE_ID              NUMBER,
  DATA_TYPE_ID          NUMBER,
  ISBACKGROUND          NUMBER,
  QUANTITATION_TYPE_ID  NUMBER,
  OJBCONCRETECLASS      VARCHAR2(100),
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE QUANTITATIONTYPEDIMENSION
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE QUANTITATIONTYPEMAP
(
  ID                    NUMBER                  NOT NULL,
  DESC_SECURITY_ID      NUMBER,
  IDENTIFIER            VARCHAR2(255)           NOT NULL,
  NAME                  VARCHAR2(100),
  QUANTITATION_TYPE_ID  NUMBER,
  SECURED_ELEMENT_ID    VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE QUANTITATIONTYPEMAPPING
(
  ID                  NUMBER                    NOT NULL,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE QUANTITATIONTYPEMAPS
(
  QUANTITATION_TYPE_MAPPING_ID  NUMBER          NOT NULL,
  QUANTITATION_TYPE_MAP_ID      NUMBER          NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE QUANTITATIONTYPEMAPSOURCES
(
  QUANTITATION_TYPE_ID      NUMBER              NOT NULL,
  QUANTITATION_TYPE_MAP_ID  NUMBER              NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE QUANTITATIONTYPETUPLE
(
  ID                       NUMBER               NOT NULL,
  DESIGN_ELEMENT_TUPLE_ID  NUMBER,
  QUANTITATION_TYPE_ID     NUMBER,
  DATUM_ID                 NUMBER,
  SECURED_ELEMENT_ID       VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE QUANTTYPEDIMENSIONQUANTTYPE
(
  QUANTITATION_TYPE_DIMENSION_ID  NUMBER        NOT NULL,
  QUANTITATION_TYPE_ID            NUMBER        NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE REPORTER
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  CONTROL_TYPE_ID     NUMBER,
  WARNING_TYPE_ID     NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100),
  REPORTER_GROUP_ID   NUMBER
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE REPORTERDIMENSIONREPORTER
(
  REPORTER_DIMENSION_ID  NUMBER                 NOT NULL,
  REPORTER_ID            NUMBER                 NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE REPORTERONTOLOGYENTRY
(
  REPORTER_ID        NUMBER                     NOT NULL,
  ONTOLOGY_ENTRY_ID  NUMBER                     NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE REPORTERONTOLOGYENTRY IS 'This table contains 1:n
associations b/w OntologyEntry and Reporter that represent a Reporter''s
failed types.';


CREATE TABLE SECURITY
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SECURITYCONTACT
(
  SECURITY_ID  NUMBER                           NOT NULL,
  CONTACT_ID   NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SECURITYGROUP
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SECURITYGROUPCONTACT
(
  SECURITY_GROUP_ID  NUMBER                     NOT NULL,
  CONTACT_ID         NUMBER                     NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SECURITYSECURITYGROUP
(
  SECURITY_ID        NUMBER                     NOT NULL,
  SECURITY_GROUP_ID  NUMBER                     NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SEQFEATURE
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  BIOSEQUENCE_ID      NUMBER,
  BASIS               VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SEQFEATURELOCATION
(
  ID                  NUMBER                    NOT NULL,
  SEQ_FEATURE_ID      NUMBER,
  SEQ_FEATURE_LOC_ID  NUMBER,
  COORDINATE_ID       NUMBER,
  STRANDTYPE          VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SEQUENCEPOSITION
(
  ID                          NUMBER            NOT NULL,
  POSITION_START              NUMBER,
  POSITION_END                NUMBER,
  REPORTER_COMPOSITE_MAP_ID   NUMBER,
  REPORTER_ID                 NUMBER,
  COMPOSITE_COMPOSITE_MAP_ID  NUMBER,
  COMPOSITE_ID                NUMBER,
  OJBCONCRETECLASS            VARCHAR2(100),
  SECURED_ELEMENT_ID          VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SOFTWARE
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  URI                 VARCHAR2(100),
  TYPE_ID             NUMBER,
  SOFTWARE_ID         NUMBER,
  HARDWARE_ID         NUMBER,
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SOFTWARE2SOFTWARE
(
  SOFTWARE_ID             NUMBER                NOT NULL,
  ASSOCIATED_SOFTWARE_ID  NUMBER                NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE SOFTWARE2SOFTWARE IS 'This table contains m:n associations b/w two Software that represent a Software''s dependencies.';


CREATE TABLE SOFTWAREAPPLICATION
(
  ID                       NUMBER               NOT NULL,
  DESC_SECURITY_ID         NUMBER,
  SOFTWARE_ID              NUMBER               NOT NULL,
  PROTOCOL_APPLICATION_ID  NUMBER,
  VERSION                  VARCHAR2(24),
  RELEASEDATE              DATE,
  SECURED_ELEMENT_ID       VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE SOFTWAREMANUFACTURERS
(
  SOFTWARE_ID  NUMBER                           NOT NULL,
  CONTACT_ID   NUMBER                           NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TOAD2_PLAN_TABLE
(
  STATEMENT_ID     VARCHAR2(32),
  TIMESTAMP        DATE,
  REMARKS          VARCHAR2(80),
  OPERATION        VARCHAR2(30),
  OPTIONS          VARCHAR2(30),
  OBJECT_NODE      VARCHAR2(128),
  OBJECT_OWNER     VARCHAR2(30),
  OBJECT_NAME      VARCHAR2(30),
  OBJECT_INSTANCE  NUMBER,
  OBJECT_TYPE      VARCHAR2(30),
  SEARCH_COLUMNS   NUMBER,
  ID               NUMBER,
  COST             NUMBER,
  PARENT_ID        NUMBER,
  POSITION         NUMBER,
  CARDINALITY      NUMBER,
  OPTIMIZER        VARCHAR2(255),
  BYTES            NUMBER,
  OTHER_TAG        VARCHAR2(255),
  OTHER            LONG
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TOAD_PLAN_SQL
(
  USERNAME      VARCHAR2(30),
  STATEMENT_ID  VARCHAR2(32),
  TIMESTAMP     DATE,
  STATEMENT     VARCHAR2(2000)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TOAD_PLAN_TABLE
(
  STATEMENT_ID     VARCHAR2(32),
  TIMESTAMP        DATE,
  REMARKS          VARCHAR2(80),
  OPERATION        VARCHAR2(30),
  OPTIONS          VARCHAR2(30),
  OBJECT_NODE      VARCHAR2(128),
  OBJECT_OWNER     VARCHAR2(30),
  OBJECT_NAME      VARCHAR2(30),
  OBJECT_INSTANCE  NUMBER,
  OBJECT_TYPE      VARCHAR2(30),
  SEARCH_COLUMNS   NUMBER,
  ID               NUMBER,
  COST             NUMBER,
  PARENT_ID        NUMBER,
  POSITION         NUMBER,
  CARDINALITY      NUMBER,
  OPTIMIZER        VARCHAR2(255),
  BYTES            NUMBER,
  OTHER_TAG        VARCHAR2(255),
  OTHER            LONG
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TOPLEVELBIOASSAYS
(
  EXPERIMENT_DESIGN_ID  NUMBER                  NOT NULL,
  BIOASSAY_ID           NUMBER                  NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TRANSFORMATION
(
  ID                            NUMBER          NOT NULL,
  DESC_SECURITY_ID              NUMBER,
  IDENTIFIER                    VARCHAR2(255)   NOT NULL,
  NAME                          VARCHAR2(100),
  SECURITY_ID                   NUMBER,
  DER_BIOASSAY_DATA_TARGET_ID   NUMBER,
  QUANTITATION_TYPE_MAPPING_ID  NUMBER,
  DESIGN_ELEMENT_MAPPING_ID     NUMBER,
  BIOASSAY_MAPPING_ID           NUMBER,
  SECURED_ELEMENT_ID            VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TRANSFORMEDBIOASSAYDATA
(
  TRANSFORMATION_ID  NUMBER                     NOT NULL,
  BIOASSAY_DATA_ID   NUMBER                     NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TREATMENT
(
  ID                     NUMBER                 NOT NULL,
  DESC_SECURITY_ID       NUMBER,
  IDENTIFIER             VARCHAR2(255)          NOT NULL,
  NAME                   VARCHAR2(100),
  BIOMATERIAL_ID         NUMBER,
  ACTION_ID              NUMBER,
  ACTION_MEASUREMENT_ID  NUMBER,
  TREATMENT_ORDER        NUMBER,
  SECURED_ELEMENT_ID     VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TST_A_AASSOC
(
  A_ID       NUMBER                             NOT NULL,
  AASSOC_ID  NUMBER                             NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TST_A_ASSOC
(
  ID  NUMBER                                    NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TST_BASE
(
  ID             NUMBER                         NOT NULL,
  CLASS_NAME     VARCHAR2(200)                  NOT NULL,
  BASE_ATT       VARCHAR2(200),
  BASE_ASSOC_ID  NUMBER,
  A_ATT          VARCHAR2(200),
  B_ATT          VARCHAR2(200),
  C_ATT          VARCHAR2(200)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TST_BASE_ASSOC
(
  ID  NUMBER                                    NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TST_B_ASSOC
(
  ID    NUMBER                                  NOT NULL,
  B_ID  NUMBER                                  NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE TST_C_ASSOC
(
  ID    NUMBER                                  NOT NULL,
  C_ID  NUMBER                                  NOT NULL
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE UNIT
(
  ID                  NUMBER                    NOT NULL,
  OJBCONCRETECLASS    VARCHAR2(100),
  UNITNAME            VARCHAR2(100),
  UNITNAMECV          VARCHAR2(100),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ZONE
(
  ID                  NUMBER                    NOT NULL,
  DESC_SECURITY_ID    NUMBER,
  IDENTIFIER          VARCHAR2(255)             NOT NULL,
  NAME                VARCHAR2(100),
  DISTANCE_UNIT_ID    NUMBER,
  ZONE_GROUP_ID       NUMBER,
  ZONE_ROW            NUMBER,
  ZONE_COLUMN         NUMBER,
  UPPERLEFTX          FLOAT(126),
  UPPERLEFTY          FLOAT(126),
  LOWERRIGHTX         FLOAT(126),
  LOWERRIGHTY         FLOAT(126),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ZONEDEFECT
(
  ID                              NUMBER        NOT NULL,
  ARRAY_MANUFACTURE_DEVIATION_ID  NUMBER,
  DEFECT_TYPE_ID                  NUMBER,
  POSITION_DELTA_ID               NUMBER,
  ZONE_ID                         NUMBER,
  SECURED_ELEMENT_ID              VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ZONEGROUP
(
  ID                        NUMBER              NOT NULL,
  PHYSICAL_ARRAY_DESIGN_ID  NUMBER,
  DISTANCE_UNIT_ID          NUMBER,
  ZONE_LAYOUT_ID            NUMBER,
  SPACINGSBETWEENZONESX     FLOAT(126),
  SPACINGSBETWEENZONESY     FLOAT(126),
  ZONESPERX                 NUMBER,
  ZONESPERY                 NUMBER,
  SECURED_ELEMENT_ID        VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE TABLE ZONELAYOUT
(
  ID                  NUMBER                    NOT NULL,
  DISTANCE_UNIT_ID    NUMBER,
  NUMFEATURESPERROW   NUMBER,
  NUMFEATURESPERCOL   NUMBER,
  SPACINGBETWEENROWS  FLOAT(126),
  SPACINGBETWEENCOLS  FLOAT(126),
  SECURED_ELEMENT_ID  VARCHAR2(100)
)
NOLOGGING 
NOCACHE
NOPARALLEL;


CREATE UNIQUE INDEX ACTIONPROTOCOLTYPE_PK ON ACTIONPROTOCOLTYPE
(ACTION_ID, PROTOCOL_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ACTPROT_ACT_IDX ON ACTIONPROTOCOLTYPE
(ACTION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ACTPROT_PROTYPE_IDX ON ACTIONPROTOCOLTYPE
(PROTOCOL_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX AFFYBACKGROUND_PK ON AFFYBACKGROUND
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX AFFYCALLSUMMARY_PK ON AFFYCALLSUMMARY
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX AFFYCONTROL_PK ON AFFYCONTROL
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX AFFYHOUSEKEEPINGCONTROL_PK ON AFFYHOUSEKEEPINGCONTROL
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX AFFYMETRIX_PK ON AFFYMETRIX
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX AFFYSPIKECONTROL_PK ON AFFYSPIKECONTROL
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX AGILENT_PK ON AGILENT
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ANALYSISRESULTS_PK ON ANALYSISRESULTS
(EXPERIMENT_ID, BIOASSAY_DATA_CLUSTER_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ANA_ASYCLUS_IDX ON ANALYSISRESULTS
(BIOASSAY_DATA_CLUSTER_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ANA_EXP_IDX ON ANALYSISRESULTS
(EXPERIMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX APPLICATIONPERFORMER_PK ON APPLICATIONPERFORMER
(PROTOCOL_APPLICATION_ID, PERSON_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX APPLICATION_PRIVILEGE_COMB ON AS_APPLICATION_PRIVILEGE
(APPLICATION_ID, PRIVILEGE_ID)
LOGGING
NOPARALLEL;


CREATE INDEX APPPRF_PERSON_IDX ON APPLICATIONPERFORMER
(PERSON_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX APPPRF_PROT_IDX ON APPLICATIONPERFORMER
(PROTOCOL_APPLICATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX APP_ID_IDX ON AS_USER_ROLE_PROTECT_APP
(APPLICATION_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX APP_PROTECTION_ELEMENT_COMB ON AS_APP_PROTECTION_ELEMENT
(APPLICATION_ID, PROTECTION_ELEMENT_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX APP_PROTECTION_GROUP_COMB ON AS_APP_PROTECTION_GROUP
(APPLICATION_ID, PROTECTION_GROUP_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYDESIGNCOMPOSITEGRP_PK ON ARRAYDESIGNCOMPOSITEGRP
(ARRAY_DESIGN_ID, COMPOSITE_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYDESIGNFEATUREGRP_PK ON ARRAYDESIGNFEATUREGRP
(ARRAY_DESIGN_ID, FEATURE_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYDESIGNPROVIDER_PK ON ARRAYDESIGNPROVIDER
(ARRAY_DESIGN_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYDESIGNREPORTERGRP_PK ON ARRAYDESIGNREPORTERGRP
(ARRAY_DESIGN_ID, REPORTER_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYDESIGN_PK ON ARRAYDESIGN
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAYDESI_IDENTIFIER_IDX ON ARRAYDESIGN
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAYDESI_NM_IDX ON ARRAYDESIGN
(NAME)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYGROUP_PK ON ARRAYGROUP
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAYGRP_IDENTIFIER_IDX ON ARRAYGROUP
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYMANUFACTUREDEVIATION_PK ON ARRAYMANUFACTUREDEVIATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYMANUFACTURER_PK ON ARRAYMANUFACTURER
(ARRAY_MANUFACTURE_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAYMANUFACTURE_PK ON ARRAYMANUFACTURE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAYMAN_IDENTIFIER_IDX ON ARRAYMANUFACTURE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAY_ARRDESI_IDX ON ARRAY
(ARRAY_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAY_ARRGRP_IDX ON ARRAY
(ARRAY_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAY_ARRMAN_IDX ON ARRAY
(ARRAY_MANUFACTURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAY_DESCSEC_IDX ON ARRAY
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAY_IDENTIFIER_IDX ON ARRAY
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRAY_INFO_IDX ON ARRAY
(INFORMATION_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ARRAY_PK ON ARRAY
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDESICOMGRP_COMPGRP_IDX ON ARRAYDESIGNCOMPOSITEGRP
(COMPOSITE_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDESICOMGRP_DESI_IDX ON ARRAYDESIGNCOMPOSITEGRP
(ARRAY_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDESIPRO_ROLE_IDX ON ARRAYDESIGNPROVIDER
(ROLE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDESIREP_DESI_IDX ON ARRAYDESIGNREPORTERGRP
(ARRAY_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDESIREP_REPGRP_IDX ON ARRAYDESIGNREPORTERGRP
(REPORTER_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDESI_DESCSEC_IDX ON ARRAYDESIGN
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDESI_SURF_IDX ON ARRAYDESIGN
(SURFACE_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDISIFGRP_DESI_IDX ON ARRAYDESIGNFEATUREGRP
(ARRAY_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDISIFGRP_FEAT_IDX ON ARRAYDESIGNFEATUREGRP
(FEATURE_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDISIPRO_CONT_IDX ON ARRAYDESIGNPROVIDER
(CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRDISIPRO_DESI_IDX ON ARRAYDESIGNPROVIDER
(ARRAY_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRGRP_DESCSEC_IDX ON ARRAYGROUP
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRGRP_DISUNIT_IDX ON ARRAYGROUP
(DISTANCE_UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRGRP_NM_IDX ON ARRAYGROUP
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRGRP_SUBSTR_IDX ON ARRAYGROUP
(SUBSTRATE_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRMAN_ARRAY_IDX ON ARRAYMANUFACTUREDEVIATION
(ARRAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRMAN_DESCSEC_IDX ON ARRAYMANUFACTURE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ARRMAN_NM_IDX ON ARRAYMANUFACTURE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX ATTRIBUTE_IND ON AS_LOG
(ATTRIBUTE_NAME)
LOGGING
NOPARALLEL;


CREATE INDEX AUDITTBL_DESCSEC_IDX ON AUDIT_TBL
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX AUDITTBL_PERF_IDX ON AUDIT_TBL
(PERFORMER_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX AUDIT_TBL_PK ON AUDIT_TBL
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BACKGROUND_ID_IDX ON AFFYMETRIX
(BACKGROUND_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIBLIOGRAPHICREFERENCE_PK ON BIBLIOGRAPHICREFERENCE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIB_DESCRIP_IDX ON BIBLIOGRAPHICREFERENCE
(DESCRIPTION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIB_DESCSEC_IDX ON BIBLIOGRAPHICREFERENCE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYCHANNEL_PK ON BIOASSAYCHANNEL
(BIOASSAY_ID, CHANNEL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAYCLUS_IDENTIFIER_IDX ON BIOASSAYDATACLUSTER
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYCREATION_PK ON BIOASSAYCREATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAYCRE_IDENTIFIER_IDX ON BIOASSAYCREATION
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYDATACLUSTER_PK ON BIOASSAYDATACLUSTER
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAYDATA_IDENTIFIER_IDX ON BIOASSAYDATA
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYDATA_PK ON BIOASSAYDATA
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYDIMENSIONBIOASSAY_PK ON BIOASSAYDIMENSIONBIOASSAY
(BIOASSAY_DIMENSION_ID, BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYDIMENSION_PK ON BIOASSAYDIMENSION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYFACTORVALUE_PK ON BIOASSAYFACTORVALUE
(BIOASSAY_ID, FACTOR_VALUE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYMAPBIOASSAY_PK ON BIOASSAYMAPBIOASSAY
(BIOASSAY_MAP_ID, BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYMAPPING_PK ON BIOASSAYMAPPING
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYMAPS_PK ON BIOASSAYMAPS
(BIOASSAY_MAPPING_ID, BIOASSAY_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAYMAP_IDENTIFIER_IDX ON BIOASSAYMAP
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYMAP_PK ON BIOASSAYMAP
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAYMEN_IDENTIFIER_IDX ON BIOASSAYDIMENSION
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYTREATMENT_PK ON BIOASSAYTREATMENT
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAYTRX_IDENTIFIER_IDX ON BIOASSAYTREATMENT
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAYTUPLE_PK ON BIOASSAYTUPLE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAY_BIOASCRE_IDX ON BIOASSAY
(BIOASSAY_CREATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAY_DESCSEC_IDX ON BIOASSAY
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAY_FEAEXT_IDX ON BIOASSAY
(FEATURE_EXTRACTION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAY_IDENTIFIER_IDX ON BIOASSAY
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAY_NM_IDX ON BIOASSAY
(NAME)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOASSAY_PK ON BIOASSAY
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSAY_TYPE_IDX ON BIOASSAY
(TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSCLUS_DATA_IDX ON BIOASSAYDATACLUSTER
(CLUSTER_BIOASSAY_DATA_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSCLUS_DESCSEC_IDX ON BIOASSAYDATACLUSTER
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSCLUS_NM_IDX ON BIOASSAYDATACLUSTER
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSCRE_ARRAY_IDX ON BIOASSAYCREATION
(ARRAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSCRE_DESCSEC_IDX ON BIOASSAYCREATION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSCRE_NM_IDX ON BIOASSAYCREATION
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSCRE_PHYS_IDX ON BIOASSAYCREATION
(PHYSICAL_BIOASSAY_TARGET_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDATA_BIODIMS_IDX ON BIOASSAYDATA
(BIOASSAY_DIMENSION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDATA_DESCSEC_IDX ON BIOASSAYDATA
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDATA_DESIELM_IDX ON BIOASSAYDATA
(DESIGN_ELEMENT_DIMENSION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDATA_NM_IDX ON BIOASSAYDATA
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDATA_PROCTRA_IDX ON BIOASSAYDATA
(PRODUCER_TRANSFORMATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDATA_QUANTYPE_IDX ON BIOASSAYDATA
(QUANTITATION_TYPE_DIMENSION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDATA_VALUE_IDX ON BIOASSAYDATA
(BIODATA_VALUES_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDEMIN_NM_IDX ON BIOASSAYDIMENSION
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDEMN_DESCSEC_IDX ON BIOASSAYDIMENSION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDMASY_ASSY_IDX ON BIOASSAYDIMENSIONBIOASSAY
(BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSDMASY_DM_IDX ON BIOASSAYDIMENSIONBIOASSAY
(BIOASSAY_DIMENSION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSMAP_DERI_IDX ON BIOASSAYMAP
(DERIVED_BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSMAP_DESCSEC_IDX ON BIOASSAYMAP
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSMAP_NM_IDX ON BIOASSAYMAP
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSTRX_DESCSEC_IDX ON BIOASSAYTREATMENT
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSTRX_NM_IDX ON BIOASSAYTREATMENT
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSTRX_PHYS_IDX ON BIOASSAYTREATMENT
(PHYSICAL_BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSTRX_TARG_IDX ON BIOASSAYTREATMENT
(TARGET_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSTUP_BIOASY_IDX ON BIOASSAYTUPLE
(BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASSTUP_DATATUP_IDX ON BIOASSAYTUPLE
(BIO_DATA_TUPLES_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASYCHAN_ASY_IDX ON BIOASSAYCHANNEL
(BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASYCHAN_CHAN_IDX ON BIOASSAYCHANNEL
(CHANNEL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASYFV_ASY_IDX ON BIOASSAYFACTORVALUE
(BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASYFV_FV_IDX ON BIOASSAYFACTORVALUE
(FACTOR_VALUE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASYMAPS_MAPPING_IDX ON BIOASSAYMAPS
(BIOASSAY_MAPPING_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASYMAPS_MAP_IDX ON BIOASSAYMAPS
(BIOASSAY_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASYMAP_ASY_IDX ON BIOASSAYMAPBIOASSAY
(BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOASYMAP_MAP_IDX ON BIOASSAYMAPBIOASSAY
(BIOASSAY_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIODATAVALUES_PK ON BIODATAVALUES
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIODVAL_EXTR_IDX ON BIODATAVALUES
(DATA_EXTERNAL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIODVAL_INTER_IDX ON BIODATAVALUES
(DATA_INTERNAL_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOLOGICALCHARACTERISTICS_PK ON BIOLOGICALCHARACTERISTICS
(COMPOSITE_SEQUENCE_ID, BIOSEQUENCE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOMATERIALCHARACTERISTICS_PK ON BIOMATERIALCHARACTERISTICS
(BIOMATERIAL_ID, ONTOLOGY_ENTRY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOMATERIALMEASUREMENT_PK ON BIOMATERIALMEASUREMENT
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMATERIAL_IDENTIFIER_IDX ON BIOMATERIAL
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOMATERIAL_PK ON BIOMATERIAL
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMAT_DESCSEC_IDX ON BIOMATERIAL
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMAT_MATYPE_IDX ON BIOMATERIAL
(MATERIAL_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMAT_NM_IDX ON BIOMATERIAL
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMAT_TYPE_IDX ON BIOMATERIAL
(TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMM_BIOCRE_IDX ON BIOMATERIALMEASUREMENT
(BIOASSAY_CREATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMM_BIOM_IDX ON BIOMATERIALMEASUREMENT
(BIOMATERIAL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMM_MEASU_IDX ON BIOMATERIALMEASUREMENT
(MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOMM_TRX_IDX ON BIOMATERIALMEASUREMENT
(TREATMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOSEQUENCEONTOLOGYENTRY_PK ON BIOSEQUENCEONTOLOGYENTRY
(BIOSEQUENCE_ID, ONTOLOGY_ENTRY_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOSEQUENCE_PK ON BIOSEQUENCE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOSEQ_DESCSEC_IDX ON BIOSEQUENCE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOSEQ_IDENTIFIER_IDX ON BIOSEQUENCE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOSEQ_POLYTYPE_IDX ON BIOSEQUENCE
(POLYMER_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOSEQ_SPEC_IDX ON BIOSEQUENCE
(SPECIES_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOSEQ_TYPE_IDX ON BIOSEQUENCE
(TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX BIOSOURCECONTACT_PK ON BIOSOURCECONTACT
(BIOSOURCE_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOSRC_CON_IDX ON BIOSOURCECONTACT
(CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX BIOSRC_SRC_IDX ON BIOSOURCECONTACT
(BIOSOURCE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX CALLSUM_ID_IDX ON AFFYMETRIX
(CALLSUMMARY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX CA_ADDITIONALFILE_PK ON CA_ADDITIONALFILE
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX CA_ADDITIONALPROCESSINGFILE_PK ON CA_ADDITIONALPROCESSFILE
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX CA_CHANNELONEFACTORVALUES_PK ON CA_CHANNELONEFACTORVALUES
(HYBRIDIZATION_FILE_UPLOAD_ID, FACTOR_VALUE_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX CA_CHANNELTWOFACTORVALUES_PK ON CA_CHANNELTWOFACTORVALUES
(HYBRIDIZATION_FILE_UPLOAD_ID, FACTOR_VALUE_ID)
LOGGING
NOPARALLEL;


CREATE INDEX CA_EXPER_IDX ON CA_ADDITIONALFILE
(EXPERIMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX CA_HYBRIDIZATIONFILEUPLOAD_PK ON CA_HYBRIDIZATIONFILEUPLOAD
(ID)
LOGGING
NOPARALLEL;


CREATE INDEX CHANCOMP_CHAN_IDX ON CHANNELCOMPOUND
(CHANNEL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX CHANCOMP_COMP_IDX ON CHANNELCOMPOUND
(COMPOUND_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX CHANNELCOMPOUND_PK ON CHANNELCOMPOUND
(CHANNEL_ID, COMPOUND_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX CHANNEL_IDENTIFIER_IDX ON CHANNEL
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX CHANNEL_PK ON CHANNEL
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX CHAN_DESCSEC_IDX ON CHANNEL
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX CHAN_IMAG_IDX ON CHANNEL
(IMAGE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX CHAN_NM_IDX ON CHANNEL
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMM_COMP_IDX ON COMPOUNDMEASUREMENT
(COMPOUND_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMM_MEASU_IDX ON COMPOUNDMEASUREMENT
(MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMM_TRX_IDX ON COMPOUNDMEASUREMENT
(TREATMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX COMPOSITESEQUENCE_PK ON COMPOSITESEQUENCE
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX COMPOUNDMEASUREMENT_PK ON COMPOUNDMEASUREMENT
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPOUND_IDENTIFIER_IDX ON COMPOUND
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX COMPOUND_PK ON COMPOUND
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPO_DESCSEC_IDX ON COMPOUND
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPO_EXTR_IDX ON COMPOUND
(EXTERNAL_LIMS_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPO_NM_IDX ON COMPOUND
(NAME)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX COMPSEQDIMENSIONCOMPSEQ_PK ON COMPSEQDIMENSIONCOMPSEQ
(COMP_SEQ_DIMENSION_ID, COMP_SEQ_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPSEQ_COMGRP_IDX ON COMPOSITESEQUENCE
(COMPOSITE_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPSEQ_CONTYPE_IDX ON COMPOSITESEQUENCE
(CONTROL_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPSEQ_DESCSEC_IDX ON COMPOSITESEQUENCE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPSEQ_NM_IDX ON COMPOSITESEQUENCE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMPSITESEQ_IDENTIFIER_IDX ON COMPOSITESEQUENCE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMSEQDM_SEQDM_IDX ON COMPSEQDIMENSIONCOMPSEQ
(COMP_SEQ_DIMENSION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX COMSEQDM_SEQ_IDX ON COMPSEQDIMENSIONCOMPSEQ
(COMP_SEQ_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX CONTACT_PK ON CONTACT
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX CONT_CNM_IDX ON CONTACT
(CLASS_NAME)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DATABASECONTACT_PK ON DATABASECONTACT
(DATABASE_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DATABASEENTRY_PK ON DATABASEENTRY
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DATABASE_PK ON DATABASE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DATAB_IDENTIFIER_IDX ON DATABASE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DATAEXTERNAL_PK ON DATAEXTERNAL
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DATAINTERNAL_PK ON DATAINTERNAL
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DATUM_PK ON DATUM
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DBCON_CON_IDX ON DATABASECONTACT
(CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DBCON_DB_IDX ON DATABASECONTACT
(DATABASE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DBEN_BIB_IDX ON DATABASEENTRY
(BIBLIOGRAPHIC_REFERENCE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DBEN_BIOSEQ_IDX ON DATABASEENTRY
(BIOSEQUENCE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DBEN_DBID_IDX ON DATABASEENTRY
(DATABASE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DBEN_DESCP_IDX ON DATABASEENTRY
(DESCRIPTION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DBEN_TYPE_IDX ON DATABASEENTRY
(TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DB_DESCSEC_IDX ON DATABASE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DB_NM_IDX ON DATABASE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX DB_VERS_IDX ON DATABASE
(VERSION)
NOLOGGING
NOPARALLEL;


CREATE INDEX DERBIOASY_BIOASY_IDX ON DERIVEDBIOASSAYDATA
(BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DERBIOASY_DATA_IDX ON DERIVEDBIOASSAYDATA
(BIOASSAY_DATA_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DERIVEDBIOASSAYDATA_PK ON DERIVEDBIOASSAYDATA
(BIOASSAY_ID, BIOASSAY_DATA_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESCONTEN_DESC_IDX ON DESCRIPTIONONTOLOGYENTRY
(DESCRIPTION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESCONTEN_ONT_IDX ON DESCRIPTIONONTOLOGYENTRY
(ONTOLOGY_ENTRY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESCP_DESCP_IDX ON DESCRIPTION
(DESCRIBABLE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESCP_DESCSEC_IDX ON DESCRIPTION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESCP_EXTR_IDX ON DESCRIPTION
(EXTERNAL_REFERENCE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESCRIPTIONONTOLOGYENTRY_PK ON DESCRIPTIONONTOLOGYENTRY
(DESCRIPTION_ID, ONTOLOGY_ENTRY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESCRIPTION_PK ON DESCRIPTION
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMDM_DESCSEC_IDX ON DESIGNELEMENTDIMENSION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMDM_NM_IDX ON DESIGNELEMENTDIMENSION
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMGRP_DESCSEC_IDX ON DESIGNELEMENTGROUP
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMGRP_DISUNIT_IDX ON DESIGNELEMENTGROUP
(DISTANCE_UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMGRP_FEAT_IDX ON DESIGNELEMENTGROUP
(FEATURE_SHAPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMGRP_NM_IDX ON DESIGNELEMENTGROUP
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMGRP_SPEC_IDX ON DESIGNELEMENTGROUP
(SPECIES_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMGRP_TECHTYPE_IDX ON DESIGNELEMENTGROUP
(TECHNOLOGY_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMTGRP_IDENTIFIER_IDX ON DESIGNELEMENTGROUP
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMTMAP_IDENTIFIER_IDX ON DESIGNELEMENTMAP
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMTMEN_IDENTIFIER_IDX ON DESIGNELEMENTDIMENSION
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELMTUP_DESI_IDX ON DESIGNELEMENTTUPLE
(DESIGN_ELEMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELM_MAPPING_IDX ON DESIGNELEMENTMAPS
(DESIGN_ELEMENT_MAPPING_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX DESIELM_MAP_IDX ON DESIGNELEMENTMAPS
(DESIGN_ELEMENT_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESIGNELEMENTDIMENSION_PK ON DESIGNELEMENTDIMENSION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESIGNELEMENTGROUPTYPES_PK ON DESIGNELEMENTGROUPTYPES
(DESIGN_ELEMENT_GROUP_ID, ONTOLOGY_ENTRY_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESIGNELEMENTGROUP_PK ON DESIGNELEMENTGROUP
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESIGNELEMENTMAPPING_PK ON DESIGNELEMENTMAPPING
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESIGNELEMENTMAPS_PK ON DESIGNELEMENTMAPS
(DESIGN_ELEMENT_MAPPING_ID, DESIGN_ELEMENT_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESIGNELEMENTMAP_PK ON DESIGNELEMENTMAP
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX DESIGNELEMENTTUPLE_PK ON DESIGNELEMENTTUPLE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPDESI_DESCSEC_IDX ON EXPERIMENTDESIGN
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPDESI_EXP_IDX ON EXPERIMENTDESIGN
(EXPERIMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPDESI_NORMDES_IDX ON EXPERIMENTDESIGN
(NORMALIZATION_DESCRIPTION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPDESI_QCD_IDX ON EXPERIMENTDESIGN
(QUALITY_CONTROL_DESCRIPTION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPDESI_REPL_IDX ON EXPERIMENTDESIGN
(REPLICATE_DESCRIPTION_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX EXPERIMENTALFACTOR_PK ON EXPERIMENTALFACTOR
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX EXPERIMENTBIOASSAYDATA_PK ON EXPERIMENTBIOASSAYDATA
(EXPERIMENT_ID, BIOASSAY_DATA_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX EXPERIMENTBIOASSAY_PK ON EXPERIMENTBIOASSAY
(EXPERIMENT_ID, BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX EXPERIMENTDESIGNTYPE_PK ON EXPERIMENTDESIGNTYPE
(EXPERIMENT_DESIGN_ID, ONTOLOGY_ENTRY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX EXPERIMENTDESIGN_PK ON EXPERIMENTDESIGN
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX EXPERIMENTPROVIDER_PK ON EXPERIMENTPROVIDER
(EXPERIMENT_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX EXPERIMENT_PK ON EXPERIMENT
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPFACT_IDENTIFIER_IDX ON EXPERIMENTALFACTOR
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPFAC_CATGO_IDX ON EXPERIMENTALFACTOR
(CATEGORY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPFAC_DESCSEC_IDX ON EXPERIMENTALFACTOR
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPFAC_EXPDESI_IDX ON EXPERIMENTALFACTOR
(EXPERIMENT_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPFAC_NM_IDX ON EXPERIMENTALFACTOR
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPRPO_ROLE_IDX ON EXPERIMENTPROVIDER
(ROLE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXPR_DESCSEC_IDX ON EXPERIMENT
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX EXP_IDENTIFIER_IDX ON EXPERIMENT
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX EXTERNALREFERENCE_PK ON EXTERNALREFERENCE
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FACTORVALUE_PK ON FACTORVALUE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FACTOR_IDENTIFIER_IDX ON FACTORVALUE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX FACTV_DESCSEC_IDX ON FACTORVALUE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FACTV_EXP_IDX ON FACTORVALUE
(EXPERIMENTAL_FACTOR_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FACTV_MEASU_IDX ON FACTORVALUE
(MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FACTV_NM_IDX ON FACTORVALUE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX FACTV_VALUE_IDX ON FACTORVALUE
(VALUE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEADEF_ARRMAN_IDX ON FEATUREDEFECT
(ARRAY_MANUFACTURE_DEVIATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEADEF_DEFTYPE_IDX ON FEATUREDEFECT
(DEFECT_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEADEF_FEAT_IDX ON FEATUREDEFECT
(FEATURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEADEF_POS_IDX ON FEATUREDEFECT
(POSITION_DELTA_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEAEXTR_DESCSEC_IDX ON FEATUREEXTRACTION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEAEXTR_MEASU_IDX ON FEATUREEXTRACTION
(MEASURED_BIOASSAY_TARGET_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEAEXTR_NM_IDX ON FEATUREEXTRACTION
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEAEXTR_PHYS_IDX ON FEATUREEXTRACTION
(PHYSICAL_BIOASSAY_SOURCE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEAINF_FEAREPMAP_IDX ON FEATUREINFORMATION
(FEATURE_REPORTER_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEAINF_FEAT_IDX ON FEATUREINFORMATION
(FEATURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEATEXTR_IDENTIFIER_IDX ON FEATUREEXTRACTION
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FEATURECONTROLFEATURE_PK ON FEATURECONTROLFEATURE
(FEATURE_ID, CONTROL_FEATURE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FEATURECONTROLLEDFEATURE_PK ON FEATURECONTROLLEDFEATURE
(FEATURE_ID, CONTROLLED_FEATURE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FEATUREDEFECT_PK ON FEATUREDEFECT
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FEATUREEXTRACTION_PK ON FEATUREEXTRACTION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FEATUREINFORMATION_PK ON FEATUREINFORMATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FEATURELOCATION_PK ON FEATURELOCATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FEATURE_IDENTIFIER_IDX ON FEATURE
(IDENTIFIER)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FEATURE_PK ON FEATURE
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX FIDUCIAL_PK ON FIDUCIAL
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FID_ARRGRP_IDX ON FIDUCIAL
(ARRAY_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FID_DESCSEC_IDX ON FIDUCIAL
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FID_DISUNIT_IDX ON FIDUCIAL
(DISTANCE_UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FID_FIDTYPE_IDX ON FIDUCIAL
(FIDUCIAL_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX FID_POS_IDX ON FIDUCIAL
(POSITION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDWAP_DESCSEC_IDX ON HARDWAREAPPLICATION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDWAP_HID_IDX ON HARDWAREAPPLICATION
(HARDWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDWAP_PROT_IDX ON HARDWAREAPPLICATION
(PROTOCOL_APPLICATION_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX HARDWAREAPPLICATION_PK ON HARDWAREAPPLICATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX HARDWAREMANUFACTURERS_PK ON HARDWAREMANUFACTURERS
(HARDWARE_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDWARE_IDENTIFIER_IDX ON HARDWARE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX HARDWARE_PK ON HARDWARE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDWMANF_CON_IDX ON HARDWAREMANUFACTURERS
(CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDWMANF_HARD_IDX ON HARDWAREMANUFACTURERS
(HARDWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDW_DESCSEC_IDX ON HARDWARE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDW_NM_IDX ON HARDWARE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX HARDW_TYPE_IDX ON HARDWARE
(TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX IMAGE_IDENTIFIER_IDX ON IMAGE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX IMAGE_PK ON IMAGE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX IMG_ACQ_IDX ON IMAGE
(IMAGE_ACQUISITION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX IMG_DESCSEC_IDX ON IMAGE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX IMG_FORMAT_IDX ON IMAGE
(FORMAT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX IMG_NM_IDX ON IMAGE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX IMG_PHYS_IDX ON IMAGE
(PHYSICAL_BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX IMMOBILIZEDCHARACTERISTICS_PK ON IMMOBILIZEDCHARACTERISTICS
(REPORTER_ID, BIOSEQUENCE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX LABELEDEXTRACTCOMPOUND_PK ON LABELEDEXTRACTCOMPOUND
(LABELED_EXTRACT_ID, COMPOUND_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX LOG_UID_IDX ON AS_LOG
(TABLE_NAME, ATTRIBUTE_NAME, RECORD_ID, TIMESTAMP)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX MANUFACTURELIMS_PK ON MANUFACTURELIMS
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MANU_ARRMAN_IDX ON MANUFACTURELIMS
(ARRAY_MANUFACTURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MANU_BIOM_IDX ON MANUFACTURELIMS
(BIOMATERIAL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MANU_DESCSEC_IDX ON MANUFACTURELIMS
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MANU_FEAT_IDX ON MANUFACTURELIMS
(FEATURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MANU_IDEN_IDX ON MANUFACTURELIMS
(IDENTIFIER_LIMS_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX MEASUREDBIOASSAYDATA_PK ON MEASUREDBIOASSAYDATA
(BIOASSAY_ID, BIOASSAY_DATA_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX MEASUREMENT_PK ON MEASUREMENT
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MEASU_UNIT_IDX ON MEASUREMENT
(UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX MISMATCHINFORMATION_PK ON MISMATCHINFORMATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MISMAT_COMPOS_IDX ON MISMATCHINFORMATION
(COMPOSITE_POSITION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MISMAT_FEAT_IDX ON MISMATCHINFORMATION
(FEATURE_INFORMATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX MISMAT_REPPOS_IDX ON MISMATCHINFORMATION
(REPORTER_POSITION_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX MOM_MESSAGEDATA_PK ON MOM_MESSAGEDATA
(ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX NAMEVALUETYPE_PK ON NAMEVALUETYPE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDC_ASYDM_IDX ON NODECONTENTS
(BIOASSAY_DIMENSION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDC_DESCSEC_IDX ON NODECONTENTS
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDC_DESIELM_IDX ON NODECONTENTS
(DESIGN_ELEMENT_DIMENSION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDC_NDID_IDX ON NODECONTENTS
(NODE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDC_QUANDM_IDX ON NODECONTENTS
(QUANTITATION_DIMENSION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDV_DATATYPE_IDX ON NODEVALUE
(DATA_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDV_NDID_IDX ON NODEVALUE
(NODE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDV_SCALE_IDX ON NODEVALUE
(SCALE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NDV_TYPE_IDX ON NODEVALUE
(TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NMV_ARRMAN_IDX ON NAMEVALUETYPE
(ARRAY_MANUFACTURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NMV_BIOASY_IDX ON NAMEVALUETYPE
(BIOASSAY_DATA_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NMV_BIOM_IDX ON NAMEVALUETYPE
(BIOMATERIAL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NMV_NMVTYPE_IDX ON NAMEVALUETYPE
(NAME_VALUE_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NMV_NM_IDX ON NAMEVALUETYPE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX NMV_SECELM_IDX ON NAMEVALUETYPE
(SECURED_ELEMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX NODECONTENTS_PK ON NODECONTENTS
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX NODEVALUE_PK ON NODEVALUE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NODE_ASSDATACLUS_IDX ON NODE
(BIOASSAY_DATA_CLUSTER_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NODE_DESCSEC_IDX ON NODE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NODE_NDID_IDX ON NODE
(NODE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX NODE_PK ON NODE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX NVT_EXTENDABLE_IN ON NAMEVALUETYPE
(EXTENDABLE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX OJB_HL_SEQ_PK ON OJB_HL_SEQ
(TABLENAME, FIELDNAME)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ONTOLOGYENTRYCHILDREN_PK ON ONTOLOGYENTRYCHILDREN
(ONTOLOGY_ENTRY_ID, CHILD_ONTOLOGY_ENTRY_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ONTOLOGYENTRY_PK ON ONTOLOGYENTRY
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_AGEV_IDX ON ONTOLOGYENTRY
(AGE_VALUE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_BIB_IDX ON ONTOLOGYENTRY
(BIBLIOGRAPHIC_REFERENCE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_COMP_IDX ON ONTOLOGYENTRY
(COMPOUND_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_CONT_IDX ON ONTOLOGYENTRY
(CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_EXPFACT_IDX ON ONTOLOGYENTRY
(EXPERIMENTAL_FACTOR_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_HTMEASU_IDX ON ONTOLOGYENTRY
(HEIGHT_MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_HT_IDX ON ONTOLOGYENTRY
(HEIGHT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_INIT_IDX ON ONTOLOGYENTRY
(INITIAL_TIME_POINT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_MAXMEASU_IDX ON ONTOLOGYENTRY
(MAX_MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_MAX_IDX ON ONTOLOGYENTRY
(MAX_VALUE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_MEASU_IDX ON ONTOLOGYENTRY
(MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_MINMEASU_IDX ON ONTOLOGYENTRY
(MIN_MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_MINV_IDX ON ONTOLOGYENTRY
(MIN_VALUE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_ONTREF_IDX ON ONTOLOGYENTRY
(ONTOLOGY_REFERENCE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_WTMEASU_IDX ON ONTOLOGYENTRY
(WEIGHT_MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ONT_WT_IDX ON ONTOLOGYENTRY
(WEIGHT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ORGANIZATION_PK ON ORGANIZATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ORGAN_IDENTIFIER_IDX ON ORGANIZATION
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX ORG_ARRMAN_IDX ON ORGANIZATION
(ARRAY_MANUFACTURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ORG_DESCSEC_IDX ON ORGANIZATION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ORG_NM_IDX ON ORGANIZATION
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX ORG_PARENT_IDX ON ORGANIZATION
(PARENT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PARAMETERIZABLEAPPLICATION_PK ON PARAMETERIZABLEAPPLICATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PARAMETERIZABLE_PK ON PARAMETERIZABLE
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PARAMETERVALUE_PK ON PARAMETERVALUE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PARAMETER_IDENTIFIER_IDX ON PARAMETER
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PARAMETER_PK ON PARAMETER
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PARMV_PAPP_IDX ON PARAMETERVALUE
(PARAMETERIZABLE_APPLICATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PARMV_PTYPE_IDX ON PARAMETERVALUE
(PARAMETER_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PARM_DEFV_IDX ON PARAMETER
(DEFAULT_VALUE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PARM_DESCSEC_IDX ON PARAMETER
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PARM_DTYPE_IDX ON PARAMETER
(DATA_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PARM_NM_IDX ON PARAMETER
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX PARM_PAR_IDX ON PARAMETER
(PARAMETERIZABLE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PERSON_AFF_IDX ON PERSON
(AFFILIATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PERSON_ARRMAN_IDX ON PERSON
(ARRAY_MANUFACTURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PERSON_DESCSEC_IDX ON PERSON
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PERSON_IDENTIFIER_IDX ON PERSON
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX PERSON_NM_IDX ON PERSON
(NAME)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PERSON_PK ON PERSON
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PK_A_ASSOC_PK ON TST_A_ASSOC
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PK_BASE_ASSOC ON TST_BASE_ASSOC
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PK_B_ASSOC_PK ON TST_B_ASSOC
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PK_C_ASSOC_PK ON TST_C_ASSOC
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PK_TST_BASE ON TST_BASE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX POSDEL_DISUNIT_IDX ON POSITIONDELTA
(DISTANCE_UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX POSITIONDELTA_PK ON POSITIONDELTA
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX POSITION_PK ON POSITION
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX POS_DISUNIT_IDX ON POSITION
(DISTANCE_UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROTAP_ARRDESI_IDX ON PROTOCOLAPPLICATION
(ARRAY_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROTAP_ARRMAN_IDX ON PROTOCOLAPPLICATION
(ARRAY_MANUFACTURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROTAP_BIOEVNT_IDX ON PROTOCOLAPPLICATION
(BIOEVENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROTAP_DESCSEC_IDX ON PROTOCOLAPPLICATION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROTAP_PROT_IDX ON PROTOCOLAPPLICATION
(PROTOCOL_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PROTECTION_GROUP_ELEMENT_COMB ON AS_PROTECTION_GROUP_ELEMENT
(PROTECTION_GROUP_ID, PROTECTION_ELEMENT_ID)
LOGGING
NOPARALLEL;


CREATE INDEX PROTECT_ELEMENT_IDX ON AS_USER_ROLE_PROTECT_APP
(PROTECTION_ELEMENT_ID)
LOGGING
NOPARALLEL;


CREATE INDEX PROTECT_GROUP_ID_IDX ON AS_USER_ROLE_PROTECT_APP
(PROTECTION_GROUP_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PROTOCOLAPPLICATION_PK ON PROTOCOLAPPLICATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PROTOCOLHARDWARE_PK ON PROTOCOLHARDWARE
(PROTOCOL_ID, HARDWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PROTOCOLSOFTWARE_PK ON PROTOCOLSOFTWARE
(PROTOCOL_ID, SOFTWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROTOCOL_IDENTIFIER_IDX ON PROTOCOL
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX PROTOCOL_PK ON PROTOCOL
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROT_DESCSEC_IDX ON PROTOCOL
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROT_NM_IDX ON PROTOCOL
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX PROT_TYPE_IDX ON PROTOCOL
(TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANMAP_IDENTIFIER_IDX ON QUANTITATIONTYPEMAP
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANMEN_IDENTIFIER_IDX ON QUANTITATIONTYPEDIMENSION
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX QUANTITATIONTYPEDIMENSION_PK ON QUANTITATIONTYPEDIMENSION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX QUANTITATIONTYPEMAPPING_PK ON QUANTITATIONTYPEMAPPING
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX QUANTITATIONTYPEMAPSOURCES_PK ON QUANTITATIONTYPEMAPSOURCES
(QUANTITATION_TYPE_ID, QUANTITATION_TYPE_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX QUANTITATIONTYPEMAPS_PK ON QUANTITATIONTYPEMAPS
(QUANTITATION_TYPE_MAPPING_ID, QUANTITATION_TYPE_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX QUANTITATIONTYPEMAP_PK ON QUANTITATIONTYPEMAP
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX QUANTITATIONTYPETUPLE_PK ON QUANTITATIONTYPETUPLE
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX QUANTITATIONTYPE_PK ON QUANTITATIONTYPE
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX QUANTTYPEDIMENSIONQUANTTYPE_PK ON QUANTTYPEDIMENSIONQUANTTYPE
(QUANTITATION_TYPE_DIMENSION_ID, QUANTITATION_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTUP_DAT_IDX ON QUANTITATIONTYPETUPLE
(DATUM_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTUP_ELMTUP_IDX ON QUANTITATIONTYPETUPLE
(DESIGN_ELEMENT_TUPLE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTUP_QUANTYPE_IDX ON QUANTITATIONTYPETUPLE
(QUANTITATION_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTYDM_DESCSEC_IDX ON QUANTITATIONTYPEDIMENSION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTYDM_NM_IDX ON QUANTITATIONTYPEDIMENSION
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTYMAP_DESCSEC_IDX ON QUANTITATIONTYPEMAP
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTYMAP_NM_IDX ON QUANTITATIONTYPEMAP
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTYMAP_TYPE_IDX ON QUANTITATIONTYPEMAP
(QUANTITATION_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTYPE_IDENTIFIER_IDX ON QUANTITATIONTYPE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTY_CHAN_IDX ON QUANTITATIONTYPE
(CHANNEL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTY_DATATYPE_IDX ON QUANTITATIONTYPE
(DATA_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTY_DESCSEC_IDX ON QUANTITATIONTYPE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTY_NM_IDX ON QUANTITATIONTYPE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTY_QUANTYPE_IDX ON QUANTITATIONTYPE
(QUANTITATION_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX QUANTY_SCALE_IDX ON QUANTITATIONTYPE
(SCALE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX RECORD_ID_IND ON AS_LOG
(RECORD_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX REPORTERDIMENSIONREPORTER_PK ON REPORTERDIMENSIONREPORTER
(REPORTER_DIMENSION_ID, REPORTER_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX REPORTERONTOLOGYENTRY_PK ON REPORTERONTOLOGYENTRY
(REPORTER_ID, ONTOLOGY_ENTRY_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX REPORTER_PK ON REPORTER
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX REP_IDENTIFIER_IDX ON REPORTER
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX REP_NM_IDX ON REPORTER
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX ROLE_ID_IDX ON AS_USER_ROLE_PROTECT_APP
(ROLE_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ROLE_PRIVILEGE_COMB ON AS_ROLE_PRIVILEGE
(ROLE_ID, PRIVILEGE_ID)
LOGGING
NOPARALLEL;


CREATE INDEX SECCON_CON_IDX ON SECURITYCONTACT
(CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SECCON_SEC_IDX ON SECURITYCONTACT
(SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SECGRPCON_CON_IDX ON SECURITYGROUPCONTACT
(CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SECGRPCON_SEC_ID ON SECURITYGROUPCONTACT
(SECURITY_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SECGRP_DESCSEC_IDX ON SECURITYGROUP
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SECGRP_IDENTIFIER_IDX ON SECURITYGROUP
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX SECGRP_NM_IDX ON SECURITYGROUP
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX SECSECGRP_SECGRP_IDX ON SECURITYSECURITYGROUP
(SECURITY_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SECSECGRP_SEC_IDX ON SECURITYSECURITYGROUP
(SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SECURITYCONTACT_PK ON SECURITYCONTACT
(SECURITY_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SECURITYGROUPCONTACT_PK ON SECURITYGROUPCONTACT
(SECURITY_GROUP_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SECURITYGROUP_PK ON SECURITYGROUP
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SECURITYSECURITYGROUP_PK ON SECURITYSECURITYGROUP
(SECURITY_ID, SECURITY_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SECURITY_PK ON SECURITY
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEC_DESCSEC_IDX ON SECURITY
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEC_IDENTIFIER_IDX ON SECURITY
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEC_NM_IDX ON SECURITY
(NAME)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SEQFEATURELOCATION_PK ON SEQFEATURELOCATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SEQFEATURE_PK ON SEQFEATURE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQFLOC_COORD_IDX ON SEQFEATURELOCATION
(COORDINATE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQFLOC_FEAT_IDX ON SEQFEATURELOCATION
(SEQ_FEATURE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQFLOC_SEQLOC_IDX ON SEQFEATURELOCATION
(SEQ_FEATURE_LOC_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQF_BIOSEQ_IDX ON SEQFEATURE
(BIOSEQUENCE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQF_DESCSEC_IDX ON SEQFEATURE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQPOS_COMAP_IDX ON SEQUENCEPOSITION
(COMPOSITE_COMPOSITE_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQPOS_COM_IDX ON SEQUENCEPOSITION
(COMPOSITE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQPOS_REPCOMAP_IDX ON SEQUENCEPOSITION
(REPORTER_COMPOSITE_MAP_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SEQPOS_REP_IDX ON SEQUENCEPOSITION
(REPORTER_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SEQUENCEPOSITION_PK ON SEQUENCEPOSITION
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTWAP_DESCSEC_IDX ON SOFTWAREAPPLICATION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTWAP_PROT_IDX ON SOFTWAREAPPLICATION
(PROTOCOL_APPLICATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTWAP_SOFT_IDX ON SOFTWAREAPPLICATION
(SOFTWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SOFTWARE2SOFTWARE_PK ON SOFTWARE2SOFTWARE
(SOFTWARE_ID, ASSOCIATED_SOFTWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SOFTWAREAPPLICATION_PK ON SOFTWAREAPPLICATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SOFTWAREMANUFACTURERS_PK ON SOFTWAREMANUFACTURERS
(SOFTWARE_ID, CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTWARE_IDENTIFIER_IDX ON SOFTWARE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX SOFTWARE_PK ON SOFTWARE
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTWMF_CON_IDX ON SOFTWAREMANUFACTURERS
(CONTACT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTWMF_SOFT_IDX ON SOFTWAREMANUFACTURERS
(SOFTWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTW_DESCSEC_IDX ON SOFTWARE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTW_HARD_IDX ON SOFTWARE
(HARDWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTW_NM_IDX ON SOFTWARE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTW_SOFT_IDX ON SOFTWARE
(SOFTWARE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX SOFTW_TYPE_IDX ON SOFTWARE
(TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TABLE_IND ON AS_LOG
(TABLE_NAME)
LOGGING
NOPARALLEL;


CREATE INDEX TIMESTAMP_IND ON AS_LOG
(TIMESTAMP)
LOGGING
NOPARALLEL;


CREATE INDEX TOPBIOASY_BIO_IDX ON TOPLEVELBIOASSAYS
(BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TOPBIOASY_EXP_IDX ON TOPLEVELBIOASSAYS
(EXPERIMENT_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX TOPLEVELBIOASSAYS_PK ON TOPLEVELBIOASSAYS
(EXPERIMENT_DESIGN_ID, BIOASSAY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX TPSQL_IDX ON TOAD_PLAN_SQL
(STATEMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TPTBL2_IDX ON TOAD2_PLAN_TABLE
(STATEMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TPTBL_IDX ON TOAD_PLAN_TABLE
(STATEMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRAM_BIOASYMAP_IDX ON TRANSFORMATION
(BIOASSAY_MAPPING_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRAM_BIOT_IDX ON TRANSFORMATION
(DER_BIOASSAY_DATA_TARGET_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRAM_DESCSEC_IDX ON TRANSFORMATION
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRAM_ELMAP_IDX ON TRANSFORMATION
(DESIGN_ELEMENT_MAPPING_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRAM_NM_IDX ON TRANSFORMATION
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRAM_QUAN_IDX ON TRANSFORMATION
(QUANTITATION_TYPE_MAPPING_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRAM_SEC_IDX ON TRANSFORMATION
(SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX TRANSFORMATION_PK ON TRANSFORMATION
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX TRANSFORMEDBIOASSAYDATA_PK ON TRANSFORMEDBIOASSAYDATA
(TRANSFORMATION_ID, BIOASSAY_DATA_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRANS_IDENTIFIER_IDX ON TRANSFORMATION
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX TREATMENT_PK ON TREATMENT
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRSMBIO_BIO_IDX ON TRANSFORMEDBIOASSAYDATA
(BIOASSAY_DATA_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRSMBIO_TRANSF_IDX ON TRANSFORMEDBIOASSAYDATA
(TRANSFORMATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRX_ACTMEA_IDX ON TREATMENT
(ACTION_MEASUREMENT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRX_ACT_IDX ON TREATMENT
(ACTION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRX_BIOM_IDX ON TREATMENT
(BIOMATERIAL_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRX_DESCSEC_IDX ON TREATMENT
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRX_IDENTIFIER_IDX ON TREATMENT
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE INDEX TRX_NM_IDX ON TREATMENT
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX TSTA_AID_IDX ON TST_A_AASSOC
(A_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TSTA_ASSOC_IDX ON TST_A_AASSOC
(AASSOC_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TSTBASE_BAID_IDX ON TST_BASE
(BASE_ASSOC_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TSTB_BID_IDX ON TST_B_ASSOC
(B_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX TSTC_CID_IDX ON TST_C_ASSOC
(C_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX UNIT_PK ON UNIT
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX URPAE_ID_IDX ON AS_USER_ROLE_PROTECT_APP
(USER_ID, ROLE_ID, PROTECTION_GROUP_ID, APPLICATION_ID, PROTECTION_ELEMENT_ID)
LOGGING
NOPARALLEL;


CREATE INDEX USER_ID_IND ON AS_USER_ROLE_PROTECT_APP
(USER_ID)
LOGGING
NOPARALLEL;


CREATE INDEX ZDEF_ARRMAN_IDX ON ZONEDEFECT
(ARRAY_MANUFACTURE_DEVIATION_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZDEF_DEFTYPE_IDX ON ZONEDEFECT
(DEFECT_TYPE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZDEF_POS_IDX ON ZONEDEFECT
(POSITION_DELTA_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZDEF_ZONE_IDX ON ZONEDEFECT
(ZONE_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZGRP_DISUNIT_IDX ON ZONEGROUP
(DISTANCE_UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZGRP_PHYS_IDX ON ZONEGROUP
(PHYSICAL_ARRAY_DESIGN_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZGRP_ZLAY_IDX ON ZONEGROUP
(ZONE_LAYOUT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZLAY_DISUNIT_IDX ON ZONELAYOUT
(DISTANCE_UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZN_DESCSEC_IDX ON ZONE
(DESC_SECURITY_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZN_DISUNIT_IDX ON ZONE
(DISTANCE_UNIT_ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZN_NM_IDX ON ZONE
(NAME)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZN_ZGRP_IDX ON ZONE
(ZONE_GROUP_ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ZONEDEFECT_PK ON ZONEDEFECT
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ZONEGROUP_PK ON ZONEGROUP
(ID)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ZONELAYOUT_PK ON ZONELAYOUT
(ID)
NOLOGGING
NOPARALLEL;


CREATE INDEX ZONE_IDENTIFIER_IDX ON ZONE
(IDENTIFIER)
NOLOGGING
NOPARALLEL;


CREATE UNIQUE INDEX ZONE_PK ON ZONE
(ID)
NOLOGGING
NOPARALLEL;


ALTER TABLE ACTIONPROTOCOLTYPE ADD (
  CONSTRAINT ACTIONPROTOCOLTYPE_PK PRIMARY KEY (ACTION_ID, PROTOCOL_TYPE_ID));


ALTER TABLE AFFYBACKGROUND ADD (
  CONSTRAINT AFFYBACKGROUND_PK PRIMARY KEY (ID));


ALTER TABLE AFFYCALLSUMMARY ADD (
  CONSTRAINT AFFYCALLSUMMARY_PK PRIMARY KEY (ID));


ALTER TABLE AFFYCONTROL ADD (
  CONSTRAINT AFFYCONTROL_PK PRIMARY KEY (ID));


ALTER TABLE AFFYHOUSEKEEPINGCONTROL ADD (
  CONSTRAINT AFFYHOUSEKEEPINGCONTROL_PK PRIMARY KEY (ID));


ALTER TABLE AFFYMETRIX ADD (
  CONSTRAINT AFFYMETRIX_PK PRIMARY KEY (ID));


ALTER TABLE AFFYSPIKECONTROL ADD (
  CONSTRAINT AFFYSPIKECONTROL_PK PRIMARY KEY (ID));


ALTER TABLE AGILENT ADD (
  CONSTRAINT AGILENT_PK PRIMARY KEY (ID));


ALTER TABLE ANALYSISRESULTS ADD (
  CONSTRAINT ANALYSISRESULTS_PK PRIMARY KEY (EXPERIMENT_ID, BIOASSAY_DATA_CLUSTER_ID));


ALTER TABLE APPLICATIONPERFORMER ADD (
  CONSTRAINT APPLICATIONPERFORMER_PK PRIMARY KEY (PROTOCOL_APPLICATION_ID, PERSON_ID));


ALTER TABLE ARRAY ADD (
  CONSTRAINT ARRAY_PK PRIMARY KEY (ID));


ALTER TABLE ARRAYDESIGN ADD (
  CONSTRAINT ARRAYDESIGN_CK_1 CHECK (REPORTERFILETYPE IN ('MAGE-ML','GAL') ));

ALTER TABLE ARRAYDESIGN ADD (
  CONSTRAINT ARRAYDESIGN_CK_2 CHECK (DELETED IN (0, 1) ));

ALTER TABLE ARRAYDESIGN ADD (
  CONSTRAINT ARRAYDESIGN_PK PRIMARY KEY (ID));


ALTER TABLE ARRAYDESIGNCOMPOSITEGRP ADD (
  CONSTRAINT ARRAYDESIGNCOMPOSITEGRP_PK PRIMARY KEY (ARRAY_DESIGN_ID, COMPOSITE_GROUP_ID));


ALTER TABLE ARRAYDESIGNFEATUREGRP ADD (
  CONSTRAINT ARRAYDESIGNFEATUREGRP_PK PRIMARY KEY (ARRAY_DESIGN_ID, FEATURE_GROUP_ID));


ALTER TABLE ARRAYDESIGNPROVIDER ADD (
  CONSTRAINT ARRAYDESIGNPROVIDER_PK PRIMARY KEY (ARRAY_DESIGN_ID, CONTACT_ID));


ALTER TABLE ARRAYDESIGNREPORTERGRP ADD (
  CONSTRAINT ARRAYDESIGNREPORTERGRP_PK PRIMARY KEY (ARRAY_DESIGN_ID, REPORTER_GROUP_ID));


ALTER TABLE ARRAYGROUP ADD (
  CONSTRAINT ARRAYGROUP_PK PRIMARY KEY (ID));


ALTER TABLE ARRAYMANUFACTURE ADD (
  CONSTRAINT ARRAYMANUFACTURE_PK PRIMARY KEY (ID));


ALTER TABLE ARRAYMANUFACTUREDEVIATION ADD (
  CONSTRAINT ARRAYMANUFACTUREDEVIATION_PK PRIMARY KEY (ID));


ALTER TABLE ARRAYMANUFACTURER ADD (
  CONSTRAINT ARRAYMANUFACTURER_PK PRIMARY KEY (ARRAY_MANUFACTURE_ID, CONTACT_ID));


ALTER TABLE AS_APPLICATION ADD (
  PRIMARY KEY (APPLICATION_ID));


ALTER TABLE AS_APPLICATION_PRIVILEGE ADD (
  PRIMARY KEY (APPLICATION_PRIVILEGE_ID));


ALTER TABLE AS_APP_PROTECTION_ELEMENT ADD (
  PRIMARY KEY (APP_PROTECTION_ELEMENT_ID));


ALTER TABLE AS_APP_PROTECTION_GROUP ADD (
  PRIMARY KEY (APP_PROTECTION_GROUP_ID));


ALTER TABLE AS_LOG ADD (
  PRIMARY KEY (LOG_ID));


ALTER TABLE AS_PRIVILEGE ADD (
  PRIMARY KEY (PRIVILEGE_ID));


ALTER TABLE AS_PROTECTION_ELEMENT ADD (
  PRIMARY KEY (PROTECTION_ELEMENT_ID));


ALTER TABLE AS_PROTECTION_GROUP ADD (
  PRIMARY KEY (PROTECTION_GROUP_ID));


ALTER TABLE AS_PROTECTION_GROUP_ELEMENT ADD (
  PRIMARY KEY (PROTECTION_GROUP_ELEMENT_ID));


ALTER TABLE AS_PROTECTION_GROUP_TYPE ADD (
  PRIMARY KEY (PROTECTION_GROUP_TYPE_ID));


ALTER TABLE AS_PROTECTION_TYPE ADD (
  PRIMARY KEY (PROTECTION_TYPE_ID));


ALTER TABLE AS_ROLE ADD (
  PRIMARY KEY (ROLE_ID));


ALTER TABLE AS_ROLE_PRIVILEGE ADD (
  PRIMARY KEY (ROLE_PRIVILEGE));


ALTER TABLE AS_USER ADD (
  PRIMARY KEY (USER_ID));


ALTER TABLE AS_USER_ROLE_PROTECT_APP ADD (
  PRIMARY KEY (URPA_ID));


ALTER TABLE AUDIT_TBL ADD (
  CONSTRAINT AUDIT_TBL_PK PRIMARY KEY (ID));


ALTER TABLE BIBLIOGRAPHICREFERENCE ADD (
  CONSTRAINT BIBLIOGRAPHICREFERENCE_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAY ADD (
  CONSTRAINT BIOASSAY_CK_1 CHECK (DELETED IN (0, 1)));

ALTER TABLE BIOASSAY ADD (
  CONSTRAINT BIOASSAY_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAYCHANNEL ADD (
  CONSTRAINT BIOASSAYCHANNEL_PK PRIMARY KEY (BIOASSAY_ID, CHANNEL_ID));


ALTER TABLE BIOASSAYCREATION ADD (
  CONSTRAINT BIOASSAYCREATION_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAYDATA ADD (
  CONSTRAINT BIOASSAYDATA_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAYDATACLUSTER ADD (
  CONSTRAINT BIOASSAYDATACLUSTER_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAYDIMENSION ADD (
  CONSTRAINT BIOASSAYDIMENSION_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAYDIMENSIONBIOASSAY ADD (
  CONSTRAINT BIOASSAYDIMENSIONBIOASSAY_PK PRIMARY KEY (BIOASSAY_DIMENSION_ID, BIOASSAY_ID));


ALTER TABLE BIOASSAYFACTORVALUE ADD (
  CONSTRAINT BIOASSAYFACTORVALUE_PK PRIMARY KEY (BIOASSAY_ID, FACTOR_VALUE_ID));


ALTER TABLE BIOASSAYMAP ADD (
  CONSTRAINT BIOASSAYMAP_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAYMAPBIOASSAY ADD (
  CONSTRAINT BIOASSAYMAPBIOASSAY_PK PRIMARY KEY (BIOASSAY_MAP_ID, BIOASSAY_ID));


ALTER TABLE BIOASSAYMAPPING ADD (
  CONSTRAINT BIOASSAYMAPPING_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAYMAPS ADD (
  CONSTRAINT BIOASSAYMAPS_PK PRIMARY KEY (BIOASSAY_MAPPING_ID, BIOASSAY_MAP_ID));


ALTER TABLE BIOASSAYTREATMENT ADD (
  CONSTRAINT BIOASSAYTREATMENT_PK PRIMARY KEY (ID));


ALTER TABLE BIOASSAYTUPLE ADD (
  CONSTRAINT BIOASSAYTUPLE_PK PRIMARY KEY (ID));


ALTER TABLE BIODATAVALUES ADD (
  CONSTRAINT BIODATAVALUES_PK PRIMARY KEY (ID));


ALTER TABLE BIOLOGICALCHARACTERISTICS ADD (
  CONSTRAINT BIOLOGICALCHARACTERISTICS_PK PRIMARY KEY (COMPOSITE_SEQUENCE_ID, BIOSEQUENCE_ID));


ALTER TABLE BIOMATERIAL ADD (
  CONSTRAINT BIOMATERIAL_CK_1 CHECK (IMPORTED IN
(0, 1) ));

ALTER TABLE BIOMATERIAL ADD (
  CONSTRAINT BIOMATERIAL_PK PRIMARY KEY (ID));


ALTER TABLE BIOMATERIALCHARACTERISTICS ADD (
  CONSTRAINT BIOMATERIALCHARACTERISTICS_PK PRIMARY KEY (BIOMATERIAL_ID, ONTOLOGY_ENTRY_ID));


ALTER TABLE BIOMATERIALMEASUREMENT ADD (
  CONSTRAINT BIOMATERIALMEASUREMENT_PK PRIMARY KEY (ID));


ALTER TABLE BIOSEQUENCE ADD (
  CONSTRAINT BIOSEQUENCE_PK PRIMARY KEY (ID));


ALTER TABLE BIOSEQUENCEONTOLOGYENTRY ADD (
  CONSTRAINT BIOSEQUENCEONTOLOGYENTRY_PK PRIMARY KEY (BIOSEQUENCE_ID, ONTOLOGY_ENTRY_ID));


ALTER TABLE BIOSOURCECONTACT ADD (
  CONSTRAINT BIOSOURCECONTACT_PK PRIMARY KEY (BIOSOURCE_ID, CONTACT_ID));


ALTER TABLE CA_ADDITIONALFILE ADD (
  CONSTRAINT CA_ADDITIONALFILE_PK PRIMARY KEY (ID));


ALTER TABLE CA_ADDITIONALPROCESSFILE ADD (
  CONSTRAINT CA_ADDITIONALPROCESSINGFILE_PK PRIMARY KEY (ID));


ALTER TABLE CA_CHANNELONEFACTORVALUES ADD (
  CONSTRAINT CA_CHANNELONEFACTORVALUES_PK PRIMARY KEY (HYBRIDIZATION_FILE_UPLOAD_ID, FACTOR_VALUE_ID));


ALTER TABLE CA_CHANNELTWOFACTORVALUES ADD (
  CONSTRAINT CA_CHANNELTWOFACTORVALUES_PK PRIMARY KEY (HYBRIDIZATION_FILE_UPLOAD_ID, FACTOR_VALUE_ID));


ALTER TABLE CA_HYBRIDIZATIONFILEUPLOAD ADD (
  CONSTRAINT CA_HYBRIDIZATIONFILEUPLOAD_PK PRIMARY KEY (ID));


ALTER TABLE CHANNEL ADD (
  CONSTRAINT CHANNEL_PK PRIMARY KEY (ID));


ALTER TABLE CHANNELCOMPOUND ADD (
  CONSTRAINT CHANNELCOMPOUND_PK PRIMARY KEY (CHANNEL_ID, COMPOUND_ID));


ALTER TABLE COMPOSITESEQUENCE ADD (
  CONSTRAINT COMPOSITESEQUENCE_PK PRIMARY KEY (ID));


ALTER TABLE COMPOUND ADD (
  CONSTRAINT COMPOUND_PK PRIMARY KEY (ID));


ALTER TABLE COMPOUNDMEASUREMENT ADD (
  CONSTRAINT COMPOUNDMEASUREMENT_PK PRIMARY KEY (ID));


ALTER TABLE COMPSEQDIMENSIONCOMPSEQ ADD (
  CONSTRAINT COMPSEQDIMENSIONCOMPSEQ_PK PRIMARY KEY (COMP_SEQ_DIMENSION_ID, COMP_SEQ_ID));


ALTER TABLE CONTACT ADD (
  CONSTRAINT CONTACT_PK PRIMARY KEY (ID));


ALTER TABLE DATABASE ADD (
  CONSTRAINT DATABASE_CK_1 CHECK (userdefined IN (0, 1) ));

ALTER TABLE DATABASE ADD (
  CONSTRAINT DATABASE_PK PRIMARY KEY (ID));


ALTER TABLE DATABASECONTACT ADD (
  CONSTRAINT DATABASECONTACT_PK PRIMARY KEY (DATABASE_ID, CONTACT_ID));


ALTER TABLE DATABASEENTRY ADD (
  CONSTRAINT DATABASEENTRY_PK PRIMARY KEY (ID));


ALTER TABLE DATAEXTERNAL ADD (
  CONSTRAINT DATAEXTERNAL_PK PRIMARY KEY (ID));


ALTER TABLE DATAINTERNAL ADD (
  CONSTRAINT DATAINTERNAL_PK PRIMARY KEY (ID));


ALTER TABLE DATUM ADD (
  CONSTRAINT DATUM_PK PRIMARY KEY (ID));


ALTER TABLE DERIVEDBIOASSAYDATA ADD (
  CONSTRAINT DERIVEDBIOASSAYDATA_PK PRIMARY KEY (BIOASSAY_ID, BIOASSAY_DATA_ID));


ALTER TABLE DESCRIPTION ADD (
  CONSTRAINT DESCRIPTION_PK PRIMARY KEY (ID));


ALTER TABLE DESCRIPTIONONTOLOGYENTRY ADD (
  CONSTRAINT DESCRIPTIONONTOLOGYENTRY_PK PRIMARY KEY (DESCRIPTION_ID, ONTOLOGY_ENTRY_ID));


ALTER TABLE DESIGNELEMENTDIMENSION ADD (
  CONSTRAINT DESIGNELEMENTDIMENSION_PK PRIMARY KEY (ID));


ALTER TABLE DESIGNELEMENTGROUP ADD (
  CONSTRAINT DESIGNELEMENTGROUP_PK PRIMARY KEY (ID));


ALTER TABLE DESIGNELEMENTGROUPTYPES ADD (
  CONSTRAINT DESIGNELEMENTGROUPTYPES_PK PRIMARY KEY (DESIGN_ELEMENT_GROUP_ID, ONTOLOGY_ENTRY_ID));


ALTER TABLE DESIGNELEMENTMAP ADD (
  CONSTRAINT DESIGNELEMENTMAP_PK PRIMARY KEY (ID));


ALTER TABLE DESIGNELEMENTMAPPING ADD (
  CONSTRAINT DESIGNELEMENTMAPPING_PK PRIMARY KEY (ID));


ALTER TABLE DESIGNELEMENTMAPS ADD (
  CONSTRAINT DESIGNELEMENTMAPS_PK PRIMARY KEY (DESIGN_ELEMENT_MAPPING_ID, DESIGN_ELEMENT_MAP_ID));


ALTER TABLE DESIGNELEMENTTUPLE ADD (
  CONSTRAINT DESIGNELEMENTTUPLE_PK PRIMARY KEY (ID));


ALTER TABLE EXPERIMENT ADD (
  CONSTRAINT EXPERIMENT_CK_1 CHECK (DELETED IN (0, 1)));

ALTER TABLE EXPERIMENT ADD (
  CONSTRAINT EXPERIMENT_PK PRIMARY KEY (ID));


ALTER TABLE EXPERIMENTALFACTOR ADD (
  CONSTRAINT EXPERIMENTALFACTOR_PK PRIMARY KEY (ID));


ALTER TABLE EXPERIMENTBIOASSAY ADD (
  CONSTRAINT EXPERIMENTBIOASSAY_PK PRIMARY KEY (EXPERIMENT_ID, BIOASSAY_ID));


ALTER TABLE EXPERIMENTBIOASSAYDATA ADD (
  CONSTRAINT EXPERIMENTBIOASSAYDATA_PK PRIMARY KEY (EXPERIMENT_ID, BIOASSAY_DATA_ID));


ALTER TABLE EXPERIMENTDESIGN ADD (
  CONSTRAINT EXPERIMENTDESIGN_PK PRIMARY KEY (ID));


ALTER TABLE EXPERIMENTDESIGNTYPE ADD (
  CONSTRAINT EXPERIMENTDESIGNTYPE_PK PRIMARY KEY (EXPERIMENT_DESIGN_ID, ONTOLOGY_ENTRY_ID));


ALTER TABLE EXPERIMENTPROVIDER ADD (
  CONSTRAINT EXPERIMENTPROVIDER_PK PRIMARY KEY (EXPERIMENT_ID, CONTACT_ID));


ALTER TABLE EXTERNALREFERENCE ADD (
  CONSTRAINT EXTERNALREFERENCE_PK PRIMARY KEY (ID));


ALTER TABLE FACTORVALUE ADD (
  CONSTRAINT FACTORVALUE_PK PRIMARY KEY (ID));


ALTER TABLE FEATURE ADD (
  CONSTRAINT FEATURE_PK PRIMARY KEY (ID));


ALTER TABLE FEATURECONTROLFEATURE ADD (
  CONSTRAINT FEATURECONTROLFEATURE_PK PRIMARY KEY (FEATURE_ID, CONTROL_FEATURE_ID));


ALTER TABLE FEATURECONTROLLEDFEATURE ADD (
  CONSTRAINT FEATURECONTROLLEDFEATURE_PK PRIMARY KEY (FEATURE_ID, CONTROLLED_FEATURE_ID));


ALTER TABLE FEATUREDEFECT ADD (
  CONSTRAINT FEATUREDEFECT_PK PRIMARY KEY (ID));


ALTER TABLE FEATUREDIMENSIONFEATURE ADD (
  CONSTRAINT FEATUREDIMENSIONFEATURE_PK PRIMARY KEY (FEATURE_DIMENSION_ID, FEATURE_ID) DISABLE);


ALTER TABLE FEATUREEXTRACTION ADD (
  CONSTRAINT FEATUREEXTRACTION_PK PRIMARY KEY (ID));


ALTER TABLE FEATUREINFORMATION ADD (
  CONSTRAINT FEATUREINFORMATION_PK PRIMARY KEY (ID));


ALTER TABLE FEATURELOCATION ADD (
  CONSTRAINT FEATURELOCATION_PK PRIMARY KEY (ID));


ALTER TABLE FIDUCIAL ADD (
  CONSTRAINT FIDUCIAL_PK PRIMARY KEY (ID));


ALTER TABLE HARDWARE ADD (
  CONSTRAINT HARDWARE_PK PRIMARY KEY (ID));


ALTER TABLE HARDWAREAPPLICATION ADD (
  CONSTRAINT HARDWAREAPPLICATION_PK PRIMARY KEY (ID));


ALTER TABLE HARDWAREMANUFACTURERS ADD (
  CONSTRAINT HARDWAREMANUFACTURERS_PK PRIMARY KEY (HARDWARE_ID, CONTACT_ID));


ALTER TABLE IMAGE ADD (
  CONSTRAINT IMAGE_PK PRIMARY KEY (ID));


ALTER TABLE IMMOBILIZEDCHARACTERISTICS ADD (
  CONSTRAINT IMMOBILIZEDCHARACTERISTICS_PK PRIMARY KEY (REPORTER_ID, BIOSEQUENCE_ID));


ALTER TABLE LABELEDEXTRACTCOMPOUND ADD (
  CONSTRAINT LABELEDEXTRACTCOMPOUND_PK PRIMARY KEY (LABELED_EXTRACT_ID, COMPOUND_ID));


ALTER TABLE MANUFACTURELIMS ADD (
  CONSTRAINT MANUFACTURELIMS_PK PRIMARY KEY (ID));


ALTER TABLE MEASUREDBIOASSAYDATA ADD (
  CONSTRAINT MEASUREDBIOASSAYDATA_PK PRIMARY KEY (BIOASSAY_ID, BIOASSAY_DATA_ID));


ALTER TABLE MEASUREMENT ADD (
  CONSTRAINT MEASUREMENT_PK PRIMARY KEY (ID));


ALTER TABLE MISMATCHINFORMATION ADD (
  CONSTRAINT MISMATCHINFORMATION_PK PRIMARY KEY (ID));


ALTER TABLE MOM_MESSAGEDATA ADD (
  CONSTRAINT MOM_MESSAGEDATA_PK PRIMARY KEY (ID));


ALTER TABLE NAMEVALUETYPE ADD (
  CONSTRAINT NAMEVALUETYPE_PK PRIMARY KEY (ID));


ALTER TABLE NODE ADD (
  CONSTRAINT NODE_PK PRIMARY KEY (ID));


ALTER TABLE NODECONTENTS ADD (
  CONSTRAINT NODECONTENTS_PK PRIMARY KEY (ID));


ALTER TABLE NODEVALUE ADD (
  CONSTRAINT NODEVALUE_PK PRIMARY KEY (ID));


ALTER TABLE OJB_HL_SEQ ADD (
  CONSTRAINT OJB_HL_SEQ_PK PRIMARY KEY (TABLENAME, FIELDNAME));


ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_PK PRIMARY KEY (ID));


ALTER TABLE ONTOLOGYENTRYCHILDREN ADD (
  CONSTRAINT ONTOLOGYENTRYCHILDREN_PK PRIMARY KEY (ONTOLOGY_ENTRY_ID, CHILD_ONTOLOGY_ENTRY_ID));


ALTER TABLE ORGANIZATION ADD (
  CONSTRAINT ORGANIZATION_PK PRIMARY KEY (ID));


ALTER TABLE PARAMETER ADD (
  CONSTRAINT PARAMETER_PK PRIMARY KEY (ID));


ALTER TABLE PARAMETERIZABLE ADD (
  CONSTRAINT PARAMETERIZABLE_PK PRIMARY KEY (ID));


ALTER TABLE PARAMETERIZABLEAPPLICATION ADD (
  CONSTRAINT PARAMETERIZABLEAPPLICATION_PK PRIMARY KEY (ID));


ALTER TABLE PARAMETERVALUE ADD (
  CONSTRAINT PARAMETERVALUE_PK PRIMARY KEY (ID));


ALTER TABLE PERSON ADD (
  CONSTRAINT PERSON_PK PRIMARY KEY (ID));


ALTER TABLE POSITION ADD (
  CONSTRAINT POSITION_PK PRIMARY KEY (ID));


ALTER TABLE POSITIONDELTA ADD (
  CONSTRAINT POSITIONDELTA_PK PRIMARY KEY (ID));


ALTER TABLE PROTOCOL ADD (
  CONSTRAINT PROTOCOL_PK PRIMARY KEY (ID));


ALTER TABLE PROTOCOLAPPLICATION ADD (
  CONSTRAINT PROTOCOLAPPLICATION_PK PRIMARY KEY (ID));


ALTER TABLE PROTOCOLHARDWARE ADD (
  CONSTRAINT PROTOCOLHARDWARE_PK PRIMARY KEY (PROTOCOL_ID, HARDWARE_ID));


ALTER TABLE PROTOCOLSOFTWARE ADD (
  CONSTRAINT PROTOCOLSOFTWARE_PK PRIMARY KEY (PROTOCOL_ID, SOFTWARE_ID));


ALTER TABLE QUANTITATIONTYPE ADD (
  CONSTRAINT QUANTITATIONTYPE_PK PRIMARY KEY (ID));


ALTER TABLE QUANTITATIONTYPEDIMENSION ADD (
  CONSTRAINT QUANTITATIONTYPEDIMENSION_PK PRIMARY KEY (ID));


ALTER TABLE QUANTITATIONTYPEMAP ADD (
  CONSTRAINT QUANTITATIONTYPEMAP_PK PRIMARY KEY (ID));


ALTER TABLE QUANTITATIONTYPEMAPPING ADD (
  CONSTRAINT QUANTITATIONTYPEMAPPING_PK PRIMARY KEY (ID));


ALTER TABLE QUANTITATIONTYPEMAPS ADD (
  CONSTRAINT QUANTITATIONTYPEMAPS_PK PRIMARY KEY (QUANTITATION_TYPE_MAPPING_ID, QUANTITATION_TYPE_MAP_ID));


ALTER TABLE QUANTITATIONTYPEMAPSOURCES ADD (
  CONSTRAINT QUANTITATIONTYPEMAPSOURCES_PK PRIMARY KEY (QUANTITATION_TYPE_ID, QUANTITATION_TYPE_MAP_ID));


ALTER TABLE QUANTITATIONTYPETUPLE ADD (
  CONSTRAINT QUANTITATIONTYPETUPLE_PK PRIMARY KEY (ID));


ALTER TABLE QUANTTYPEDIMENSIONQUANTTYPE ADD (
  CONSTRAINT QUANTTYPEDIMENSIONQUANTTYPE_PK PRIMARY KEY (QUANTITATION_TYPE_DIMENSION_ID, QUANTITATION_TYPE_ID));


ALTER TABLE REPORTER ADD (
  CONSTRAINT REPORTER_PK PRIMARY KEY (ID));


ALTER TABLE REPORTERDIMENSIONREPORTER ADD (
  CONSTRAINT REPORTERDIMENSIONREPORTER_PK PRIMARY KEY (REPORTER_DIMENSION_ID, REPORTER_ID));


ALTER TABLE REPORTERONTOLOGYENTRY ADD (
  CONSTRAINT REPORTERONTOLOGYENTRY_PK PRIMARY KEY (REPORTER_ID, ONTOLOGY_ENTRY_ID));


ALTER TABLE SECURITY ADD (
  CONSTRAINT SECURITY_PK PRIMARY KEY (ID));


ALTER TABLE SECURITYCONTACT ADD (
  CONSTRAINT SECURITYCONTACT_PK PRIMARY KEY (SECURITY_ID, CONTACT_ID));


ALTER TABLE SECURITYGROUP ADD (
  CONSTRAINT SECURITYGROUP_PK PRIMARY KEY (ID));


ALTER TABLE SECURITYGROUPCONTACT ADD (
  CONSTRAINT SECURITYGROUPCONTACT_PK PRIMARY KEY (SECURITY_GROUP_ID, CONTACT_ID));


ALTER TABLE SECURITYSECURITYGROUP ADD (
  CONSTRAINT SECURITYSECURITYGROUP_PK PRIMARY KEY (SECURITY_ID, SECURITY_GROUP_ID));


ALTER TABLE SEQFEATURE ADD (
  CONSTRAINT SEQFEATURE_PK PRIMARY KEY (ID));


ALTER TABLE SEQFEATURELOCATION ADD (
  CONSTRAINT SEQFEATURELOCATION_PK PRIMARY KEY (ID));


ALTER TABLE SEQUENCEPOSITION ADD (
  CONSTRAINT SEQUENCEPOSITION_PK PRIMARY KEY (ID));


ALTER TABLE SOFTWARE ADD (
  CONSTRAINT SOFTWARE_PK PRIMARY KEY (ID));


ALTER TABLE SOFTWARE2SOFTWARE ADD (
  CONSTRAINT SOFTWARE2SOFTWARE_PK PRIMARY KEY (SOFTWARE_ID, ASSOCIATED_SOFTWARE_ID));


ALTER TABLE SOFTWAREAPPLICATION ADD (
  CONSTRAINT SOFTWAREAPPLICATION_PK PRIMARY KEY (ID));


ALTER TABLE SOFTWAREMANUFACTURERS ADD (
  CONSTRAINT SOFTWAREMANUFACTURERS_PK PRIMARY KEY (SOFTWARE_ID, CONTACT_ID));


ALTER TABLE TOPLEVELBIOASSAYS ADD (
  CONSTRAINT TOPLEVELBIOASSAYS_PK PRIMARY KEY (EXPERIMENT_DESIGN_ID, BIOASSAY_ID));


ALTER TABLE TRANSFORMATION ADD (
  CONSTRAINT TRANSFORMATION_PK PRIMARY KEY (ID));


ALTER TABLE TRANSFORMEDBIOASSAYDATA ADD (
  CONSTRAINT TRANSFORMEDBIOASSAYDATA_PK PRIMARY KEY (TRANSFORMATION_ID, BIOASSAY_DATA_ID));


ALTER TABLE TREATMENT ADD (
  CONSTRAINT TREATMENT_PK PRIMARY KEY (ID));


ALTER TABLE TST_A_ASSOC ADD (
  CONSTRAINT PK_A_ASSOC_PK PRIMARY KEY (ID));


ALTER TABLE TST_BASE ADD (
  CONSTRAINT PK_TST_BASE PRIMARY KEY (ID));


ALTER TABLE TST_BASE_ASSOC ADD (
  CONSTRAINT PK_BASE_ASSOC PRIMARY KEY (ID));


ALTER TABLE TST_B_ASSOC ADD (
  CONSTRAINT PK_B_ASSOC_PK PRIMARY KEY (ID));


ALTER TABLE TST_C_ASSOC ADD (
  CONSTRAINT PK_C_ASSOC_PK PRIMARY KEY (ID));


ALTER TABLE UNIT ADD (
  CONSTRAINT UNIT_PK PRIMARY KEY (ID));


ALTER TABLE ZONE ADD (
  CONSTRAINT ZONE_PK PRIMARY KEY (ID));


ALTER TABLE ZONEDEFECT ADD (
  CONSTRAINT ZONEDEFECT_PK PRIMARY KEY (ID));


ALTER TABLE ZONEGROUP ADD (
  CONSTRAINT ZONEGROUP_PK PRIMARY KEY (ID));


ALTER TABLE ZONELAYOUT ADD (
  CONSTRAINT ZONELAYOUT_PK PRIMARY KEY (ID));


ALTER TABLE ACTIONPROTOCOLTYPE ADD (
  CONSTRAINT ACTIONPROTOCOLTYPE_FK_1 FOREIGN KEY (ACTION_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ACTIONPROTOCOLTYPE ADD (
  CONSTRAINT ACTIONPROTOCOLTYPE_FK_2 FOREIGN KEY (PROTOCOL_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE AFFYMETRIX ADD (
  CONSTRAINT AFFYMETRIX_FK_1 FOREIGN KEY (BACKGROUND_ID) 
    REFERENCES AFFYBACKGROUND (ID));

ALTER TABLE AFFYMETRIX ADD (
  CONSTRAINT AFFYMETRIX_FK_2 FOREIGN KEY (CALLSUMMARY_ID) 
    REFERENCES AFFYCALLSUMMARY (ID));


ALTER TABLE ANALYSISRESULTS ADD (
  CONSTRAINT ANALYSISRESULTS_FK_1 FOREIGN KEY (EXPERIMENT_ID) 
    REFERENCES EXPERIMENT (ID));

ALTER TABLE ANALYSISRESULTS ADD (
  CONSTRAINT ANALYSISRESULTS_FK_2 FOREIGN KEY (BIOASSAY_DATA_CLUSTER_ID) 
    REFERENCES BIOASSAYDATACLUSTER (ID));


ALTER TABLE APPLICATIONPERFORMER ADD (
  CONSTRAINT APPLICATIONPERFORMER_FK1 FOREIGN KEY (PROTOCOL_APPLICATION_ID) 
    REFERENCES PROTOCOLAPPLICATION (ID));

ALTER TABLE APPLICATIONPERFORMER ADD (
  CONSTRAINT APPLICATIONPERFORMER_FK2 FOREIGN KEY (PERSON_ID) 
    REFERENCES PERSON (ID));


ALTER TABLE ARRAY ADD (
  CONSTRAINT ARRAY_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE ARRAY ADD (
  CONSTRAINT ARRAY_FK_2 FOREIGN KEY (ARRAY_DESIGN_ID) 
    REFERENCES ARRAYDESIGN (ID));

ALTER TABLE ARRAY ADD (
  CONSTRAINT ARRAY_FK_3 FOREIGN KEY (INFORMATION_ID) 
    REFERENCES ARRAYMANUFACTURE (ID));

ALTER TABLE ARRAY ADD (
  CONSTRAINT ARRAY_FK_4 FOREIGN KEY (ARRAY_GROUP_ID) 
    REFERENCES ARRAYGROUP (ID));

ALTER TABLE ARRAY ADD (
  CONSTRAINT ARRAY_FK_5 FOREIGN KEY (ARRAY_MANUFACTURE_ID) 
    REFERENCES ARRAYMANUFACTURE (ID));


ALTER TABLE ARRAYDESIGN ADD (
  CONSTRAINT ARRAYDESIGN_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE ARRAYDESIGN ADD (
  CONSTRAINT ARRAYDESIGN_FK_2 FOREIGN KEY (SURFACE_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE ARRAYDESIGNCOMPOSITEGRP ADD (
  CONSTRAINT ARRAYDESIGNCOMPOSITEGRP_FK1 FOREIGN KEY (ARRAY_DESIGN_ID) 
    REFERENCES ARRAYDESIGN (ID));

ALTER TABLE ARRAYDESIGNCOMPOSITEGRP ADD (
  CONSTRAINT ARRAYDESIGNCOMPOSITEGRP_FK2 FOREIGN KEY (COMPOSITE_GROUP_ID) 
    REFERENCES DESIGNELEMENTGROUP (ID));


ALTER TABLE ARRAYDESIGNFEATUREGRP ADD (
  CONSTRAINT ARRAYDESIGNFEATUREGRP_FK1 FOREIGN KEY (ARRAY_DESIGN_ID) 
    REFERENCES ARRAYDESIGN (ID));

ALTER TABLE ARRAYDESIGNFEATUREGRP ADD (
  CONSTRAINT ARRAYDESIGNFEATUREGRP_FK2 FOREIGN KEY (FEATURE_GROUP_ID) 
    REFERENCES DESIGNELEMENTGROUP (ID));


ALTER TABLE ARRAYDESIGNPROVIDER ADD (
  CONSTRAINT ARRAYDESIGNPROVIDER_FK1 FOREIGN KEY (ARRAY_DESIGN_ID) 
    REFERENCES ARRAYDESIGN (ID));

ALTER TABLE ARRAYDESIGNPROVIDER ADD (
  CONSTRAINT ARRAYDESIGNPROVIDER_FK2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));

ALTER TABLE ARRAYDESIGNPROVIDER ADD (
  CONSTRAINT ARRAYDESIGNPROVIDER_FK3 FOREIGN KEY (ROLE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE ARRAYDESIGNREPORTERGRP ADD (
  CONSTRAINT ARRAYDESIGNREPORTERGRP_FK1 FOREIGN KEY (ARRAY_DESIGN_ID) 
    REFERENCES ARRAYDESIGN (ID));

ALTER TABLE ARRAYDESIGNREPORTERGRP ADD (
  CONSTRAINT ARRAYDESIGNREPORTERGRP_FK2 FOREIGN KEY (REPORTER_GROUP_ID) 
    REFERENCES DESIGNELEMENTGROUP (ID));


ALTER TABLE ARRAYGROUP ADD (
  CONSTRAINT ARRAYGROUP_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE ARRAYGROUP ADD (
  CONSTRAINT ARRAYGROUP_FK_2 FOREIGN KEY (SUBSTRATE_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ARRAYGROUP ADD (
  CONSTRAINT ARRAYGROUP_FK_3 FOREIGN KEY (DISTANCE_UNIT_ID) 
    REFERENCES UNIT (ID));


ALTER TABLE ARRAYMANUFACTURE ADD (
  CONSTRAINT ARRAYMANUFACTURE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE ARRAYMANUFACTUREDEVIATION ADD (
  CONSTRAINT ARRAYMANUFACTUREDEVIATION_FK_1 FOREIGN KEY (ARRAY_ID) 
    REFERENCES ARRAY (ID));


ALTER TABLE ARRAYMANUFACTURER ADD (
  CONSTRAINT ARRAYMANUFACTURER_FK_1 FOREIGN KEY (ARRAY_MANUFACTURE_ID) 
    REFERENCES ARRAYMANUFACTURE (ID));

ALTER TABLE ARRAYMANUFACTURER ADD (
  CONSTRAINT EXPERIMENTPROVIDER_FK_2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));


ALTER TABLE AS_APPLICATION_PRIVILEGE ADD (
  FOREIGN KEY (APPLICATION_ID) 
    REFERENCES AS_APPLICATION (APPLICATION_ID));

ALTER TABLE AS_APPLICATION_PRIVILEGE ADD (
  FOREIGN KEY (PRIVILEGE_ID) 
    REFERENCES AS_PRIVILEGE (PRIVILEGE_ID));


ALTER TABLE AS_APP_PROTECTION_ELEMENT ADD (
  FOREIGN KEY (APPLICATION_ID) 
    REFERENCES AS_APPLICATION (APPLICATION_ID));

ALTER TABLE AS_APP_PROTECTION_ELEMENT ADD (
  FOREIGN KEY (PROTECTION_ELEMENT_ID) 
    REFERENCES AS_PROTECTION_ELEMENT (PROTECTION_ELEMENT_ID));


ALTER TABLE AS_APP_PROTECTION_GROUP ADD (
  FOREIGN KEY (PROTECTION_GROUP_ID) 
    REFERENCES AS_PROTECTION_GROUP (PROTECTION_GROUP_ID));

ALTER TABLE AS_APP_PROTECTION_GROUP ADD (
  FOREIGN KEY (APPLICATION_ID) 
    REFERENCES AS_APPLICATION (APPLICATION_ID));


ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_USER (USER_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_PROTECTION_ELEMENT (PROTECTION_ELEMENT_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (PROTECTION_GROUP_ID) 
    REFERENCES AS_PROTECTION_GROUP (PROTECTION_GROUP_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_ROLE_PRIVILEGE (ROLE_PRIVILEGE));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_APPLICATION_PRIVILEGE (APPLICATION_PRIVILEGE_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_APP_PROTECTION_ELEMENT (APP_PROTECTION_ELEMENT_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_APP_PROTECTION_GROUP (APP_PROTECTION_GROUP_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (PROTECTION_GROUP_ELEMENT_ID) 
    REFERENCES AS_PROTECTION_GROUP_ELEMENT (PROTECTION_GROUP_ELEMENT_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (ACTION_USER_ID) 
    REFERENCES AS_USER (USER_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_ROLE (ROLE_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_PRIVILEGE (PRIVILEGE_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_APPLICATION (APPLICATION_ID));

ALTER TABLE AS_LOG ADD (
  FOREIGN KEY (RECORD_ID) 
    REFERENCES AS_USER_ROLE_PROTECT_APP (URPA_ID));


ALTER TABLE AS_PROTECTION_ELEMENT ADD (
  FOREIGN KEY (USER_ID) 
    REFERENCES AS_USER (USER_ID));


ALTER TABLE AS_PROTECTION_GROUP ADD (
  FOREIGN KEY (PROTECTION_GROUP_TYPE_ID) 
    REFERENCES AS_PROTECTION_GROUP_TYPE (PROTECTION_GROUP_TYPE_ID));


ALTER TABLE AS_PROTECTION_GROUP_ELEMENT ADD (
  FOREIGN KEY (PROTECTION_GROUP_ID) 
    REFERENCES AS_PROTECTION_GROUP (PROTECTION_GROUP_ID));

ALTER TABLE AS_PROTECTION_GROUP_ELEMENT ADD (
  FOREIGN KEY (PROTECTION_ELEMENT_ID) 
    REFERENCES AS_PROTECTION_ELEMENT (PROTECTION_ELEMENT_ID));


ALTER TABLE AS_ROLE ADD (
  FOREIGN KEY (APPLICATION_ID) 
    REFERENCES AS_APPLICATION (APPLICATION_ID));


ALTER TABLE AS_ROLE_PRIVILEGE ADD (
  FOREIGN KEY (ROLE_ID) 
    REFERENCES AS_ROLE (ROLE_ID));

ALTER TABLE AS_ROLE_PRIVILEGE ADD (
  FOREIGN KEY (PRIVILEGE_ID) 
    REFERENCES AS_PRIVILEGE (PRIVILEGE_ID));


ALTER TABLE AS_USER_ROLE_PROTECT_APP ADD (
  FOREIGN KEY (PROTECTION_ELEMENT_ID) 
    REFERENCES AS_PROTECTION_ELEMENT (PROTECTION_ELEMENT_ID));

ALTER TABLE AS_USER_ROLE_PROTECT_APP ADD (
  FOREIGN KEY (PROTECTION_TYPE_ID) 
    REFERENCES AS_PROTECTION_TYPE (PROTECTION_TYPE_ID));

ALTER TABLE AS_USER_ROLE_PROTECT_APP ADD (
  FOREIGN KEY (USER_ID) 
    REFERENCES AS_USER (USER_ID));

ALTER TABLE AS_USER_ROLE_PROTECT_APP ADD (
  FOREIGN KEY (ROLE_ID) 
    REFERENCES AS_ROLE (ROLE_ID));

ALTER TABLE AS_USER_ROLE_PROTECT_APP ADD (
  FOREIGN KEY (APPLICATION_ID) 
    REFERENCES AS_APPLICATION (APPLICATION_ID));

ALTER TABLE AS_USER_ROLE_PROTECT_APP ADD (
  FOREIGN KEY (PROTECTION_GROUP_ID) 
    REFERENCES AS_PROTECTION_GROUP (PROTECTION_GROUP_ID));


ALTER TABLE AUDIT_TBL ADD (
  CONSTRAINT AUDIT_TBL_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE AUDIT_TBL ADD (
  CONSTRAINT AUDIT_TBL_FK_2 FOREIGN KEY (PERFORMER_ID) 
    REFERENCES CONTACT (ID));


ALTER TABLE BIBLIOGRAPHICREFERENCE ADD (
  CONSTRAINT BIBLIOGRAPHICREFERENCE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIBLIOGRAPHICREFERENCE ADD (
  CONSTRAINT BIBLIOGRAPHICREFERENCE_FK_2 FOREIGN KEY (DESCRIPTION_ID) 
    REFERENCES DESCRIPTION (ID));


ALTER TABLE BIOASSAY ADD (
  CONSTRAINT BIOASSAY_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIOASSAY ADD (
  CONSTRAINT BIOASSAY_FK_2 FOREIGN KEY (TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE BIOASSAY ADD (
  CONSTRAINT BIOASSAY_FK_3 FOREIGN KEY (FEATURE_EXTRACTION_ID) 
    REFERENCES FEATUREEXTRACTION (ID));

ALTER TABLE BIOASSAY ADD (
  CONSTRAINT BIOASSAY_FK_4 FOREIGN KEY (BIOASSAY_CREATION_ID) 
    REFERENCES BIOASSAYCREATION (ID));


ALTER TABLE BIOASSAYCHANNEL ADD (
  CONSTRAINT BIOASSAYCHANNEL_FK1 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE BIOASSAYCHANNEL ADD (
  CONSTRAINT BIOASSAYCHANNEL_FK2 FOREIGN KEY (CHANNEL_ID) 
    REFERENCES CHANNEL (ID));


ALTER TABLE BIOASSAYCREATION ADD (
  CONSTRAINT BIOASSAYCREATION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIOASSAYCREATION ADD (
  CONSTRAINT BIOASSAYCREATION_FK_2 FOREIGN KEY (ARRAY_ID) 
    REFERENCES ARRAY (ID));

ALTER TABLE BIOASSAYCREATION ADD (
  CONSTRAINT BIOASSAYCREATION_FK_3 FOREIGN KEY (PHYSICAL_BIOASSAY_TARGET_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE BIOASSAYDATA ADD (
  CONSTRAINT BIOASSAYDATA_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIOASSAYDATA ADD (
  CONSTRAINT BIOASSAYDATA_FK_2 FOREIGN KEY (BIOASSAY_DIMENSION_ID) 
    REFERENCES BIOASSAYDIMENSION (ID));

ALTER TABLE BIOASSAYDATA ADD (
  CONSTRAINT BIOASSAYDATA_FK_3 FOREIGN KEY (DESIGN_ELEMENT_DIMENSION_ID) 
    REFERENCES DESIGNELEMENTDIMENSION (ID));

ALTER TABLE BIOASSAYDATA ADD (
  CONSTRAINT BIOASSAYDATA_FK_4 FOREIGN KEY (QUANTITATION_TYPE_DIMENSION_ID) 
    REFERENCES QUANTITATIONTYPEDIMENSION (ID));

ALTER TABLE BIOASSAYDATA ADD (
  CONSTRAINT BIOASSAYDATA_FK_5 FOREIGN KEY (BIODATA_VALUES_ID) 
    REFERENCES BIODATAVALUES (ID));

ALTER TABLE BIOASSAYDATA ADD (
  CONSTRAINT BIOASSAYDATA_FK_6 FOREIGN KEY (PRODUCER_TRANSFORMATION_ID) 
    REFERENCES TRANSFORMATION (ID));


ALTER TABLE BIOASSAYDATACLUSTER ADD (
  CONSTRAINT BIOASSAYDATACLUSTER_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIOASSAYDATACLUSTER ADD (
  CONSTRAINT BIOASSAYDATACLUSTER_FK_2 FOREIGN KEY (CLUSTER_BIOASSAY_DATA_ID) 
    REFERENCES BIOASSAYDATA (ID));


ALTER TABLE BIOASSAYDIMENSION ADD (
  CONSTRAINT BIOASSAYDIMENSION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE BIOASSAYDIMENSIONBIOASSAY ADD (
  CONSTRAINT BIOASSAYDIMENSIONBIOASSAY_FK1 FOREIGN KEY (BIOASSAY_DIMENSION_ID) 
    REFERENCES BIOASSAYDIMENSION (ID));

ALTER TABLE BIOASSAYDIMENSIONBIOASSAY ADD (
  CONSTRAINT BIOASSAYDIMENSIONBIOASSAY_FK2 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE BIOASSAYFACTORVALUE ADD (
  CONSTRAINT BIOASSAYFACTORVALUE_FK_1 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE BIOASSAYMAP ADD (
  CONSTRAINT BIOASSAYMAP_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIOASSAYMAP ADD (
  CONSTRAINT BIOASSAYMAP_FK_2 FOREIGN KEY (DERIVED_BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE BIOASSAYMAPBIOASSAY ADD (
  CONSTRAINT BIOASSAYMAPBIOASSAY_FK_1 FOREIGN KEY (BIOASSAY_MAP_ID) 
    REFERENCES BIOASSAYMAP (ID));

ALTER TABLE BIOASSAYMAPBIOASSAY ADD (
  CONSTRAINT BIOASSAYMAPBIOASSAY_FK_2 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE BIOASSAYMAPS ADD (
  CONSTRAINT BIOASSAYMAPS_FK1 FOREIGN KEY (BIOASSAY_MAPPING_ID) 
    REFERENCES BIOASSAYMAPPING (ID));

ALTER TABLE BIOASSAYMAPS ADD (
  CONSTRAINT BIOASSAYMAPS_FK2 FOREIGN KEY (BIOASSAY_MAP_ID) 
    REFERENCES BIOASSAYMAP (ID));


ALTER TABLE BIOASSAYTREATMENT ADD (
  CONSTRAINT BIOASSAYTREATMENT_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIOASSAYTREATMENT ADD (
  CONSTRAINT BIOASSAYTREATMENT_FK_2 FOREIGN KEY (PHYSICAL_BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE BIOASSAYTREATMENT ADD (
  CONSTRAINT BIOASSAYTREATMENT_FK_3 FOREIGN KEY (TARGET_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE BIOASSAYTUPLE ADD (
  CONSTRAINT BIOASSAYTUPLE_FK_1 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE BIOASSAYTUPLE ADD (
  CONSTRAINT BIOASSAYTUPLE_FK_2 FOREIGN KEY (BIO_DATA_TUPLES_ID) 
    REFERENCES BIODATAVALUES (ID));


ALTER TABLE BIODATAVALUES ADD (
  CONSTRAINT BIODATAVALUES_FK_1 FOREIGN KEY (DATA_INTERNAL_ID) 
    REFERENCES DATAINTERNAL (ID));

ALTER TABLE BIODATAVALUES ADD (
  CONSTRAINT BIODATAVALUES_FK_2 FOREIGN KEY (DATA_EXTERNAL_ID) 
    REFERENCES DATAEXTERNAL (ID));


ALTER TABLE BIOLOGICALCHARACTERISTICS ADD (
  CONSTRAINT BIOLOGICALCHARACTERISTICS_FK1 FOREIGN KEY (COMPOSITE_SEQUENCE_ID) 
    REFERENCES COMPOSITESEQUENCE (ID));

ALTER TABLE BIOLOGICALCHARACTERISTICS ADD (
  CONSTRAINT BIOLOGICALCHARACTERISTICS_FK2 FOREIGN KEY (BIOSEQUENCE_ID) 
    REFERENCES BIOSEQUENCE (ID));


ALTER TABLE BIOMATERIAL ADD (
  CONSTRAINT BIOMATERIAL_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIOMATERIAL ADD (
  CONSTRAINT BIOMATERIAL_FK_2 FOREIGN KEY (MATERIAL_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE BIOMATERIAL ADD (
  CONSTRAINT BIOMATERIAL_FK_3 FOREIGN KEY (TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE BIOMATERIALCHARACTERISTICS ADD (
  CONSTRAINT BIOMATERIALCHARACTERISTICS_FK1 FOREIGN KEY (BIOMATERIAL_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE BIOMATERIALCHARACTERISTICS ADD (
  CONSTRAINT BIOMATERIALCHARACTERISTICS_FK2 FOREIGN KEY (ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE BIOMATERIALMEASUREMENT ADD (
  CONSTRAINT BIOMATERIALMEASUREMENT_FK_1 FOREIGN KEY (BIOMATERIAL_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE BIOMATERIALMEASUREMENT ADD (
  CONSTRAINT BIOMATERIALMEASUREMENT_FK_2 FOREIGN KEY (MEASUREMENT_ID) 
    REFERENCES MEASUREMENT (ID));

ALTER TABLE BIOMATERIALMEASUREMENT ADD (
  CONSTRAINT BIOMATERIALMEASUREMENT_FK_3 FOREIGN KEY (TREATMENT_ID) 
    REFERENCES TREATMENT (ID));

ALTER TABLE BIOMATERIALMEASUREMENT ADD (
  CONSTRAINT BIOMATERIALMEASUREMENT_FK_4 FOREIGN KEY (BIOASSAY_CREATION_ID) 
    REFERENCES BIOASSAYCREATION (ID));


ALTER TABLE BIOSEQUENCE ADD (
  CONSTRAINT BIOSEQUENCE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE BIOSEQUENCE ADD (
  CONSTRAINT BIOSEQUENCE_FK_2 FOREIGN KEY (POLYMER_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE BIOSEQUENCE ADD (
  CONSTRAINT BIOSEQUENCE_FK_3 FOREIGN KEY (TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE BIOSEQUENCE ADD (
  CONSTRAINT BIOSEQUENCE_FK_4 FOREIGN KEY (SPECIES_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE BIOSEQUENCEONTOLOGYENTRY ADD (
  CONSTRAINT BIOSEQUENCEONTOLOGYENTRY_FK_1 FOREIGN KEY (BIOSEQUENCE_ID) 
    REFERENCES BIOSEQUENCE (ID));

ALTER TABLE BIOSEQUENCEONTOLOGYENTRY ADD (
  CONSTRAINT BIOSEQUENCEONTOLOGYENTRY_FK_2 FOREIGN KEY (ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE BIOSOURCECONTACT ADD (
  CONSTRAINT BIOSOURCECONTACT_FK1 FOREIGN KEY (BIOSOURCE_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE BIOSOURCECONTACT ADD (
  CONSTRAINT BIOSOURCECONTACT_FK2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));


ALTER TABLE CA_ADDITIONALFILE ADD (
  CONSTRAINT CA_ADDITIONALFILE_FK1 FOREIGN KEY (EXPERIMENT_ID) 
    REFERENCES EXPERIMENT (ID));


ALTER TABLE CA_ADDITIONALPROCESSFILE ADD (
  CONSTRAINT CA_ADDITIONALPROCESSFILEFK1 FOREIGN KEY (EXPERIMENT_ID) 
    REFERENCES EXPERIMENT (ID));

ALTER TABLE CA_ADDITIONALPROCESSFILE ADD (
  CONSTRAINT CA_ADDITIONALPROCESSFILEFK2 FOREIGN KEY (PROTOCOL_APPLICATION_ID) 
    REFERENCES PROTOCOLAPPLICATION (ID));


ALTER TABLE CA_CHANNELONEFACTORVALUES ADD (
  CONSTRAINT CA_CHANNELONEFACTORVALUES_FK2 FOREIGN KEY (FACTOR_VALUE_ID) 
    REFERENCES FACTORVALUE (ID));


ALTER TABLE CA_CHANNELTWOFACTORVALUES ADD (
  CONSTRAINT CA_CHANNELTWOFACTORVALUES_FK2 FOREIGN KEY (FACTOR_VALUE_ID) 
    REFERENCES FACTORVALUE (ID));


ALTER TABLE CA_HYBRIDIZATIONFILEUPLOAD ADD (
  CONSTRAINT CA_HYBRIDIZATIONFILEUPLOAD_FK1 FOREIGN KEY (MEASURED_BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE CA_HYBRIDIZATIONFILEUPLOAD ADD (
  CONSTRAINT CA_HYBRIDIZATIONFILEUPLOAD_FK2 FOREIGN KEY (DERIVED_BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE CA_HYBRIDIZATIONFILEUPLOAD ADD (
  CONSTRAINT CA_HYBRIDIZATIONFILEUPLOAD_FK3 FOREIGN KEY (EXPERIMENT_ID) 
    REFERENCES EXPERIMENT (ID));

ALTER TABLE CA_HYBRIDIZATIONFILEUPLOAD ADD (
  CONSTRAINT CA_HYBRIDIZATIONFILEUPLOAD_FK4 FOREIGN KEY (EXTRACT_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE CA_HYBRIDIZATIONFILEUPLOAD ADD (
  CONSTRAINT CA_HYBRIDIZATIONFILEUPLOAD_FK5 FOREIGN KEY (SPIKED_CONTROL_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE CA_HYBRIDIZATIONFILEUPLOAD ADD (
  CONSTRAINT CA_HYBRIDIZATIONFILEUPLOAD_FK6 FOREIGN KEY (CHANNEL_TWO_EXTRACT_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE CA_HYBRIDIZATIONFILEUPLOAD ADD (
  CONSTRAINT CA_HYBRIDIZATIONFILEUPLOAD_FK7 FOREIGN KEY (CHANNEL_TWO_SPIKED_CONTROL_ID) 
    REFERENCES BIOMATERIAL (ID));


ALTER TABLE CHANNEL ADD (
  CONSTRAINT CHANNEL_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE CHANNEL ADD (
  CONSTRAINT CHANNEL_FK_2 FOREIGN KEY (IMAGE_ID) 
    REFERENCES IMAGE (ID));


ALTER TABLE CHANNELCOMPOUND ADD (
  CONSTRAINT CHANNELCOMPOUND_FK1 FOREIGN KEY (CHANNEL_ID) 
    REFERENCES CHANNEL (ID));

ALTER TABLE CHANNELCOMPOUND ADD (
  CONSTRAINT CHANNELCOMPOUND_FK2 FOREIGN KEY (COMPOUND_ID) 
    REFERENCES COMPOUND (ID));


ALTER TABLE CHROMOSOMALABERRATIONTYPE ADD (
  CONSTRAINT CHROMOSOMALABERRATIONTYPE_FK1 FOREIGN KEY (CHROMOSOMAL_ABERRATION_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE CHROMOSOMALABERRATIONTYPE ADD (
  CONSTRAINT CHROMOSOMALABERRATIONTYPE_FK2 FOREIGN KEY (ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE COMPOSITESEQUENCE ADD (
  CONSTRAINT COMPOSITESEQUENCE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE COMPOSITESEQUENCE ADD (
  CONSTRAINT COMPOSITESEQUENCE_FK_2 FOREIGN KEY (CONTROL_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE COMPOSITESEQUENCE ADD (
  CONSTRAINT COMPOSITESEQUENCE_FK_3 FOREIGN KEY (COMPOSITE_GROUP_ID) 
    REFERENCES DESIGNELEMENTGROUP (ID));


ALTER TABLE COMPOUND ADD (
  CONSTRAINT COMPOUND_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE COMPOUND ADD (
  CONSTRAINT COMPOUND_FK_2 FOREIGN KEY (EXTERNAL_LIMS_ID) 
    REFERENCES DATABASEENTRY (ID));


ALTER TABLE COMPOUNDMEASUREMENT ADD (
  CONSTRAINT COMPOUNDMEASUREMENT_FK_1 FOREIGN KEY (COMPOUND_ID) 
    REFERENCES COMPOUND (ID));

ALTER TABLE COMPOUNDMEASUREMENT ADD (
  CONSTRAINT COMPOUNDMEASUREMENT_FK_2 FOREIGN KEY (MEASUREMENT_ID) 
    REFERENCES MEASUREMENT (ID));

ALTER TABLE COMPOUNDMEASUREMENT ADD (
  CONSTRAINT COMPOUNDMEASUREMENT_FK_3 FOREIGN KEY (TREATMENT_ID) 
    REFERENCES TREATMENT (ID));

ALTER TABLE COMPOUNDMEASUREMENT ADD (
  CONSTRAINT COMPOUNDMEASUREMENT_FK_4 FOREIGN KEY (PARENT_COMPOUND_ID) 
    REFERENCES COMPOUND (ID));


ALTER TABLE COMPSEQDIMENSIONCOMPSEQ ADD (
  CONSTRAINT COMPSEQDIMENSIONCOMPSEQ_FK1 FOREIGN KEY (COMP_SEQ_DIMENSION_ID) 
    REFERENCES DESIGNELEMENTDIMENSION (ID));

ALTER TABLE COMPSEQDIMENSIONCOMPSEQ ADD (
  CONSTRAINT COMPSEQDIMENSIONCOMPSEQ_FK2 FOREIGN KEY (COMP_SEQ_ID) 
    REFERENCES COMPOSITESEQUENCE (ID));


ALTER TABLE DATABASE ADD (
  CONSTRAINT DATABASE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE DATABASECONTACT ADD (
  CONSTRAINT DATABASECONTACT_FK_1 FOREIGN KEY (DATABASE_ID) 
    REFERENCES DATABASE (ID));

ALTER TABLE DATABASECONTACT ADD (
  CONSTRAINT DATABASECONTACT_FK_2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));


ALTER TABLE DATABASEENTRY ADD (
  CONSTRAINT DATABASEENTRY_FK_1 FOREIGN KEY (TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE DATABASEENTRY ADD (
  CONSTRAINT DATABASEENTRY_FK_2 FOREIGN KEY (BIOSEQUENCE_ID) 
    REFERENCES BIOSEQUENCE (ID));

ALTER TABLE DATABASEENTRY ADD (
  CONSTRAINT DATABASEENTRY_FK_3 FOREIGN KEY (DATABASE_ID) 
    REFERENCES DATABASE (ID));

ALTER TABLE DATABASEENTRY ADD (
  CONSTRAINT DATABASEENTRY_FK_4 FOREIGN KEY (DESCRIPTION_ID) 
    REFERENCES DESCRIPTION (ID));

ALTER TABLE DATABASEENTRY ADD (
  CONSTRAINT DATABASEENTRY_FK_5 FOREIGN KEY (BIBLIOGRAPHIC_REFERENCE_ID) 
    REFERENCES BIBLIOGRAPHICREFERENCE (ID));


ALTER TABLE DERIVEDBIOASSAYDATA ADD (
  CONSTRAINT DERIVEDBIOASSAYDATA_FK_1 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE DERIVEDBIOASSAYDATA ADD (
  CONSTRAINT DERIVEDBIOASSAYDATA_FK_2 FOREIGN KEY (BIOASSAY_DATA_ID) 
    REFERENCES BIOASSAYDATA (ID));


ALTER TABLE DESCRIPTION ADD (
  CONSTRAINT DESCRIPTION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE DESCRIPTION ADD (
  CONSTRAINT DESCRIPTION_FK_2 FOREIGN KEY (EXTERNAL_REFERENCE_ID) 
    REFERENCES EXTERNALREFERENCE (ID));


ALTER TABLE DESCRIPTIONONTOLOGYENTRY ADD (
  CONSTRAINT DESCRIPTIONONTOLOGYENTRY_FK1 FOREIGN KEY (DESCRIPTION_ID) 
    REFERENCES DESCRIPTION (ID));

ALTER TABLE DESCRIPTIONONTOLOGYENTRY ADD (
  CONSTRAINT DESCRIPTIONONTOLOGYENTRY_FK2 FOREIGN KEY (ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE DESIGNELEMENTDIMENSION ADD (
  CONSTRAINT DESIGNELEMENTDIMENSION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE DESIGNELEMENTGROUP ADD (
  CONSTRAINT DESIGNELEMENTGROUP_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE DESIGNELEMENTGROUP ADD (
  CONSTRAINT DESIGNELEMENTGROUP_FK_2 FOREIGN KEY (SPECIES_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE DESIGNELEMENTGROUP ADD (
  CONSTRAINT DESIGNELEMENTGROUP_FK_3 FOREIGN KEY (TECHNOLOGY_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE DESIGNELEMENTGROUP ADD (
  CONSTRAINT DESIGNELEMENTGROUP_FK_4 FOREIGN KEY (FEATURE_SHAPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE DESIGNELEMENTGROUP ADD (
  CONSTRAINT DESIGNELEMENTGROUP_FK_5 FOREIGN KEY (DISTANCE_UNIT_ID) 
    REFERENCES UNIT (ID));


ALTER TABLE DESIGNELEMENTGROUPTYPES ADD (
  CONSTRAINT DESIGNELEMENTGROUPTYPES_FK_1 FOREIGN KEY (DESIGN_ELEMENT_GROUP_ID) 
    REFERENCES DESIGNELEMENTGROUP (ID));

ALTER TABLE DESIGNELEMENTGROUPTYPES ADD (
  CONSTRAINT DESIGNELEMENTGROUPTYPES_FK_2 FOREIGN KEY (ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE DESIGNELEMENTMAP ADD (
  CONSTRAINT DESIGNELEMENTMAP_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE DESIGNELEMENTMAP ADD (
  CONSTRAINT DESIGNELEMENTMAP_FK_2 FOREIGN KEY (REPORTER_ID) 
    REFERENCES REPORTER (ID));

ALTER TABLE DESIGNELEMENTMAP ADD (
  CONSTRAINT DESIGNELEMENTMAP_FK_3 FOREIGN KEY (COMPOSITE_SEQUENCE_ID) 
    REFERENCES COMPOSITESEQUENCE (ID));


ALTER TABLE DESIGNELEMENTMAPS ADD (
  CONSTRAINT DESIGNELEMENTMAPS_FK1 FOREIGN KEY (DESIGN_ELEMENT_MAPPING_ID) 
    REFERENCES DESIGNELEMENTMAPPING (ID));

ALTER TABLE DESIGNELEMENTMAPS ADD (
  CONSTRAINT DESIGNELEMENTMAPS_FK2 FOREIGN KEY (DESIGN_ELEMENT_MAP_ID) 
    REFERENCES DESIGNELEMENTMAP (ID));


ALTER TABLE EXPERIMENT ADD (
  CONSTRAINT EXPERIMENT_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE EXPERIMENTALFACTOR ADD (
  CONSTRAINT EXPERIMENTALFACTOR_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE EXPERIMENTALFACTOR ADD (
  CONSTRAINT EXPERIMENTALFACTOR_FK_2 FOREIGN KEY (CATEGORY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE EXPERIMENTALFACTOR ADD (
  CONSTRAINT EXPERIMENTALFACTOR_FK_3 FOREIGN KEY (EXPERIMENT_DESIGN_ID) 
    REFERENCES EXPERIMENTDESIGN (ID));


ALTER TABLE EXPERIMENTBIOASSAY ADD (
  CONSTRAINT EXPERIMENTBIOASSAY_FK_1 FOREIGN KEY (EXPERIMENT_ID) 
    REFERENCES EXPERIMENT (ID));

ALTER TABLE EXPERIMENTBIOASSAY ADD (
  CONSTRAINT EXPERIMENTBIOASSAY_FK_2 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE EXPERIMENTBIOASSAYDATA ADD (
  CONSTRAINT EXPERIMENTBIOASSAYDATA_FK_1 FOREIGN KEY (EXPERIMENT_ID) 
    REFERENCES EXPERIMENT (ID));

ALTER TABLE EXPERIMENTBIOASSAYDATA ADD (
  CONSTRAINT EXPERIMENTBIOASSAYDATA_FK_2 FOREIGN KEY (BIOASSAY_DATA_ID) 
    REFERENCES BIOASSAYDATA (ID));


ALTER TABLE EXPERIMENTDESIGN ADD (
  CONSTRAINT EXPERIMENTDESIGN_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE EXPERIMENTDESIGN ADD (
  CONSTRAINT EXPERIMENTDESIGN_FK_2 FOREIGN KEY (QUALITY_CONTROL_DESCRIPTION_ID) 
    REFERENCES DESCRIPTION (ID));

ALTER TABLE EXPERIMENTDESIGN ADD (
  CONSTRAINT EXPERIMENTDESIGN_FK_3 FOREIGN KEY (NORMALIZATION_DESCRIPTION_ID) 
    REFERENCES DESCRIPTION (ID));

ALTER TABLE EXPERIMENTDESIGN ADD (
  CONSTRAINT EXPERIMENTDESIGN_FK_4 FOREIGN KEY (REPLICATE_DESCRIPTION_ID) 
    REFERENCES DESCRIPTION (ID));

ALTER TABLE EXPERIMENTDESIGN ADD (
  CONSTRAINT EXPERIMENTDESIGN_FK_5 FOREIGN KEY (EXPERIMENT_ID) 
    REFERENCES EXPERIMENT (ID));


ALTER TABLE EXPERIMENTDESIGNTYPE ADD (
  CONSTRAINT EXPERIMENTDESIGNTYPE_FK1 FOREIGN KEY (EXPERIMENT_DESIGN_ID) 
    REFERENCES EXPERIMENTDESIGN (ID));

ALTER TABLE EXPERIMENTDESIGNTYPE ADD (
  CONSTRAINT EXPERIMENTDESIGNTYPE_FK2 FOREIGN KEY (ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE EXPERIMENTPROVIDER ADD (
  CONSTRAINT EXPERIMENTPROVIDER_FK1 FOREIGN KEY (EXPERIMENT_ID) 
    REFERENCES EXPERIMENT (ID));

ALTER TABLE EXPERIMENTPROVIDER ADD (
  CONSTRAINT EXPERIMENTPROVIDER_FK2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));

ALTER TABLE EXPERIMENTPROVIDER ADD (
  CONSTRAINT EXPERIMENTPROVIDER_FK3 FOREIGN KEY (ROLE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE FACTORVALUE ADD (
  CONSTRAINT FACTORVALUE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE FACTORVALUE ADD (
  CONSTRAINT FACTORVALUE_FK_2 FOREIGN KEY (EXPERIMENTAL_FACTOR_ID) 
    REFERENCES EXPERIMENTALFACTOR (ID));

ALTER TABLE FACTORVALUE ADD (
  CONSTRAINT FACTORVALUE_FK_3 FOREIGN KEY (MEASUREMENT_ID) 
    REFERENCES MEASUREMENT (ID));

ALTER TABLE FACTORVALUE ADD (
  CONSTRAINT FACTORVALUE_FK_4 FOREIGN KEY (VALUE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE FEATURE ADD (
  CONSTRAINT FEATURE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE FEATURE ADD (
  CONSTRAINT FEATURE_FK_2 FOREIGN KEY (CONTROL_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE FEATURE ADD (
  CONSTRAINT FEATURE_FK_3 FOREIGN KEY (POSITION_ID) 
    REFERENCES POSITION (ID));

ALTER TABLE FEATURE ADD (
  CONSTRAINT FEATURE_FK_4 FOREIGN KEY (ZONE_ID) 
    REFERENCES ZONE (ID));

ALTER TABLE FEATURE ADD (
  CONSTRAINT FEATURE_FK_5 FOREIGN KEY (FEATURE_LOCATION_ID) 
    REFERENCES FEATURELOCATION (ID));

ALTER TABLE FEATURE ADD (
  CONSTRAINT FEATURE_FK_6 FOREIGN KEY (FEATURE_GROUP_ID) 
    REFERENCES DESIGNELEMENTGROUP (ID));


ALTER TABLE FEATURECONTROLFEATURE ADD (
  CONSTRAINT FEATURECONTROLFEATURE_FK1 FOREIGN KEY (FEATURE_ID) 
    REFERENCES FEATURE (ID));

ALTER TABLE FEATURECONTROLFEATURE ADD (
  CONSTRAINT FEATURECONTROLFEATURE_FK2 FOREIGN KEY (CONTROL_FEATURE_ID) 
    REFERENCES FEATURE (ID));


ALTER TABLE FEATURECONTROLLEDFEATURE ADD (
  CONSTRAINT FEATURECONTROLLEDFEATURE_FK1 FOREIGN KEY (FEATURE_ID) 
    REFERENCES FEATURE (ID));

ALTER TABLE FEATURECONTROLLEDFEATURE ADD (
  CONSTRAINT FEATURECONTROLLEDFEATURE_FK2 FOREIGN KEY (CONTROLLED_FEATURE_ID) 
    REFERENCES FEATURE (ID));


ALTER TABLE FEATUREDEFECT ADD (
  CONSTRAINT FEATUREDEFECT_FK_1 FOREIGN KEY (DEFECT_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE FEATUREDEFECT ADD (
  CONSTRAINT FEATUREDEFECT_FK_2 FOREIGN KEY (POSITION_DELTA_ID) 
    REFERENCES POSITIONDELTA (ID));

ALTER TABLE FEATUREDEFECT ADD (
  CONSTRAINT FEATUREDEFECT_FK_3 FOREIGN KEY (FEATURE_ID) 
    REFERENCES FEATURE (ID));

ALTER TABLE FEATUREDEFECT ADD (
  CONSTRAINT FEATUREDEFECT_FK_4 FOREIGN KEY (ARRAY_MANUFACTURE_DEVIATION_ID) 
    REFERENCES ARRAYMANUFACTUREDEVIATION (ID));


ALTER TABLE FEATUREDIMENSIONFEATURE ADD (
  CONSTRAINT FEATUREDIMENSIONFEATURE_FK1 FOREIGN KEY (FEATURE_DIMENSION_ID) 
    REFERENCES DESIGNELEMENTDIMENSION (ID));

ALTER TABLE FEATUREDIMENSIONFEATURE ADD (
  CONSTRAINT FEATUREDIMENSIONFEATURE_FK2 FOREIGN KEY (FEATURE_ID) 
    REFERENCES FEATURE (ID));


ALTER TABLE FEATUREEXTRACTION ADD (
  CONSTRAINT FEATUREEXTRACTION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE FEATUREEXTRACTION ADD (
  CONSTRAINT FEATUREEXTRACTION_FK_2 FOREIGN KEY (PHYSICAL_BIOASSAY_SOURCE_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE FEATUREEXTRACTION ADD (
  CONSTRAINT FEATUREEXTRACTION_FK_3 FOREIGN KEY (MEASURED_BIOASSAY_TARGET_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE FEATUREINFORMATION ADD (
  CONSTRAINT FEATUREINFORMATION_FK_1 FOREIGN KEY (FEATURE_ID) 
    REFERENCES FEATURE (ID));

ALTER TABLE FEATUREINFORMATION ADD (
  CONSTRAINT FEATUREINFORMATION_FK_2 FOREIGN KEY (FEATURE_REPORTER_MAP_ID) 
    REFERENCES DESIGNELEMENTMAP (ID));


ALTER TABLE FIDUCIAL ADD (
  CONSTRAINT FIDUCIAL_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE FIDUCIAL ADD (
  CONSTRAINT FIDUCIAL_FK_2 FOREIGN KEY (FIDUCIAL_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE FIDUCIAL ADD (
  CONSTRAINT FIDUCIAL_FK_3 FOREIGN KEY (DISTANCE_UNIT_ID) 
    REFERENCES UNIT (ID));

ALTER TABLE FIDUCIAL ADD (
  CONSTRAINT FIDUCIAL_FK_4 FOREIGN KEY (POSITION_ID) 
    REFERENCES POSITION (ID));

ALTER TABLE FIDUCIAL ADD (
  CONSTRAINT FIDUCIAL_FK_5 FOREIGN KEY (ARRAY_GROUP_ID) 
    REFERENCES ARRAYGROUP (ID));


ALTER TABLE HARDWARE ADD (
  CONSTRAINT HARDWARE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE HARDWARE ADD (
  CONSTRAINT HARDWARE_FK_2 FOREIGN KEY (TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE HARDWARE ADD (
  CONSTRAINT HARDWARE_FK_3 FOREIGN KEY (ID) 
    REFERENCES PARAMETERIZABLE (ID));


ALTER TABLE HARDWARE2SOFTWARE ADD (
  CONSTRAINT HARDWARE2SOFTWARE_FK_1 FOREIGN KEY (HARDWARE_ID) 
    REFERENCES HARDWARE (ID));

ALTER TABLE HARDWARE2SOFTWARE ADD (
  CONSTRAINT HARDWARE2SOFTWARE_FK_2 FOREIGN KEY (SOFTWARE_ID) 
    REFERENCES SOFTWARE (ID));


ALTER TABLE HARDWAREAPPLICATION ADD (
  CONSTRAINT HARDWAREAPPLICATION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE HARDWAREAPPLICATION ADD (
  CONSTRAINT HARDWAREAPPLICATION_FK_2 FOREIGN KEY (HARDWARE_ID) 
    REFERENCES HARDWARE (ID));

ALTER TABLE HARDWAREAPPLICATION ADD (
  CONSTRAINT HARDWAREAPPLICATION_FK_3 FOREIGN KEY (ID) 
    REFERENCES PARAMETERIZABLEAPPLICATION (ID));

ALTER TABLE HARDWAREAPPLICATION ADD (
  CONSTRAINT HARDWAREAPPLICATION_FK_4 FOREIGN KEY (PROTOCOL_APPLICATION_ID) 
    REFERENCES PROTOCOLAPPLICATION (ID));


ALTER TABLE HARDWAREMANUFACTURERS ADD (
  CONSTRAINT HARDWAREMANUFACTURERS_FK1 FOREIGN KEY (HARDWARE_ID) 
    REFERENCES HARDWARE (ID));

ALTER TABLE HARDWAREMANUFACTURERS ADD (
  CONSTRAINT HARDWAREMANUFACTURERS_FK2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));


ALTER TABLE IMAGE ADD (
  CONSTRAINT IMAGE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE IMAGE ADD (
  CONSTRAINT IMAGE_FK_2 FOREIGN KEY (FORMAT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE IMAGE ADD (
  CONSTRAINT IMAGE_FK_3 FOREIGN KEY (PHYSICAL_BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE IMAGE ADD (
  CONSTRAINT IMAGE_FK_4 FOREIGN KEY (IMAGE_ACQUISITION_ID) 
    REFERENCES BIOASSAYTREATMENT (ID));


ALTER TABLE IMMOBILIZEDCHARACTERISTICS ADD (
  CONSTRAINT IMMOBILIZEDCHARACTERISTICS_FK1 FOREIGN KEY (REPORTER_ID) 
    REFERENCES REPORTER (ID));

ALTER TABLE IMMOBILIZEDCHARACTERISTICS ADD (
  CONSTRAINT IMMOBILIZEDCHARACTERISTICS_FK2 FOREIGN KEY (BIOSEQUENCE_ID) 
    REFERENCES BIOSEQUENCE (ID));


ALTER TABLE LABELEDEXTRACTCOMPOUND ADD (
  CONSTRAINT LABELEDEXTRACTCOMPOUND_FK1 FOREIGN KEY (LABELED_EXTRACT_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE LABELEDEXTRACTCOMPOUND ADD (
  CONSTRAINT LABELEDEXTRACTCOMPOUND_FK2 FOREIGN KEY (COMPOUND_ID) 
    REFERENCES COMPOUND (ID));


ALTER TABLE MANUFACTURELIMS ADD (
  CONSTRAINT MANUFACTURELIMS_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE MANUFACTURELIMS ADD (
  CONSTRAINT MANUFACTURELIMS_FK_2 FOREIGN KEY (FEATURE_ID) 
    REFERENCES FEATURE (ID));

ALTER TABLE MANUFACTURELIMS ADD (
  CONSTRAINT MANUFACTURELIMS_FK_3 FOREIGN KEY (BIOMATERIAL_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE MANUFACTURELIMS ADD (
  CONSTRAINT MANUFACTURELIMS_FK_4 FOREIGN KEY (IDENTIFIER_LIMS_ID) 
    REFERENCES DATABASEENTRY (ID));

ALTER TABLE MANUFACTURELIMS ADD (
  CONSTRAINT MANUFACTURELIMS_FK_5 FOREIGN KEY (ARRAY_MANUFACTURE_ID) 
    REFERENCES ARRAYMANUFACTURE (ID));


ALTER TABLE MEASUREDBIOASSAYDATA ADD (
  CONSTRAINT MEASUREDBIOASSAYDATA_FK_1 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));

ALTER TABLE MEASUREDBIOASSAYDATA ADD (
  CONSTRAINT MEASUREDBIOASSAYDATA_FK_2 FOREIGN KEY (BIOASSAY_DATA_ID) 
    REFERENCES BIOASSAYDATA (ID));


ALTER TABLE MEASUREMENT ADD (
  CONSTRAINT MEASUREMENT_FK_1 FOREIGN KEY (UNIT_ID) 
    REFERENCES UNIT (ID));


ALTER TABLE MISMATCHINFORMATION ADD (
  CONSTRAINT MISMATCHINFORMATION_FK_1 FOREIGN KEY (REPORTER_POSITION_ID) 
    REFERENCES SEQUENCEPOSITION (ID));

ALTER TABLE MISMATCHINFORMATION ADD (
  CONSTRAINT MISMATCHINFORMATION_FK_2 FOREIGN KEY (COMPOSITE_POSITION_ID) 
    REFERENCES SEQUENCEPOSITION (ID));

ALTER TABLE MISMATCHINFORMATION ADD (
  CONSTRAINT MISMATCHINFORMATION_FK_3 FOREIGN KEY (FEATURE_INFORMATION_ID) 
    REFERENCES FEATUREINFORMATION (ID));


ALTER TABLE NAMEVALUETYPE ADD (
  CONSTRAINT NAMEVALUETYPE_FK_2 FOREIGN KEY (NAME_VALUE_TYPE_ID) 
    REFERENCES NAMEVALUETYPE (ID));

ALTER TABLE NAMEVALUETYPE ADD (
  CONSTRAINT NAMEVALUETYPE_FK_3 FOREIGN KEY (ARRAY_MANUFACTURE_ID) 
    REFERENCES ARRAYMANUFACTURE (ID));

ALTER TABLE NAMEVALUETYPE ADD (
  CONSTRAINT NAMEVALUETYPE_FK_4 FOREIGN KEY (BIOMATERIAL_ID) 
    REFERENCES BIOMATERIAL (ID));

ALTER TABLE NAMEVALUETYPE ADD (
  CONSTRAINT NAMEVALUETYPE_FK_5 FOREIGN KEY (BIOASSAY_DATA_ID) 
    REFERENCES BIOASSAYDATA (ID));


ALTER TABLE NODE ADD (
  CONSTRAINT NODE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE NODE ADD (
  CONSTRAINT NODE_FK_2 FOREIGN KEY (BIOASSAY_DATA_CLUSTER_ID) 
    REFERENCES BIOASSAYDATACLUSTER (ID));

ALTER TABLE NODE ADD (
  CONSTRAINT NODE_FK_3 FOREIGN KEY (NODE_ID) 
    REFERENCES NODE (ID));


ALTER TABLE NODECONTENTS ADD (
  CONSTRAINT NODECONTENTS_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE NODECONTENTS ADD (
  CONSTRAINT NODECONTENTS_FK_2 FOREIGN KEY (BIOASSAY_DIMENSION_ID) 
    REFERENCES BIOASSAYDIMENSION (ID));

ALTER TABLE NODECONTENTS ADD (
  CONSTRAINT NODECONTENTS_FK_3 FOREIGN KEY (DESIGN_ELEMENT_DIMENSION_ID) 
    REFERENCES DESIGNELEMENTDIMENSION (ID));

ALTER TABLE NODECONTENTS ADD (
  CONSTRAINT NODECONTENTS_FK_4 FOREIGN KEY (QUANTITATION_DIMENSION_ID) 
    REFERENCES QUANTITATIONTYPEDIMENSION (ID));

ALTER TABLE NODECONTENTS ADD (
  CONSTRAINT NODECONTENTS_FK_5 FOREIGN KEY (NODE_ID) 
    REFERENCES NODE (ID));


ALTER TABLE NODEVALUE ADD (
  CONSTRAINT NODEVALUE_FK_1 FOREIGN KEY (TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE NODEVALUE ADD (
  CONSTRAINT NODEVALUE_FK_2 FOREIGN KEY (SCALE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE NODEVALUE ADD (
  CONSTRAINT NODEVALUE_FK_3 FOREIGN KEY (DATA_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE NODEVALUE ADD (
  CONSTRAINT NODEVALUE_FK_4 FOREIGN KEY (NODE_ID) 
    REFERENCES NODE (ID));


ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_1 FOREIGN KEY (ONTOLOGY_REFERENCE_ID) 
    REFERENCES DATABASEENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_11 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_15 FOREIGN KEY (AGE_VALUE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_16 FOREIGN KEY (MEASUREMENT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_17 FOREIGN KEY (MIN_VALUE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_18 FOREIGN KEY (MIN_MEASUREMENT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_19 FOREIGN KEY (MAX_VALUE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_2 FOREIGN KEY (BIBLIOGRAPHIC_REFERENCE_ID) 
    REFERENCES BIBLIOGRAPHICREFERENCE (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_20 FOREIGN KEY (MAX_MEASUREMENT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_21 FOREIGN KEY (INITIAL_TIME_POINT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_22 FOREIGN KEY (WEIGHT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_23 FOREIGN KEY (WEIGHT_MEASUREMENT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_24 FOREIGN KEY (HEIGHT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_25 FOREIGN KEY (HEIGHT_MEASUREMENT_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_4 FOREIGN KEY (COMPOUND_ID) 
    REFERENCES COMPOUND (ID));

ALTER TABLE ONTOLOGYENTRY ADD (
  CONSTRAINT ONTOLOGYENTRY_FK_9 FOREIGN KEY (EXPERIMENTAL_FACTOR_ID) 
    REFERENCES EXPERIMENTALFACTOR (ID));


ALTER TABLE ONTOLOGYENTRYCHILDREN ADD (
  CONSTRAINT ONTOLOGYENTRYCHILDREN_FK_1 FOREIGN KEY (ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ONTOLOGYENTRYCHILDREN ADD (
  CONSTRAINT ONTOLOGYENTRYCHILDREN_FK_2 FOREIGN KEY (CHILD_ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE ORGANIZATION ADD (
  CONSTRAINT ORGANIZATION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE ORGANIZATION ADD (
  CONSTRAINT ORGANIZATION_FK_2 FOREIGN KEY (PARENT_ID) 
    REFERENCES ORGANIZATION (ID));

ALTER TABLE ORGANIZATION ADD (
  CONSTRAINT ORGANIZATION_FK_3 FOREIGN KEY (ID) 
    REFERENCES CONTACT (ID));

ALTER TABLE ORGANIZATION ADD (
  CONSTRAINT ORGANIZATION_FK_4 FOREIGN KEY (ARRAY_MANUFACTURE_ID) 
    REFERENCES ARRAYMANUFACTURE (ID));


ALTER TABLE PARAMETER ADD (
  CONSTRAINT PARAMETER_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE PARAMETER ADD (
  CONSTRAINT PARAMETER_FK_2 FOREIGN KEY (DEFAULT_VALUE_ID) 
    REFERENCES MEASUREMENT (ID));

ALTER TABLE PARAMETER ADD (
  CONSTRAINT PARAMETER_FK_3 FOREIGN KEY (DATA_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE PARAMETER ADD (
  CONSTRAINT PARAMETER_FK_4 FOREIGN KEY (PARAMETERIZABLE_ID) 
    REFERENCES PARAMETERIZABLE (ID));


ALTER TABLE PARAMETERVALUE ADD (
  CONSTRAINT PARAMETERVALUE_FK_1 FOREIGN KEY (PARAMETER_TYPE_ID) 
    REFERENCES PARAMETER (ID));

ALTER TABLE PARAMETERVALUE ADD (
  CONSTRAINT PARAMETERVALUE_FK_2 FOREIGN KEY (PARAMETERIZABLE_APPLICATION_ID) 
    REFERENCES PARAMETERIZABLEAPPLICATION (ID));


ALTER TABLE PERSON ADD (
  CONSTRAINT PERSON_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE PERSON ADD (
  CONSTRAINT PERSON_FK_2 FOREIGN KEY (AFFILIATION_ID) 
    REFERENCES ORGANIZATION (ID));

ALTER TABLE PERSON ADD (
  CONSTRAINT PERSON_FK_3 FOREIGN KEY (ID) 
    REFERENCES CONTACT (ID));

ALTER TABLE PERSON ADD (
  CONSTRAINT PERSON_FK_4 FOREIGN KEY (ARRAY_MANUFACTURE_ID) 
    REFERENCES ARRAYMANUFACTURE (ID));


ALTER TABLE POSITION ADD (
  CONSTRAINT POSITION_FK_1 FOREIGN KEY (DISTANCE_UNIT_ID) 
    REFERENCES UNIT (ID));


ALTER TABLE POSITIONDELTA ADD (
  CONSTRAINT POSITIONDELTA_FK_1 FOREIGN KEY (DISTANCE_UNIT_ID) 
    REFERENCES UNIT (ID));


ALTER TABLE PROTOCOL ADD (
  CONSTRAINT PROTOCOL_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE PROTOCOL ADD (
  CONSTRAINT PROTOCOL_FK_2 FOREIGN KEY (TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE PROTOCOL ADD (
  CONSTRAINT PROTOCOL_FK_3 FOREIGN KEY (ID) 
    REFERENCES PARAMETERIZABLE (ID));


ALTER TABLE PROTOCOLAPPLICATION ADD (
  CONSTRAINT PROTOCOLAPPLICATION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE PROTOCOLAPPLICATION ADD (
  CONSTRAINT PROTOCOLAPPLICATION_FK_2 FOREIGN KEY (PROTOCOL_ID) 
    REFERENCES PROTOCOL (ID));

ALTER TABLE PROTOCOLAPPLICATION ADD (
  CONSTRAINT PROTOCOLAPPLICATION_FK_3 FOREIGN KEY (ID) 
    REFERENCES PARAMETERIZABLEAPPLICATION (ID));

ALTER TABLE PROTOCOLAPPLICATION ADD (
  CONSTRAINT PROTOCOLAPPLICATION_FK_4 FOREIGN KEY (ARRAY_MANUFACTURE_ID) 
    REFERENCES ARRAYMANUFACTURE (ID));

ALTER TABLE PROTOCOLAPPLICATION ADD (
  CONSTRAINT PROTOCOLAPPLICATION_FK_5 FOREIGN KEY (ARRAY_DESIGN_ID) 
    REFERENCES ARRAYDESIGN (ID));


ALTER TABLE PROTOCOLHARDWARE ADD (
  CONSTRAINT PROTOCOLHARDWARE_FK1 FOREIGN KEY (PROTOCOL_ID) 
    REFERENCES PROTOCOL (ID));

ALTER TABLE PROTOCOLHARDWARE ADD (
  CONSTRAINT PROTOCOLHARDWARE_FK2 FOREIGN KEY (HARDWARE_ID) 
    REFERENCES HARDWARE (ID));


ALTER TABLE PROTOCOLSOFTWARE ADD (
  CONSTRAINT PROTOCOLSOFTWARE_FK1 FOREIGN KEY (PROTOCOL_ID) 
    REFERENCES PROTOCOL (ID));

ALTER TABLE PROTOCOLSOFTWARE ADD (
  CONSTRAINT PROTOCOLSOFTWARE_FK2 FOREIGN KEY (SOFTWARE_ID) 
    REFERENCES SOFTWARE (ID));


ALTER TABLE QUANTITATIONTYPE ADD (
  CONSTRAINT QUANTITATIONTYPE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE QUANTITATIONTYPE ADD (
  CONSTRAINT QUANTITATIONTYPE_FK_2 FOREIGN KEY (CHANNEL_ID) 
    REFERENCES CHANNEL (ID));

ALTER TABLE QUANTITATIONTYPE ADD (
  CONSTRAINT QUANTITATIONTYPE_FK_3 FOREIGN KEY (SCALE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE QUANTITATIONTYPE ADD (
  CONSTRAINT QUANTITATIONTYPE_FK_4 FOREIGN KEY (DATA_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE QUANTITATIONTYPE ADD (
  CONSTRAINT QUANTITATIONTYPE_FK_5 FOREIGN KEY (QUANTITATION_TYPE_ID) 
    REFERENCES QUANTITATIONTYPE (ID));


ALTER TABLE QUANTITATIONTYPEDIMENSION ADD (
  CONSTRAINT QUANTITATIONTYPEDIMENSION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE QUANTITATIONTYPEMAP ADD (
  CONSTRAINT QUANTITATIONTYPEMAP_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE QUANTITATIONTYPEMAP ADD (
  CONSTRAINT QUANTITATIONTYPEMAP_FK_2 FOREIGN KEY (QUANTITATION_TYPE_ID) 
    REFERENCES QUANTITATIONTYPE (ID));


ALTER TABLE QUANTITATIONTYPEMAPS ADD (
  CONSTRAINT QUANTITATIONTYPEMAPS_FK1 FOREIGN KEY (QUANTITATION_TYPE_MAPPING_ID) 
    REFERENCES QUANTITATIONTYPEMAPPING (ID));

ALTER TABLE QUANTITATIONTYPEMAPS ADD (
  CONSTRAINT QUANTITATIONTYPEMAPS_FK2 FOREIGN KEY (QUANTITATION_TYPE_MAP_ID) 
    REFERENCES QUANTITATIONTYPEMAP (ID));


ALTER TABLE QUANTITATIONTYPEMAPSOURCES ADD (
  CONSTRAINT QUANTITATIONTYPEMAPSOURCES_FK1 FOREIGN KEY (QUANTITATION_TYPE_ID) 
    REFERENCES QUANTITATIONTYPE (ID));

ALTER TABLE QUANTITATIONTYPEMAPSOURCES ADD (
  CONSTRAINT QUANTITATIONTYPEMAPSOURCES_FK2 FOREIGN KEY (QUANTITATION_TYPE_MAP_ID) 
    REFERENCES QUANTITATIONTYPEMAP (ID));


ALTER TABLE QUANTITATIONTYPETUPLE ADD (
  CONSTRAINT QUANTITATIONTYPETUPLE_FK_1 FOREIGN KEY (QUANTITATION_TYPE_ID) 
    REFERENCES QUANTITATIONTYPE (ID));

ALTER TABLE QUANTITATIONTYPETUPLE ADD (
  CONSTRAINT QUANTITATIONTYPETUPLE_FK_2 FOREIGN KEY (DESIGN_ELEMENT_TUPLE_ID) 
    REFERENCES QUANTITATIONTYPE (ID));

ALTER TABLE QUANTITATIONTYPETUPLE ADD (
  CONSTRAINT QUANTITATIONTYPETUPLE_FK_4 FOREIGN KEY (DATUM_ID) 
    REFERENCES DATUM (ID));


ALTER TABLE QUANTTYPEDIMENSIONQUANTTYPE ADD (
  CONSTRAINT QUANTTYPEDIMENSIONQUANTTYPEFK1 FOREIGN KEY (QUANTITATION_TYPE_DIMENSION_ID) 
    REFERENCES QUANTITATIONTYPEDIMENSION (ID));

ALTER TABLE QUANTTYPEDIMENSIONQUANTTYPE ADD (
  CONSTRAINT QUANTTYPEDIMENSIONQUANTTYPEFK2 FOREIGN KEY (QUANTITATION_TYPE_ID) 
    REFERENCES QUANTITATIONTYPE (ID));


ALTER TABLE REPORTER ADD (
  CONSTRAINT REPORTER_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE REPORTER ADD (
  CONSTRAINT REPORTER_FK_2 FOREIGN KEY (CONTROL_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE REPORTER ADD (
  CONSTRAINT REPORTER_FK_3 FOREIGN KEY (WARNING_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE REPORTER ADD (
  CONSTRAINT REPORTER_FK_4 FOREIGN KEY (REPORTER_GROUP_ID) 
    REFERENCES DESIGNELEMENTGROUP (ID));


ALTER TABLE REPORTERDIMENSIONREPORTER ADD (
  CONSTRAINT REPORTERDIMENSIONREPORTER_FK1 FOREIGN KEY (REPORTER_DIMENSION_ID) 
    REFERENCES DESIGNELEMENTDIMENSION (ID));

ALTER TABLE REPORTERDIMENSIONREPORTER ADD (
  CONSTRAINT REPORTERDIMENSIONREPORTER_FK2 FOREIGN KEY (REPORTER_ID) 
    REFERENCES REPORTER (ID));


ALTER TABLE REPORTERONTOLOGYENTRY ADD (
  CONSTRAINT REPORTERONTOLOGYENTRY_FK_1 FOREIGN KEY (REPORTER_ID) 
    REFERENCES REPORTER (ID));

ALTER TABLE REPORTERONTOLOGYENTRY ADD (
  CONSTRAINT REPORTERONTOLOGYENTRY_FK_2 FOREIGN KEY (ONTOLOGY_ENTRY_ID) 
    REFERENCES ONTOLOGYENTRY (ID));


ALTER TABLE SECURITY ADD (
  CONSTRAINT SECURITY_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE SECURITYCONTACT ADD (
  CONSTRAINT SECURITYCONTACT_FK_1 FOREIGN KEY (SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE SECURITYCONTACT ADD (
  CONSTRAINT SECURITYCONTACT_FK_2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));


ALTER TABLE SECURITYGROUP ADD (
  CONSTRAINT SECURITYGROUP_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE SECURITYGROUPCONTACT ADD (
  CONSTRAINT SECURITYGROUPCONTACT_FK_1 FOREIGN KEY (SECURITY_GROUP_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE SECURITYGROUPCONTACT ADD (
  CONSTRAINT SECURITYGROUPCONTACT_FK_2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));


ALTER TABLE SECURITYSECURITYGROUP ADD (
  CONSTRAINT SECURITYSECURITYGROUP_FK_1 FOREIGN KEY (SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE SECURITYSECURITYGROUP ADD (
  CONSTRAINT SECURITYSECURITYGROUP_FK_2 FOREIGN KEY (SECURITY_GROUP_ID) 
    REFERENCES SECURITYGROUP (ID));


ALTER TABLE SEQFEATURE ADD (
  CONSTRAINT SEQFEATURE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE SEQFEATURE ADD (
  CONSTRAINT SEQFEATURE_FK_2 FOREIGN KEY (BIOSEQUENCE_ID) 
    REFERENCES BIOSEQUENCE (ID));


ALTER TABLE SEQFEATURELOCATION ADD (
  CONSTRAINT SEQFEATURELOCATION_FK_1 FOREIGN KEY (COORDINATE_ID) 
    REFERENCES SEQUENCEPOSITION (ID));

ALTER TABLE SEQFEATURELOCATION ADD (
  CONSTRAINT SEQFEATURELOCATION_FK_2 FOREIGN KEY (SEQ_FEATURE_LOC_ID) 
    REFERENCES SEQFEATURELOCATION (ID));

ALTER TABLE SEQFEATURELOCATION ADD (
  CONSTRAINT SEQFEATURELOCATION_FK_3 FOREIGN KEY (SEQ_FEATURE_ID) 
    REFERENCES SEQFEATURE (ID));


ALTER TABLE SEQUENCEPOSITION ADD (
  CONSTRAINT SEQUENCEPOSITION_FK_1 FOREIGN KEY (REPORTER_ID) 
    REFERENCES REPORTER (ID));

ALTER TABLE SEQUENCEPOSITION ADD (
  CONSTRAINT SEQUENCEPOSITION_FK_2 FOREIGN KEY (REPORTER_COMPOSITE_MAP_ID) 
    REFERENCES DESIGNELEMENTMAP (ID));

ALTER TABLE SEQUENCEPOSITION ADD (
  CONSTRAINT SEQUENCEPOSITION_FK_3 FOREIGN KEY (COMPOSITE_ID) 
    REFERENCES COMPOSITESEQUENCE (ID));

ALTER TABLE SEQUENCEPOSITION ADD (
  CONSTRAINT SEQUENCEPOSITION_FK_4 FOREIGN KEY (COMPOSITE_COMPOSITE_MAP_ID) 
    REFERENCES DESIGNELEMENTMAP (ID));


ALTER TABLE SOFTWARE ADD (
  CONSTRAINT SOFTWARE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE SOFTWARE ADD (
  CONSTRAINT SOFTWARE_FK_2 FOREIGN KEY (TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE SOFTWARE ADD (
  CONSTRAINT SOFTWARE_FK_3 FOREIGN KEY (HARDWARE_ID) 
    REFERENCES HARDWARE (ID));

ALTER TABLE SOFTWARE ADD (
  CONSTRAINT SOFTWARE_FK_4 FOREIGN KEY (ID) 
    REFERENCES PARAMETERIZABLE (ID));

ALTER TABLE SOFTWARE ADD (
  CONSTRAINT SOFTWARE_FK_5 FOREIGN KEY (SOFTWARE_ID) 
    REFERENCES SOFTWARE (ID));


ALTER TABLE SOFTWARE2SOFTWARE ADD (
  CONSTRAINT SOFTWARE2SOFTWARE_FK_1 FOREIGN KEY (SOFTWARE_ID) 
    REFERENCES SOFTWARE (ID));

ALTER TABLE SOFTWARE2SOFTWARE ADD (
  CONSTRAINT SOFTWARE2SOFTWARE_FK_2 FOREIGN KEY (ASSOCIATED_SOFTWARE_ID) 
    REFERENCES SOFTWARE (ID));


ALTER TABLE SOFTWAREAPPLICATION ADD (
  CONSTRAINT SOFTWAREAPPLICATION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE SOFTWAREAPPLICATION ADD (
  CONSTRAINT SOFTWAREAPPLICATION_FK_2 FOREIGN KEY (SOFTWARE_ID) 
    REFERENCES SOFTWARE (ID));

ALTER TABLE SOFTWAREAPPLICATION ADD (
  CONSTRAINT SOFTWAREAPPLICATION_FK_3 FOREIGN KEY (ID) 
    REFERENCES PARAMETERIZABLEAPPLICATION (ID));

ALTER TABLE SOFTWAREAPPLICATION ADD (
  CONSTRAINT SOFTWAREAPPLICATION_FK_4 FOREIGN KEY (PROTOCOL_APPLICATION_ID) 
    REFERENCES PROTOCOLAPPLICATION (ID));


ALTER TABLE SOFTWAREMANUFACTURERS ADD (
  CONSTRAINT SOFTWAREMANUFACTURERS_FK1 FOREIGN KEY (SOFTWARE_ID) 
    REFERENCES SOFTWARE (ID));

ALTER TABLE SOFTWAREMANUFACTURERS ADD (
  CONSTRAINT SOFTWAREMANUFACTURERS_FK2 FOREIGN KEY (CONTACT_ID) 
    REFERENCES CONTACT (ID));


ALTER TABLE TOPLEVELBIOASSAYS ADD (
  CONSTRAINT TOPLEVELBIOASSAYS_FK_1 FOREIGN KEY (EXPERIMENT_DESIGN_ID) 
    REFERENCES EXPERIMENTDESIGN (ID));

ALTER TABLE TOPLEVELBIOASSAYS ADD (
  CONSTRAINT TOPLEVELBIOASSAYS_FK_2 FOREIGN KEY (BIOASSAY_ID) 
    REFERENCES BIOASSAY (ID));


ALTER TABLE TRANSFORMATION ADD (
  CONSTRAINT TRANSFORMATION_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE TRANSFORMATION ADD (
  CONSTRAINT TRANSFORMATION_FK_2 FOREIGN KEY (DER_BIOASSAY_DATA_TARGET_ID) 
    REFERENCES BIOASSAYDATA (ID));

ALTER TABLE TRANSFORMATION ADD (
  CONSTRAINT TRANSFORMATION_FK_3 FOREIGN KEY (QUANTITATION_TYPE_MAPPING_ID) 
    REFERENCES QUANTITATIONTYPEMAPPING (ID));

ALTER TABLE TRANSFORMATION ADD (
  CONSTRAINT TRANSFORMATION_FK_4 FOREIGN KEY (DESIGN_ELEMENT_MAPPING_ID) 
    REFERENCES DESIGNELEMENTMAPPING (ID));

ALTER TABLE TRANSFORMATION ADD (
  CONSTRAINT TRANSFORMATION_FK_5 FOREIGN KEY (BIOASSAY_MAPPING_ID) 
    REFERENCES BIOASSAYMAPPING (ID));

ALTER TABLE TRANSFORMATION ADD (
  CONSTRAINT TRANSFORMATION_FK_6 FOREIGN KEY (SECURITY_ID) 
    REFERENCES SECURITY (ID));


ALTER TABLE TRANSFORMEDBIOASSAYDATA ADD (
  CONSTRAINT TRANSFORMEDBIOASSAYDATA_FK_1 FOREIGN KEY (TRANSFORMATION_ID) 
    REFERENCES TRANSFORMATION (ID));

ALTER TABLE TRANSFORMEDBIOASSAYDATA ADD (
  CONSTRAINT TRANSFORMEDBIOASSAYDATA_FK_2 FOREIGN KEY (BIOASSAY_DATA_ID) 
    REFERENCES BIOASSAYDATA (ID));


ALTER TABLE TREATMENT ADD (
  CONSTRAINT TREATMENT_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE TREATMENT ADD (
  CONSTRAINT TREATMENT_FK_2 FOREIGN KEY (ACTION_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE TREATMENT ADD (
  CONSTRAINT TREATMENT_FK_3 FOREIGN KEY (ACTION_MEASUREMENT_ID) 
    REFERENCES MEASUREMENT (ID));

ALTER TABLE TREATMENT ADD (
  CONSTRAINT TREATMENT_FK_4 FOREIGN KEY (BIOMATERIAL_ID) 
    REFERENCES BIOMATERIAL (ID));


ALTER TABLE TST_A_AASSOC ADD (
  CONSTRAINT FK_A_AASSOC_A FOREIGN KEY (A_ID) 
    REFERENCES TST_BASE (ID));

ALTER TABLE TST_A_AASSOC ADD (
  CONSTRAINT FK_A_AASSOC_AASSOC FOREIGN KEY (AASSOC_ID) 
    REFERENCES TST_A_ASSOC (ID));


ALTER TABLE TST_BASE ADD (
  CONSTRAINT FK_BASE_ASSOC FOREIGN KEY (BASE_ASSOC_ID) 
    REFERENCES TST_BASE_ASSOC (ID));


ALTER TABLE TST_B_ASSOC ADD (
  CONSTRAINT FK_B_ASSOC_B FOREIGN KEY (B_ID) 
    REFERENCES TST_BASE (ID));


ALTER TABLE TST_C_ASSOC ADD (
  CONSTRAINT FK_C_ASSOC_C FOREIGN KEY (C_ID) 
    REFERENCES TST_BASE (ID));


ALTER TABLE ZONE ADD (
  CONSTRAINT ZONE_FK_1 FOREIGN KEY (DESC_SECURITY_ID) 
    REFERENCES SECURITY (ID));

ALTER TABLE ZONE ADD (
  CONSTRAINT ZONE_FK_2 FOREIGN KEY (DISTANCE_UNIT_ID) 
    REFERENCES UNIT (ID));

ALTER TABLE ZONE ADD (
  CONSTRAINT ZONE_FK_3 FOREIGN KEY (ZONE_GROUP_ID) 
    REFERENCES ZONEGROUP (ID));


ALTER TABLE ZONEDEFECT ADD (
  CONSTRAINT ZONEDEFECT_FK_1 FOREIGN KEY (DEFECT_TYPE_ID) 
    REFERENCES ONTOLOGYENTRY (ID));

ALTER TABLE ZONEDEFECT ADD (
  CONSTRAINT ZONEDEFECT_FK_2 FOREIGN KEY (POSITION_DELTA_ID) 
    REFERENCES POSITIONDELTA (ID));

ALTER TABLE ZONEDEFECT ADD (
  CONSTRAINT ZONEDEFECT_FK_3 FOREIGN KEY (ZONE_ID) 
    REFERENCES ZONE (ID));

ALTER TABLE ZONEDEFECT ADD (
  CONSTRAINT ZONEDEFECT_FK_4 FOREIGN KEY (ARRAY_MANUFACTURE_DEVIATION_ID) 
    REFERENCES ARRAYMANUFACTUREDEVIATION (ID));


ALTER TABLE ZONEGROUP ADD (
  CONSTRAINT ZONEGROUP_FK_1 FOREIGN KEY (DISTANCE_UNIT_ID) 
    REFERENCES UNIT (ID));

ALTER TABLE ZONEGROUP ADD (
  CONSTRAINT ZONEGROUP_FK_2 FOREIGN KEY (ZONE_LAYOUT_ID) 
    REFERENCES ZONELAYOUT (ID));

ALTER TABLE ZONEGROUP ADD (
  CONSTRAINT ZONEGROUP_FK_3 FOREIGN KEY (PHYSICAL_ARRAY_DESIGN_ID) 
    REFERENCES ARRAYDESIGN (ID));


ALTER TABLE ZONELAYOUT ADD (
  CONSTRAINT ZONELAYOUT_FK_1 FOREIGN KEY (DISTANCE_UNIT_ID) 
    REFERENCES UNIT (ID));



