EDIT

SET WRITE_DELAY 500;

SET DEFAULT_LOCK_TIMEOUT 2000;

SET CACHE_SIZE 16384;

CREATE USER IF NOT EXISTS EDIT PASSWORD '' ADMIN;

CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC START WITH 4 BELONGS_TO_TABLE;

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE(

    TEAMMEMBERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE;

CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD(

    REV INTEGER NOT NULL,

    TEAMMEMBERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE(

    TYPES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE;

CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD(

    REV INTEGER NOT NULL,

    TYPES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT(

    CONTINENTS_ID INTEGER NOT NULL

);

-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD(

    REV INTEGER NOT NULL,

    CONTINENTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT(

    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD(

    REV INTEGER NOT NULL,

    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION(

    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD(

    REV INTEGER NOT NULL,

    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE(

    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD(

    REV INTEGER NOT NULL,

    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION(

    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD(

    REV INTEGER NOT NULL,

    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY(

    COUNTRIES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_COUNTRY;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD(

    REV INTEGER NOT NULL,

    COUNTRIES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_FEATURE_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE(

    GEOSCOPES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_GEOSCOPE;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE_AUD(

    REV INTEGER NOT NULL,

    GEOSCOPES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE(

    SCOPES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SCOPE;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE_AUD(

    REV INTEGER NOT NULL,

    SCOPES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING(

    MULTILANGUAGETEXT_ID INTEGER NOT NULL,

    MULTILANGUAGETEXT_MAPKEY_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD(

    REV INTEGER NOT NULL,

    MULTILANGUAGETEXT_ID INTEGER NOT NULL,

    MULTILANGUAGETEXT_MAPKEY_ID INTEGER NOT NULL,

    REVTYPE TINYINT

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD;

    DESCRIPTION_ID INTEGER NOT NULL,

    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL

);

CREATE CACHED TABLE PUBLIC.IDENTIFIER(

    ID INTEGER NOT NULL,

    UUID VARCHAR(36),

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE_AUD;

    REV INTEGER NOT NULL,

    DESCRIPTION_ID INTEGER NOT NULL,

    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

CREATE CACHED TABLE PUBLIC.INSTITUTIONALMEMBERSHIP(

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

    CITATION_ID INTEGER

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA;

CREATE CACHED TABLE PUBLIC.MEDIAKEY_NAMEDAREA(

    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_NAMEDAREA;

CREATE CACHED TABLE PUBLIC.MEDIAKEY_NAMEDAREA_AUD(

    REV INTEGER NOT NULL,

    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_NAMEDAREA_AUD;

CREATE CACHED TABLE PUBLIC.MEDIAKEY_SCOPE(

    SCOPERESTRICTIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE;

CREATE CACHED TABLE PUBLIC.MEDIAKEY_SCOPE_AUD(

    REV INTEGER NOT NULL,

    SCOPERESTRICTIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIAKEY_SCOPE_AUD;

    MEDIAKEY_ID INTEGER NOT NULL,

);

    REV INTEGER NOT NULL,

    MEDIAKEY_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATION(

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD;

CREATE CACHED TABLE PUBLIC.MEDIA_REPRESENTATION(

    KEYREPRESENTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_REPRESENTATION;

CREATE CACHED TABLE PUBLIC.MEDIA_REPRESENTATION_AUD(

    REV INTEGER NOT NULL,

    KEYREPRESENTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.MEDIA_SEQUENCE(

    USEDSEQUENCES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_SEQUENCE;

CREATE CACHED TABLE PUBLIC.MEDIA_SEQUENCE_AUD(

    REV INTEGER NOT NULL,

    USEDSEQUENCES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_SEQUENCE_AUD;

    COVEREDTAXA_ID INTEGER NOT NULL

);

    REV INTEGER NOT NULL,

    COVEREDTAXA_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA(

    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_NAMEDAREA;

CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD(

    REV INTEGER NOT NULL,

    GEOGRAPHICALSCOPE_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD;

CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_SCOPE(

    SCOPERESTRICTIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_SCOPE;

CREATE CACHED TABLE PUBLIC.MULTIACCESSKEY_SCOPE_AUD(

    REV INTEGER NOT NULL,

    SCOPERESTRICTIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_SCOPE_AUD;

    MULTIACCESSKEY_ID INTEGER NOT NULL,

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MULTIACCESSKEY_TAXON;

    REV INTEGER NOT NULL,

    MULTIACCESSKEY_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

CREATE CACHED TABLE PUBLIC.NAMERELATIONSHIP(

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PERMISSIONGROUP;

CREATE CACHED TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL(

    GRANTEDAUTHORITIES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL;

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION(

    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL

);

-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION;

CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD(

    REV INTEGER NOT NULL,

    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.RIGHTSINFO_ANNOTATION(

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO_ANNOTATION;

CREATE CACHED TABLE PUBLIC.RIGHTSINFO_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.RIGHTSINFO_MARKER(

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTSINFO_MARKER;

CREATE CACHED TABLE PUBLIC.RIGHTSINFO_MARKER_AUD(

    REV INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONBASE_RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING(

    DESCRIPTION_ID INTEGER NOT NULL,

    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING;

CREATE CACHED TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTION_ID INTEGER NOT NULL,

    DESCRIPTION_MAPKEY_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 1 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_AUD;

CREATE CACHED TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL(

    GRANTEDAUTHORITIES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL;

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE(

    DESCRIPTIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE;

CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION_AUD;

CREATE CACHED TABLE PUBLIC.HIBERNATE_SEQUENCES(

    SEQUENCE_NAME VARCHAR(255) NOT NULL,

    NEXT_VAL BIGINT

ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBC2 PRIMARY KEY(TAXONBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33F PRIMARY KEY(REV, GATHERINGEVENT_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D7 PRIMARY KEY(TAXONNAMEBASE_ID, STATUS_ID);

ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB0 PRIMARY KEY(DETERMINATIONEVENT_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33C PRIMARY KEY(REV, TAXONNAMEBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD PRIMARY KEY(DEFINEDTERMBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBA5 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.CREDIT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE3 PRIMARY KEY(REV, CREDIT_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7FE PRIMARY KEY(TAXONRELATIONSHIP_ID, MARKERS_ID);

ALTER TABLE PUBLIC.NAMERELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5A2 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE6 PRIMARY KEY(REV, ANNOTATION_ID, ANNOTATIONS_ID);

--ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2CE PRIMARY KEY(REV, SEQUENCE_ID, CHROMATOGRAMS_ID);

ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE0 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF36 PRIMARY KEY(REV, LANGUAGESTRING_ID, MARKERS_ID);

ALTER TABLE PUBLIC.REFERENCE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF43 PRIMARY KEY(REV, REFERENCE_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7A3 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF49 PRIMARY KEY(REV, TAXONNODE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.FEATURETREE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9E6 PRIMARY KEY(REV, FEATURETREE_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9E5 PRIMARY KEY(POLYTOMOUSKEY_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX314 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXECE PRIMARY KEY(REV, TAXONNAMEBASE_ID, STATUS_ID);

ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX32A PRIMARY KEY(STATISTICALMEASUREMENTVALUE_ID, MODIFIERS_ID);

ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEEB PRIMARY KEY(REV, TYPEDESIGNATIONBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9E0 PRIMARY KEY(REV, SEQUENCE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2C1 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2BE PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2B2 PRIMARY KEY(POLYTOMOUSKEY_ID, MARKERS_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2B4 PRIMARY KEY(POLYTOMOUSKEY_ID, COVEREDTAXA_ID);

ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED7 PRIMARY KEY(TAXONNODE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7B1 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED2 PRIMARY KEY(TAXONNAMEBASE_ID, TYPEDESIGNATIONS_ID);

ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXECC PRIMARY KEY(HYBRIDRELATIONSHIP_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2E2 PRIMARY KEY(TERMVOCABULARY_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TAXONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF5F5 PRIMARY KEY(REV, TAXONBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD2F PRIMARY KEY(REV, TAXONNAMEBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX729 PRIMARY KEY(KEYSTATEMENT_ID, LABEL_MAPKEY_ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD96 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.FEATURETREE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF0 PRIMARY KEY(FEATURETREE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD4 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF2 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, SORTINDEX);

ALTER TABLE PUBLIC.COLLECTION_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEE PRIMARY KEY(COLLECTION_ID, MEDIA_ID);

ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFA PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFB PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.FEATURETREE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF9 PRIMARY KEY(FEATURETREE_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX368 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF5 PRIMARY KEY(CLASSIFICATION_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF7 PRIMARY KEY(CLASSIFICATION_ID, SOURCES_ID);

ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD5 PRIMARY KEY(REV, NAMERELATIONSHIP_ID, MARKERS_ID);

ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFF PRIMARY KEY(REV, ORIGINALSOURCEBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.AGENTBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF1 PRIMARY KEY(AGENTBASE_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE0 PRIMARY KEY(FEATURETREE_ID, SORTINDEX);

ALTER TABLE PUBLIC.COLLECTION_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDD PRIMARY KEY(COLLECTION_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE5 PRIMARY KEY(DESCRIPTIONBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDF PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEB PRIMARY KEY(POLYTOMOUSKEY_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE7 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_FAXNUMBERS_ELEMENT);

ALTER TABLE PUBLIC.TAXONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX91D PRIMARY KEY(REV, TAXONBASE_ID, CREDITS_ID, SORTINDEX);

ALTER TABLE PUBLIC.COLLECTION_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAD9 PRIMARY KEY(REV, COLLECTION_ID, CREDITS_ID, SORTINDEX);

ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX444 PRIMARY KEY(FEATURETREE_ID, REPRESENTATIONS_ID);

ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63FF PRIMARY KEY(GATHERINGEVENT_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.WORKINGSET_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8BD PRIMARY KEY(REV, WORKINGSET_ID, MARKERS_ID);

ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43B PRIMARY KEY(REV, ORIGINALSOURCEBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6887 PRIMARY KEY(REV, ORIGINALS_ID, DERIVATIONEVENTS_ID);

ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFF4 PRIMARY KEY(TAXONBASE_ID, SORTINDEX);

ALTER TABLE PUBLIC.MEDIA_DESCRIPTION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX952 PRIMARY KEY(REV, MEDIA_ID, DESCRIPTION_ID, DESCRIPTION_MAPKEY_ID);

ALTER TABLE PUBLIC.TERMVOCABULARY_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFFF PRIMARY KEY(REV, TERMVOCABULARY_ID, CREDITS_ID, SORTINDEX);

ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA47 PRIMARY KEY(ORIGINALSOURCEBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX969 PRIMARY KEY(MEDIA_ID, TITLE_MAPKEY_ID);

ALTER TABLE PUBLIC.SEQUENCE_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX514 PRIMARY KEY(REV, SEQUENCE_ID, CITATIONS_ID);

ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX906 PRIMARY KEY(FEATURETREE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX901 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX17 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX18 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX19 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX12 PRIMARY KEY(SYNONYMRELATIONSHIP_ID, MARKERS_ID);

ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2F PRIMARY KEY(REV, NOMENCLATURALSTATUS_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.MEDIA_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX439 PRIMARY KEY(REV, MEDIA_ID, CREDITS_ID, SORTINDEX);

ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX16 PRIMARY KEY(MEDIA_ID, SOURCES_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1B PRIMARY KEY(POLYTOMOUSKEY_ID, SORTINDEX);

ALTER TABLE PUBLIC.EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1D PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF5F PRIMARY KEY(REV, DERIVATIONEVENT_ID, MARKERS_ID);

ALTER TABLE PUBLIC.MEDIA_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX13 PRIMARY KEY(REV, MEDIA_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2B PRIMARY KEY(DEFINEDTERMBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX25D PRIMARY KEY(MEDIA_ID, MARKERS_ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD6 PRIMARY KEY(DESCRIPTIONBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX984 PRIMARY KEY(COLLECTION_ID, SOURCES_ID);

ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX657 PRIMARY KEY(REV, SYNONYMRELATIONSHIP_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC3CB PRIMARY KEY(TERMVOCABULARY_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.FEATURENODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9FE PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.WORKINGSET_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB92 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB5D PRIMARY KEY(NOMENCLATURALSTATUS_ID, MARKERS_ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA82 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB59 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5FC PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB5A PRIMARY KEY(REV, POLYTOMOUSKEY_ID, COVEREDTAXA_ID);

ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFA8 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5C PRIMARY KEY(DESCRIPTIONBASE_ID, DESCRIPTIONSOURCES_ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB86 PRIMARY KEY(DESCRIPTIONBASE_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXON ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB77 PRIMARY KEY(POLYTOMOUSKEY_ID, TAXON_ID);

ALTER TABLE PUBLIC.REFERENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDC PRIMARY KEY(REV, REFERENCE_ID, MEDIA_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX60C PRIMARY KEY(DEFINEDTERMBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2864 PRIMARY KEY(REV, STATEDATA_ID, MODIFIERS_ID);

--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA9D PRIMARY KEY(REV, SEQUENCE_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC9 PRIMARY KEY(WORKINGSET_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4F7 PRIMARY KEY(TYPEDESIGNATIONBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFB3 PRIMARY KEY(REV, HYBRIDRELATIONSHIP_ID, ANNOTATIONS_ID);

--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX286 PRIMARY KEY(REV, CLASSIFICATION_ID, ROOTNODES_ID);

ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F PRIMARY KEY(FEATURETREE_ID, EXTENSIONS_ID);

--ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9EB PRIMARY KEY(SEQUENCE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.MEDIA_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA7B PRIMARY KEY(REV, MEDIA_ID, MARKERS_ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA7D PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEB6 PRIMARY KEY(TAXONNAMEBASE_ID, SOURCES_ID);

--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88C PRIMARY KEY(SEQUENCE_ID, EXTENSIONS_ID);

--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX807 PRIMARY KEY(SEQUENCE_ID, CHROMATOGRAMS_ID);

ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE PRIMARY KEY(ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA9 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5A PRIMARY KEY(REV, DEFINEDTERMBASE_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6D PRIMARY KEY(REV, LANGUAGESTRING_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA8 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1D0 PRIMARY KEY(REV, KEYSTATEMENT_ID, LABEL_ID, LABEL_MAPKEY_ID);

ALTER TABLE PUBLIC.CREDIT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5488765 PRIMARY KEY(REV, CREDIT_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBD PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA2 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, SORTINDEX);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA7 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.COLLECTION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6E PRIMARY KEY(REV, COLLECTION_ID, MARKERS_ID);

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX55 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_FEATURE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3D PRIMARY KEY(REV, DESCRIPTIONBASE_ID, DESCRIPTIVESYSTEM_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5A24 PRIMARY KEY(POLYTOMOUSKEY_ID, GEOGRAPHICALSCOPE_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3C PRIMARY KEY(POLYTOMOUSKEYNODE_ID, MODIFYINGTEXT_MAPKEY_ID);

ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA5 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1E1 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.MEDIAREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX557C PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA4 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, DESCRIPTIONSOURCES_ID);

ALTER TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3AC PRIMARY KEY(STATEDATA_ID, MODIFIERS_ID);

ALTER TABLE PUBLIC.AGENTBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD PRIMARY KEY(AGENTBASE_ID, SORTINDEX);

ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87CF PRIMARY KEY(MEDIA_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8F PRIMARY KEY(REV, CLASSIFICATION_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX95 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_PHONENUMBERS_ELEMENT);

ALTER TABLE PUBLIC.KEYSTATEMENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA6 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX698 PRIMARY KEY(REV, TAXONNAMEBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3A PRIMARY KEY(REV, DEFINEDTERMBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.COLLECTION_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX60 PRIMARY KEY(REV, COLLECTION_ID, MEDIA_ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63 PRIMARY KEY(DESCRIPTIONBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA4 PRIMARY KEY(TAXONNAMEBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.TERMVOCABULARY_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1DF PRIMARY KEY(TERMVOCABULARY_ID, SORTINDEX);

ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69E PRIMARY KEY(ID);

ALTER TABLE PUBLIC.USERACCOUNT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX850 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.DERIVATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX83E PRIMARY KEY(ID);

ALTER TABLE PUBLIC.TERMVOCABULARY_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDDD PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3F PRIMARY KEY(REV, FEATURENODE_ID, ONLYAPPLICABLEIF_ID);

ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC9 PRIMARY KEY(REV, WORKINGSET_ID, REPRESENTATIONS_ID);

ALTER TABLE PUBLIC.FEATURETREE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAF PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.COLLECTION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAD PRIMARY KEY(REV, COLLECTION_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.SEQUENCE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3DF PRIMARY KEY(REV, SEQUENCE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAB PRIMARY KEY(MEMBERS_ID, GROUPS_ID);

ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4A PRIMARY KEY(REV, TAXONBASE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX879 PRIMARY KEY(NOMENCLATURALSTATUS_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC7 PRIMARY KEY(REV, GATHERINGEVENT_ID, COLLECTINGAREAS_ID);

ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAC PRIMARY KEY(FEATURENODE_ID, INAPPLICABLEIF_ID);

ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX48 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);

ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB4 PRIMARY KEY(REV, AGENTBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBA PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_EMAILADDRESSES_ELEMENT);

ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC6A35D PRIMARY KEY(STATEDATA_ID, MODIFYINGTEXT_MAPKEY_ID);

ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4F PRIMARY KEY(REV, MEDIA_ID, TITLE_ID, TITLE_MAPKEY_ID);

ALTER TABLE PUBLIC.CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC5 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3EB PRIMARY KEY(ID);

ALTER TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3CC PRIMARY KEY(REV, TAXONRELATIONSHIP_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.ANNOTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4D PRIMARY KEY(REV, ANNOTATION_ID, MARKERS_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX36 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX35 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE02 PRIMARY KEY(REV, FEATURETREE_ID, REPRESENTATIONS_ID);

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX31 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MODIFIERS_ID);

ALTER TABLE PUBLIC.FEATURETREE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX32 PRIMARY KEY(REV, FEATURETREE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E8 PRIMARY KEY(WORKINGSET_ID, REPRESENTATIONS_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3D9 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, MARKERS_ID);

ALTER TABLE PUBLIC.COLLECTION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4 PRIMARY KEY(COLLECTION_ID, SORTINDEX);

ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E PRIMARY KEY(REV, DETERMINATIONEVENT_ID, MARKERS_ID);

ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX45 PRIMARY KEY(REV, HOMOTYPICALGROUP_ID, MARKERS_ID);

ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E3 PRIMARY KEY(REV, TAXONNAMEBASE_ID, TYPEDESIGNATIONS_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX52 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, MEDIA_ID);

ALTER TABLE PUBLIC.AGENTBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX44 PRIMARY KEY(AGENTBASE_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX50 PRIMARY KEY(DEFINEDTERMBASE_ID, SORTINDEX);

ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC2 PRIMARY KEY(REV, FEATURETREE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX871 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCC8 PRIMARY KEY(GATHERINGEVENT_ID, COLLECTINGAREAS_ID);

ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC1 PRIMARY KEY(REV, REFERENCE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.AGENTBASE_ADDRESS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCE45 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_ADDRESSES_ID);

ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE26 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX93 PRIMARY KEY(FEATURETREE_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCE5 PRIMARY KEY(ORIGINALSOURCEBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX880 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.AGENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43456AE PRIMARY KEY(ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7E PRIMARY KEY(REV, DESCRIPTIONBASE_ID, SOURCES_ID);

ALTER TABLE PUBLIC.AGENTBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB3456AE PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9F PRIMARY KEY(REV, DESCRIPTIONBASE_ID, CREDITS_ID, SORTINDEX);

ALTER TABLE PUBLIC.AGENTBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF PRIMARY KEY(REV, AGENTBASE_ID, MARKERS_ID);

ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6E1 PRIMARY KEY(NAMERELATIONSHIP_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.CREDIT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1 PRIMARY KEY(CREDIT_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX99 PRIMARY KEY(WORKINGSET_ID, MARKERS_ID);

ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA3456AE PRIMARY KEY(ANNOTATION_ID, ANNOTATIONS_ID);

ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6EF PRIMARY KEY(ID);

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9A PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, CREDITS_ID, SORTINDEX);

ALTER TABLE PUBLIC.LOCUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX80 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFF PRIMARY KEY(REV, TERMVOCABULARY_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.REFERENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX85 PRIMARY KEY(REV, REFERENCE_ID, EXTENSIONS_ID);

ALTER TABLE PUBLIC.EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX81 PRIMARY KEY(ID);

ALTER TABLE PUBLIC.TAXONRELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX92 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.COLLECTION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX90 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.LSIDAUTHORITY_NAMESPACES ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX77 PRIMARY KEY(LSIDAUTHORITY_ID, NAMESPACES_MAPKEY);

--ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX762 PRIMARY KEY(SEQUENCE_ID, CITATIONS_ID);

ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7A PRIMARY KEY(ID);

ALTER TABLE PUBLIC.REPRESENTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX91 PRIMARY KEY(REV, REPRESENTATION_ID, MARKERS_ID);

ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D PRIMARY KEY(ID);

--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX97 PRIMARY KEY(SEQUENCE_ID, RIGHTS_ID);

ALTER TABLE PUBLIC.ADDRESS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2 PRIMARY KEY(ID, REV);

ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9063 UNIQUE(SOURCES_ID);

ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7A0 UNIQUE(UUID);

ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5F1 UNIQUE(ANNOTATIONS_ID);

ALTER TABLE PUBLIC.MEDIA_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX448E UNIQUE(USEDSEQUENCES_ID);

ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA5E UNIQUE(UUID);

ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4D7 UNIQUE(ANNOTATIONS_ID);

ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD80E UNIQUE(SOURCES_ID);

ALTER TABLE PUBLIC.MEDIA_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2EC UNIQUE(RIGHTS_ID);

ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.FK8400DFA537998500 FOREIGN KEY(LANGUAGESTRING_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIA_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.FK3C7BD9CD34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.FK4CB48B3D9C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CDBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.FKAD1E6D3447C496CB FOREIGN KEY(FEATURETREE_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKC753F137C6D55834 FOREIGN KEY(MULTILANGUAGETEXT_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

--ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.FK544ADBE1D0374392 FOREIGN KEY(PUBLISHEDIN_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK8F39D56034869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER_AUD ADD CONSTRAINT PUBLIC.FK160230F834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKF41ADEEB53DD72E3 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK13BD64E847C496CB FOREIGN KEY(FEATURETREE_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK44D5F7D886EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.FKFC824E31E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.REPRESENTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.FKD640BBBD34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKD1D59CDC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.FK76DDD01BF95F225A FOREIGN KEY(GATHERINGEVENT_ID) REFERENCES PUBLIC.GATHERINGEVENT(ID) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FKB5AE7AB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.FK1ED033D42687715A FOREIGN KEY(COUNTRY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2BAEC3B8B8 FOREIGN KEY(SCHOOL_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.FK1C727CFF89D97CB FOREIGN KEY(POLYTOMOUSKEY_ID) REFERENCES PUBLIC.POLYTOMOUSKEY(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER ADD CONSTRAINT PUBLIC.FK97E0D105E0960EC4 FOREIGN KEY(MODIFIERS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49B4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2B4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.RIGHTSINFO ADD CONSTRAINT PUBLIC.FK91E56DF7BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.COLLECTION ADD CONSTRAINT PUBLIC.FKF078ABEBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK3296F9AF34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_MEDIA ADD CONSTRAINT PUBLIC.FKBBEF5B0C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775A4382686A FOREIGN KEY(STATEMENT_ID) REFERENCES PUBLIC.KEYSTATEMENT(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.FK67A45544E3818E37 FOREIGN KEY(REPRESENTATION_ID) REFERENCES PUBLIC.MEDIAREPRESENTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK812DE753887E3D12 FOREIGN KEY(MEMBERS_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.FK1DB2497378D1BD FOREIGN KEY(MODIFIER_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.FKE03B8292927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FK69FBDD372BD180D9 FOREIGN KEY(TAXONRELATIONSHIP_ID) REFERENCES PUBLIC.TAXONRELATIONSHIP(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONBASE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK4CF70A6C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT ADD CONSTRAINT PUBLIC.FKE9D17767F3BB39BD FOREIGN KEY(RECOMMENDEDMEASUREMENTUNITS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKCA7F794A3A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;

--ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;

ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;

ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.FK97D36661BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD ADD CONSTRAINT PUBLIC.FKF3803C234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK921A01F0C0DB4934 FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.COLLECTION ADD CONSTRAINT PUBLIC.FKF078ABE16B9CA77 FOREIGN KEY(INSTITUTE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD ADD CONSTRAINT PUBLIC.FKCAF7E75F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS ADD CONSTRAINT PUBLIC.FKC171CC2486EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TERMVOCABULARY ADD CONSTRAINT PUBLIC.FK487AA692BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CD4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.CLASSIFICATION_MARKER ADD CONSTRAINT PUBLIC.FK59778AB3777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;

ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.FK76DDD01B1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE ADD CONSTRAINT PUBLIC.FK6AE876AB57FA94D4 FOREIGN KEY(ONLYAPPLICABLEIF_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER ADD CONSTRAINT PUBLIC.FK97E0D1053B8BB609 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.FK4CEED9F84220AFEB FOREIGN KEY(FEATURE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

--ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKCDB0237B3A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP_AUD ADD CONSTRAINT PUBLIC.FK847A94A34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FKB914A10B44E9E6D4 FOREIGN KEY(TYPEDESIGNATIONBASE_ID) REFERENCES PUBLIC.TYPEDESIGNATIONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.FK6BEDC7EE777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;

ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.FK88F1805AD64DC020 FOREIGN KEY(MARKERTYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B12C0DB4934 FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.FK1A21C74FBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.FK7A0351D6BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;

ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK93FFD2AD8E7BF9AB FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;

ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.FK544ADBE14FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_CONTACT_URLS ADD CONSTRAINT PUBLIC.FK9A9643EC86EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.FK4CF19F94BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.FKB0BD86D384A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKF746D2763A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02F8991B9D FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCCCC05993E FOREIGN KEY(SYNONYMTOBEUSED_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.FK4CB48B3D32D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.FK82C86DAC2BD180D9 FOREIGN KEY(TAXONRELATIONSHIP_ID) REFERENCES PUBLIC.TAXONRELATIONSHIP(ID) NOCHECK;

ALTER TABLE PUBLIC.CLASSIFICATION_ANNOTATION ADD CONSTRAINT PUBLIC.FKC978FD2884A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.FK522D90C73B8BB609 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION ADD CONSTRAINT PUBLIC.FKAE34C1D8927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;

ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK5D248B8434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKD58E791834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT ADD CONSTRAINT PUBLIC.FK45F60AFB3927C853 FOREIGN KEY(CONTINENTS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA3272DADF76EA FOREIGN KEY(PRIMARYCOLLECTOR_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK9E7794681E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD ADD CONSTRAINT PUBLIC.FK76253F8A34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.FKF483ADB34BAC703F FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2BBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.FK750A135034869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FK3DA7BE4434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.FKBB16686134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02F11BD77B FOREIGN KEY(TYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.CREDIT_AUD ADD CONSTRAINT PUBLIC.FK5533906A34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DERIVATIONEVENT ADD CONSTRAINT PUBLIC.FK426BC038524B89D FOREIGN KEY(TYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK2EBEFB1C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49B74FED214 FOREIGN KEY(SEC_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIA_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FKE13FAD3534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E51083AEB7F3BE FOREIGN KEY(CITATION_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES ADD CONSTRAINT PUBLIC.FK4BD2B08E86EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIAKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.FK922630D334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.NAMERELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.FK743F44D434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA ADD CONSTRAINT PUBLIC.FK21F700763B8BB609 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.FK7C978EB334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.FK780D5C7F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKFB680C819C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.FK78CA9719BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK8318CB8134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.FK67A45544BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF ADD CONSTRAINT PUBLIC.FK56833D011128E63B FOREIGN KEY(INAPPLICABLEIF_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.COLLECTION_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK25A8D88B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.FK8ED0FAE734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.FK7536062432D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;

ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.FK6F1286F3F55AFD89 FOREIGN KEY(EXACTLOCATION_REFERENCESYSTEM_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.FKA9E6B138576595C3 FOREIGN KEY(ROOT_ID) REFERENCES PUBLIC.POLYTOMOUSKEYNODE(ID) NOCHECK;

ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.FKF483ADB3F8991B9D FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FKD482FE2134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

--ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKCDB0237BD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKA197815C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK2DCE02904C428112 FOREIGN KEY(TYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.REPRESENTATION_ANNOTATION ADD CONSTRAINT PUBLIC.FK371091E11E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E51083AF619DE3 FOREIGN KEY(TYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK2E340A6636C6F6F6 FOREIGN KEY(POINTAPPROXIMATION_REFERENCESYSTEM_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775A4220AFEB FOREIGN KEY(FEATURE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.FK522D90C79682414B FOREIGN KEY(MODIFYINGTEXT_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.FK9C2BA24534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.FK5BC6DEAD8D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK626B7850C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;

ALTER TABLE PUBLIC.WORKINGSET_AUD ADD CONSTRAINT PUBLIC.FK628F58E234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS ADD CONSTRAINT PUBLIC.FK52E1AD9586EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK6A3D3D434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.FEATURETREE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FKF128E10534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK11AE594734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK15FE775234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.FK6F1286F3BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.FKA020DAAA1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK42D7AF90C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;

ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBD1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.MARKER_AUD ADD CONSTRAINT PUBLIC.FKB951F12B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.FK395842D777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;

ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK2DCE02904FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK6A2601A9F1DDBFAB FOREIGN KEY(DESCRIPTIONBASE_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.REPRESENTATION ADD CONSTRAINT PUBLIC.FK9C4724EDE8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02E71EF6CE FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEDIA ADD CONSTRAINT PUBLIC.FK6FC908ABC0DB4934 FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FKC0D6BBB58C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE ADD CONSTRAINT PUBLIC.FK1205D3564FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA ADD CONSTRAINT PUBLIC.FK21F70076C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK7CFED28E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C64FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.FK1010BA6DD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK1AD225DC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_CREDIT ADD CONSTRAINT PUBLIC.FK2636742232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIA ADD CONSTRAINT PUBLIC.FK46C7FC4BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK365E4F3C1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.FKFB1697BBBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK3D1256F934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.FK7E3A1D8632D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;

ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.FK7B49CF26F95F225A FOREIGN KEY(GATHERINGEVENT_ID) REFERENCES PUBLIC.GATHERINGEVENT(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.FK5D8B8DA47C496CB FOREIGN KEY(FEATURETREE_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK3281DB8734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKF3C1293434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE ADD CONSTRAINT PUBLIC.FKC330D6395C601E49 FOREIGN KEY(DESCRIPTIONSOURCES_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.FK544ADBE1BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.FK243C037F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.FK560BA7928C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.FKB3BBB1EB34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775ADE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.SEQUENCE_REFERENCE_AUD ADD CONSTRAINT PUBLIC.FK18E5CF9E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_EXTENSION ADD CONSTRAINT PUBLIC.FK8E1E567686EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK505F2E5DBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.AGENTBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK7FE7C0F334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.CREDIT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK1DEB578634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_EXTENSION ADD CONSTRAINT PUBLIC.FKDEFCDC0B927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;

ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.FKF494F15B1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49BBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIAREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK67AAAB0234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.FK9033CE74AEB7F3BE FOREIGN KEY(CITATION_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.CDM_VIEW ADD CONSTRAINT PUBLIC.FKC5DE8EF84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK91B37B3684A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURETREE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKA508E2B634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.FKC28EE7E6927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;

ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.FK8AEBCA0434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784A0A6EDCE FOREIGN KEY(TITLE_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK74E1B58BC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.FK522D90C7F05D08D4 FOREIGN KEY(MODIFYINGTEXT_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;

ALTER TABLE PUBLIC.CREDIT_MARKER ADD CONSTRAINT PUBLIC.FK10CC68404CF694E0 FOREIGN KEY(CREDIT_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;

ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.FK2C7E7DFA59832240 FOREIGN KEY(HYBRIDRELATIONSHIP_ID) REFERENCES PUBLIC.HYBRIDRELATIONSHIP(ID) NOCHECK;

ALTER TABLE PUBLIC.LOCUS_AUD ADD CONSTRAINT PUBLIC.FK5224108F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK13BD64E83A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK9662E5AE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.FK230A885F7208BB38 FOREIGN KEY(SUPERVIEWS_ID) REFERENCES PUBLIC.CDM_VIEW(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.FKA75C411534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK69D9A11AF95F225A FOREIGN KEY(GATHERINGEVENT_ID) REFERENCES PUBLIC.GATHERINGEVENT(ID) NOCHECK;

ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.FK1DB2497AEC8CCAA FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.DESCRIPTIONBASE_FEATURE ADD CONSTRAINT PUBLIC.FK58ACF5649AE62C6 FOREIGN KEY(DESCRIPTIVESYSTEM_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCCDE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.MEDIA ADD CONSTRAINT PUBLIC.FK46C7FC4C2445443 FOREIGN KEY(ARTIST_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;

ALTER TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK37DEC57EEB62BE9A FOREIGN KEY(COLLECTION_ID) REFERENCES PUBLIC.COLLECTION(ID) NOCHECK;

ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FKE3E46396777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;

ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.FK4CEED9F8BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2BAD54327F FOREIGN KEY(INREFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;

ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.FK8959CE7034869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.FK668D5B914FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;

ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK1FFC43A934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;