some fixes for modell change branche

[cdmlib.git] / 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 0ad8f5a843bb14a731cd3c648b687af7e1fd2ac0..04d658c9a1d6a5b2ec02c4d27b4135455d0e11bc 100644 (file)
--- 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 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,
 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;
     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,
 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;
     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,
 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
 );
     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,
 -- 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,
     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),
     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),
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN NOT NULL,
     TITLECACHE VARCHAR(255),

-    URI VARCHAR(255),
+    URI CLOB,

     ISO639_1 VARCHAR(2),
     ISO639_1 VARCHAR(2),

-    ISO639_2 VARCHAR(3),
+    RANKCLASS VARCHAR(4) NOT NULL,

     ISTECHNICAL BOOLEAN,
     ORDERINDEX INTEGER,
     SYMMETRICAL BOOLEAN,
     ISTECHNICAL BOOLEAN,
     ORDERINDEX INTEGER,
     SYMMETRICAL BOOLEAN,


@@ -731,6 +906,8 @@ CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     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),
     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),
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),

-    URI VARCHAR(255),
+    URI CLOB,

     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     KINDOF_ID INTEGER,
     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),
     VOCABULARY_ID INTEGER,
     ORDERINDEX INTEGER,
     ISO639_1 VARCHAR(2),

-    ISO639_2 VARCHAR(3),
+    RANKCLASS VARCHAR(4) NOT NULL,

     SUPPORTSCATEGORICALDATA BOOLEAN,
     SUPPORTSCOMMONTAXONNAME BOOLEAN,
     SUPPORTSDISTRIBUTION BOOLEAN,
     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,
     IMAGEGALLERY BOOLEAN NOT NULL,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,

+    SPECIMEN_ID INTEGER,

     TAXON_ID INTEGER,
     TAXONNAME_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,
     IMAGEGALLERY BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,

+    SPECIMEN_ID INTEGER,

     TAXON_ID INTEGER,
     TAXONNAME_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;
     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,
 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),
     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,
     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,
     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,
     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,
     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(
 );
 -- 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,
 -- 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,
 );
 -- 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;
     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,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SORTINDEX INTEGER,

+    TREEINDEX VARCHAR(255),

     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     FEATURE_ID INTEGER,
     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,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SORTINDEX INTEGER,

+    TREEINDEX VARCHAR(255),

     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     FEATURE_ID INTEGER,
     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),
     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,
     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),
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),

-    URI VARCHAR(255),
+    URI CLOB,

     DESCRIPTIONSEPARATED BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     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,
     TIMEPERIOD_FREETEXT VARCHAR(255),
     TIMEPERIOD_START VARCHAR(255),
     ABSOLUTEELEVATION INTEGER,

-    ABSOLUTEELEVATIONERROR INTEGER,
+    ABSOLUTEELEVATIONMAX INTEGER,
+    ABSOLUTEELEVATIONTEXT VARCHAR(30),

     COLLECTINGMETHOD VARCHAR(255),
     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,
     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,
     TIMEPERIOD_FREETEXT VARCHAR(255),
     TIMEPERIOD_START VARCHAR(255),
     ABSOLUTEELEVATION INTEGER,

-    ABSOLUTEELEVATIONERROR INTEGER,
+    ABSOLUTEELEVATIONMAX INTEGER,
+    ABSOLUTEELEVATIONTEXT VARCHAR(30),

     COLLECTINGMETHOD VARCHAR(255),
     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,
     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;
     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,
 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
 );
     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,
 -- 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,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SIZE INTEGER,

-    URI VARCHAR(255),
+    URI CLOB,

     DURATION INTEGER,
     HEIGHT INTEGER,
     WIDTH INTEGER,
     DURATION INTEGER,
     HEIGHT INTEGER,
     WIDTH INTEGER,


@@ -2126,7 +2337,7 @@ CREATE CACHED TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD(
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SIZE INTEGER,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     SIZE INTEGER,

-    URI VARCHAR(255),
+    URI CLOB,

     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     REPRESENTATION_ID INTEGER,
     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,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,

+    SOURCETYPE VARCHAR(4) NOT NULL,

     CITATIONMICROREFERENCE VARCHAR(255),
     ORIGINALNAMESTRING VARCHAR(255),
     IDINSOURCE VARCHAR(255),
     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,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,

+       SOURCETYPE VARCHAR(4) NOT NULL,

     CITATIONMICROREFERENCE VARCHAR(255),
     ORIGINALNAMESTRING VARCHAR(255),
     IDINSOURCE VARCHAR(255),
     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),
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN NOT NULL,
     TITLECACHE VARCHAR(255),

+    STARTNUMBER INTEGER,

     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     ROOT_ID 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),
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),

+    STARTNUMBER INTEGER,

     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     ROOT_ID 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;
     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,
 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),
     EDITOR VARCHAR(255),
     ISBN VARCHAR(255),
     ISSN VARCHAR(255),

+    DOI VARCHAR(255),

     NOMENCLATURALLYRELEVANT BOOLEAN NOT NULL,
     ORGANIZATION VARCHAR(255),
     PAGES 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,
     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,
     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),
     EDITOR VARCHAR(255),
     ISBN VARCHAR(255),
     ISSN VARCHAR(255),

+    DOI VARCHAR(255),

     NOMENCLATURALLYRELEVANT BOOLEAN,
     ORGANIZATION VARCHAR(255),
     PAGES 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,
     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,
     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),
     UPDATED TIMESTAMP,
     TEXT CLOB,
     ABBREVIATEDTEXT VARCHAR(255),

-    URI VARCHAR(255),
+    URI CLOB,

     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     LANGUAGE_ID INTEGER,
     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),
     UPDATED TIMESTAMP,
     TEXT CLOB,
     ABBREVIATEDTEXT VARCHAR(255),

-    URI VARCHAR(255),
+    URI CLOB,

     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     LANGUAGE_ID INTEGER,
     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
 );
     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,
     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,
     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,
     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,
     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,
     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,
     REV INTEGER NOT NULL,

+    REVTYPE TINYINT,

     SEQUENCE_ID INTEGER NOT NULL,
     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,
     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,
     REV INTEGER NOT NULL,

+    REVTYPE TINYINT,

     SEQUENCE_ID INTEGER NOT NULL,
     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,
     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,
     REV INTEGER NOT NULL,

+    REVTYPE TINYINT,

     SEQUENCE_ID INTEGER NOT NULL,
     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,
     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,
     REV INTEGER NOT NULL,

+    REVTYPE TINYINT,

     SEQUENCE_ID INTEGER NOT NULL,
     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,
     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,
     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,
     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,
 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),
     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),
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN NOT NULL,
     TITLECACHE VARCHAR(255),

+    PUBLISH BOOLEAN,

     INDIVIDUALCOUNT INTEGER,
     ACCESSIONNUMBER VARCHAR(255),
     BARCODE VARCHAR(255),
     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,
     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,
     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);
 );
 -- 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,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,

+    RECORDBASIS  VARCHAR(4) NOT NULL,

     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
     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),
     LSID_REVISION VARCHAR(255),
     PROTECTEDTITLECACHE BOOLEAN,
     TITLECACHE VARCHAR(255),

+    PUBLISH BOOLEAN,

     INDIVIDUALCOUNT INTEGER,
     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),
     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,
     COLLECTION_ID INTEGER,
     DERIVEDFROM_ID INTEGER,
     STOREDUNDER_ID INTEGER,

-    EXSICCATUM VARCHAR(255),

     PRESERVATION_ID INTEGER,
     PRESERVATION_ID INTEGER,

-    FIELDNOTES VARCHAR(255),
-    FIELDNUMBER VARCHAR(255),

     GATHERINGEVENT_ID INTEGER,
     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(
 );
 -- 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;
     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
 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,
     TITLECACHE VARCHAR(255),
     APPENDEDPHRASE VARCHAR(255),
     DOUBTFUL BOOLEAN NOT NULL,

+    PUBLISH BOOLEAN,

     USENAMECACHE BOOLEAN NOT NULL,
     EXCLUDED BOOLEAN,
     TAXONSTATUSUNKNOWN 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,
     TITLECACHE VARCHAR(255),
     APPENDEDPHRASE VARCHAR(255),
     DOUBTFUL BOOLEAN,

+    PUBLISH BOOLEAN,

     USENAMECACHE BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     USENAMECACHE BOOLEAN,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,


@@ -3899,6 +4166,8 @@ CREATE CACHED TABLE PUBLIC.TAXONNODE(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,

+    SORTINDEX INTEGER,
+    TREEINDEX VARCHAR(255),

     COUNTCHILDREN INTEGER NOT NULL,
     MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
     CREATEDBY_ID INTEGER,
     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,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,

+    SORTINDEX INTEGER,
+    TREEINDEX VARCHAR(255),

     COUNTCHILDREN INTEGER,
     MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
     CREATEDBY_ID INTEGER,
     COUNTCHILDREN INTEGER,
     MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
     CREATEDBY_ID INTEGER,


@@ -4016,6 +4287,7 @@ CREATE CACHED TABLE PUBLIC.TERMVOCABULARY(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,

+    TERMTYPE VARCHAR(4),

     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
     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),
     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
 );
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER
 );


@@ -4037,6 +4309,7 @@ CREATE CACHED TABLE PUBLIC.TERMVOCABULARY_AUD(
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,
     CREATED TIMESTAMP,
     UUID VARCHAR(36),
     UPDATED TIMESTAMP,

+    TERMTYPE VARCHAR(4),

     LSID_AUTHORITY VARCHAR(255),
     LSID_LSID VARCHAR(255),
     LSID_NAMESPACE VARCHAR(255),
     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),
     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
 );
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER
 );


@@ -4150,7 +4423,6 @@ CREATE CACHED TABLE PUBLIC.TYPEDESIGNATIONBASE(
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     CITATION_ID INTEGER,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     CITATION_ID INTEGER,

-    HOMOTYPICALGROUP_ID INTEGER,

     TYPESTATUS_ID INTEGER,
     TYPENAME_ID INTEGER,
     TYPESPECIMEN_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,
     CREATEDBY_ID INTEGER,
     UPDATEDBY_ID INTEGER,
     CITATION_ID INTEGER,

-    HOMOTYPICALGROUP_ID INTEGER,

     TYPESTATUS_ID INTEGER,
     CONSERVEDTYPE BOOLEAN,
     REJECTEDTYPE BOOLEAN,
     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;
     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;
 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.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.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;
 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.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;
 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.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.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;
 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.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;
 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.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.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.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;
 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.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;
 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.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.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;
 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.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;
 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.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.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;
 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.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;
 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.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;
 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.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;
 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.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;
 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.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;
 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.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.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;
 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.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;
 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.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.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.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.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;
 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.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;
 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.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;
 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;