Project

General

Profile

Revision 0bd9db14

ID0bd9db14d72713246dda89a44e6d4888eb9b7076
Parent 292fe199
Child 52a59b6e

Added by Andreas Müller almost 4 years ago

update test schema and test database for vaadin

View differences:

src/test/resources/dbscripts/001-cdm.h2.sql
68 68
    CODE VARCHAR(255),
69 69
    NAME VARCHAR(255),
70 70
    FIRSTNAME VARCHAR(255),
71
	INITIALS VARCHAR(50),
71 72
    LASTNAME VARCHAR(255),
72 73
    LIFESPAN_END VARCHAR(255),
73 74
    LIFESPAN_FREETEXT VARCHAR(255),
......
101 102
    NOMENCLATURALTITLE VARCHAR(255),
102 103
    PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,
103 104
    FIRSTNAME VARCHAR(255),
104
    LASTNAME VARCHAR(255),
105
    INITIALS VARCHAR(50),
106
	LASTNAME VARCHAR(255),
105 107
    LIFESPAN_END VARCHAR(255),
106 108
    LIFESPAN_FREETEXT VARCHAR(255),
107 109
    LIFESPAN_START VARCHAR(255),
......
522 524
    ID INTEGER NOT NULL,
523 525
    CREATED TIMESTAMP,
524 526
    UUID VARCHAR(36),
525
    PROPERTYNAME INTEGER,
527
    PROPERTYNAME VARCHAR(20),
526 528
    VALUE VARCHAR(255),
527 529
    CREATEDBY_ID INTEGER
528 530
);
......
946 948
    LEVEL_ID INTEGER,
947 949
    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,
948 950
    SHAPE_ID INTEGER,
949
    TYPE_ID INTEGER
951
    TYPE_ID INTEGER,
952
	STRUCTURE_ID INTEGER,
953
	PROPERTY_ID INTEGER,
950 954
);
951 955
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE;
952 956
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(
......
984 988
    SUPPORTSQUANTITATIVEDATA BOOLEAN,
985 989
    SUPPORTSTAXONINTERACTION BOOLEAN,
986 990
    SUPPORTSTEXTDATA BOOLEAN,
991
    SYMMETRICAL BOOLEAN,
992
    TRANSITIVE BOOLEAN,
987 993
    ISTECHNICAL BOOLEAN,
988 994
    ABSENCETERM BOOLEAN NOT NULL,
989 995
    DEFAULTCOLOR VARCHAR(255),
......
993 999
    VALIDPERIOD_END VARCHAR(255),
994 1000
    VALIDPERIOD_FREETEXT VARCHAR(255),
995 1001
    VALIDPERIOD_START VARCHAR(255),
996
    LEVEL_ID INTEGER,
1002
    ISO3166_A2 VARCHAR(2),
1003
 	LEVEL_ID INTEGER,
997 1004
    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,
998 1005
    SHAPE_ID INTEGER,
999 1006
    TYPE_ID INTEGER,
1000
    ISO3166_A2 VARCHAR(2),
1001
    SYMMETRICAL BOOLEAN,
1002
    TRANSITIVE BOOLEAN
1007
    STRUCTURE_ID INTEGER,
1008
	PROPERTY_ID INTEGER,
1003 1009
);
1004 1010
-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_AUD;
1005 1011
CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION(
......
2234 2240
  	OCCURRENCE_ID INT,
2235 2241
  	REFERENCE_ID INT,
2236 2242
  	TAXON_ID INT,
2237
  	TAXONNAME_ID INT
2243
  	TAXONNAME_ID INT,
2244
	KEY_ID INT
2238 2245
);
2239 2246
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE;
2240 2247
CREATE CACHED TABLE PUBLIC.INTEXTREFERENCE_AUD(
......
2255 2262
  	OCCURRENCE_ID INT,
2256 2263
  	REFERENCE_ID INT,
2257 2264
  	TAXON_ID INT,
2258
  	TAXONNAME_ID INT
2265
  	TAXONNAME_ID INT,
2266
	KEY_ID INT
2259 2267
);
2260 2268
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.INTEXTREFERENCE_AUD;
2261 2269

  
......
3375 3383
    REFTYPE VARCHAR(4),
3376 3384
    URI CLOB,
3377 3385
    VOLUME VARCHAR(255),
3386
	ACCESSED TIMESTAMP,
3387
	LASTRETRIEVED TIMESTAMP,
3388
	EXTERNALID VARCHAR(255),
3389
	EXTERNALLINK CLOB,
3390
	AUTHORITYTYPE  VARCHAR(10) NOT NULL,
3378 3391
    CREATEDBY_ID INTEGER,
3379 3392
    UPDATEDBY_ID INTEGER,
3380 3393
    AUTHORSHIP_ID INTEGER,
......
3424 3437
    REFTYPE  VARCHAR(4),
3425 3438
    URI CLOB,
3426 3439
    VOLUME VARCHAR(255),
3440
    ACCESSED TIMESTAMP,
3441
	LASTRETRIEVED TIMESTAMP,
3442
	EXTERNALID VARCHAR(255),
3443
	EXTERNALLINK CLOB,
3444
	AUTHORITYTYPE  VARCHAR(10) NOT NULL,
3427 3445
    CREATEDBY_ID INTEGER,
3428 3446
    UPDATEDBY_ID INTEGER,
3429 3447
    AUTHORSHIP_ID INTEGER,
......
3532 3550
    REVTYPE TINYINT
3533 3551
);
3534 3552
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REFERENCE_RIGHTSINFO_AUD;
3535
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION(
3536
    RELATIONSHIPTERMBASE_ID INTEGER NOT NULL,
3553
CREATE CACHED TABLE PUBLIC.REGISTRATION(
3554
    ID INTEGER NOT NULL,
3555
    CREATED TIMESTAMP,
3556
    UUID VARCHAR(36),
3557
    UPDATED TIMESTAMP,
3558
	IDENTIFIER VARCHAR(255),
3559
	REGISTRATIONDATE TIMESTAMP,
3560
	SPECIFICIDENTIFIER VARCHAR(255),
3561
	STATUS VARCHAR(255),
3562
    CREATEDBY_ID INTEGER,
3563
    UPDATEDBY_ID INTEGER,
3564
	INSTITUTION_ID INTEGER,
3565
	NAME_ID INTEGER,
3566
	SUBMITTER_ID INTEGER
3567
);
3568
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION;
3569
CREATE CACHED TABLE PUBLIC.REGISTRATION_AUD(
3570
    ID INTEGER NOT NULL,
3571
    REV INTEGER NOT NULL,
3572
    REVTYPE TINYINT,
3573
    CREATED TIMESTAMP,
3574
    UUID VARCHAR(36),
3575
    UPDATED TIMESTAMP,
3576
	IDENTIFIER VARCHAR(255),
3577
	REGISTRATIONDATE TIMESTAMP,
3578
	SPECIFICIDENTIFIER VARCHAR(255),
3579
	STATUS VARCHAR(255),
3580
    CREATEDBY_ID INTEGER,
3581
    UPDATEDBY_ID INTEGER,
3582
	INSTITUTION_ID INTEGER,
3583
	NAME_ID INTEGER,
3584
	SUBMITTER_ID INTEGER
3585
);
3586
-- 2175 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_AUD;
3587
CREATE CACHED TABLE PUBLIC.REGISTRATION_ANNOTATION(
3588
    REGISTRATION_ID INTEGER NOT NULL,
3589
    ANNOTATIONS_ID INTEGER NOT NULL
3590
);
3591
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_ANNOTATION;
3592
CREATE CACHED TABLE PUBLIC.REGISTRATION_ANNOTATION_AUD(
3593
    REV INTEGER NOT NULL,
3594
    REGISTRATION_ID INTEGER NOT NULL,
3595
    ANNOTATIONS_ID INTEGER NOT NULL,
3596
    REVTYPE TINYINT
3597
);
3598
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REPRESENTATION_ANNOTATION_AUD;
3599
CREATE CACHED TABLE PUBLIC.REGISTRATION_MARKER(
3600
    REGISTRATION_ID INTEGER NOT NULL,
3601
    MARKERS_ID INTEGER NOT NULL
3602
);
3603
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_MARKER;
3604
CREATE CACHED TABLE PUBLIC.REGISTRATION_MARKER_AUD(
3605
    REV INTEGER NOT NULL,
3606
    REGISTRATION_ID INTEGER NOT NULL,
3607
    MARKERS_ID INTEGER NOT NULL,
3608
    REVTYPE TINYINT
3609
);
3610
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_MARKER_AUD;
3611
CREATE CACHED TABLE PUBLIC.REGISTRATION_REGISTRATION(
3612
    REGISTRATION_ID INTEGER NOT NULL,
3613
    BLOCKEDBY_ID INTEGER NOT NULL
3614
);
3615
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_REGISTRATION;
3616
CREATE CACHED TABLE PUBLIC.REGISTRATION_REGISTRATION_AUD(
3617
    REV INTEGER NOT NULL,
3618
    REGISTRATION_ID INTEGER NOT NULL,
3619
    BLOCKEDBY_ID INTEGER NOT NULL,
3620
    REVTYPE TINYINT
3621
);
3622
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_REGISTRATION_AUD;
3623
CREATE CACHED TABLE PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE(
3624
    REGISTRATIONS_ID INTEGER NOT NULL,
3625
    TYPEDESIGNATIONS_ID INTEGER NOT NULL
3626
);
3627
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE;
3628
CREATE CACHED TABLE PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE_AUD(
3629
    REV INTEGER NOT NULL,
3630
    REGISTRATIONS_ID INTEGER NOT NULL,
3631
    TYPEDESIGNATIONS_ID INTEGER NOT NULL,
3632
    REVTYPE TINYINT
3633
);
3634
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.REGISTRATION_TYPEDESIGNATIONBASE_AUD;
3635

  
3636
CREATE CACHED TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION(
3637
    TERM_ID INTEGER NOT NULL,
3537 3638
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL
3538 3639
);
3539
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION;
3540
CREATE CACHED TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD(
3640
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.TERMBASE_INVERSEREPRESENTATION;
3641
CREATE CACHED TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD(
3541 3642
    REV INTEGER NOT NULL,
3542
    RELATIONSHIPTERMBASE_ID INTEGER NOT NULL,
3643
    TERM_ID INTEGER NOT NULL,
3543 3644
    INVERSEREPRESENTATIONS_ID INTEGER NOT NULL,
3544 3645
    REVTYPE TINYINT
3545 3646
);
3546
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD;
3647
-- 54 +/- SELECT COUNT(*) FROM PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD;
3547 3648
CREATE CACHED TABLE PUBLIC.REPRESENTATION(
3548 3649
    ID INTEGER NOT NULL,
3549 3650
    CREATED TIMESTAMP,
......
3835 3936
    MARKERS_ID INTEGER NOT NULL
3836 3937
);
3837 3938

  
3838

  
3839 3939
CREATE CACHED TABLE PUBLIC.SPECIMENOROBSERVATIONBASE(
3840 3940
    DTYPE VARCHAR(31) NOT NULL,
3841 3941
    ID INTEGER NOT NULL,
......
3850 3950
    LSID_REVISION VARCHAR(255),
3851 3951
    PROTECTEDTITLECACHE BOOLEAN NOT NULL,
3852 3952
    TITLECACHE VARCHAR(255),
3953
    PROTECTEDIDENTITYCACHE BOOLEAN,
3954
    IDENTITYCACHE VARCHAR(255),
3853 3955
    PUBLISH BOOLEAN,
3854 3956
    INDIVIDUALCOUNT INTEGER,
3855 3957
	PREFERREDSTABLEURI CLOB,
......
3893 3995
    LSID_REVISION VARCHAR(255),
3894 3996
    PROTECTEDTITLECACHE BOOLEAN,
3895 3997
    TITLECACHE VARCHAR(255),
3896
    PUBLISH BOOLEAN,
3998
    PROTECTEDIDENTITYCACHE BOOLEAN NULL,
3999
    IDENTITYCACHE VARCHAR(255),
4000
	PUBLISH BOOLEAN,
3897 4001
    INDIVIDUALCOUNT INTEGER,
3898 4002
    PREFERREDSTABLEURI CLOB,
3899 4003
    ACCESSIONNUMBER VARCHAR(255),
......
4291 4395
    REVTYPE TINYINT
4292 4396
);
4293 4397
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD;
4294
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE(
4398
CREATE CACHED TABLE PUBLIC.TAXONNAME(
4295 4399
    DTYPE VARCHAR(31) NOT NULL,
4296 4400
    ID INTEGER NOT NULL,
4297 4401
    CREATED TIMESTAMP,
4298 4402
    UUID VARCHAR(36),
4299 4403
    UPDATED TIMESTAMP,
4404
	NAMETYPE VARCHAR(255),
4300 4405
    LSID_AUTHORITY VARCHAR(255),
4301 4406
    LSID_LSID VARCHAR(255),
4302 4407
    LSID_NAMESPACE VARCHAR(255),
......
4341 4446
    EXBASIONYMAUTHORSHIP_ID INTEGER,
4342 4447
    EXCOMBINATIONAUTHORSHIP_ID INTEGER
4343 4448
);
4344
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE;
4345
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAMEBASE(TITLECACHE);
4346
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_AUD(
4449
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME;
4450
CREATE INDEX PUBLIC.TAXONNAMEBASETITLECACHEINDEX ON PUBLIC.TAXONNAME(TITLECACHE);
4451
CREATE CACHED TABLE PUBLIC.TAXONNAME_AUD(
4347 4452
    DTYPE VARCHAR(31) NOT NULL,
4348 4453
    ID INTEGER NOT NULL,
4349 4454
    REV INTEGER NOT NULL,
4350 4455
    REVTYPE TINYINT,
4351 4456
    CREATED TIMESTAMP,
4352
    UUID VARCHAR(36),
4457
	UUID VARCHAR(36),
4353 4458
    UPDATED TIMESTAMP,
4354
    LSID_AUTHORITY VARCHAR(255),
4459
    NAMETYPE VARCHAR(255),
4460
	LSID_AUTHORITY VARCHAR(255),
4355 4461
    LSID_LSID VARCHAR(255),
4356 4462
    LSID_NAMESPACE VARCHAR(255),
4357 4463
    LSID_OBJECT VARCHAR(255),
......
4395 4501
    NAMEAPPROBATION VARCHAR(255),
4396 4502
    SUBGENUSAUTHORSHIP VARCHAR(255)
4397 4503
);
4398
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_AUD;
4399
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION(
4400
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4504
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_AUD;
4505
CREATE CACHED TABLE PUBLIC.TAXONNAME_ANNOTATION(
4506
    TAXONNAME_ID INTEGER NOT NULL,
4401 4507
    ANNOTATIONS_ID INTEGER NOT NULL
4402 4508
);
4403
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ANNOTATION;
4404
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD(
4509
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_ANNOTATION;
4510
CREATE CACHED TABLE PUBLIC.TAXONNAME_ANNOTATION_AUD(
4405 4511
    REV INTEGER NOT NULL,
4406
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4512
    TAXONNAME_ID INTEGER NOT NULL,
4407 4513
    ANNOTATIONS_ID INTEGER NOT NULL,
4408 4514
    REVTYPE TINYINT
4409 4515
);
4410
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD;
4411
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_CREDIT(
4412
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4516
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_ANNOTATION_AUD;
4517
CREATE CACHED TABLE PUBLIC.TAXONNAME_CREDIT(
4518
    TAXONNAME_ID INTEGER NOT NULL,
4413 4519
    CREDITS_ID INTEGER NOT NULL,
4414 4520
    SORTINDEX INTEGER NOT NULL
4415 4521
);
4416
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_CREDIT;
4417
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_CREDIT_AUD(
4522
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_CREDIT;
4523
CREATE CACHED TABLE PUBLIC.TAXONNAME_CREDIT_AUD(
4418 4524
    REV INTEGER NOT NULL,
4419
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4525
    TAXONNAME_ID INTEGER NOT NULL,
4420 4526
    CREDITS_ID INTEGER NOT NULL,
4421 4527
    SORTINDEX INTEGER NOT NULL,
4422 4528
    REVTYPE TINYINT
4423 4529
);
4424
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_CREDIT_AUD;
4425
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_EXTENSION(
4426
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4530
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_CREDIT_AUD;
4531
CREATE CACHED TABLE PUBLIC.TAXONNAME_EXTENSION(
4532
    TAXONNAME_ID INTEGER NOT NULL,
4427 4533
    EXTENSIONS_ID INTEGER NOT NULL
4428 4534
);
4429
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_EXTENSION;
4430
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD(
4535
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_EXTENSION;
4536
CREATE CACHED TABLE PUBLIC.TAXONNAME_EXTENSION_AUD(
4431 4537
    REV INTEGER NOT NULL,
4432
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4538
    TAXONNAME_ID INTEGER NOT NULL,
4433 4539
    EXTENSIONS_ID INTEGER NOT NULL,
4434 4540
    REVTYPE TINYINT
4435 4541
);
4436
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_EXTENSION_AUD;
4437
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_IDENTIFIER(
4438
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4542
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_EXTENSION_AUD;
4543
CREATE CACHED TABLE PUBLIC.TAXONNAME_IDENTIFIER(
4544
    TAXONNAME_ID INTEGER NOT NULL,
4439 4545
    IDENTIFIERS_ID INTEGER NOT NULL,
4440 4546
    SORTINDEX INTEGER NOT NULL
4441 4547
);
4442
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_IDENTIFIER;
4443
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_IDENTIFIER_AUD(
4548
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_IDENTIFIER;
4549
CREATE CACHED TABLE PUBLIC.TAXONNAME_IDENTIFIER_AUD(
4444 4550
    REV INTEGER NOT NULL,
4445
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4551
    TAXONNAME_ID INTEGER NOT NULL,
4446 4552
    IDENTIFIERS_ID INTEGER NOT NULL,
4447 4553
    SORTINDEX INTEGER NOT NULL,
4448 4554
    REVTYPE TINYINT
4449 4555
);
4450
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_IDENTIFIER_AUD;
4451
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_MARKER(
4452
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4556
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_IDENTIFIER_AUD;
4557
CREATE CACHED TABLE PUBLIC.TAXONNAME_MARKER(
4558
    TAXONNAME_ID INTEGER NOT NULL,
4453 4559
    MARKERS_ID INTEGER NOT NULL
4454 4560
);
4455
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_MARKER;
4456
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD(
4561
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_MARKER;
4562
CREATE CACHED TABLE PUBLIC.TAXONNAME_MARKER_AUD(
4457 4563
    REV INTEGER NOT NULL,
4458
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4564
    TAXONNAME_ID INTEGER NOT NULL,
4459 4565
    MARKERS_ID INTEGER NOT NULL,
4460 4566
    REVTYPE TINYINT
4461 4567
);
4462
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_MARKER_AUD;
4463
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS(
4464
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4568
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_MARKER_AUD;
4569
CREATE CACHED TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS(
4570
    TAXONNAME_ID INTEGER NOT NULL,
4465 4571
    STATUS_ID INTEGER NOT NULL
4466 4572
);
4467
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS;
4468
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD(
4573
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_NOMENCLATURALSTATUS;
4574
CREATE CACHED TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS_AUD(
4469 4575
    REV INTEGER NOT NULL,
4470
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4576
    TAXONNAME_ID INTEGER NOT NULL,
4471 4577
    STATUS_ID INTEGER NOT NULL,
4472 4578
    REVTYPE TINYINT
4473 4579
);
4474
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD;
4475
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE(
4476
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4580
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_NOMENCLATURALSTATUS_AUD;
4581
CREATE CACHED TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE(
4582
    TAXONNAME_ID INTEGER NOT NULL,
4477 4583
    SOURCES_ID INTEGER NOT NULL
4478 4584
);
4479
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE;
4480
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD(
4585
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_ORIGINALSOURCEBASE;
4586
CREATE CACHED TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE_AUD(
4481 4587
    REV INTEGER NOT NULL,
4482
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4588
    TAXONNAME_ID INTEGER NOT NULL,
4483 4589
    SOURCES_ID INTEGER NOT NULL,
4484 4590
    REVTYPE TINYINT
4485 4591
);
4486
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD;
4487
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO(
4488
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4592
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_ORIGINALSOURCEBASE_AUD;
4593
CREATE CACHED TABLE PUBLIC.TAXONNAME_RIGHTSINFO(
4594
    TAXONNAME_ID INTEGER NOT NULL,
4489 4595
    RIGHTS_ID INTEGER NOT NULL
4490 4596
);
4491
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_RIGHTSINFO;
4492
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO_AUD(
4597
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_RIGHTSINFO;
4598
CREATE CACHED TABLE PUBLIC.TAXONNAME_RIGHTSINFO_AUD(
4493 4599
    REV INTEGER NOT NULL,
4494
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4600
    TAXONNAME_ID INTEGER NOT NULL,
4495 4601
    RIGHTS_ID INTEGER NOT NULL,
4496 4602
    REVTYPE TINYINT
4497 4603
);
4498
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_RIGHTSINFO_AUD;
4499
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE(
4500
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4604
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_RIGHTSINFO_AUD;
4605
CREATE CACHED TABLE PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE(
4606
    TAXONNAME_ID INTEGER NOT NULL,
4501 4607
    TYPEDESIGNATIONS_ID INTEGER NOT NULL
4502 4608
);
4503
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE;
4504
CREATE CACHED TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD(
4609
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE;
4610
CREATE CACHED TABLE PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE_AUD(
4505 4611
    REV INTEGER NOT NULL,
4506
    TAXONNAMEBASE_ID INTEGER NOT NULL,
4612
    TAXONNAME_ID INTEGER NOT NULL,
4507 4613
    TYPEDESIGNATIONS_ID INTEGER NOT NULL,
4508 4614
    REVTYPE TINYINT
4509 4615
);
4510
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD;
4616
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE_AUD;
4511 4617
CREATE CACHED TABLE PUBLIC.TAXONNODE(
4512 4618
    ID INTEGER NOT NULL,
4513 4619
    CREATED TIMESTAMP,
......
4517 4623
    TREEINDEX VARCHAR(255),
4518 4624
    COUNTCHILDREN INTEGER NOT NULL,
4519 4625
    MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
4520
    CREATEDBY_ID INTEGER,
4626
	EXCLUDED BOOLEAN,
4627
	UNPLACED BOOLEAN,
4628
	CREATEDBY_ID INTEGER,
4521 4629
    UPDATEDBY_ID INTEGER,
4522 4630
    CLASSIFICATION_ID INTEGER,
4523 4631
    PARENT_ID INTEGER,
......
4587 4695
    TREEINDEX VARCHAR(255),
4588 4696
    COUNTCHILDREN INTEGER,
4589 4697
    MICROREFERENCEFORPARENTCHILDRELATION VARCHAR(255),
4698
	EXCLUDED BOOLEAN,
4699
	UNPLACED BOOLEAN,
4590 4700
    CREATEDBY_ID INTEGER,
4591 4701
    UPDATEDBY_ID INTEGER,
4592 4702
    CLASSIFICATION_ID INTEGER,
......
4608 4718
    REVTYPE TINYINT
4609 4719
);
4610 4720
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_ANNOTATION_AUD;
4721
CREATE CACHED TABLE PUBLIC.TAXONNODE_EXCLUDEDNOTE(
4722
    TAXONNODE_ID INTEGER NOT NULL,
4723
    EXCLUDEDNOTE_ID INTEGER NOT NULL,
4724
	EXCLUDEDNOTE_MAPKEY_ID INTEGER NOT NULL
4725
);
4726
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_EXCLUDEDNOTE;
4727
CREATE CACHED TABLE PUBLIC.TAXONNODE_EXCLUDEDNOTE_AUD(
4728
    REV INTEGER NOT NULL,
4729
    TAXONNODE_ID INTEGER NOT NULL,
4730
    EXCLUDEDNOTE_ID INTEGER NOT NULL,
4731
	EXCLUDEDNOTE_MAPKEY_ID INTEGER NOT NULL,
4732
    REVTYPE TINYINT
4733
);
4734
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.TAXONNODE_EXCLUDEDNOTE_AUD;
4611 4735
CREATE CACHED TABLE PUBLIC.TAXONNODE_MARKER(
4612 4736
    TAXONNODE_ID INTEGER NOT NULL,
4613 4737
    MARKERS_ID INTEGER NOT NULL
......
4933 5057
    UPDATED TIMESTAMP,
4934 5058
    CREATEDBY_ID INTEGER,
4935 5059
    UPDATEDBY_ID INTEGER,
4936
    DESCRIPTIVESYSTEM_ID INTEGER
5060
    DESCRIPTIVESYSTEM_ID INTEGER,
5061
	MAXRANK_ID INTEGER,
5062
	MINRANK_ID INTEGER
4937 5063
);
4938 5064
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET;
4939 5065
CREATE CACHED TABLE PUBLIC.WORKINGSET_AUD(
......
4946 5072
    UPDATED TIMESTAMP,
4947 5073
    CREATEDBY_ID INTEGER,
4948 5074
    UPDATEDBY_ID INTEGER,
4949
    DESCRIPTIVESYSTEM_ID INTEGER
5075
    DESCRIPTIVESYSTEM_ID INTEGER,
5076
	MAXRANK_ID INTEGER,
5077
	MINRANK_ID INTEGER
4950 5078
);
4951 5079
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_AUD;
4952 5080
CREATE CACHED TABLE PUBLIC.WORKINGSET_ANNOTATION(
......
4985 5113
    REVTYPE TINYINT
4986 5114
);
4987 5115
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_MARKER_AUD;
5116
CREATE CACHED TABLE PUBLIC.WORKINGSET_NAMEDAREA(
5117
    WORKINGSET_ID INTEGER NOT NULL,
5118
    GEOFILTER_ID INTEGER NOT NULL
5119
);
5120
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_NAMEDAREA;
5121
CREATE CACHED TABLE PUBLIC.WORKINGSET_NAMEDAREA_AUD(
5122
    REV INTEGER NOT NULL,
5123
    WORKINGSET_ID INTEGER NOT NULL,
5124
    GEOFILTER_ID INTEGER NOT NULL,
5125
    REVTYPE TINYINT
5126
);
5127
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_NAMEDAREA_AUD;
4988 5128
CREATE CACHED TABLE PUBLIC.WORKINGSET_REPRESENTATION(
4989 5129
    WORKINGSET_ID INTEGER NOT NULL,
4990 5130
    REPRESENTATIONS_ID INTEGER NOT NULL
......
4997 5137
    REVTYPE TINYINT
4998 5138
);
4999 5139
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_REPRESENTATION_AUD;
5140
CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONNODE(
5141
    WORKINGSET_ID INTEGER NOT NULL,
5142
    TAXONSUBTREEFILTER_ID INTEGER NOT NULL
5143
);
5144
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_TAXONNODE;
5145
CREATE CACHED TABLE PUBLIC.WORKINGSET_TAXONNODE_AUD(
5146
    REV INTEGER NOT NULL,
5147
    WORKINGSET_ID INTEGER NOT NULL,
5148
    TAXONSUBTREEFILTER_ID INTEGER NOT NULL,
5149
    REVTYPE TINYINT
5150
);
5151
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.WORKINGSET_TAXONNODE_AUD;
5000 5152
CREATE CACHED TABLE PUBLIC.HIBERNATE_SEQUENCES(
5001 5153
    SEQUENCE_NAME VARCHAR(255) NOT NULL,
5002 5154
    NEXT_VAL BIGINT
......
5013 5165
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBCB PRIMARY KEY(REV, WORKINGSET_ID, ANNOTATIONS_ID);
5014 5166
ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBC2 PRIMARY KEY(TAXONBASE_ID, SOURCES_ID);
5015 5167
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33F PRIMARY KEY(REV, GATHERINGEVENT_ID, MARKERS_ID);
5016
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D7 PRIMARY KEY(TAXONNAMEBASE_ID, STATUS_ID);
5168
ALTER TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D7 PRIMARY KEY(TAXONNAME_ID, STATUS_ID);
5017 5169
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBAC PRIMARY KEY(COUNTRY_ID, CONTINENTS_ID);
5018 5170
ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB0 PRIMARY KEY(DETERMINATIONEVENT_ID, MARKERS_ID);
5019
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33C PRIMARY KEY(REV, TAXONNAMEBASE_ID, SOURCES_ID);
5171
ALTER TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX33C PRIMARY KEY(REV, TAXONNAME_ID, SOURCES_ID);
5020 5172
ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD PRIMARY KEY(DEFINEDTERMBASE_ID, SOURCES_ID);
5021 5173
ALTER TABLE PUBLIC.TAXONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX185 PRIMARY KEY(TAXONBASE_ID, RIGHTS_ID);
5022 5174
ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX36E PRIMARY KEY(TERMVOCABULARY_ID, SOURCES_ID);
......
5053 5205
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9E5 PRIMARY KEY(POLYTOMOUSKEY_ID, ANNOTATIONS_ID);
5054 5206
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX314 PRIMARY KEY(ID, REV);
5055 5207
ALTER TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX599 PRIMARY KEY(INSTITUTION_ID, TYPES_ID);
5056
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXECE PRIMARY KEY(REV, TAXONNAMEBASE_ID, STATUS_ID);
5208
ALTER TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXECE PRIMARY KEY(REV, TAXONNAME_ID, STATUS_ID);
5057 5209
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX32A PRIMARY KEY(STATISTICALMEASUREMENTVALUE_ID, MODIFIERS_ID);
5058 5210
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEEB PRIMARY KEY(REV, TYPEDESIGNATIONBASE_ID, MARKERS_ID);
5059 5211
ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9E0 PRIMARY KEY(REV, SEQUENCE_ID, ANNOTATIONS_ID);
......
5065 5217
ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED7 PRIMARY KEY(TAXONNODE_ID, ANNOTATIONS_ID);
5066 5218
ALTER TABLE PUBLIC.MEDIAKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF33 PRIMARY KEY(MEDIAKEY_ID, GEOGRAPHICALSCOPE_ID);
5067 5219
ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7B1 PRIMARY KEY(ID);
5068
ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED2 PRIMARY KEY(TAXONNAMEBASE_ID, TYPEDESIGNATIONS_ID);
5220
ALTER TABLE PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED2 PRIMARY KEY(TAXONNAME_ID, TYPEDESIGNATIONS_ID);
5069 5221
ALTER TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2CD PRIMARY KEY(REV, FEATURE_ID, RECOMMENDEDSTATISTICALMEASURES_ID);
5070 5222
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXECC PRIMARY KEY(HYBRIDRELATIONSHIP_ID, MARKERS_ID);
5071 5223
ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2E2 PRIMARY KEY(TERMVOCABULARY_ID, MARKERS_ID);
......
5096 5248
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69EA PRIMARY KEY(ID);
5097 5249
ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC0F PRIMARY KEY(ID);
5098 5250
ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC47 PRIMARY KEY(REV, MEDIA_ID, ANNOTATIONS_ID);
5099
ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD56 PRIMARY KEY(REV, TAXONNAMEBASE_ID, RIGHTS_ID);
5251
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD56 PRIMARY KEY(REV, TAXONNAME_ID, RIGHTS_ID);
5100 5252
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX818 PRIMARY KEY(ID);
5101 5253
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD80 PRIMARY KEY(POLYTOMOUSKEY_ID, SOURCES_ID);
5102
ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD2A PRIMARY KEY(REV, TAXONNAMEBASE_ID, EXTENSIONS_ID);
5254
ALTER TABLE PUBLIC.TAXONNAME_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD2A PRIMARY KEY(REV, TAXONNAME_ID, EXTENSIONS_ID);
5103 5255
ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX71C PRIMARY KEY(REFERENCE_ID, SORTINDEX);
5104
ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD2F PRIMARY KEY(REV, TAXONNAMEBASE_ID, ANNOTATIONS_ID);
5256
ALTER TABLE PUBLIC.TAXONNAME_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD2F PRIMARY KEY(REV, TAXONNAME_ID, ANNOTATIONS_ID);
5105 5257
ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX729 PRIMARY KEY(KEYSTATEMENT_ID, LABEL_MAPKEY_ID);
5106 5258
ALTER TABLE PUBLIC.DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD96 PRIMARY KEY(ID, REV);
5107 5259
ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD2 PRIMARY KEY(REV, TAXONINTERACTION_ID, DESCRIPTION_ID, DESCRIPTION_MAPKEY_ID);
......
5128 5280
--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD7 PRIMARY KEY(CLASSIFICATION_ID, ROOTNODES_ID);
5129 5281
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD6 PRIMARY KEY(REV, DETERMINATIONEVENT_ID, SETOFREFERENCES_ID);
5130 5282
ALTER TABLE PUBLIC.DERIVATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD9 PRIMARY KEY(DERIVATIONEVENT_ID, MARKERS_ID);
5131
ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDC7 PRIMARY KEY(TAXONNAMEBASE_ID, EXTENSIONS_ID);
5283
ALTER TABLE PUBLIC.TAXONNAME_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDC7 PRIMARY KEY(TAXONNAME_ID, EXTENSIONS_ID);
5132 5284
ALTER TABLE PUBLIC.DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE2 PRIMARY KEY(ID, REV);
5133 5285
ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE0 PRIMARY KEY(FEATURETREE_ID, SORTINDEX);
5134 5286
ALTER TABLE PUBLIC.COLLECTION_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDD PRIMARY KEY(COLLECTION_ID, RIGHTS_ID);
......
5171 5323
ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX906 PRIMARY KEY(FEATURETREE_ID, SOURCES_ID);
5172 5324
ALTER TABLE PUBLIC.RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX901 PRIMARY KEY(ID);
5173 5325
ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX909 PRIMARY KEY(REV, MEDIA_ID, SOURCES_ID);
5174
ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA1D PRIMARY KEY(TAXONNAMEBASE_ID, RIGHTS_ID);
5175
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX919 PRIMARY KEY(ID);
5326
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA1D PRIMARY KEY(TAXONNAME_ID, RIGHTS_ID);
5327
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX919 PRIMARY KEY(ID);
5176 5328
ALTER TABLE PUBLIC.LSIDAUTHORITY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA44 PRIMARY KEY(ID);
5177 5329
ALTER TABLE PUBLIC.DESCRIPTIONBASE_FEATURE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX435 PRIMARY KEY(DESCRIPTIONBASE_ID, DESCRIPTIVESYSTEM_ID);
5178 5330
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5F PRIMARY KEY(HOMOTYPICALGROUP_ID, ANNOTATIONS_ID);
......
5230 5382
ALTER TABLE PUBLIC.TERMVOCABULARY_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC3CB PRIMARY KEY(TERMVOCABULARY_ID, EXTENSIONS_ID);
5231 5383
ALTER TABLE PUBLIC.FEATURENODE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9FE PRIMARY KEY(ID, REV);
5232 5384
ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56B PRIMARY KEY(DERIVATIONEVENT_ID, ANNOTATIONS_ID);
5233
ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56A PRIMARY KEY(REV, TAXONNAMEBASE_ID, CREDITS_ID, SORTINDEX);
5385
ALTER TABLE PUBLIC.TAXONNAME_CREDIT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56A PRIMARY KEY(REV, TAXONNAME_ID, CREDITS_ID, SORTINDEX);
5234 5386
ALTER TABLE PUBLIC.MEDIA_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX564 PRIMARY KEY(REV, MEDIA_ID, EXTENSIONS_ID);
5235 5387
ALTER TABLE PUBLIC.REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX560 PRIMARY KEY(ID);
5236 5388
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBF7 PRIMARY KEY(ID);
......
5246 5398
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB36 PRIMARY KEY(SPECIMENOROBSERVATIONBASE_ID, RIGHTS_ID);
5247 5399
ALTER TABLE PUBLIC.TAXONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE3C PRIMARY KEY(REV, TAXONBASE_ID, SOURCES_ID);
5248 5400
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC81E PRIMARY KEY(ID, REV);
5249
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX98E PRIMARY KEY(TAXONNAMEBASE_ID, MARKERS_ID);
5401
ALTER TABLE PUBLIC.TAXONNAME_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX98E PRIMARY KEY(TAXONNAME_ID, MARKERS_ID);
5250 5402
ALTER TABLE PUBLIC.FEATURENODE_DEFINEDTERMBASE_ONLYAPPLICABLE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA85 PRIMARY KEY(FEATURENODE_ID, ONLYAPPLICABLEIF_ID);
5251 5403
ALTER TABLE PUBLIC.WORKINGSET_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB92 PRIMARY KEY(ID, REV);
5252 5404
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB5D PRIMARY KEY(NOMENCLATURALSTATUS_ID, MARKERS_ID);
......
5257 5409
ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB5A PRIMARY KEY(REV, POLYTOMOUSKEY_ID, COVEREDTAXA_ID);
5258 5410
ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB62 PRIMARY KEY(TAXONNODE_ID, MARKERS_ID);
5259 5411
ALTER TABLE PUBLIC.MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5F7 PRIMARY KEY(ID, REV);
5260
ALTER TABLE PUBLIC.TAXONNAMEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5F6 PRIMARY KEY(ID, REV);
5412
ALTER TABLE PUBLIC.TAXONNAME_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5F6 PRIMARY KEY(ID, REV);
5261 5413
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5E PRIMARY KEY(REV, POLYTOMOUSKEYNODE_ID, MODIFYINGTEXT_ID, MODIFYINGTEXT_MAPKEY_ID);
5262 5414
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX94C PRIMARY KEY(ID);
5263 5415
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFA8 PRIMARY KEY(ID, REV);
......
5277 5429
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F PRIMARY KEY(FEATURETREE_ID, EXTENSIONS_ID);
5278 5430
--ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX9EB PRIMARY KEY(SEQUENCE_ID, ANNOTATIONS_ID);
5279 5431
ALTER TABLE PUBLIC.RIGHTSINFO_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5DE PRIMARY KEY(RIGHTS_ID, ANNOTATIONS_ID);
5280
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA96 PRIMARY KEY(RELATIONSHIPTERMBASE_ID, INVERSEREPRESENTATIONS_ID);
5432
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA96 PRIMARY KEY(TERM_ID, INVERSEREPRESENTATIONS_ID);
5281 5433
ALTER TABLE PUBLIC.MEDIA_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA7B PRIMARY KEY(REV, MEDIA_ID, MARKERS_ID);
5282 5434
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA7D PRIMARY KEY(REV, SPECIMENOROBSERVATIONBASE_ID, ANNOTATIONS_ID);
5283
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEB6 PRIMARY KEY(TAXONNAMEBASE_ID, SOURCES_ID);
5435
ALTER TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEB6 PRIMARY KEY(TAXONNAME_ID, SOURCES_ID);
5284 5436
ALTER TABLE PUBLIC.NAMERELATIONSHIP_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC34 PRIMARY KEY(REV, NAMERELATIONSHIP_ID, ANNOTATIONS_ID);
5285 5437
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88C PRIMARY KEY(SEQUENCE_ID, EXTENSIONS_ID);
5286 5438
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX807 PRIMARY KEY(SEQUENCE_ID, CHROMATOGRAMS_ID);
......
5313 5465
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69 PRIMARY KEY(DEFINEDTERMBASE_ID, RIGHTS_ID);
5314 5466
ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX72 PRIMARY KEY(REV, DERIVATIONEVENT_ID, ANNOTATIONS_ID);
5315 5467
ALTER TABLE PUBLIC.LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXDC8 PRIMARY KEY(ID, REV);
5316
ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88B PRIMARY KEY(TAXONNAMEBASE_ID, SORTINDEX);
5468
ALTER TABLE PUBLIC.TAXONNAME_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88B PRIMARY KEY(TAXONNAME_ID, SORTINDEX);
5317 5469
ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX64 PRIMARY KEY(REV, TERMVOCABULARY_ID, MARKERS_ID);
5318 5470
ALTER TABLE PUBLIC.WORKINGSET ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA5 PRIMARY KEY(ID);
5319 5471
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX1E1 PRIMARY KEY(ID);
......
5334 5486
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX95 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_PHONENUMBERS_ELEMENT);
5335 5487
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA5 PRIMARY KEY(REV, FEATURE_ID, RECOMMENDEDMODIFIERENUMERATION_ID);
5336 5488
ALTER TABLE PUBLIC.KEYSTATEMENT_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA6 PRIMARY KEY(ID, REV);
5337
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX698 PRIMARY KEY(REV, TAXONNAMEBASE_ID, MARKERS_ID);
5489
ALTER TABLE PUBLIC.TAXONNAME_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX698 PRIMARY KEY(REV, TAXONNAME_ID, MARKERS_ID);
5338 5490
ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3A PRIMARY KEY(REV, DEFINEDTERMBASE_ID, SOURCES_ID);
5339 5491
ALTER TABLE PUBLIC.COLLECTION_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX60 PRIMARY KEY(REV, COLLECTION_ID, MEDIA_ID);
5340 5492
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA1 PRIMARY KEY(REV, TEXTDATA_ID, MULTILANGUAGETEXT_ID, MULTILANGUAGETEXT_MAPKEY_ID);
5341 5493
ALTER TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63 PRIMARY KEY(DESCRIPTIONBASE_ID, ANNOTATIONS_ID);
5342 5494
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5D PRIMARY KEY(DESCRIPTIONELEMENTBASE_ID, ANNOTATIONS_ID);
5343
ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA4 PRIMARY KEY(TAXONNAMEBASE_ID, ANNOTATIONS_ID);
5495
ALTER TABLE PUBLIC.TAXONNAME_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA4 PRIMARY KEY(TAXONNAME_ID, ANNOTATIONS_ID);
5344 5496
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_URLS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5C PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_URLS_ELEMENT);
5345 5497
ALTER TABLE PUBLIC.TAXONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX6B24 PRIMARY KEY(REV, TAXONBASE_ID, EXTENSIONS_ID);
5346 5498
ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5F PRIMARY KEY(REV, DEFINEDTERMBASE_ID, REPRESENTATIONS_ID);
......
5408 5560
ALTER TABLE PUBLIC.MEDIA_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX46 PRIMARY KEY(MEDIAKEY_ID, KEYREPRESENTATIONS_ID);
5409 5561
ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E PRIMARY KEY(REV, DETERMINATIONEVENT_ID, MARKERS_ID);
5410 5562
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_MARKER_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX45 PRIMARY KEY(REV, HOMOTYPICALGROUP_ID, MARKERS_ID);
5411
ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E3 PRIMARY KEY(REV, TAXONNAMEBASE_ID, TYPEDESIGNATIONS_ID);
5563
ALTER TABLE PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX3E3 PRIMARY KEY(REV, TAXONNAME_ID, TYPEDESIGNATIONS_ID);
5412 5564
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX52 PRIMARY KEY(REV, DEFINEDTERMBASE_ID, MEDIA_ID);
5413 5565
ALTER TABLE PUBLIC.AGENTBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX44 PRIMARY KEY(AGENTBASE_ID, EXTENSIONS_ID);
5414 5566
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX50 PRIMARY KEY(DEFINEDTERMBASE_ID, SORTINDEX);
......
5417 5569
ALTER TABLE PUBLIC.MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX871 PRIMARY KEY(ID);
5418 5570
ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCC8 PRIMARY KEY(GATHERINGEVENT_ID, COLLECTINGAREAS_ID);
5419 5571
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC1 PRIMARY KEY(REV, REFERENCE_ID, SOURCES_ID);
5420
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX51 PRIMARY KEY(REV, RELATIONSHIPTERMBASE_ID, INVERSEREPRESENTATIONS_ID);
5572
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX51 PRIMARY KEY(REV, TERM_ID, INVERSEREPRESENTATIONS_ID);
5421 5573
ALTER TABLE PUBLIC.AGENTBASE_ADDRESS_AUD ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCE45 PRIMARY KEY(REV, AGENTBASE_ID, CONTACT_ADDRESSES_ID);
5422 5574
ALTER TABLE PUBLIC.PERMISSIONGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE26 PRIMARY KEY(ID);
5423 5575
ALTER TABLE PUBLIC.FEATURETREE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX93 PRIMARY KEY(FEATURETREE_ID, ANNOTATIONS_ID);
......
5489 5641
ALTER TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX56B9 UNIQUE(ANNOTATIONS_ID);
5490 5642
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE98 UNIQUE(MODIFYINGTEXT_ID);
5491 5643
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF0C6 UNIQUE(MARKERS_ID);
5492
ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA1D5 UNIQUE(RIGHTS_ID);
5644
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA1D5 UNIQUE(RIGHTS_ID);
5493 5645
ALTER TABLE PUBLIC.FEATURETREE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXE04 UNIQUE(CREDITS_ID);
5494 5646
ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXC03 UNIQUE(UUID);
5495 5647
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXXXXF21 UNIQUE(CREDITS_ID);
......
5512 5664
ALTER TABLE PUBLIC.LANGUAGESTRING_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5422 UNIQUE(ANNOTATIONS_ID);
5513 5665
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB36B UNIQUE(RIGHTS_ID);
5514 5666
ALTER TABLE PUBLIC.COLLECTION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD488 UNIQUE(MARKERS_ID);
5515
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX98E1 UNIQUE(MARKERS_ID);
5667
ALTER TABLE PUBLIC.TAXONNAME_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX98E1 UNIQUE(MARKERS_ID);
5516 5668
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX4E7 UNIQUE(SOURCES_ID);
5517 5669
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX50A UNIQUE(CREDITS_ID);
5518 5670
ALTER TABLE PUBLIC.DETERMINATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFEB UNIQUE(UUID);
......
5566 5718
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2820 UNIQUE(ANNOTATIONS_ID);
5567 5719
ALTER TABLE PUBLIC.ANNOTATION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXAE UNIQUE(ANNOTATIONS_ID);
5568 5720
ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF52 UNIQUE(RIGHTS_ID);
5569
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEB60 UNIQUE(SOURCES_ID);
5721
ALTER TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXEB60 UNIQUE(SOURCES_ID);
5570 5722
ALTER TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE56 UNIQUE(SOURCES_ID);
5571 5723
ALTER TABLE PUBLIC.EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX819 UNIQUE(UUID);
5572 5724
ALTER TABLE PUBLIC.CDM_VIEW_CDM_VIEW ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX230 UNIQUE(SUPERVIEWS_ID);
......
5601 5753
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX35B UNIQUE(UUID);
5602 5754
ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFF44 UNIQUE(CREDITS_ID);
5603 5755
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBBE UNIQUE(EXTENSIONS_ID);
5604
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX919B UNIQUE(UUID);
5756
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX919B UNIQUE(UUID);
5605 5757
ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX2A9 UNIQUE(UUID);
5606 5758
ALTER TABLE PUBLIC.TAXONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXF6BE UNIQUE(MARKERS_ID);
5607 5759
ALTER TABLE PUBLIC.TERMVOCABULARY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8B66 UNIQUE(UUID);
5608 5760
ALTER TABLE PUBLIC.ANNOTATION_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX953D UNIQUE(MARKERS_ID);
5609
ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA49 UNIQUE(ANNOTATIONS_ID);
5761
ALTER TABLE PUBLIC.TAXONNAME_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCA49 UNIQUE(ANNOTATIONS_ID);
5610 5762
ALTER TABLE PUBLIC.DESCRIPTIONBASE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFD69 UNIQUE(MARKERS_ID);
5611 5763
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX43DC UNIQUE(MARKERS_ID);
5612 5764
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXECC2 UNIQUE(MARKERS_ID);
5613 5765
ALTER TABLE PUBLIC.HOMOTYPICALGROUP ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC247 UNIQUE(UUID);
5614 5766
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX688 UNIQUE(SOURCES_ID);
5615 5767
ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX75 UNIQUE(SOURCES_ID);
5616
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA961 UNIQUE(INVERSEREPRESENTATIONS_ID);
5768
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA961 UNIQUE(INVERSEREPRESENTATIONS_ID);
5617 5769
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXC4F06 UNIQUE(UUID, USERNAME);
5618 5770
ALTER TABLE PUBLIC.ADDRESS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE6 UNIQUE(UUID);
5619 5771
ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXE924 UNIQUE(ANNOTATIONS_ID);
5620 5772
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX145 UNIQUE(RECOMMENDEDMODIFIERENUMERATION_ID);
5621 5773
ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXBB00 UNIQUE(MARKERS_ID);
5622
ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88BA UNIQUE(CREDITS_ID);
5774
ALTER TABLE PUBLIC.TAXONNAME_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX88BA UNIQUE(CREDITS_ID);
5623 5775
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX8079 UNIQUE(CHROMATOGRAMS_ID);
5624 5776
ALTER TABLE PUBLIC.LSIDAUTHORITY ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXA443 UNIQUE(UUID, AUTHORITY);
5625 5777
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX69B UNIQUE(RIGHTS_ID);
......
5636 5788
ALTER TABLE PUBLIC.TERMVOCABULARY_RIGHTSINFO ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX371A UNIQUE(RIGHTS_ID);
5637 5789
ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB625 UNIQUE(MARKERS_ID);
5638 5790
ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX444F UNIQUE(REPRESENTATIONS_ID);
5639
ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDC73 UNIQUE(EXTENSIONS_ID);
5791
ALTER TABLE PUBLIC.TAXONNAME_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXFDC73 UNIQUE(EXTENSIONS_ID);
5640 5792
ALTER TABLE PUBLIC.DERIVATIONEVENT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX83EE UNIQUE(UUID);
5641 5793
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5575 UNIQUE(UUID);
5642 5794
ALTER TABLE PUBLIC.GATHERINGEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX63FFD UNIQUE(ANNOTATIONS_ID);
......
5661 5813
ALTER TABLE PUBLIC.FEATURETREE_EXTENSION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXB9F0 UNIQUE(EXTENSIONS_ID);
5662 5814
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXCFB UNIQUE(ANNOTATIONS_ID);
5663 5815
ALTER TABLE PUBLIC.DESCRIPTIONBASE_CREDIT ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXED4 UNIQUE(CREDITS_ID);
5664
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D78 UNIQUE(STATUS_ID);
5816
ALTER TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX7D78 UNIQUE(STATUS_ID);
5665 5817
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX5094 UNIQUE(MULTILANGUAGETEXT_ID);
5666 5818
ALTER TABLE PUBLIC.RIGHTSINFO_MARKER ADD CONSTRAINT PUBLIC.CONSTRAINT_XXX14BB UNIQUE(MARKERS_ID);
5667 5819
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.CONSTRAINT_XXXD4BB UNIQUE(UUID);
......
5681 5833
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKCFAA93163B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
5682 5834
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE767134AF0E81 FOREIGN KEY(INDESCRIPTION_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;
5683 5835
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK365E4F3C3B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
5684
ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.FK29BCD8B28C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
5836
ALTER TABLE PUBLIC.TAXONNAME_CREDIT ADD CONSTRAINT PUBLIC.FK29BCD8B28C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5685 5837
ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER ADD CONSTRAINT PUBLIC.FK862BAEA7258E060 FOREIGN KEY(TERMVOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
5686 5838
ALTER TABLE PUBLIC.RIGHTSINFO_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKF98828E834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5687 5839
ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK41ED09731E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
......
5691 5843
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA32728C750E27 FOREIGN KEY(LIFESTAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
5692 5844
ALTER TABLE PUBLIC.AGENTBASE_EXTENSION ADD CONSTRAINT PUBLIC.FK8E1E5676927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
5693 5845
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER ADD CONSTRAINT PUBLIC.FK89261453C0DB4934 FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
5694
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAE4CB0F315 FOREIGN KEY(TYPENAME_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
5846
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAE4CB0F315 FOREIGN KEY(TYPENAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5695 5847
ALTER TABLE PUBLIC.TAXONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK65CF621B9C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
5696 5848
ALTER TABLE PUBLIC.MEDIA_MARKER ADD CONSTRAINT PUBLIC.FKD21E7935C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
5697 5849
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4B22838834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5698
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5850
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C67F90DF03 FOREIGN KEY(EXBASIONYMAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5699 5851
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_MARKER ADD CONSTRAINT PUBLIC.FKB3FFDC7C777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
5700 5852
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
5701 5853
ALTER TABLE PUBLIC.MEDIA_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK99ABA37B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
5707 5859
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FKDD9AE8FC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5708 5860
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKF3D3D74334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5709 5861
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK4D73278044E9E6D4 FOREIGN KEY(TYPEDESIGNATIONBASE_ID) REFERENCES PUBLIC.TYPEDESIGNATIONBASE(ID) NOCHECK;
5710
ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK9E7794688C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
5862
ALTER TABLE PUBLIC.TAXONNAME_ANNOTATION ADD CONSTRAINT PUBLIC.FK9E7794688C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5711 5863
ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5712 5864
ALTER TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FKAE4A67A734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5713 5865
ALTER TABLE PUBLIC.FEATURETREE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK8E50DD02C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
......
5724 5876
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE ADD CONSTRAINT PUBLIC.FK8FB1ED8355A53F64 FOREIGN KEY(SETOFREFERENCES_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
5725 5877
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK409B7FE334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5726 5878
ALTER TABLE PUBLIC.CREDIT ADD CONSTRAINT PUBLIC.FK78CA97194FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5727
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E5108328482454 FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
5879
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E5108328482454 FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5728 5880
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.FK1FFEC88BBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5729 5881
ALTER TABLE PUBLIC.HOMOTYPICALGROUP ADD CONSTRAINT PUBLIC.FK7DECCC184FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5730 5882
ALTER TABLE PUBLIC.REPRESENTATION_MARKER ADD CONSTRAINT PUBLIC.FK560063EC47E8AE60 FOREIGN KEY(REPRESENTATION_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
......
5791 5943
ALTER TABLE PUBLIC.FEATURETREE_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FKECAB4AC934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5792 5944
ALTER TABLE PUBLIC.MEDIA_SEQUENCE ADD CONSTRAINT PUBLIC.FK61D09FCF29B4761 FOREIGN KEY(USEDSEQUENCES_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
5793 5945
ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXONBASE ADD CONSTRAINT PUBLIC.FKED8F3A5489D97CB FOREIGN KEY(POLYTOMOUSKEY_ID) REFERENCES PUBLIC.POLYTOMOUSKEY(ID) NOCHECK;
5794
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKF746D2768C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
5946
ALTER TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKF746D2768C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5795 5947
ALTER TABLE PUBLIC.MEDIAREPRESENTATIONPART ADD CONSTRAINT PUBLIC.FK67A455444FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5796 5948
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E51083BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5797 5949
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK839208C43A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
5798 5950
--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.FKB0BD86D318929176 FOREIGN KEY(ROOTNODES_ID) REFERENCES PUBLIC.TAXONNODE(ID) NOCHECK;
5799 5951
ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5FDC9A94FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5800
ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT ADD CONSTRAINT PUBLIC.FK29BCD8B232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
5952
ALTER TABLE PUBLIC.TAXONNAME_CREDIT ADD CONSTRAINT PUBLIC.FK29BCD8B232D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
5801 5953
ALTER TABLE PUBLIC.POLYTOMOUSKEY ADD CONSTRAINT PUBLIC.FKA9E6B1384FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5802 5954
ALTER TABLE PUBLIC.FEATURETREE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK7B5CDEB934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5803 5955
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_EXTENSION ADD CONSTRAINT PUBLIC.FKE03B82923B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
......
5827 5979
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFIER ADD CONSTRAINT PUBLIC.FK97E0D105E0960EC4 FOREIGN KEY(MODIFIERS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
5828 5980
ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49B4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5829 5981
ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION ADD CONSTRAINT PUBLIC.FKD8A9A9A21E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
5830
ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.FKC28EE7E68C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
5982
ALTER TABLE PUBLIC.TAXONNAME_EXTENSION ADD CONSTRAINT PUBLIC.FKC28EE7E68C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5831 5983
ALTER TABLE PUBLIC.REFERENCE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK4AD9EDFE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5832 5984
ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2B4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5833 5985
ALTER TABLE PUBLIC.RIGHTSINFO ADD CONSTRAINT PUBLIC.FK91E56DF7BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
5859 6011
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKCA7F794A3A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
5860 6012
ALTER TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK626B785084A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;
5861 6013
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.FK1966BDB1C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
5862
ALTER TABLE PUBLIC.TAXONNAMEBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FKD9895D8334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6014
ALTER TABLE PUBLIC.TAXONNAME_CREDIT_AUD ADD CONSTRAINT PUBLIC.FKD9895D8334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5863 6015
ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.FK1A21C74FE8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
5864 6016
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP_MARKER ADD CONSTRAINT PUBLIC.FKCEF24485777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
5865 6017
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK88BF955134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5866 6018
ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKCB4FE9BE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5867
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.FK560BA7926615E90D FOREIGN KEY(STATUS_ID) REFERENCES PUBLIC.NOMENCLATURALSTATUS(ID) NOCHECK;
6019
ALTER TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.FK560BA7926615E90D FOREIGN KEY(STATUS_ID) REFERENCES PUBLIC.NOMENCLATURALSTATUS(ID) NOCHECK;
5868 6020
ALTER TABLE PUBLIC.TAXONNODE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKB2C4367334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5869 6021
ALTER TABLE PUBLIC.COLLECTION_MARKER ADD CONSTRAINT PUBLIC.FKF0CA00FBEB62BE9A FOREIGN KEY(COLLECTION_ID) REFERENCES PUBLIC.COLLECTION(ID) NOCHECK;
5870 6022
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD ADD CONSTRAINT PUBLIC.FK88A308E634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5871 6023
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK208142711E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
5872
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E5108316CDFF85 FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6024
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E5108316CDFF85 FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5873 6025
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBDBBD2C869 FOREIGN KEY(WORKINGSET_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
5874 6026
ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
5875 6027
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA_AUD ADD CONSTRAINT PUBLIC.FK20025CB734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5876
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6028
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C662AD57A2 FOREIGN KEY(EXCOMBINATIONAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5877 6029
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK921A01F0C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
5878 6030
ALTER TABLE PUBLIC.INDIVIDUALSASSOCIATION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5C75EC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5879 6031
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB110006BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
5924 6076
ALTER TABLE PUBLIC.COLLECTION_RIGHTSINFO ADD CONSTRAINT PUBLIC.FKF9BDEE98C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
5925 6077
ALTER TABLE PUBLIC.RIGHTSINFO ADD CONSTRAINT PUBLIC.FK91E56DF7F7976FC5 FOREIGN KEY(AGENT_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5926 6078
ALTER TABLE PUBLIC.LANGUAGESTRING_MARKER ADD CONSTRAINT PUBLIC.FK8DA633B037998500 FOREIGN KEY(LANGUAGESTRING_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5927
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F3777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6079
ALTER TABLE PUBLIC.TAXONNAME_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F3777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
5928 6080
ALTER TABLE PUBLIC.REFERENCE_CREDIT ADD CONSTRAINT PUBLIC.FK5BC6DEAD32D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
5929 6081
ALTER TABLE PUBLIC.MEDIA_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK2FEEB6B8C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
5930 6082
ALTER TABLE PUBLIC.MEDIA_RIGHTSINFO ADD CONSTRAINT PUBLIC.FKDB1266D2C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
......
5934 6086
ALTER TABLE PUBLIC.DESCRIPTIONBASE_SCOPE ADD CONSTRAINT PUBLIC.FKB9257C42951A5D40 FOREIGN KEY(SCOPES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
5935 6087
--ALTER TABLE PUBLIC.SEQUENCE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK1B1ABB6634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5936 6088
ALTER TABLE PUBLIC.REFERENCE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK1DF60C5C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5937
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.FK9033CE749DD57A93 FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6089
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.FK9033CE749DD57A93 FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5938 6090
ALTER TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKB482C5E686EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
5939 6091
ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK2E340A6647AF954C FOREIGN KEY(VOCABULARY_ID) REFERENCES PUBLIC.TERMVOCABULARY(ID) NOCHECK;
5940 6092
ALTER TABLE PUBLIC.TAXONBASE_EXTENSION ADD CONSTRAINT PUBLIC.FKF961257B9C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
......
5959 6111
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.FK4CF19F94BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5960 6112
ALTER TABLE PUBLIC.PERMISSIONGROUP_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FK5311437CA0971A3 FOREIGN KEY(GROUP_ID) REFERENCES PUBLIC.PERMISSIONGROUP(ID) NOCHECK;
5961 6113
--ALTER TABLE PUBLIC.CLASSIFICATION_TAXONNODE ADD CONSTRAINT PUBLIC.FKB0BD86D384A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;
5962
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKF746D2763A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
6114
ALTER TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKF746D2763A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
5963 6115
ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02F8991B9D FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
5964 6116
ALTER TABLE PUBLIC.FEATURETREE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK8E50DD0247C496CB FOREIGN KEY(FEATURETREE_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;
5965 6117
ALTER TABLE PUBLIC.TAXONBASE_MARKER ADD CONSTRAINT PUBLIC.FK5CDB747E9C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
5966 6118
ALTER TABLE PUBLIC.TAXONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK71381DCC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5967 6119
ALTER TABLE PUBLIC.CLASSIFICATION_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK289591F734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5968
ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKBB24070634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6120
ALTER TABLE PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.FKBB24070634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5969 6121
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.FK2D26AB8834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5970 6122
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK1E28140E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5971 6123
ALTER TABLE PUBLIC.COLLECTION_EXTENSION ADD CONSTRAINT PUBLIC.FKF68FEBDE927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
5972 6124
--ALTER TABLE PUBLIC.SEQUENCE_MEDIA ADD CONSTRAINT PUBLIC.FK8E5D91E6D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
5973
ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK42D7AF908C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6125
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK42D7AF908C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
5974 6126
ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCCCC05993E FOREIGN KEY(SYNONYMTOBEUSED_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
5975 6127
ALTER TABLE PUBLIC.TAXONBASE_CREDIT ADD CONSTRAINT PUBLIC.FK4CB48B3D32D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
5976 6128
ALTER TABLE PUBLIC.TAXONRELATIONSHIP_ANNOTATION ADD CONSTRAINT PUBLIC.FK82C86DAC2BD180D9 FOREIGN KEY(TAXONRELATIONSHIP_ID) REFERENCES PUBLIC.TAXONRELATIONSHIP(ID) NOCHECK;
......
5979 6131
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MODIFYINGTEXT ADD CONSTRAINT PUBLIC.FK522D90C73B8BB609 FOREIGN KEY(DESCRIPTIONELEMENTBASE_ID) REFERENCES PUBLIC.DESCRIPTIONELEMENTBASE(ID) NOCHECK;
5980 6132
ALTER TABLE PUBLIC.POLYTOMOUSKEY_EXTENSION ADD CONSTRAINT PUBLIC.FKAE34C1D8927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
5981 6133
ALTER TABLE PUBLIC.STATEDATA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK93FFD2ADF05D08D4 FOREIGN KEY(MODIFYINGTEXT_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5982
ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKB6734E3934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6134
ALTER TABLE PUBLIC.TAXONNAME_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKB6734E3934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5983 6135
ALTER TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION ADD CONSTRAINT PUBLIC.FK397EF986C0DB4934 FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
5984 6136
ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK579A1DC02BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
5985 6137
ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXON ADD CONSTRAINT PUBLIC.FK8DA4E8E3DE9A3E39 FOREIGN KEY(TAXON_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
5986 6138
ALTER TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK1093B7C134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5987 6139
ALTER TABLE PUBLIC.TAXONNODE_MARKER_AUD ADD CONSTRAINT PUBLIC.FK77D9D37E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5988 6140
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD ADD CONSTRAINT PUBLIC.FKF5DE434C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5989
ALTER TABLE PUBLIC.TAXONNAMEBASE_AUD ADD CONSTRAINT PUBLIC.FK5CA2CB9734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6141
ALTER TABLE PUBLIC.TAXONNAME_AUD ADD CONSTRAINT PUBLIC.FK5CA2CB9734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
5990 6142
ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.FK4CEED9F847C496CB FOREIGN KEY(FEATURETREE_ID) REFERENCES PUBLIC.FEATURETREE(ID) NOCHECK;
5991 6143
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAEBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
5992 6144
ALTER TABLE PUBLIC.MEDIAREPRESENTATION ADD CONSTRAINT PUBLIC.FK1966BDB14FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
5999 6151
ALTER TABLE PUBLIC.TAXONNODE ADD CONSTRAINT PUBLIC.FK924F5BCC4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6000 6152
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKA4B9E0A434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6001 6153
ALTER TABLE PUBLIC.CLASSIFICATION ADD CONSTRAINT PUBLIC.FKDB1100064FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6002
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK5D248B8434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6154
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK5D248B8434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6003 6155
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKD58E791834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6004 6156
ALTER TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT ADD CONSTRAINT PUBLIC.FK45F60AFB3927C853 FOREIGN KEY(CONTINENTS_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6005 6157
ALTER TABLE PUBLIC.MEDIA_REPRESENTATION ADD CONSTRAINT PUBLIC.FK1B8712C8BE59D760 FOREIGN KEY(MEDIAKEY_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
6006 6158
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA3272DADF76EA FOREIGN KEY(PRIMARYCOLLECTOR_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6007
ALTER TABLE PUBLIC.TAXONNAMEBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK9E7794681E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6159
ALTER TABLE PUBLIC.TAXONNAME_ANNOTATION ADD CONSTRAINT PUBLIC.FK9E7794681E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6008 6160
ALTER TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD ADD CONSTRAINT PUBLIC.FK76253F8A34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6009 6161
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE76714220AFEB FOREIGN KEY(FEATURE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6010 6162
ALTER TABLE PUBLIC.REFERENCE ADD CONSTRAINT PUBLIC.FK404D5F2BBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6011 6163
ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA_AUD ADD CONSTRAINT PUBLIC.FK750A135034869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6012 6164
ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FK731CC81FBBD2C869 FOREIGN KEY(WORKINGSETS_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6013
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER_AUD ADD CONSTRAINT PUBLIC.FK3DA7BE4434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6165
ALTER TABLE PUBLIC.TAXONNAME_MARKER_AUD ADD CONSTRAINT PUBLIC.FK3DA7BE4434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6014 6166
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE_AUD ADD CONSTRAINT PUBLIC.FKBB16686134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6015 6167
ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02F11BD77B FOREIGN KEY(TYPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6016 6168
ALTER TABLE PUBLIC.CREDIT_AUD ADD CONSTRAINT PUBLIC.FK5533906A34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6025 6177
ALTER TABLE PUBLIC.TAXONBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK41ED09739C9D39 FOREIGN KEY(TAXONBASE_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
6026 6178
ALTER TABLE PUBLIC.TERMVOCABULARY_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK8F2D512A3A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
6027 6179
ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5FDC9A9BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6028
ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FKC0D6BBB5C7DF530C FOREIGN KEY(TYPEDESIGNATIONS_ID) REFERENCES PUBLIC.TYPEDESIGNATIONBASE(ID) NOCHECK;
6180
ALTER TABLE PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FKC0D6BBB5C7DF530C FOREIGN KEY(TYPEDESIGNATIONS_ID) REFERENCES PUBLIC.TYPEDESIGNATIONBASE(ID) NOCHECK;
6029 6181
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775A808998FB FOREIGN KEY(PARENT_ID) REFERENCES PUBLIC.POLYTOMOUSKEYNODE(ID) NOCHECK;
6030 6182
ALTER TABLE PUBLIC.ANNOTATION ADD CONSTRAINT PUBLIC.FK1A21C74F4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6031
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6B14B73EF FOREIGN KEY(COMBINATIONAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6183
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C6B14B73EF FOREIGN KEY(COMBINATIONAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6032 6184
ALTER TABLE PUBLIC.NAMERELATIONSHIP_MARKER_AUD ADD CONSTRAINT PUBLIC.FKCD68D66734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6033 6185
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE7671BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6034 6186
ALTER TABLE PUBLIC.INSTITUTIONALMEMBERSHIP ADD CONSTRAINT PUBLIC.FK3C8E1FF9BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
6040 6192
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER ADD CONSTRAINT PUBLIC.FK7B49CF26777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6041 6193
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_AUD ADD CONSTRAINT PUBLIC.FKE4252DE934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6042 6194
ALTER TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY ADD CONSTRAINT PUBLIC.FKCAF43931603B036 FOREIGN KEY(COUNTRIES_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6043
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.FK9033CE74AF4F9F62 FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6195
ALTER TABLE PUBLIC.HYBRIDRELATIONSHIP ADD CONSTRAINT PUBLIC.FK9033CE74AF4F9F62 FOREIGN KEY(RELATEDTO_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6044 6196
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775A9D3C2E93 FOREIGN KEY(QUESTION_ID) REFERENCES PUBLIC.KEYSTATEMENT(ID) NOCHECK;
6045 6197
ALTER TABLE PUBLIC.DESCRIPTIONBASE_FEATURE_AUD ADD CONSTRAINT PUBLIC.FKA4D7D13534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6046 6198
ALTER TABLE PUBLIC.POLYTOMOUSKEY_ANNOTATION ADD CONSTRAINT PUBLIC.FK278CF8B689D97CB FOREIGN KEY(POLYTOMOUSKEY_ID) REFERENCES PUBLIC.POLYTOMOUSKEY(ID) NOCHECK;
......
6089 6241
ALTER TABLE PUBLIC.POLYTOMOUSKEY_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK23F76ADEC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
6090 6242
ALTER TABLE PUBLIC.KEYSTATEMENT_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.FKE203E1A934869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6091 6243
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FKB914A10B777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6092
ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49B8492378F FOREIGN KEY(NAME_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6244
ALTER TABLE PUBLIC.TAXONBASE ADD CONSTRAINT PUBLIC.FK9249B49B8492378F FOREIGN KEY(NAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6093 6245
ALTER TABLE PUBLIC.TAXONINTERACTION_LANGUAGESTRING_AUD ADD CONSTRAINT PUBLIC.FK9E016B9134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6094 6246
ALTER TABLE PUBLIC.WORKINGSET_MARKER ADD CONSTRAINT PUBLIC.FK9CB22CC8BBD2C869 FOREIGN KEY(WORKINGSET_ID) REFERENCES PUBLIC.WORKINGSET(ID) NOCHECK;
6095 6247
ALTER TABLE PUBLIC.AGENTBASE_MEDIA ADD CONSTRAINT PUBLIC.FKE8FC5D9B86EFC5D4 FOREIGN KEY(AGENTBASE_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
......
6099 6251
ALTER TABLE PUBLIC.GATHERINGEVENT_MARKER_AUD ADD CONSTRAINT PUBLIC.FK160DF9F734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6100 6252
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_MARKER ADD CONSTRAINT PUBLIC.FK8E6106C73B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
6101 6253
ALTER TABLE PUBLIC.AGENTBASE_ANNOTATION ADD CONSTRAINT PUBLIC.FK44D5F7D81E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6102
ALTER TABLE PUBLIC.TAXONNAMEBASE_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F38C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6254
ALTER TABLE PUBLIC.TAXONNAME_MARKER ADD CONSTRAINT PUBLIC.FK39E3C1F38C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6103 6255
ALTER TABLE PUBLIC.POLYTOMOUSKEY_TAXON_AUD ADD CONSTRAINT PUBLIC.FKED9BED3434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6104 6256
ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION ADD CONSTRAINT PUBLIC.FKB74F03F76BE0BFDA FOREIGN KEY(DETERMINATIONEVENT_ID) REFERENCES PUBLIC.DETERMINATIONEVENT(ID) NOCHECK;
6105 6257
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK2059F21B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6162 6314
ALTER TABLE PUBLIC.DETERMINATIONEVENT_REFERENCE_AUD ADD CONSTRAINT PUBLIC.FK6255A1D434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6163 6315
ALTER TABLE PUBLIC.DESCRIPTIONBASE_AUD ADD CONSTRAINT PUBLIC.FK7456581E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6164 6316
ALTER TABLE PUBLIC.AGENTBASE ADD CONSTRAINT PUBLIC.FK1205D356BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6165
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.FK9215BC6334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6317
ALTER TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS_AUD ADD CONSTRAINT PUBLIC.FK9215BC6334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6166 6318
ALTER TABLE PUBLIC.EXTENSION ADD CONSTRAINT PUBLIC.FK52EF3C1FBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6167 6319
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE76716561D9B1 FOREIGN KEY(ASSOCIATEDSPECIMENOROBSERVATION_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
6168 6320
ALTER TABLE PUBLIC.POLYTOMOUSKEY_MARKER_AUD ADD CONSTRAINT PUBLIC.FKC6BD229234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6192 6344
ALTER TABLE PUBLIC.WORKINGSET_DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FK731CC81F33B8A841 FOREIGN KEY(DESCRIPTIONS_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;
6193 6345
ALTER TABLE PUBLIC.DETERMINATIONEVENT_MARKER ADD CONSTRAINT PUBLIC.FK5C475102777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6194 6346
ALTER TABLE PUBLIC.FEATURETREE_AUD ADD CONSTRAINT PUBLIC.FK355BE36534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6195
ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FKA981956134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6347
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FKA981956134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6196 6348
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE ADD CONSTRAINT PUBLIC.FK38FE76711C3C3FF7 FOREIGN KEY(AREA_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6197 6349
ALTER TABLE PUBLIC.SEQUENCE_REFERENCE ADD CONSTRAINT PUBLIC.FK6944904D1DDDC219 FOREIGN KEY(CITATIONS_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6198 6350
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.FK1FFEC88B4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
6208 6360
ALTER TABLE PUBLIC.MEDIAKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.FK63AD1EC134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6209 6361
ALTER TABLE PUBLIC.COLLECTION_ANNOTATION ADD CONSTRAINT PUBLIC.FKEA970F70EB62BE9A FOREIGN KEY(COLLECTION_ID) REFERENCES PUBLIC.COLLECTION(ID) NOCHECK;
6210 6362
ALTER TABLE PUBLIC.DETERMINATIONEVENT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FKAFDA5E4834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6211
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.FK98592F33473FB677 FOREIGN KEY(INVERSEREPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
6363
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.FK98592F33473FB677 FOREIGN KEY(INVERSEREPRESENTATIONS_ID) REFERENCES PUBLIC.REPRESENTATION(ID) NOCHECK;
6212 6364
ALTER TABLE PUBLIC.RIGHTSINFO_MARKER ADD CONSTRAINT PUBLIC.FKB739BBA2777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6213 6365
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAEAEB7F3BE FOREIGN KEY(CITATION_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6214 6366
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.FK4CF19F944FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
6230 6382
ALTER TABLE PUBLIC.GATHERINGEVENT ADD CONSTRAINT PUBLIC.FK6F1286F3BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6231 6383
ALTER TABLE PUBLIC.DESCRIPTIONBASE_SCOPE ADD CONSTRAINT PUBLIC.FKB9257C42D86445CE FOREIGN KEY(TAXONDESCRIPTION_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;
6232 6384
ALTER TABLE PUBLIC.MEDIA_ANNOTATION ADD CONSTRAINT PUBLIC.FKA020DAAA1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6233
ALTER TABLE PUBLIC.TAXONNAMEBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK42D7AF90C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
6385
ALTER TABLE PUBLIC.TAXONNAME_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK42D7AF90C13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;
6234 6386
ALTER TABLE PUBLIC.WORKINGSET_ANNOTATION ADD CONSTRAINT PUBLIC.FKCBBA8CBD1E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6235 6387
ALTER TABLE PUBLIC.FEATURENODE ADD CONSTRAINT PUBLIC.FK4CEED9F84FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6236 6388
--ALTER TABLE PUBLIC.SEQUENCE_CREDIT ADD CONSTRAINT PUBLIC.FK2CFBC93732D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
......
6241 6393
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK9C979F3C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6242 6394
ALTER TABLE PUBLIC.REFERENCE_AUD ADD CONSTRAINT PUBLIC.FK8F0FFF7C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6243 6395
ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK91B37B363A6735D9 FOREIGN KEY(SOURCES_ID) REFERENCES PUBLIC.ORIGINALSOURCEBASE(ID) NOCHECK;
6244
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA32727CC340C5 FOREIGN KEY(STOREDUNDER_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6396
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA32727CC340C5 FOREIGN KEY(STOREDUNDER_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6245 6397
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE ADD CONSTRAINT PUBLIC.FK860775A1C0483C4 FOREIGN KEY(SUBKEY_ID) REFERENCES PUBLIC.POLYTOMOUSKEY(ID) NOCHECK;
6246 6398
ALTER TABLE PUBLIC.NOMENCLATURALSTATUS_MARKER ADD CONSTRAINT PUBLIC.FK2F5128E777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6247 6399
ALTER TABLE PUBLIC.STATEDATA_DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK107321E28E7BF9AB FOREIGN KEY(STATEDATA_ID) REFERENCES PUBLIC.STATEDATA(ID) NOCHECK;
......
6267 6419
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MARKER ADD CONSTRAINT PUBLIC.FK89261453777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6268 6420
ALTER TABLE PUBLIC.STATEDATA ADD CONSTRAINT PUBLIC.FKFB1697BB682A4E4B FOREIGN KEY(STATE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6269 6421
ALTER TABLE PUBLIC.MEDIA_DESCRIPTION ADD CONSTRAINT PUBLIC.FK368283E1C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
6270
ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CDDA935185 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6422
ALTER TABLE PUBLIC.DESCRIPTIONBASE ADD CONSTRAINT PUBLIC.FKFF4D58CDDA935185 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6271 6423
ALTER TABLE PUBLIC.CDMMETADATA ADD CONSTRAINT PUBLIC.FK6EA78F7B4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6272 6424
ALTER TABLE PUBLIC.ANNOTATION_MARKER ADD CONSTRAINT PUBLIC.FKB17EAF4A777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6273 6425
ALTER TABLE PUBLIC.LOCUS ADD CONSTRAINT PUBLIC.FK462F1BEBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
......
6276 6428
ALTER TABLE PUBLIC.MARKER_AUD ADD CONSTRAINT PUBLIC.FKB951F12B34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6277 6429
ALTER TABLE PUBLIC.TAXONNODE_MARKER ADD CONSTRAINT PUBLIC.FK395842D777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6278 6430
ALTER TABLE PUBLIC.STATISTICALMEASUREMENTVALUE ADD CONSTRAINT PUBLIC.FK2DCE02904FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6279
ALTER TABLE PUBLIC.RELATIONSHIPTERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.FK98592F33ECEEF4AF FOREIGN KEY(RELATIONSHIPTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6431
ALTER TABLE PUBLIC.TERMBASE_INVERSEREPRESENTATION ADD CONSTRAINT PUBLIC.FK98592F33ECEEF4AF FOREIGN KEY(TERM_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6280 6432
ALTER TABLE PUBLIC.DESCRIPTIONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK6A2601A9F1DDBFAB FOREIGN KEY(DESCRIPTIONBASE_ID) REFERENCES PUBLIC.DESCRIPTIONBASE(ID) NOCHECK;
6281 6433
ALTER TABLE PUBLIC.REPRESENTATION ADD CONSTRAINT PUBLIC.FK9C4724EDE8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6282 6434
ALTER TABLE PUBLIC.TAXONRELATIONSHIP ADD CONSTRAINT PUBLIC.FK7482BA02E71EF6CE FOREIGN KEY(RELATEDFROM_ID) REFERENCES PUBLIC.TAXONBASE(ID) NOCHECK;
6283 6435
ALTER TABLE PUBLIC.RIGHTSINFO ADD CONSTRAINT PUBLIC.FK91E56DF74FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6284
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK505F2E5D966B96B2 FOREIGN KEY(NAMEUSEDINSOURCE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6436
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK505F2E5D966B96B2 FOREIGN KEY(NAMEUSEDINSOURCE_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6285 6437
ALTER TABLE PUBLIC.POLYTOMOUSKEY_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK629EC1D134869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6286 6438
ALTER TABLE PUBLIC.WORKINGSET_REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK21B88BAC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6287 6439
ALTER TABLE PUBLIC.POLYTOMOUSKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.FK1C727CFF3FF8E7B2 FOREIGN KEY(GEOGRAPHICALSCOPE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
......
6294 6446
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKCFAA9316CD55E0D6 FOREIGN KEY(DEFINITION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
6295 6447
ALTER TABLE PUBLIC.TERMVOCABULARY ADD CONSTRAINT PUBLIC.FK487AA6924FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6296 6448
ALTER TABLE PUBLIC.COLLECTION_CREDIT ADD CONSTRAINT PUBLIC.FKE0A317BA32D1B9F FOREIGN KEY(CREDITS_ID) REFERENCES PUBLIC.CREDIT(ID) NOCHECK;
6297
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6617E62B3 FOREIGN KEY(NOMENCLATURALREFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6449
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C6617E62B3 FOREIGN KEY(NOMENCLATURALREFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6298 6450
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK9754F4643B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
6299 6451
ALTER TABLE PUBLIC.MEDIA_DESCRIPTION ADD CONSTRAINT PUBLIC.FK368283E12BEBA58D FOREIGN KEY(DESCRIPTION_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
6300 6452
ALTER TABLE PUBLIC.COLLECTION_AUD ADD CONSTRAINT PUBLIC.FKD6D4298F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6307 6459
ALTER TABLE PUBLIC.HOMOTYPICALGROUP_ANNOTATION ADD CONSTRAINT PUBLIC.FK7A0351D61E403E0B FOREIGN KEY(ANNOTATIONS_ID) REFERENCES PUBLIC.ANNOTATION(ID) NOCHECK;
6308 6460
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAE4FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6309 6461
ALTER TABLE PUBLIC.DEFINEDTERMBASE_MEDIA ADD CONSTRAINT PUBLIC.FK6FC908ABC0DB4934 FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6310
ALTER TABLE PUBLIC.TAXONNAMEBASE_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FKC0D6BBB58C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6462
ALTER TABLE PUBLIC.TAXONNAME_TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FKC0D6BBB58C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6311 6463
ALTER TABLE PUBLIC.AGENTBASE ADD CONSTRAINT PUBLIC.FK1205D3564FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6312 6464
ALTER TABLE PUBLIC.MEDIAKEY_TAXONSCOPE_AUD ADD CONSTRAINT PUBLIC.FK311443734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6313 6465
ALTER TABLE PUBLIC.DESCRIPTIONELEMENTBASE_MEDIA ADD CONSTRAINT PUBLIC.FK21F70076C2C29593 FOREIGN KEY(MEDIA_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
6314 6466
ALTER TABLE PUBLIC.TAXONBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK7CFED28E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6315
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C64FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6467
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C64FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6316 6468
ALTER TABLE PUBLIC.MULTIACCESSKEY_TAXONSCOPE_AUD ADD CONSTRAINT PUBLIC.FKF083E4BE34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6317 6469
ALTER TABLE PUBLIC.SEQUENCE_ANNOTATION ADD CONSTRAINT PUBLIC.FK1010BA6DD57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
6318 6470
ALTER TABLE PUBLIC.REFERENCE_RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK1AD225DC34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6344 6496
ALTER TABLE PUBLIC.SEQUENCE ADD CONSTRAINT PUBLIC.FK544ADBE1BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6345 6497
ALTER TABLE PUBLIC.USERACCOUNT_GRANTEDAUTHORITYIMPL ADD CONSTRAINT PUBLIC.FKFD724D855EA5DD89 FOREIGN KEY(USER_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6346 6498
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE_AUD ADD CONSTRAINT PUBLIC.FK243C037F34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6347
ALTER TABLE PUBLIC.TAXONNAMEBASE_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.FK560BA7928C85CF94 FOREIGN KEY(TAXONNAMEBASE_ID) REFERENCES PUBLIC.TAXONNAMEBASE(ID) NOCHECK;
6499
ALTER TABLE PUBLIC.TAXONNAME_NOMENCLATURALSTATUS ADD CONSTRAINT PUBLIC.FK560BA7928C85CF94 FOREIGN KEY(TAXONNAME_ID) REFERENCES PUBLIC.TAXONNAME(ID) NOCHECK;
6348 6500
ALTER TABLE PUBLIC.GATHERINGEVENT_DEFINEDTERMBASE_AUD ADD CONSTRAINT PUBLIC.FKB3BBB1EB34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6349 6501
ALTER TABLE PUBLIC.RIGHTSINFO_AUD ADD CONSTRAINT PUBLIC.FK252BC84834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6350 6502
ALTER TABLE PUBLIC.LANGUAGESTRING ADD CONSTRAINT PUBLIC.FKB5FDC9A9E8D36B00 FOREIGN KEY(LANGUAGE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
......
6353 6505
ALTER TABLE PUBLIC.CLASSIFICATION_MARKER_AUD ADD CONSTRAINT PUBLIC.FK68A9270434869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6354 6506
ALTER TABLE PUBLIC.MULTIACCESSKEY_SCOPE_AUD ADD CONSTRAINT PUBLIC.FK511FBF4834869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6355 6507
ALTER TABLE PUBLIC.DEFINEDTERMBASE ADD CONSTRAINT PUBLIC.FK2E340A66CC0240B6 FOREIGN KEY(SHAPE_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
6356
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6508
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C6BC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6357 6509
ALTER TABLE PUBLIC.TERMVOCABULARY_MARKER ADD CONSTRAINT PUBLIC.FK862BAEA7777265A1 FOREIGN KEY(MARKERS_ID) REFERENCES PUBLIC.MARKER(ID) NOCHECK;
6358 6510
ALTER TABLE PUBLIC.SEQUENCE_AUD ADD CONSTRAINT PUBLIC.FK39F4313234869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6359 6511
ALTER TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK79E7827E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6365 6517
ALTER TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION ADD CONSTRAINT PUBLIC.FKAAC8AFE6C0DB4934 FOREIGN KEY(DEFINEDTERMBASE_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6366 6518
ALTER TABLE PUBLIC.NAMERELATIONSHIP ADD CONSTRAINT PUBLIC.FK5E510834FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6367 6519
ALTER TABLE PUBLIC.AGENTBASE_ADDRESS_AUD ADD CONSTRAINT PUBLIC.FK3D28383C34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6368
ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK8F98B2B734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6520
ALTER TABLE PUBLIC.TAXONNAME_EXTENSION_AUD ADD CONSTRAINT PUBLIC.FK8F98B2B734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6369 6521
--ALTER TABLE PUBLIC.SEQUENCE_EXTENSION ADD CONSTRAINT PUBLIC.FK7BE66D41D57FFDD5 FOREIGN KEY(SEQUENCE_ID) REFERENCES PUBLIC.SEQUENCE(ID) NOCHECK;
6370 6522
ALTER TABLE PUBLIC.FEATURETREE ADD CONSTRAINT PUBLIC.FK4CF19F94B7892921 FOREIGN KEY(ROOT_ID) REFERENCES PUBLIC.FEATURENODE(ID) NOCHECK;
6371 6523
ALTER TABLE PUBLIC.POLYTOMOUSKEYNODE_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK5574E12EF05D08D4 FOREIGN KEY(MODIFYINGTEXT_ID) REFERENCES PUBLIC.LANGUAGESTRING(ID) NOCHECK;
......
6388 6540
ALTER TABLE PUBLIC.ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK505F2E5DBC5DA539 FOREIGN KEY(UPDATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6389 6541
ALTER TABLE PUBLIC.AGENTBASE_CREDIT_AUD ADD CONSTRAINT PUBLIC.FK7FE7C0F334869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6390 6542
ALTER TABLE PUBLIC.CREDIT_ANNOTATION_AUD ADD CONSTRAINT PUBLIC.FK1DEB578634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6391
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;
6543
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C6BFEAE500 FOREIGN KEY(HOMOTYPICALGROUP_ID) REFERENCES PUBLIC.HOMOTYPICALGROUP(ID) NOCHECK;
6392 6544
ALTER TABLE PUBLIC.AGENTBASE_CONTACT_URLS_AUD ADD CONSTRAINT PUBLIC.FK1CE69BBD34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6393 6545
ALTER TABLE PUBLIC.REFERENCE_ANNOTATION ADD CONSTRAINT PUBLIC.FKFC824E38D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6394 6546
ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK48A31E0734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
......
6403 6555
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE ADD CONSTRAINT PUBLIC.FK21CA3272E17C9A6B FOREIGN KEY(SEX_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6404 6556
ALTER TABLE PUBLIC.REPRESENTATION_AUD ADD CONSTRAINT PUBLIC.FK294D143E34869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6405 6557
ALTER TABLE PUBLIC.USERACCOUNT ADD CONSTRAINT PUBLIC.FKB3F13C24FF2DB2C FOREIGN KEY(CREATEDBY_ID) REFERENCES PUBLIC.USERACCOUNT(ID) NOCHECK;
6406
ALTER TABLE PUBLIC.TAXONNAMEBASE_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK7A38D54734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6407
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C62B4FEDD6 FOREIGN KEY(BASIONYMAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6408
ALTER TABLE PUBLIC.TAXONNAMEBASE ADD CONSTRAINT PUBLIC.FKB4870C6D7BE55A0 FOREIGN KEY(RANK_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6558
ALTER TABLE PUBLIC.TAXONNAME_ORIGINALSOURCEBASE_AUD ADD CONSTRAINT PUBLIC.FK7A38D54734869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6559
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C62B4FEDD6 FOREIGN KEY(BASIONYMAUTHORSHIP_ID) REFERENCES PUBLIC.AGENTBASE(ID) NOCHECK;
6560
ALTER TABLE PUBLIC.TAXONNAME ADD CONSTRAINT PUBLIC.FKB4870C6D7BE55A0 FOREIGN KEY(RANK_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6409 6561
ALTER TABLE PUBLIC.SPECIMENOROBSERVATIONBASE_CREDIT ADD CONSTRAINT PUBLIC.FK7E3A1D863B8A5ABA FOREIGN KEY(SPECIMENOROBSERVATIONBASE_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
6410 6562
ALTER TABLE PUBLIC.ADDRESS_AUD ADD CONSTRAINT PUBLIC.FK115657A534869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6411 6563
ALTER TABLE PUBLIC.TYPEDESIGNATIONBASE ADD CONSTRAINT PUBLIC.FK8AC9DCAE94DB044A FOREIGN KEY(TYPESPECIMEN_ID) REFERENCES PUBLIC.SPECIMENOROBSERVATIONBASE(ID) NOCHECK;
......
6434 6586
ALTER TABLE PUBLIC.REFERENCE_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FKD3E8B7F18D0FB4DA FOREIGN KEY(REFERENCE_ID) REFERENCES PUBLIC.REFERENCE(ID) NOCHECK;
6435 6587
ALTER TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE ADD CONSTRAINT PUBLIC.FK91B37B3684A3CE1B FOREIGN KEY(CLASSIFICATION_ID) REFERENCES PUBLIC.CLASSIFICATION(ID) NOCHECK;
6436 6588
ALTER TABLE PUBLIC.FEATURETREE_MARKER_AUD ADD CONSTRAINT PUBLIC.FKA508E2B634869AAE FOREIGN KEY(REV) REFERENCES PUBLIC.AUDITEVENT(REVISIONNUMBER) NOCHECK;
6437
ALTER TABLE PUBLIC.TAXONNAMEBASE_EXTENSION ADD CONSTRAINT PUBLIC.FKC28EE7E6927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
6589
ALTER TABLE PUBLIC.TAXONNAME_EXTENSION ADD CONSTRAINT PUBLIC.FKC28EE7E6927DE9DF FOREIGN KEY(EXTENSIONS_ID) REFERENCES PUBLIC.EXTENSION(ID) NOCHECK;
6438 6590
ALTER TABLE PUBLIC.MEDIAKEY_NAMEDAREA ADD CONSTRAINT PUBLIC.FK31E7D402BE59D760 FOREIGN KEY(MEDIAKEY_ID) REFERENCES PUBLIC.MEDIA(ID) NOCHECK;
6439 6591
ALTER TABLE PUBLIC.MEDIA_LANGUAGESTRING ADD CONSTRAINT PUBLIC.FK353DB784A0A6EDCE FOREIGN KEY(TITLE_MAPKEY_ID) REFERENCES PUBLIC.DEFINEDTERMBASE(ID) NOCHECK;
6440 6592
ALTER TABLE PUBLIC.REFERENCE_RIGHTSINFO ADD CONSTRAINT PUBLIC.FK74E1B58BC13F7B21 FOREIGN KEY(RIGHTS_ID) REFERENCES PUBLIC.RIGHTSINFO(ID) NOCHECK;

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)