Project

General

Profile

« Previous | Next » 

Revision c20d5dff

Added by Andreas Müller almost 9 years ago

Simplify table structure for CategoricalData-StateData and and QuantitativeData_StatisticalMeasurementValue #4841

View differences:

cdmlib-ext/src/test/resources/dbscripts/001-cdm.h2.sql
1586 1586 
    REVTYPE TINYINT
1587 1587 
);
1588 1588 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
1589 
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(
1590 
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1591 
    STATEDATA_ID INTEGER NOT NULL
1592 
);
1593 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA;
1594 
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(
1595 
    REV INTEGER NOT NULL,
1596 
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1597 
    STATEDATA_ID INTEGER NOT NULL,
1598 
    REVTYPE TINYINT
1599 
);
1600 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD;
1601 
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE(
1602 
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1603 
    STATISTICALVALUES_ID INTEGER NOT NULL
1604 
);
1605 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE;
1606 
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD(
1607 
    REV INTEGER NOT NULL,
1608 
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1609 
    STATISTICALVALUES_ID INTEGER NOT NULL,
1610 
    REVTYPE TINYINT
1611 
);
1612 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD;
1613 1589 
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT(
1614 1590 
    ID INTEGER NOT NULL,
1615 1591 
    CREATED TIMESTAMP,
......
4054 4030 
    UPDATED TIMESTAMP,
4055 4031 
    CREATEDBY_ID INTEGER,
4056 4032 
    UPDATEDBY_ID INTEGER,
4033 
	CATEGORICALDATA_ID INTEGER,
4057 4034 
    STATE_ID INTEGER
4058 4035 
);
4059 4036 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA;
......
4066 4043 
    UPDATED TIMESTAMP,
4067 4044 
    CREATEDBY_ID INTEGER,
4068 4045 
    UPDATEDBY_ID INTEGER,
4046 
	CATEGORICALDATA_ID INTEGER,
4069 4047 
    STATE_ID INTEGER
4070 4048 
);
4071 4049 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD;
......
4103 4081 
    VALUE DOUBLE NOT NULL,
4104 4082 
    CREATEDBY_ID INTEGER,
4105 4083 
    UPDATEDBY_ID INTEGER,
4084 
	QUANTITATIVEDATA_ID INTEGER,
4106 4085 
    TYPE_ID INTEGER
4107 4086 
);
4108 4087 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE;
......
4116 4095 
    VALUE DOUBLE,
4117 4096 
    CREATEDBY_ID INTEGER,
4118 4097 
    UPDATEDBY_ID INTEGER,
4098 
	QUANTITATIVEDATA_ID INTEGER,
4119 4099 
    TYPE_ID INTEGER
4120 4100 
);
4121 4101 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD;
......
5173 5153 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MARKERS_ID);
5174 5154 
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DC PRIMARY KEY(TYPEDESIGNATIONBASE_ID, MARKERS_ID);
5175 5155 
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F0 PRIMARY KEY(ID);
5176 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE8 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);
5177 5156 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE5 PRIMARY KEY(DEFINEDTERMBASE_ID, EXTENSIONS_ID);
5178 5157 
ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX539 PRIMARY KEY(ID);
5179 5158 
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43D PRIMARY KEY(GATHERINGEVENT_ID, MARKERS_ID);
......
5364 5343 
ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87CF PRIMARY KEY(MEDIA_ID, ANNOTATIONS_ID);
5365 5344 
ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8F PRIMARY KEY(REV, CLASSIFICATION_ID, RIGHTS_ID);
5366 5345 
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX95 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_PHONENUMBERS_ELEMENT);
5367 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);
5368 5346 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);
5369 5347 
ALTER TABLE PUBLIC.KEYSTATEMENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA6 PRIMARY KEY(ID, REV);
5370 5348 
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX698 PRIMARY KEY(REV, TAXONNAMEBASE_ID, MARKERS_ID);
......
5411 5389 
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX48 PRIMARY KEY(ID, REV);
5412 5390 
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID);
5413 5391 
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID);
5414 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);
5415 5392 
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);
5416 5393 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
5417 5394 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
......
5698 5675 
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4D7 UNIQUE(ANNOTATIONS_ID);
5699 5676 
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F0 UNIQUE(EXTENSIONS_ID);
5700 5677 
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFB UNIQUE(ANNOTATIONS_ID);
5701 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DF UNIQUE(STATISTICALVALUES_ID);
5702 5678 
ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED4 UNIQUE(CREDITS_ID);
5703 5679 
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D78 UNIQUE(STATUS_ID);
5704 5680 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5094 UNIQUE(MULTILANGUAGETEXT_ID);
......
5735 5711 
ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.FKD21E7935C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
5736 5712 
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5737 5713 
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5738 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.FK1D0A1EBE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5739 5714 
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7C777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
5740 5715 
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
5741 5716 
ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK99ABA37B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
5917 5892 
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5918 5893 
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5919 5894 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
5920 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5921 5895 
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5922 5896 
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5923 5897 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
......
5939 5913 
ALTER TABLE PUBLIC.CLASSIFICATION_MARKER ADD CONSTRAINT PUBLIC.FK59778AB3777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
5940 5914 
ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.FK76DDD01B1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
5941 5915 
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.FK3C8E1FF916B9CA77 FOREIGN KEY(INSTITUTE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5942 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.FK2DE8E9334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5943 5916 
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.FK2331098134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5944 5917 
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.FK6BEDC7EE8D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
5945 5918 
ALTER TABLE PUBLIC.TERMVOCABULARY_AUD ADD CONSTRAINT PUBLIC.FKA6ED3B6334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6038 6011 
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.FK1966BDB14FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6039 6012 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK6E6F45734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6040 6013 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.FK6FF15DFCC9CD5B57 FOREIGN KEY(RECOMMENDEDSTATISTICALMEASURES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6041 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D987CC6A4 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;
6042 6014 
ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK812DE753DA9DCB5F FOREIGN KEY(GROUPS_ID) REFERENCES PUBLIC.PERMISSIONGROUP(ID) NOCHECK;
6043 6015 
--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK4616A015D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
6044 6016 
ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
......
6145 6117 
ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FKFD724D851857F6C2 FOREIGN KEY(GRANTEDAUTHORITIES_ID) REFERENCES PUBLIC.GRANTEDAUTHORITYIMPL(ID) NOCHECK;
6146 6118 
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.FK8DA633B0777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6147 6119 
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.FK160DF9F734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6148 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C2D883945E FOREIGN KEY(STATISTICALVALUES_ID) REFERENCES PUBLIC.STATISTICALMEASUREMENTVALUE(ID) NOCHECK;
6149 6120 
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FK8E6106C73B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
6150 6121 
ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK44D5F7D81E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6151 6122 
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F38C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
......
6511 6482 
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE ADD CONSTRAINT PUBLIC.FK8FB1ED836BE0BFDA FOREIGN KEY(DETERMINATIONEVENT_ID) REFERENCES PUBLIC.DETERMINATIONEVENT(ID) NOCHECK;
6512 6483 
ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.FK230A885F7208BB38 FOREIGN KEY(SUPERVIEWS_ID) REFERENCES PUBLIC.CDM_VIEW(ID) NOCHECK;
6513 6484 
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.FKA75C411534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6514 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C28F213219 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;
6515 6485 
ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK69D9A11AF95F225A FOREIGN KEY(GATHERINGEVENT_ID) REFERENCES PUBLIC.GATHERINGEVENT(ID) NOCHECK;
6516 6486 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.FKA72FB5AED0BDAE9B FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6517 6487 
ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.FK1DB2497AEC8CCAA FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
cdmlib-io/src/test/resources/dbscripts/001-cdm.h2.sql
1586 1586 
    REVTYPE TINYINT
1587 1587 
);
1588 1588 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD;
1589 
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(
1590 
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1591 
    STATEDATA_ID INTEGER NOT NULL
1592 
);
1593 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA;
1594 
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(
1595 
    REV INTEGER NOT NULL,
1596 
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1597 
    STATEDATA_ID INTEGER NOT NULL,
1598 
    REVTYPE TINYINT
1599 
);
1600 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD;
1601 
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE(
1602 
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1603 
    STATISTICALVALUES_ID INTEGER NOT NULL
1604 
);
1605 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE;
1606 
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD(
1607 
    REV INTEGER NOT NULL,
1608 
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,
1609 
    STATISTICALVALUES_ID INTEGER NOT NULL,
1610 
    REVTYPE TINYINT
1611 
);
1612 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD;
1613 1589 
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT(
1614 1590 
    ID INTEGER NOT NULL,
1615 1591 
    CREATED TIMESTAMP,
......
4054 4030 
    UPDATED TIMESTAMP,
4055 4031 
    CREATEDBY_ID INTEGER,
4056 4032 
    UPDATEDBY_ID INTEGER,
4033 
	CATEGORICALDATA_ID INTEGER,
4057 4034 
    STATE_ID INTEGER
4058 4035 
);
4059 4036 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA;
......
4066 4043 
    UPDATED TIMESTAMP,
4067 4044 
    CREATEDBY_ID INTEGER,
4068 4045 
    UPDATEDBY_ID INTEGER,
4046 
	CATEGORICALDATA_ID INTEGER,
4069 4047 
    STATE_ID INTEGER
4070 4048 
);
4071 4049 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD;
......
4103 4081 
    VALUE DOUBLE NOT NULL,
4104 4082 
    CREATEDBY_ID INTEGER,
4105 4083 
    UPDATEDBY_ID INTEGER,
4084 
	QUANTITATIVEDATA_ID INTEGER,
4106 4085 
    TYPE_ID INTEGER
4107 4086 
);
4108 4087 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE;
......
4116 4095 
    VALUE DOUBLE,
4117 4096 
    CREATEDBY_ID INTEGER,
4118 4097 
    UPDATEDBY_ID INTEGER,
4098 
	QUANTITATIVEDATA_ID INTEGER,
4119 4099 
    TYPE_ID INTEGER
4120 4100 
);
4121 4101 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD;
......
5173 5153 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MARKERS_ID);
5174 5154 
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DC PRIMARY KEY(TYPEDESIGNATIONBASE_ID, MARKERS_ID);
5175 5155 
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F0 PRIMARY KEY(ID);
5176 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE8 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);
5177 5156 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE5 PRIMARY KEY(DEFINEDTERMBASE_ID, EXTENSIONS_ID);
5178 5157 
ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX539 PRIMARY KEY(ID);
5179 5158 
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43D PRIMARY KEY(GATHERINGEVENT_ID, MARKERS_ID);
......
5364 5343 
ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX87CF PRIMARY KEY(MEDIA_ID, ANNOTATIONS_ID);
5365 5344 
ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8F PRIMARY KEY(REV, CLASSIFICATION_ID, RIGHTS_ID);
5366 5345 
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX95 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_PHONENUMBERS_ELEMENT);
5367 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);
5368 5346 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);
5369 5347 
ALTER TABLE PUBLIC.KEYSTATEMENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA6 PRIMARY KEY(ID, REV);
5370 5348 
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX698 PRIMARY KEY(REV, TAXONNAMEBASE_ID, MARKERS_ID);
......
5411 5389 
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX48 PRIMARY KEY(ID, REV);
5412 5390 
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB PRIMARY KEY(COLLECTION_ID, EXTENSIONS_ID);
5413 5391 
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_INAPPLICABLEIF_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB3 PRIMARY KEY(REV, FEATURENODE_ID, INAPPLICABLEIF_ID);
5414 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);
5415 5392 
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);
5416 5393 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
5417 5394 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB7 PRIMARY KEY(POLYTOMOUSKEY_ID, SCOPERESTRICTIONS_ID);
......
5698 5675 
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4D7 UNIQUE(ANNOTATIONS_ID);
5699 5676 
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F0 UNIQUE(EXTENSIONS_ID);
5700 5677 
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFB UNIQUE(ANNOTATIONS_ID);
5701 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DF UNIQUE(STATISTICALVALUES_ID);
5702 5678 
ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED4 UNIQUE(CREDITS_ID);
5703 5679 
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D78 UNIQUE(STATUS_ID);
5704 5680 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5094 UNIQUE(MULTILANGUAGETEXT_ID);
......
5735 5711 
ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.FKD21E7935C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
5736 5712 
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5737 5713 
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5738 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.FK1D0A1EBE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5739 5714 
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7C777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
5740 5715 
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
5741 5716 
ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK99ABA37B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
5917 5892 
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5918 5893 
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5919 5894 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
5920 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
5921 5895 
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5922 5896 
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5923 5897 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B1232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
......
5939 5913 
ALTER TABLE PUBLIC.CLASSIFICATION_MARKER ADD CONSTRAINT PUBLIC.FK59778AB3777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
5940 5914 
ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.FK76DDD01B1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
5941 5915 
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.FK3C8E1FF916B9CA77 FOREIGN KEY(INSTITUTE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5942 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.FK2DE8E9334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5943 5916 
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.FK2331098134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5944 5917 
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.FK6BEDC7EE8D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
5945 5918 
ALTER TABLE PUBLIC.TERMVOCABULARY_AUD ADD CONSTRAINT PUBLIC.FKA6ED3B6334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6038 6011 
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.FK1966BDB14FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6039 6012 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK6E6F45734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6040 6013 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.FK6FF15DFCC9CD5B57 FOREIGN KEY(RECOMMENDEDSTATISTICALMEASURES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6041 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D987CC6A4 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;
6042 6014 
ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK812DE753DA9DCB5F FOREIGN KEY(GROUPS_ID) REFERENCES PUBLIC.PERMISSIONGROUP(ID) NOCHECK;
6043 6015 
--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK4616A015D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
6044 6016 
ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
......
6145 6117 
ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FKFD724D851857F6C2 FOREIGN KEY(GRANTEDAUTHORITIES_ID) REFERENCES PUBLIC.GRANTEDAUTHORITYIMPL(ID) NOCHECK;
6146 6118 
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.FK8DA633B0777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6147 6119 
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.FK160DF9F734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6148 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C2D883945E FOREIGN KEY(STATISTICALVALUES_ID) REFERENCES PUBLIC.STATISTICALMEASUREMENTVALUE(ID) NOCHECK;
6149 6120 
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FK8E6106C73B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
6150 6121 
ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK44D5F7D81E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6151 6122 
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F38C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
......
6511 6482 
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE ADD CONSTRAINT PUBLIC.FK8FB1ED836BE0BFDA FOREIGN KEY(DETERMINATIONEVENT_ID) REFERENCES PUBLIC.DETERMINATIONEVENT(ID) NOCHECK;
6512 6483 
ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.FK230A885F7208BB38 FOREIGN KEY(SUPERVIEWS_ID) REFERENCES PUBLIC.CDM_VIEW(ID) NOCHECK;
6513 6484 
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.FKA75C411534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6514 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C28F213219 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;
6515 6485 
ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK69D9A11AF95F225A FOREIGN KEY(GATHERINGEVENT_ID) REFERENCES PUBLIC.GATHERINGEVENT(ID) NOCHECK;
6516 6486 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.FKA72FB5AED0BDAE9B FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6517 6487 
ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.FK1DB2497AEC8CCAA FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/description/StateData.java
17 17 

  		




  18
  18
  
    
import javax.persistence.Entity;


  		




  19
  19
  
    
import javax.persistence.FetchType;


  		




  20
  
  
    
import javax.persistence.JoinColumn;


  		




  21
  
  
    
import javax.persistence.JoinTable;


  		




  22
  20
  
    
import javax.persistence.ManyToMany;


  		




  23
  21
  
    
import javax.persistence.ManyToOne;


  		




  24
  22
  
    
import javax.persistence.MapKeyJoinColumn;


  		




  ......




  90
  88
  
    
    @XmlIDREF


  		




  91
  89
  
    
    @XmlSchemaType(name = "IDREF")


  		




  92
  90
  
    
    @ManyToOne(fetch = FetchType.LAZY )


  		




  93
  
  
    
    @JoinTable(


  		




  94
  
  
    
            name = "DescriptionElementBase_StateData"


  		




  95
  
  
    
          , joinColumns = @JoinColumn(name = "statedata_id")


  		




  96
  
  
    
          , inverseJoinColumns = @JoinColumn(name = "DescriptionElementBase_id")


  		




  97
  
  
    

  		




  98
  
  
    
        )


  		




  99
  91
  
    
    @IndexedEmbedded(depth=1)


  		




  100
  92
  
    
    private CategoricalData categoricalData;


  		




  101
  93
  
    

  		












  

    
      cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/description/StatisticalMeasurementValue.java
    
  





  15
  15
  
    

  		




  16
  16
  
    
import javax.persistence.Entity;


  		




  17
  17
  
    
import javax.persistence.FetchType;


  		




  18
  
  
    
import javax.persistence.JoinColumn;


  		




  19
  
  
    
import javax.persistence.JoinTable;


  		




  20
  18
  
    
import javax.persistence.ManyToMany;


  		




  21
  19
  
    
import javax.persistence.ManyToOne;


  		




  22
  20
  
    
import javax.xml.bind.annotation.XmlAccessType;


  		




  ......




  81
  79
  
    
    @XmlIDREF


  		




  82
  80
  
    
    @XmlSchemaType(name = "IDREF")


  		




  83
  81
  
    
    @ManyToOne(fetch = FetchType.LAZY )


  		




  84
  
  
    
    @JoinTable(


  		




  85
  
  
    
         name = "DescriptionElementBase_StatisticalMeasurementValue"


  		




  86
  
  
    
             , joinColumns = @JoinColumn(name = "statisticalvalues_id")


  		




  87
  
  
    
             , inverseJoinColumns = @JoinColumn(name = "DescriptionElementBase_id")


  		




  88
  
  
    
    )


  		




  89
  82
  
    
    @IndexedEmbedded(depth=1)


  		




  90
  83
  
    
	private QuantitativeData quantitativeData;


  		




  91
  84
  
    

  		












  

    
      cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v35_36/SchemaUpdater_35_36.java
    
  





  117
  117
  
    
        newColumnName = "rightCutPosition";


  		




  118
  118
  
    
        step = MnTableRemover.NewInstance(stepName,


  		




  119
  119
  
    
                tableName,


  		




  120
  
  
    
                "descriptionElementBase_id",


  		




  
  120
  
    
                "categoricaldata_id",


  		




  121
  121
  
    
                "DescriptionElementBase_id",


  		




  122
  122
  
    
                "statedata_id",


  		




  123
  123
  
    
                "DescriptionElementBase",


  		












  

    
      cdmlib-persistence/src/test/resources/dbscripts/001-cdm.h2.sql
    
  





  1586
  1586
  
    
    REVTYPE TINYINT


  		




  1587
  1587
  
    
);


  		




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


  		




  1589
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(


  		




  1590
  
  
    
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,


  		




  1591
  
  
    
    STATEDATA_ID INTEGER NOT NULL


  		




  1592
  
  
    
);


  		




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


  		




  1594
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(


  		




  1595
  
  
    
    REV INTEGER NOT NULL,


  		




  1596
  
  
    
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,


  		




  1597
  
  
    
    STATEDATA_ID INTEGER NOT NULL,


  		




  1598
  
  
    
    REVTYPE TINYINT


  		




  1599
  
  
    
);


  		




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


  		




  1601
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE(


  		




  1602
  
  
    
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,


  		




  1603
  
  
    
    STATISTICALVALUES_ID INTEGER NOT NULL


  		




  1604
  
  
    
);


  		




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


  		




  1606
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD(


  		




  1607
  
  
    
    REV INTEGER NOT NULL,


  		




  1608
  
  
    
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,


  		




  1609
  
  
    
    STATISTICALVALUES_ID INTEGER NOT NULL,


  		




  1610
  
  
    
    REVTYPE TINYINT


  		




  1611
  
  
    
);


  		




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


  		




  1613
  1589
  
    
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT(


  		




  1614
  1590
  
    
    ID INTEGER NOT NULL,


  		




  1615
  1591
  
    
    CREATED TIMESTAMP,


  		




  ......




  4054
  4030
  
    
    UPDATED TIMESTAMP,


  		




  4055
  4031
  
    
    CREATEDBY_ID INTEGER,


  		




  4056
  4032
  
    
    UPDATEDBY_ID INTEGER,


  		




  
  4033
  
    
	CATEGORICALDATA_ID INTEGER,


  		




  4057
  4034
  
    
    STATE_ID INTEGER


  		




  4058
  4035
  
    
);


  		




  4059
  4036
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA;


  		




  ......




  4066
  4043
  
    
    UPDATED TIMESTAMP,


  		




  4067
  4044
  
    
    CREATEDBY_ID INTEGER,


  		




  4068
  4045
  
    
    UPDATEDBY_ID INTEGER,


  		




  
  4046
  
    
	CATEGORICALDATA_ID INTEGER,


  		




  4069
  4047
  
    
    STATE_ID INTEGER


  		




  4070
  4048
  
    
);


  		




  4071
  4049
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD;


  		




  ......




  4103
  4081
  
    
    VALUE DOUBLE NOT NULL,


  		




  4104
  4082
  
    
    CREATEDBY_ID INTEGER,


  		




  4105
  4083
  
    
    UPDATEDBY_ID INTEGER,


  		




  
  4084
  
    
	QUANTITATIVEDATA_ID INTEGER,


  		




  4106
  4085
  
    
    TYPE_ID INTEGER


  		




  4107
  4086
  
    
);


  		




  4108
  4087
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE;


  		




  ......




  4116
  4095
  
    
    VALUE DOUBLE,


  		




  4117
  4096
  
    
    CREATEDBY_ID INTEGER,


  		




  4118
  4097
  
    
    UPDATEDBY_ID INTEGER,


  		




  
  4098
  
    
	QUANTITATIVEDATA_ID INTEGER,


  		




  4119
  4099
  
    
    TYPE_ID INTEGER


  		




  4120
  4100
  
    
);


  		




  4121
  4101
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD;


  		




  ......




  5173
  5153
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MARKERS_ID);


  		




  5174
  5154
  
    
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DC PRIMARY KEY(TYPEDESIGNATIONBASE_ID, MARKERS_ID);


  		




  5175
  5155
  
    
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F0 PRIMARY KEY(ID);


  		




  5176
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE8 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);


  		




  5177
  5156
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE5 PRIMARY KEY(DEFINEDTERMBASE_ID, EXTENSIONS_ID);


  		




  5178
  5157
  
    
ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX539 PRIMARY KEY(ID);


  		




  5179
  5158
  
    
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43D PRIMARY KEY(GATHERINGEVENT_ID, MARKERS_ID);


  		




  ......




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


  		




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


  		




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


  		




  5367
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);


  		




  5368
  5346
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  5414
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);


  		




  5415
  5392
  
    
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);


  		




  5416
  5393
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);


  		




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


  		




  ......




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


  		




  5699
  5676
  
    
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F0 UNIQUE(EXTENSIONS_ID);


  		




  5700
  5677
  
    
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFB UNIQUE(ANNOTATIONS_ID);


  		




  5701
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DF UNIQUE(STATISTICALVALUES_ID);


  		




  5702
  5678
  
    
ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED4 UNIQUE(CREDITS_ID);


  		




  5703
  5679
  
    
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D78 UNIQUE(STATUS_ID);


  		




  5704
  5680
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5094 UNIQUE(MULTILANGUAGETEXT_ID);


  		




  ......




  5735
  5711
  
    
ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.FKD21E7935C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;


  		




  5736
  5712
  
    
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  5737
  5713
  
    
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;


  		




  5738
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.FK1D0A1EBE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  5739
  5714
  
    
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7C777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;


  		




  5740
  5715
  
    
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;


  		




  5741
  5716
  
    
ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK99ABA37B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  ......




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


  		




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


  		




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


  		




  5920
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;


  		




  5921
  5895
  
    
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;


  		




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


  		




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


  		




  ......




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


  		




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


  		




  5941
  5915
  
    
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.FK3C8E1FF916B9CA77 FOREIGN KEY(INSTITUTE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;


  		




  5942
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.FK2DE8E9334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  5943
  5916
  
    
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.FK2331098134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  5944
  5917
  
    
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.FK6BEDC7EE8D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;


  		




  5945
  5918
  
    
ALTER TABLE PUBLIC.TERMVOCABULARY_AUD ADD CONSTRAINT PUBLIC.FKA6ED3B6334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  ......




  6038
  6011
  
    
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.FK1966BDB14FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;


  		




  6039
  6012
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK6E6F45734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  6040
  6013
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.FK6FF15DFCC9CD5B57 FOREIGN KEY(RECOMMENDEDSTATISTICALMEASURES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;


  		




  6041
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D987CC6A4 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;


  		




  6042
  6014
  
    
ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK812DE753DA9DCB5F FOREIGN KEY(GROUPS_ID) REFERENCES PUBLIC.PERMISSIONGROUP(ID) NOCHECK;


  		




  6043
  6015
  
    
--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK4616A015D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;


  		




  6044
  6016
  
    
ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;


  		




  ......




  6145
  6117
  
    
ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FKFD724D851857F6C2 FOREIGN KEY(GRANTEDAUTHORITIES_ID) REFERENCES PUBLIC.GRANTEDAUTHORITYIMPL(ID) NOCHECK;


  		




  6146
  6118
  
    
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.FK8DA633B0777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;


  		




  6147
  6119
  
    
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.FK160DF9F734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  6148
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C2D883945E FOREIGN KEY(STATISTICALVALUES_ID) REFERENCES PUBLIC.STATISTICALMEASUREMENTVALUE(ID) NOCHECK;


  		




  6149
  6120
  
    
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FK8E6106C73B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;


  		




  6150
  6121
  
    
ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK44D5F7D81E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;


  		




  6151
  6122
  
    
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F38C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;


  		




  ......




  6511
  6482
  
    
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE ADD CONSTRAINT PUBLIC.FK8FB1ED836BE0BFDA FOREIGN KEY(DETERMINATIONEVENT_ID) REFERENCES PUBLIC.DETERMINATIONEVENT(ID) NOCHECK;


  		




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


  		




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


  		




  6514
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C28F213219 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;


  		




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


  		




  6516
  6486
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.FKA72FB5AED0BDAE9B FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;


  		




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


  		












  

    
      cdmlib-persistence/src/test/resources/eu/etaxonomy/cdm/database/ClearDBDataSet.xml
    
  





  150
  150
  
    
  <DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD/>


  		




  151
  151
  
    
  <DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE/>


  		




  152
  152
  
    
  <DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD/>


  		




  153
  
  
    
  <DESCRIPTIONELEMENTBASE_STATEDATA/>


  		




  154
  
  
    
  <DESCRIPTIONELEMENTBASE_STATEDATA_AUD/>


  		




  155
  
  
    
  <DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE/>


  		




  156
  
  
    
  <DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD/>


  		




  157
  153
  
    
  <DETERMINATIONEVENT/>


  		




  158
  154
  
    
  <DETERMINATIONEVENT_ANNOTATION/>


  		




  159
  155
  
    
  <DETERMINATIONEVENT_ANNOTATION_AUD/>


  		












  

    
      cdmlib-persistence/src/test/resources/eu/etaxonomy/cdm/persistence/dao/hibernate/dataset.dtd
    
  





  99
  99
  
    
    DESCRIPTIONELEMENTBASE_MODIFIER_AUD*,


  		




  100
  100
  
    
    DESCRIPTIONELEMENTBASE_MODIFYINGTEXT*,


  		




  101
  101
  
    
    DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD*,


  		




  102
  
  
    
    DESCRIPTIONELEMENTBASE_STATEDATA*,


  		




  103
  
  
    
    DESCRIPTIONELEMENTBASE_STATEDATA_AUD*,


  		




  104
  
  
    
    DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE*,


  		




  105
  
  
    
    DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD*,


  		




  106
  102
  
    
    DETERMINATIONEVENT*,


  		




  107
  103
  
    
    DETERMINATIONEVENT_ANNOTATION*,


  		




  108
  104
  
    
    DETERMINATIONEVENT_ANNOTATION_AUD*,


  		




  ......




  1327
  1323
  
    
    REVTYPE CDATA #IMPLIED


  		




  1328
  1324
  
    
>


  		




  1329
  1325
  
    

  		




  1330
  
  
    
<!ELEMENT DESCRIPTIONELEMENTBASE_STATEDATA EMPTY>


  		




  1331
  
  
    
<!ATTLIST DESCRIPTIONELEMENTBASE_STATEDATA


  		




  1332
  
  
    
    DESCRIPTIONELEMENTBASE_ID CDATA #IMPLIED


  		




  1333
  
  
    
    STATEDATA_ID CDATA #IMPLIED


  		




  1334
  
  
    
>


  		




  1335
  
  
    

  		




  1336
  
  
    
<!ELEMENT DESCRIPTIONELEMENTBASE_STATEDATA_AUD EMPTY>


  		




  1337
  
  
    
<!ATTLIST DESCRIPTIONELEMENTBASE_STATEDATA_AUD


  		




  1338
  
  
    
    REV CDATA #REQUIRED


  		




  1339
  
  
    
    DESCRIPTIONELEMENTBASE_ID CDATA #REQUIRED


  		




  1340
  
  
    
    STATEDATA_ID CDATA #REQUIRED


  		




  1341
  
  
    
    REVTYPE CDATA #IMPLIED


  		




  1342
  
  
    
>


  		




  1343
  
  
    

  		




  1344
  
  
    
<!ELEMENT DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE EMPTY>


  		




  1345
  
  
    
<!ATTLIST DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE


  		




  1346
  
  
    
    DESCRIPTIONELEMENTBASE_ID CDATA #REQUIRED


  		




  1347
  
  
    
    STATISTICALVALUES_ID CDATA #REQUIRED


  		




  1348
  
  
    
>


  		




  1349
  
  
    

  		




  1350
  
  
    
<!ELEMENT DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD EMPTY>


  		




  1351
  
  
    
<!ATTLIST DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD


  		




  1352
  
  
    
    REV CDATA #REQUIRED


  		




  1353
  
  
    
    DESCRIPTIONELEMENTBASE_ID CDATA #REQUIRED


  		




  1354
  
  
    
    STATISTICALVALUES_ID CDATA #REQUIRED


  		




  1355
  
  
    
    REVTYPE CDATA #IMPLIED


  		




  1356
  
  
    
>


  		




  1357
  
  
    

  		




  1358
  1326
  
    
<!ELEMENT DETERMINATIONEVENT EMPTY>


  		




  1359
  1327
  
    
<!ATTLIST DETERMINATIONEVENT


  		




  1360
  1328
  
    
    ID CDATA #REQUIRED


  		












  

    
      cdmlib-persistence/src/test/resources/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonDaoHibernateImplTest.testGetTaxaByNameAndArea.xml
    
  





  245
  245
  
    
  <TAXONRELATIONSHIP ID="2" CREATED="2009-06-18 13:47:59.0" UUID="8d50cecd-c59c-4567-b6f3-4595550c49fa" RELATEDFROM_ID="1" RELATEDTO_ID="19" DOUBTFUL="false" TYPE_ID="888"/>


  		




  246
  246
  
    
  <TAXONRELATIONSHIP_AUD ID="2" REV="1025" REVTYPE="0" CREATED="2009-06-18 13:47:59.0" UUID="8d50cecd-c59c-4567-b6f3-4595550c49fa" RELATEDFROM_ID="1" RELATEDTO_ID="19" DOUBTFUL="false" TYPE_ID="888"/>


  		




  247
  247
  
    

  		




  248
  
  
    
	<TAXONRELATIONSHIP ID="3" CREATED="2009-06-18 13:47:59.0" UUID="f802fd48-26cf-4aec-8d15-6ff542711829" RELATEDFROM_ID="20" RELATEDTO_ID="21" DOUBTFUL="false" TYPE_ID="888"/>


  		




  
  248
  
    
  <TAXONRELATIONSHIP ID="3" CREATED="2009-06-18 13:47:59.0" UUID="f802fd48-26cf-4aec-8d15-6ff542711829" RELATEDFROM_ID="20" RELATEDTO_ID="21" DOUBTFUL="false" TYPE_ID="888"/>


  		




  249
  249
  
    
  <TAXONRELATIONSHIP_AUD ID="3" REV="1025" REVTYPE="0" CREATED="2009-06-18 13:47:59.0" UUID="f802fd48-26cf-4aec-8d15-6ff542711829" RELATEDFROM_ID="20" RELATEDTO_ID="21" DOUBTFUL="false" TYPE_ID="888"/>


  		




  250
  250
  
    

  		




  251
  251
  
    

  		












  

    
      cdmlib-persistence/src/test/resources/eu/etaxonomy/cdm/persistence/dao/jdbc/dataset.dtd
    
  





  99
  99
  
    
    DESCRIPTIONELEMENTBASE_MODIFIER_AUD*,


  		




  100
  100
  
    
    DESCRIPTIONELEMENTBASE_MODIFYINGTEXT*,


  		




  101
  101
  
    
    DESCRIPTIONELEMENTBASE_MODIFYINGTEXT_AUD*,


  		




  102
  
  
    
    DESCRIPTIONELEMENTBASE_STATEDATA*,


  		




  103
  
  
    
    DESCRIPTIONELEMENTBASE_STATEDATA_AUD*,


  		




  104
  
  
    
    DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE*,


  		




  105
  
  
    
    DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD*,


  		




  106
  102
  
    
    DETERMINATIONEVENT*,


  		




  107
  103
  
    
    DETERMINATIONEVENT_ANNOTATION*,


  		




  108
  104
  
    
    DETERMINATIONEVENT_ANNOTATION_AUD*,


  		




  ......




  1327
  1323
  
    
    REVTYPE CDATA #IMPLIED


  		




  1328
  1324
  
    
>


  		




  1329
  1325
  
    

  		




  1330
  
  
    
<!ELEMENT DESCRIPTIONELEMENTBASE_STATEDATA EMPTY>


  		




  1331
  
  
    
<!ATTLIST DESCRIPTIONELEMENTBASE_STATEDATA


  		




  1332
  
  
    
    DESCRIPTIONELEMENTBASE_ID CDATA #IMPLIED


  		




  1333
  
  
    
    STATEDATA_ID CDATA #IMPLIED


  		




  1334
  
  
    
>


  		




  1335
  
  
    

  		




  1336
  
  
    
<!ELEMENT DESCRIPTIONELEMENTBASE_STATEDATA_AUD EMPTY>


  		




  1337
  
  
    
<!ATTLIST DESCRIPTIONELEMENTBASE_STATEDATA_AUD


  		




  1338
  
  
    
    REV CDATA #REQUIRED


  		




  1339
  
  
    
    DESCRIPTIONELEMENTBASE_ID CDATA #REQUIRED


  		




  1340
  
  
    
    STATEDATA_ID CDATA #REQUIRED


  		




  1341
  
  
    
    REVTYPE CDATA #IMPLIED


  		




  1342
  
  
    
>


  		




  1343
  
  
    

  		




  1344
  
  
    
<!ELEMENT DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE EMPTY>


  		




  1345
  
  
    
<!ATTLIST DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE


  		




  1346
  
  
    
    DESCRIPTIONELEMENTBASE_ID CDATA #REQUIRED


  		




  1347
  
  
    
    STATISTICALVALUES_ID CDATA #REQUIRED


  		




  1348
  
  
    
>


  		




  1349
  
  
    

  		




  1350
  
  
    
<!ELEMENT DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD EMPTY>


  		




  1351
  
  
    
<!ATTLIST DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD


  		




  1352
  
  
    
    REV CDATA #REQUIRED


  		




  1353
  
  
    
    DESCRIPTIONELEMENTBASE_ID CDATA #REQUIRED


  		




  1354
  
  
    
    STATISTICALVALUES_ID CDATA #REQUIRED


  		




  1355
  
  
    
    REVTYPE CDATA #IMPLIED


  		




  1356
  
  
    
>


  		




  1357
  
  
    

  		




  1358
  1326
  
    
<!ELEMENT DETERMINATIONEVENT EMPTY>


  		




  1359
  1327
  
    
<!ATTLIST DETERMINATIONEVENT


  		




  1360
  1328
  
    
    ID CDATA #REQUIRED


  		












  

    
      cdmlib-services/src/test/resources/dbscripts/001-cdm.h2.sql
    
  





  1586
  1586
  
    
    REVTYPE TINYINT


  		




  1587
  1587
  
    
);


  		




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


  		




  1589
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA(


  		




  1590
  
  
    
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,


  		




  1591
  
  
    
    STATEDATA_ID INTEGER NOT NULL


  		




  1592
  
  
    
);


  		




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


  		




  1594
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD(


  		




  1595
  
  
    
    REV INTEGER NOT NULL,


  		




  1596
  
  
    
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,


  		




  1597
  
  
    
    STATEDATA_ID INTEGER NOT NULL,


  		




  1598
  
  
    
    REVTYPE TINYINT


  		




  1599
  
  
    
);


  		




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


  		




  1601
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE(


  		




  1602
  
  
    
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,


  		




  1603
  
  
    
    STATISTICALVALUES_ID INTEGER NOT NULL


  		




  1604
  
  
    
);


  		




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


  		




  1606
  
  
    
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD(


  		




  1607
  
  
    
    REV INTEGER NOT NULL,


  		




  1608
  
  
    
    DESCRIPTIONELEMENTBASE_ID INTEGER NOT NULL,


  		




  1609
  
  
    
    STATISTICALVALUES_ID INTEGER NOT NULL,


  		




  1610
  
  
    
    REVTYPE TINYINT


  		




  1611
  
  
    
);


  		




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


  		




  1613
  1589
  
    
CREATE CACHED TABLE PUBLIC.DETERMINATIONEVENT(


  		




  1614
  1590
  
    
    ID INTEGER NOT NULL,


  		




  1615
  1591
  
    
    CREATED TIMESTAMP,


  		




  ......




  4054
  4030
  
    
    UPDATED TIMESTAMP,


  		




  4055
  4031
  
    
    CREATEDBY_ID INTEGER,


  		




  4056
  4032
  
    
    UPDATEDBY_ID INTEGER,


  		




  
  4033
  
    
	CATEGORICALDATA_ID INTEGER,


  		




  4057
  4034
  
    
    STATE_ID INTEGER


  		




  4058
  4035
  
    
);


  		




  4059
  4036
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA;


  		




  ......




  4066
  4043
  
    
    UPDATED TIMESTAMP,


  		




  4067
  4044
  
    
    CREATEDBY_ID INTEGER,


  		




  4068
  4045
  
    
    UPDATEDBY_ID INTEGER,


  		




  
  4046
  
    
	CATEGORICALDATA_ID INTEGER,


  		




  4069
  4047
  
    
    STATE_ID INTEGER


  		




  4070
  4048
  
    
);


  		




  4071
  4049
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATEDATA_AUD;


  		




  ......




  4103
  4081
  
    
    VALUE DOUBLE NOT NULL,


  		




  4104
  4082
  
    
    CREATEDBY_ID INTEGER,


  		




  4105
  4083
  
    
    UPDATEDBY_ID INTEGER,


  		




  
  4084
  
    
	QUANTITATIVEDATA_ID INTEGER,


  		




  4106
  4085
  
    
    TYPE_ID INTEGER


  		




  4107
  4086
  
    
);


  		




  4108
  4087
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE;


  		




  ......




  4116
  4095
  
    
    VALUE DOUBLE,


  		




  4117
  4096
  
    
    CREATEDBY_ID INTEGER,


  		




  4118
  4097
  
    
    UPDATEDBY_ID INTEGER,


  		




  
  4098
  
    
	QUANTITATIVEDATA_ID INTEGER,


  		




  4119
  4099
  
    
    TYPE_ID INTEGER


  		




  4120
  4100
  
    
);


  		




  4121
  4101
  
    
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.STATISTICALMEASUREMENTVALUE_AUD;


  		




  ......




  5173
  5153
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE9 PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, MARKERS_ID);


  		




  5174
  5154
  
    
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DC PRIMARY KEY(TYPEDESIGNATIONBASE_ID, MARKERS_ID);


  		




  5175
  5155
  
    
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F0 PRIMARY KEY(ID);


  		




  5176
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE8 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);


  		




  5177
  5156
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE5 PRIMARY KEY(DEFINEDTERMBASE_ID, EXTENSIONS_ID);


  		




  5178
  5157
  
    
ALTER TABLE PUBLIC.SYNONYMRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX539 PRIMARY KEY(ID);


  		




  5179
  5158
  
    
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43D PRIMARY KEY(GATHERINGEVENT_ID, MARKERS_ID);


  		




  ......




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


  		




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


  		




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


  		




  5367
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, STATISTICALVALUES_ID);


  		




  5368
  5346
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  5414
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB0 PRIMARY KEY(REV, DESCRIPTIONELEMENTBASE_ID, STATEDATA_ID);


  		




  5415
  5392
  
    
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB1 PRIMARY KEY(PERMISSIONGROUP_ID, GRANTEDAUTHORITIES_ID);


  		




  5416
  5393
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB6 PRIMARY KEY(DEFINEDTERMBASE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);


  		




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


  		




  ......




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


  		




  5699
  5676
  
    
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F0 UNIQUE(EXTENSIONS_ID);


  		




  5700
  5677
  
    
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFB UNIQUE(ANNOTATIONS_ID);


  		




  5701
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8DF UNIQUE(STATISTICALVALUES_ID);


  		




  5702
  5678
  
    
ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED4 UNIQUE(CREDITS_ID);


  		




  5703
  5679
  
    
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D78 UNIQUE(STATUS_ID);


  		




  5704
  5680
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5094 UNIQUE(MULTILANGUAGETEXT_ID);


  		




  ......




  5735
  5711
  
    
ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.FKD21E7935C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;


  		




  5736
  5712
  
    
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  5737
  5713
  
    
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORTEAM_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;


  		




  5738
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA_AUD ADD CONSTRAINT PUBLIC.FK1D0A1EBE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  5739
  5714
  
    
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7C777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;


  		




  5740
  5715
  
    
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;


  		




  5741
  5716
  
    
ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK99ABA37B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  ......




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


  		




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


  		




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


  		




  5920
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D15153604 FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;


  		




  5921
  5895
  
    
ALTER TABLE PUBLIC.INDIVIDUALASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;


  		




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


  		




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


  		




  ......




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


  		




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


  		




  5941
  5915
  
    
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.FK3C8E1FF916B9CA77 FOREIGN KEY(INSTITUTE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;


  		




  5942
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.FK2DE8E9334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  5943
  5916
  
    
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER_AUD ADD CONSTRAINT PUBLIC.FK2331098134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  5944
  5917
  
    
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.FK6BEDC7EE8D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;


  		




  5945
  5918
  
    
ALTER TABLE PUBLIC.TERMVOCABULARY_AUD ADD CONSTRAINT PUBLIC.FKA6ED3B6334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  ......




  6038
  6011
  
    
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.FK1966BDB14FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;


  		




  6039
  6012
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK6E6F45734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  6040
  6013
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE ADD CONSTRAINT PUBLIC.FK6FF15DFCC9CD5B57 FOREIGN KEY(RECOMMENDEDSTATISTICALMEASURES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;


  		




  6041
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATEDATA ADD CONSTRAINT PUBLIC.FK592D6F6D987CC6A4 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;


  		




  6042
  6014
  
    
ALTER TABLE PUBLIC.USERACCOUNT_PERMISSIONGROUP ADD CONSTRAINT PUBLIC.FK812DE753DA9DCB5F FOREIGN KEY(GROUPS_ID) REFERENCES PUBLIC.PERMISSIONGROUP(ID) NOCHECK;


  		




  6043
  6015
  
    
--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK4616A015D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;


  		




  6044
  6016
  
    
ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;


  		




  ......




  6145
  6117
  
    
ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FKFD724D851857F6C2 FOREIGN KEY(GRANTEDAUTHORITIES_ID) REFERENCES PUBLIC.GRANTEDAUTHORITYIMPL(ID) NOCHECK;


  		




  6146
  6118
  
    
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.FK8DA633B0777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;


  		




  6147
  6119
  
    
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.FK160DF9F734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;


  		




  6148
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C2D883945E FOREIGN KEY(STATISTICALVALUES_ID) REFERENCES PUBLIC.STATISTICALMEASUREMENTVALUE(ID) NOCHECK;


  		




  6149
  6120
  
    
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FK8E6106C73B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;


  		




  6150
  6121
  
    
ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK44D5F7D81E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;


  		




  6151
  6122
  
    
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F38C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;


  		




  ......




  6511
  6482
  
    
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE ADD CONSTRAINT PUBLIC.FK8FB1ED836BE0BFDA FOREIGN KEY(DETERMINATIONEVENT_ID) REFERENCES PUBLIC.DETERMINATIONEVENT(ID) NOCHECK;


  		




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


  		




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


  		




  6514
  
  
    
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK8AF511C28F213219 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;


  		




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


  		




  6516
  6486
  
    
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.FKA72FB5AED0BDAE9B FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;


  		




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


  		












Also available in:  Unified diff