Project

General

Profile

« Previous | Next » 

Revision db727ae6

Added by Andreas Müller almost 6 years ago

fix #7405 Rename WorkingSet to DescriptiveDataSet

View differences:

cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql
5087 5087 
    GROUPS_ID INTEGER NOT NULL
5088 5088 
);
5089 5089 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.USERACCOUNT_PERMISSIONGROUP;
5090 
CREATE CACHED TABLE PUBLIC.WORKINGSET(
5090 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET(
5091 5091 
    DTYPE VARCHAR(31) NOT NULL,
5092 5092 
    ID INTEGER NOT NULL,
5093 5093 
    CREATED TIMESTAMP,
......
5099 5099 
	MAXRANK_ID INTEGER,
5100 5100 
	MINRANK_ID INTEGER
5101 5101 
);
5102 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET;
5103 
CREATE CACHED TABLE PUBLIC.WORKINGSET_AUD(
5102 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET;
5103 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_AUD(
5104 5104 
    DTYPE VARCHAR(31) NOT NULL,
5105 5105 
    ID INTEGER NOT NULL,
5106 5106 
    REV INTEGER NOT NULL,
......
5114 5114 
	MAXRANK_ID INTEGER,
5115 5115 
	MINRANK_ID INTEGER
5116 5116 
);
5117 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_AUD;
5118 
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION(
5119 
    WORKINGSET_ID INTEGER NOT NULL,
5117 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_AUD;
5118 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION(
5119 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5120 5120 
    ANNOTATIONS_ID INTEGER NOT NULL
5121 5121 
);
5122 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION;
5123 
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD(
5122 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_ANNOTATION;
5123 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION_AUD(
5124 5124 
    REV INTEGER NOT NULL,
5125 
    WORKINGSET_ID INTEGER NOT NULL,
5125 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5126 5126 
    ANNOTATIONS_ID INTEGER NOT NULL,
5127 5127 
    REVTYPE TINYINT
5128 5128 
);
5129 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ANNOTATION_AUD;
5130 
CREATE CACHED TABLE PUBLIC.WORKINGSET_CREDIT(
5131 
    WORKINGSET_ID INTEGER NOT NULL,
5129 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_ANNOTATION_AUD;
5130 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_CREDIT(
5131 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5132 5132 
    CREDITS_ID INTEGER NOT NULL,
5133 5133 
    SORTINDEX INTEGER NOT NULL
5134 5134 
);
5135 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_CREDIT;
5136 
CREATE CACHED TABLE PUBLIC.WORKINGSET_CREDIT_AUD(
5135 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_CREDIT;
5136 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_CREDIT_AUD(
5137 5137 
    REV INTEGER NOT NULL,
5138 
    WORKINGSET_ID INTEGER NOT NULL,
5138 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5139 5139 
    CREDITS_ID INTEGER NOT NULL,
5140 5140 
    SORTINDEX INTEGER NOT NULL,
5141 5141 
    REVTYPE TINYINT
5142 5142 
);
5143 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_CREDIT_AUD;
5144 
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE(
5145 
    WORKINGSETS_ID INTEGER NOT NULL,
5143 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_CREDIT_AUD;
5144 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE(
5145 
    DESCRIPTIVEDATASETS_ID INTEGER NOT NULL,
5146 5146 
    DESCRIPTIONS_ID INTEGER NOT NULL
5147 5147 
);
5148 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE;
5149 
CREATE CACHED TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD(
5148 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE;
5149 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE_AUD(
5150 5150 
    REV INTEGER NOT NULL,
5151 
    WORKINGSETS_ID INTEGER NOT NULL,
5151 
    DESCRIPTIVEDATASETS_ID INTEGER NOT NULL,
5152 5152 
    DESCRIPTIONS_ID INTEGER NOT NULL,
5153 5153 
    REVTYPE TINYINT
5154 5154 
);
5155 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD;
5156 
CREATE CACHED TABLE PUBLIC.WORKINGSET_EXTENSION(
5157 
    WORKINGSET_ID INTEGER NOT NULL,
5155 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE_AUD;
5156 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_EXTENSION(
5157 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5158 5158 
    EXTENSIONS_ID INTEGER NOT NULL
5159 5159 
);
5160 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_EXTENSION;
5161 
CREATE CACHED TABLE PUBLIC.MEDIA_WORKINGSET_AUD(
5160 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_EXTENSION;
5161 
CREATE CACHED TABLE PUBLIC.MEDIA_DESCRIPTIVEDATASET_AUD(
5162 5162 
    REV INTEGER NOT NULL,
5163 
    WORKINGSET_ID INTEGER NOT NULL,
5163 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5164 5164 
    EXTENSIONS_ID INTEGER NOT NULL,
5165 5165 
    REVTYPE TINYINT
5166 5166 
);
5167 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_EXTENSION_AUD;
5168 
CREATE CACHED TABLE PUBLIC.WORKINGSET_IDENTIFIER(
5169 
    WORKINGSET_ID INTEGER NOT NULL,
5167 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_EXTENSION_AUD;
5168 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_IDENTIFIER(
5169 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5170 5170 
    IDENTIFIERS_ID INTEGER NOT NULL,
5171 5171 
    SORTINDEX INTEGER NOT NULL
5172 5172 
);
5173 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_IDENTIFIER;
5174 
CREATE CACHED TABLE PUBLIC.WORKINGSET_IDENTIFIER_AUD(
5173 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_IDENTIFIER;
5174 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_IDENTIFIER_AUD(
5175 5175 
    REV INTEGER NOT NULL,
5176 
    WORKINGSET_ID INTEGER NOT NULL,
5176 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5177 5177 
    IDENTIFIERS_ID INTEGER NOT NULL,
5178 5178 
    SORTINDEX INTEGER NOT NULL,
5179 5179 
    REVTYPE TINYINT
5180 5180 
);
5181 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_IDENTIFIER_AUD;
5182 
CREATE CACHED TABLE PUBLIC.WORKINGSET_MARKER(
5183 
    WORKINGSET_ID INTEGER NOT NULL,
5181 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_IDENTIFIER_AUD;
5182 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER(
5183 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5184 5184 
    MARKERS_ID INTEGER NOT NULL
5185 5185 
);
5186 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_MARKER;
5187 
CREATE CACHED TABLE PUBLIC.WORKINGSET_MARKER_AUD(
5186 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_MARKER;
5187 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER_AUD(
5188 5188 
    REV INTEGER NOT NULL,
5189 
    WORKINGSET_ID INTEGER NOT NULL,
5189 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5190 5190 
    MARKERS_ID INTEGER NOT NULL,
5191 5191 
    REVTYPE TINYINT
5192 5192 
);
5193 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_MARKER_AUD;
5194 
CREATE CACHED TABLE PUBLIC.WORKINGSET_NAMEDAREA(
5195 
    WORKINGSET_ID INTEGER NOT NULL,
5193 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_MARKER_AUD;
5194 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_NAMEDAREA(
5195 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5196 5196 
    GEOFILTER_ID INTEGER NOT NULL
5197 5197 
);
5198 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_NAMEDAREA;
5199 
CREATE CACHED TABLE PUBLIC.WORKINGSET_NAMEDAREA_AUD(
5198 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_NAMEDAREA;
5199 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_NAMEDAREA_AUD(
5200 5200 
    REV INTEGER NOT NULL,
5201 
    WORKINGSET_ID INTEGER NOT NULL,
5201 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5202 5202 
    GEOFILTER_ID INTEGER NOT NULL,
5203 5203 
    REVTYPE TINYINT
5204 5204 
);
5205 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_NAMEDAREA_AUD;
5206 
CREATE CACHED TABLE PUBLIC.WORKINGSET_ORIGINALSOURCEBASE(
5207 
    WORKINGSET_ID INTEGER NOT NULL,
5205 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_NAMEDAREA_AUD;
5206 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_ORIGINALSOURCEBASE(
5207 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5208 5208 
    SOURCES_ID INTEGER NOT NULL
5209 5209 
);
5210 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ORIGINALSOURCEBASE;
5211 
CREATE CACHED TABLE PUBLIC.WORKINGSET_ORIGINALSOURCEBASE_AUD(
5210 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_ORIGINALSOURCEBASE;
5211 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_ORIGINALSOURCEBASE_AUD(
5212 5212 
    REV INTEGER NOT NULL,
5213 
    WORKINGSET_ID INTEGER NOT NULL,
5213 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5214 5214 
    SOURCES_ID INTEGER NOT NULL,
5215 5215 
    REVTYPE TINYINT
5216 5216 
);
5217 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_ORIGINALSOURCEBASE_AUD;
5218 
CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION(
5219 
    WORKINGSET_ID INTEGER NOT NULL,
5217 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_ORIGINALSOURCEBASE_AUD;
5218 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION(
5219 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5220 5220 
    REPRESENTATIONS_ID INTEGER NOT NULL
5221 5221 
);
5222 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION;
5223 
CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD(
5222 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION;
5223 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION_AUD(
5224 5224 
    REV INTEGER NOT NULL,
5225 
    WORKINGSET_ID INTEGER NOT NULL,
5225 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5226 5226 
    REPRESENTATIONS_ID INTEGER NOT NULL,
5227 5227 
    REVTYPE TINYINT
5228 5228 
);
5229 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION_AUD;
5230 
CREATE CACHED TABLE PUBLIC.WORKINGSET_RIGHTSINFO(
5231 
    WORKINGSET_ID INTEGER NOT NULL,
5229 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION_AUD;
5230 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_RIGHTSINFO(
5231 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5232 5232 
    RIGHTS_ID INTEGER NOT NULL
5233 5233 
);
5234 5234 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTSINFO;
5235 
CREATE CACHED TABLE PUBLIC.WORKINGSET_RIGHTSINFO_AUD(
5235 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_RIGHTSINFO_AUD(
5236 5236 
    REV INTEGER NOT NULL,
5237 
    WORKINGSET_ID INTEGER NOT NULL,
5237 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5238 5238 
    RIGHTS_ID INTEGER NOT NULL,
5239 5239 
    REVTYPE TINYINT
5240 5240 
);
5241 5241 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.MEDIA_RIGHTSINFO_AUD;
5242 
CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONNODE(
5243 
    WORKINGSET_ID INTEGER NOT NULL,
5242 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_TAXONNODE(
5243 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5244 5244 
    TAXONSUBTREEFILTER_ID INTEGER NOT NULL
5245 5245 
);
5246 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_TAXONNODE;
5247 
CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONNODE_AUD(
5246 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_TAXONNODE;
5247 
CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_TAXONNODE_AUD(
5248 5248 
    REV INTEGER NOT NULL,
5249 
    WORKINGSET_ID INTEGER NOT NULL,
5249 
    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,
5250 5250 
    TAXONSUBTREEFILTER_ID INTEGER NOT NULL,
5251 5251 
    REVTYPE TINYINT
5252 5252 
);
5253 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_TAXONNODE_AUD;
5253 
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIVEDATASET_TAXONNODE_AUD;
5254 5254 
CREATE CACHED TABLE PUBLIC.HIBERNATE_SEQUENCES(
5255 5255 
    SEQUENCE_NAME VARCHAR(255) NOT NULL,
5256 5256 
    NEXT_VAL BIGINT
......
5264 5264 
ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX340 PRIMARY KEY(ID);
5265 5265 
ALTER TABLE PUBLIC.GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX346 PRIMARY KEY(ID);
5266 5266 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX341 PRIMARY KEY(POLYTOMOUSKEY_ID, RIGHTS_ID);
5267 
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBCB PRIMARY KEY(REV, WORKINGSET_ID, ANNOTATIONS_ID);
5267 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBCB PRIMARY KEY(REV, DESCRIPTIVEDATASET_ID, ANNOTATIONS_ID);
5268 5268 
ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBC2 PRIMARY KEY(TAXONBASE_ID, SOURCES_ID);
5269 5269 
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33F PRIMARY KEY(REV, GATHERINGEVENT_ID, MARKERS_ID);
5270 5270 
ALTER TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D7 PRIMARY KEY(TAXONNAME_ID, STATUS_ID);
......
5409 5409 
ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX444 PRIMARY KEY(FEATURETREE_ID, REPRESENTATIONS_ID);
5410 5410 
ALTER TABLE PUBLIC.MULTIACCESSKEY_COVEREDTAXON_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8B0 PRIMARY KEY(REV, MULTIACCESSKEY_ID, COVEREDTAXA_ID);
5411 5411 
ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63FF PRIMARY KEY(GATHERINGEVENT_ID, ANNOTATIONS_ID);
5412 
ALTER TABLE PUBLIC.WORKINGSET_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8BD PRIMARY KEY(REV, WORKINGSET_ID, MARKERS_ID);
5412 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8BD PRIMARY KEY(REV, DESCRIPTIVEDATASET_ID, MARKERS_ID);
5413 5413 
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43B PRIMARY KEY(REV, ORIGINALSOURCEBASE_ID, MARKERS_ID);
5414 5414 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX509 PRIMARY KEY(TEXTDATA_ID, MULTILANGUAGETEXT_MAPKEY_ID);
5415 5415 
ALTER TABLE PUBLIC.MEDIA_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX448 PRIMARY KEY(PHYLOGENETICTREE_ID, USEDSEQUENCES_ID);
......
5420 5420 
ALTER TABLE PUBLIC.TERMVOCABULARY_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFFF PRIMARY KEY(REV, TERMVOCABULARY_ID, CREDITS_ID, SORTINDEX);
5421 5421 
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA47 PRIMARY KEY(ORIGINALSOURCEBASE_ID, ANNOTATIONS_ID);
5422 5422 
ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX969 PRIMARY KEY(MEDIA_ID, TITLE_MAPKEY_ID);
5423 
ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA53 PRIMARY KEY(WORKINGSETS_ID, DESCRIPTIONS_ID);
5423 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA53 PRIMARY KEY(DESCRIPTIVEDATASETS_ID, DESCRIPTIONS_ID);
5424 5424 
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX514 PRIMARY KEY(REV, SEQUENCE_ID, CITATIONS_ID);
5425 5425 
ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX906 PRIMARY KEY(FEATURETREE_ID, SOURCES_ID);
5426 5426 
ALTER TABLE PUBLIC.RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX901 PRIMARY KEY(ID);
......
5502 5502 
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC81E PRIMARY KEY(ID, REV);
5503 5503 
ALTER TABLE PUBLIC.TAXONNAME_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX98E PRIMARY KEY(TAXONNAME_ID, MARKERS_ID);
5504 5504 
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA85 PRIMARY KEY(FEATURENODE_ID, ONLYAPPLICABLEIF_ID);
5505 
ALTER TABLE PUBLIC.WORKINGSET_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB92 PRIMARY KEY(ID, REV);
5505 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB92 PRIMARY KEY(ID, REV);
5506 5506 
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB5D PRIMARY KEY(NOMENCLATURALSTATUS_ID, MARKERS_ID);
5507 5507 
ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA82 PRIMARY KEY(REV, DESCRIPTIONBASE_ID, ANNOTATIONS_ID);
5508 5508 
ALTER TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA70 PRIMARY KEY(TAXONDESCRIPTION_ID, GEOSCOPES_ID);
......
5524 5524 
ALTER TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2864 PRIMARY KEY(REV, STATEDATA_ID, MODIFIERS_ID);
5525 5525 
--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA9D PRIMARY KEY(REV, SEQUENCE_ID, RIGHTS_ID);
5526 5526 
ALTER TABLE PUBLIC.MEDIA_SEQUENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFE4 PRIMARY KEY(REV, PHYLOGENETICTREE_ID, USEDSEQUENCES_ID);
5527 
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC9 PRIMARY KEY(WORKINGSET_ID, ANNOTATIONS_ID);
5527 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC9 PRIMARY KEY(DESCRIPTIVEDATASET_ID, ANNOTATIONS_ID);
5528 5528 
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4F7 PRIMARY KEY(TYPEDESIGNATIONBASE_ID, ANNOTATIONS_ID);
5529 5529 
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFB3 PRIMARY KEY(REV, HYBRIDRELATIONSHIP_ID, ANNOTATIONS_ID);
5530 5530 
--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX286 PRIMARY KEY(REV, CLASSIFICATION_ID, ROOTNODES_ID);
......
5539 5539 
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88C PRIMARY KEY(SEQUENCE_ID, EXTENSIONS_ID);
5540 5540 
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX807 PRIMARY KEY(SEQUENCE_ID, CHROMATOGRAMS_ID);
5541 5541 
ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE PRIMARY KEY(ID);
5542 
ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDAF PRIMARY KEY(REV, WORKINGSETS_ID, DESCRIPTIONS_ID);
5542 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDAF PRIMARY KEY(REV, DESCRIPTIVEDATASETS_ID, DESCRIPTIONS_ID);
5543 5543 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA9 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, RIGHTS_ID);
5544 5544 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5A PRIMARY KEY(REV, DEFINEDTERMBASE_ID, EXTENSIONS_ID);
5545 5545 
ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6D PRIMARY KEY(REV, LANGUAGESTRING_ID, ANNOTATIONS_ID);
......
5569 5569 
ALTER TABLE PUBLIC.LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDC8 PRIMARY KEY(ID, REV);
5570 5570 
ALTER TABLE PUBLIC.TAXONNAME_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88B PRIMARY KEY(TAXONNAME_ID, SORTINDEX);
5571 5571 
ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX64 PRIMARY KEY(REV, TERMVOCABULARY_ID, MARKERS_ID);
5572 
ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA5 PRIMARY KEY(ID);
5572 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA5 PRIMARY KEY(ID);
5573 5573 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1E1 PRIMARY KEY(ID);
5574 5574 
ALTER TABLE PUBLIC.MEDIAREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX557C PRIMARY KEY(ID, REV);
5575 5575 
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3AA PRIMARY KEY(MEDIAKEY_ID, SCOPERESTRICTIONS_ID);
......
5609 5609 
ALTER TABLE PUBLIC.MEDIAKEY_COVEREDTAXON ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAA PRIMARY KEY(MEDIAKEY_ID, COVEREDTAXA_ID);
5610 5610 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX96 PRIMARY KEY(REV, NAMEDAREA_ID, COUNTRIES_ID);
5611 5611 
ALTER TABLE PUBLIC.MULTIACCESSKEY_COVEREDTAXON ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCAA PRIMARY KEY(MULTIACCESSKEY_ID, COVEREDTAXA_ID);
5612 
ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC9 PRIMARY KEY(REV, WORKINGSET_ID, REPRESENTATIONS_ID);
5612 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC9 PRIMARY KEY(REV, DESCRIPTIVEDATASET_ID, REPRESENTATIONS_ID);
5613 5613 
ALTER TABLE PUBLIC.FEATURETREE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAF PRIMARY KEY(ID, REV);
5614 5614 
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAD PRIMARY KEY(REV, COLLECTION_ID, ANNOTATIONS_ID);
5615 5615 
ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC8 PRIMARY KEY(REV, DETERMINATIONEVENT_ID, ANNOTATIONS_ID);
......
5656 5656 
ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX37 PRIMARY KEY(REV, TAXONRELATIONSHIP_ID, MARKERS_ID);
5657 5657 
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4E PRIMARY KEY(REFERENCE_ID, SOURCES_ID);
5658 5658 
ALTER TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43 PRIMARY KEY(REV, CLASSIFICATION_ID, ANNOTATIONS_ID);
5659 
ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E8 PRIMARY KEY(WORKINGSET_ID, REPRESENTATIONS_ID);
5659 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E8 PRIMARY KEY(DESCRIPTIVEDATASET_ID, REPRESENTATIONS_ID);
5660 5660 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3D9 PRIMARY KEY(REV, POLYTOMOUSKEY_ID, MARKERS_ID);
5661 5661 
ALTER TABLE PUBLIC.COLLECTION_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4 PRIMARY KEY(COLLECTION_ID, SORTINDEX);
5662 5662 
ALTER TABLE PUBLIC.MEDIA_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX46 PRIMARY KEY(MEDIAKEY_ID, KEYREPRESENTATIONS_ID);
......
5698 5698 
ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6E1 PRIMARY KEY(NAMERELATIONSHIP_ID, ANNOTATIONS_ID);
5699 5699 
ALTER TABLE PUBLIC.CREDIT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1 PRIMARY KEY(CREDIT_ID, ANNOTATIONS_ID);
5700 5700 
ALTER TABLE PUBLIC.DESCRIPTIONBASE_SCOPE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3A0 PRIMARY KEY(TAXONDESCRIPTION_ID, SCOPES_ID);
5701 
ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX99 PRIMARY KEY(WORKINGSET_ID, MARKERS_ID);
5701 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX99 PRIMARY KEY(DESCRIPTIVEDATASET_ID, MARKERS_ID);
5702 5702 
ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA3456AE PRIMARY KEY(ANNOTATION_ID, ANNOTATIONS_ID);
5703 5703 
ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6EF PRIMARY KEY(ID);
5704 5704 
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9A PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, CREDITS_ID, SORTINDEX);
......
5792 5792 
ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX76F UNIQUE(UUID);
5793 5793 
ALTER TABLE PUBLIC.TAXONRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7FE3 UNIQUE(MARKERS_ID);
5794 5794 
ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56B67 UNIQUE(ANNOTATIONS_ID);
5795 
ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX99E UNIQUE(MARKERS_ID);
5795 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX99E UNIQUE(MARKERS_ID);
5796 5796 
ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX986 UNIQUE(EXTENSIONS_ID);
5797 5797 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5DC UNIQUE(ANNOTATIONS_ID);
5798 5798 
ALTER TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB869 UNIQUE(EXTENSIONS_ID);
......
5884 5884 
ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD9E UNIQUE(MARKERS_ID);
5885 5885 
ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA656 UNIQUE(UUID);
5886 5886 
ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX25D4 UNIQUE(MARKERS_ID);
5887 
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC95 UNIQUE(ANNOTATIONS_ID);
5887 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEC95 UNIQUE(ANNOTATIONS_ID);
5888 5888 
ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX729C UNIQUE(LABEL_ID);
5889 5889 
ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7F1 UNIQUE(UUID);
5890 5890 
ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX371A UNIQUE(RIGHTS_ID);
......
5904 5904 
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3C3 UNIQUE(MODIFYINGTEXT_ID);
5905 5905 
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5FCB UNIQUE(ANNOTATIONS_ID);
5906 5906 
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB592 UNIQUE(UUID);
5907 
ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E88 UNIQUE(REPRESENTATIONS_ID);
5907 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E88 UNIQUE(REPRESENTATIONS_ID);
5908 5908 
ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9063 UNIQUE(SOURCES_ID);
5909 5909 
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7A0 UNIQUE(UUID);
5910 5910 
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5F1 UNIQUE(ANNOTATIONS_ID);
5911 5911 
ALTER TABLE PUBLIC.INDIVIDUALSASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX11A UNIQUE(DESCRIPTION_ID);
5912 5912 
ALTER TABLE PUBLIC.MEDIA_SEQUENCE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX448E UNIQUE(USEDSEQUENCES_ID);
5913 
ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA5E UNIQUE(UUID);
5913 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA5E UNIQUE(UUID);
5914 5914 
ALTER TABLE PUBLIC.TERMVOCABULARY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4D7 UNIQUE(ANNOTATIONS_ID);
5915 5915 
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F0 UNIQUE(EXTENSIONS_ID);
5916 5916 
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFB UNIQUE(ANNOTATIONS_ID);
......
6028 6028 
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA3272C8505DB FOREIGN KEY(PRESERVATION_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6029 6029 
ALTER TABLE PUBLIC.MEDIA_RIGHTSINFO ADD CONSTRAINT PUBLIC.FKDB1266D2C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
6030 6030 
ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.FK78CA9719F7976FC5 FOREIGN KEY(AGENT_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6031 
ALTER TABLE PUBLIC.WORKINGSET_MARKER_AUD ADD CONSTRAINT PUBLIC.FK6AEAB69934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6031 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER_AUD ADD CONSTRAINT PUBLIC.FK6AEAB69934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6032 6032 
ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK579A1DC028459272 FOREIGN KEY(DESCRIPTION_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6033 6033 
ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKB212F49034869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6034 6034 
ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.FK6F1286F34FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
6124 6124 
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD ADD CONSTRAINT PUBLIC.FK88A308E634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6125 6125 
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK208142711E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6126 6126 
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E5108316CDFF85 FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6127 
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBDBBD2C869 FOREIGN KEY(WORKINGSET_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6128 
ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6127 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBDBBD2C869 FOREIGN KEY(DESCRIPTIVEDATASET_ID) REFERENCES PUBLIC.DESCRIPTIVEDATASET(ID) NOCHECK;
6128 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6129 6129 
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6130 6130 
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6131 6131 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
......
6202 6202 
ALTER TABLE PUBLIC.REFERENCE_MARKER ADD CONSTRAINT PUBLIC.FK6BEDC7EE777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6203 6203 
ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.FK88F1805AD64DC020 FOREIGN KEY(MARKERTYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6204 6204 
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.FK78FF2B12C0DB4934 FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6205 
ALTER TABLE PUBLIC.MULTIACCESSKEY_SCOPE ADD CONSTRAINT PUBLIC.FKCC6CE4F7B4555A9A FOREIGN KEY(MULTIACCESSKEY_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6205 
ALTER TABLE PUBLIC.MULTIACCESSKEY_SCOPE ADD CONSTRAINT PUBLIC.FKCC6CE4F7B4555A9A FOREIGN KEY(MULTIACCESSKEY_ID) REFERENCES PUBLIC.DESCRIPTIVEDATASET(ID) NOCHECK;
6206 6206 
ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.FK1A21C74FBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6207 6207 
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.FK7A0351D6BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;
6208 6208 
ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK93FFD2AD8E7BF9AB FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
......
6221 6221 
ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK289591F734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6222 6222 
ALTER TABLE PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKBB24070634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6223 6223 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.FK2D26AB8834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6224 
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK1E28140E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6224 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK1E28140E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6225 6225 
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.FKF68FEBDE927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
6226 6226 
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.FK8E5D91E6D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
6227 6227 
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK42D7AF908C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
......
6263 6263 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE76714220AFEB FOREIGN KEY(FEATURE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6264 6264 
ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2BBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6265 6265 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.FK750A135034869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6266 
ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FK731CC81FBBD2C869 FOREIGN KEY(WORKINGSETS_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6266 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FK731CC81FBBD2C869 FOREIGN KEY(DESCRIPTIVEDATASETS_ID) REFERENCES PUBLIC.DESCRIPTIVEDATASET(ID) NOCHECK;
6267 6267 
ALTER TABLE PUBLIC.TAXONNAME_MARKER_AUD ADD CONSTRAINT PUBLIC.FK3DA7BE4434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6268 6268 
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.FKBB16686134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6269 6269 
ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02F11BD77B FOREIGN KEY(TYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
......
6319 6319 
ALTER TABLE PUBLIC.MEDIA_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FKE13FAD3534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6320 6320 
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E51083AEB7F3BE FOREIGN KEY(CITATION_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6321 6321 
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES ADD CONSTRAINT PUBLIC.FK4BD2B08E86EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6322 
ALTER TABLE PUBLIC.MULTIACCESSKEY_TAXONSCOPE ADD CONSTRAINT PUBLIC.FKCC7A356DB64A7B29 FOREIGN KEY(MULTIACCESSKEY_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6322 
ALTER TABLE PUBLIC.MULTIACCESSKEY_TAXONSCOPE ADD CONSTRAINT PUBLIC.FKCC7A356DB64A7B29 FOREIGN KEY(MULTIACCESSKEY_ID) REFERENCES PUBLIC.DESCRIPTIVEDATASET(ID) NOCHECK;
6323 6323 
ALTER TABLE PUBLIC.MEDIAKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.FK922630D334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6324 6324 
ALTER TABLE PUBLIC.NAMERELATIONSHIP_AUD ADD CONSTRAINT PUBLIC.FK743F44D434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6325 6325 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA ADD CONSTRAINT PUBLIC.FK21F700763B8BB609 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;
6326 6326 
ALTER TABLE PUBLIC.REPRESENTATION_MARKER ADD CONSTRAINT PUBLIC.FK560063EC777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6327 6327 
ALTER TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE ADD CONSTRAINT PUBLIC.FK3ADD7CD586D04E74 FOREIGN KEY(GEOSCOPES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6328 
ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA003835BBBD2C869 FOREIGN KEY(WORKINGSET_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6328 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA003835BBBD2C869 FOREIGN KEY(DESCRIPTIVEDATASET_ID) REFERENCES PUBLIC.DESCRIPTIVEDATASET(ID) NOCHECK;
6329 6329 
ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCC39DB2DFB FOREIGN KEY(PARENT_ID) REFERENCES PUBLIC.TAXONNODE(ID) NOCHECK;
6330 6330 
ALTER TABLE PUBLIC.MEDIA_CREDIT_AUD ADD CONSTRAINT PUBLIC.FKDB32A3C534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6331 6331 
ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK2E340A6688206484 FOREIGN KEY(TYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
......
6337 6337 
ALTER TABLE PUBLIC.AGENTBASE_AUD ADD CONSTRAINT PUBLIC.FK29CC662734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6338 6338 
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAE9E3ED08 FOREIGN KEY(TYPESTATUS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6339 6339 
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKA0CE054134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6340 
ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA003835BB31C4747 FOREIGN KEY(REPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
6340 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION ADD CONSTRAINT PUBLIC.FKA003835BB31C4747 FOREIGN KEY(REPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
6341 6341 
ALTER TABLE PUBLIC.AGENTBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK323A45EC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6342 6342 
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7CB029DDA0 FOREIGN KEY(ORIGINALSOURCEBASE_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
6343 6343 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK23F76ADEC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
......
6345 6345 
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FKB914A10B777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6346 6346 
ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49B8492378F FOREIGN KEY(NAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6347 6347 
ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.FK9E016B9134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6348 
ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8BBD2C869 FOREIGN KEY(WORKINGSET_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6348 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8BBD2C869 FOREIGN KEY(DESCRIPTIVEDATASET_ID) REFERENCES PUBLIC.DESCRIPTIVEDATASET(ID) NOCHECK;
6349 6349 
ALTER TABLE PUBLIC.AGENTBASE_MEDIA ADD CONSTRAINT PUBLIC.FKE8FC5D9B86EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6350 6350 
ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK81DC081534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6351 6351 
ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FKFD724D851857F6C2 FOREIGN KEY(GRANTEDAUTHORITIES_ID) REFERENCES PUBLIC.GRANTEDAUTHORITYIMPL(ID) NOCHECK;
......
6398 6398 
ALTER TABLE PUBLIC.REPRESENTATION_ANNOTATION ADD CONSTRAINT PUBLIC.FK371091E11E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6399 6399 
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E51083AF619DE3 FOREIGN KEY(TYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6400 6400 
ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK2E340A6636C6F6F6 FOREIGN KEY(POINTAPPROXIMATION_REFERENCESYSTEM_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6401 
ALTER TABLE PUBLIC.MULTIACCESSKEY_COVEREDTAXON ADD CONSTRAINT PUBLIC.FK34EB896DB4555A9A FOREIGN KEY(MULTIACCESSKEY_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6401 
ALTER TABLE PUBLIC.MULTIACCESSKEY_COVEREDTAXON ADD CONSTRAINT PUBLIC.FK34EB896DB4555A9A FOREIGN KEY(MULTIACCESSKEY_ID) REFERENCES PUBLIC.DESCRIPTIVEDATASET(ID) NOCHECK;
6402 6402 
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE ADD CONSTRAINT PUBLIC.FKBFFEE8F0BE59D760 FOREIGN KEY(MEDIAKEY_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
6403 6403 
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775A4220AFEB FOREIGN KEY(FEATURE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6404 6404 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.FK522D90C79682414B FOREIGN KEY(MODIFYINGTEXT_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
......
6435 6435 
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE76719108D9B FOREIGN KEY(TAXON2_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
6436 6436 
ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.FK5BC6DEAD8D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6437 6437 
ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK626B7850C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
6438 
ALTER TABLE PUBLIC.WORKINGSET_AUD ADD CONSTRAINT PUBLIC.FK628F58E234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6438 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_AUD ADD CONSTRAINT PUBLIC.FK628F58E234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6439 6439 
ALTER TABLE PUBLIC.RIGHTSINFO_ANNOTATION ADD CONSTRAINT PUBLIC.FK27CB1E97C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
6440 6440 
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS ADD CONSTRAINT PUBLIC.FK52E1AD9586EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6441 6441 
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK6A3D3D434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6443 6443 
ALTER TABLE PUBLIC.KEYSTATEMENT ADD CONSTRAINT PUBLIC.FK7125B9F0BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6444 6444 
ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784A1CA19B1 FOREIGN KEY(TITLE_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
6445 6445 
ALTER TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.FK4CB735DA34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6446 
ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FK731CC81F33B8A841 FOREIGN KEY(DESCRIPTIONS_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;
6446 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FK731CC81F33B8A841 FOREIGN KEY(DESCRIPTIONS_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;
6447 6447 
ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.FK5C475102777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6448 6448 
ALTER TABLE PUBLIC.FEATURETREE_AUD ADD CONSTRAINT PUBLIC.FK355BE36534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6449 6449 
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FKA981956134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6485 6485 
ALTER TABLE PUBLIC.DESCRIPTIONBASE_SCOPE ADD CONSTRAINT PUBLIC.FKB9257C42D86445CE FOREIGN KEY(TAXONDESCRIPTION_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;
6486 6486 
ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.FKA020DAAA1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6487 6487 
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK42D7AF90C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
6488 
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBD1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6488 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBD1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6489 6489 
ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.FK4CEED9F84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6490 6490 
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.FK2CFBC93732D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
6491 6491 
ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCC84A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;
......
6500 6500 
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER ADD CONSTRAINT PUBLIC.FK2F5128E777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6501 6501 
ALTER TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK107321E28E7BF9AB FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
6502 6502 
ALTER TABLE PUBLIC.FEATURENODE_AUD ADD CONSTRAINT PUBLIC.FK25AD4BC934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6503 
ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.FK668D5B91BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6503 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET ADD CONSTRAINT PUBLIC.FK668D5B91BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6504 6504 
ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK8F1F9C44258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
6505 6505 
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.FK2C7E7DFA1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6506 6506 
ALTER TABLE PUBLIC.MEDIAREPRESENTATION_MEDIAREPRESENTATIONPART_AUD ADD CONSTRAINT PUBLIC.FK3544378734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6537 6537 
ALTER TABLE PUBLIC.RIGHTSINFO ADD CONSTRAINT PUBLIC.FK91E56DF74FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6538 6538 
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK505F2E5D966B96B2 FOREIGN KEY(NAMEUSEDINSOURCE_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6539 6539 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK629EC1D134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6540 
ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK21B88BAC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6540 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK21B88BAC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6541 6541 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.FK1C727CFF3FF8E7B2 FOREIGN KEY(GEOGRAPHICALSCOPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6542 6542 
ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.FK6F1286F38B455EC6 FOREIGN KEY(LOCALITY_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
6543 6543 
ALTER TABLE PUBLIC.COLLECTION ADD CONSTRAINT PUBLIC.FKF078ABECEB38EFF FOREIGN KEY(SUPERCOLLECTION_ID) REFERENCES PUBLIC.COLLECTION(ID) NOCHECK;
......
6571 6571 
ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.FK1010BA6DD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
6572 6572 
ALTER TABLE PUBLIC.REFERENCE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK1AD225DC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6573 6573 
ALTER TABLE PUBLIC.AGENTBASE_CREDIT ADD CONSTRAINT PUBLIC.FK2636742232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
6574 
ALTER TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.FK1F5A7489B4555A9A FOREIGN KEY(MULTIACCESSKEY_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6574 
ALTER TABLE PUBLIC.MULTIACCESSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.FK1F5A7489B4555A9A FOREIGN KEY(MULTIACCESSKEY_ID) REFERENCES PUBLIC.DESCRIPTIVEDATASET(ID) NOCHECK;
6575 6575 
ALTER TABLE PUBLIC.MEDIA ADD CONSTRAINT PUBLIC.FK46C7FC4BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6576 6576 
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK365E4F3C1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6577 6577 
ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.FKFB1697BBBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
6623 6623 
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
6624 6624 
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.FK4CF19F94B7892921 FOREIGN KEY(ROOT_ID) REFERENCES PUBLIC.FEATURENODE(ID) NOCHECK;
6625 6625 
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK5574E12EF05D08D4 FOREIGN KEY(MODIFYINGTEXT_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
6626 
ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.FK668D5B9123DB7F04 FOREIGN KEY(DESCRIPTIVESYSTEM_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;
6626 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET ADD CONSTRAINT PUBLIC.FK668D5B9123DB7F04 FOREIGN KEY(DESCRIPTIVESYSTEM_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;
6627 6627 
ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.FKFB1697BB4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6628 6628 
ALTER TABLE PUBLIC.AGENTBASE_AGENTBASE_AUD ADD CONSTRAINT PUBLIC.FKA8A87CFE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6629 6629 
ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK8F2D512A258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
......
6740 6740 
ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.FK4CEED9F8BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6741 6741 
ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2BAD54327F FOREIGN KEY(INREFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6742 6742 
ALTER TABLE PUBLIC.MULTIACCESSKEY_TAXONSCOPE ADD CONSTRAINT PUBLIC.FKCC7A356DDE9A3E39 FOREIGN KEY(TAXONOMICSCOPE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
6743 
ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.FK8959CE7034869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6744 
ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.FK668D5B914FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6743 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.FK8959CE7034869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6744 
ALTER TABLE PUBLIC.DESCRIPTIVEDATASET ADD CONSTRAINT PUBLIC.FK668D5B914FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6745 6745 
ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK1FFC43A934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6746 6746 
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.FKFB2DB8DC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6747 6747 
ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKA898D9FB34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;

Also available in: Unified diff