X-Git-Url: https://dev.e-taxonomy.eu/gitweb/cdmlib.git/blobdiff_plain/1a12a20248d2554b7424c41fc73641f8f3160ef8..219acb965c82dff00ca8a665fd70e9a5f3ebc2ca:/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql

diff --git a/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql b/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
index 0ad8f5a843..04d658c9a1 100644
--- a/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
+++ b/cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
@@ -6,6 +6,8 @@ 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;
+
+
 CREATE CACHED TABLE PUBLIC.ADDRESS(
     ID INTEGER NOT NULL,
     CREATED TIMESTAMP,
@@ -279,6 +281,104 @@ CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS_AUD(
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS_AUD;
+
+CREATE TABLE AMPLIFICATION (
+     ID INTEGER NOT NULL,
+     CREATED TIMESTAMP,
+     UUID VARCHAR(36),
+     UPDATED TIMESTAMP,
+     DESCRIPTION VARCHAR(255),
+     TIMEPERIOD_END VARCHAR(255),
+     TIMEPERIOD_FREETEXT VARCHAR(255),
+     TIMEPERIOD_START VARCHAR(255),
+     ELECTROPHORESISVOLTAGE DOUBLE,
+     GELCONCENTRATION DOUBLE,
+     GELRUNNINGTIME DOUBLE,
+     LADDERUSED VARCHAR(255),
+     SUCCESSTEXT VARCHAR(255),
+     SUCCESSFUL BOOLEAN,
+     CREATEDBY_ID INTEGER,
+     UPDATEDBY_ID INTEGER,
+     ACTOR_ID INTEGER,
+     CLONING_ID INTEGER,
+     DNASAMPLE_ID INTEGER,
+     FORWARDPRIMER_ID INTEGER,
+     DNAMARKER_ID INTEGER,
+     PURIFICATION_ID INTEGER,
+     REVERSEPRIMER_ID INTEGER,
+     GELPHOTO_ID INTEGER,
+     PRIMARY KEY (ID)
+);
+
+CREATE TABLE AMPLIFICATION_AUD (
+    ID INTEGER NOT NULL,
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+    DESCRIPTION VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+    ELECTROPHORESISVOLTAGE DOUBLE,
+    GELCONCENTRATION DOUBLE,
+    GELRUNNINGTIME DOUBLE,
+    LADDERUSED VARCHAR(255),
+    SUCCESSTEXT VARCHAR(255),
+    SUCCESSFUL BOOLEAN,
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    ACTOR_ID INTEGER,
+    CLONING_ID INTEGER,
+    DNASAMPLE_ID INTEGER,
+    FORWARDPRIMER_ID INTEGER,
+    DNAMARKER_ID INTEGER,
+    PURIFICATION_ID INTEGER,
+    REVERSEPRIMER_ID INTEGER,
+    GELPHOTO_ID INTEGER,
+    PRIMARY KEY (ID)
+);
+
+CREATE TABLE AMPLIFICATION_ANNOTATION (
+    AMPLIFICATION_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL,
+    PRIMARY KEY (AMPLIFICATION_ID, ANNOTATIONS_ID)
+);
+
+CREATE TABLE AMPLIFICATION_ANNOTATION_AUD (
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    AMPLIFICATION_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL
+);
+
+CREATE TABLE AMPLIFICATION_MARKER (
+    AMPLIFICATION_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL,
+    PRIMARY KEY (AMPLIFICATION_ID, MARKERS_ID)
+);
+
+CREATE TABLE AMPLIFICATION_MARKER_AUD (
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    AMPLIFICATION_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL,
+);
+
+CREATE TABLE AMPLIFICATION_SINGLEREAD (
+	AMPLIFICATION_ID INTEGER NOT NULL,
+    SINGLEREADS_ID INTEGER NOT NULL,
+    PRIMARY KEY (AMPLIFICATION_ID, SINGLEREADS_ID)
+);
+
+CREATE TABLE AMPLIFICATION_SINGLEREAD_AUD (
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+	AMPLIFICATION_ID INTEGER NOT NULL,
+    SINGLEREADS_ID INTEGER NOT NULL,
+);
+
 CREATE CACHED TABLE PUBLIC.ANNOTATION(
     ID INTEGER NOT NULL,
     CREATED TIMESTAMP,
@@ -366,6 +466,12 @@ CREATE CACHED TABLE PUBLIC.CDMMETADATA(
     CREATEDBY_ID INTEGER
 );
 -- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;
+CREATE CACHED TABLE PUBLIC.CDMPREFERENCES(
+    SUBJECT VARCHAR(255),
+    PREDICATE VARCHAR(255),
+    VALUE VARCHAR(1023)
+);
+-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;
 CREATE CACHED TABLE PUBLIC.CLASSIFICATION(
     ID INTEGER NOT NULL,
     CREATED TIMESTAMP,
@@ -491,6 +597,73 @@ CREATE CACHED TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD(
     ROOTNODES_ID INTEGER NOT NULL,
     REVTYPE TINYINT
 );
+
+CREATE TABLE PUBLIC.CLONING (
+	ID INTEGER NOT NULL,
+    UUID VARCHAR(36),
+    CREATED TIMESTAMP,
+    UPDATED TIMESTAMP,
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    DESCRIPTION VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+	STRAIN VARCHAR(255),
+    METHOD_ID INTEGER,
+    ACTOR_ID INTEGER,
+    FORWARDPRIMER_ID INTEGER,
+    REVERSEPRIMER_ID INTEGER,
+    PRIMARY KEY (ID)
+);
+
+CREATE TABLE PUBLIC.CLONING_AUD (
+	ID INTEGER NOT NULL,
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+    DESCRIPTION VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+	METHOD_ID INTEGER,
+    STRAIN VARCHAR(255),
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    ACTOR_ID INTEGER,
+    FORWARDPRIMER_ID INTEGER,
+    REVERSEPRIMER_ID INTEGER
+);
+
+
+CREATE TABLE PUBLIC.CLONING_ANNOTATION (
+    CLONING_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL,
+    PRIMARY KEY (CLONING_ID, ANNOTATIONS_ID)
+);
+
+CREATE TABLE PUBLIC.CLONING_ANNOTATION_AUD (
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    CLONING_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL
+);
+
+CREATE TABLE PUBLIC.CLONING_MARKER (
+    CLONING_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL,
+    PRIMARY KEY (CLONING_ID, MARKERS_ID)
+);
+
+CREATE TABLE PUBLIC.CLONING_MARKER_AUD (
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    CLONING_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL
+);
+
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_TAXONNODE_AUD;
 CREATE CACHED TABLE PUBLIC.COLLECTION(
     ID INTEGER NOT NULL,
@@ -683,6 +856,8 @@ CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    TERMTYPE VARCHAR(4),
+    IDINVOCABULARY VARCHAR(255),
     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
@@ -690,9 +865,9 @@ CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN NOT NULL,
     TITLECACHE VARCHAR(255),
-    URI VARCHAR(255),
+    URI CLOB,
     ISO639_1 VARCHAR(2),
-    ISO639_2 VARCHAR(3),
+    RANKCLASS VARCHAR(4) NOT NULL,
     ISTECHNICAL BOOLEAN,
     ORDERINDEX INTEGER,
     SYMMETRICAL BOOLEAN,
@@ -731,6 +906,8 @@ CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    TERMTYPE VARCHAR(4),
+    IDINVOCABULARY VARCHAR(255),
     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
@@ -738,7 +915,7 @@ CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),
-    URI VARCHAR(255),
+    URI CLOB,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     KINDOF_ID INTEGER,
@@ -746,7 +923,7 @@ CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(
     VOCABULARY_ID INTEGER,
     ORDERINDEX INTEGER,
     ISO639_1 VARCHAR(2),
-    ISO639_2 VARCHAR(3),
+    RANKCLASS VARCHAR(4) NOT NULL,
     SUPPORTSCATEGORICALDATA BOOLEAN,
     SUPPORTSCOMMONTAXONNAME BOOLEAN,
     SUPPORTSDISTRIBUTION BOOLEAN,
@@ -1013,6 +1190,7 @@ CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE(
     IMAGEGALLERY BOOLEAN NOT NULL,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
+    SPECIMEN_ID INTEGER,
     TAXON_ID INTEGER,
     TAXONNAME_ID INTEGER
 );
@@ -1035,6 +1213,7 @@ CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_AUD(
     IMAGEGALLERY BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
+    SPECIMEN_ID INTEGER,
     TAXON_ID INTEGER,
     TAXONNAME_ID INTEGER
 );
@@ -1161,26 +1340,17 @@ CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE_AUD(
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SCOPE_AUD;
-CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE(
-    DESCRIPTIONS_ID INTEGER NOT NULL,
-    DESCRIBEDSPECIMENOROBSERVATIONS_ID INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE;
-CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD(
-    REV INTEGER NOT NULL,
-    DESCRIPTIONS_ID INTEGER NOT NULL,
-    DESCRIBEDSPECIMENOROBSERVATIONS_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD;
 CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE(
     DTYPE VARCHAR(31) NOT NULL,
     ID INTEGER NOT NULL,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
-    ORDERRELEVANT BOOLEAN,
     NAME VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    ORDERRELEVANT BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     FEATURE_ID INTEGER,
@@ -1202,6 +1372,11 @@ CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    NAME VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    ORDERRELEVANT BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     FEATURE_ID INTEGER,
@@ -1212,9 +1387,7 @@ CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD(
     UNIT_ID INTEGER,
     FORMAT_ID INTEGER,
     ASSOCIATEDSPECIMENOROBSERVATION_ID INTEGER,
-    NAME VARCHAR(255),
-    LANGUAGE_ID INTEGER,
-    ORDERRELEVANT BOOLEAN
+    LANGUAGE_ID INTEGER
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_AUD;
 CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION(
@@ -1309,13 +1482,13 @@ CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD(
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
 CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(
     DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
-    STATES_ID INTEGER NOT NULL
+    STATEDATA_ID INTEGER NOT NULL
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA;
 CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(
     REV INTEGER NOT NULL,
     DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
-    STATES_ID INTEGER NOT NULL,
+    STATEDATA_ID INTEGER NOT NULL,
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD;
@@ -1437,6 +1610,7 @@ CREATE CACHED TABLE PUBLIC.FEATURENODE(
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SORTINDEX INTEGER,
+    TREEINDEX VARCHAR(255),
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     FEATURE_ID INTEGER,
@@ -1452,6 +1626,7 @@ CREATE CACHED TABLE PUBLIC.FEATURENODE_AUD(
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SORTINDEX INTEGER,
+    TREEINDEX VARCHAR(255),
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     FEATURE_ID INTEGER,
@@ -1495,7 +1670,7 @@ CREATE CACHED TABLE PUBLIC.FEATURETREE(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN NOT NULL,
     TITLECACHE VARCHAR(255),
-    URI VARCHAR(255),
+    URI CLOB,
     DESCRIPTIONSEPARATED BOOLEAN NOT NULL,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
@@ -1516,7 +1691,7 @@ CREATE CACHED TABLE PUBLIC.FEATURETREE_AUD(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),
-    URI VARCHAR(255),
+    URI CLOB,
     DESCRIPTIONSEPARATED BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
@@ -1619,10 +1794,15 @@ CREATE CACHED TABLE PUBLIC.GATHERINGEVENT(
     TIMEPERIOD_FREETEXT VARCHAR(255),
     TIMEPERIOD_START VARCHAR(255),
     ABSOLUTEELEVATION INTEGER,
-    ABSOLUTEELEVATIONERROR INTEGER,
+    ABSOLUTEELEVATIONMAX INTEGER,
+    ABSOLUTEELEVATIONTEXT VARCHAR(30),
     COLLECTINGMETHOD VARCHAR(255),
-    DISTANCETOGROUND INTEGER,
-    DISTANCETOWATERSURFACE INTEGER,
+    DISTANCETOGROUND DOUBLE,
+    DISTANCETOGROUNDMAX DOUBLE,
+    DISTANCETOGROUNDTEXT VARCHAR(30),
+    DISTANCETOWATERSURFACE DOUBLE,
+    DISTANCETOWATERSURFACEMAX DOUBLE,
+    DISTANCETOWATERSURFACETEXT VARCHAR(30),
     EXACTLOCATION_ERRORRADIUS INTEGER,
     EXACTLOCATION_LATITUDE DOUBLE,
     EXACTLOCATION_LONGITUDE DOUBLE,
@@ -1646,10 +1826,15 @@ CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_AUD(
     TIMEPERIOD_FREETEXT VARCHAR(255),
     TIMEPERIOD_START VARCHAR(255),
     ABSOLUTEELEVATION INTEGER,
-    ABSOLUTEELEVATIONERROR INTEGER,
+    ABSOLUTEELEVATIONMAX INTEGER,
+    ABSOLUTEELEVATIONTEXT VARCHAR(30),
     COLLECTINGMETHOD VARCHAR(255),
-    DISTANCETOGROUND INTEGER,
-    DISTANCETOWATERSURFACE INTEGER,
+    DISTANCETOGROUND DOUBLE,
+    DISTANCETOGROUNDMAX DOUBLE,
+    DISTANCETOGROUNDTEXT VARCHAR(30),
+    DISTANCETOWATERSURFACE DOUBLE,
+    DISTANCETOWATERSURFACEMAX DOUBLE,
+    DISTANCETOWATERSURFACETEXT VARCHAR(30),
     EXACTLOCATION_ERRORRADIUS INTEGER,
     EXACTLOCATION_LATITUDE DOUBLE,
     EXACTLOCATION_LONGITUDE DOUBLE,
@@ -1697,30 +1882,6 @@ CREATE CACHED TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD(
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.GATHERINGEVENT_MARKER_AUD;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION(
-    ID INTEGER NOT NULL,
-    CREATED TIMESTAMP,
-    UUID VARCHAR(36),
-    UPDATED TIMESTAMP,
-    ACCESSIONNUMBER VARCHAR(255),
-    URI VARCHAR(255),
-    CREATEDBY_ID INTEGER,
-    UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.GENBANKACCESSION_AUD(
-    ID INTEGER NOT NULL,
-    REV INTEGER NOT NULL,
-    REVTYPE TINYINT,
-    CREATED TIMESTAMP,
-    UUID VARCHAR(36),
-    UPDATED TIMESTAMP,
-    ACCESSIONNUMBER VARCHAR(255),
-    URI VARCHAR(255),
-    CREATEDBY_ID INTEGER,
-    UPDATEDBY_ID INTEGER
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.GENBANKACCESSION_AUD;
 CREATE CACHED TABLE PUBLIC.GRANTEDAUTHORITYIMPL(
     ID INTEGER NOT NULL,
     CREATED TIMESTAMP,
@@ -2030,6 +2191,56 @@ CREATE CACHED TABLE PUBLIC.MARKER_AUD(
     UPDATEDBY_ID INTEGER,
     MARKERTYPE_ID INTEGER
 );
+
+CREATE TABLE MATERIALANDMETHOD (
+    ID INTEGER NOT NULL,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+    MATERIALMETHODTERM BINARY(255),
+    MATERIALMETHODTEXT VARCHAR(255),
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    PRIMARY KEY (ID)
+);
+
+CREATE TABLE MATERIALANDMETHOD_AUD (
+    ID INTEGER NOT NULL,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+    MATERIALMETHODTERM BINARY(255),
+    MATERIALMETHODTEXT VARCHAR(255),
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+);
+
+CREATE TABLE MATERIALANDMETHOD_ANNOTATION (
+    MATERIALANDMETHOD_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL,
+    PRIMARY KEY (MATERIALANDMETHOD_ID, ANNOTATIONS_ID)
+);
+
+CREATE TABLE MATERIALANDMETHOD_ANNOTATION_AUD (
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    MATERIALANDMETHOD_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL,
+);
+
+CREATE TABLE MATERIALANDMETHOD_MARKER (
+    MATERIALANDMETHOD_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL,
+    PRIMARY KEY (MATERIALANDMETHOD_ID, MARKERS_ID)
+);
+
+CREATE TABLE MATERIALANDMETHOD_MARKER_AUD (
+    REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
+    MATERIALANDMETHOD_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL,
+);
+
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.MARKER_AUD;
 CREATE CACHED TABLE PUBLIC.MEDIA(
     DTYPE VARCHAR(31) NOT NULL,
@@ -2107,7 +2318,7 @@ CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART(
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SIZE INTEGER,
-    URI VARCHAR(255),
+    URI CLOB,
     DURATION INTEGER,
     HEIGHT INTEGER,
     WIDTH INTEGER,
@@ -2126,7 +2337,7 @@ CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD(
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SIZE INTEGER,
-    URI VARCHAR(255),
+    URI CLOB,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     REPRESENTATION_ID INTEGER,
@@ -2474,6 +2685,7 @@ CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    SOURCETYPE VARCHAR(4) NOT NULL,
     CITATIONMICROREFERENCE VARCHAR(255),
     ORIGINALNAMESTRING VARCHAR(255),
     IDINSOURCE VARCHAR(255),
@@ -2494,6 +2706,7 @@ CREATE CACHED TABLE PUBLIC.ORIGINALSOURCEBASE_AUD(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+   	SOURCETYPE VARCHAR(4) NOT NULL,
     CITATIONMICROREFERENCE VARCHAR(255),
     ORIGINALNAMESTRING VARCHAR(255),
     IDINSOURCE VARCHAR(255),
@@ -2553,6 +2766,7 @@ CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN NOT NULL,
     TITLECACHE VARCHAR(255),
+    STARTNUMBER INTEGER,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     ROOT_ID INTEGER
@@ -2626,6 +2840,7 @@ CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_AUD(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),
+    STARTNUMBER INTEGER,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     ROOT_ID INTEGER
@@ -2753,6 +2968,52 @@ CREATE CACHED TABLE PUBLIC.POLYTOMOUSKEY_TAXON_AUD(
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.POLYTOMOUSKEY_TAXON_AUD;
+
+CREATE TABLE PRIMER (
+    ID INTEGER NOT NULL,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+    LABEL VARCHAR(255),
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    PUBLISHEDIN_ID INTEGER,
+    SEQUENCE_ID INTEGER,
+    PRIMARY KEY (ID)
+);
+CREATE TABLE PRIMER_AUD (
+    ID INTEGER NOT NULL,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+    LABEL VARCHAR(255),
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    PUBLISHEDIN_ID INTEGER,
+    SEQUENCE_ID INTEGER
+);
+
+CREATE TABLE PRIMER_ANNOTATION (
+    PRIMER_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL,
+    PRIMARY KEY (PRIMER_ID, ANNOTATIONS_ID)
+);
+CREATE TABLE PRIMER_ANNOTATION_AUD (
+    PRIMER_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL
+);
+
+CREATE TABLE PRIMER_MARKER (
+    PRIMER_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL,
+    PRIMARY KEY (PRIMER_ID, MARKERS_ID)
+);
+CREATE TABLE PRIMER_MARKER_AUD (
+    PRIMER_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL
+);
+
+
 CREATE CACHED TABLE PUBLIC.REFERENCE(
     DTYPE VARCHAR(31) NOT NULL,
     ID INTEGER NOT NULL,
@@ -2773,6 +3034,7 @@ CREATE CACHED TABLE PUBLIC.REFERENCE(
     EDITOR VARCHAR(255),
     ISBN VARCHAR(255),
     ISSN VARCHAR(255),
+    DOI VARCHAR(255),
     NOMENCLATURALLYRELEVANT BOOLEAN NOT NULL,
     ORGANIZATION VARCHAR(255),
     PAGES VARCHAR(255),
@@ -2785,8 +3047,11 @@ CREATE CACHED TABLE PUBLIC.REFERENCE(
     SERIES VARCHAR(255),
     SERIESPART VARCHAR(255),
     TITLE CLOB,
-    REFTYPE INTEGER,
-    URI VARCHAR(255),
+    ABBREVTITLE VARCHAR(255),
+    ABBREVTITLECACHE CLOB,
+    PROTECTEDABBREVTITLECACHE BOOLEAN,
+    REFTYPE VARCHAR(4),
+    URI CLOB,
     VOLUME VARCHAR(255),
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
@@ -2819,6 +3084,7 @@ CREATE CACHED TABLE PUBLIC.REFERENCE_AUD(
     EDITOR VARCHAR(255),
     ISBN VARCHAR(255),
     ISSN VARCHAR(255),
+    DOI VARCHAR(255),
     NOMENCLATURALLYRELEVANT BOOLEAN,
     ORGANIZATION VARCHAR(255),
     PAGES VARCHAR(255),
@@ -2831,8 +3097,11 @@ CREATE CACHED TABLE PUBLIC.REFERENCE_AUD(
     SERIES VARCHAR(255),
     SERIESPART VARCHAR(255),
     TITLE CLOB,
-    REFTYPE INTEGER,
-    URI VARCHAR(255),
+    ABBREVTITLE VARCHAR(255),
+    ABBREVTITLECACHE CLOB,
+    PROTECTEDABBREVTITLECACHE BOOLEAN,
+    REFTYPE  VARCHAR(4),
+    URI CLOB,
     VOLUME VARCHAR(255),
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
@@ -2999,7 +3268,7 @@ CREATE CACHED TABLE PUBLIC.RIGHTS(
     UPDATED TIMESTAMP,
     TEXT CLOB,
     ABBREVIATEDTEXT VARCHAR(255),
-    URI VARCHAR(255),
+    URI CLOB,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     LANGUAGE_ID INTEGER,
@@ -3016,7 +3285,7 @@ CREATE CACHED TABLE PUBLIC.RIGHTS_AUD(
     UPDATED TIMESTAMP,
     TEXT CLOB,
     ABBREVIATEDTEXT VARCHAR(255),
-    URI VARCHAR(255),
+    URI CLOB,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     LANGUAGE_ID INTEGER,
@@ -3047,172 +3316,173 @@ CREATE CACHED TABLE PUBLIC.RIGHTS_MARKER_AUD(
     MARKERS_ID INTEGER NOT NULL,
     REVTYPE TINYINT
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.RIGHTS_MARKER_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE(
+
+CREATE TABLE SEQUENCE (
     ID INTEGER NOT NULL,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
-    LSID_AUTHORITY VARCHAR(255),
-    LSID_LSID VARCHAR(255),
-    LSID_NAMESPACE VARCHAR(255),
-    LSID_OBJECT VARCHAR(255),
-    LSID_REVISION VARCHAR(255),
-    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
-    TITLECACHE VARCHAR(255),
-    BARCODE BOOLEAN NOT NULL,
-    CITATIONMICROREFERENCE VARCHAR(255),
-    DATESEQUENCED TIMESTAMP,
-    LENGTH INTEGER,
-    SEQUENCE VARCHAR(255),
+    BARCODESEQUENCEPART_LENGTH INTEGER,
+    BARCODESEQUENCEPART_STRING CLOB,
+    BOLDPROCESSID VARCHAR(255),
+    CONSENSUSSEQUENCE_LENGTH INTEGER,
+    CONSENSUSSEQUENCE_STRING CLOB,
+    GENETICACCESSIONNUMBER VARCHAR(255),
+    HAPLOTYPE VARCHAR(255),
+    ISBARCODE BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
-    LOCUS_ID INTEGER,
-    PUBLISHEDIN_ID INTEGER
+    CONTIGFILE_ID INTEGER,
+    DNASAMPLE_ID INTEGER,
+    DNAMARKER_ID INTEGER,
+    PRIMARY KEY (ID)
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE;
-CREATE INDEX PUBLIC.SEQUENCETITLECACHEINDEX ON PUBLIC.SEQUENCE(TITLECACHE);
-CREATE CACHED TABLE PUBLIC.SEQUENCE_AUD(
+CREATE TABLE SEQUENCE_AUD (
     ID INTEGER NOT NULL,
     REV INTEGER NOT NULL,
     REVTYPE TINYINT,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
-    LSID_AUTHORITY VARCHAR(255),
-    LSID_LSID VARCHAR(255),
-    LSID_NAMESPACE VARCHAR(255),
-    LSID_OBJECT VARCHAR(255),
-    LSID_REVISION VARCHAR(255),
-    PROTECTEDTITLECACHE BOOLEAN,
-    TITLECACHE VARCHAR(255),
-    BARCODE BOOLEAN,
-    CITATIONMICROREFERENCE VARCHAR(255),
-    DATESEQUENCED TIMESTAMP,
-    LENGTH INTEGER,
-    SEQUENCE VARCHAR(255),
+    BARCODESEQUENCEPART_LENGTH INTEGER,
+    BARCODESEQUENCEPART_STRING CLOB,
+    BOLDPROCESSID VARCHAR(255),
+    CONSENSUSSEQUENCE_LENGTH INTEGER,
+    CONSENSUSSEQUENCE_STRING CLOB,
+    GENETICACCESSIONNUMBER VARCHAR(255),
+    HAPLOTYPE VARCHAR(255),
+    ISBARCODE BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
-    LOCUS_ID INTEGER,
-    PUBLISHEDIN_ID INTEGER
+    CONTIGFILE_ID INTEGER,
+    DNASAMPLE_ID INTEGER,
+    DNAMARKER_ID INTEGER
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_ANNOTATION(
-    SEQUENCE_ID INTEGER NOT NULL,
-    ANNOTATIONS_ID INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ANNOTATION;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_ANNOTATION_AUD(
-    REV INTEGER NOT NULL,
+
+CREATE TABLE SEQUENCE_ANNOTATION (
     SEQUENCE_ID INTEGER NOT NULL,
     ANNOTATIONS_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
+    PRIMARY KEY (SEQUENCE_ID, ANNOTATIONS_ID)
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ANNOTATION_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_CREDIT(
-    SEQUENCE_ID INTEGER NOT NULL,
-    CREDITS_ID INTEGER NOT NULL,
-    SORTINDEX INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_CREDIT;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_CREDIT_AUD(
-    REV INTEGER NOT NULL,
-    SEQUENCE_ID INTEGER NOT NULL,
-    CREDITS_ID INTEGER NOT NULL,
-    SORTINDEX INTEGER NOT NULL,
-    REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_CREDIT_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_EXTENSION(
-    SEQUENCE_ID INTEGER NOT NULL,
-    EXTENSIONS_ID INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_EXTENSION_AUD(
+CREATE TABLE SEQUENCE_ANNOTATION_AUD (
     REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
     SEQUENCE_ID INTEGER NOT NULL,
-    EXTENSIONS_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
+    ANNOTATIONS_ID INTEGER NOT NULL
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_EXTENSION_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION(
+
+CREATE TABLE SEQUENCE_MARKER (
     SEQUENCE_ID INTEGER NOT NULL,
-    GENBANKACCESSION_ID INTEGER NOT NULL
+    MARKERS_ID INTEGER NOT NULL,
+    PRIMARY KEY (SEQUENCE_ID, MARKERS_ID)
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD(
+CREATE TABLE SEQUENCE_MARKER_AUD (
     REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
     SEQUENCE_ID INTEGER NOT NULL,
-    GENBANKACCESSION_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
+    MARKERS_ID INTEGER NOT NULL
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_GENBANKACCESSION_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER(
+CREATE TABLE SEQUENCE_REFERENCE (
     SEQUENCE_ID INTEGER NOT NULL,
-    MARKERS_ID INTEGER NOT NULL
+    CITATIONS_ID INTEGER NOT NULL,
+    PRIMARY KEY (SEQUENCE_ID, CITATIONS_ID)
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MARKER;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_MARKER_AUD(
+CREATE TABLE SEQUENCE_REFERENCE_AUD (
     REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
     SEQUENCE_ID INTEGER NOT NULL,
-    MARKERS_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
+    CITATIONS_ID INTEGER NOT NULL
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MARKER_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_MEDIA(
+
+CREATE TABLE SEQUENCE_SINGLEREAD (
     SEQUENCE_ID INTEGER NOT NULL,
-    CHROMATOGRAMS_ID INTEGER NOT NULL
+    SINGLEREADS_ID INTEGER NOT NULL,
+    PRIMARY KEY (SEQUENCE_ID, SINGLEREADS_ID)
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MEDIA;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_MEDIA_AUD(
+CREATE TABLE SEQUENCE_SINGLEREAD_AUD (
     REV INTEGER NOT NULL,
+    REVTYPE TINYINT,
     SEQUENCE_ID INTEGER NOT NULL,
-    CHROMATOGRAMS_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
+    SINGLEREADS_ID INTEGER NOT NULL
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_MEDIA_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE(
-    SEQUENCE_ID INTEGER NOT NULL,
-    SOURCES_ID INTEGER NOT NULL
+
+CREATE TABLE SINGLEREAD (
+    ID INTEGER NOT NULL,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+    DESCRIPTION VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+    DIRECTION INTEGER,
+    SEQUENCE_LENGTH INTEGER,
+    SEQUENCE_STRING CLOB,
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    ACTOR_ID INTEGER,
+    AMPLIFICATION_ID INTEGER,
+    MATERIALANDMETHOD_ID INTEGER,
+    PHEROGRAM_ID INTEGER,
+    PRIMER_ID INTEGER,
+    PRIMARY KEY (ID)
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ORIGINALSOURCEBASE;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD(
+CREATE TABLE SINGLEREAD_AUD (
+    ID INTEGER NOT NULL,
     REV INTEGER NOT NULL,
-    SEQUENCE_ID INTEGER NOT NULL,
-    SOURCES_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_REFERENCE(
-    SEQUENCE_ID INTEGER NOT NULL,
-    CITATIONS_ID INTEGER NOT NULL
+    REVTYPE TINYINT,
+    CREATED TIMESTAMP,
+    UUID VARCHAR(36),
+    UPDATED TIMESTAMP,
+    DESCRIPTION VARCHAR(255),
+    TIMEPERIOD_END VARCHAR(255),
+    TIMEPERIOD_FREETEXT VARCHAR(255),
+    TIMEPERIOD_START VARCHAR(255),
+    DIRECTION INTEGER,
+    SEQUENCE_LENGTH INTEGER,
+    SEQUENCE_STRING CLOB,
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    ACTOR_ID INTEGER,
+    AMPLIFICATION_ID INTEGER,
+    MATERIALANDMETHOD_ID INTEGER,
+    PHEROGRAM_ID INTEGER,
+    PRIMER_ID INTEGER
+);
+
+CREATE TABLE SINGLEREAD_ANNOTATION (
+    SINGLEREAD_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL,
+    PRIMARY KEY (SINGLEREAD_ID, ANNOTATIONS_ID)
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_REFERENCE;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_REFERENCE_AUD(
+CREATE TABLE SINGLEREAD_ANNOTATION_AUD (
     REV INTEGER NOT NULL,
-    SEQUENCE_ID INTEGER NOT NULL,
-    CITATIONS_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
+    REVTYPE TINYINT,
+    SINGLEREAD_ID INTEGER NOT NULL,
+    ANNOTATIONS_ID INTEGER NOT NULL
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_REFERENCE_AUD;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_RIGHTS(
-    SEQUENCE_ID INTEGER NOT NULL,
-    RIGHTS_ID INTEGER NOT NULL
+
+CREATE TABLE SINGLEREAD_MARKER (
+    SINGLEREAD_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL,
+    PRIMARY KEY (SINGLEREAD_ID, MARKERS_ID)
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_RIGHTS;
-CREATE CACHED TABLE PUBLIC.SEQUENCE_RIGHTS_AUD(
+
+CREATE TABLE SINGLEREAD_MARKER_AUD (
     REV INTEGER NOT NULL,
-    SEQUENCE_ID INTEGER NOT NULL,
-    RIGHTS_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
+    REVTYPE TINYINT,
+    SINGLEREAD_ID INTEGER NOT NULL,
+    MARKERS_ID INTEGER NOT NULL
 );
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SEQUENCE_RIGHTS_AUD;
+
+
 CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE(
     DTYPE VARCHAR(31) NOT NULL,
     ID INTEGER NOT NULL,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    RECORDBASIS  VARCHAR(4) NOT NULL,
     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
@@ -3220,6 +3490,7 @@ CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN NOT NULL,
     TITLECACHE VARCHAR(255),
+    PUBLISH BOOLEAN,
     INDIVIDUALCOUNT INTEGER,
     ACCESSIONNUMBER VARCHAR(255),
     BARCODE VARCHAR(255),
@@ -3232,12 +3503,14 @@ CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE(
     UPDATEDBY_ID INTEGER,
     LIFESTAGE_ID INTEGER,
     SEX_ID INTEGER,
+    KINDOFUNIT_ID INTEGER,
     COLLECTION_ID INTEGER,
     DERIVEDFROM_ID INTEGER,
     STOREDUNDER_ID INTEGER,
     PRESERVATION_ID INTEGER,
     GATHERINGEVENT_ID INTEGER,
-    PRIMARYCOLLECTOR_ID INTEGER
+    PRIMARYCOLLECTOR_ID INTEGER,
+    MEDIASPECIMEN_ID INTEGER
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE;
 CREATE INDEX PUBLIC.SPECIMENOROBSERVATIONBASETITLECACHEINDEX ON PUBLIC.SPECIMENOROBSERVATIONBASE(TITLECACHE);
@@ -3249,6 +3522,7 @@ CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    RECORDBASIS  VARCHAR(4) NOT NULL,
     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
@@ -3256,24 +3530,27 @@ CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),
+    PUBLISH BOOLEAN,
     INDIVIDUALCOUNT INTEGER,
-    CREATEDBY_ID INTEGER,
-    UPDATEDBY_ID INTEGER,
-    LIFESTAGE_ID INTEGER,
-    SEX_ID INTEGER,
     ACCESSIONNUMBER VARCHAR(255),
     BARCODE VARCHAR(255),
     CATALOGNUMBER VARCHAR(255),
     COLLECTORSNUMBER VARCHAR(255),
+    EXSICCATUM VARCHAR(255),
+    FIELDNOTES VARCHAR(255),
+    FIELDNUMBER VARCHAR(255),
+    CREATEDBY_ID INTEGER,
+    UPDATEDBY_ID INTEGER,
+    LIFESTAGE_ID INTEGER,
+    SEX_ID INTEGER,
+    KINDOFUNIT_ID INTEGER,
     COLLECTION_ID INTEGER,
     DERIVEDFROM_ID INTEGER,
     STOREDUNDER_ID INTEGER,
-    EXSICCATUM VARCHAR(255),
     PRESERVATION_ID INTEGER,
-    FIELDNOTES VARCHAR(255),
-    FIELDNUMBER VARCHAR(255),
     GATHERINGEVENT_ID INTEGER,
-    PRIMARYCOLLECTOR_ID INTEGER
+    PRIMARYCOLLECTOR_ID INTEGER,
+    MEDIASPECIMEN_ID INTEGER
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_AUD;
 CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION(
@@ -3352,18 +3629,6 @@ CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD(
     REVTYPE TINYINT
 );
 -- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD;
-CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA(
-    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
-    MEDIA_ID INTEGER NOT NULL
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA;
-CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD(
-    REV INTEGER NOT NULL,
-    SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
-    MEDIA_ID INTEGER NOT NULL,
-    REVTYPE TINYINT
-);
--- 0 +/- SELECT COUNT(*) FROM PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD;
 CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE(
     SPECIMENOROBSERVATIONBASE_ID INTEGER NOT NULL,
     SOURCES_ID INTEGER NOT NULL
@@ -3561,6 +3826,7 @@ CREATE CACHED TABLE PUBLIC.TAXONBASE(
     TITLECACHE VARCHAR(255),
     APPENDEDPHRASE VARCHAR(255),
     DOUBTFUL BOOLEAN NOT NULL,
+    PUBLISH BOOLEAN,
     USENAMECACHE BOOLEAN NOT NULL,
     EXCLUDED BOOLEAN,
     TAXONSTATUSUNKNOWN BOOLEAN,
@@ -3591,6 +3857,7 @@ CREATE CACHED TABLE PUBLIC.TAXONBASE_AUD(
     TITLECACHE VARCHAR(255),
     APPENDEDPHRASE VARCHAR(255),
     DOUBTFUL BOOLEAN,
+    PUBLISH BOOLEAN,
     USENAMECACHE BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
@@ -3899,6 +4166,8 @@ CREATE CACHED TABLE PUBLIC.TAXONNODE(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    SORTINDEX INTEGER,
+    TREEINDEX VARCHAR(255),
     COUNTCHILDREN INTEGER NOT NULL,
     MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
     CREATEDBY_ID INTEGER,
@@ -3917,6 +4186,8 @@ CREATE CACHED TABLE PUBLIC.TAXONNODE_AUD(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    SORTINDEX INTEGER,
+    TREEINDEX VARCHAR(255),
     COUNTCHILDREN INTEGER,
     MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
     CREATEDBY_ID INTEGER,
@@ -4016,6 +4287,7 @@ CREATE CACHED TABLE PUBLIC.TERMVOCABULARY(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    TERMTYPE VARCHAR(4),
     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
@@ -4023,8 +4295,8 @@ CREATE CACHED TABLE PUBLIC.TERMVOCABULARY(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN NOT NULL,
     TITLECACHE VARCHAR(255),
-    URI VARCHAR(255),
-    TERMSOURCEURI VARCHAR(255),
+    URI CLOB,
+    TERMSOURCEURI CLOB,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER
 );
@@ -4037,6 +4309,7 @@ CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_AUD(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
+    TERMTYPE VARCHAR(4),
     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
@@ -4044,8 +4317,8 @@ CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_AUD(
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),
-    URI VARCHAR(255),
-    TERMSOURCEURI VARCHAR(255),
+    URI CLOB,
+    TERMSOURCEURI CLOB,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER
 );
@@ -4150,7 +4423,6 @@ CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE(
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     CITATION_ID INTEGER,
-    HOMOTYPICALGROUP_ID INTEGER,
     TYPESTATUS_ID INTEGER,
     TYPENAME_ID INTEGER,
     TYPESPECIMEN_ID INTEGER
@@ -4170,7 +4442,6 @@ CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD(
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     CITATION_ID INTEGER,
-    HOMOTYPICALGROUP_ID INTEGER,
     TYPESTATUS_ID INTEGER,
     CONSERVEDTYPE BOOLEAN,
     REJECTEDTYPE BOOLEAN,
@@ -4332,698 +4603,688 @@ CREATE CACHED TABLE PUBLIC.HIBERNATE_SEQUENCES(
     NEXT_VAL BIGINT
 );
 -- 8 +/- SELECT COUNT(*) FROM PUBLIC.HIBERNATE_SEQUENCES;
-ALTER TABLE PUBLIC.TAXONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_F6B PRIMARY KEY(TAXONBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_7E7 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FD6F PRIMARY KEY(REV, HOMOTYPICALGROUP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BCD PRIMARY KEY(REV, TYPEDESIGNATIONBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_7E6 PRIMARY KEY(SEQUENCE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.CONSTRAINT_340 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_346 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_341 PRIMARY KEY(POLYTOMOUSKEY_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BCB PRIMARY KEY(REV, WORKINGSET_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_BC2 PRIMARY KEY(TAXONBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_33F PRIMARY KEY(REV, GATHERINGEVENT_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_7D7 PRIMARY KEY(TAXONNAMEBASE_ID, STATUS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT ADD CONSTRAINT PUBLIC.CONSTRAINT_BAC PRIMARY KEY(DEFINEDTERMBASE_ID, CONTINENTS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BAD PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, SEQUENCES_ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_BB0 PRIMARY KEY(DETERMINATIONEVENT_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_33C PRIMARY KEY(REV, TAXONNAMEBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_FD PRIMARY KEY(DEFINEDTERMBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_185 PRIMARY KEY(TAXONBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_36E PRIMARY KEY(TERMVOCABULARY_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_FE PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MEDIA_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_15A PRIMARY KEY(MEDIA_ID, SORTINDEX);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C76 PRIMARY KEY(REV, HYBRIDRELATIONSHIP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_C81 PRIMARY KEY(NAMERELATIONSHIP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D97 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.MEDIA_DESCRIPTION ADD CONSTRAINT PUBLIC.CONSTRAINT_D9A PRIMARY KEY(MEDIA_ID, DESCRIPTION_MAPKEY_ID);
-ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D9D PRIMARY KEY(REV, SEQUENCE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_371 PRIMARY KEY(TERMVOCABULARY_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BA5 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.CREDIT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BE3 PRIMARY KEY(REV, CREDIT_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_7FE PRIMARY KEY(TAXONRELATIONSHIP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_5A4 PRIMARY KEY(REV, WORKINGSET_ID, GEOGRAPHICALSCOPE_ID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_5A2 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BE6 PRIMARY KEY(REV, ANNOTATION_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_909E PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, DESCRIPTION_MAPKEY_ID);
-ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2CE PRIMARY KEY(REV, SEQUENCE_ID, CHROMATOGRAMS_ID);
-ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_BE0 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BA2 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMEASUREMENTUNITS_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F37 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F36 PRIMARY KEY(REV, LANGUAGESTRING_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.RIGHTS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_301 PRIMARY KEY(REV, RIGHTS_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.REFERENCE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F43 PRIMARY KEY(REV, REFERENCE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_7A3 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F49 PRIMARY KEY(REV, TAXONNODE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.REPRESENTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_F1F PRIMARY KEY(REPRESENTATION_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.HIBERNATE_SEQUENCES ADD CONSTRAINT PUBLIC.CONSTRAINT_59A PRIMARY KEY(SEQUENCE_NAME);
-ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_30E PRIMARY KEY(TERMVOCABULARY_ID, REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9D7 PRIMARY KEY(REV, TERMVOCABULARY_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.CONSTRAINT_557 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_550 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.FEATURETREE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9E6 PRIMARY KEY(REV, FEATURETREE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_9E5 PRIMARY KEY(POLYTOMOUSKEY_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_314 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_599 PRIMARY KEY(AGENTBASE_ID, TYPES_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_ECE PRIMARY KEY(REV, TAXONNAMEBASE_ID, STATUS_ID);
-ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_32A PRIMARY KEY(STATISTICALMEASUREMENTVALUE_ID, MODIFIERS_ID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_EEB PRIMARY KEY(REV, TYPEDESIGNATIONBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9E0 PRIMARY KEY(REV, SEQUENCE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.MULTIACCESSKEY_TAXON ADD CONSTRAINT PUBLIC.CONSTRAINT_7C6 PRIMARY KEY(MULTIACCESSKEY_ID, TAXON_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2C1 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_2BE PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_2B2 PRIMARY KEY(POLYTOMOUSKEY_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_2B4 PRIMARY KEY(POLYTOMOUSKEY_ID, COVEREDTAXA_ID);
-ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_ED7 PRIMARY KEY(TAXONNODE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.MEDIAKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.CONSTRAINT_F33 PRIMARY KEY(MEDIA_ID, GEOGRAPHICALSCOPE_ID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_7B1 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_ED2 PRIMARY KEY(TAXONNAMEBASE_ID, TYPEDESIGNATIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2CD PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_ECC PRIMARY KEY(HYBRIDRELATIONSHIP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_2E2 PRIMARY KEY(TERMVOCABULARY_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F5F5 PRIMARY KEY(REV, TAXONBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_2F2 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_360 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_2C5 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_154 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.COLLECTION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_D48 PRIMARY KEY(COLLECTION_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B599 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_C24 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.REFERENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_C22 PRIMARY KEY(REFERENCE_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_BE63 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, SEQUENCES_ID);
-ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_C10 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_718 PRIMARY KEY(REV, REPRESENTATION_ID, ID, SORTINDEX);
-ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C29 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_CA PRIMARY KEY(REV, DEFINEDTERMBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_CB PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DERIVATIONEVENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_CC PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.FEATURETREE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_CE PRIMARY KEY(REV, FEATURETREE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_CF PRIMARY KEY(COLLECTION_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.COLLECTION_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_DA PRIMARY KEY(REV, COLLECTION_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D3 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MODIFIERS_ID);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_D4B PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D0 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_726 PRIMARY KEY(SEQUENCE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D63 PRIMARY KEY(REV, STATEDATA_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F PRIMARY KEY(SEQUENCE_ID, GENBANKACCESSION_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4D PRIMARY KEY(TERMVOCABULARY_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_550F PRIMARY KEY(REV, SEQUENCE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_69EA PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_C0F PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C47 PRIMARY KEY(REV, MEDIA_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D56 PRIMARY KEY(REV, TAXONNAMEBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C63 PRIMARY KEY(SYNONYMRELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_818 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_D80 PRIMARY KEY(POLYTOMOUSKEY_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D2A PRIMARY KEY(REV, TAXONNAMEBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_71C PRIMARY KEY(REFERENCE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D2F PRIMARY KEY(REV, TAXONNAMEBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_729 PRIMARY KEY(KEYSTATEMENT_ID, LABEL_MAPKEY_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D96 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D2 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, DESCRIPTION_ID, DESCRIPTION_MAPKEY_ID);
-ALTER TABLE PUBLIC.FEATURETREE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_F0 PRIMARY KEY(FEATURETREE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D4 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_F2 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F3 PRIMARY KEY(REV, COLLECTION_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_EC PRIMARY KEY(CLASSIFICATION_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_ED PRIMARY KEY(DESCRIPTIONBASE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.COLLECTION_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_EE PRIMARY KEY(COLLECTION_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FA PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FB PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.RIGHTS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_14B PRIMARY KEY(RIGHTS_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_F9 PRIMARY KEY(FEATURETREE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_368 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_F5 PRIMARY KEY(CLASSIFICATION_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F4 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, CONTINENTS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_F7 PRIMARY KEY(CLASSIFICATION_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.MEDIA_TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F6 PRIMARY KEY(REV, MEDIA_ID, COVEREDTAXA_ID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D5 PRIMARY KEY(REV, NAMERELATIONSHIP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FF PRIMARY KEY(REV, ORIGINALSOURCEBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_F1 PRIMARY KEY(AGENTBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_E8 PRIMARY KEY(AGENTBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_D7 PRIMARY KEY(CLASSIFICATION_ID, ROOTNODES_ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_D6 PRIMARY KEY(REV, DETERMINATIONEVENT_ID, SETOFREFERENCES_ID);
-ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_D9 PRIMARY KEY(DERIVATIONEVENT_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_FDC7 PRIMARY KEY(TAXONNAMEBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E2 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_E0 PRIMARY KEY(FEATURETREE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.COLLECTION_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_DD PRIMARY KEY(COLLECTION_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_E5 PRIMARY KEY(DESCRIPTIONBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_DB PRIMARY KEY(DEFINEDTERMBASE_ID, SUPPORTEDCATEGORICALENUMERATIONS_ID);
-ALTER TABLE PUBLIC.MEDIA_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_65C7 PRIMARY KEY(REV, MEDIA_ID, KEYREPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_DF PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_EB PRIMARY KEY(POLYTOMOUSKEY_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E7 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_FAXNUMBERS_ELEMENT);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E3 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.CONSTRAINT_E9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_DE PRIMARY KEY(REV, CLASSIFICATION_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_542 PRIMARY KEY(LANGUAGESTRING_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_DC PRIMARY KEY(CLASSIFICATION_ID, SORTINDEX);
-ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_F0C PRIMARY KEY(LANGUAGESTRING_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_AE9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_8DC PRIMARY KEY(TYPEDESIGNATIONBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F0 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AE8 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_AE5 PRIMARY KEY(DEFINEDTERMBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_539 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_43D PRIMARY KEY(GATHERINGEVENT_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.LOCUS ADD CONSTRAINT PUBLIC.CONSTRAINT_453 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.TAXONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_91D PRIMARY KEY(REV, TAXONBASE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.COLLECTION_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AD9 PRIMARY KEY(REV, COLLECTION_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_444 PRIMARY KEY(FEATURETREE_ID, REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.WORKINGSET_TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_8B0 PRIMARY KEY(REV, WORKINGSET_ID, COVEREDTAXA_ID);
-ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_63FF PRIMARY KEY(GATHERINGEVENT_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.WORKINGSET_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_8BD PRIMARY KEY(REV, WORKINGSET_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_43B PRIMARY KEY(REV, ORIGINALSOURCEBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_509 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MULTILANGUAGETEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.MEDIA_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_448 PRIMARY KEY(MEDIA_ID, USEDSEQUENCES_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_6887 PRIMARY KEY(REV, ORIGINALS_ID, DERIVATIONEVENTS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_FF4 PRIMARY KEY(TAXONBASE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.MEDIA_DESCRIPTION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_952 PRIMARY KEY(REV, MEDIA_ID, DESCRIPTION_ID, DESCRIPTION_MAPKEY_ID);
-ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_56B6 PRIMARY KEY(TAXONBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FFF PRIMARY KEY(REV, TERMVOCABULARY_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_A47 PRIMARY KEY(ORIGINALSOURCEBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_969 PRIMARY KEY(MEDIA_ID, TITLE_MAPKEY_ID);
-ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_A53 PRIMARY KEY(WORKINGSET_ID, DESCRIPTIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_514 PRIMARY KEY(REV, SEQUENCE_ID, CITATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_4D8 PRIMARY KEY(DESCRIPTIONS_ID, DESCRIBEDSPECIMENOROBSERVATIONS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_906 PRIMARY KEY(FEATURETREE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_901 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_909 PRIMARY KEY(REV, MEDIA_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_A1D PRIMARY KEY(TAXONNAMEBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_919 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.LSIDAUTHORITY ADD CONSTRAINT PUBLIC.CONSTRAINT_A44 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_FEATURE ADD CONSTRAINT PUBLIC.CONSTRAINT_435 PRIMARY KEY(DESCRIPTIONBASE_ID, DESCRIPTIVESYSTEM_ID);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_A5F PRIMARY KEY(HOMOTYPICALGROUP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY ADD CONSTRAINT PUBLIC.CONSTRAINT_8B6 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MEDIA_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_2E PRIMARY KEY(MEDIA_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_17 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_18 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_19 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_11 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, DESCRIPTION_MAPKEY_ID);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_12 PRIMARY KEY(SYNONYMRELATIONSHIP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2F PRIMARY KEY(REV, NOMENCLATURALSTATUS_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.MEDIA_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_439 PRIMARY KEY(REV, MEDIA_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_15 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_45D PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_16 PRIMARY KEY(MEDIA_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_1B PRIMARY KEY(POLYTOMOUSKEY_ID, SORTINDEX);
-ALTER TABLE PUBLIC.EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_1D PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT ADD CONSTRAINT PUBLIC.CONSTRAINT_1C PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDMEASUREMENTUNITS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_14 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);
-ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F5F PRIMARY KEY(REV, DERIVATIONEVENT_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.MEDIA_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_13 PRIMARY KEY(REV, MEDIA_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_2B PRIMARY KEY(DEFINEDTERMBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONNODE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_8CB PRIMARY KEY(REV, TAXONNODE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_AFB PRIMARY KEY(TAXONBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXON_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2B4E PRIMARY KEY(REV, POLYTOMOUSKEY_ID, TAXON_ID);
-ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_2A PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.AGENTBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_28 PRIMARY KEY(AGENTBASE_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.CONSTRAINT_29 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_22 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AF1 PRIMARY KEY(REV, TERMVOCABULARY_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_20 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_21 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_26 PRIMARY KEY(REV, NOMENCLATURALSTATUS_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_24 PRIMARY KEY(REV, FEATURETREE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_25 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_30 PRIMARY KEY(REV, GATHERINGEVENT_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_2C PRIMARY KEY(DEFINEDTERMBASE_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_23 PRIMARY KEY(CDM_VIEW_ID, SUPERVIEWS_ID);
-ALTER TABLE PUBLIC.ANNOTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_953 PRIMARY KEY(ANNOTATION_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_282 PRIMARY KEY(HYBRIDRELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_A65 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E64 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E65 PRIMARY KEY(REV, FEATURETREE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_23A PRIMARY KEY(ORIGINALS_ID, DERIVATIONEVENTS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_239 PRIMARY KEY(REV, CLASSIFICATION_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FF0 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.REFERENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_244 PRIMARY KEY(REV, REFERENCE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_247 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E5B PRIMARY KEY(REV, POLYTOMOUSKEY_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_242 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_988 PRIMARY KEY(TAXONRELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FD0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_25D PRIMARY KEY(MEDIA_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_FD6 PRIMARY KEY(DESCRIPTIONBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_984 PRIMARY KEY(COLLECTION_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.RIGHTS_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FD2 PRIMARY KEY(REV, RIGHTS_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_225 PRIMARY KEY(USERACCOUNT_ID, GRANTEDAUTHORITIES_ID);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_657 PRIMARY KEY(REV, SYNONYMRELATIONSHIP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C3CB PRIMARY KEY(TERMVOCABULARY_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.FEATURENODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9FE PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_56B PRIMARY KEY(DERIVATIONEVENT_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_56A PRIMARY KEY(REV, TAXONNAMEBASE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.MEDIA_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_564 PRIMARY KEY(REV, MEDIA_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_560 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_BF7 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.REFERENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_599C PRIMARY KEY(REFERENCE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_E92 PRIMARY KEY(REFERENCE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B49 PRIMARY KEY(REV, TERMVOCABULARY_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E70 PRIMARY KEY(REV, STATISTICALMEASUREMENTVALUE_ID, MODIFIERS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E8A PRIMARY KEY(REV, AGENTBASE_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.REPRESENTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_E8B PRIMARY KEY(REPRESENTATION_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E8C PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MEDIA_ID, SORTINDEX);
-ALTER TABLE PUBLIC.STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_60B PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_656 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, DEFINITION_ID, DEFINITION_MAPKEY_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_B36 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E3C PRIMARY KEY(REV, TAXONBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C81E PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_98E PRIMARY KEY(TAXONNAMEBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE ADD CONSTRAINT PUBLIC.CONSTRAINT_A85 PRIMARY KEY(FEATURENODE_ID, ONLYAPPLICABLEIF_ID);
-ALTER TABLE PUBLIC.WORKINGSET_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B92 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_B5D PRIMARY KEY(NOMENCLATURALSTATUS_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A82 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_A70 PRIMARY KEY(DESCRIPTIONBASE_ID, GEOSCOPES_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_B59 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5FC PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B5A PRIMARY KEY(REV, POLYTOMOUSKEY_ID, COVEREDTAXA_ID);
-ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_B62 PRIMARY KEY(TAXONNODE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_5F7 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_5F6 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A5E PRIMARY KEY(REV, POLYTOMOUSKEYNODE_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.CONSTRAINT_94C PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FA8 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_A5C PRIMARY KEY(DESCRIPTIONBASE_ID, DESCRIPTIONSOURCES_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_B86 PRIMARY KEY(DESCRIPTIONBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.MULTIACCESSKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FDE PRIMARY KEY(REV, WORKINGSET_ID, SCOPERESTRICTIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXON ADD CONSTRAINT PUBLIC.CONSTRAINT_B77 PRIMARY KEY(POLYTOMOUSKEY_ID, TAXON_ID);
-ALTER TABLE PUBLIC.REFERENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FDC PRIMARY KEY(REV, REFERENCE_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_60C PRIMARY KEY(DEFINEDTERMBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2864 PRIMARY KEY(REV, STATEDATA_ID, MODIFIERS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A9D PRIMARY KEY(REV, SEQUENCE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.MEDIA_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FE4 PRIMARY KEY(REV, MEDIA_ID, USEDSEQUENCES_ID);
-ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_EC9 PRIMARY KEY(WORKINGSET_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_4F7 PRIMARY KEY(TYPEDESIGNATIONBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_FB3 PRIMARY KEY(REV, HYBRIDRELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_286 PRIMARY KEY(REV, CLASSIFICATION_ID, ROOTNODES_ID);
-ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_B9F PRIMARY KEY(FEATURETREE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_9EB PRIMARY KEY(SEQUENCE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.RIGHTS_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5DE PRIMARY KEY(RIGHTS_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_A96 PRIMARY KEY(DEFINEDTERMBASE_ID, INVERSEREPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.MEDIA_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A7B PRIMARY KEY(REV, MEDIA_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A7D PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_EB6 PRIMARY KEY(TAXONNAMEBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C34 PRIMARY KEY(REV, NAMERELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_88C PRIMARY KEY(SEQUENCE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_807 PRIMARY KEY(SEQUENCE_ID, CHROMATOGRAMS_ID);
-ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_E PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_DAF PRIMARY KEY(REV, WORKINGSET_ID, DESCRIPTIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A9 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_5A PRIMARY KEY(REV, DEFINEDTERMBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_6D PRIMARY KEY(REV, LANGUAGESTRING_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_A8 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_53 PRIMARY KEY(REV, AGENTBASE_ID, TYPES_ID);
-ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_1D0 PRIMARY KEY(REV, KEYSTATEMENT_ID, LABEL_ID, LABEL_MAPKEY_ID);
-ALTER TABLE PUBLIC.CREDIT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_54 PRIMARY KEY(REV, CREDIT_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_58 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, SCOPES_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_56 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, SUPPORTEDCATEGORICALENUMERATIONS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BD PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_A2 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A7 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.COLLECTION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_6E PRIMARY KEY(REV, COLLECTION_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_55 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_71 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, GEOSCOPES_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_FEATURE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3D PRIMARY KEY(REV, DESCRIPTIONBASE_ID, DESCRIPTIVESYSTEM_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.CONSTRAINT_5A24 PRIMARY KEY(POLYTOMOUSKEY_ID, GEOGRAPHICALSCOPE_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_3C PRIMARY KEY(POLYTOMOUSKEYNODE_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.MEDIA_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_6B PRIMARY KEY(MEDIA_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_6A PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_66 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_67 PRIMARY KEY(REV, SYNONYMRELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_68 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_65 PRIMARY KEY(DESCRIPTIONBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_6F PRIMARY KEY(REV, DESCRIPTIONBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_69 PRIMARY KEY(DEFINEDTERMBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_72 PRIMARY KEY(REV, DERIVATIONEVENT_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_DC8 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_88B PRIMARY KEY(TAXONNAMEBASE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_64 PRIMARY KEY(REV, TERMVOCABULARY_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.CONSTRAINT_CA5 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_1E1 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MEDIAREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_557C PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_3AA PRIMARY KEY(MEDIA_ID, SCOPERESTRICTIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A4 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, DESCRIPTIONSOURCES_ID);
-ALTER TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_3AC PRIMARY KEY(STATEDATA_ID, MODIFIERS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_D PRIMARY KEY(AGENTBASE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.CDMMETADATA ADD CONSTRAINT PUBLIC.CONSTRAINT_87 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_86 PRIMARY KEY(DETERMINATIONEVENT_ID, SETOFREFERENCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_8E PRIMARY KEY(SEQUENCE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.REFERENCE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_88 PRIMARY KEY(REV, REFERENCE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_8C PRIMARY KEY(REV, SEQUENCE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_8B PRIMARY KEY(REV, POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
-ALTER TABLE PUBLIC.REFERENCE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_8A PRIMARY KEY(REFERENCE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_87CF PRIMARY KEY(MEDIA_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_8F PRIMARY KEY(REV, CLASSIFICATION_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_95 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_PHONENUMBERS_ELEMENT);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_8D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A5 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);
-ALTER TABLE PUBLIC.KEYSTATEMENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A6 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_698 PRIMARY KEY(REV, TAXONNAMEBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3A PRIMARY KEY(REV, DEFINEDTERMBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.COLLECTION_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_60 PRIMARY KEY(REV, COLLECTION_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_A1 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MULTILANGUAGETEXT_ID, MULTILANGUAGETEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_63 PRIMARY KEY(DESCRIPTIONBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_CA4 PRIMARY KEY(TAXONNAMEBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_CONTACT_URLS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_5C PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_URLS_ELEMENT);
-ALTER TABLE PUBLIC.TAXONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_6B24 PRIMARY KEY(REV, TAXONBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_5F PRIMARY KEY(REV, DEFINEDTERMBASE_ID, REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_61 PRIMARY KEY(REV, TAXONBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_1DF PRIMARY KEY(TERMVOCABULARY_ID, SORTINDEX);
-ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.CONSTRAINT_69E PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_DB5 PRIMARY KEY(REV, DESCRIPTIONS_ID, DESCRIBEDSPECIMENOROBSERVATIONS_ID);
-ALTER TABLE PUBLIC.USERACCOUNT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_850 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.MEDIAKEY_TAXON ADD CONSTRAINT PUBLIC.CONSTRAINT_3AB PRIMARY KEY(MEDIAKEY_ID, TAXON_ID);
-ALTER TABLE PUBLIC.DERIVATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_83E PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_DDD PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3F PRIMARY KEY(REV, FEATURENODE_ID, ONLYAPPLICABLEIF_ID);
-ALTER TABLE PUBLIC.MEDIA_TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_AA PRIMARY KEY(MEDIA_ID, COVEREDTAXA_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_WATERBODYORCOUNTRY_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_96 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, WATERBODIESORCOUNTRIES_ID);
-ALTER TABLE PUBLIC.WORKINGSET_TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_CAA PRIMARY KEY(WORKINGSET_ID, COVEREDTAXA_ID);
-ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C9 PRIMARY KEY(REV, WORKINGSET_ID, REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AF PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.COLLECTION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_AD PRIMARY KEY(REV, COLLECTION_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C8 PRIMARY KEY(REV, DETERMINATIONEVENT_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3DF PRIMARY KEY(REV, SEQUENCE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_AB PRIMARY KEY(MEMBERS_ID, GROUPS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_4A PRIMARY KEY(REV, TAXONBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.CONSTRAINT_CC2 PRIMARY KEY(WORKINGSET_ID, GEOGRAPHICALSCOPE_ID);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_879 PRIMARY KEY(NOMENCLATURALSTATUS_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C7 PRIMARY KEY(REV, GATHERINGEVENT_ID, COLLECTINGAREAS_ID);
-ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF ADD CONSTRAINT PUBLIC.CONSTRAINT_AC PRIMARY KEY(FEATURENODE_ID, INAPPLICABLEIF_ID);
-ALTER TABLE PUBLIC.AGENTBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B9 PRIMARY KEY(REV, AGENTBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C0 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.COLLECTION ADD CONSTRAINT PUBLIC.CONSTRAINT_B5 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BF PRIMARY KEY(REV, CLASSIFICATION_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_86A PRIMARY KEY(REV, TERMVOCABULARY_ID, REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.REPRESENTATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3DC PRIMARY KEY(REV, REPRESENTATION_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_BE PRIMARY KEY(AGENTBASE_ID, CONTACT_ADDRESSES_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B8 PRIMARY KEY(REV, AGENTBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_BC PRIMARY KEY(HOMOTYPICALGROUP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_48 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATES_ID);
-ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_B1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_B6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_B7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B4 PRIMARY KEY(REV, AGENTBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_BA PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_EMAILADDRESSES_ELEMENT);
-ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_C6 PRIMARY KEY(STATEDATA_ID, MODIFYINGTEXT_MAPKEY_ID);
-ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_4F PRIMARY KEY(REV, MEDIA_ID, TITLE_ID, TITLE_MAPKEY_ID);
-ALTER TABLE PUBLIC.CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_C5 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MEDIAKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_DBEE PRIMARY KEY(REV, MEDIA_ID, GEOGRAPHICALSCOPE_ID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_3EB PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_39 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.MEDIAKEY_TAXON_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E05 PRIMARY KEY(REV, MEDIAKEY_ID, TAXON_ID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3CC PRIMARY KEY(REV, TAXONRELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.ANNOTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_4D PRIMARY KEY(REV, ANNOTATION_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_36 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_35 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_E02 PRIMARY KEY(REV, FEATURETREE_ID, REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_WATERBODYORCOUNTRY ADD CONSTRAINT PUBLIC.CONSTRAINT_DBE PRIMARY KEY(DEFINEDTERMBASE_ID, WATERBODIESORCOUNTRIES_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER ADD CONSTRAINT PUBLIC.CONSTRAINT_31 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MODIFIERS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_32 PRIMARY KEY(REV, FEATURETREE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_33 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.COLLECTION_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_34 PRIMARY KEY(REV, COLLECTION_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_37 PRIMARY KEY(REV, TAXONRELATIONSHIP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_4E PRIMARY KEY(REFERENCE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_43 PRIMARY KEY(REV, CLASSIFICATION_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_3E8 PRIMARY KEY(WORKINGSET_ID, REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3D9 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.COLLECTION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_C4 PRIMARY KEY(COLLECTION_ID, SORTINDEX);
-ALTER TABLE PUBLIC.MEDIA_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_46 PRIMARY KEY(MEDIA_ID, KEYREPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3E PRIMARY KEY(REV, DETERMINATIONEVENT_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_45 PRIMARY KEY(REV, HOMOTYPICALGROUP_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_3E3 PRIMARY KEY(REV, TAXONNAMEBASE_ID, TYPEDESIGNATIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_52 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, MEDIA_ID);
-ALTER TABLE PUBLIC.AGENTBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_44 PRIMARY KEY(AGENTBASE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_50 PRIMARY KEY(DEFINEDTERMBASE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C3 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, DESCRIPTION_ID, DESCRIPTION_MAPKEY_ID);
-ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C2 PRIMARY KEY(REV, FEATURETREE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_871 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_CC8 PRIMARY KEY(GATHERINGEVENT_ID, COLLECTINGAREAS_ID);
-ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C1 PRIMARY KEY(REV, REFERENCE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_51 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, INVERSEREPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ADDRESS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_ADDRESSES_ID);
-ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_E26 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_93 PRIMARY KEY(FEATURETREE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.AUDITEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_8 PRIMARY KEY(REVISIONNUMBER);
-ALTER TABLE PUBLIC.TAXONNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_66E PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_9E PRIMARY KEY(DETERMINATIONEVENT_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_82 PRIMARY KEY(REV, CLASSIFICATION_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_7 PRIMARY KEY(AGENTBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_7F PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.AGENTBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_6 PRIMARY KEY(REV, AGENTBASE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_83 PRIMARY KEY(DEFINEDTERMBASE_ID, REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_98 PRIMARY KEY(CLASSIFICATION_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5 PRIMARY KEY(AGENTBASE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_CE5 PRIMARY KEY(ORIGINALSOURCEBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_880 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.AGENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_4 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.AGENTBASE_AGENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_3 PRIMARY KEY(AGENTBASE_ID, SORTINDEX);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_7E PRIMARY KEY(REV, DESCRIPTIONBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.AGENTBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_B PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9F PRIMARY KEY(REV, DESCRIPTIONBASE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.CLASSIFICATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_84 PRIMARY KEY(CLASSIFICATION_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.GATHERINGEVENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_87A PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.AGENTBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_F PRIMARY KEY(REV, AGENTBASE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_6E1 PRIMARY KEY(NAMERELATIONSHIP_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.CREDIT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_1 PRIMARY KEY(CREDIT_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_3A0 PRIMARY KEY(DESCRIPTIONBASE_ID, SCOPES_ID);
-ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_99 PRIMARY KEY(WORKINGSET_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_A PRIMARY KEY(ANNOTATION_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_6EF PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9A PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.LOCUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_80 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9 PRIMARY KEY(REV, AGENTBASE_ID, TEAMMEMBERS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.MULTIACCESSKEY_TAXON_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_9D PRIMARY KEY(REV, MULTIACCESSKEY_ID, TAXON_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_CFF PRIMARY KEY(REV, TERMVOCABULARY_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.REFERENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_85 PRIMARY KEY(REV, REFERENCE_ID, EXTENSIONS_ID);
-ALTER TABLE PUBLIC.EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_81 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.MULTIACCESSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_7C PRIMARY KEY(WORKINGSET_ID, SCOPERESTRICTIONS_ID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_92 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.COLLECTION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_90 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.LSIDAUTHORITY_NAMESPACES ADD CONSTRAINT PUBLIC.CONSTRAINT_77 PRIMARY KEY(LSIDAUTHORITY_ID, NAMESPACES_MAPKEY);
-ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_81E PRIMARY KEY(REFERENCE_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_7B PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, SOURCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_762 PRIMARY KEY(SEQUENCE_ID, CITATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_C3C PRIMARY KEY(REV, SEQUENCE_ID, GENBANKACCESSION_ID);
-ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_7A PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.REPRESENTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_91 PRIMARY KEY(REV, REPRESENTATION_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.MEDIAKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_40F PRIMARY KEY(REV, MEDIA_ID, SCOPERESTRICTIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_7D PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.SEQUENCE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_97 PRIMARY KEY(SEQUENCE_ID, RIGHTS_ID);
-ALTER TABLE PUBLIC.ADDRESS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_2 PRIMARY KEY(ID, REV);
-ALTER TABLE PUBLIC.REFERENCE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_804 PRIMARY KEY(REV, REFERENCE_ID, ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_668 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, GEOGRAPHICALSCOPE_ID);
-ALTER TABLE PUBLIC.CREDIT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_6E4 PRIMARY KEY(CREDIT_ID, MARKERS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_79 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, DEFINITION_MAPKEY_ID);
-ALTER TABLE PUBLIC.AGENTBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_94 PRIMARY KEY(REV, AGENTBASE_ID, CREDITS_ID, SORTINDEX);
-ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_76 PRIMARY KEY(ID);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_539C UNIQUE(UUID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_7A39 UNIQUE(UUID);
-ALTER TABLE PUBLIC.MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_45D7 UNIQUE(UUID);
-ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_87CF2 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.CONSTRAINT_3406 UNIQUE(UUID);
-ALTER TABLE PUBLIC.AGENTBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_F1E UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_9696 UNIQUE(TITLE_ID);
-ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_9EB9 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_CE56 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_71C0 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.REPRESENTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_F1F6 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.COLLECTION ADD CONSTRAINT PUBLIC.CONSTRAINT_B51 UNIQUE(UUID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_6E1E UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.REFERENCE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_8AD UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_56B9 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.CONSTRAINT_E98 UNIQUE(MODIFYINGTEXT_ID);
-ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_F0C6 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_A1D5 UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_E04 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C03 UNIQUE(UUID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_F21 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_977 UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_C0FE UNIQUE(UUID);
-ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_BC2C UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.FEATURETREE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_F07 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_AFBA UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_2F29 UNIQUE(UUID);
-ALTER TABLE PUBLIC.RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_9013 UNIQUE(UUID);
-ALTER TABLE PUBLIC.MEDIA_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_15AD UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_DC0 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_3EB1 UNIQUE(UUID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_9EF UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_7B13 UNIQUE(UUID);
-ALTER TABLE PUBLIC.LOCUS ADD CONSTRAINT PUBLIC.CONSTRAINT_453E UNIQUE(UUID);
-ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.CONSTRAINT_94CF UNIQUE(UUID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_2BE4 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_DBF UNIQUE(SUPPORTEDCATEGORICALENUMERATIONS_ID);
-ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5422 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_B36B UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.COLLECTION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_D488 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_98E1 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_4E7 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_50A UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_FEB UNIQUE(UUID);
-ALTER TABLE PUBLIC.REPRESENTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_E8BF UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_E8E UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_EBD UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_FDB UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_1B0 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_A86 UNIQUE(UUID);
-ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_871F UNIQUE(UUID);
-ALTER TABLE PUBLIC.COLLECTION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_C46 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_831 UNIQUE(REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_BE03 UNIQUE(UUID);
-ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_7E63 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_65C UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.MEDIA_DESCRIPTION ADD CONSTRAINT PUBLIC.CONSTRAINT_D9A9 UNIQUE(DESCRIPTION_ID);
-ALTER TABLE PUBLIC.CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_C5D UNIQUE(UUID);
-ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_C61 UNIQUE(MODIFYINGTEXT_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_EC3 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_E261 UNIQUE(UUID, NAME);
-ALTER TABLE PUBLIC.CREDIT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_1E UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.CONSTRAINT_29C UNIQUE(UUID);
-ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_76F UNIQUE(UUID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_7FE3 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_56B67 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_99E UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_986 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5DC UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_B869 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_F70 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_185F UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_1E18 UNIQUE(UUID);
-ALTER TABLE PUBLIC.REFERENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_599CB UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_120 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.CONSTRAINT_69E7 UNIQUE(UUID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_8DCF UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_2C5B UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_B5D0 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_4F7D UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_6EF3 UNIQUE(UUID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_79F UNIQUE(DEFINITION_ID);
-ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_214 UNIQUE(UUID);
-ALTER TABLE PUBLIC.CDMMETADATA ADD CONSTRAINT PUBLIC.CONSTRAINT_87C UNIQUE(UUID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_9E5E UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_8797 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_8188 UNIQUE(UUID);
-ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_ED73 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_341F UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_63F UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_AE96 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_D7D UNIQUE(ROOTNODES_ID);
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_224 UNIQUE(UUID);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_2820 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_AE UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_7620 UNIQUE(CITATIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_F52 UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_EB60 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C63A UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_E56 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_819 UNIQUE(UUID);
-ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_230 UNIQUE(SUPERVIEWS_ID);
-ALTER TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_988B UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_C819 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_AE52 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_60CA UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.COLLECTION_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_DD7 UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_BF7D UNIQUE(UUID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_2E26 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.AGENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_40 UNIQUE(UUID);
-ALTER TABLE PUBLIC.CREDIT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_6E4D UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_36E6 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_7263 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.MEDIA_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_6B2 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_BCF UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_909ED UNIQUE(DESCRIPTION_ID);
-ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_934 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_447 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_8E8 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_1DFF UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_BE5 UNIQUE(CONTACT_ADDRESSES_ID);
-ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_81E7 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_242C UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_59 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_160 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_69EA1 UNIQUE(UUID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_2B1 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_7D6 UNIQUE(UUID);
-ALTER TABLE PUBLIC.FEATURETREE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_F96 UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C3CBC UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_35B UNIQUE(UUID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_BE634 UNIQUE(SEQUENCES_ID);
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F1 UNIQUE(GENBANKACCESSION_ID);
-ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_FF44 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_BBE UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_919B UNIQUE(UUID);
-ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_2A9 UNIQUE(UUID);
-ALTER TABLE PUBLIC.TAXONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_F6BE UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY ADD CONSTRAINT PUBLIC.CONSTRAINT_8B66 UNIQUE(UUID);
-ALTER TABLE PUBLIC.ANNOTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_953D UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_CA49 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_FD69 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_43DC UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_ECC2 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_C247 UNIQUE(UUID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_688 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_75 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_A961 UNIQUE(INVERSEREPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_C4F06 UNIQUE(UUID, USERNAME);
-ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_E6 UNIQUE(UUID);
-ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_E924 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_145 UNIQUE(RECOMMENDEDMODIFIERENUMERATION_ID);
-ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_BB00 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_88BA UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_8079 UNIQUE(CHROMATOGRAMS_ID);
-ALTER TABLE PUBLIC.LSIDAUTHORITY ADD CONSTRAINT PUBLIC.CONSTRAINT_A443 UNIQUE(UUID, AUTHORITY);
-ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_69B UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_C103 UNIQUE(UUID);
-ALTER TABLE PUBLIC.GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_3463 UNIQUE(UUID, AUTHORITY);
-ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_88C2 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_2B2B UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_D9E UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_A656 UNIQUE(UUID);
-ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_25D4 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_EC95 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_729C UNIQUE(LABEL_ID);
-ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_7F1 UNIQUE(UUID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_371A UNIQUE(RIGHTS_ID);
-ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_B625 UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_444F UNIQUE(REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_FDC73 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.DERIVATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_83EE UNIQUE(UUID);
-ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.CONSTRAINT_5575 UNIQUE(UUID);
-ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_63FFD UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5605 UNIQUE(UUID);
-ALTER TABLE PUBLIC.AGENTBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_D8 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.RIGHTS_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5DEB UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_30E3 UNIQUE(REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_984E UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_A47C UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.CLASSIFICATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_845 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_3C3 UNIQUE(MODIFYINGTEXT_ID);
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_5FCB UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_B592 UNIQUE(UUID);
-ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_3E88 UNIQUE(REPRESENTATIONS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_9063 UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_7A0 UNIQUE(UUID);
-ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_A5F1 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_11A UNIQUE(DESCRIPTION_ID);
-ALTER TABLE PUBLIC.MEDIA_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_448E UNIQUE(USEDSEQUENCES_ID);
-ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.CONSTRAINT_CA5E UNIQUE(UUID);
-ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_C4D7 UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_B9F0 UNIQUE(EXTENSIONS_ID);
-ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_CFB UNIQUE(ANNOTATIONS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_8DF UNIQUE(STATISTICALVALUES_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_ED4 UNIQUE(CREDITS_ID);
-ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_7D78 UNIQUE(STATUS_ID);
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_5094 UNIQUE(MULTILANGUAGETEXT_ID);
-ALTER TABLE PUBLIC.RIGHTS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_14BB UNIQUE(MARKERS_ID);
-ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_D4BB UNIQUE(UUID);
-ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_D80E UNIQUE(SOURCES_ID);
-ALTER TABLE PUBLIC.MEDIA_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_2EC UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.TAXONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF6B PRIMARY KEY(TAXONBASE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7E7 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD6F PRIMARY KEY(REV, HOMOTYPICALGROUP_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBCD PRIMARY KEY(REV, TYPEDESIGNATIONBASE_ID, ANNOTATIONS_ID);
+----ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7E6 PRIMARY KEY(SEQUENCE_ID, SORTINDEX);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX340 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX346 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX341 PRIMARY KEY(POLYTOMOUSKEY_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBCB PRIMARY KEY(REV, WORKINGSET_ID, ANNOTATIONS_ID);
+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.DEFINEDTERMBASE_CONTINENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBAC PRIMARY KEY(DEFINEDTERMBASE_ID, CONTINENTS_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBAD PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, SEQUENCES_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.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX185 PRIMARY KEY(TAXONBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX36E PRIMARY KEY(TERMVOCABULARY_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFE PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.MEDIA_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX15A PRIMARY KEY(MEDIA_ID, SORTINDEX);
+ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC76 PRIMARY KEY(REV, HYBRIDRELATIONSHIP_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC81 PRIMARY KEY(NAMERELATIONSHIP_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD97 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, CREDITS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.MEDIA_DESCRIPTION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD9A PRIMARY KEY(MEDIA_ID, DESCRIPTION_MAPKEY_ID);
+----ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD9D PRIMARY KEY(REV, SEQUENCE_ID, CREDITS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX371 PRIMARY KEY(TERMVOCABULARY_ID, RIGHTS_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.MULTIACCESSKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5A4 PRIMARY KEY(REV, WORKINGSET_ID, GEOGRAPHICALSCOPE_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.TAXONINTERACTION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX909E PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, DESCRIPTION_MAPKEY_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.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBA2 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMEASUREMENTUNITS_ID);
+ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF36 PRIMARY KEY(REV, LANGUAGESTRING_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.RIGHTS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX301 PRIMARY KEY(REV, RIGHTS_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.REFERENCE_RIGHTS_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.REPRESENTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF1F PRIMARY KEY(REPRESENTATION_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.HIBERNATE_SEQUENCES ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX59A PRIMARY KEY(SEQUENCE_NAME);
+ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX30E PRIMARY KEY(TERMVOCABULARY_ID, REPRESENTATIONS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9D7 PRIMARY KEY(REV, TERMVOCABULARY_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX557 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.DETERMINATIONEVENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX550 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.FEATURETREE_RIGHTS_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.AGENTBASE_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX599 PRIMARY KEY(AGENTBASE_ID, TYPES_ID);
+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.MULTIACCESSKEY_TAXON ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7C6 PRIMARY KEY(MULTIACCESSKEY_ID, TAXON_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.MEDIAKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF33 PRIMARY KEY(MEDIA_ID, GEOGRAPHICALSCOPE_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.DEFINEDTERMBASE_STATISTICALMEASURE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2CD PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_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.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2F2 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX360 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2C5 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX154 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.COLLECTION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD48 PRIMARY KEY(COLLECTION_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB599 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.HOMOTYPICALGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC24 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.REFERENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC22 PRIMARY KEY(REFERENCE_ID, MEDIA_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE63 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, SEQUENCES_ID);
+ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC10 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX718 PRIMARY KEY(REV, REPRESENTATION_ID, ID, SORTINDEX);
+ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC29 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA PRIMARY KEY(REV, DEFINEDTERMBASE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCB PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.DERIVATIONEVENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCC PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.FEATURETREE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCE PRIMARY KEY(REV, FEATURETREE_ID, CREDITS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCF PRIMARY KEY(COLLECTION_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.COLLECTION_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDA PRIMARY KEY(REV, COLLECTION_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD3 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MODIFIERS_ID);
+ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD4B PRIMARY KEY(ID);
+--ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX726 PRIMARY KEY(SEQUENCE_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD63 PRIMARY KEY(REV, STATEDATA_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4D PRIMARY KEY(TERMVOCABULARY_ID, ANNOTATIONS_ID);
+--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX550F PRIMARY KEY(REV, SEQUENCE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69EA PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC0F PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC47 PRIMARY KEY(REV, MEDIA_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD56 PRIMARY KEY(REV, TAXONNAMEBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC63 PRIMARY KEY(SYNONYMRELATIONSHIP_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX818 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD80 PRIMARY KEY(POLYTOMOUSKEY_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD2A PRIMARY KEY(REV, TAXONNAMEBASE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX71C PRIMARY KEY(REFERENCE_ID, SORTINDEX);
+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.TAXONINTERACTION_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD2 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, DESCRIPTION_ID, DESCRIPTION_MAPKEY_ID);
+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_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF3 PRIMARY KEY(REV, COLLECTION_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC PRIMARY KEY(CLASSIFICATION_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED PRIMARY KEY(DESCRIPTIONBASE_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.RIGHTS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX14B PRIMARY KEY(RIGHTS_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.FEATURETREE_RIGHTS 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_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF5 PRIMARY KEY(CLASSIFICATION_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF4 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, CONTINENTS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF7 PRIMARY KEY(CLASSIFICATION_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.MEDIA_TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF6 PRIMARY KEY(REV, MEDIA_ID, COVEREDTAXA_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_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF1 PRIMARY KEY(AGENTBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.AGENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE8 PRIMARY KEY(AGENTBASE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD7 PRIMARY KEY(CLASSIFICATION_ID, ROOTNODES_ID);
+ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD6 PRIMARY KEY(REV, DETERMINATIONEVENT_ID, SETOFREFERENCES_ID);
+ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD9 PRIMARY KEY(DERIVATIONEVENT_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDC7 PRIMARY KEY(TAXONNAMEBASE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE2 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE0 PRIMARY KEY(FEATURETREE_ID, SORTINDEX);
+ALTER TABLE PUBLIC.COLLECTION_RIGHTS 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.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDB PRIMARY KEY(DEFINEDTERMBASE_ID, SUPPORTEDCATEGORICALENUMERATIONS_ID);
+ALTER TABLE PUBLIC.MEDIA_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX65C7 PRIMARY KEY(REV, MEDIA_ID, KEYREPRESENTATIONS_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.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE3 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MODIFYINGTEXT_MAPKEY_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDE PRIMARY KEY(REV, CLASSIFICATION_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX542 PRIMARY KEY(LANGUAGESTRING_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDC PRIMARY KEY(CLASSIFICATION_ID, SORTINDEX);
+ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF0C PRIMARY KEY(LANGUAGESTRING_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DC PRIMARY KEY(TYPEDESIGNATIONBASE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F0 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE8 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE5 PRIMARY KEY(DEFINEDTERMBASE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX539 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43D PRIMARY KEY(GATHERINGEVENT_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.LOCUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX453 PRIMARY KEY(ID);
+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.WORKINGSET_TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8B0 PRIMARY KEY(REV, WORKINGSET_ID, COVEREDTAXA_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.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX509 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MULTILANGUAGETEXT_MAPKEY_ID);
+ALTER TABLE PUBLIC.MEDIA_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX448 PRIMARY KEY(MEDIA_ID, USEDSEQUENCES_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.TAXONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56B6 PRIMARY KEY(TAXONBASE_ID, ANNOTATIONS_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.WORKINGSET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA53 PRIMARY KEY(WORKINGSET_ID, DESCRIPTIONS_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.RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX901 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX909 PRIMARY KEY(REV, MEDIA_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA1D PRIMARY KEY(TAXONNAMEBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX919 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.LSIDAUTHORITY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA44 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_FEATURE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX435 PRIMARY KEY(DESCRIPTIONBASE_ID, DESCRIPTIVESYSTEM_ID);
+ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5F PRIMARY KEY(HOMOTYPICALGROUP_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8B6 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.MEDIA_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2E PRIMARY KEY(MEDIA_ID, RIGHTS_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.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX11 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, DESCRIPTION_MAPKEY_ID);
+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.DEFINEDTERMBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX15 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX45D PRIMARY KEY(ID);
+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.DEFINEDTERMBASE_MEASUREMENTUNIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1C PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDMEASUREMENTUNITS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX14 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);
+ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF5F PRIMARY KEY(REV, DERIVATIONEVENT_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.MEDIA_RIGHTS_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.TAXONNODE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8CB PRIMARY KEY(REV, TAXONNODE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAFB PRIMARY KEY(TAXONBASE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXON_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2B4E PRIMARY KEY(REV, POLYTOMOUSKEY_ID, TAXON_ID);
+ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2A PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.AGENTBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX28 PRIMARY KEY(AGENTBASE_ID, MEDIA_ID);
+ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX29 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAF1 PRIMARY KEY(REV, TERMVOCABULARY_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.HOMOTYPICALGROUP_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX20 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX21 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX26 PRIMARY KEY(REV, NOMENCLATURALSTATUS_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.FEATURETREE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX24 PRIMARY KEY(REV, FEATURETREE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX25 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX30 PRIMARY KEY(REV, GATHERINGEVENT_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2C PRIMARY KEY(DEFINEDTERMBASE_ID, MEDIA_ID);
+ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX23 PRIMARY KEY(CDM_VIEW_ID, SUPERVIEWS_ID);
+ALTER TABLE PUBLIC.ANNOTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX953 PRIMARY KEY(ANNOTATION_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX282 PRIMARY KEY(HYBRIDRELATIONSHIP_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA65 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE64 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE65 PRIMARY KEY(REV, FEATURETREE_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_DERIVATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX23A PRIMARY KEY(ORIGINALS_ID, DERIVATIONEVENTS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX239 PRIMARY KEY(REV, CLASSIFICATION_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFF0 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.REFERENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX244 PRIMARY KEY(REV, REFERENCE_ID, CREDITS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX247 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE5B PRIMARY KEY(REV, POLYTOMOUSKEY_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX242 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX988 PRIMARY KEY(TAXONRELATIONSHIP_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MARKERS_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.RIGHTS_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD2 PRIMARY KEY(REV, RIGHTS_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX225 PRIMARY KEY(USERACCOUNT_ID, GRANTEDAUTHORITIES_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.DERIVATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56B PRIMARY KEY(DERIVATIONEVENT_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56A PRIMARY KEY(REV, TAXONNAMEBASE_ID, CREDITS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.MEDIA_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX564 PRIMARY KEY(REV, MEDIA_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX560 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBF7 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.REFERENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX599C PRIMARY KEY(REFERENCE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE92 PRIMARY KEY(REFERENCE_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB49 PRIMARY KEY(REV, TERMVOCABULARY_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE70 PRIMARY KEY(REV, STATISTICALMEASUREMENTVALUE_ID, MODIFIERS_ID);
+ALTER TABLE PUBLIC.AGENTBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE8A PRIMARY KEY(REV, AGENTBASE_ID, MEDIA_ID);
+ALTER TABLE PUBLIC.REPRESENTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE8B PRIMARY KEY(REPRESENTATION_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE8C PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MEDIA_ID, SORTINDEX);
+ALTER TABLE PUBLIC.STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX60B PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX656 PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, DEFINITION_ID, DEFINITION_MAPKEY_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB36 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE3C PRIMARY KEY(REV, TAXONBASE_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC81E PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX98E PRIMARY KEY(TAXONNAMEBASE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA85 PRIMARY KEY(FEATURENODE_ID, ONLYAPPLICABLEIF_ID);
+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.DESCRIPTIONBASE_GEOSCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA70 PRIMARY KEY(DESCRIPTIONBASE_ID, GEOSCOPES_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.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB62 PRIMARY KEY(TAXONNODE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5F7 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5F6 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5E PRIMARY KEY(REV, POLYTOMOUSKEYNODE_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX94C PRIMARY KEY(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.MULTIACCESSKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDE PRIMARY KEY(REV, WORKINGSET_ID, SCOPERESTRICTIONS_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_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA9D PRIMARY KEY(REV, SEQUENCE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.MEDIA_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFE4 PRIMARY KEY(REV, MEDIA_ID, USEDSEQUENCES_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.RIGHTS_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5DE PRIMARY KEY(RIGHTS_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA96 PRIMARY KEY(DEFINEDTERMBASE_ID, INVERSEREPRESENTATIONS_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.NAMERELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC34 PRIMARY KEY(REV, NAMERELATIONSHIP_ID, ANNOTATIONS_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.WORKINGSET_DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDAF PRIMARY KEY(REV, WORKINGSET_ID, DESCRIPTIONS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS_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.AGENTBASE_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX53 PRIMARY KEY(REV, AGENTBASE_ID, TYPES_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.DESCRIPTIONBASE_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX58 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, SCOPES_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, SUPPORTEDCATEGORICALENUMERATIONS_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_GEOSCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX71 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, GEOSCOPES_ID);
+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.MEDIA_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6B PRIMARY KEY(MEDIA_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6A PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6634534 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, CREDITS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX67 PRIMARY KEY(REV, SYNONYMRELATIONSHIP_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX68 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX65 PRIMARY KEY(DESCRIPTIONBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6F PRIMARY KEY(REV, DESCRIPTIONBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69 PRIMARY KEY(DEFINEDTERMBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX72 PRIMARY KEY(REV, DERIVATIONEVENT_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDC8 PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88B PRIMARY KEY(TAXONNAMEBASE_ID, SORTINDEX);
+ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX64 PRIMARY KEY(REV, TERMVOCABULARY_ID, MARKERS_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.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3AA PRIMARY KEY(MEDIA_ID, SCOPERESTRICTIONS_ID);
+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.CDMMETADATA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX86 PRIMARY KEY(DETERMINATIONEVENT_ID, SETOFREFERENCES_ID);
+--ALTER TABLE PUBLIC.SEQUENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8E PRIMARY KEY(SEQUENCE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.REFERENCE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88 PRIMARY KEY(REV, REFERENCE_ID, MARKERS_ID);
+--ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8C PRIMARY KEY(REV, SEQUENCE_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8B PRIMARY KEY(REV, POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
+ALTER TABLE PUBLIC.REFERENCE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8A PRIMARY KEY(REFERENCE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87CF PRIMARY KEY(MEDIA_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTS_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.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);
+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.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA1 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, MULTILANGUAGETEXT_ID, MULTILANGUAGETEXT_MAPKEY_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.AGENTBASE_CONTACT_URLS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5C PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_URLS_ELEMENT);
+ALTER TABLE PUBLIC.TAXONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6B24 PRIMARY KEY(REV, TAXONBASE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5F PRIMARY KEY(REV, DEFINEDTERMBASE_ID, REPRESENTATIONS_ID);
+ALTER TABLE PUBLIC.TAXONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX61 PRIMARY KEY(REV, TAXONBASE_ID, RIGHTS_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.MEDIAKEY_TAXON ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3AB PRIMARY KEY(MEDIAKEY_ID, TAXON_ID);
+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.MEDIA_TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAA PRIMARY KEY(MEDIA_ID, COVEREDTAXA_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_WATERBODYORCOUNTRY_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX96 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, WATERBODIESORCOUNTRIES_ID);
+ALTER TABLE PUBLIC.WORKINGSET_TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCAA PRIMARY KEY(WORKINGSET_ID, COVEREDTAXA_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.DETERMINATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC8 PRIMARY KEY(REV, DETERMINATIONEVENT_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.MULTIACCESSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCC2 PRIMARY KEY(WORKINGSET_ID, GEOGRAPHICALSCOPE_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.AGENTBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9 PRIMARY KEY(REV, AGENTBASE_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC0 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.COLLECTION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB5 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBF PRIMARY KEY(REV, CLASSIFICATION_ID, CREDITS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX86A PRIMARY KEY(REV, TERMVOCABULARY_ID, REPRESENTATIONS_ID);
+ALTER TABLE PUBLIC.REPRESENTATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3DC PRIMARY KEY(REV, REPRESENTATION_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.AGENTBASE_ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE PRIMARY KEY(AGENTBASE_ID, CONTACT_ADDRESSES_ID);
+ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB8 PRIMARY KEY(REV, AGENTBASE_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBC PRIMARY KEY(HOMOTYPICALGROUP_ID, MARKERS_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.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);
+ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_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.MEDIAKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDBEE PRIMARY KEY(REV, MEDIA_ID, GEOGRAPHICALSCOPE_ID);
+ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3EB PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.MEDIAKEY_TAXON_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE05 PRIMARY KEY(REV, MEDIAKEY_ID, TAXON_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_RIGHTS_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.DEFINEDTERMBASE_WATERBODYORCOUNTRY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDBE PRIMARY KEY(DEFINEDTERMBASE_ID, WATERBODIESORCOUNTRIES_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.COLLECTION_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX34 PRIMARY KEY(REV, COLLECTION_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX37 PRIMARY KEY(REV, TAXONRELATIONSHIP_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4E PRIMARY KEY(REFERENCE_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43 PRIMARY KEY(REV, CLASSIFICATION_ID, ANNOTATIONS_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.MEDIA_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX46 PRIMARY KEY(MEDIA_ID, KEYREPRESENTATIONS_ID);
+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.INDIVIDUALASSOCIATION_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC3 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, DESCRIPTION_ID, DESCRIPTION_MAPKEY_ID);
+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.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX51 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, INVERSEREPRESENTATIONS_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.AUDITEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8A37655 PRIMARY KEY(REVISIONNUMBER);
+ALTER TABLE PUBLIC.TAXONNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX66E PRIMARY KEY(ID, REV);
+ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9E PRIMARY KEY(DETERMINATIONEVENT_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX82 PRIMARY KEY(REV, CLASSIFICATION_ID, SOURCES_ID);
+ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7A125 PRIMARY KEY(AGENTBASE_ID, SOURCES_ID);
+--ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7F PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.AGENTBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63456AE PRIMARY KEY(REV, AGENTBASE_ID, RIGHTS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX83 PRIMARY KEY(DEFINEDTERMBASE_ID, REPRESENTATIONS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX98 PRIMARY KEY(CLASSIFICATION_ID, EXTENSIONS_ID);
+ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX53456AE PRIMARY KEY(AGENTBASE_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.AGENTBASE_AGENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33456AE PRIMARY KEY(AGENTBASE_ID, SORTINDEX);
+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.CLASSIFICATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX84 PRIMARY KEY(CLASSIFICATION_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.GATHERINGEVENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87A PRIMARY KEY(ID, REV);
+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.DESCRIPTIONBASE_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3A0 PRIMARY KEY(DESCRIPTIONBASE_ID, SCOPES_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.AGENTBASE_AGENTBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX93456AE PRIMARY KEY(REV, AGENTBASE_ID, TEAMMEMBERS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.MULTIACCESSKEY_TAXON_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9D PRIMARY KEY(REV, MULTIACCESSKEY_ID, TAXON_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTS_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.MULTIACCESSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7C PRIMARY KEY(WORKINGSET_ID, SCOPERESTRICTIONS_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.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX81E PRIMARY KEY(REFERENCE_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7B PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, SOURCES_ID);
+--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.MEDIAKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX40F PRIMARY KEY(REV, MEDIA_ID, SCOPERESTRICTIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D PRIMARY KEY(ID);
+--ALTER TABLE PUBLIC.SEQUENCE_RIGHTS 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.REFERENCE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX804 PRIMARY KEY(REV, REFERENCE_ID, ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX668 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, GEOGRAPHICALSCOPE_ID);
+ALTER TABLE PUBLIC.CREDIT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6E4 PRIMARY KEY(CREDIT_ID, MARKERS_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX79 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, DEFINITION_MAPKEY_ID);
+ALTER TABLE PUBLIC.AGENTBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX94 PRIMARY KEY(REV, AGENTBASE_ID, CREDITS_ID, SORTINDEX);
+ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX76 PRIMARY KEY(ID);
+ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX539C UNIQUE(UUID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7A39 UNIQUE(UUID);
+ALTER TABLE PUBLIC.MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX45D7 UNIQUE(UUID);
+ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87CF2 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3406 UNIQUE(UUID);
+ALTER TABLE PUBLIC.AGENTBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF1E UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9696 UNIQUE(TITLE_ID);
+ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9EB9 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCE56 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX71C0 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.REPRESENTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF1F6 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.COLLECTION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB51 UNIQUE(UUID);
+ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6E1E UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.REFERENCE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8AD UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56B9 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE98 UNIQUE(MODIFYINGTEXT_ID);
+ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF0C6 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA1D5 UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXE04 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXC03 UNIQUE(UUID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXF21 UNIQUE(CREDITS_ID);
+--ALTER TABLE PUBLIC.SEQUENCE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXX977 UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXC0FE UNIQUE(UUID);
+ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXBC2C UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.FEATURETREE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXF07 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXAFBA UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXX2F29 UNIQUE(UUID);
+ALTER TABLE PUBLIC.RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXX9013 UNIQUE(UUID);
+ALTER TABLE PUBLIC.MEDIA_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXX15AD UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXDC0 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXX3EB1 UNIQUE(UUID);
+ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9EF UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7B13 UNIQUE(UUID);
+ALTER TABLE PUBLIC.LOCUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX453E UNIQUE(UUID);
+ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX94CF UNIQUE(UUID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2BE4 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDBF UNIQUE(SUPPORTEDCATEGORICALENUMERATIONS_ID);
+ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5422 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB36B UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.COLLECTION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD488 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX98E1 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4E7 UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX50A UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFEB UNIQUE(UUID);
+ALTER TABLE PUBLIC.REPRESENTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE8BF UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.AGENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE8E UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEBD UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDB UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1B0 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA86 UNIQUE(UUID);
+ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX871F UNIQUE(UUID);
+ALTER TABLE PUBLIC.COLLECTION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC46 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX831 UNIQUE(REPRESENTATIONS_ID);
+ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE03 UNIQUE(UUID);
+--ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7E63 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX65C UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.MEDIA_DESCRIPTION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD9A9 UNIQUE(DESCRIPTION_ID);
+ALTER TABLE PUBLIC.CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC5D UNIQUE(UUID);
+ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC61 UNIQUE(MODIFYINGTEXT_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC3 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE261 UNIQUE(UUID, NAME);
+ALTER TABLE PUBLIC.CREDIT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1E UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX29C UNIQUE(UUID);
+ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX76F UNIQUE(UUID);
+ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7FE3 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56B67 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX99E UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX986 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5DC UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB869 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF70 UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX185F UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1E18 UNIQUE(UUID);
+ALTER TABLE PUBLIC.REFERENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX599CB UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX120 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69E7 UNIQUE(UUID);
+ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DCF UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2C5B UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB5D0 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4F7D UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6EF3 UNIQUE(UUID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX79F UNIQUE(DEFINITION_ID);
+ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX214 UNIQUE(UUID);
+ALTER TABLE PUBLIC.CDMMETADATA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87C UNIQUE(UUID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9E5E UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8797 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8188 UNIQUE(UUID);
+ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED73 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX341F UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63F UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE96 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD7D UNIQUE(ROOTNODES_ID);
+ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2820 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7620 UNIQUE(CITATIONS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF52 UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEB60 UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC63A UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE56 UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX819 UNIQUE(UUID);
+ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX230 UNIQUE(SUPERVIEWS_ID);
+ALTER TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX988B UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC819 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE52 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX60CA UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.COLLECTION_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDD7 UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBF7D UNIQUE(UUID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2E26 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.AGENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX40 UNIQUE(UUID);
+ALTER TABLE PUBLIC.CREDIT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6E4D UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX36E6 UNIQUE(SOURCES_ID);
+--ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7263 UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.MEDIA_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6B2 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBCF UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX909ED UNIQUE(DESCRIPTION_ID);
+ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX934 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.AGENTBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX447 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.SEQUENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8E8 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1DFF UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.AGENTBASE_ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE5 UNIQUE(CONTACT_ADDRESSES_ID);
+ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX81E7 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX242C UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX59 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX160 UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69EA1 UNIQUE(UUID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2B1 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D6 UNIQUE(UUID);
+ALTER TABLE PUBLIC.FEATURETREE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF96 UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC3CBC UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX35B UNIQUE(UUID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBE634 UNIQUE(SEQUENCES_ID);
+ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFF44 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBBE UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX919B UNIQUE(UUID);
+ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2A9 UNIQUE(UUID);
+ALTER TABLE PUBLIC.TAXONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF6BE UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8B66 UNIQUE(UUID);
+ALTER TABLE PUBLIC.ANNOTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX953D UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA49 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD69 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43DC UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXECC2 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.HOMOTYPICALGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC247 UNIQUE(UUID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX688 UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX75 UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA961 UNIQUE(INVERSEREPRESENTATIONS_ID);
+ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F06 UNIQUE(UUID, USERNAME);
+ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE6 UNIQUE(UUID);
+ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE924 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX145 UNIQUE(RECOMMENDEDMODIFIERENUMERATION_ID);
+ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB00 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88BA UNIQUE(CREDITS_ID);
+--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8079 UNIQUE(CHROMATOGRAMS_ID);
+ALTER TABLE PUBLIC.LSIDAUTHORITY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA443 UNIQUE(UUID, AUTHORITY);
+ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69B UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC103 UNIQUE(UUID);
+ALTER TABLE PUBLIC.GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3463 UNIQUE(UUID, AUTHORITY);
+--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88C2 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2B2B UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD9E UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA656 UNIQUE(UUID);
+ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX25D4 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC95 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX729C UNIQUE(LABEL_ID);
+ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7F1 UNIQUE(UUID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX371A UNIQUE(RIGHTS_ID);
+ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB625 UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX444F UNIQUE(REPRESENTATIONS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDC73 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.DERIVATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX83EE UNIQUE(UUID);
+ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5575 UNIQUE(UUID);
+ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63FFD UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5605 UNIQUE(UUID);
+ALTER TABLE PUBLIC.AGENTBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD8 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.RIGHTS_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5DEB UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX30E3 UNIQUE(REPRESENTATIONS_ID);
+ALTER TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX984E UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA47C UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.CLASSIFICATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX845 UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3C3 UNIQUE(MODIFYINGTEXT_ID);
+ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5FCB UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB592 UNIQUE(UUID);
+ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E88 UNIQUE(REPRESENTATIONS_ID);
+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.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX11A UNIQUE(DESCRIPTION_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.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F0 UNIQUE(EXTENSIONS_ID);
+ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFB UNIQUE(ANNOTATIONS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DF UNIQUE(STATISTICALVALUES_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED4 UNIQUE(CREDITS_ID);
+ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D78 UNIQUE(STATUS_ID);
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5094 UNIQUE(MULTILANGUAGETEXT_ID);
+ALTER TABLE PUBLIC.RIGHTS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX14BB UNIQUE(MARKERS_ID);
+ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD4BB UNIQUE(UUID);
+ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD80E UNIQUE(SOURCES_ID);
+ALTER TABLE PUBLIC.MEDIA_RIGHTS 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.DEFINEDTERMBASE_MEASUREMENTUNIT ADD CONSTRAINT PUBLIC.FKE9D17767D0BDAE9B FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.FK3C7BD9CD34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
@@ -5051,11 +5312,11 @@ ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER ADD CONSTRAINT PUBLIC.FK89261453C0DB49
 ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAE4CB0F315 FOREIGN KEY(TYPENAME_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK65CF621B9C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.FKD21E7935C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.FK1D0A1EBE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7C777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK99ABA37B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK6A2601A9C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
 ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.FKA8814EB2258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
@@ -5091,7 +5352,7 @@ ALTER TABLE PUBLIC.MEDIA ADD CONSTRAINT PUBLIC.FK46C7FC44FF2DB2C FOREIGN KEY(CRE
 ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB1100068D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(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.SEQUENCE ADD CONSTRAINT PUBLIC.FK544ADBE1D0374392 FOREIGN KEY(PUBLISHEDIN_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKC753F137C086B46F FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(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;
@@ -5123,14 +5384,13 @@ ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.FK6F1286F33DA462D5 FOREI
 ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.FK8400DFA51E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
 ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.FKAAC8AFE6B31C4747 FOREIGN KEY(REPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
 ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK70BB5FD8DA0C376A FOREIGN KEY(LABEL_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F698096D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.AGENTBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4FDFF8D134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.FKBFFEE8F0546985E4 FOREIGN KEY(SCOPERESTRICTIONS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA408B63A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
 ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF ADD CONSTRAINT PUBLIC.FK56833D0152FCC4B FOREIGN KEY(FEATURENODE_ID) REFERENCES PUBLIC.FEATURENODE(ID) NOCHECK;
 ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKE644349534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.COLLECTION_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK9AABDB5434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FKDE29CD8033B8A841 FOREIGN KEY(DESCRIPTIONS_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;
+ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKDE29CD8033B8A841 FOREIGN KEY(SPECIMEN_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.STATEDATA_AUD ADD CONSTRAINT PUBLIC.FKDA6A700C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA3272C8505DB FOREIGN KEY(PRESERVATION_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_RIGHTS ADD CONSTRAINT PUBLIC.FKDB1266D2C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
@@ -5176,7 +5436,6 @@ ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.FK76DDD01BF95
 ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.FK6944904DD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK629941D04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
 ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK7AE0176334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF8BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
 ALTER TABLE PUBLIC.TAXONBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK65CF621BC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
 ALTER TABLE PUBLIC.RIGHTS ADD CONSTRAINT PUBLIC.FK91E56DF7E8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.FK7125B9F04FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
@@ -5235,13 +5494,12 @@ ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E5108316CDFF85 FORE
 ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBDBBD2C869 FOREIGN KEY(WORKINGSET_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
 ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FK7A439066777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
 ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) 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(EXCOMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
-ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATES_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
+ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
 ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
 ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK8F69809615C4EF35 FOREIGN KEY(GENBANKACCESSION_ID) REFERENCES PUBLIC.GENBANKACCESSION(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.MEDIAKEY_TAXON ADD CONSTRAINT PUBLIC.FKC00C3966DE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
@@ -5276,7 +5534,7 @@ ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE ADD CONSTRAINT PUB
 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.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.FK6FF15DFCD0BDAE9B FOREIGN KEY(DEFINEDTERMBASE_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.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.DESCRIPTIONELEMENTBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FK1E160FB934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
@@ -5295,11 +5553,10 @@ ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.FK5BC6DEAD32D1B9F FORE
 ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK2FEEB6B8C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_RIGHTS ADD CONSTRAINT PUBLIC.FKDB1266D2C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
 ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FKD522D38334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.FK544ADBE12DBE1F1F FOREIGN KEY(LOCUS_ID) REFERENCES PUBLIC.LOCUS(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.FK544ADBE12DBE1F1F FOREIGN KEY(LOCUS_ID) REFERENCES PUBLIC.LOCUS(ID) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK2FEEB6B83A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONBASE_SCOPE ADD CONSTRAINT PUBLIC.FKB9257C42951A5D40 FOREIGN KEY(SCOPES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA ADD CONSTRAINT PUBLIC.FK4EEBF7B7C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK1B1ABB6634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK1B1ABB6634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.REFERENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK1DF60C5C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.FK9033CE749DD57A93 FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKB482C5E686EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
@@ -5338,7 +5595,7 @@ ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.F
 ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.FK2D26AB8834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK1E28140E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.FKF68FEBDE927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.FK8E5D91E6D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.FK8E5D91E6D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK42D7AF908C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(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;
@@ -5363,13 +5620,12 @@ ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK6E6F457
 ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.FK6FF15DFCC9CD5B57 FOREIGN KEY(RECOMMENDEDSTATISTICALMEASURES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D987CC6A4 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK812DE753DA9DCB5F FOREIGN KEY(GROUPS_ID) REFERENCES PUBLIC.PERMISSIONGROUP(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_RIGHTS ADD CONSTRAINT PUBLIC.FK4616A015D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_RIGHTS ADD CONSTRAINT PUBLIC.FK4616A015D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
 ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK686C42B7E0960EC4 FOREIGN KEY(MODIFIERS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCC4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
 ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKA4B9E0A434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB1100064FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
-ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK8457720834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) 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;
@@ -5392,7 +5648,6 @@ ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK2EBEFB1C34
 ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49B74FED214 FOREIGN KEY(SEC_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.SEQUENCE_MARKER ADD CONSTRAINT PUBLIC.FK3D22B278D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02AEB7F3BE FOREIGN KEY(CITATION_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FKDE29CD805C9E3461 FOREIGN KEY(DESCRIBEDSPECIMENOROBSERVATIONS_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.FK1A21C74FDF299D00 FOREIGN KEY(ANNOTATIONTYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.AGENTBASE_MARKER ADD CONSTRAINT PUBLIC.FK365D5D6386EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK41ED09739C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
@@ -5486,7 +5741,7 @@ ALTER TABLE PUBLIC.ANNOTATION_MARKER_AUD ADD CONSTRAINT PUBLIC.FK68CE281B34869AA
 ALTER TABLE PUBLIC.REFERENCE_MEDIA ADD CONSTRAINT PUBLIC.FKBBEF5B08D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION ADD CONSTRAINT PUBLIC.FKE6E91F831E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
 ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD ADD CONSTRAINT PUBLIC.FK2C1599B834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.FK8E5D91E666ACA7EC FOREIGN KEY(CHROMATOGRAMS_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.FK8E5D91E666ACA7EC FOREIGN KEY(CHROMATOGRAMS_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.FK1CB715E83B8BB609 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;
@@ -5513,7 +5768,7 @@ ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.FKA9E6B138576595C3 FOREIG
 ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.FKF483ADB3F8991B9D FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FKD482FE2134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_TAXONBASE ADD CONSTRAINT PUBLIC.FK1ABD49E07C3D0017 FOREIGN KEY(COVEREDTAXA_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKCDB0237BD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) 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.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE76714FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
@@ -5612,7 +5867,7 @@ ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.FKA020DAAA1E403E0B FOR
 ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK42D7AF90C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
 ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBD1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
 ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.FK4CEED9F84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.FK2CFBC93732D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.FK2CFBC93732D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
 ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCC84A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;
 ALTER TABLE PUBLIC.CLASSIFICATION_AUD ADD CONSTRAINT PUBLIC.FKEB11BAD734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.FK1ED033D44FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
@@ -5639,7 +5894,6 @@ ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA3272156
 ALTER TABLE PUBLIC.TAXONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKE11D334F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKC025854234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK2BC1DD2E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FK5A2F4DC934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.FK278CF8B61E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
 ALTER TABLE PUBLIC.TERMVOCABULARY_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK681B370B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.USERACCOUNT_AUD ADD CONSTRAINT PUBLIC.FK6A57909334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
@@ -5681,9 +5935,9 @@ ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS ADD CONSTRAINT PUBLIC.FK9754
 ALTER TABLE PUBLIC.MEDIA_DESCRIPTION ADD CONSTRAINT PUBLIC.FK368283E12BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
 ALTER TABLE PUBLIC.COLLECTION_AUD ADD CONSTRAINT PUBLIC.FKD6D4298F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK2E340A66D040DBF0 FOREIGN KEY(PARTOF_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_RIGHTS ADD CONSTRAINT PUBLIC.FK4616A015C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_RIGHTS ADD CONSTRAINT PUBLIC.FK4616A015C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTS(ID) NOCHECK;
 ALTER TABLE PUBLIC.MEDIA_AUD ADD CONSTRAINT PUBLIC.FKF70B2B9534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK1CA8129234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK1CA8129234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.KEYSTATEMENT_AUD ADD CONSTRAINT PUBLIC.FK93036FC134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.FK1010BA6D1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
 ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.FK7A0351D61E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
@@ -5724,7 +5978,6 @@ ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.FK5D8B8DA47C496C
 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.SPECIMENOROBSERVATIONBASE_MEDIA ADD CONSTRAINT PUBLIC.FK4EEBF7B73B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.FK544ADBE1BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
 ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FKFD724D855EA5DD89 FOREIGN KEY(USERACCOUNT_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
 ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.FK243C037F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
@@ -5750,18 +6003,15 @@ ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.FKAAC8AF
 ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E510834FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
 ALTER TABLE PUBLIC.AGENTBASE_ADDRESS_AUD ADD CONSTRAINT PUBLIC.FK3D28383C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK8F98B2B734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.FK4CF19F94B7892921 FOREIGN KEY(ROOT_ID) REFERENCES PUBLIC.FEATURENODE(ID) NOCHECK;
 ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK5574E12EF05D08D4 FOREIGN KEY(MODIFYINGTEXT_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
 ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.FK668D5B9123DB7F04 FOREIGN KEY(DESCRIPTIVESYSTEM_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;
 ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.FKFB1697BB4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
 ALTER TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD ADD CONSTRAINT PUBLIC.FKA8A87CFE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.DESCRIPTIONBASE_SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKF1B33B5134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK8F2D512A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
-ALTER TABLE PUBLIC.GENBANKACCESSION ADD CONSTRAINT PUBLIC.FK86C1DBF84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CDDE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
 ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER_AUD ADD CONSTRAINT PUBLIC.FK8619495F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_GENBANKACCESSION_AUD ADD CONSTRAINT PUBLIC.FKC717736734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FKE3E463967B4CB560 FOREIGN KEY(NAMERELATIONSHIP_ID) REFERENCES PUBLIC.NAMERELATIONSHIP(ID) NOCHECK;
 ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTS_AUD ADD CONSTRAINT PUBLIC.FK4168503534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.FKB8D7025234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
@@ -5853,8 +6103,8 @@ ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK
 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.SEQUENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK69D81BCC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.FK2CFBC937D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK69D81BCC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
+--ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.FK2CFBC937D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
 ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.FK395842D927D8399 FOREIGN KEY(TAXONNODE_ID) REFERENCES PUBLIC.TAXONNODE(ID) NOCHECK;
 ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION ADD CONSTRAINT PUBLIC.FK715D6726927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
 ALTER TABLE PUBLIC.COLLECTION ADD CONSTRAINT PUBLIC.FKF078ABE4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
@@ -5882,7 +6132,6 @@ ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.FK668D5B914FF2DB2C FOREIGN K
 ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK1FFC43A934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.FKFB2DB8DC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
 ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKA898D9FB34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
-ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAEBFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;
 ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.FK2E38AC8B7B4CB560 FOREIGN KEY(NAMERELATIONSHIP_ID) REFERENCES PUBLIC.NAMERELATIONSHIP(ID) NOCHECK;
 ALTER TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION ADD CONSTRAINT PUBLIC.FK2170B25C5AF2C74 FOREIGN KEY(SUPPORTEDCATEGORICALENUMERATIONS_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
 ALTER TABLE PUBLIC.DESCRIPTIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FK92DD5BDD34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
