alter table ACTION drop foreign key ACTIONIFKC;
alter table ACTION_APPLICATION drop foreign key ACTION_APPLICATION__ACTION_DEC;
alter table ACTION_APPLICATION drop foreign key ACTION_APPLICATION__ACTION_FKC;
alter table ACTION_APPLICATION drop foreign key ACTION_APPLICATIONIFKC;
alter table ACTION_APPLICATION drop foreign key ACTION_APPLICATION_PROTOCOL_AC;
alter table ACTION_APPLICATION drop foreign key ACTION_APPLICATION__PROTOCOL_C;
alter table AUDIT drop foreign key AUDIT_DESCRIBABLE_FKC;
alter table AUDIT drop foreign key AUDITIFKC;
alter table AUDIT drop foreign key AUDIT__PERFORMER_FKC;
alter table AUDIT_COLLECTION drop foreign key AUDIT_COLLECTIONIFKC;
alter table BIBLIOGRAPHIC_REFERENCE drop foreign key BIBLIOGRAPHIC_REFERENCEIFKC;
alter table BIBLIOGRAPHIC_REFERENCE drop foreign key BIBLIOGRAPHIC_REFERENCE_REFERC;
alter table CONCEPTUAL_MOLECULE drop foreign key CONCEPTUAL_MOLECULEIFKC;
alter table CONCEPTUAL_MOLECULE drop foreign key CONCEPTUAL_MOLECULE_CONCEPTUAC;
alter table CONCEPTUAL_MOLECULE_COLLECTION drop foreign key CONCEPTUAL_MOLECULE_COLLECTIONIFKC;
alter table CONTACT drop foreign key CONTACTIFKC;
alter table CONTACT drop foreign key CONTACT_AUDIT_COLLECTION_FKC;
alter table CONTACT_ROLE drop foreign key CONTACT_ROLE_INVESTIGATION_FKC;
alter table CONTACT_ROLE drop foreign key CONTACT_ROLE__ROLE_FKC;
alter table CONTACT_ROLE drop foreign key CONTACT_ROLE__CONTACT_FKC;
alter table CONTACT_ROLE drop foreign key CONTACT_ROLEIFKC;
alter table CONTACT_ROLE drop foreign key CONTACT_ROLE_PROTOCOL_APPLICAC;
alter table CONTACT_ROLE drop foreign key CONTACT_ROLE_MATERIAL_FKC;
alter table CONTACT_ROLE drop foreign key CONTACT_ROLE_DATABASE_FKC;
alter table CONTACT_ROLE drop foreign key CONTACT_ROLE_PARAMETERIZABLE_C;
alter table DATA drop foreign key DATAIFKC;
alter table DATA drop foreign key DATA_DATA_COLLECTION_FKC;
alter table DATA drop foreign key GPA_OUTDATA_FKC;
alter table DATABASE_ENTRY drop foreign key DATABASE_ENTRYIFKC;
alter table DATABASE_ENTRY drop foreign key DATABASE_ENTRY_IDENTIFIABLE_FC;
alter table DATABASE_ENTRY drop foreign key DATABASE_ENTRY__DATABASE_FKC;
alter table DATABASE_safe drop foreign key DATABASEIFKC;
alter table DATABASE_safe drop foreign key DATABASE_REFERENCEABLE_COLLECC;
alter table DATA_COLLECTION drop foreign key DATA_COLLECTIONIFKC;
alter table DATA_PARTITION drop foreign key DATA_PARTITIONIFKC;
alter table DATA_PARTITION drop foreign key DATA_PARTITION_DATA_COLLECTIOC;
alter table DATA_PARTITION drop foreign key DATA_PARTITION__PARTITIONED_DC;
alter table DATA_PROPERTY drop foreign key DATA_PROPERTYIFKC;
alter table DESCRIBABLE drop foreign key DESCRIBABLE__SECURITY_FKC;
alter table DESCRIBABLE drop foreign key DESCRIBABLE__URI_FKC;
alter table DESCRIPTION drop foreign key DESCRIPTION_DESCRIBABLE_FKC;
alter table DESCRIPTION drop foreign key DESCRIPTIONIFKC;
alter table DIMENSION drop foreign key DIMENSIONIFKC;
alter table DIMENSION drop foreign key DIMENSION_DATA_COLLECTION_FKC;
alter table DIMENSION drop foreign key DIMENSION__DIMENSION_TYPE_FKC;
alter table DIMENSION_ELEMENT drop foreign key DIMENSION_ELEMENTIFKC;
alter table EQUIPMENT drop foreign key EQUIPMENTIFKC;
alter table EQUIPMENT drop foreign key EQUIPMENT_PROTOCOL_COLLECTIONC;
alter table EQUIPMENT drop foreign key EQUIPMENT__MAKE_FKC;
alter table EQUIPMENT drop foreign key EQUIPMENT__MODEL_FKC;
alter table EQUIPMENT_APPLICATION drop foreign key EQUIPMENT_APPLICATIONIFKC;
alter table EQUIPMENT_APPLICATION drop foreign key EQUIPMENT_APPLICATION_PROTOCOC;
alter table EQUIPMENT_APPLICATION drop foreign key EQUIPMENT_APPLICATION__APPLIEC;
alter table EXTERNAL_DATA drop foreign key EXTERNAL_DATA__EXTERNAL_FORMAC;
alter table EXTERNAL_DATA drop foreign key EXTERNAL_DATAIFKC;
alter table EXTERNAL_DATA drop foreign key EXTERNAL_DATA__FILE_FORMAT_FKC;
alter table EXTERNAL_U_R_I drop foreign key EXTERNAL_U_R_IIFKC;
alter table FACTOR drop foreign key FACTOR_INVESTIGATION_COLLECTIC;
alter table FACTOR drop foreign key FACTOR__FACTOR_CATEGORY_FKC;
alter table FACTOR drop foreign key FACTORIFKC;
alter table FACTOR_VALUE drop foreign key FACTOR_VALUEIFKC;
alter table FACTOR_VALUE drop foreign key FACTOR_VALUE__VALUE_FKC;
alter table FACTOR_VALUE drop foreign key FACTOR_VALUE_FACTOR_FKC;
alter table FU_G_EROOT drop foreign key FU_G_EROOT__AUDIT_COLLECTION_C;
alter table FU_G_EROOT drop foreign key FU_G_EROOT__DATA_COLLECTION_FC;
alter table FU_G_EROOT drop foreign key FU_G_EROOT__CONCEPTUAL_MOLECUC;
alter table FU_G_EROOT drop foreign key FU_G_EROOT__ONTOLOGY_COLLECTIC;
alter table FU_G_EROOT drop foreign key FU_G_EROOTIFKC;
alter table FU_G_EROOT drop foreign key FU_G_EROOT__REFERENCEABLE_COLC;
alter table FU_G_EROOT drop foreign key FU_G_EROOT__PROTOCOL_COLLECTIC;
alter table FU_G_EROOT drop foreign key FU_G_EROOT__MATERIAL_COLLECTIC;
alter table FU_G_EROOT drop foreign key FU_G_EROOT__INVESTIGATION_COLC;
alter table GENERIC_ACTION drop foreign key GENERIC_ACTIONIFKC;
alter table GENERIC_ACTION drop foreign key GENERIC_ACTION_GENERIC_PROTOCC;
alter table GENERIC_ACTION drop foreign key GENERIC_ACTION__ACTION_TERM_FC;
alter table GENERIC_ACTION drop foreign key GENERIC_ACTION__GENERIC_PROTOC;
alter table GENERIC_EQUIPMENT drop foreign key GENERIC_EQUIPMENTIFKC;
alter table GENERIC_MATERIAL drop foreign key GENERIC_MATERIALIFKC;
alter table GENERIC_MAT_MEAS drop foreign key GENERIC_MAT_MEASIFKC;
alter table GENERIC_MAT_MEAS drop foreign key GENERIC_MAT_MEAS__GENERIC_MEAC;
alter table GENERIC_MAT_MEAS drop foreign key GENERIC_MAT_MEAS_GENERIC_PROTC;
alter table GENERIC_PARAMETER drop foreign key GENERIC_PARAMETER_GENERIC_EQUC;
alter table GENERIC_PARAMETER drop foreign key GENERIC_PARAMETER_GENERIC_SOFC;
alter table GENERIC_PARAMETER drop foreign key GENERIC_PARAMETERIFKC;
alter table GENERIC_PARAMETER drop foreign key GENERIC_PARAMETER_GENERIC_PROC;
alter table GENERIC_PROTOCOL drop foreign key GENERIC_PROTOCOLIFKC;
alter table GENERIC_PROTOCOL_APPLICATION drop foreign key GENERIC_PROTOCOL_APPLICATIONIFKC;
alter table GENERIC_PROTOCOL_APPLICATION drop foreign key GENERIC_PROTOCOL_APPLICATION_C;
alter table GENERIC_SOFTWARE drop foreign key GENERIC_SOFTWAREIFKC;
alter table HIGHER_LEVEL_ANALYSIS drop foreign key HIGHER_LEVEL_ANALYSISIFKC;
alter table HIGHER_LEVEL_ANALYSIS drop foreign key HIGHER_LEVEL_ANALYSIS_DATA_COC;
alter table IDENTIFIABLE drop foreign key IDENTIFIABLEIFKC;
alter table IDENTIFICATION_SERVER drop foreign key IDENTIFICATION_SERVER__DATABAC;
alter table INTERNAL_DATA drop foreign key INTERNAL_DATAIFKC;
alter table INVESTIGATION drop foreign key INVESTIGATION_INVESTIGATION_CC;
alter table INVESTIGATION drop foreign key INVESTIGATIONIFKC;
alter table INVESTIGATION_COLLECTION drop foreign key INVESTIGATION_COLLECTIONIFKC;
alter table INVESTIGATION_COMPONENT drop foreign key INVESTIGATION_COMPONENT_INVESC;
alter table INVESTIGATION_COMPONENT drop foreign key INVESTIGATION_COMPONENT__NORMC;
alter table INVESTIGATION_COMPONENT drop foreign key INVESTIGATION_COMPONENTIFKC;
alter table INVESTIGATION_COMPONENT drop foreign key INVESTIGATION_COMPONENT__REPLC;
alter table INVESTIGATION_COMPONENT drop foreign key INVESTIGATION_COMPONENT__QUALC;
alter table MATERIAL drop foreign key MATERIALIFKC;
alter table MATERIAL drop foreign key MATERIAL_MATERIAL_COLLECTION_C;
alter table MATERIAL drop foreign key MATERIAL__MATERIAL_TYPE_FKC;
alter table MATERIAL drop foreign key MATERIAL_GENERIC_PROTOCOL_APPC;
alter table MATERIAL_COLLECTION drop foreign key MATERIAL_COLLECTIONIFKC;
alter table MATERIAL_MEASUREMENT drop foreign key MATERIAL_MEASUREMENTIFKC;
alter table MATERIAL_MEASUREMENT drop foreign key MATERIAL_MEASUREMENT__MEASUREC;
alter table NAME_VALUE_TYPE drop foreign key NAME_VALUE_TYPE_DESCRIBABLE_FC;
alter table NAME_VALUE_TYPE drop foreign key NAME_VALUE_TYPEIFKC;
alter table OBJECT_PROPERTY drop foreign key OBJECT_PROPERTYIFKC;
alter table ONTOLOGY_COLLECTION drop foreign key ONTOLOGY_COLLECTIONIFKC;
alter table ONTOLOGY_INDIVIDUAL drop foreign key ONTOLOGY_INDIVIDUALIFKC;
alter table ONTOLOGY_PROPERTY drop foreign key ONTOLOGY_PROPERTYIFKC;
alter table ONTOLOGY_TERM drop foreign key ONTOLOGY_TERM_ONTOLOGY_COLLECC;
alter table ONTOLOGY_TERM drop foreign key ONTOLOGY_TERMIFKC;
alter table ORGANIZATION drop foreign key ORGANIZATIONIFKC;
alter table ORGANIZATION drop foreign key ORGANIZATION__PARENT_FKC;
alter table PARAMETER drop foreign key PARAMETERIFKC;
alter table PARAMETER drop foreign key PARAMETER__DEFAULT_VALUE_FKC;
alter table PARAMETER drop foreign key PARAMETER__PARAMETER_TYPE_FKC;
alter table PARAMETERIZABLE drop foreign key PARAMETERIZABLEIFKC;
alter table PARAMETERIZABLE_APPLICATION drop foreign key PARAMETERIZABLE_APPLICATIONIFKC;
alter table PARAMETER_VALUE drop foreign key PARAMETER_VALUE_PARAMETERIZABC;
alter table PARAMETER_VALUE drop foreign key PARAMETER_VALUE__PARAMETER_FKC;
alter table PARAMETER_VALUE drop foreign key PARAMETER_VALUEIFKC;
alter table PARAMETER_VALUE drop foreign key PARAMETER_VALUE__PARAMETER_VAC;
alter table PARTITION_PAIR drop foreign key PARTITION_PAIR__PARTITION_PAIC;
alter table PARTITION_PAIR drop foreign key PARTITION_PAIRIFKC;
alter table PARTITION_PAIR drop foreign key PARTITION_PAIR_PROTOCOL_APPLIC;
alter table PERSON drop foreign key PERSONIFKC;
alter table PROTOCOL drop foreign key PROTOCOLIFKC;
alter table PROTOCOL drop foreign key PROTOCOL_PROTOCOL_COLLECTION_C;
alter table PROTOCOL_APPLICATION drop foreign key PROTOCOL_APPLICATION__PROTOCOC;
alter table PROTOCOL_APPLICATION drop foreign key PROTOCOL_APPLICATIONIFKC;
alter table PROTOCOL_APPLICATION drop foreign key PROTOCOL_APPLICATION_PROTOCOLC;
alter table PROTOCOL_COLLECTION drop foreign key PROTOCOL_COLLECTIONIFKC;
alter table REFERENCEABLE_COLLECTION drop foreign key REFERENCEABLE_COLLECTIONIFKC;
alter table SECURITY drop foreign key SECURITYIFKC;
alter table SECURITY drop foreign key SECURITY_AUDIT_COLLECTION_FKC;
alter table SECURITY_ACCESS drop foreign key SECURITY_ACCESS_SECURITY_FKC;
alter table SECURITY_ACCESS drop foreign key SECURITY_ACCESSIFKC;
alter table SECURITY_ACCESS drop foreign key SECURITY_ACCESS__ACCESS_RIGHTC;
alter table SECURITY_ACCESS drop foreign key SECURITY_ACCESS__ACCESS_GROUPC;
alter table SECURITY_GROUP drop foreign key SECURITY_GROUPIFKC;
alter table SECURITY_GROUP drop foreign key SECURITY_GROUP_AUDIT_COLLECTIC;
alter table SEQUENCE drop foreign key SEQUENCEIFKC;
alter table SEQUENCE drop foreign key SEQUENCE__SEQUENCE_ANNOTATIONC;
alter table SEQUENCE_ANNOTATION drop foreign key SEQUENCE_ANNOTATION__POLYMER_C;
alter table SEQUENCE_ANNOTATION drop foreign key SEQUENCE_ANNOTATION__TYPE_FKC;
alter table SEQUENCE_ANNOTATION drop foreign key SEQUENCE_ANNOTATIONIFKC;
alter table SEQUENCE_ANNOTATION drop foreign key SEQUENCE_ANNOTATION__SPECIES_C;
alter table SEQUENCE_ANNOTATION drop foreign key SEQUENCE_ANNOTATION_CONCEPTUAC;
alter table SOFTWARE drop foreign key SOFTWAREIFKC;
alter table SOFTWARE drop foreign key SOFTWARE_PROTOCOL_COLLECTION_C;
alter table SOFTWARE_APPLICATION drop foreign key SOFTWARE_APPLICATIONIFKC;
alter table SOFTWARE_APPLICATION drop foreign key SOFTWARE_APPLICATION_PROTOCOLC;
alter table SOFTWARE_APPLICATION drop foreign key SOFTWARE_APPLICATION__APPLIEDC;
alter table __AFFILIATIONS drop foreign key ORGANIZATION_PEOPLE_FKC;
alter table __AFFILIATIONS drop foreign key PERSON__AFFILIATIONS_FKC;
alter table __ALL_PROTOCOL_APPLICATIONS drop foreign key INVESTIGATION_COMPONENT__ALL_C;
alter table __ALL_PROTOCOL_APPLICATIONS drop foreign key PROTOCOL_APPLICATION_INVESTIGC;
alter table __ANNOTATIONS drop foreign key DESCRIBABLE__ANNOTATIONS_FKC;
alter table __ANNOTATIONS drop foreign key ONTOLOGY_TERM_DESCRIBABLES_FKC;
alter table __BIBLIOGRAPHIC_REFERENCES drop foreign key IDENTIFIABLE__BIBLIOGRAPHIC_RC;
alter table __BIBLIOGRAPHIC_REFERENCES drop foreign key BIBLIOGRAPHIC_REFERENCE_IDENTC;
alter table __CHARACTERISTICS drop foreign key MAT_CHAR_FKC;
alter table __CHARACTERISTICS drop foreign key MATERIAL__CHARACTERISTICS_FKC;
alter table __COMPONENT_DESIGN_TYPES drop foreign key INVESTIGATION_COMPONENT__COMPC;
alter table __COMPONENT_DESIGN_TYPES drop foreign key ONTOLOGY_TERM_INVESTIGATION_CC;
alter table __CONTENT drop foreign key OBJECT_PROPERTY__CONTENT_FKC;
alter table __CONTENT drop foreign key ONTOLOGY_INDIVIDUAL_OBJECT_PRC;
alter table __DATA_PARTITIONS drop foreign key FACTOR_VALUE__DATA_PARTITIONSC;
alter table __DATA_PARTITIONS drop foreign key DATA_PARTITION_FACTOR_VALUES_C;
alter table __DIMENSION drop foreign key DATA__DIMENSION_FKC;
alter table __DIMENSION drop foreign key DIMENSION_DATAS_FKC;
alter table __DIMENSION_ELEMENT_SET drop foreign key DATA_PARTITION__DIMENSION_ELEC;
alter table __DIMENSION_ELEMENT_SET drop foreign key DIMENSION_ELEMENT_DATA_PARTITC;
alter table __FACTORS drop foreign key INVESTIGATION_COMPONENT__FACTC;
alter table __FACTORS drop foreign key FACTOR_INVESTIGATION_COMPONENC;
alter table __GENERIC_EQUIPMENT drop foreign key GENERIC_EQUIPMENT_GENERIC_PROC;
alter table __GENERIC_EQUIPMENT drop foreign key GENERIC_PROTOCOL__GENERIC_EQUC;
alter table __GENERIC_EQUIPMENT_PARTS drop foreign key GENERIC_EQUIPMENT__GENERIC_EQC;
alter table __GENERIC_EQUIPMENT_PARTS drop foreign key GENERIC_EQUIPMENT_GENERIC_EQUC;
alter table __GENERIC_INPUT_DATA drop foreign key DATA_INPUT_GPA_FKC;
alter table __GENERIC_INPUT_DATA drop foreign key GPA_INDATA_FKC;
alter table __GENERIC_SOFTWARE drop foreign key GENERIC_SOFTWARE_GENERIC_PROTC;
alter table __GENERIC_SOFTWARE drop foreign key GENERIC_PROTOCOL__GENERIC_SOFC;
alter table __INPUT_PARTITIONS drop foreign key PARTITION_PAIR__INPUT_PARTITIC;
alter table __INPUT_PARTITIONS drop foreign key PARTITION_IN_FKC;
alter table __INVESTIGATION_TYPES drop foreign key INVESTIGATION__INVESTIGATION_C;
alter table __INVESTIGATION_TYPES drop foreign key ONTOLOGY_TERM_INVESTIGATIONS_C;
alter table __MEMBERS drop foreign key CONTACT_SECURITY_GROUPS_FKC;
alter table __MEMBERS drop foreign key SECURITY_GROUP__MEMBERS_FKC;
alter table __OUTPUT_PARTITIONS drop foreign key PARTITION_OUT_FKC;
alter table __OUTPUT_PARTITIONS drop foreign key PARTITION_PAIR__OUTPUT_PARTITC;
alter table __OWNER drop foreign key SECURITY__OWNER_FKC;
alter table __OWNER drop foreign key CONTACT_SECURITIES_FKC;
alter table __PARAMETERIZABLE_TYPES drop foreign key PARAMETERIZABLE__PARAMETERIZAC;
alter table __PARAMETERIZABLE_TYPES drop foreign key ONTOLOGY_TERM_PARAMETERIZABLEC;
alter table __PROPERTIES drop foreign key ONTOLOGY_PROPERTY_ONTOLOGY_INC;
alter table __PROPERTIES drop foreign key ONTOLOGY_INDIVIDUAL__PROPERTIC;
alter table __PROTOCOL_INPUT_TYPES drop foreign key PROTOCOL__INPUT_TYPES_FKC;
alter table __PROTOCOL_INPUT_TYPES drop foreign key P_INPUTTYPES_FK;
alter table __PROTOCOL_OUTPUT_TYPES drop foreign key P_OUTPUTTYPES_FKC;
alter table __PROTOCOL_OUTPUT_TYPES drop foreign key PROTOCOL__OUTPUT_TYPES_FKC;
alter table __QUALITY_CONTROL_STATISTICS drop foreign key Material_QC_FKC;
alter table __QUALITY_CONTROL_STATISTICS drop foreign key MATERIAL__QUALITY_CONTROL_STAC;
alter table __SOFTWARE2_EQUIPMENT drop foreign key EQUIPMENT__SOFTWARES_FKC;
alter table __SOFTWARE2_EQUIPMENT drop foreign key SOFTWARE__EQUIPMENT_FKC;
alter table __SOURCE_MATERIALS drop foreign key INVESTIGATION__SOURCE_MATERIAC;
alter table __SOURCE_MATERIALS drop foreign key MATERIAL_INVESTIGATIONS_FKC;
alter table __SUMMARY_RESULTS drop foreign key INVESTIGATION__SUMMARY_RESULTC;
alter table __SUMMARY_RESULTS drop foreign key HIGHER_LEVEL_ANALYSIS_INVESTIC;
alter table __SUPPORTING_DATA drop foreign key DATA_HIGHER_LEVEL_ANALYSES_FKC;
alter table __SUPPORTING_DATA drop foreign key HIGHER_LEVEL_ANALYSIS__SUPPORC;
-- SKIP drop table if exists ACTION;
-- SKIP drop table if exists ACTION_APPLICATION;
-- SKIP drop table if exists AUDIT;
-- SKIP drop table if exists AUDIT_COLLECTION;
-- SKIP drop table if exists BIBLIOGRAPHIC_REFERENCE;
-- SKIP drop table if exists CONCEPTUAL_MOLECULE;
-- SKIP drop table if exists CONCEPTUAL_MOLECULE_COLLECTION;
-- SKIP drop table if exists CONTACT;
-- SKIP drop table if exists CONTACT_ROLE;
-- SKIP drop table if exists DATA;
-- SKIP drop table if exists DATABASE_ENTRY;
-- SKIP drop table if exists DATABASE_safe;
-- SKIP drop table if exists DATA_COLLECTION;
-- SKIP drop table if exists DATA_PARTITION;
-- SKIP drop table if exists DATA_PROPERTY;
-- SKIP drop table if exists DESCRIBABLE;
-- SKIP drop table if exists DESCRIPTION;
-- SKIP drop table if exists DIMENSION;
-- SKIP drop table if exists DIMENSION_ELEMENT;
-- SKIP drop table if exists EQUIPMENT;
-- SKIP drop table if exists EQUIPMENT_APPLICATION;
-- SKIP drop table if exists EXTERNAL_DATA;
-- SKIP drop table if exists EXTERNAL_U_R_I;
-- SKIP drop table if exists FACTOR;
-- SKIP drop table if exists FACTOR_VALUE;
-- SKIP drop table if exists FU_G_EROOT;
-- SKIP drop table if exists GENERIC_ACTION;
-- SKIP drop table if exists GENERIC_EQUIPMENT;
-- SKIP drop table if exists GENERIC_MATERIAL;
-- SKIP drop table if exists GENERIC_MAT_MEAS;
-- SKIP drop table if exists GENERIC_PARAMETER;
-- SKIP drop table if exists GENERIC_PROTOCOL;
-- SKIP drop table if exists GENERIC_PROTOCOL_APPLICATION;
-- SKIP drop table if exists GENERIC_SOFTWARE;
-- SKIP drop table if exists HIGHER_LEVEL_ANALYSIS;
-- SKIP drop table if exists IDENTIFIABLE;
-- SKIP drop table if exists IDENTIFICATION_SERVER;
-- SKIP drop table if exists INTERNAL_DATA;
-- SKIP drop table if exists INVESTIGATION;
-- SKIP drop table if exists INVESTIGATION_COLLECTION;
-- SKIP drop table if exists INVESTIGATION_COMPONENT;
-- SKIP drop table if exists MATERIAL;
-- SKIP drop table if exists MATERIAL_COLLECTION;
-- SKIP drop table if exists MATERIAL_MEASUREMENT;
-- SKIP drop table if exists NAME_VALUE_TYPE;
-- SKIP drop table if exists OBJECT_PROPERTY;
-- SKIP drop table if exists ONTOLOGY_COLLECTION;
-- SKIP drop table if exists ONTOLOGY_INDIVIDUAL;
-- SKIP drop table if exists ONTOLOGY_PROPERTY;
-- SKIP drop table if exists ONTOLOGY_TERM;
-- SKIP drop table if exists ORGANIZATION;
-- SKIP drop table if exists PARAMETER;
-- SKIP drop table if exists PARAMETERIZABLE;
-- SKIP drop table if exists PARAMETERIZABLE_APPLICATION;
-- SKIP drop table if exists PARAMETER_VALUE;
-- SKIP drop table if exists PARTITION_PAIR;
-- SKIP drop table if exists PERSON;
-- SKIP drop table if exists PROTOCOL;
-- SKIP drop table if exists PROTOCOL_APPLICATION;
-- SKIP drop table if exists PROTOCOL_COLLECTION;
-- SKIP drop table if exists REFERENCEABLE_COLLECTION;
-- SKIP drop table if exists SECURITY;
-- SKIP drop table if exists SECURITY_ACCESS;
-- SKIP drop table if exists SECURITY_GROUP;
-- SKIP drop table if exists SEQUENCE;
-- SKIP drop table if exists SEQUENCE_ANNOTATION;
-- SKIP drop table if exists SOFTWARE;
-- SKIP drop table if exists SOFTWARE_APPLICATION;
-- SKIP drop table if exists __AFFILIATIONS;
-- SKIP drop table if exists __ALL_PROTOCOL_APPLICATIONS;
-- SKIP drop table if exists __ANNOTATIONS;
-- SKIP drop table if exists __BIBLIOGRAPHIC_REFERENCES;
-- SKIP drop table if exists __CHARACTERISTICS;
-- SKIP drop table if exists __COMPONENT_DESIGN_TYPES;
-- SKIP drop table if exists __CONTENT;
-- SKIP drop table if exists __DATA_PARTITIONS;
-- SKIP drop table if exists __DIMENSION;
-- SKIP drop table if exists __DIMENSION_ELEMENT_SET;
-- SKIP drop table if exists __FACTORS;
-- SKIP drop table if exists __GENERIC_EQUIPMENT;
-- SKIP drop table if exists __GENERIC_EQUIPMENT_PARTS;
-- SKIP drop table if exists __GENERIC_INPUT_DATA;
-- SKIP drop table if exists __GENERIC_SOFTWARE;
-- SKIP drop table if exists __INPUT_PARTITIONS;
-- SKIP drop table if exists __INVESTIGATION_TYPES;
-- SKIP drop table if exists __MEMBERS;
-- SKIP drop table if exists __OUTPUT_PARTITIONS;
-- SKIP drop table if exists __OWNER;
-- SKIP drop table if exists __PARAMETERIZABLE_TYPES;
-- SKIP drop table if exists __PROPERTIES;
-- SKIP drop table if exists __PROTOCOL_INPUT_TYPES;
-- SKIP drop table if exists __PROTOCOL_OUTPUT_TYPES;
-- SKIP drop table if exists __QUALITY_CONTROL_STATISTICS;
-- SKIP drop table if exists __SOFTWARE2_EQUIPMENT;
-- SKIP drop table if exists __SOURCE_MATERIALS;
-- SKIP drop table if exists __SUMMARY_RESULTS;
-- SKIP drop table if exists __SUPPORTING_DATA;
create table ACTION (
    ID BIGINT not null,
    ACTION_ORDINAL INTEGER,
    primary key (ID)
);
create table ACTION_APPLICATION (
    ID BIGINT not null,
    _ACTION_FK BIGINT not null,
    _ACTION_DEVIATION_FK BIGINT unique,
    _PROTOCOL_APPLICATION_REFER_FK BIGINT unique,
    PROTOCOL_APPLICATION_FK BIGINT,
    primary key (ID)
);
create table AUDIT (
    ID BIGINT not null,
    DATE DATETIME not null,
    ACTION VARCHAR(255) BINARY not null,
    _PERFORMER_FK BIGINT,
    DESCRIBABLE_FK BIGINT,
    primary key (ID)
);
create table AUDIT_COLLECTION (
    ID BIGINT not null,
    primary key (ID)
);
create table BIBLIOGRAPHIC_REFERENCE (
    ID BIGINT not null,
    AUTHORS VARCHAR(255) BINARY,
    PUBLICATION VARCHAR(255) BINARY,
    PUBLISHER VARCHAR(255) BINARY,
    EDITOR VARCHAR(255) BINARY,
    YEAR INTEGER,
    VOLUME VARCHAR(255) BINARY,
    ISSUE VARCHAR(255) BINARY,
    PAGES VARCHAR(255) BINARY,
    TITLE VARCHAR(255) BINARY,
    REFERENCEABLE_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table CONCEPTUAL_MOLECULE (
    ID BIGINT not null,
    CONCEPTUAL_MOLECULE_COLLECT_FK BIGINT,
    primary key (ID)
);
create table CONCEPTUAL_MOLECULE_COLLECTION (
    ID BIGINT not null,
    primary key (ID)
);
create table CONTACT (
    ID BIGINT not null,
    ADDRESS VARCHAR(255) BINARY,
    PHONE VARCHAR(255) BINARY,
    EMAIL VARCHAR(255) BINARY,
    FAX VARCHAR(255) BINARY,
    TOLL_FREE_PHONE VARCHAR(255) BINARY,
    AUDIT_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table CONTACT_ROLE (
    ID BIGINT not null,
    _CONTACT_FK BIGINT not null,
    _ROLE_FK BIGINT not null,
    INVESTIGATION_FK BIGINT,
    MATERIAL_FK BIGINT,
    DATABASE_FK BIGINT,
    PARAMETERIZABLE_FK BIGINT,
    PROTOCOL_APPLICATION_FK BIGINT,
    primary key (ID)
);
create table DATA (
    ID BIGINT not null,
    GENERIC_PROTOCOL_APPLICATIO_FK BIGINT,
    DATA_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table DATABASE_ENTRY (
    ID BIGINT not null,
    ACCESSION VARCHAR(255) BINARY not null,
    ACCESSION_VERSION VARCHAR(255) BINARY,
    _DATABASE_FK BIGINT not null,
    IDENTIFIABLE_FK BIGINT,
    primary key (ID)
);
create table DATABASE_safe (
    ID BIGINT not null,
    VERSION VARCHAR(255) BINARY,
    U_R_I VARCHAR(255) BINARY,
    REFERENCEABLE_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table DATA_COLLECTION (
    ID BIGINT not null,
    primary key (ID)
);
create table DATA_PARTITION (
    ID BIGINT not null,
    _PARTITIONED_DATA_FK BIGINT not null,
    DATA_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table DATA_PROPERTY (
    ID BIGINT not null,
    DATA_TYPE VARCHAR(255) BINARY,
    VALUE VARCHAR(255) BINARY,
    primary key (ID)
);
create table DESCRIBABLE (
    ID BIGINT not null auto_increment,
    _SECURITY_FK BIGINT,
    _URI_FK BIGINT unique,
    primary key (ID)
);
create table DESCRIPTION (
    ID BIGINT not null,
    TEXT VARCHAR(255) BINARY,
    DESCRIBABLE_FK BIGINT,
    primary key (ID)
);
create table DIMENSION (
    ID BIGINT not null,
    _DIMENSION_TYPE_FK BIGINT,
    DATA_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table DIMENSION_ELEMENT (
    ID BIGINT not null,
    primary key (ID)
);
create table EQUIPMENT (
    ID BIGINT not null,
    _MODEL_FK BIGINT,
    _MAKE_FK BIGINT,
    PROTOCOL_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table EQUIPMENT_APPLICATION (
    ID BIGINT not null,
    SERIAL_NUMBER VARCHAR(255) BINARY,
    _APPLIED_EQUIPMENT_FK BIGINT not null,
    PROTOCOL_APPLICATION_FK BIGINT,
    primary key (ID)
);
create table EXTERNAL_DATA (
    ID BIGINT not null,
    _FILE_FORMAT_FK BIGINT,
    _EXTERNAL_FORMAT_DOCUMENTAT_FK BIGINT unique,
    primary key (ID)
);
create table EXTERNAL_U_R_I (
    ID BIGINT not null,
    URI VARCHAR(255) BINARY not null,
    primary key (ID)
);
create table FACTOR (
    ID BIGINT not null,
    _FACTOR_CATEGORY_FK BIGINT,
    INVESTIGATION_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table FACTOR_VALUE (
    ID BIGINT not null,
    _VALUE_FK BIGINT,
    FACTOR_FK BIGINT,
    primary key (ID)
);
create table FU_G_EROOT (
    ID BIGINT not null,
    _MATERIAL_COLLECTION_FK BIGINT unique,
    _CONCEPTUAL_MOLECULE_COLLEC_FK BIGINT unique,
    _REFERENCEABLE_COLLECTION_FK BIGINT unique,
    _INVESTIGATION_COLLECTION_FK BIGINT unique,
    _DATA_COLLECTION_FK BIGINT unique,
    _AUDIT_COLLECTION_FK BIGINT unique,
    _PROTOCOL_COLLECTION_FK BIGINT unique,
    _ONTOLOGY_COLLECTION_FK BIGINT unique,
    primary key (ID)
);
create table GENERIC_ACTION (
    ID BIGINT not null,
    ACTION_TEXT VARCHAR(255) BINARY,
    _ACTION_TERM_FK BIGINT,
    _GENERIC_PROTOCOL_REFERENCE_FK BIGINT unique,
    GENERIC_PROTOCOL_FK BIGINT,
    primary key (ID)
);
create table GENERIC_EQUIPMENT (
    ID BIGINT not null,
    primary key (ID)
);
create table GENERIC_MATERIAL (
    ID BIGINT not null,
    primary key (ID)
);
create table GENERIC_MAT_MEAS (
    ID BIGINT not null,
    _GENERIC_MEASURE_MATERIAL_FK BIGINT not null,
    GENERIC_PROTOCOL_APPLICATIO_FK BIGINT,
    primary key (ID)
);
create table GENERIC_PARAMETER (
    ID BIGINT not null,
    GENERIC_PROTOCOL_FK BIGINT,
    GENERIC_SOFTWARE_FK BIGINT,
    GENERIC_EQUIPMENT_FK BIGINT,
    primary key (ID)
);
create table GENERIC_PROTOCOL (
    ID BIGINT not null,
    primary key (ID)
);
create table GENERIC_PROTOCOL_APPLICATION (
    ID BIGINT not null,
    _GENERIC_PROTOCOL_FK BIGINT not null,
    primary key (ID)
);
create table GENERIC_SOFTWARE (
    ID BIGINT not null,
    primary key (ID)
);
create table HIGHER_LEVEL_ANALYSIS (
    ID BIGINT not null,
    DATA_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table IDENTIFIABLE (
    ID BIGINT not null,
    IDENTIFIER VARCHAR(255) BINARY not null,
    NAME VARCHAR(255) BINARY,
    primary key (ID)
);
create table IDENTIFICATION_SERVER (
    ID BIGINT not null auto_increment,
    FUGE_IDENTIFIER VARCHAR(255) BINARY,
    ENTITY_TYPE VARCHAR(255) BINARY not null,
    _DATABASE_IDENTIFIER_FK BIGINT not null unique,
    primary key (ID)
);
create table INTERNAL_DATA (
    ID BIGINT not null,
    STORAGE LONGBLOB,
    primary key (ID)
);
create table INVESTIGATION (
    ID BIGINT not null,
    INVESTIGATION_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table INVESTIGATION_COLLECTION (
    ID BIGINT not null,
    primary key (ID)
);
create table INVESTIGATION_COMPONENT (
    ID BIGINT not null,
    _REPLICATE_DESCRIPTION_FK BIGINT unique,
    _QUALITY_CONTROL_DESCRIPTIO_FK BIGINT unique,
    _NORMALIZATION_DESCRIPTION_FK BIGINT unique,
    INVESTIGATION_FK BIGINT,
    primary key (ID)
);
create table MATERIAL (
    ID BIGINT not null,
    _MATERIAL_TYPE_FK BIGINT,
    GENERIC_PROTOCOL_APPLICATIO_FK BIGINT,
    MATERIAL_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table MATERIAL_COLLECTION (
    ID BIGINT not null,
    primary key (ID)
);
create table MATERIAL_MEASUREMENT (
    ID BIGINT not null,
    _MEASUREMENT_FK BIGINT,
    primary key (ID)
);
create table NAME_VALUE_TYPE (
    ID BIGINT not null,
    NAME VARCHAR(255) BINARY,
    VALUE VARCHAR(255) BINARY,
    TYPE VARCHAR(255) BINARY,
    DESCRIBABLE_FK BIGINT,
    primary key (ID)
);
create table OBJECT_PROPERTY (
    ID BIGINT not null,
    primary key (ID)
);
create table ONTOLOGY_COLLECTION (
    ID BIGINT not null,
    primary key (ID)
);
create table ONTOLOGY_INDIVIDUAL (
    ID BIGINT not null,
    primary key (ID)
);
create table ONTOLOGY_PROPERTY (
    ID BIGINT not null,
    primary key (ID)
);
create table ONTOLOGY_TERM (
    ID BIGINT not null,
    ONTOLOGY_U_R_I VARCHAR(255) BINARY,
    ONTOLOGY_TERM_U_R_I VARCHAR(255) BINARY,
    ONTOLOGY_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table ORGANIZATION (
    ID BIGINT not null,
    _PARENT_FK BIGINT,
    primary key (ID)
);
create table PARAMETER (
    ID BIGINT not null,
    _DEFAULT_VALUE_FK BIGINT,
    _PARAMETER_TYPE_FK BIGINT,
    primary key (ID)
);
create table PARAMETERIZABLE (
    ID BIGINT not null,
    primary key (ID)
);
create table PARAMETERIZABLE_APPLICATION (
    ID BIGINT not null,
    primary key (ID)
);
create table PARAMETER_VALUE (
    ID BIGINT not null,
    _PARAMETER_FK BIGINT not null,
    _PARAMETER_VALUE_FK BIGINT,
    PARAMETERIZABLE_APPLICATION_FK BIGINT,
    primary key (ID)
);
create table PARTITION_PAIR (
    ID BIGINT not null,
    _PARTITION_PAIR_ALGORITHM_FK BIGINT unique,
    PROTOCOL_APPLICATION_FK BIGINT,
    primary key (ID)
);
create table PERSON (
    ID BIGINT not null,
    LAST_NAME VARCHAR(255) BINARY,
    FIRST_NAME VARCHAR(255) BINARY,
    MID_INITIALS VARCHAR(255) BINARY,
    primary key (ID)
);
create table PROTOCOL (
    ID BIGINT not null,
    PROTOCOL_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table PROTOCOL_APPLICATION (
    ID BIGINT not null,
    ACTIVITY_DATE DATETIME,
    _PROTOCOL_DEVIATION_FK BIGINT unique,
    PROTOCOL_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table PROTOCOL_COLLECTION (
    ID BIGINT not null,
    primary key (ID)
);
create table REFERENCEABLE_COLLECTION (
    ID BIGINT not null,
    primary key (ID)
);
create table SECURITY (
    ID BIGINT not null,
    AUDIT_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table SECURITY_ACCESS (
    ID BIGINT not null,
    _ACCESS_GROUP_FK BIGINT not null,
    _ACCESS_RIGHT_FK BIGINT,
    SECURITY_FK BIGINT,
    primary key (ID)
);
create table SECURITY_GROUP (
    ID BIGINT not null,
    AUDIT_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table SEQUENCE (
    ID BIGINT not null,
    LENGTH INTEGER,
    IS_APPROXIMATE_LENGTH INTEGER,
    IS_CIRCULAR INTEGER,
    SEQUENCE INTEGER,
    START INTEGER,
    END INTEGER,
    _SEQUENCE_ANNOTATIONS_FK BIGINT,
    primary key (ID)
);
create table SEQUENCE_ANNOTATION (
    ID BIGINT not null,
    _SPECIES_FK BIGINT,
    _TYPE_FK BIGINT,
    _POLYMER_TYPE_FK BIGINT,
    CONCEPTUAL_MOLECULE_COLLECT_FK BIGINT,
    primary key (ID)
);
create table SOFTWARE (
    ID BIGINT not null,
    VERSION VARCHAR(255) BINARY,
    PROTOCOL_COLLECTION_FK BIGINT,
    primary key (ID)
);
create table SOFTWARE_APPLICATION (
    ID BIGINT not null,
    _APPLIED_SOFTWARE_FK BIGINT not null,
    PROTOCOL_APPLICATION_FK BIGINT,
    primary key (ID)
);
create table __AFFILIATIONS (
    PEOPLE_FK BIGINT not null,
    _AFFILIATIONS_FK BIGINT not null,
    primary key (PEOPLE_FK, _AFFILIATIONS_FK)
);
create table __ALL_PROTOCOL_APPLICATIONS (
    INVESTIGATION_COMPONENTS_FK BIGINT not null,
    _ALL_PROTOCOL_APPLICATIONS_FK BIGINT not null,
    primary key (INVESTIGATION_COMPONENTS_FK, _ALL_PROTOCOL_APPLICATIONS_FK)
);
create table __ANNOTATIONS (
    DESCRIBABLES_FK BIGINT not null,
    _ANNOTATIONS_FK BIGINT not null,
    primary key (DESCRIBABLES_FK, _ANNOTATIONS_FK)
);
create table __BIBLIOGRAPHIC_REFERENCES (
    IDENTIFIABLES_FK BIGINT not null,
    _BIBLIOGRAPHIC_REFERENCES_FK BIGINT not null,
    primary key (IDENTIFIABLES_FK, _BIBLIOGRAPHIC_REFERENCES_FK)
);
create table __CHARACTERISTICS (
    MATERIALS_FK BIGINT not null,
    _CHARACTERISTICS_FK BIGINT not null,
    primary key (MATERIALS_FK, _CHARACTERISTICS_FK)
);
create table __COMPONENT_DESIGN_TYPES (
    INVESTIGATION_COMPONENTS_FK BIGINT not null,
    _COMPONENT_DESIGN_TYPES_FK BIGINT not null,
    primary key (INVESTIGATION_COMPONENTS_FK, _COMPONENT_DESIGN_TYPES_FK)
);
create table __CONTENT (
    OBJECT_PROPERTIES_FK BIGINT not null,
    _CONTENT_FK BIGINT not null,
    primary key (OBJECT_PROPERTIES_FK, _CONTENT_FK)
);
create table __DATA_PARTITIONS (
    FACTOR_VALUES_FK BIGINT not null,
    _DATA_PARTITIONS_FK BIGINT not null,
    primary key (FACTOR_VALUES_FK, _DATA_PARTITIONS_FK)
);
create table __DIMENSION (
    DATAS_FK BIGINT not null,
    _DIMENSION_FK BIGINT not null,
    DATA__DIMENSION_IDX integer not null,
    primary key (DATAS_FK, DATA__DIMENSION_IDX)
);
create table __DIMENSION_ELEMENT_SET (
    DATA_PARTITIONS_FK BIGINT not null,
    _DIMENSION_ELEMENT_SET_FK BIGINT not null,
    primary key (DATA_PARTITIONS_FK, _DIMENSION_ELEMENT_SET_FK)
);
create table __FACTORS (
    INVESTIGATION_COMPONENTS_FK BIGINT not null,
    _FACTORS_FK BIGINT not null,
    primary key (INVESTIGATION_COMPONENTS_FK, _FACTORS_FK)
);
create table __GENERIC_EQUIPMENT (
    GENERIC_PROTOCOLS_FK BIGINT not null,
    _GENERIC_EQUIPMENT_FK BIGINT not null,
    primary key (GENERIC_PROTOCOLS_FK, _GENERIC_EQUIPMENT_FK)
);
create table __GENERIC_EQUIPMENT_PARTS (
    GENERIC_EQUIPMENTS_FK BIGINT not null,
    _GENERIC_EQUIPMENT_PARTS_FK BIGINT not null,
    primary key (GENERIC_EQUIPMENTS_FK, _GENERIC_EQUIPMENT_PARTS_FK)
);
create table __GENERIC_INPUT_DATA (
    GENERIC_PROTOCOL_APPLICATIO_FK BIGINT not null,
    _GENERIC_INPUT_DATA_FK BIGINT not null,
    primary key (GENERIC_PROTOCOL_APPLICATIO_FK, _GENERIC_INPUT_DATA_FK)
);
create table __GENERIC_SOFTWARE (
    GENERIC_PROTOCOLS_FK BIGINT not null,
    _GENERIC_SOFTWARE_FK BIGINT not null,
    primary key (GENERIC_PROTOCOLS_FK, _GENERIC_SOFTWARE_FK)
);
create table __INPUT_PARTITIONS (
    PARTITION_PAIRS_FK BIGINT not null,
    _INPUT_PARTITIONS_FK BIGINT not null,
    primary key (PARTITION_PAIRS_FK, _INPUT_PARTITIONS_FK)
);
create table __INVESTIGATION_TYPES (
    INVESTIGATIONS_FK BIGINT not null,
    _INVESTIGATION_TYPES_FK BIGINT not null,
    primary key (INVESTIGATIONS_FK, _INVESTIGATION_TYPES_FK)
);
create table __MEMBERS (
    SECURITY_GROUPS_FK BIGINT not null,
    _MEMBERS_FK BIGINT not null,
    primary key (SECURITY_GROUPS_FK, _MEMBERS_FK)
);
create table __OUTPUT_PARTITIONS (
    PARTITION_PAIRS_FK BIGINT not null,
    _OUTPUT_PARTITIONS_FK BIGINT not null,
    primary key (PARTITION_PAIRS_FK, _OUTPUT_PARTITIONS_FK)
);
create table __OWNER (
    SECURITIES_FK BIGINT not null,
    _OWNER_FK BIGINT not null,
    primary key (SECURITIES_FK, _OWNER_FK)
);
create table __PARAMETERIZABLE_TYPES (
    PARAMETERIZABLES_FK BIGINT not null,
    _PARAMETERIZABLE_TYPES_FK BIGINT not null,
    primary key (PARAMETERIZABLES_FK, _PARAMETERIZABLE_TYPES_FK)
);
create table __PROPERTIES (
    ONTOLOGY_INDIVIDUALS_FK BIGINT not null,
    _PROPERTIES_FK BIGINT not null,
    primary key (ONTOLOGY_INDIVIDUALS_FK, _PROPERTIES_FK)
);
create table __PROTOCOL_INPUT_TYPES (
    PROTOCOLS_FK BIGINT not null,
    _INPUT_TYPES_FK BIGINT not null,
    primary key (PROTOCOLS_FK, _INPUT_TYPES_FK)
);
create table __PROTOCOL_OUTPUT_TYPES (
    PROTOCOLS_FK BIGINT not null,
    _OUTPUT_TYPES_FK BIGINT not null,
    primary key (PROTOCOLS_FK, _OUTPUT_TYPES_FK)
);
create table __QUALITY_CONTROL_STATISTICS (
    MATERIALS_FK BIGINT not null,
    _QUALITY_CONTROL_STATISTICS_FK BIGINT not null,
    primary key (MATERIALS_FK, _QUALITY_CONTROL_STATISTICS_FK)
);
create table __SOFTWARE2_EQUIPMENT (
    _SOFTWARES_FK BIGINT not null,
    _EQUIPMENT_FK BIGINT not null,
    primary key (_EQUIPMENT_FK, _SOFTWARES_FK)
);
create table __SOURCE_MATERIALS (
    INVESTIGATIONS_FK BIGINT not null,
    _SOURCE_MATERIALS_FK BIGINT not null,
    primary key (INVESTIGATIONS_FK, _SOURCE_MATERIALS_FK)
);
create table __SUMMARY_RESULTS (
    INVESTIGATIONS_FK BIGINT not null,
    _SUMMARY_RESULTS_FK BIGINT not null,
    primary key (INVESTIGATIONS_FK, _SUMMARY_RESULTS_FK)
);
create table __SUPPORTING_DATA (
    HIGHER_LEVEL_ANALYSES_FK BIGINT not null,
    _SUPPORTING_DATA_FK BIGINT not null,
    primary key (HIGHER_LEVEL_ANALYSES_FK, _SUPPORTING_DATA_FK)
);
alter table ACTION 
    add index ACTIONIFKC (ID), 
    add constraint ACTIONIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table ACTION_APPLICATION 
    add index ACTION_APPLICATION__ACTION_DEC (_ACTION_DEVIATION_FK), 
    add constraint ACTION_APPLICATION__ACTION_DEC 
    foreign key (_ACTION_DEVIATION_FK) 
    references DESCRIPTION (ID);
alter table ACTION_APPLICATION 
    add index ACTION_APPLICATION__ACTION_FKC (_ACTION_FK), 
    add constraint ACTION_APPLICATION__ACTION_FKC 
    foreign key (_ACTION_FK) 
    references ACTION (ID);
alter table ACTION_APPLICATION 
    add index ACTION_APPLICATIONIFKC (ID), 
    add constraint ACTION_APPLICATIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table ACTION_APPLICATION 
    add index ACTION_APPLICATION_PROTOCOL_AC (PROTOCOL_APPLICATION_FK), 
    add constraint ACTION_APPLICATION_PROTOCOL_AC 
    foreign key (PROTOCOL_APPLICATION_FK) 
    references PROTOCOL_APPLICATION (ID);
alter table ACTION_APPLICATION 
    add index ACTION_APPLICATION__PROTOCOL_C (_PROTOCOL_APPLICATION_REFER_FK), 
    add constraint ACTION_APPLICATION__PROTOCOL_C 
    foreign key (_PROTOCOL_APPLICATION_REFER_FK) 
    references PROTOCOL_APPLICATION (ID);
alter table AUDIT 
    add index AUDIT_DESCRIBABLE_FKC (DESCRIBABLE_FK), 
    add constraint AUDIT_DESCRIBABLE_FKC 
    foreign key (DESCRIBABLE_FK) 
    references DESCRIBABLE (ID);
alter table AUDIT 
    add index AUDITIFKC (ID), 
    add constraint AUDITIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table AUDIT 
    add index AUDIT__PERFORMER_FKC (_PERFORMER_FK), 
    add constraint AUDIT__PERFORMER_FKC 
    foreign key (_PERFORMER_FK) 
    references CONTACT (ID);
alter table AUDIT_COLLECTION 
    add index AUDIT_COLLECTIONIFKC (ID), 
    add constraint AUDIT_COLLECTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table BIBLIOGRAPHIC_REFERENCE 
    add index BIBLIOGRAPHIC_REFERENCEIFKC (ID), 
    add constraint BIBLIOGRAPHIC_REFERENCEIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table BIBLIOGRAPHIC_REFERENCE 
    add index BIBLIOGRAPHIC_REFERENCE_REFERC (REFERENCEABLE_COLLECTION_FK), 
    add constraint BIBLIOGRAPHIC_REFERENCE_REFERC 
    foreign key (REFERENCEABLE_COLLECTION_FK) 
    references REFERENCEABLE_COLLECTION (ID);
alter table CONCEPTUAL_MOLECULE 
    add index CONCEPTUAL_MOLECULEIFKC (ID), 
    add constraint CONCEPTUAL_MOLECULEIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table CONCEPTUAL_MOLECULE 
    add index CONCEPTUAL_MOLECULE_CONCEPTUAC (CONCEPTUAL_MOLECULE_COLLECT_FK), 
    add constraint CONCEPTUAL_MOLECULE_CONCEPTUAC 
    foreign key (CONCEPTUAL_MOLECULE_COLLECT_FK) 
    references CONCEPTUAL_MOLECULE_COLLECTION (ID);
alter table CONCEPTUAL_MOLECULE_COLLECTION 
    add index CONCEPTUAL_MOLECULE_COLLECTIONIFKC (ID), 
    add constraint CONCEPTUAL_MOLECULE_COLLECTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table CONTACT 
    add index CONTACTIFKC (ID), 
    add constraint CONTACTIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table CONTACT 
    add index CONTACT_AUDIT_COLLECTION_FKC (AUDIT_COLLECTION_FK), 
    add constraint CONTACT_AUDIT_COLLECTION_FKC 
    foreign key (AUDIT_COLLECTION_FK) 
    references AUDIT_COLLECTION (ID);
alter table CONTACT_ROLE 
    add index CONTACT_ROLE_INVESTIGATION_FKC (INVESTIGATION_FK), 
    add constraint CONTACT_ROLE_INVESTIGATION_FKC 
    foreign key (INVESTIGATION_FK) 
    references INVESTIGATION (ID);
alter table CONTACT_ROLE 
    add index CONTACT_ROLE__ROLE_FKC (_ROLE_FK), 
    add constraint CONTACT_ROLE__ROLE_FKC 
    foreign key (_ROLE_FK) 
    references ONTOLOGY_TERM (ID);
alter table CONTACT_ROLE 
    add index CONTACT_ROLE__CONTACT_FKC (_CONTACT_FK), 
    add constraint CONTACT_ROLE__CONTACT_FKC 
    foreign key (_CONTACT_FK) 
    references CONTACT (ID);
alter table CONTACT_ROLE 
    add index CONTACT_ROLEIFKC (ID), 
    add constraint CONTACT_ROLEIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table CONTACT_ROLE 
    add index CONTACT_ROLE_PROTOCOL_APPLICAC (PROTOCOL_APPLICATION_FK), 
    add constraint CONTACT_ROLE_PROTOCOL_APPLICAC 
    foreign key (PROTOCOL_APPLICATION_FK) 
    references PROTOCOL_APPLICATION (ID);
alter table CONTACT_ROLE 
    add index CONTACT_ROLE_MATERIAL_FKC (MATERIAL_FK), 
    add constraint CONTACT_ROLE_MATERIAL_FKC 
    foreign key (MATERIAL_FK) 
    references MATERIAL (ID);
alter table CONTACT_ROLE 
    add index CONTACT_ROLE_DATABASE_FKC (DATABASE_FK), 
    add constraint CONTACT_ROLE_DATABASE_FKC 
    foreign key (DATABASE_FK) 
    references DATABASE_safe (ID);
alter table CONTACT_ROLE 
    add index CONTACT_ROLE_PARAMETERIZABLE_C (PARAMETERIZABLE_FK), 
    add constraint CONTACT_ROLE_PARAMETERIZABLE_C 
    foreign key (PARAMETERIZABLE_FK) 
    references PARAMETERIZABLE (ID);
alter table DATA 
    add index DATAIFKC (ID), 
    add constraint DATAIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table DATA 
    add index DATA_DATA_COLLECTION_FKC (DATA_COLLECTION_FK), 
    add constraint DATA_DATA_COLLECTION_FKC 
    foreign key (DATA_COLLECTION_FK) 
    references DATA_COLLECTION (ID);
alter table DATA 
    add index GPA_OUTDATA_FKC (GENERIC_PROTOCOL_APPLICATIO_FK), 
    add constraint GPA_OUTDATA_FKC 
    foreign key (GENERIC_PROTOCOL_APPLICATIO_FK) 
    references GENERIC_PROTOCOL_APPLICATION (ID);
alter table DATABASE_ENTRY 
    add index DATABASE_ENTRYIFKC (ID), 
    add constraint DATABASE_ENTRYIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table DATABASE_ENTRY 
    add index DATABASE_ENTRY_IDENTIFIABLE_FC (IDENTIFIABLE_FK), 
    add constraint DATABASE_ENTRY_IDENTIFIABLE_FC 
    foreign key (IDENTIFIABLE_FK) 
    references IDENTIFIABLE (ID);
alter table DATABASE_ENTRY 
    add index DATABASE_ENTRY__DATABASE_FKC (_DATABASE_FK), 
    add constraint DATABASE_ENTRY__DATABASE_FKC 
    foreign key (_DATABASE_FK) 
    references DATABASE_safe (ID);
alter table DATABASE_safe 
    add index DATABASEIFKC (ID), 
    add constraint DATABASEIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table DATABASE_safe 
    add index DATABASE_REFERENCEABLE_COLLECC (REFERENCEABLE_COLLECTION_FK), 
    add constraint DATABASE_REFERENCEABLE_COLLECC 
    foreign key (REFERENCEABLE_COLLECTION_FK) 
    references REFERENCEABLE_COLLECTION (ID);
alter table DATA_COLLECTION 
    add index DATA_COLLECTIONIFKC (ID), 
    add constraint DATA_COLLECTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table DATA_PARTITION 
    add index DATA_PARTITIONIFKC (ID), 
    add constraint DATA_PARTITIONIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table DATA_PARTITION 
    add index DATA_PARTITION_DATA_COLLECTIOC (DATA_COLLECTION_FK), 
    add constraint DATA_PARTITION_DATA_COLLECTIOC 
    foreign key (DATA_COLLECTION_FK) 
    references DATA_COLLECTION (ID);
alter table DATA_PARTITION 
    add index DATA_PARTITION__PARTITIONED_DC (_PARTITIONED_DATA_FK), 
    add constraint DATA_PARTITION__PARTITIONED_DC 
    foreign key (_PARTITIONED_DATA_FK) 
    references DATA (ID);
alter table DATA_PROPERTY 
    add index DATA_PROPERTYIFKC (ID), 
    add constraint DATA_PROPERTYIFKC 
    foreign key (ID) 
    references ONTOLOGY_PROPERTY (ID);
alter table DESCRIBABLE 
    add index DESCRIBABLE__SECURITY_FKC (_SECURITY_FK), 
    add constraint DESCRIBABLE__SECURITY_FKC 
    foreign key (_SECURITY_FK) 
    references SECURITY (ID);
alter table DESCRIBABLE 
    add index DESCRIBABLE__URI_FKC (_URI_FK), 
    add constraint DESCRIBABLE__URI_FKC 
    foreign key (_URI_FK) 
    references EXTERNAL_U_R_I (ID);
alter table DESCRIPTION 
    add index DESCRIPTION_DESCRIBABLE_FKC (DESCRIBABLE_FK), 
    add constraint DESCRIPTION_DESCRIBABLE_FKC 
    foreign key (DESCRIBABLE_FK) 
    references DESCRIBABLE (ID);
alter table DESCRIPTION 
    add index DESCRIPTIONIFKC (ID), 
    add constraint DESCRIPTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table DIMENSION 
    add index DIMENSIONIFKC (ID), 
    add constraint DIMENSIONIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table DIMENSION 
    add index DIMENSION_DATA_COLLECTION_FKC (DATA_COLLECTION_FK), 
    add constraint DIMENSION_DATA_COLLECTION_FKC 
    foreign key (DATA_COLLECTION_FK) 
    references DATA_COLLECTION (ID);
alter table DIMENSION 
    add index DIMENSION__DIMENSION_TYPE_FKC (_DIMENSION_TYPE_FK), 
    add constraint DIMENSION__DIMENSION_TYPE_FKC 
    foreign key (_DIMENSION_TYPE_FK) 
    references ONTOLOGY_TERM (ID);
alter table DIMENSION_ELEMENT 
    add index DIMENSION_ELEMENTIFKC (ID), 
    add constraint DIMENSION_ELEMENTIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table EQUIPMENT 
    add index EQUIPMENTIFKC (ID), 
    add constraint EQUIPMENTIFKC 
    foreign key (ID) 
    references PARAMETERIZABLE (ID);
alter table EQUIPMENT 
    add index EQUIPMENT_PROTOCOL_COLLECTIONC (PROTOCOL_COLLECTION_FK), 
    add constraint EQUIPMENT_PROTOCOL_COLLECTIONC 
    foreign key (PROTOCOL_COLLECTION_FK) 
    references PROTOCOL_COLLECTION (ID);
alter table EQUIPMENT 
    add index EQUIPMENT__MAKE_FKC (_MAKE_FK), 
    add constraint EQUIPMENT__MAKE_FKC 
    foreign key (_MAKE_FK) 
    references ONTOLOGY_TERM (ID);
alter table EQUIPMENT 
    add index EQUIPMENT__MODEL_FKC (_MODEL_FK), 
    add constraint EQUIPMENT__MODEL_FKC 
    foreign key (_MODEL_FK) 
    references ONTOLOGY_TERM (ID);
alter table EQUIPMENT_APPLICATION 
    add index EQUIPMENT_APPLICATIONIFKC (ID), 
    add constraint EQUIPMENT_APPLICATIONIFKC 
    foreign key (ID) 
    references PARAMETERIZABLE_APPLICATION (ID);
alter table EQUIPMENT_APPLICATION 
    add index EQUIPMENT_APPLICATION_PROTOCOC (PROTOCOL_APPLICATION_FK), 
    add constraint EQUIPMENT_APPLICATION_PROTOCOC 
    foreign key (PROTOCOL_APPLICATION_FK) 
    references PROTOCOL_APPLICATION (ID);
alter table EQUIPMENT_APPLICATION 
    add index EQUIPMENT_APPLICATION__APPLIEC (_APPLIED_EQUIPMENT_FK), 
    add constraint EQUIPMENT_APPLICATION__APPLIEC 
    foreign key (_APPLIED_EQUIPMENT_FK) 
    references EQUIPMENT (ID);
alter table EXTERNAL_DATA 
    add index EXTERNAL_DATA__EXTERNAL_FORMAC (_EXTERNAL_FORMAT_DOCUMENTAT_FK), 
    add constraint EXTERNAL_DATA__EXTERNAL_FORMAC 
    foreign key (_EXTERNAL_FORMAT_DOCUMENTAT_FK) 
    references EXTERNAL_U_R_I (ID);
alter table EXTERNAL_DATA 
    add index EXTERNAL_DATAIFKC (ID), 
    add constraint EXTERNAL_DATAIFKC 
    foreign key (ID) 
    references DATA (ID);
alter table EXTERNAL_DATA 
    add index EXTERNAL_DATA__FILE_FORMAT_FKC (_FILE_FORMAT_FK), 
    add constraint EXTERNAL_DATA__FILE_FORMAT_FKC 
    foreign key (_FILE_FORMAT_FK) 
    references ONTOLOGY_TERM (ID);
alter table EXTERNAL_U_R_I 
    add index EXTERNAL_U_R_IIFKC (ID), 
    add constraint EXTERNAL_U_R_IIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table FACTOR 
    add index FACTOR_INVESTIGATION_COLLECTIC (INVESTIGATION_COLLECTION_FK), 
    add constraint FACTOR_INVESTIGATION_COLLECTIC 
    foreign key (INVESTIGATION_COLLECTION_FK) 
    references INVESTIGATION_COLLECTION (ID);
alter table FACTOR 
    add index FACTOR__FACTOR_CATEGORY_FKC (_FACTOR_CATEGORY_FK), 
    add constraint FACTOR__FACTOR_CATEGORY_FKC 
    foreign key (_FACTOR_CATEGORY_FK) 
    references ONTOLOGY_TERM (ID);
alter table FACTOR 
    add index FACTORIFKC (ID), 
    add constraint FACTORIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table FACTOR_VALUE 
    add index FACTOR_VALUEIFKC (ID), 
    add constraint FACTOR_VALUEIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table FACTOR_VALUE 
    add index FACTOR_VALUE__VALUE_FKC (_VALUE_FK), 
    add constraint FACTOR_VALUE__VALUE_FKC 
    foreign key (_VALUE_FK) 
    references ONTOLOGY_TERM (ID);
alter table FACTOR_VALUE 
    add index FACTOR_VALUE_FACTOR_FKC (FACTOR_FK), 
    add constraint FACTOR_VALUE_FACTOR_FKC 
    foreign key (FACTOR_FK) 
    references FACTOR (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOT__AUDIT_COLLECTION_C (_AUDIT_COLLECTION_FK), 
    add constraint FU_G_EROOT__AUDIT_COLLECTION_C 
    foreign key (_AUDIT_COLLECTION_FK) 
    references AUDIT_COLLECTION (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOT__DATA_COLLECTION_FC (_DATA_COLLECTION_FK), 
    add constraint FU_G_EROOT__DATA_COLLECTION_FC 
    foreign key (_DATA_COLLECTION_FK) 
    references DATA_COLLECTION (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOT__CONCEPTUAL_MOLECUC (_CONCEPTUAL_MOLECULE_COLLEC_FK), 
    add constraint FU_G_EROOT__CONCEPTUAL_MOLECUC 
    foreign key (_CONCEPTUAL_MOLECULE_COLLEC_FK) 
    references CONCEPTUAL_MOLECULE_COLLECTION (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOT__ONTOLOGY_COLLECTIC (_ONTOLOGY_COLLECTION_FK), 
    add constraint FU_G_EROOT__ONTOLOGY_COLLECTIC 
    foreign key (_ONTOLOGY_COLLECTION_FK) 
    references ONTOLOGY_COLLECTION (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOTIFKC (ID), 
    add constraint FU_G_EROOTIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOT__REFERENCEABLE_COLC (_REFERENCEABLE_COLLECTION_FK), 
    add constraint FU_G_EROOT__REFERENCEABLE_COLC 
    foreign key (_REFERENCEABLE_COLLECTION_FK) 
    references REFERENCEABLE_COLLECTION (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOT__PROTOCOL_COLLECTIC (_PROTOCOL_COLLECTION_FK), 
    add constraint FU_G_EROOT__PROTOCOL_COLLECTIC 
    foreign key (_PROTOCOL_COLLECTION_FK) 
    references PROTOCOL_COLLECTION (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOT__MATERIAL_COLLECTIC (_MATERIAL_COLLECTION_FK), 
    add constraint FU_G_EROOT__MATERIAL_COLLECTIC 
    foreign key (_MATERIAL_COLLECTION_FK) 
    references MATERIAL_COLLECTION (ID);
alter table FU_G_EROOT 
    add index FU_G_EROOT__INVESTIGATION_COLC (_INVESTIGATION_COLLECTION_FK), 
    add constraint FU_G_EROOT__INVESTIGATION_COLC 
    foreign key (_INVESTIGATION_COLLECTION_FK) 
    references INVESTIGATION_COLLECTION (ID);
alter table GENERIC_ACTION 
    add index GENERIC_ACTIONIFKC (ID), 
    add constraint GENERIC_ACTIONIFKC 
    foreign key (ID) 
    references ACTION (ID);
alter table GENERIC_ACTION 
    add index GENERIC_ACTION_GENERIC_PROTOCC (GENERIC_PROTOCOL_FK), 
    add constraint GENERIC_ACTION_GENERIC_PROTOCC 
    foreign key (GENERIC_PROTOCOL_FK) 
    references GENERIC_PROTOCOL (ID);
alter table GENERIC_ACTION 
    add index GENERIC_ACTION__ACTION_TERM_FC (_ACTION_TERM_FK), 
    add constraint GENERIC_ACTION__ACTION_TERM_FC 
    foreign key (_ACTION_TERM_FK) 
    references ONTOLOGY_TERM (ID);
alter table GENERIC_ACTION 
    add index GENERIC_ACTION__GENERIC_PROTOC (_GENERIC_PROTOCOL_REFERENCE_FK), 
    add constraint GENERIC_ACTION__GENERIC_PROTOC 
    foreign key (_GENERIC_PROTOCOL_REFERENCE_FK) 
    references PROTOCOL (ID);
alter table GENERIC_EQUIPMENT 
    add index GENERIC_EQUIPMENTIFKC (ID), 
    add constraint GENERIC_EQUIPMENTIFKC 
    foreign key (ID) 
    references EQUIPMENT (ID);
alter table GENERIC_MATERIAL 
    add index GENERIC_MATERIALIFKC (ID), 
    add constraint GENERIC_MATERIALIFKC 
    foreign key (ID) 
    references MATERIAL (ID);
alter table GENERIC_MAT_MEAS 
    add index GENERIC_MAT_MEASIFKC (ID), 
    add constraint GENERIC_MAT_MEASIFKC 
    foreign key (ID) 
    references MATERIAL_MEASUREMENT (ID);
alter table GENERIC_MAT_MEAS 
    add index GENERIC_MAT_MEAS__GENERIC_MEAC (_GENERIC_MEASURE_MATERIAL_FK), 
    add constraint GENERIC_MAT_MEAS__GENERIC_MEAC 
    foreign key (_GENERIC_MEASURE_MATERIAL_FK) 
    references MATERIAL (ID);
alter table GENERIC_MAT_MEAS 
    add index GENERIC_MAT_MEAS_GENERIC_PROTC (GENERIC_PROTOCOL_APPLICATIO_FK), 
    add constraint GENERIC_MAT_MEAS_GENERIC_PROTC 
    foreign key (GENERIC_PROTOCOL_APPLICATIO_FK) 
    references GENERIC_PROTOCOL_APPLICATION (ID);
alter table GENERIC_PARAMETER 
    add index GENERIC_PARAMETER_GENERIC_EQUC (GENERIC_EQUIPMENT_FK), 
    add constraint GENERIC_PARAMETER_GENERIC_EQUC 
    foreign key (GENERIC_EQUIPMENT_FK) 
    references GENERIC_EQUIPMENT (ID);
alter table GENERIC_PARAMETER 
    add index GENERIC_PARAMETER_GENERIC_SOFC (GENERIC_SOFTWARE_FK), 
    add constraint GENERIC_PARAMETER_GENERIC_SOFC 
    foreign key (GENERIC_SOFTWARE_FK) 
    references GENERIC_SOFTWARE (ID);
alter table GENERIC_PARAMETER 
    add index GENERIC_PARAMETERIFKC (ID), 
    add constraint GENERIC_PARAMETERIFKC 
    foreign key (ID) 
    references PARAMETER (ID);
alter table GENERIC_PARAMETER 
    add index GENERIC_PARAMETER_GENERIC_PROC (GENERIC_PROTOCOL_FK), 
    add constraint GENERIC_PARAMETER_GENERIC_PROC 
    foreign key (GENERIC_PROTOCOL_FK) 
    references GENERIC_PROTOCOL (ID);
alter table GENERIC_PROTOCOL 
    add index GENERIC_PROTOCOLIFKC (ID), 
    add constraint GENERIC_PROTOCOLIFKC 
    foreign key (ID) 
    references PROTOCOL (ID);
alter table GENERIC_PROTOCOL_APPLICATION 
    add index GENERIC_PROTOCOL_APPLICATIONIFKC (ID), 
    add constraint GENERIC_PROTOCOL_APPLICATIONIFKC 
    foreign key (ID) 
    references PROTOCOL_APPLICATION (ID);
alter table GENERIC_PROTOCOL_APPLICATION 
    add index GENERIC_PROTOCOL_APPLICATION_C (_GENERIC_PROTOCOL_FK), 
    add constraint GENERIC_PROTOCOL_APPLICATION_C 
    foreign key (_GENERIC_PROTOCOL_FK) 
    references PROTOCOL (ID);
alter table GENERIC_SOFTWARE 
    add index GENERIC_SOFTWAREIFKC (ID), 
    add constraint GENERIC_SOFTWAREIFKC 
    foreign key (ID) 
    references SOFTWARE (ID);
alter table HIGHER_LEVEL_ANALYSIS 
    add index HIGHER_LEVEL_ANALYSISIFKC (ID), 
    add constraint HIGHER_LEVEL_ANALYSISIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table HIGHER_LEVEL_ANALYSIS 
    add index HIGHER_LEVEL_ANALYSIS_DATA_COC (DATA_COLLECTION_FK), 
    add constraint HIGHER_LEVEL_ANALYSIS_DATA_COC 
    foreign key (DATA_COLLECTION_FK) 
    references DATA_COLLECTION (ID);
alter table IDENTIFIABLE 
    add index IDENTIFIABLEIFKC (ID), 
    add constraint IDENTIFIABLEIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table IDENTIFICATION_SERVER 
    add index IDENTIFICATION_SERVER__DATABAC (_DATABASE_IDENTIFIER_FK), 
    add constraint IDENTIFICATION_SERVER__DATABAC 
    foreign key (_DATABASE_IDENTIFIER_FK) 
    references DESCRIBABLE (ID);
alter table INTERNAL_DATA 
    add index INTERNAL_DATAIFKC (ID), 
    add constraint INTERNAL_DATAIFKC 
    foreign key (ID) 
    references DATA (ID);
alter table INVESTIGATION 
    add index INVESTIGATION_INVESTIGATION_CC (INVESTIGATION_COLLECTION_FK), 
    add constraint INVESTIGATION_INVESTIGATION_CC 
    foreign key (INVESTIGATION_COLLECTION_FK) 
    references INVESTIGATION_COLLECTION (ID);
alter table INVESTIGATION 
    add index INVESTIGATIONIFKC (ID), 
    add constraint INVESTIGATIONIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table INVESTIGATION_COLLECTION 
    add index INVESTIGATION_COLLECTIONIFKC (ID), 
    add constraint INVESTIGATION_COLLECTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table INVESTIGATION_COMPONENT 
    add index INVESTIGATION_COMPONENT_INVESC (INVESTIGATION_FK), 
    add constraint INVESTIGATION_COMPONENT_INVESC 
    foreign key (INVESTIGATION_FK) 
    references INVESTIGATION (ID);
alter table INVESTIGATION_COMPONENT 
    add index INVESTIGATION_COMPONENT__NORMC (_NORMALIZATION_DESCRIPTION_FK), 
    add constraint INVESTIGATION_COMPONENT__NORMC 
    foreign key (_NORMALIZATION_DESCRIPTION_FK) 
    references DESCRIPTION (ID);
alter table INVESTIGATION_COMPONENT 
    add index INVESTIGATION_COMPONENTIFKC (ID), 
    add constraint INVESTIGATION_COMPONENTIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table INVESTIGATION_COMPONENT 
    add index INVESTIGATION_COMPONENT__REPLC (_REPLICATE_DESCRIPTION_FK), 
    add constraint INVESTIGATION_COMPONENT__REPLC 
    foreign key (_REPLICATE_DESCRIPTION_FK) 
    references DESCRIPTION (ID);
alter table INVESTIGATION_COMPONENT 
    add index INVESTIGATION_COMPONENT__QUALC (_QUALITY_CONTROL_DESCRIPTIO_FK), 
    add constraint INVESTIGATION_COMPONENT__QUALC 
    foreign key (_QUALITY_CONTROL_DESCRIPTIO_FK) 
    references DESCRIPTION (ID);
alter table MATERIAL 
    add index MATERIALIFKC (ID), 
    add constraint MATERIALIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table MATERIAL 
    add index MATERIAL_MATERIAL_COLLECTION_C (MATERIAL_COLLECTION_FK), 
    add constraint MATERIAL_MATERIAL_COLLECTION_C 
    foreign key (MATERIAL_COLLECTION_FK) 
    references MATERIAL_COLLECTION (ID);
alter table MATERIAL 
    add index MATERIAL__MATERIAL_TYPE_FKC (_MATERIAL_TYPE_FK), 
    add constraint MATERIAL__MATERIAL_TYPE_FKC 
    foreign key (_MATERIAL_TYPE_FK) 
    references ONTOLOGY_TERM (ID);
alter table MATERIAL 
    add index MATERIAL_GENERIC_PROTOCOL_APPC (GENERIC_PROTOCOL_APPLICATIO_FK), 
    add constraint MATERIAL_GENERIC_PROTOCOL_APPC 
    foreign key (GENERIC_PROTOCOL_APPLICATIO_FK) 
    references GENERIC_PROTOCOL_APPLICATION (ID);
alter table MATERIAL_COLLECTION 
    add index MATERIAL_COLLECTIONIFKC (ID), 
    add constraint MATERIAL_COLLECTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table MATERIAL_MEASUREMENT 
    add index MATERIAL_MEASUREMENTIFKC (ID), 
    add constraint MATERIAL_MEASUREMENTIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table MATERIAL_MEASUREMENT 
    add index MATERIAL_MEASUREMENT__MEASUREC (_MEASUREMENT_FK), 
    add constraint MATERIAL_MEASUREMENT__MEASUREC 
    foreign key (_MEASUREMENT_FK) 
    references ONTOLOGY_TERM (ID);
alter table NAME_VALUE_TYPE 
    add index NAME_VALUE_TYPE_DESCRIBABLE_FC (DESCRIBABLE_FK), 
    add constraint NAME_VALUE_TYPE_DESCRIBABLE_FC 
    foreign key (DESCRIBABLE_FK) 
    references DESCRIBABLE (ID);
alter table NAME_VALUE_TYPE 
    add index NAME_VALUE_TYPEIFKC (ID), 
    add constraint NAME_VALUE_TYPEIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table OBJECT_PROPERTY 
    add index OBJECT_PROPERTYIFKC (ID), 
    add constraint OBJECT_PROPERTYIFKC 
    foreign key (ID) 
    references ONTOLOGY_PROPERTY (ID);
alter table ONTOLOGY_COLLECTION 
    add index ONTOLOGY_COLLECTIONIFKC (ID), 
    add constraint ONTOLOGY_COLLECTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table ONTOLOGY_INDIVIDUAL 
    add index ONTOLOGY_INDIVIDUALIFKC (ID), 
    add constraint ONTOLOGY_INDIVIDUALIFKC 
    foreign key (ID) 
    references ONTOLOGY_TERM (ID);
alter table ONTOLOGY_PROPERTY 
    add index ONTOLOGY_PROPERTYIFKC (ID), 
    add constraint ONTOLOGY_PROPERTYIFKC 
    foreign key (ID) 
    references ONTOLOGY_TERM (ID);
alter table ONTOLOGY_TERM 
    add index ONTOLOGY_TERM_ONTOLOGY_COLLECC (ONTOLOGY_COLLECTION_FK), 
    add constraint ONTOLOGY_TERM_ONTOLOGY_COLLECC 
    foreign key (ONTOLOGY_COLLECTION_FK) 
    references ONTOLOGY_COLLECTION (ID);
alter table ONTOLOGY_TERM 
    add index ONTOLOGY_TERMIFKC (ID), 
    add constraint ONTOLOGY_TERMIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table ORGANIZATION 
    add index ORGANIZATIONIFKC (ID), 
    add constraint ORGANIZATIONIFKC 
    foreign key (ID) 
    references CONTACT (ID);
alter table ORGANIZATION 
    add index ORGANIZATION__PARENT_FKC (_PARENT_FK), 
    add constraint ORGANIZATION__PARENT_FKC 
    foreign key (_PARENT_FK) 
    references ORGANIZATION (ID);
alter table PARAMETER 
    add index PARAMETERIFKC (ID), 
    add constraint PARAMETERIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table PARAMETER 
    add index PARAMETER__DEFAULT_VALUE_FKC (_DEFAULT_VALUE_FK), 
    add constraint PARAMETER__DEFAULT_VALUE_FKC 
    foreign key (_DEFAULT_VALUE_FK) 
    references ONTOLOGY_TERM (ID);
alter table PARAMETER 
    add index PARAMETER__PARAMETER_TYPE_FKC (_PARAMETER_TYPE_FK), 
    add constraint PARAMETER__PARAMETER_TYPE_FKC 
    foreign key (_PARAMETER_TYPE_FK) 
    references ONTOLOGY_TERM (ID);
alter table PARAMETERIZABLE 
    add index PARAMETERIZABLEIFKC (ID), 
    add constraint PARAMETERIZABLEIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table PARAMETERIZABLE_APPLICATION 
    add index PARAMETERIZABLE_APPLICATIONIFKC (ID), 
    add constraint PARAMETERIZABLE_APPLICATIONIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table PARAMETER_VALUE 
    add index PARAMETER_VALUE_PARAMETERIZABC (PARAMETERIZABLE_APPLICATION_FK), 
    add constraint PARAMETER_VALUE_PARAMETERIZABC 
    foreign key (PARAMETERIZABLE_APPLICATION_FK) 
    references PARAMETERIZABLE_APPLICATION (ID);
alter table PARAMETER_VALUE 
    add index PARAMETER_VALUE__PARAMETER_FKC (_PARAMETER_FK), 
    add constraint PARAMETER_VALUE__PARAMETER_FKC 
    foreign key (_PARAMETER_FK) 
    references PARAMETER (ID);
alter table PARAMETER_VALUE 
    add index PARAMETER_VALUEIFKC (ID), 
    add constraint PARAMETER_VALUEIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table PARAMETER_VALUE 
    add index PARAMETER_VALUE__PARAMETER_VAC (_PARAMETER_VALUE_FK), 
    add constraint PARAMETER_VALUE__PARAMETER_VAC 
    foreign key (_PARAMETER_VALUE_FK) 
    references ONTOLOGY_TERM (ID);
alter table PARTITION_PAIR 
    add index PARTITION_PAIR__PARTITION_PAIC (_PARTITION_PAIR_ALGORITHM_FK), 
    add constraint PARTITION_PAIR__PARTITION_PAIC 
    foreign key (_PARTITION_PAIR_ALGORITHM_FK) 
    references DESCRIPTION (ID);
alter table PARTITION_PAIR 
    add index PARTITION_PAIRIFKC (ID), 
    add constraint PARTITION_PAIRIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table PARTITION_PAIR 
    add index PARTITION_PAIR_PROTOCOL_APPLIC (PROTOCOL_APPLICATION_FK), 
    add constraint PARTITION_PAIR_PROTOCOL_APPLIC 
    foreign key (PROTOCOL_APPLICATION_FK) 
    references PROTOCOL_APPLICATION (ID);
alter table PERSON 
    add index PERSONIFKC (ID), 
    add constraint PERSONIFKC 
    foreign key (ID) 
    references CONTACT (ID);
alter table PROTOCOL 
    add index PROTOCOLIFKC (ID), 
    add constraint PROTOCOLIFKC 
    foreign key (ID) 
    references PARAMETERIZABLE (ID);
alter table PROTOCOL 
    add index PROTOCOL_PROTOCOL_COLLECTION_C (PROTOCOL_COLLECTION_FK), 
    add constraint PROTOCOL_PROTOCOL_COLLECTION_C 
    foreign key (PROTOCOL_COLLECTION_FK) 
    references PROTOCOL_COLLECTION (ID);
alter table PROTOCOL_APPLICATION 
    add index PROTOCOL_APPLICATION__PROTOCOC (_PROTOCOL_DEVIATION_FK), 
    add constraint PROTOCOL_APPLICATION__PROTOCOC 
    foreign key (_PROTOCOL_DEVIATION_FK) 
    references DESCRIPTION (ID);
alter table PROTOCOL_APPLICATION 
    add index PROTOCOL_APPLICATIONIFKC (ID), 
    add constraint PROTOCOL_APPLICATIONIFKC 
    foreign key (ID) 
    references PARAMETERIZABLE_APPLICATION (ID);
alter table PROTOCOL_APPLICATION 
    add index PROTOCOL_APPLICATION_PROTOCOLC (PROTOCOL_COLLECTION_FK), 
    add constraint PROTOCOL_APPLICATION_PROTOCOLC 
    foreign key (PROTOCOL_COLLECTION_FK) 
    references PROTOCOL_COLLECTION (ID);
alter table PROTOCOL_COLLECTION 
    add index PROTOCOL_COLLECTIONIFKC (ID), 
    add constraint PROTOCOL_COLLECTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table REFERENCEABLE_COLLECTION 
    add index REFERENCEABLE_COLLECTIONIFKC (ID), 
    add constraint REFERENCEABLE_COLLECTIONIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table SECURITY 
    add index SECURITYIFKC (ID), 
    add constraint SECURITYIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table SECURITY 
    add index SECURITY_AUDIT_COLLECTION_FKC (AUDIT_COLLECTION_FK), 
    add constraint SECURITY_AUDIT_COLLECTION_FKC 
    foreign key (AUDIT_COLLECTION_FK) 
    references AUDIT_COLLECTION (ID);
alter table SECURITY_ACCESS 
    add index SECURITY_ACCESS_SECURITY_FKC (SECURITY_FK), 
    add constraint SECURITY_ACCESS_SECURITY_FKC 
    foreign key (SECURITY_FK) 
    references SECURITY (ID);
alter table SECURITY_ACCESS 
    add index SECURITY_ACCESSIFKC (ID), 
    add constraint SECURITY_ACCESSIFKC 
    foreign key (ID) 
    references DESCRIBABLE (ID);
alter table SECURITY_ACCESS 
    add index SECURITY_ACCESS__ACCESS_RIGHTC (_ACCESS_RIGHT_FK), 
    add constraint SECURITY_ACCESS__ACCESS_RIGHTC 
    foreign key (_ACCESS_RIGHT_FK) 
    references ONTOLOGY_TERM (ID);
alter table SECURITY_ACCESS 
    add index SECURITY_ACCESS__ACCESS_GROUPC (_ACCESS_GROUP_FK), 
    add constraint SECURITY_ACCESS__ACCESS_GROUPC 
    foreign key (_ACCESS_GROUP_FK) 
    references SECURITY_GROUP (ID);
alter table SECURITY_GROUP 
    add index SECURITY_GROUPIFKC (ID), 
    add constraint SECURITY_GROUPIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table SECURITY_GROUP 
    add index SECURITY_GROUP_AUDIT_COLLECTIC (AUDIT_COLLECTION_FK), 
    add constraint SECURITY_GROUP_AUDIT_COLLECTIC 
    foreign key (AUDIT_COLLECTION_FK) 
    references AUDIT_COLLECTION (ID);
alter table SEQUENCE 
    add index SEQUENCEIFKC (ID), 
    add constraint SEQUENCEIFKC 
    foreign key (ID) 
    references CONCEPTUAL_MOLECULE (ID);
alter table SEQUENCE 
    add index SEQUENCE__SEQUENCE_ANNOTATIONC (_SEQUENCE_ANNOTATIONS_FK), 
    add constraint SEQUENCE__SEQUENCE_ANNOTATIONC 
    foreign key (_SEQUENCE_ANNOTATIONS_FK) 
    references SEQUENCE_ANNOTATION (ID);
alter table SEQUENCE_ANNOTATION 
    add index SEQUENCE_ANNOTATION__POLYMER_C (_POLYMER_TYPE_FK), 
    add constraint SEQUENCE_ANNOTATION__POLYMER_C 
    foreign key (_POLYMER_TYPE_FK) 
    references ONTOLOGY_TERM (ID);
alter table SEQUENCE_ANNOTATION 
    add index SEQUENCE_ANNOTATION__TYPE_FKC (_TYPE_FK), 
    add constraint SEQUENCE_ANNOTATION__TYPE_FKC 
    foreign key (_TYPE_FK) 
    references ONTOLOGY_TERM (ID);
alter table SEQUENCE_ANNOTATION 
    add index SEQUENCE_ANNOTATIONIFKC (ID), 
    add constraint SEQUENCE_ANNOTATIONIFKC 
    foreign key (ID) 
    references IDENTIFIABLE (ID);
alter table SEQUENCE_ANNOTATION 
    add index SEQUENCE_ANNOTATION__SPECIES_C (_SPECIES_FK), 
    add constraint SEQUENCE_ANNOTATION__SPECIES_C 
    foreign key (_SPECIES_FK) 
    references ONTOLOGY_TERM (ID);
alter table SEQUENCE_ANNOTATION 
    add index SEQUENCE_ANNOTATION_CONCEPTUAC (CONCEPTUAL_MOLECULE_COLLECT_FK), 
    add constraint SEQUENCE_ANNOTATION_CONCEPTUAC 
    foreign key (CONCEPTUAL_MOLECULE_COLLECT_FK) 
    references CONCEPTUAL_MOLECULE_COLLECTION (ID);
alter table SOFTWARE 
    add index SOFTWAREIFKC (ID), 
    add constraint SOFTWAREIFKC 
    foreign key (ID) 
    references PARAMETERIZABLE (ID);
alter table SOFTWARE 
    add index SOFTWARE_PROTOCOL_COLLECTION_C (PROTOCOL_COLLECTION_FK), 
    add constraint SOFTWARE_PROTOCOL_COLLECTION_C 
    foreign key (PROTOCOL_COLLECTION_FK) 
    references PROTOCOL_COLLECTION (ID);
alter table SOFTWARE_APPLICATION 
    add index SOFTWARE_APPLICATIONIFKC (ID), 
    add constraint SOFTWARE_APPLICATIONIFKC 
    foreign key (ID) 
    references PARAMETERIZABLE_APPLICATION (ID);
alter table SOFTWARE_APPLICATION 
    add index SOFTWARE_APPLICATION_PROTOCOLC (PROTOCOL_APPLICATION_FK), 
    add constraint SOFTWARE_APPLICATION_PROTOCOLC 
    foreign key (PROTOCOL_APPLICATION_FK) 
    references PROTOCOL_APPLICATION (ID);
alter table SOFTWARE_APPLICATION 
    add index SOFTWARE_APPLICATION__APPLIEDC (_APPLIED_SOFTWARE_FK), 
    add constraint SOFTWARE_APPLICATION__APPLIEDC 
    foreign key (_APPLIED_SOFTWARE_FK) 
    references SOFTWARE (ID);
alter table __AFFILIATIONS 
    add index ORGANIZATION_PEOPLE_FKC (PEOPLE_FK), 
    add constraint ORGANIZATION_PEOPLE_FKC 
    foreign key (PEOPLE_FK) 
    references PERSON (ID);
alter table __AFFILIATIONS 
    add index PERSON__AFFILIATIONS_FKC (_AFFILIATIONS_FK), 
    add constraint PERSON__AFFILIATIONS_FKC 
    foreign key (_AFFILIATIONS_FK) 
    references ORGANIZATION (ID);
alter table __ALL_PROTOCOL_APPLICATIONS 
    add index INVESTIGATION_COMPONENT__ALL_C (_ALL_PROTOCOL_APPLICATIONS_FK), 
    add constraint INVESTIGATION_COMPONENT__ALL_C 
    foreign key (_ALL_PROTOCOL_APPLICATIONS_FK) 
    references PROTOCOL_APPLICATION (ID);
alter table __ALL_PROTOCOL_APPLICATIONS 
    add index PROTOCOL_APPLICATION_INVESTIGC (INVESTIGATION_COMPONENTS_FK), 
    add constraint PROTOCOL_APPLICATION_INVESTIGC 
    foreign key (INVESTIGATION_COMPONENTS_FK) 
    references INVESTIGATION_COMPONENT (ID);
alter table __ANNOTATIONS 
    add index DESCRIBABLE__ANNOTATIONS_FKC (_ANNOTATIONS_FK), 
    add constraint DESCRIBABLE__ANNOTATIONS_FKC 
    foreign key (_ANNOTATIONS_FK) 
    references ONTOLOGY_TERM (ID);
alter table __ANNOTATIONS 
    add index ONTOLOGY_TERM_DESCRIBABLES_FKC (DESCRIBABLES_FK), 
    add constraint ONTOLOGY_TERM_DESCRIBABLES_FKC 
    foreign key (DESCRIBABLES_FK) 
    references DESCRIBABLE (ID);
alter table __BIBLIOGRAPHIC_REFERENCES 
    add index IDENTIFIABLE__BIBLIOGRAPHIC_RC (_BIBLIOGRAPHIC_REFERENCES_FK), 
    add constraint IDENTIFIABLE__BIBLIOGRAPHIC_RC 
    foreign key (_BIBLIOGRAPHIC_REFERENCES_FK) 
    references BIBLIOGRAPHIC_REFERENCE (ID);
alter table __BIBLIOGRAPHIC_REFERENCES 
    add index BIBLIOGRAPHIC_REFERENCE_IDENTC (IDENTIFIABLES_FK), 
    add constraint BIBLIOGRAPHIC_REFERENCE_IDENTC 
    foreign key (IDENTIFIABLES_FK) 
    references IDENTIFIABLE (ID);
alter table __CHARACTERISTICS 
    add index MAT_CHAR_FKC (MATERIALS_FK), 
    add constraint MAT_CHAR_FKC 
    foreign key (MATERIALS_FK) 
    references MATERIAL (ID);
alter table __CHARACTERISTICS 
    add index MATERIAL__CHARACTERISTICS_FKC (_CHARACTERISTICS_FK), 
    add constraint MATERIAL__CHARACTERISTICS_FKC 
    foreign key (_CHARACTERISTICS_FK) 
    references ONTOLOGY_TERM (ID);
alter table __COMPONENT_DESIGN_TYPES 
    add index INVESTIGATION_COMPONENT__COMPC (_COMPONENT_DESIGN_TYPES_FK), 
    add constraint INVESTIGATION_COMPONENT__COMPC 
    foreign key (_COMPONENT_DESIGN_TYPES_FK) 
    references ONTOLOGY_TERM (ID);
alter table __COMPONENT_DESIGN_TYPES 
    add index ONTOLOGY_TERM_INVESTIGATION_CC (INVESTIGATION_COMPONENTS_FK), 
    add constraint ONTOLOGY_TERM_INVESTIGATION_CC 
    foreign key (INVESTIGATION_COMPONENTS_FK) 
    references INVESTIGATION_COMPONENT (ID);
alter table __CONTENT 
    add index OBJECT_PROPERTY__CONTENT_FKC (_CONTENT_FK), 
    add constraint OBJECT_PROPERTY__CONTENT_FKC 
    foreign key (_CONTENT_FK) 
    references ONTOLOGY_INDIVIDUAL (ID);
alter table __CONTENT 
    add index ONTOLOGY_INDIVIDUAL_OBJECT_PRC (OBJECT_PROPERTIES_FK), 
    add constraint ONTOLOGY_INDIVIDUAL_OBJECT_PRC 
    foreign key (OBJECT_PROPERTIES_FK) 
    references OBJECT_PROPERTY (ID);
alter table __DATA_PARTITIONS 
    add index FACTOR_VALUE__DATA_PARTITIONSC (_DATA_PARTITIONS_FK), 
    add constraint FACTOR_VALUE__DATA_PARTITIONSC 
    foreign key (_DATA_PARTITIONS_FK) 
    references DATA_PARTITION (ID);
alter table __DATA_PARTITIONS 
    add index DATA_PARTITION_FACTOR_VALUES_C (FACTOR_VALUES_FK), 
    add constraint DATA_PARTITION_FACTOR_VALUES_C 
    foreign key (FACTOR_VALUES_FK) 
    references FACTOR_VALUE (ID);
alter table __DIMENSION 
    add index DATA__DIMENSION_FKC (_DIMENSION_FK), 
    add constraint DATA__DIMENSION_FKC 
    foreign key (_DIMENSION_FK) 
    references DIMENSION (ID);
alter table __DIMENSION 
    add index DIMENSION_DATAS_FKC (DATAS_FK), 
    add constraint DIMENSION_DATAS_FKC 
    foreign key (DATAS_FK) 
    references DATA (ID);
alter table __DIMENSION_ELEMENT_SET 
    add index DATA_PARTITION__DIMENSION_ELEC (_DIMENSION_ELEMENT_SET_FK), 
    add constraint DATA_PARTITION__DIMENSION_ELEC 
    foreign key (_DIMENSION_ELEMENT_SET_FK) 
    references DIMENSION_ELEMENT (ID);
alter table __DIMENSION_ELEMENT_SET 
    add index DIMENSION_ELEMENT_DATA_PARTITC (DATA_PARTITIONS_FK), 
    add constraint DIMENSION_ELEMENT_DATA_PARTITC 
    foreign key (DATA_PARTITIONS_FK) 
    references DATA_PARTITION (ID);
alter table __FACTORS 
    add index INVESTIGATION_COMPONENT__FACTC (_FACTORS_FK), 
    add constraint INVESTIGATION_COMPONENT__FACTC 
    foreign key (_FACTORS_FK) 
    references FACTOR (ID);
alter table __FACTORS 
    add index FACTOR_INVESTIGATION_COMPONENC (INVESTIGATION_COMPONENTS_FK), 
    add constraint FACTOR_INVESTIGATION_COMPONENC 
    foreign key (INVESTIGATION_COMPONENTS_FK) 
    references INVESTIGATION_COMPONENT (ID);
alter table __GENERIC_EQUIPMENT 
    add index GENERIC_EQUIPMENT_GENERIC_PROC (GENERIC_PROTOCOLS_FK), 
    add constraint GENERIC_EQUIPMENT_GENERIC_PROC 
    foreign key (GENERIC_PROTOCOLS_FK) 
    references GENERIC_PROTOCOL (ID);
alter table __GENERIC_EQUIPMENT 
    add index GENERIC_PROTOCOL__GENERIC_EQUC (_GENERIC_EQUIPMENT_FK), 
    add constraint GENERIC_PROTOCOL__GENERIC_EQUC 
    foreign key (_GENERIC_EQUIPMENT_FK) 
    references GENERIC_EQUIPMENT (ID);
alter table __GENERIC_EQUIPMENT_PARTS 
    add index GENERIC_EQUIPMENT__GENERIC_EQC (_GENERIC_EQUIPMENT_PARTS_FK), 
    add constraint GENERIC_EQUIPMENT__GENERIC_EQC 
    foreign key (_GENERIC_EQUIPMENT_PARTS_FK) 
    references GENERIC_EQUIPMENT (ID);
alter table __GENERIC_EQUIPMENT_PARTS 
    add index GENERIC_EQUIPMENT_GENERIC_EQUC (GENERIC_EQUIPMENTS_FK), 
    add constraint GENERIC_EQUIPMENT_GENERIC_EQUC 
    foreign key (GENERIC_EQUIPMENTS_FK) 
    references GENERIC_EQUIPMENT (ID);
alter table __GENERIC_INPUT_DATA 
    add index DATA_INPUT_GPA_FKC (_GENERIC_INPUT_DATA_FK), 
    add constraint DATA_INPUT_GPA_FKC 
    foreign key (_GENERIC_INPUT_DATA_FK) 
    references DATA (ID);
alter table __GENERIC_INPUT_DATA 
    add index GPA_INDATA_FKC (GENERIC_PROTOCOL_APPLICATIO_FK), 
    add constraint GPA_INDATA_FKC 
    foreign key (GENERIC_PROTOCOL_APPLICATIO_FK) 
    references GENERIC_PROTOCOL_APPLICATION (ID);
alter table __GENERIC_SOFTWARE 
    add index GENERIC_SOFTWARE_GENERIC_PROTC (GENERIC_PROTOCOLS_FK), 
    add constraint GENERIC_SOFTWARE_GENERIC_PROTC 
    foreign key (GENERIC_PROTOCOLS_FK) 
    references GENERIC_PROTOCOL (ID);
alter table __GENERIC_SOFTWARE 
    add index GENERIC_PROTOCOL__GENERIC_SOFC (_GENERIC_SOFTWARE_FK), 
    add constraint GENERIC_PROTOCOL__GENERIC_SOFC 
    foreign key (_GENERIC_SOFTWARE_FK) 
    references GENERIC_SOFTWARE (ID);
alter table __INPUT_PARTITIONS 
    add index PARTITION_PAIR__INPUT_PARTITIC (_INPUT_PARTITIONS_FK), 
    add constraint PARTITION_PAIR__INPUT_PARTITIC 
    foreign key (_INPUT_PARTITIONS_FK) 
    references DATA_PARTITION (ID);
alter table __INPUT_PARTITIONS 
    add index PARTITION_IN_FKC (PARTITION_PAIRS_FK), 
    add constraint PARTITION_IN_FKC 
    foreign key (PARTITION_PAIRS_FK) 
    references PARTITION_PAIR (ID);
alter table __INVESTIGATION_TYPES 
    add index INVESTIGATION__INVESTIGATION_C (_INVESTIGATION_TYPES_FK), 
    add constraint INVESTIGATION__INVESTIGATION_C 
    foreign key (_INVESTIGATION_TYPES_FK) 
    references ONTOLOGY_TERM (ID);
alter table __INVESTIGATION_TYPES 
    add index ONTOLOGY_TERM_INVESTIGATIONS_C (INVESTIGATIONS_FK), 
    add constraint ONTOLOGY_TERM_INVESTIGATIONS_C 
    foreign key (INVESTIGATIONS_FK) 
    references INVESTIGATION (ID);
alter table __MEMBERS 
    add index CONTACT_SECURITY_GROUPS_FKC (SECURITY_GROUPS_FK), 
    add constraint CONTACT_SECURITY_GROUPS_FKC 
    foreign key (SECURITY_GROUPS_FK) 
    references SECURITY_GROUP (ID);
alter table __MEMBERS 
    add index SECURITY_GROUP__MEMBERS_FKC (_MEMBERS_FK), 
    add constraint SECURITY_GROUP__MEMBERS_FKC 
    foreign key (_MEMBERS_FK) 
    references CONTACT (ID);
alter table __OUTPUT_PARTITIONS 
    add index PARTITION_OUT_FKC (PARTITION_PAIRS_FK), 
    add constraint PARTITION_OUT_FKC 
    foreign key (PARTITION_PAIRS_FK) 
    references PARTITION_PAIR (ID);
alter table __OUTPUT_PARTITIONS 
    add index PARTITION_PAIR__OUTPUT_PARTITC (_OUTPUT_PARTITIONS_FK), 
    add constraint PARTITION_PAIR__OUTPUT_PARTITC 
    foreign key (_OUTPUT_PARTITIONS_FK) 
    references DATA_PARTITION (ID);
alter table __OWNER 
    add index SECURITY__OWNER_FKC (_OWNER_FK), 
    add constraint SECURITY__OWNER_FKC 
    foreign key (_OWNER_FK) 
    references CONTACT (ID);
alter table __OWNER 
    add index CONTACT_SECURITIES_FKC (SECURITIES_FK), 
    add constraint CONTACT_SECURITIES_FKC 
    foreign key (SECURITIES_FK) 
    references SECURITY (ID);
alter table __PARAMETERIZABLE_TYPES 
    add index PARAMETERIZABLE__PARAMETERIZAC (_PARAMETERIZABLE_TYPES_FK), 
    add constraint PARAMETERIZABLE__PARAMETERIZAC 
    foreign key (_PARAMETERIZABLE_TYPES_FK) 
    references ONTOLOGY_TERM (ID);
alter table __PARAMETERIZABLE_TYPES 
    add index ONTOLOGY_TERM_PARAMETERIZABLEC (PARAMETERIZABLES_FK), 
    add constraint ONTOLOGY_TERM_PARAMETERIZABLEC 
    foreign key (PARAMETERIZABLES_FK) 
    references PARAMETERIZABLE (ID);
alter table __PROPERTIES 
    add index ONTOLOGY_PROPERTY_ONTOLOGY_INC (ONTOLOGY_INDIVIDUALS_FK), 
    add constraint ONTOLOGY_PROPERTY_ONTOLOGY_INC 
    foreign key (ONTOLOGY_INDIVIDUALS_FK) 
    references ONTOLOGY_INDIVIDUAL (ID);
alter table __PROPERTIES 
    add index ONTOLOGY_INDIVIDUAL__PROPERTIC (_PROPERTIES_FK), 
    add constraint ONTOLOGY_INDIVIDUAL__PROPERTIC 
    foreign key (_PROPERTIES_FK) 
    references ONTOLOGY_PROPERTY (ID);
alter table __PROTOCOL_INPUT_TYPES 
    add index PROTOCOL__INPUT_TYPES_FKC (_INPUT_TYPES_FK), 
    add constraint PROTOCOL__INPUT_TYPES_FKC 
    foreign key (_INPUT_TYPES_FK) 
    references ONTOLOGY_TERM (ID);
alter table __PROTOCOL_INPUT_TYPES 
    add index P_INPUTTYPES_FK (PROTOCOLS_FK), 
    add constraint P_INPUTTYPES_FK 
    foreign key (PROTOCOLS_FK) 
    references PROTOCOL (ID);
alter table __PROTOCOL_OUTPUT_TYPES 
    add index P_OUTPUTTYPES_FKC (PROTOCOLS_FK), 
    add constraint P_OUTPUTTYPES_FKC 
    foreign key (PROTOCOLS_FK) 
    references PROTOCOL (ID);
alter table __PROTOCOL_OUTPUT_TYPES 
    add index PROTOCOL__OUTPUT_TYPES_FKC (_OUTPUT_TYPES_FK), 
    add constraint PROTOCOL__OUTPUT_TYPES_FKC 
    foreign key (_OUTPUT_TYPES_FK) 
    references ONTOLOGY_TERM (ID);
alter table __QUALITY_CONTROL_STATISTICS 
    add index Material_QC_FKC (MATERIALS_FK), 
    add constraint Material_QC_FKC 
    foreign key (MATERIALS_FK) 
    references MATERIAL (ID);
alter table __QUALITY_CONTROL_STATISTICS 
    add index MATERIAL__QUALITY_CONTROL_STAC (_QUALITY_CONTROL_STATISTICS_FK), 
    add constraint MATERIAL__QUALITY_CONTROL_STAC 
    foreign key (_QUALITY_CONTROL_STATISTICS_FK) 
    references ONTOLOGY_TERM (ID);
alter table __SOFTWARE2_EQUIPMENT 
    add index EQUIPMENT__SOFTWARES_FKC (_SOFTWARES_FK), 
    add constraint EQUIPMENT__SOFTWARES_FKC 
    foreign key (_SOFTWARES_FK) 
    references SOFTWARE (ID);
alter table __SOFTWARE2_EQUIPMENT 
    add index SOFTWARE__EQUIPMENT_FKC (_EQUIPMENT_FK), 
    add constraint SOFTWARE__EQUIPMENT_FKC 
    foreign key (_EQUIPMENT_FK) 
    references EQUIPMENT (ID);
alter table __SOURCE_MATERIALS 
    add index INVESTIGATION__SOURCE_MATERIAC (_SOURCE_MATERIALS_FK), 
    add constraint INVESTIGATION__SOURCE_MATERIAC 
    foreign key (_SOURCE_MATERIALS_FK) 
    references MATERIAL (ID);
alter table __SOURCE_MATERIALS 
    add index MATERIAL_INVESTIGATIONS_FKC (INVESTIGATIONS_FK), 
    add constraint MATERIAL_INVESTIGATIONS_FKC 
    foreign key (INVESTIGATIONS_FK) 
    references INVESTIGATION (ID);
alter table __SUMMARY_RESULTS 
    add index INVESTIGATION__SUMMARY_RESULTC (_SUMMARY_RESULTS_FK), 
    add constraint INVESTIGATION__SUMMARY_RESULTC 
    foreign key (_SUMMARY_RESULTS_FK) 
    references HIGHER_LEVEL_ANALYSIS (ID);
alter table __SUMMARY_RESULTS 
    add index HIGHER_LEVEL_ANALYSIS_INVESTIC (INVESTIGATIONS_FK), 
    add constraint HIGHER_LEVEL_ANALYSIS_INVESTIC 
    foreign key (INVESTIGATIONS_FK) 
    references INVESTIGATION (ID);
alter table __SUPPORTING_DATA 
    add index DATA_HIGHER_LEVEL_ANALYSES_FKC (HIGHER_LEVEL_ANALYSES_FK), 
    add constraint DATA_HIGHER_LEVEL_ANALYSES_FKC 
    foreign key (HIGHER_LEVEL_ANALYSES_FK) 
    references HIGHER_LEVEL_ANALYSIS (ID);
alter table __SUPPORTING_DATA 
    add index HIGHER_LEVEL_ANALYSIS__SUPPORC (_SUPPORTING_DATA_FK), 
    add constraint HIGHER_LEVEL_ANALYSIS__SUPPORC 
    foreign key (_SUPPORTING_DATA_FK) 
    references DATA (ID);