cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl

   1
   2     create table Address (
   3         id integer not null,
   4         created timestamp,
   5         uuid varchar(36),
   6         updated timestamp,
   7         locality varchar(255),
   8         location_errorradius integer,
   9         location_latitude double,
  10         location_longitude double,
  11         pobox varchar(255),
  12         postcode varchar(255),
  13         region varchar(255),
  14         street varchar(255),
  15         createdby_id integer,
  16         updatedby_id integer,
  17         country_id integer,
  18         location_referencesystem_id integer,
  19         primary key (id),
  20         unique (uuid)
  21     );
  22
  23     create table Address_AUD (
  24         id integer not null,
  25         REV integer not null,
  26         revtype tinyint,
  27         created timestamp,
  28         uuid varchar(36),
  29         updated timestamp,
  30         locality varchar(255),
  31         location_errorradius integer,
  32         location_latitude double,
  33         location_longitude double,
  34         pobox varchar(255),
  35         postcode varchar(255),
  36         region varchar(255),
  37         street varchar(255),
  38         createdby_id integer,
  39         updatedby_id integer,
  40         country_id integer,
  41         location_referencesystem_id integer,
  42         primary key (id, REV)
  43     );
  44
  45     create table AgentBase (
  46         DTYPE varchar(31) not null,
  47         id integer not null,
  48         created timestamp,
  49         uuid varchar(36),
  50         updated timestamp,
  51         lsid_authority varchar(255),
  52         lsid_lsid varchar(255),
  53         lsid_namespace varchar(255),
  54         lsid_object varchar(255),
  55         lsid_revision varchar(255),
  56         protectedtitlecache bit not null,
  57         titleCache varchar(255),
  58         code varchar(255),
  59         name varchar(255),
  60         nomenclaturaltitle varchar(255),
  61         firstname varchar(255),
  62         lastname varchar(255),
  63         lifespan_end varchar(255),
  64         lifespan_freetext varchar(255),
  65         lifespan_start varchar(255),
  66         prefix varchar(255),
  67         suffix varchar(255),
  68         protectednomenclaturaltitlecache bit,
  69         createdby_id integer,
  70         updatedby_id integer,
  71         ispartof_id integer,
  72         primary key (id),
  73         unique (uuid)
  74     );
  75
  76     create table AgentBase_AUD (
  77         DTYPE varchar(31) not null,
  78         id integer not null,
  79         REV integer not null,
  80         revtype tinyint,
  81         created timestamp,
  82         uuid varchar(36),
  83         updated timestamp,
  84         lsid_authority varchar(255),
  85         lsid_lsid varchar(255),
  86         lsid_namespace varchar(255),
  87         lsid_object varchar(255),
  88         lsid_revision varchar(255),
  89         protectedtitlecache bit,
  90         titleCache varchar(255),
  91         createdby_id integer,
  92         updatedby_id integer,
  93         code varchar(255),
  94         name varchar(255),
  95         ispartof_id integer,
  96         nomenclaturaltitle varchar(255),
  97         firstname varchar(255),
  98         lastname varchar(255),
  99         lifespan_end varchar(255),
 100         lifespan_freetext varchar(255),
 101         lifespan_start varchar(255),
 102         prefix varchar(255),
 103         suffix varchar(255),
 104         protectednomenclaturaltitlecache bit,
 105         primary key (id, REV)
 106     );
 107
 108     create table AgentBase_Address (
 109         AgentBase_id integer not null,
 110         contact_addresses_id integer not null,
 111         primary key (AgentBase_id, contact_addresses_id),
 112         unique (contact_addresses_id)
 113     );
 114
 115     create table AgentBase_Address_AUD (
 116         REV integer not null,
 117         AgentBase_id integer not null,
 118         contact_addresses_id integer not null,
 119         revtype tinyint,
 120         primary key (REV, AgentBase_id, contact_addresses_id)
 121     );
 122
 123     create table AgentBase_AgentBase (
 124         AgentBase_id integer not null,
 125         teammembers_id integer not null,
 126         sortIndex integer not null,
 127         primary key (AgentBase_id, sortIndex)
 128     );
 129
 130     create table AgentBase_AgentBase_AUD (
 131         REV integer not null,
 132         AgentBase_id integer not null,
 133         teammembers_id integer not null,
 134         sortIndex integer not null,
 135         revtype tinyint,
 136         primary key (REV, AgentBase_id, teammembers_id, sortIndex)
 137     );
 138
 139     create table AgentBase_Annotation (
 140         AgentBase_id integer not null,
 141         annotations_id integer not null,
 142         primary key (AgentBase_id, annotations_id),
 143         unique (annotations_id)
 144     );
 145
 146     create table AgentBase_Annotation_AUD (
 147         REV integer not null,
 148         AgentBase_id integer not null,
 149         annotations_id integer not null,
 150         revtype tinyint,
 151         primary key (REV, AgentBase_id, annotations_id)
 152     );
 153
 154     create table AgentBase_Credit (
 155         AgentBase_id integer not null,
 156         credits_id integer not null,
 157         sortIndex integer not null,
 158         primary key (AgentBase_id, sortIndex),
 159         unique (credits_id)
 160     );
 161
 162     create table AgentBase_Credit_AUD (
 163         REV integer not null,
 164         AgentBase_id integer not null,
 165         credits_id integer not null,
 166         sortIndex integer not null,
 167         revtype tinyint,
 168         primary key (REV, AgentBase_id, credits_id, sortIndex)
 169     );
 170
 171     create table AgentBase_DefinedTermBase (
 172         AgentBase_id integer not null,
 173         types_id integer not null,
 174         primary key (AgentBase_id, types_id)
 175     );
 176
 177     create table AgentBase_DefinedTermBase_AUD (
 178         REV integer not null,
 179         AgentBase_id integer not null,
 180         types_id integer not null,
 181         revtype tinyint,
 182         primary key (REV, AgentBase_id, types_id)
 183     );
 184
 185     create table AgentBase_Extension (
 186         AgentBase_id integer not null,
 187         extensions_id integer not null,
 188         primary key (AgentBase_id, extensions_id),
 189         unique (extensions_id)
 190     );
 191
 192     create table AgentBase_Extension_AUD (
 193         REV integer not null,
 194         AgentBase_id integer not null,
 195         extensions_id integer not null,
 196         revtype tinyint,
 197         primary key (REV, AgentBase_id, extensions_id)
 198     );
 199
 200     create table AgentBase_Marker (
 201         AgentBase_id integer not null,
 202         markers_id integer not null,
 203         primary key (AgentBase_id, markers_id),
 204         unique (markers_id)
 205     );
 206
 207     create table AgentBase_Marker_AUD (
 208         REV integer not null,
 209         AgentBase_id integer not null,
 210         markers_id integer not null,
 211         revtype tinyint,
 212         primary key (REV, AgentBase_id, markers_id)
 213     );
 214
 215     create table AgentBase_Media (
 216         AgentBase_id integer not null,
 217         media_id integer not null,
 218         primary key (AgentBase_id, media_id)
 219     );
 220
 221     create table AgentBase_Media_AUD (
 222         REV integer not null,
 223         AgentBase_id integer not null,
 224         media_id integer not null,
 225         revtype tinyint,
 226         primary key (REV, AgentBase_id, media_id)
 227     );
 228
 229     create table AgentBase_OriginalSourceBase (
 230         AgentBase_id integer not null,
 231         sources_id integer not null,
 232         primary key (AgentBase_id, sources_id),
 233         unique (sources_id)
 234     );
 235
 236     create table AgentBase_OriginalSourceBase_AUD (
 237         REV integer not null,
 238         AgentBase_id integer not null,
 239         sources_id integer not null,
 240         revtype tinyint,
 241         primary key (REV, AgentBase_id, sources_id)
 242     );
 243
 244     create table AgentBase_Rights (
 245         AgentBase_id integer not null,
 246         rights_id integer not null,
 247         primary key (AgentBase_id, rights_id),
 248         unique (rights_id)
 249     );
 250
 251     create table AgentBase_Rights_AUD (
 252         REV integer not null,
 253         AgentBase_id integer not null,
 254         rights_id integer not null,
 255         revtype tinyint,
 256         primary key (REV, AgentBase_id, rights_id)
 257     );
 258
 259     create table AgentBase_contact_emailaddresses (
 260         AgentBase_id integer not null,
 261         contact_emailaddresses_element varchar(255)
 262     );
 263
 264     create table AgentBase_contact_emailaddresses_AUD (
 265         REV integer not null,
 266         AgentBase_id integer not null,
 267         contact_emailaddresses_element varchar(255) not null,
 268         revtype tinyint,
 269         primary key (REV, AgentBase_id, contact_emailaddresses_element)
 270     );
 271
 272     create table AgentBase_contact_faxnumbers (
 273         AgentBase_id integer not null,
 274         contact_faxnumbers_element varchar(255)
 275     );
 276
 277     create table AgentBase_contact_faxnumbers_AUD (
 278         REV integer not null,
 279         AgentBase_id integer not null,
 280         contact_faxnumbers_element varchar(255) not null,
 281         revtype tinyint,
 282         primary key (REV, AgentBase_id, contact_faxnumbers_element)
 283     );
 284
 285     create table AgentBase_contact_phonenumbers (
 286         AgentBase_id integer not null,
 287         contact_phonenumbers_element varchar(255)
 288     );
 289
 290     create table AgentBase_contact_phonenumbers_AUD (
 291         REV integer not null,
 292         AgentBase_id integer not null,
 293         contact_phonenumbers_element varchar(255) not null,
 294         revtype tinyint,
 295         primary key (REV, AgentBase_id, contact_phonenumbers_element)
 296     );
 297
 298     create table AgentBase_contact_urls (
 299         AgentBase_id integer not null,
 300         contact_urls_element varchar(255)
 301     );
 302
 303     create table AgentBase_contact_urls_AUD (
 304         REV integer not null,
 305         AgentBase_id integer not null,
 306         contact_urls_element varchar(255) not null,
 307         revtype tinyint,
 308         primary key (REV, AgentBase_id, contact_urls_element)
 309     );
 310
 311     create table Annotation (
 312         id integer not null,
 313         created timestamp,
 314         uuid varchar(36),
 315         updated timestamp,
 316         text longvarchar,
 317         annotatedObj_type varchar(255),
 318         annotatedObj_id integer not null,
 319         linkbackurl varbinary(255),
 320         createdby_id integer,
 321         updatedby_id integer,
 322         language_id integer,
 323         annotationtype_id integer,
 324         commentator_id integer,
 325         primary key (id),
 326         unique (uuid)
 327     );
 328
 329     create table Annotation_AUD (
 330         id integer not null,
 331         REV integer not null,
 332         revtype tinyint,
 333         created timestamp,
 334         uuid varchar(36),
 335         updated timestamp,
 336         text longvarchar,
 337         linkbackurl varbinary(255),
 338         createdby_id integer,
 339         updatedby_id integer,
 340         language_id integer,
 341         annotationtype_id integer,
 342         commentator_id integer,
 343         primary key (id, REV)
 344     );
 345
 346     create table Annotation_Annotation (
 347         Annotation_id integer not null,
 348         annotations_id integer not null,
 349         primary key (Annotation_id, annotations_id),
 350         unique (annotations_id)
 351     );
 352
 353     create table Annotation_Annotation_AUD (
 354         REV integer not null,
 355         Annotation_id integer not null,
 356         annotations_id integer not null,
 357         revtype tinyint,
 358         primary key (REV, Annotation_id, annotations_id)
 359     );
 360
 361     create table Annotation_Marker (
 362         Annotation_id integer not null,
 363         markers_id integer not null,
 364         primary key (Annotation_id, markers_id),
 365         unique (markers_id)
 366     );
 367
 368     create table Annotation_Marker_AUD (
 369         REV integer not null,
 370         Annotation_id integer not null,
 371         markers_id integer not null,
 372         revtype tinyint,
 373         primary key (REV, Annotation_id, markers_id)
 374     );
 375
 376     create table AuditEvent (
 377         revisionnumber integer generated by default as identity (start with 1),
 378         date timestamp,
 379         timestamp bigint,
 380         uuid varchar(255),
 381         primary key (revisionnumber)
 382     );
 383
 384     create table CDM_VIEW (
 385         id integer not null,
 386         created timestamp,
 387         uuid varchar(36),
 388         description varchar(255),
 389         name varchar(255),
 390         createdby_id integer,
 391         reference_id integer,
 392         primary key (id),
 393         unique (uuid)
 394     );
 395
 396     create table CDM_VIEW_CDM_VIEW (
 397         CDM_VIEW_id integer not null,
 398         superviews_id integer not null,
 399         primary key (CDM_VIEW_id, superviews_id),
 400         unique (superviews_id)
 401     );
 402
 403     create table Collection (
 404         id integer not null,
 405         created timestamp,
 406         uuid varchar(36),
 407         updated timestamp,
 408         lsid_authority varchar(255),
 409         lsid_lsid varchar(255),
 410         lsid_namespace varchar(255),
 411         lsid_object varchar(255),
 412         lsid_revision varchar(255),
 413         protectedtitlecache bit not null,
 414         titleCache varchar(255),
 415         code varchar(255),
 416         codestandard varchar(255),
 417         name varchar(255),
 418         townorlocation varchar(255),
 419         createdby_id integer,
 420         updatedby_id integer,
 421         institute_id integer,
 422         supercollection_id integer,
 423         primary key (id),
 424         unique (uuid)
 425     );
 426
 427     create table Collection_AUD (
 428         id integer not null,
 429         REV integer not null,
 430         revtype tinyint,
 431         created timestamp,
 432         uuid varchar(36),
 433         updated timestamp,
 434         lsid_authority varchar(255),
 435         lsid_lsid varchar(255),
 436         lsid_namespace varchar(255),
 437         lsid_object varchar(255),
 438         lsid_revision varchar(255),
 439         protectedtitlecache bit,
 440         titleCache varchar(255),
 441         code varchar(255),
 442         codestandard varchar(255),
 443         name varchar(255),
 444         townorlocation varchar(255),
 445         createdby_id integer,
 446         updatedby_id integer,
 447         institute_id integer,
 448         supercollection_id integer,
 449         primary key (id, REV)
 450     );
 451
 452     create table Collection_Annotation (
 453         Collection_id integer not null,
 454         annotations_id integer not null,
 455         primary key (Collection_id, annotations_id),
 456         unique (annotations_id)
 457     );
 458
 459     create table Collection_Annotation_AUD (
 460         REV integer not null,
 461         Collection_id integer not null,
 462         annotations_id integer not null,
 463         revtype tinyint,
 464         primary key (REV, Collection_id, annotations_id)
 465     );
 466
 467     create table Collection_Credit (
 468         Collection_id integer not null,
 469         credits_id integer not null,
 470         sortIndex integer not null,
 471         primary key (Collection_id, sortIndex),
 472         unique (credits_id)
 473     );
 474
 475     create table Collection_Credit_AUD (
 476         REV integer not null,
 477         Collection_id integer not null,
 478         credits_id integer not null,
 479         sortIndex integer not null,
 480         revtype tinyint,
 481         primary key (REV, Collection_id, credits_id, sortIndex)
 482     );
 483
 484     create table Collection_Extension (
 485         Collection_id integer not null,
 486         extensions_id integer not null,
 487         primary key (Collection_id, extensions_id),
 488         unique (extensions_id)
 489     );
 490
 491     create table Collection_Extension_AUD (
 492         REV integer not null,
 493         Collection_id integer not null,
 494         extensions_id integer not null,
 495         revtype tinyint,
 496         primary key (REV, Collection_id, extensions_id)
 497     );
 498
 499     create table Collection_Marker (
 500         Collection_id integer not null,
 501         markers_id integer not null,
 502         primary key (Collection_id, markers_id),
 503         unique (markers_id)
 504     );
 505
 506     create table Collection_Marker_AUD (
 507         REV integer not null,
 508         Collection_id integer not null,
 509         markers_id integer not null,
 510         revtype tinyint,
 511         primary key (REV, Collection_id, markers_id)
 512     );
 513
 514     create table Collection_Media (
 515         Collection_id integer not null,
 516         media_id integer not null,
 517         primary key (Collection_id, media_id)
 518     );
 519
 520     create table Collection_Media_AUD (
 521         REV integer not null,
 522         Collection_id integer not null,
 523         media_id integer not null,
 524         revtype tinyint,
 525         primary key (REV, Collection_id, media_id)
 526     );
 527
 528     create table Collection_OriginalSourceBase (
 529         Collection_id integer not null,
 530         sources_id integer not null,
 531         primary key (Collection_id, sources_id),
 532         unique (sources_id)
 533     );
 534
 535     create table Collection_OriginalSourceBase_AUD (
 536         REV integer not null,
 537         Collection_id integer not null,
 538         sources_id integer not null,
 539         revtype tinyint,
 540         primary key (REV, Collection_id, sources_id)
 541     );
 542
 543     create table Collection_Rights (
 544         Collection_id integer not null,
 545         rights_id integer not null,
 546         primary key (Collection_id, rights_id),
 547         unique (rights_id)
 548     );
 549
 550     create table Collection_Rights_AUD (
 551         REV integer not null,
 552         Collection_id integer not null,
 553         rights_id integer not null,
 554         revtype tinyint,
 555         primary key (REV, Collection_id, rights_id)
 556     );
 557
 558     create table Credit (
 559         id integer not null,
 560         created timestamp,
 561         uuid varchar(36),
 562         updated timestamp,
 563         text longvarchar,
 564         abbreviatedtext varchar(255),
 565         createdby_id integer,
 566         updatedby_id integer,
 567         language_id integer,
 568         agent_id integer,
 569         primary key (id),
 570         unique (uuid)
 571     );
 572
 573     create table Credit_AUD (
 574         id integer not null,
 575         REV integer not null,
 576         revtype tinyint,
 577         created timestamp,
 578         uuid varchar(36),
 579         updated timestamp,
 580         text longvarchar,
 581         abbreviatedtext varchar(255),
 582         createdby_id integer,
 583         updatedby_id integer,
 584         language_id integer,
 585         agent_id integer,
 586         primary key (id, REV)
 587     );
 588
 589     create table Credit_Annotation (
 590         Credit_id integer not null,
 591         annotations_id integer not null,
 592         primary key (Credit_id, annotations_id),
 593         unique (annotations_id)
 594     );
 595
 596     create table Credit_Annotation_AUD (
 597         REV integer not null,
 598         Credit_id integer not null,
 599         annotations_id integer not null,
 600         revtype tinyint,
 601         primary key (REV, Credit_id, annotations_id)
 602     );
 603
 604     create table Credit_Marker (
 605         Credit_id integer not null,
 606         markers_id integer not null,
 607         primary key (Credit_id, markers_id),
 608         unique (markers_id)
 609     );
 610
 611     create table Credit_Marker_AUD (
 612         REV integer not null,
 613         Credit_id integer not null,
 614         markers_id integer not null,
 615         revtype tinyint,
 616         primary key (REV, Credit_id, markers_id)
 617     );
 618
 619     create table DefinedTermBase (
 620         DTYPE varchar(31) not null,
 621         id integer not null,
 622         created timestamp,
 623         uuid varchar(36),
 624         updated timestamp,
 625         lsid_authority varchar(255),
 626         lsid_lsid varchar(255),
 627         lsid_namespace varchar(255),
 628         lsid_object varchar(255),
 629         lsid_revision varchar(255),
 630         protectedtitlecache bit not null,
 631         titleCache varchar(255),
 632         uri varchar(255),
 633         iso639_1 varchar(2),
 634         iso639_2 varchar(3),
 635         istechnical bit,
 636         orderindex integer,
 637         symmetrical bit,
 638         transitive bit,
 639         defaultcolor varchar(255),
 640         supportscategoricaldata bit,
 641         supportscommontaxonname bit,
 642         supportsdistribution bit,
 643         supportsindividualassociation bit,
 644         supportsquantitativedata bit,
 645         supportstaxoninteraction bit,
 646         supportstextdata bit,
 647         pointapproximation_errorradius integer,
 648         pointapproximation_latitude double,
 649         pointapproximation_longitude double,
 650         validperiod_end varchar(255),
 651         validperiod_freetext varchar(255),
 652         validperiod_start varchar(255),
 653         iso3166_a2 varchar(2),
 654         createdby_id integer,
 655         updatedby_id integer,
 656         kindof_id integer,
 657         partof_id integer,
 658         vocabulary_id integer,
 659         level_id integer,
 660         pointapproximation_referencesystem_id integer,
 661         shape_id integer,
 662         type_id integer,
 663         primary key (id),
 664         unique (uuid)
 665     );
 666
 667     create table DefinedTermBase_AUD (
 668         DTYPE varchar(31) not null,
 669         id integer not null,
 670         REV integer not null,
 671         revtype tinyint,
 672         created timestamp,
 673         uuid varchar(36),
 674         updated timestamp,
 675         lsid_authority varchar(255),
 676         lsid_lsid varchar(255),
 677         lsid_namespace varchar(255),
 678         lsid_object varchar(255),
 679         lsid_revision varchar(255),
 680         protectedtitlecache bit,
 681         titleCache varchar(255),
 682         uri varchar(255),
 683         createdby_id integer,
 684         updatedby_id integer,
 685         kindof_id integer,
 686         partof_id integer,
 687         vocabulary_id integer,
 688         istechnical bit,
 689         orderindex integer,
 690         iso639_1 varchar(2),
 691         iso639_2 varchar(3),
 692         symmetrical bit,
 693         transitive bit,
 694         pointapproximation_errorradius integer,
 695         pointapproximation_latitude double,
 696         pointapproximation_longitude double,
 697         validperiod_end varchar(255),
 698         validperiod_freetext varchar(255),
 699         validperiod_start varchar(255),
 700         level_id integer,
 701         pointapproximation_referencesystem_id integer,
 702         shape_id integer,
 703         type_id integer,
 704         iso3166_a2 varchar(2),
 705         defaultcolor varchar(255),
 706         supportscategoricaldata bit,
 707         supportscommontaxonname bit,
 708         supportsdistribution bit,
 709         supportsindividualassociation bit,
 710         supportsquantitativedata bit,
 711         supportstaxoninteraction bit,
 712         supportstextdata bit,
 713         primary key (id, REV)
 714     );
 715
 716     create table DefinedTermBase_Annotation (
 717         DefinedTermBase_id integer not null,
 718         annotations_id integer not null,
 719         primary key (DefinedTermBase_id, annotations_id),
 720         unique (annotations_id)
 721     );
 722
 723     create table DefinedTermBase_Annotation_AUD (
 724         REV integer not null,
 725         DefinedTermBase_id integer not null,
 726         annotations_id integer not null,
 727         revtype tinyint,
 728         primary key (REV, DefinedTermBase_id, annotations_id)
 729     );
 730
 731     create table DefinedTermBase_Continent (
 732         DefinedTermBase_id integer not null,
 733         continents_id integer not null,
 734         primary key (DefinedTermBase_id, continents_id)
 735     );
 736
 737     create table DefinedTermBase_Continent_AUD (
 738         REV integer not null,
 739         DefinedTermBase_id integer not null,
 740         continents_id integer not null,
 741         revtype tinyint,
 742         primary key (REV, DefinedTermBase_id, continents_id)
 743     );
 744
 745     create table DefinedTermBase_Credit (
 746         DefinedTermBase_id integer not null,
 747         credits_id integer not null,
 748         sortIndex integer not null,
 749         primary key (DefinedTermBase_id, sortIndex),
 750         unique (credits_id)
 751     );
 752
 753     create table DefinedTermBase_Credit_AUD (
 754         REV integer not null,
 755         DefinedTermBase_id integer not null,
 756         credits_id integer not null,
 757         sortIndex integer not null,
 758         revtype tinyint,
 759         primary key (REV, DefinedTermBase_id, credits_id, sortIndex)
 760     );
 761
 762     create table DefinedTermBase_Extension (
 763         DefinedTermBase_id integer not null,
 764         extensions_id integer not null,
 765         primary key (DefinedTermBase_id, extensions_id),
 766         unique (extensions_id)
 767     );
 768
 769     create table DefinedTermBase_Extension_AUD (
 770         REV integer not null,
 771         DefinedTermBase_id integer not null,
 772         extensions_id integer not null,
 773         revtype tinyint,
 774         primary key (REV, DefinedTermBase_id, extensions_id)
 775     );
 776
 777     create table DefinedTermBase_Marker (
 778         DefinedTermBase_id integer not null,
 779         markers_id integer not null,
 780         primary key (DefinedTermBase_id, markers_id),
 781         unique (markers_id)
 782     );
 783
 784     create table DefinedTermBase_Marker_AUD (
 785         REV integer not null,
 786         DefinedTermBase_id integer not null,
 787         markers_id integer not null,
 788         revtype tinyint,
 789         primary key (REV, DefinedTermBase_id, markers_id)
 790     );
 791
 792     create table DefinedTermBase_MeasurementUnit (
 793         DefinedTermBase_id integer not null,
 794         recommendedmeasurementunits_id integer not null,
 795         primary key (DefinedTermBase_id, recommendedmeasurementunits_id)
 796     );
 797
 798     create table DefinedTermBase_MeasurementUnit_AUD (
 799         REV integer not null,
 800         DefinedTermBase_id integer not null,
 801         recommendedmeasurementunits_id integer not null,
 802         revtype tinyint,
 803         primary key (REV, DefinedTermBase_id, recommendedmeasurementunits_id)
 804     );
 805
 806     create table DefinedTermBase_Media (
 807         DefinedTermBase_id integer not null,
 808         media_id integer not null,
 809         primary key (DefinedTermBase_id, media_id),
 810         unique (media_id)
 811     );
 812
 813     create table DefinedTermBase_Media_AUD (
 814         REV integer not null,
 815         DefinedTermBase_id integer not null,
 816         media_id integer not null,
 817         revtype tinyint,
 818         primary key (REV, DefinedTermBase_id, media_id)
 819     );
 820
 821     create table DefinedTermBase_OriginalSourceBase (
 822         DefinedTermBase_id integer not null,
 823         sources_id integer not null,
 824         primary key (DefinedTermBase_id, sources_id),
 825         unique (sources_id)
 826     );
 827
 828     create table DefinedTermBase_OriginalSourceBase_AUD (
 829         REV integer not null,
 830         DefinedTermBase_id integer not null,
 831         sources_id integer not null,
 832         revtype tinyint,
 833         primary key (REV, DefinedTermBase_id, sources_id)
 834     );
 835
 836     create table DefinedTermBase_RecommendedModifierEnumeration (
 837         DefinedTermBase_id integer not null,
 838         recommendedmodifierenumeration_id integer not null,
 839         primary key (DefinedTermBase_id, recommendedmodifierenumeration_id),
 840         unique (recommendedmodifierenumeration_id)
 841     );
 842
 843     create table DefinedTermBase_RecommendedModifierEnumeration_AUD (
 844         REV integer not null,
 845         DefinedTermBase_id integer not null,
 846         recommendedmodifierenumeration_id integer not null,
 847         revtype tinyint,
 848         primary key (REV, DefinedTermBase_id, recommendedmodifierenumeration_id)
 849     );
 850
 851     create table DefinedTermBase_Representation (
 852         DefinedTermBase_id integer not null,
 853         representations_id integer not null,
 854         primary key (DefinedTermBase_id, representations_id),
 855         unique (representations_id)
 856     );
 857
 858     create table DefinedTermBase_Representation_AUD (
 859         REV integer not null,
 860         DefinedTermBase_id integer not null,
 861         representations_id integer not null,
 862         revtype tinyint,
 863         primary key (REV, DefinedTermBase_id, representations_id)
 864     );
 865
 866     create table DefinedTermBase_Rights (
 867         DefinedTermBase_id integer not null,
 868         rights_id integer not null,
 869         primary key (DefinedTermBase_id, rights_id),
 870         unique (rights_id)
 871     );
 872
 873     create table DefinedTermBase_Rights_AUD (
 874         REV integer not null,
 875         DefinedTermBase_id integer not null,
 876         rights_id integer not null,
 877         revtype tinyint,
 878         primary key (REV, DefinedTermBase_id, rights_id)
 879     );
 880
 881     create table DefinedTermBase_StatisticalMeasure (
 882         DefinedTermBase_id integer not null,
 883         recommendedstatisticalmeasures_id integer not null,
 884         primary key (DefinedTermBase_id, recommendedstatisticalmeasures_id)
 885     );
 886
 887     create table DefinedTermBase_StatisticalMeasure_AUD (
 888         REV integer not null,
 889         DefinedTermBase_id integer not null,
 890         recommendedstatisticalmeasures_id integer not null,
 891         revtype tinyint,
 892         primary key (REV, DefinedTermBase_id, recommendedstatisticalmeasures_id)
 893     );
 894
 895     create table DefinedTermBase_SupportedCategoricalEnumeration (
 896         DefinedTermBase_id integer not null,
 897         supportedcategoricalenumerations_id integer not null,
 898         primary key (DefinedTermBase_id, supportedcategoricalenumerations_id),
 899         unique (supportedcategoricalenumerations_id)
 900     );
 901
 902     create table DefinedTermBase_SupportedCategoricalEnumeration_AUD (
 903         REV integer not null,
 904         DefinedTermBase_id integer not null,
 905         supportedcategoricalenumerations_id integer not null,
 906         revtype tinyint,
 907         primary key (REV, DefinedTermBase_id, supportedcategoricalenumerations_id)
 908     );
 909
 910     create table DefinedTermBase_WaterbodyOrCountry (
 911         DefinedTermBase_id integer not null,
 912         waterbodiesorcountries_id integer not null,
 913         primary key (DefinedTermBase_id, waterbodiesorcountries_id)
 914     );
 915
 916     create table DefinedTermBase_WaterbodyOrCountry_AUD (
 917         REV integer not null,
 918         DefinedTermBase_id integer not null,
 919         waterbodiesorcountries_id integer not null,
 920         revtype tinyint,
 921         primary key (REV, DefinedTermBase_id, waterbodiesorcountries_id)
 922     );
 923
 924     create table DerivationEvent (
 925         id integer not null,
 926         created timestamp,
 927         uuid varchar(36),
 928         updated timestamp,
 929         description varchar(255),
 930         timeperiod_end varchar(255),
 931         timeperiod_freetext varchar(255),
 932         timeperiod_start varchar(255),
 933         createdby_id integer,
 934         updatedby_id integer,
 935         actor_id integer,
 936         type_id integer,
 937         primary key (id),
 938         unique (uuid)
 939     );
 940
 941     create table DerivationEvent_AUD (
 942         id integer not null,
 943         REV integer not null,
 944         revtype tinyint,
 945         created timestamp,
 946         uuid varchar(36),
 947         updated timestamp,
 948         description varchar(255),
 949         timeperiod_end varchar(255),
 950         timeperiod_freetext varchar(255),
 951         timeperiod_start varchar(255),
 952         createdby_id integer,
 953         updatedby_id integer,
 954         actor_id integer,
 955         type_id integer,
 956         primary key (id, REV)
 957     );
 958
 959     create table DerivationEvent_Annotation (
 960         DerivationEvent_id integer not null,
 961         annotations_id integer not null,
 962         primary key (DerivationEvent_id, annotations_id),
 963         unique (annotations_id)
 964     );
 965
 966     create table DerivationEvent_Annotation_AUD (
 967         REV integer not null,
 968         DerivationEvent_id integer not null,
 969         annotations_id integer not null,
 970         revtype tinyint,
 971         primary key (REV, DerivationEvent_id, annotations_id)
 972     );
 973
 974     create table DerivationEvent_Marker (
 975         DerivationEvent_id integer not null,
 976         markers_id integer not null,
 977         primary key (DerivationEvent_id, markers_id),
 978         unique (markers_id)
 979     );
 980
 981     create table DerivationEvent_Marker_AUD (
 982         REV integer not null,
 983         DerivationEvent_id integer not null,
 984         markers_id integer not null,
 985         revtype tinyint,
 986         primary key (REV, DerivationEvent_id, markers_id)
 987     );
 988
 989     create table DescriptionBase (
 990         DTYPE varchar(31) not null,
 991         id integer not null,
 992         created timestamp,
 993         uuid varchar(36),
 994         updated timestamp,
 995         lsid_authority varchar(255),
 996         lsid_lsid varchar(255),
 997         lsid_namespace varchar(255),
 998         lsid_object varchar(255),
 999         lsid_revision varchar(255),
1000         protectedtitlecache bit not null,
1001         titleCache varchar(255),
1002         imagegallery bit not null,
1003         createdby_id integer,
1004         updatedby_id integer,
1005         taxon_fk integer,
1006         taxonName_fk integer,
1007         primary key (id),
1008         unique (uuid)
1009     );
1010
1011     create table DescriptionBase_AUD (
1012         DTYPE varchar(31) not null,
1013         id integer not null,
1014         REV integer not null,
1015         revtype tinyint,
1016         created timestamp,
1017         uuid varchar(36),
1018         updated timestamp,
1019         lsid_authority varchar(255),
1020         lsid_lsid varchar(255),
1021         lsid_namespace varchar(255),
1022         lsid_object varchar(255),
1023         lsid_revision varchar(255),
1024         protectedtitlecache bit,
1025         titleCache varchar(255),
1026         imagegallery bit,
1027         createdby_id integer,
1028         updatedby_id integer,
1029         taxon_fk integer,
1030         taxonName_fk integer,
1031         primary key (id, REV)
1032     );
1033
1034     create table DescriptionBase_Annotation (
1035         DescriptionBase_id integer not null,
1036         annotations_id integer not null,
1037         primary key (DescriptionBase_id, annotations_id),
1038         unique (annotations_id)
1039     );
1040
1041     create table DescriptionBase_Annotation_AUD (
1042         REV integer not null,
1043         DescriptionBase_id integer not null,
1044         annotations_id integer not null,
1045         revtype tinyint,
1046         primary key (REV, DescriptionBase_id, annotations_id)
1047     );
1048
1049     create table DescriptionBase_Credit (
1050         DescriptionBase_id integer not null,
1051         credits_id integer not null,
1052         sortIndex integer not null,
1053         primary key (DescriptionBase_id, sortIndex),
1054         unique (credits_id)
1055     );
1056
1057     create table DescriptionBase_Credit_AUD (
1058         REV integer not null,
1059         DescriptionBase_id integer not null,
1060         credits_id integer not null,
1061         sortIndex integer not null,
1062         revtype tinyint,
1063         primary key (REV, DescriptionBase_id, credits_id, sortIndex)
1064     );
1065
1066     create table DescriptionBase_Extension (
1067         DescriptionBase_id integer not null,
1068         extensions_id integer not null,
1069         primary key (DescriptionBase_id, extensions_id),
1070         unique (extensions_id)
1071     );
1072
1073     create table DescriptionBase_Extension_AUD (
1074         REV integer not null,
1075         DescriptionBase_id integer not null,
1076         extensions_id integer not null,
1077         revtype tinyint,
1078         primary key (REV, DescriptionBase_id, extensions_id)
1079     );
1080
1081     create table DescriptionBase_Feature (
1082         DescriptionBase_id integer not null,
1083         descriptivesystem_id integer not null,
1084         primary key (DescriptionBase_id, descriptivesystem_id)
1085     );
1086
1087     create table DescriptionBase_Feature_AUD (
1088         REV integer not null,
1089         DescriptionBase_id integer not null,
1090         descriptivesystem_id integer not null,
1091         revtype tinyint,
1092         primary key (REV, DescriptionBase_id, descriptivesystem_id)
1093     );
1094
1095     create table DescriptionBase_GeoScope (
1096         DescriptionBase_id integer not null,
1097         geoscopes_id integer not null,
1098         primary key (DescriptionBase_id, geoscopes_id)
1099     );
1100
1101     create table DescriptionBase_GeoScope_AUD (
1102         REV integer not null,
1103         DescriptionBase_id integer not null,
1104         geoscopes_id integer not null,
1105         revtype tinyint,
1106         primary key (REV, DescriptionBase_id, geoscopes_id)
1107     );
1108
1109     create table DescriptionBase_Marker (
1110         DescriptionBase_id integer not null,
1111         markers_id integer not null,
1112         primary key (DescriptionBase_id, markers_id),
1113         unique (markers_id)
1114     );
1115
1116     create table DescriptionBase_Marker_AUD (
1117         REV integer not null,
1118         DescriptionBase_id integer not null,
1119         markers_id integer not null,
1120         revtype tinyint,
1121         primary key (REV, DescriptionBase_id, markers_id)
1122     );
1123
1124     create table DescriptionBase_OriginalSourceBase (
1125         DescriptionBase_id integer not null,
1126         sources_id integer not null,
1127         primary key (DescriptionBase_id, sources_id),
1128         unique (sources_id)
1129     );
1130
1131     create table DescriptionBase_OriginalSourceBase_AUD (
1132         REV integer not null,
1133         DescriptionBase_id integer not null,
1134         sources_id integer not null,
1135         revtype tinyint,
1136         primary key (REV, DescriptionBase_id, sources_id)
1137     );
1138
1139     create table DescriptionBase_Reference (
1140         DescriptionBase_id integer not null,
1141         descriptionsources_id integer not null,
1142         primary key (DescriptionBase_id, descriptionsources_id)
1143     );
1144
1145     create table DescriptionBase_Reference_AUD (
1146         REV integer not null,
1147         DescriptionBase_id integer not null,
1148         descriptionsources_id integer not null,
1149         revtype tinyint,
1150         primary key (REV, DescriptionBase_id, descriptionsources_id)
1151     );
1152
1153     create table DescriptionBase_Rights (
1154         DescriptionBase_id integer not null,
1155         rights_id integer not null,
1156         primary key (DescriptionBase_id, rights_id),
1157         unique (rights_id)
1158     );
1159
1160     create table DescriptionBase_Rights_AUD (
1161         REV integer not null,
1162         DescriptionBase_id integer not null,
1163         rights_id integer not null,
1164         revtype tinyint,
1165         primary key (REV, DescriptionBase_id, rights_id)
1166     );
1167
1168     create table DescriptionBase_Scope (
1169         DescriptionBase_id integer not null,
1170         scopes_id integer not null,
1171         primary key (DescriptionBase_id, scopes_id)
1172     );
1173
1174     create table DescriptionBase_Scope_AUD (
1175         REV integer not null,
1176         DescriptionBase_id integer not null,
1177         scopes_id integer not null,
1178         revtype tinyint,
1179         primary key (REV, DescriptionBase_id, scopes_id)
1180     );
1181
1182     create table DescriptionBase_SpecimenOrObservationBase (
1183         descriptions_id integer not null,
1184         describedspecimenorobservations_id integer not null,
1185         primary key (descriptions_id, describedspecimenorobservations_id)
1186     );
1187
1188     create table DescriptionBase_SpecimenOrObservationBase_AUD (
1189         REV integer not null,
1190         descriptions_id integer not null,
1191         describedspecimenorobservations_id integer not null,
1192         revtype tinyint,
1193         primary key (REV, descriptions_id, describedspecimenorobservations_id)
1194     );
1195
1196     create table DescriptionElementBase (
1197         DTYPE varchar(31) not null,
1198         id integer not null,
1199         created timestamp,
1200         uuid varchar(36),
1201         updated timestamp,
1202         orderrelevant bit,
1203         name varchar(255),
1204         createdby_id integer,
1205         updatedby_id integer,
1206         feature_id integer,
1207         indescription_id integer,
1208         language_id integer,
1209         area_id integer,
1210         status_id integer,
1211         associatedspecimenorobservation_id integer,
1212         unit_id integer,
1213         taxon2_id integer,
1214         format_id integer,
1215         primary key (id),
1216         unique (uuid)
1217     );
1218
1219     create table DescriptionElementBase_AUD (
1220         DTYPE varchar(31) not null,
1221         id integer not null,
1222         REV integer not null,
1223         revtype tinyint,
1224         created timestamp,
1225         uuid varchar(36),
1226         updated timestamp,
1227         createdby_id integer,
1228         updatedby_id integer,
1229         feature_id integer,
1230         indescription_id integer,
1231         orderrelevant bit,
1232         associatedspecimenorobservation_id integer,
1233         name varchar(255),
1234         language_id integer,
1235         taxon2_id integer,
1236         area_id integer,
1237         status_id integer,
1238         unit_id integer,
1239         format_id integer,
1240         primary key (id, REV)
1241     );
1242
1243     create table DescriptionElementBase_Annotation (
1244         DescriptionElementBase_id integer not null,
1245         annotations_id integer not null,
1246         primary key (DescriptionElementBase_id, annotations_id),
1247         unique (annotations_id)
1248     );
1249
1250     create table DescriptionElementBase_Annotation_AUD (
1251         REV integer not null,
1252         DescriptionElementBase_id integer not null,
1253         annotations_id integer not null,
1254         revtype tinyint,
1255         primary key (REV, DescriptionElementBase_id, annotations_id)
1256     );
1257
1258     create table DescriptionElementBase_LanguageString (
1259         DescriptionElementBase_id integer not null,
1260         multilanguagetext_id integer not null,
1261         multilanguagetext_mapkey_id integer not null,
1262         primary key (DescriptionElementBase_id, multilanguagetext_mapkey_id),
1263         unique (multilanguagetext_id)
1264     );
1265
1266     create table DescriptionElementBase_LanguageString_AUD (
1267         REV integer not null,
1268         DescriptionElementBase_id integer not null,
1269         multilanguagetext_id integer not null,
1270         multilanguagetext_mapkey_id integer not null,
1271         revtype tinyint,
1272         primary key (REV, DescriptionElementBase_id, multilanguagetext_id, multilanguagetext_mapkey_id)
1273     );
1274
1275     create table DescriptionElementBase_Marker (
1276         DescriptionElementBase_id integer not null,
1277         markers_id integer not null,
1278         primary key (DescriptionElementBase_id, markers_id),
1279         unique (markers_id)
1280     );
1281
1282     create table DescriptionElementBase_Marker_AUD (
1283         REV integer not null,
1284         DescriptionElementBase_id integer not null,
1285         markers_id integer not null,
1286         revtype tinyint,
1287         primary key (REV, DescriptionElementBase_id, markers_id)
1288     );
1289
1290     create table DescriptionElementBase_Media (
1291         DescriptionElementBase_id integer not null,
1292         media_id integer not null,
1293         sortIndex integer not null,
1294         primary key (DescriptionElementBase_id, sortIndex)
1295     );
1296
1297     create table DescriptionElementBase_Media_AUD (
1298         REV integer not null,
1299         DescriptionElementBase_id integer not null,
1300         media_id integer not null,
1301         sortIndex integer not null,
1302         revtype tinyint,
1303         primary key (REV, DescriptionElementBase_id, media_id, sortIndex)
1304     );
1305
1306     create table DescriptionElementBase_Modifier (
1307         DescriptionElementBase_id integer not null,
1308         modifiers_id integer not null,
1309         primary key (DescriptionElementBase_id, modifiers_id)
1310     );
1311
1312     create table DescriptionElementBase_Modifier_AUD (
1313         REV integer not null,
1314         DescriptionElementBase_id integer not null,
1315         modifiers_id integer not null,
1316         revtype tinyint,
1317         primary key (REV, DescriptionElementBase_id, modifiers_id)
1318     );
1319
1320     create table DescriptionElementBase_ModifyingText (
1321         DescriptionElementBase_id integer not null,
1322         modifyingtext_id integer not null,
1323         modifyingtext_mapkey_id integer not null,
1324         primary key (DescriptionElementBase_id, modifyingtext_mapkey_id),
1325         unique (modifyingtext_id)
1326     );
1327
1328     create table DescriptionElementBase_ModifyingText_AUD (
1329         REV integer not null,
1330         DescriptionElementBase_id integer not null,
1331         modifyingtext_id integer not null,
1332         modifyingtext_mapkey_id integer not null,
1333         revtype tinyint,
1334         primary key (REV, DescriptionElementBase_id, modifyingtext_id, modifyingtext_mapkey_id)
1335     );
1336
1337     create table DescriptionElementBase_OriginalSourceBase (
1338         DescriptionElementBase_id integer not null,
1339         sources_id integer not null,
1340         primary key (DescriptionElementBase_id, sources_id),
1341         unique (sources_id)
1342     );
1343
1344     create table DescriptionElementBase_OriginalSourceBase_AUD (
1345         REV integer not null,
1346         DescriptionElementBase_id integer not null,
1347         sources_id integer not null,
1348         revtype tinyint,
1349         primary key (REV, DescriptionElementBase_id, sources_id)
1350     );
1351
1352     create table DescriptionElementBase_StateData (
1353         DescriptionElementBase_id integer not null,
1354         states_id integer not null
1355     );
1356
1357     create table DescriptionElementBase_StateData_AUD (
1358         REV integer not null,
1359         DescriptionElementBase_id integer not null,
1360         states_id integer not null,
1361         revtype tinyint,
1362         primary key (REV, DescriptionElementBase_id, states_id)
1363     );
1364
1365     create table DescriptionElementBase_StatisticalMeasurementValue (
1366         DescriptionElementBase_id integer not null,
1367         statisticalvalues_id integer not null,
1368         primary key (DescriptionElementBase_id, statisticalvalues_id),
1369         unique (statisticalvalues_id)
1370     );
1371
1372     create table DescriptionElementBase_StatisticalMeasurementValue_AUD (
1373         REV integer not null,
1374         DescriptionElementBase_id integer not null,
1375         statisticalvalues_id integer not null,
1376         revtype tinyint,
1377         primary key (REV, DescriptionElementBase_id, statisticalvalues_id)
1378     );
1379
1380     create table DeterminationEvent (
1381         id integer not null,
1382         created timestamp,
1383         uuid varchar(36),
1384         updated timestamp,
1385         description varchar(255),
1386         timeperiod_end varchar(255),
1387         timeperiod_freetext varchar(255),
1388         timeperiod_start varchar(255),
1389         preferredflag bit not null,
1390         createdby_id integer,
1391         updatedby_id integer,
1392         actor_id integer,
1393         identifiedunit_id integer,
1394         modifier_id integer,
1395         taxon_id integer,
1396         primary key (id),
1397         unique (uuid)
1398     );
1399
1400     create table DeterminationEvent_AUD (
1401         id integer not null,
1402         REV integer not null,
1403         revtype tinyint,
1404         created timestamp,
1405         uuid varchar(36),
1406         updated timestamp,
1407         description varchar(255),
1408         timeperiod_end varchar(255),
1409         timeperiod_freetext varchar(255),
1410         timeperiod_start varchar(255),
1411         preferredflag bit,
1412         createdby_id integer,
1413         updatedby_id integer,
1414         actor_id integer,
1415         identifiedunit_id integer,
1416         modifier_id integer,
1417         taxon_id integer,
1418         primary key (id, REV)
1419     );
1420
1421     create table DeterminationEvent_Annotation (
1422         DeterminationEvent_id integer not null,
1423         annotations_id integer not null,
1424         primary key (DeterminationEvent_id, annotations_id),
1425         unique (annotations_id)
1426     );
1427
1428     create table DeterminationEvent_Annotation_AUD (
1429         REV integer not null,
1430         DeterminationEvent_id integer not null,
1431         annotations_id integer not null,
1432         revtype tinyint,
1433         primary key (REV, DeterminationEvent_id, annotations_id)
1434     );
1435
1436     create table DeterminationEvent_Marker (
1437         DeterminationEvent_id integer not null,
1438         markers_id integer not null,
1439         primary key (DeterminationEvent_id, markers_id),
1440         unique (markers_id)
1441     );
1442
1443     create table DeterminationEvent_Marker_AUD (
1444         REV integer not null,
1445         DeterminationEvent_id integer not null,
1446         markers_id integer not null,
1447         revtype tinyint,
1448         primary key (REV, DeterminationEvent_id, markers_id)
1449     );
1450
1451     create table DeterminationEvent_Reference (
1452         DeterminationEvent_id integer not null,
1453         setofreferences_id integer not null,
1454         primary key (DeterminationEvent_id, setofreferences_id)
1455     );
1456
1457     create table DeterminationEvent_Reference_AUD (
1458         REV integer not null,
1459         DeterminationEvent_id integer not null,
1460         setofreferences_id integer not null,
1461         revtype tinyint,
1462         primary key (REV, DeterminationEvent_id, setofreferences_id)
1463     );
1464
1465     create table Extension (
1466         id integer not null,
1467         created timestamp,
1468         uuid varchar(36),
1469         updated timestamp,
1470         extendedObj_type varchar(255),
1471         extendedObj_id integer not null,
1472         value longvarchar,
1473         createdby_id integer,
1474         updatedby_id integer,
1475         type_id integer,
1476         primary key (id),
1477         unique (uuid)
1478     );
1479
1480     create table Extension_AUD (
1481         id integer not null,
1482         REV integer not null,
1483         revtype tinyint,
1484         created timestamp,
1485         uuid varchar(36),
1486         updated timestamp,
1487         value longvarchar,
1488         createdby_id integer,
1489         updatedby_id integer,
1490         type_id integer,
1491         primary key (id, REV)
1492     );
1493
1494     create table FeatureNode (
1495         id integer not null,
1496         created timestamp,
1497         uuid varchar(36),
1498         updated timestamp,
1499         createdby_id integer,
1500         updatedby_id integer,
1501         feature_id integer,
1502         parent_fk integer,
1503         taxon_id integer,
1504         primary key (id),
1505         unique (uuid)
1506     );
1507
1508     create table FeatureNode_AUD (
1509         id integer not null,
1510         REV integer not null,
1511         revtype tinyint,
1512         created timestamp,
1513         uuid varchar(36),
1514         updated timestamp,
1515         createdby_id integer,
1516         updatedby_id integer,
1517         feature_id integer,
1518         parent_fk integer,
1519         taxon_id integer,
1520         primary key (id, REV)
1521     );
1522
1523     create table FeatureNode_DefinedTermBase_InapplicableIf (
1524         FeatureNode_id integer not null,
1525         inapplicableif_id integer not null,
1526         primary key (FeatureNode_id, inapplicableif_id)
1527     );
1528
1529     create table FeatureNode_DefinedTermBase_InapplicableIf_AUD (
1530         REV integer not null,
1531         FeatureNode_id integer not null,
1532         inapplicableif_id integer not null,
1533         revtype tinyint,
1534         primary key (REV, FeatureNode_id, inapplicableif_id)
1535     );
1536
1537     create table FeatureNode_DefinedTermBase_OnlyApplicable (
1538         FeatureNode_id integer not null,
1539         onlyapplicableif_id integer not null,
1540         primary key (FeatureNode_id, onlyapplicableif_id)
1541     );
1542
1543     create table FeatureNode_DefinedTermBase_OnlyApplicable_AUD (
1544         REV integer not null,
1545         FeatureNode_id integer not null,
1546         onlyapplicableif_id integer not null,
1547         revtype tinyint,
1548         primary key (REV, FeatureNode_id, onlyapplicableif_id)
1549     );
1550
1551     create table FeatureNode_Representation (
1552         FeatureNode_id integer not null,
1553         questions_id integer not null,
1554         primary key (FeatureNode_id, questions_id),
1555         unique (questions_id)
1556     );
1557
1558     create table FeatureNode_Representation_AUD (
1559         REV integer not null,
1560         FeatureNode_id integer not null,
1561         questions_id integer not null,
1562         revtype tinyint,
1563         primary key (REV, FeatureNode_id, questions_id)
1564     );
1565
1566     create table FeatureTree (
1567         DTYPE varchar(31) not null,
1568         id integer not null,
1569         created timestamp,
1570         uuid varchar(36),
1571         updated timestamp,
1572         lsid_authority varchar(255),
1573         lsid_lsid varchar(255),
1574         lsid_namespace varchar(255),
1575         lsid_object varchar(255),
1576         lsid_revision varchar(255),
1577         protectedtitlecache bit not null,
1578         titleCache varchar(255),
1579         uri varchar(255),
1580         descriptionseparated bit not null,
1581         createdby_id integer,
1582         updatedby_id integer,
1583         root_id integer,
1584         primary key (id),
1585         unique (uuid)
1586     );
1587
1588     create table FeatureTree_AUD (
1589         DTYPE varchar(31) not null,
1590         id integer not null,
1591         REV integer not null,
1592         revtype tinyint,
1593         created timestamp,
1594         uuid varchar(36),
1595         updated timestamp,
1596         lsid_authority varchar(255),
1597         lsid_lsid varchar(255),
1598         lsid_namespace varchar(255),
1599         lsid_object varchar(255),
1600         lsid_revision varchar(255),
1601         protectedtitlecache bit,
1602         titleCache varchar(255),
1603         uri varchar(255),
1604         descriptionseparated bit,
1605         createdby_id integer,
1606         updatedby_id integer,
1607         root_id integer,
1608         primary key (id, REV)
1609     );
1610
1611     create table FeatureTree_Annotation (
1612         FeatureTree_id integer not null,
1613         annotations_id integer not null,
1614         primary key (FeatureTree_id, annotations_id),
1615         unique (annotations_id)
1616     );
1617
1618     create table FeatureTree_Annotation_AUD (
1619         REV integer not null,
1620         FeatureTree_id integer not null,
1621         annotations_id integer not null,
1622         revtype tinyint,
1623         primary key (REV, FeatureTree_id, annotations_id)
1624     );
1625
1626     create table FeatureTree_Credit (
1627         FeatureTree_id integer not null,
1628         credits_id integer not null,
1629         sortIndex integer not null,
1630         primary key (FeatureTree_id, sortIndex),
1631         unique (credits_id)
1632     );
1633
1634     create table FeatureTree_Credit_AUD (
1635         REV integer not null,
1636         FeatureTree_id integer not null,
1637         credits_id integer not null,
1638         sortIndex integer not null,
1639         revtype tinyint,
1640         primary key (REV, FeatureTree_id, credits_id, sortIndex)
1641     );
1642
1643     create table FeatureTree_Extension (
1644         FeatureTree_id integer not null,
1645         extensions_id integer not null,
1646         primary key (FeatureTree_id, extensions_id),
1647         unique (extensions_id)
1648     );
1649
1650     create table FeatureTree_Extension_AUD (
1651         REV integer not null,
1652         FeatureTree_id integer not null,
1653         extensions_id integer not null,
1654         revtype tinyint,
1655         primary key (REV, FeatureTree_id, extensions_id)
1656     );
1657
1658     create table FeatureTree_Marker (
1659         FeatureTree_id integer not null,
1660         markers_id integer not null,
1661         primary key (FeatureTree_id, markers_id),
1662         unique (markers_id)
1663     );
1664
1665     create table FeatureTree_Marker_AUD (
1666         REV integer not null,
1667         FeatureTree_id integer not null,
1668         markers_id integer not null,
1669         revtype tinyint,
1670         primary key (REV, FeatureTree_id, markers_id)
1671     );
1672
1673     create table FeatureTree_OriginalSourceBase (
1674         FeatureTree_id integer not null,
1675         sources_id integer not null,
1676         primary key (FeatureTree_id, sources_id),
1677         unique (sources_id)
1678     );
1679
1680     create table FeatureTree_OriginalSourceBase_AUD (
1681         REV integer not null,
1682         FeatureTree_id integer not null,
1683         sources_id integer not null,
1684         revtype tinyint,
1685         primary key (REV, FeatureTree_id, sources_id)
1686     );
1687
1688     create table FeatureTree_Representation (
1689         FeatureTree_id integer not null,
1690         representations_id integer not null,
1691         primary key (FeatureTree_id, representations_id),
1692         unique (representations_id)
1693     );
1694
1695     create table FeatureTree_Representation_AUD (
1696         REV integer not null,
1697         FeatureTree_id integer not null,
1698         representations_id integer not null,
1699         revtype tinyint,
1700         primary key (REV, FeatureTree_id, representations_id)
1701     );
1702
1703     create table FeatureTree_Rights (
1704         FeatureTree_id integer not null,
1705         rights_id integer not null,
1706         primary key (FeatureTree_id, rights_id),
1707         unique (rights_id)
1708     );
1709
1710     create table FeatureTree_Rights_AUD (
1711         REV integer not null,
1712         FeatureTree_id integer not null,
1713         rights_id integer not null,
1714         revtype tinyint,
1715         primary key (REV, FeatureTree_id, rights_id)
1716     );
1717
1718     create table FeatureTree_TaxonBase (
1719         FeatureTree_id integer not null,
1720         coveredtaxa_id integer not null,
1721         primary key (FeatureTree_id, coveredtaxa_id)
1722     );
1723
1724     create table FeatureTree_TaxonBase_AUD (
1725         REV integer not null,
1726         FeatureTree_id integer not null,
1727         coveredtaxa_id integer not null,
1728         revtype tinyint,
1729         primary key (REV, FeatureTree_id, coveredtaxa_id)
1730     );
1731
1732     create table GatheringEvent (
1733         id integer not null,
1734         created timestamp,
1735         uuid varchar(36),
1736         updated timestamp,
1737         description varchar(255),
1738         timeperiod_end varchar(255),
1739         timeperiod_freetext varchar(255),
1740         timeperiod_start varchar(255),
1741         absoluteelevation integer,
1742         absoluteelevationerror integer,
1743         collectingmethod varchar(255),
1744         distancetoground integer,
1745         distancetowatersurface integer,
1746         exactlocation_errorradius integer,
1747         exactlocation_latitude double,
1748         exactlocation_longitude double,
1749         createdby_id integer,
1750         updatedby_id integer,
1751         actor_id integer,
1752         exactlocation_referencesystem_id integer,
1753         locality_id integer,
1754         primary key (id),
1755         unique (uuid)
1756     );
1757
1758     create table GatheringEvent_AUD (
1759         id integer not null,
1760         REV integer not null,
1761         revtype tinyint,
1762         created timestamp,
1763         uuid varchar(36),
1764         updated timestamp,
1765         description varchar(255),
1766         timeperiod_end varchar(255),
1767         timeperiod_freetext varchar(255),
1768         timeperiod_start varchar(255),
1769         absoluteelevation integer,
1770         absoluteelevationerror integer,
1771         collectingmethod varchar(255),
1772         distancetoground integer,
1773         distancetowatersurface integer,
1774         exactlocation_errorradius integer,
1775         exactlocation_latitude double,
1776         exactlocation_longitude double,
1777         createdby_id integer,
1778         updatedby_id integer,
1779         actor_id integer,
1780         exactlocation_referencesystem_id integer,
1781         locality_id integer,
1782         primary key (id, REV)
1783     );
1784
1785     create table GatheringEvent_Annotation (
1786         GatheringEvent_id integer not null,
1787         annotations_id integer not null,
1788         primary key (GatheringEvent_id, annotations_id),
1789         unique (annotations_id)
1790     );
1791
1792     create table GatheringEvent_Annotation_AUD (
1793         REV integer not null,
1794         GatheringEvent_id integer not null,
1795         annotations_id integer not null,
1796         revtype tinyint,
1797         primary key (REV, GatheringEvent_id, annotations_id)
1798     );
1799
1800     create table GatheringEvent_DefinedTermBase (
1801         GatheringEvent_id integer not null,
1802         collectingareas_id integer not null,
1803         primary key (GatheringEvent_id, collectingareas_id)
1804     );
1805
1806     create table GatheringEvent_DefinedTermBase_AUD (
1807         REV integer not null,
1808         GatheringEvent_id integer not null,
1809         collectingareas_id integer not null,
1810         revtype tinyint,
1811         primary key (REV, GatheringEvent_id, collectingareas_id)
1812     );
1813
1814     create table GatheringEvent_Marker (
1815         GatheringEvent_id integer not null,
1816         markers_id integer not null,
1817         primary key (GatheringEvent_id, markers_id),
1818         unique (markers_id)
1819     );
1820
1821     create table GatheringEvent_Marker_AUD (
1822         REV integer not null,
1823         GatheringEvent_id integer not null,
1824         markers_id integer not null,
1825         revtype tinyint,
1826         primary key (REV, GatheringEvent_id, markers_id)
1827     );
1828
1829     create table GenBankAccession (
1830         id integer not null,
1831         created timestamp,
1832         uuid varchar(36),
1833         updated timestamp,
1834         accessionnumber varchar(255),
1835         uri varchar(255),
1836         createdby_id integer,
1837         updatedby_id integer,
1838         primary key (id),
1839         unique (uuid)
1840     );
1841
1842     create table GenBankAccession_AUD (
1843         id integer not null,
1844         REV integer not null,
1845         revtype tinyint,
1846         created timestamp,
1847         uuid varchar(36),
1848         updated timestamp,
1849         accessionnumber varchar(255),
1850         uri varchar(255),
1851         createdby_id integer,
1852         updatedby_id integer,
1853         primary key (id, REV)
1854     );
1855
1856     create table GrantedAuthorityImpl (
1857         id integer not null,
1858         created timestamp,
1859         uuid varchar(36),
1860         authority varchar(255),
1861         createdby_id integer,
1862         primary key (id),
1863         unique (uuid, authority)
1864     );
1865
1866     create table HomotypicalGroup (
1867         id integer not null,
1868         created timestamp,
1869         uuid varchar(36),
1870         updated timestamp,
1871         createdby_id integer,
1872         updatedby_id integer,
1873         primary key (id),
1874         unique (uuid)
1875     );
1876
1877     create table HomotypicalGroup_AUD (
1878         id integer not null,
1879         REV integer not null,
1880         revtype tinyint,
1881         created timestamp,
1882         uuid varchar(36),
1883         updated timestamp,
1884         createdby_id integer,
1885         updatedby_id integer,
1886         primary key (id, REV)
1887     );
1888
1889     create table HomotypicalGroup_Annotation (
1890         HomotypicalGroup_id integer not null,
1891         annotations_id integer not null,
1892         primary key (HomotypicalGroup_id, annotations_id),
1893         unique (annotations_id)
1894     );
1895
1896     create table HomotypicalGroup_Annotation_AUD (
1897         REV integer not null,
1898         HomotypicalGroup_id integer not null,
1899         annotations_id integer not null,
1900         revtype tinyint,
1901         primary key (REV, HomotypicalGroup_id, annotations_id)
1902     );
1903
1904     create table HomotypicalGroup_Marker (
1905         HomotypicalGroup_id integer not null,
1906         markers_id integer not null,
1907         primary key (HomotypicalGroup_id, markers_id),
1908         unique (markers_id)
1909     );
1910
1911     create table HomotypicalGroup_Marker_AUD (
1912         REV integer not null,
1913         HomotypicalGroup_id integer not null,
1914         markers_id integer not null,
1915         revtype tinyint,
1916         primary key (REV, HomotypicalGroup_id, markers_id)
1917     );
1918
1919     create table HybridRelationship (
1920         id integer not null,
1921         created timestamp,
1922         uuid varchar(36),
1923         updated timestamp,
1924         citationmicroreference varchar(255),
1925         originalnamestring varchar(255),
1926         doubtful bit not null,
1927         ruleconsidered varchar(255),
1928         createdby_id integer,
1929         updatedby_id integer,
1930         citation_id integer,
1931         relatedfrom_id integer,
1932         relatedto_id integer,
1933         type_id integer,
1934         primary key (id),
1935         unique (uuid)
1936     );
1937
1938     create table HybridRelationship_AUD (
1939         id integer not null,
1940         REV integer not null,
1941         revtype tinyint,
1942         created timestamp,
1943         uuid varchar(36),
1944         updated timestamp,
1945         citationmicroreference varchar(255),
1946         originalnamestring varchar(255),
1947         doubtful bit,
1948         ruleconsidered varchar(255),
1949         createdby_id integer,
1950         updatedby_id integer,
1951         citation_id integer,
1952         relatedfrom_id integer,
1953         relatedto_id integer,
1954         type_id integer,
1955         primary key (id, REV)
1956     );
1957
1958     create table HybridRelationship_Annotation (
1959         HybridRelationship_id integer not null,
1960         annotations_id integer not null,
1961         primary key (HybridRelationship_id, annotations_id),
1962         unique (annotations_id)
1963     );
1964
1965     create table HybridRelationship_Annotation_AUD (
1966         REV integer not null,
1967         HybridRelationship_id integer not null,
1968         annotations_id integer not null,
1969         revtype tinyint,
1970         primary key (REV, HybridRelationship_id, annotations_id)
1971     );
1972
1973     create table HybridRelationship_Marker (
1974         HybridRelationship_id integer not null,
1975         markers_id integer not null,
1976         primary key (HybridRelationship_id, markers_id),
1977         unique (markers_id)
1978     );
1979
1980     create table HybridRelationship_Marker_AUD (
1981         REV integer not null,
1982         HybridRelationship_id integer not null,
1983         markers_id integer not null,
1984         revtype tinyint,
1985         primary key (REV, HybridRelationship_id, markers_id)
1986     );
1987
1988     create table IndividualAssociation_LanguageString (
1989         DescriptionElementBase_id integer not null,
1990         description_id integer not null,
1991         description_mapkey_id integer not null,
1992         primary key (DescriptionElementBase_id, description_mapkey_id),
1993         unique (description_id)
1994     );
1995
1996     create table IndividualAssociation_LanguageString_AUD (
1997         REV integer not null,
1998         DescriptionElementBase_id integer not null,
1999         description_id integer not null,
2000         description_mapkey_id integer not null,
2001         revtype tinyint,
2002         primary key (REV, DescriptionElementBase_id, description_id, description_mapkey_id)
2003     );
2004
2005     create table InstitutionalMembership (
2006         id integer not null,
2007         created timestamp,
2008         uuid varchar(36),
2009         updated timestamp,
2010         department varchar(255),
2011         period_end varchar(255),
2012         period_freetext varchar(255),
2013         period_start varchar(255),
2014         role varchar(255),
2015         createdby_id integer,
2016         updatedby_id integer,
2017         institute_id integer,
2018         person_id integer,
2019         primary key (id),
2020         unique (uuid)
2021     );
2022
2023     create table InstitutionalMembership_AUD (
2024         id integer not null,
2025         REV integer not null,
2026         revtype tinyint,
2027         created timestamp,
2028         uuid varchar(36),
2029         updated timestamp,
2030         department varchar(255),
2031         period_end varchar(255),
2032         period_freetext varchar(255),
2033         period_start varchar(255),
2034         role varchar(255),
2035         createdby_id integer,
2036         updatedby_id integer,
2037         institute_id integer,
2038         person_id integer,
2039         primary key (id, REV)
2040     );
2041
2042     create table LSIDAuthority (
2043         id integer not null,
2044         created timestamp,
2045         uuid varchar(36),
2046         authority varchar(255),
2047         authoritywsdl longvarchar,
2048         port integer not null,
2049         server varchar(255),
2050         url varchar(255),
2051         createdby_id integer,
2052         primary key (id),
2053         unique (uuid, authority)
2054     );
2055
2056     create table LSIDAuthority_namespaces (
2057         LSIDAuthority_id integer not null,
2058         namespaces_element varchar(255),
2059         namespaces_mapkey varchar(255),
2060         primary key (LSIDAuthority_id, namespaces_mapkey)
2061     );
2062
2063     create table LanguageString (
2064         id integer not null,
2065         created timestamp,
2066         uuid varchar(36),
2067         updated timestamp,
2068         text longvarchar,
2069         createdby_id integer,
2070         updatedby_id integer,
2071         language_id integer,
2072         primary key (id),
2073         unique (uuid)
2074     );
2075
2076     create table LanguageString_AUD (
2077         id integer not null,
2078         REV integer not null,
2079         revtype tinyint,
2080         created timestamp,
2081         uuid varchar(36),
2082         updated timestamp,
2083         text longvarchar,
2084         createdby_id integer,
2085         updatedby_id integer,
2086         language_id integer,
2087         primary key (id, REV)
2088     );
2089
2090     create table LanguageString_Annotation (
2091         LanguageString_id integer not null,
2092         annotations_id integer not null,
2093         primary key (LanguageString_id, annotations_id),
2094         unique (annotations_id)
2095     );
2096
2097     create table LanguageString_Annotation_AUD (
2098         REV integer not null,
2099         LanguageString_id integer not null,
2100         annotations_id integer not null,
2101         revtype tinyint,
2102         primary key (REV, LanguageString_id, annotations_id)
2103     );
2104
2105     create table LanguageString_Marker (
2106         LanguageString_id integer not null,
2107         markers_id integer not null,
2108         primary key (LanguageString_id, markers_id),
2109         unique (markers_id)
2110     );
2111
2112     create table LanguageString_Marker_AUD (
2113         REV integer not null,
2114         LanguageString_id integer not null,
2115         markers_id integer not null,
2116         revtype tinyint,
2117         primary key (REV, LanguageString_id, markers_id)
2118     );
2119
2120     create table Locus (
2121         id integer not null,
2122         created timestamp,
2123         uuid varchar(36),
2124         updated timestamp,
2125         description varchar(255),
2126         name varchar(255),
2127         createdby_id integer,
2128         updatedby_id integer,
2129         primary key (id),
2130         unique (uuid)
2131     );
2132
2133     create table Locus_AUD (
2134         id integer not null,
2135         REV integer not null,
2136         revtype tinyint,
2137         created timestamp,
2138         uuid varchar(36),
2139         updated timestamp,
2140         description varchar(255),
2141         name varchar(255),
2142         createdby_id integer,
2143         updatedby_id integer,
2144         primary key (id, REV)
2145     );
2146
2147     create table Marker (
2148         id integer not null,
2149         created timestamp,
2150         uuid varchar(36),
2151         updated timestamp,
2152         flag bit not null,
2153         markedObj_type varchar(255),
2154         markedObj_id integer not null,
2155         createdby_id integer,
2156         updatedby_id integer,
2157         markertype_id integer,
2158         primary key (id),
2159         unique (uuid)
2160     );
2161
2162     create table Marker_AUD (
2163         id integer not null,
2164         REV integer not null,
2165         revtype tinyint,
2166         created timestamp,
2167         uuid varchar(36),
2168         updated timestamp,
2169         flag bit,
2170         createdby_id integer,
2171         updatedby_id integer,
2172         markertype_id integer,
2173         primary key (id, REV)
2174     );
2175
2176     create table Media (
2177         DTYPE varchar(31) not null,
2178         id integer not null,
2179         created timestamp,
2180         uuid varchar(36),
2181         updated timestamp,
2182         lsid_authority varchar(255),
2183         lsid_lsid varchar(255),
2184         lsid_namespace varchar(255),
2185         lsid_object varchar(255),
2186         lsid_revision varchar(255),
2187         protectedtitlecache bit not null,
2188         titleCache varchar(255),
2189         mediacreated timestamp,
2190         citationmicroreference varchar(255),
2191         createdby_id integer,
2192         updatedby_id integer,
2193         artist_id integer,
2194         citation_id integer,
2195         primary key (id),
2196         unique (uuid)
2197     );
2198
2199     create table MediaKey_NamedArea (
2200         Media_id integer not null,
2201         geographicalscope_id integer not null,
2202         primary key (Media_id, geographicalscope_id)
2203     );
2204
2205     create table MediaKey_NamedArea_AUD (
2206         REV integer not null,
2207         Media_id integer not null,
2208         geographicalscope_id integer not null,
2209         revtype tinyint,
2210         primary key (REV, Media_id, geographicalscope_id)
2211     );
2212
2213     create table MediaKey_Scope (
2214         Media_id integer not null,
2215         scoperestrictions_id integer not null,
2216         primary key (Media_id, scoperestrictions_id)
2217     );
2218
2219     create table MediaKey_Scope_AUD (
2220         REV integer not null,
2221         Media_id integer not null,
2222         scoperestrictions_id integer not null,
2223         revtype tinyint,
2224         primary key (REV, Media_id, scoperestrictions_id)
2225     );
2226
2227     create table MediaKey_Taxon (
2228         mediaKey_fk integer not null,
2229         taxon_fk integer not null,
2230         primary key (mediaKey_fk, taxon_fk)
2231     );
2232
2233     create table MediaKey_Taxon_AUD (
2234         REV integer not null,
2235         mediaKey_fk integer not null,
2236         taxon_fk integer not null,
2237         revtype tinyint,
2238         primary key (REV, mediaKey_fk, taxon_fk)
2239     );
2240
2241     create table MediaRepresentation (
2242         id integer not null,
2243         created timestamp,
2244         uuid varchar(36),
2245         updated timestamp,
2246         mimetype varchar(255),
2247         suffix varchar(255),
2248         createdby_id integer,
2249         updatedby_id integer,
2250         media_id integer,
2251         primary key (id),
2252         unique (uuid)
2253     );
2254
2255     create table MediaRepresentationPart (
2256         DTYPE varchar(31) not null,
2257         id integer not null,
2258         created timestamp,
2259         uuid varchar(36),
2260         updated timestamp,
2261         size integer,
2262         uri varchar(255),
2263         duration integer,
2264         height integer,
2265         width integer,
2266         createdby_id integer,
2267         updatedby_id integer,
2268         representation_id integer not null,
2269         sortIndex integer,
2270         primary key (id),
2271         unique (uuid)
2272     );
2273
2274     create table MediaRepresentationPart_AUD (
2275         DTYPE varchar(31) not null,
2276         id integer not null,
2277         REV integer not null,
2278         revtype tinyint,
2279         created timestamp,
2280         uuid varchar(36),
2281         updated timestamp,
2282         size integer,
2283         uri varchar(255),
2284         createdby_id integer,
2285         updatedby_id integer,
2286         representation_id integer,
2287         duration integer,
2288         height integer,
2289         width integer,
2290         primary key (id, REV)
2291     );
2292
2293     create table MediaRepresentation_AUD (
2294         id integer not null,
2295         REV integer not null,
2296         revtype tinyint,
2297         created timestamp,
2298         uuid varchar(36),
2299         updated timestamp,
2300         mimetype varchar(255),
2301         suffix varchar(255),
2302         createdby_id integer,
2303         updatedby_id integer,
2304         media_id integer,
2305         primary key (id, REV)
2306     );
2307
2308     create table MediaRepresentation_MediaRepresentationPart_AUD (
2309         REV integer not null,
2310         representation_id integer not null,
2311         id integer not null,
2312         sortIndex integer not null,
2313         revtype tinyint,
2314         primary key (REV, representation_id, id, sortIndex)
2315     );
2316
2317     create table Media_AUD (
2318         DTYPE varchar(31) not null,
2319         id integer not null,
2320         REV integer not null,
2321         revtype tinyint,
2322         created timestamp,
2323         uuid varchar(36),
2324         updated timestamp,
2325         lsid_authority varchar(255),
2326         lsid_lsid varchar(255),
2327         lsid_namespace varchar(255),
2328         lsid_object varchar(255),
2329         lsid_revision varchar(255),
2330         protectedtitlecache bit,
2331         titleCache varchar(255),
2332         mediacreated timestamp,
2333         createdby_id integer,
2334         updatedby_id integer,
2335         artist_id integer,
2336         citationmicroreference varchar(255),
2337         citation_id integer,
2338         primary key (id, REV)
2339     );
2340
2341     create table Media_Annotation (
2342         Media_id integer not null,
2343         annotations_id integer not null,
2344         primary key (Media_id, annotations_id),
2345         unique (annotations_id)
2346     );
2347
2348     create table Media_Annotation_AUD (
2349         REV integer not null,
2350         Media_id integer not null,
2351         annotations_id integer not null,
2352         revtype tinyint,
2353         primary key (REV, Media_id, annotations_id)
2354     );
2355
2356     create table Media_Credit (
2357         Media_id integer not null,
2358         credits_id integer not null,
2359         sortIndex integer not null,
2360         primary key (Media_id, sortIndex),
2361         unique (credits_id)
2362     );
2363
2364     create table Media_Credit_AUD (
2365         REV integer not null,
2366         Media_id integer not null,
2367         credits_id integer not null,
2368         sortIndex integer not null,
2369         revtype tinyint,
2370         primary key (REV, Media_id, credits_id, sortIndex)
2371     );
2372
2373     create table Media_Description (
2374         Media_id integer not null,
2375         description_id integer not null,
2376         description_mapkey_id integer not null,
2377         primary key (Media_id, description_mapkey_id),
2378         unique (description_id)
2379     );
2380
2381     create table Media_Description_AUD (
2382         REV integer not null,
2383         Media_id integer not null,
2384         description_id integer not null,
2385         description_mapkey_id integer not null,
2386         revtype tinyint,
2387         primary key (REV, Media_id, description_id, description_mapkey_id)
2388     );
2389
2390     create table Media_Extension (
2391         Media_id integer not null,
2392         extensions_id integer not null,
2393         primary key (Media_id, extensions_id),
2394         unique (extensions_id)
2395     );
2396
2397     create table Media_Extension_AUD (
2398         REV integer not null,
2399         Media_id integer not null,
2400         extensions_id integer not null,
2401         revtype tinyint,
2402         primary key (REV, Media_id, extensions_id)
2403     );
2404
2405     create table Media_LanguageString (
2406         Media_id integer not null,
2407         title_id integer not null,
2408         title_mapkey_id integer not null,
2409         primary key (Media_id, title_mapkey_id),
2410         unique (title_id)
2411     );
2412
2413     create table Media_LanguageString_AUD (
2414         REV integer not null,
2415         Media_id integer not null,
2416         title_id integer not null,
2417         title_mapkey_id integer not null,
2418         revtype tinyint,
2419         primary key (REV, Media_id, title_id, title_mapkey_id)
2420     );
2421
2422     create table Media_Marker (
2423         Media_id integer not null,
2424         markers_id integer not null,
2425         primary key (Media_id, markers_id),
2426         unique (markers_id)
2427     );
2428
2429     create table Media_Marker_AUD (
2430         REV integer not null,
2431         Media_id integer not null,
2432         markers_id integer not null,
2433         revtype tinyint,
2434         primary key (REV, Media_id, markers_id)
2435     );
2436
2437     create table Media_OriginalSourceBase (
2438         Media_id integer not null,
2439         sources_id integer not null,
2440         primary key (Media_id, sources_id),
2441         unique (sources_id)
2442     );
2443
2444     create table Media_OriginalSourceBase_AUD (
2445         REV integer not null,
2446         Media_id integer not null,
2447         sources_id integer not null,
2448         revtype tinyint,
2449         primary key (REV, Media_id, sources_id)
2450     );
2451
2452     create table Media_Representation (
2453         Media_id integer not null,
2454         keyrepresentations_id integer not null,
2455         primary key (Media_id, keyrepresentations_id)
2456     );
2457
2458     create table Media_Representation_AUD (
2459         REV integer not null,
2460         Media_id integer not null,
2461         keyrepresentations_id integer not null,
2462         revtype tinyint,
2463         primary key (REV, Media_id, keyrepresentations_id)
2464     );
2465
2466     create table Media_Rights (
2467         Media_id integer not null,
2468         rights_id integer not null,
2469         primary key (Media_id, rights_id),
2470         unique (rights_id)
2471     );
2472
2473     create table Media_Rights_AUD (
2474         REV integer not null,
2475         Media_id integer not null,
2476         rights_id integer not null,
2477         revtype tinyint,
2478         primary key (REV, Media_id, rights_id)
2479     );
2480
2481     create table Media_Sequence (
2482         Media_id integer not null,
2483         usedsequences_id integer not null,
2484         primary key (Media_id, usedsequences_id),
2485         unique (usedsequences_id)
2486     );
2487
2488     create table Media_Sequence_AUD (
2489         REV integer not null,
2490         Media_id integer not null,
2491         usedsequences_id integer not null,
2492         revtype tinyint,
2493         primary key (REV, Media_id, usedsequences_id)
2494     );
2495
2496     create table Media_TaxonBase (
2497         Media_id integer not null,
2498         coveredtaxa_id integer not null,
2499         primary key (Media_id, coveredtaxa_id)
2500     );
2501
2502     create table Media_TaxonBase_AUD (
2503         REV integer not null,
2504         Media_id integer not null,
2505         coveredtaxa_id integer not null,
2506         revtype tinyint,
2507         primary key (REV, Media_id, coveredtaxa_id)
2508     );
2509
2510     create table MultiAccessKey_NamedArea (
2511         WorkingSet_id integer not null,
2512         geographicalscope_id integer not null,
2513         primary key (WorkingSet_id, geographicalscope_id)
2514     );
2515
2516     create table MultiAccessKey_NamedArea_AUD (
2517         REV integer not null,
2518         WorkingSet_id integer not null,
2519         geographicalscope_id integer not null,
2520         revtype tinyint,
2521         primary key (REV, WorkingSet_id, geographicalscope_id)
2522     );
2523
2524     create table MultiAccessKey_Scope (
2525         WorkingSet_id integer not null,
2526         scoperestrictions_id integer not null,
2527         primary key (WorkingSet_id, scoperestrictions_id)
2528     );
2529
2530     create table MultiAccessKey_Scope_AUD (
2531         REV integer not null,
2532         WorkingSet_id integer not null,
2533         scoperestrictions_id integer not null,
2534         revtype tinyint,
2535         primary key (REV, WorkingSet_id, scoperestrictions_id)
2536     );
2537
2538     create table MultiAccessKey_Taxon (
2539         multiAccessKey_fk integer not null,
2540         taxon_fk integer not null,
2541         primary key (multiAccessKey_fk, taxon_fk)
2542     );
2543
2544     create table MultiAccessKey_Taxon_AUD (
2545         REV integer not null,
2546         multiAccessKey_fk integer not null,
2547         taxon_fk integer not null,
2548         revtype tinyint,
2549         primary key (REV, multiAccessKey_fk, taxon_fk)
2550     );
2551
2552     create table NameRelationship (
2553         id integer not null,
2554         created timestamp,
2555         uuid varchar(36),
2556         updated timestamp,
2557         citationmicroreference varchar(255),
2558         originalnamestring varchar(255),
2559         doubtful bit not null,
2560         ruleconsidered varchar(255),
2561         createdby_id integer,
2562         updatedby_id integer,
2563         citation_id integer,
2564         relatedfrom_id integer,
2565         relatedto_id integer,
2566         type_id integer,
2567         primary key (id),
2568         unique (uuid)
2569     );
2570
2571     create table NameRelationship_AUD (
2572         id integer not null,
2573         REV integer not null,
2574         revtype tinyint,
2575         created timestamp,
2576         uuid varchar(36),
2577         updated timestamp,
2578         citationmicroreference varchar(255),
2579         originalnamestring varchar(255),
2580         doubtful bit,
2581         ruleconsidered varchar(255),
2582         createdby_id integer,
2583         updatedby_id integer,
2584         citation_id integer,
2585         relatedfrom_id integer,
2586         relatedto_id integer,
2587         type_id integer,
2588         primary key (id, REV)
2589     );
2590
2591     create table NameRelationship_Annotation (
2592         NameRelationship_id integer not null,
2593         annotations_id integer not null,
2594         primary key (NameRelationship_id, annotations_id),
2595         unique (annotations_id)
2596     );
2597
2598     create table NameRelationship_Annotation_AUD (
2599         REV integer not null,
2600         NameRelationship_id integer not null,
2601         annotations_id integer not null,
2602         revtype tinyint,
2603         primary key (REV, NameRelationship_id, annotations_id)
2604     );
2605
2606     create table NameRelationship_Marker (
2607         NameRelationship_id integer not null,
2608         markers_id integer not null,
2609         primary key (NameRelationship_id, markers_id),
2610         unique (markers_id)
2611     );
2612
2613     create table NameRelationship_Marker_AUD (
2614         REV integer not null,
2615         NameRelationship_id integer not null,
2616         markers_id integer not null,
2617         revtype tinyint,
2618         primary key (REV, NameRelationship_id, markers_id)
2619     );
2620
2621     create table NomenclaturalStatus (
2622         id integer not null,
2623         created timestamp,
2624         uuid varchar(36),
2625         updated timestamp,
2626         citationmicroreference varchar(255),
2627         originalnamestring varchar(255),
2628         ruleconsidered varchar(255),
2629         createdby_id integer,
2630         updatedby_id integer,
2631         citation_id integer,
2632         type_id integer,
2633         primary key (id),
2634         unique (uuid)
2635     );
2636
2637     create table NomenclaturalStatus_AUD (
2638         id integer not null,
2639         REV integer not null,
2640         revtype tinyint,
2641         created timestamp,
2642         uuid varchar(36),
2643         updated timestamp,
2644         citationmicroreference varchar(255),
2645         originalnamestring varchar(255),
2646         ruleconsidered varchar(255),
2647         createdby_id integer,
2648         updatedby_id integer,
2649         citation_id integer,
2650         type_id integer,
2651         primary key (id, REV)
2652     );
2653
2654     create table NomenclaturalStatus_Annotation (
2655         NomenclaturalStatus_id integer not null,
2656         annotations_id integer not null,
2657         primary key (NomenclaturalStatus_id, annotations_id),
2658         unique (annotations_id)
2659     );
2660
2661     create table NomenclaturalStatus_Annotation_AUD (
2662         REV integer not null,
2663         NomenclaturalStatus_id integer not null,
2664         annotations_id integer not null,
2665         revtype tinyint,
2666         primary key (REV, NomenclaturalStatus_id, annotations_id)
2667     );
2668
2669     create table NomenclaturalStatus_Marker (
2670         NomenclaturalStatus_id integer not null,
2671         markers_id integer not null,
2672         primary key (NomenclaturalStatus_id, markers_id),
2673         unique (markers_id)
2674     );
2675
2676     create table NomenclaturalStatus_Marker_AUD (
2677         REV integer not null,
2678         NomenclaturalStatus_id integer not null,
2679         markers_id integer not null,
2680         revtype tinyint,
2681         primary key (REV, NomenclaturalStatus_id, markers_id)
2682     );
2683
2684     create table OriginalSourceBase (
2685         DTYPE varchar(31) not null,
2686         id integer not null,
2687         created timestamp,
2688         uuid varchar(36),
2689         updated timestamp,
2690         citationmicroreference varchar(255),
2691         originalnamestring varchar(255),
2692         idinsource varchar(255),
2693         idnamespace varchar(255),
2694         sourcedObj_type varchar(255),
2695         sourcedObj_id integer not null,
2696         createdby_id integer,
2697         updatedby_id integer,
2698         citation_id integer,
2699         nameusedinsource_id integer,
2700         primary key (id),
2701         unique (uuid)
2702     );
2703
2704     create table OriginalSourceBase_AUD (
2705         DTYPE varchar(31) not null,
2706         id integer not null,
2707         REV integer not null,
2708         revtype tinyint,
2709         created timestamp,
2710         uuid varchar(36),
2711         updated timestamp,
2712         citationmicroreference varchar(255),
2713         originalnamestring varchar(255),
2714         idinsource varchar(255),
2715         idnamespace varchar(255),
2716         createdby_id integer,
2717         updatedby_id integer,
2718         citation_id integer,
2719         nameusedinsource_id integer,
2720         primary key (id, REV)
2721     );
2722
2723     create table OriginalSourceBase_Annotation (
2724         OriginalSourceBase_id integer not null,
2725         annotations_id integer not null,
2726         primary key (OriginalSourceBase_id, annotations_id),
2727         unique (annotations_id)
2728     );
2729
2730     create table OriginalSourceBase_Annotation_AUD (
2731         REV integer not null,
2732         OriginalSourceBase_id integer not null,
2733         annotations_id integer not null,
2734         revtype tinyint,
2735         primary key (REV, OriginalSourceBase_id, annotations_id)
2736     );
2737
2738     create table OriginalSourceBase_Marker (
2739         OriginalSourceBase_id integer not null,
2740         markers_id integer not null,
2741         primary key (OriginalSourceBase_id, markers_id),
2742         unique (markers_id)
2743     );
2744
2745     create table OriginalSourceBase_Marker_AUD (
2746         REV integer not null,
2747         OriginalSourceBase_id integer not null,
2748         markers_id integer not null,
2749         revtype tinyint,
2750         primary key (REV, OriginalSourceBase_id, markers_id)
2751     );
2752
2753     create table PermissionGroup (
2754         id integer not null,
2755         created timestamp,
2756         uuid varchar(36),
2757         name varchar(255),
2758         createdby_id integer,
2759         primary key (id),
2760         unique (uuid, name)
2761     );
2762
2763     create table PermissionGroup_GrantedAuthorityImpl (
2764         PermissionGroup_id integer not null,
2765         grantedauthorities_id integer not null,
2766         primary key (PermissionGroup_id, grantedauthorities_id)
2767     );
2768
2769     create table PolytomousKey_NamedArea (
2770         FeatureTree_id integer not null,
2771         geographicalscope_id integer not null,
2772         primary key (FeatureTree_id, geographicalscope_id)
2773     );
2774
2775     create table PolytomousKey_NamedArea_AUD (
2776         REV integer not null,
2777         FeatureTree_id integer not null,
2778         geographicalscope_id integer not null,
2779         revtype tinyint,
2780         primary key (REV, FeatureTree_id, geographicalscope_id)
2781     );
2782
2783     create table PolytomousKey_Scope (
2784         FeatureTree_id integer not null,
2785         scoperestrictions_id integer not null,
2786         primary key (FeatureTree_id, scoperestrictions_id)
2787     );
2788
2789     create table PolytomousKey_Scope_AUD (
2790         REV integer not null,
2791         FeatureTree_id integer not null,
2792         scoperestrictions_id integer not null,
2793         revtype tinyint,
2794         primary key (REV, FeatureTree_id, scoperestrictions_id)
2795     );
2796
2797     create table PolytomousKey_Taxon (
2798         polytomousKey_fk integer not null,
2799         taxon_fk integer not null,
2800         primary key (polytomousKey_fk, taxon_fk)
2801     );
2802
2803     create table PolytomousKey_Taxon_AUD (
2804         REV integer not null,
2805         polytomousKey_fk integer not null,
2806         taxon_fk integer not null,
2807         revtype tinyint,
2808         primary key (REV, polytomousKey_fk, taxon_fk)
2809     );
2810
2811     create table Reference (
2812         DTYPE varchar(31) not null,
2813         id integer not null,
2814         created timestamp,
2815         uuid varchar(36),
2816         updated timestamp,
2817         lsid_authority varchar(255),
2818         lsid_lsid varchar(255),
2819         lsid_namespace varchar(255),
2820         lsid_object varchar(255),
2821         lsid_revision varchar(255),
2822         protectedtitlecache bit not null,
2823         titleCache varchar(255),
2824         datepublished_end varchar(255),
2825         datepublished_freetext varchar(255),
2826         datepublished_start varchar(255),
2827         edition varchar(255),
2828         editor varchar(255),
2829         isbn varchar(255),
2830         issn varchar(255),
2831         nomenclaturallyrelevant bit not null,
2832         organization varchar(255),
2833         pages varchar(255),
2834         parsingproblem integer not null,
2835         placepublished varchar(255),
2836         problemends integer not null,
2837         problemstarts integer not null,
2838         publisher varchar(255),
2839         referenceAbstract longvarchar,
2840         series varchar(255),
2841         seriespart varchar(255),
2842         title longvarchar,
2843         refType integer,
2844         uri varchar(255),
2845         volume varchar(255),
2846         createdby_id integer,
2847         updatedby_id integer,
2848         authorteam_id integer,
2849         inreference_id integer,
2850         institution_id integer,
2851         school_id integer,
2852         abbreviatedReference_id integer,
2853         fullReference_id integer,
2854         primary key (id),
2855         unique (uuid)
2856     );
2857
2858     create table Reference_AUD (
2859         DTYPE varchar(31) not null,
2860         id integer not null,
2861         REV integer not null,
2862         revtype tinyint,
2863         created timestamp,
2864         uuid varchar(36),
2865         updated timestamp,
2866         lsid_authority varchar(255),
2867         lsid_lsid varchar(255),
2868         lsid_namespace varchar(255),
2869         lsid_object varchar(255),
2870         lsid_revision varchar(255),
2871         protectedtitlecache bit,
2872         titleCache varchar(255),
2873         datepublished_end varchar(255),
2874         datepublished_freetext varchar(255),
2875         datepublished_start varchar(255),
2876         edition varchar(255),
2877         editor varchar(255),
2878         isbn varchar(255),
2879         issn varchar(255),
2880         nomenclaturallyrelevant bit,
2881         organization varchar(255),
2882         pages varchar(255),
2883         parsingproblem integer,
2884         placepublished varchar(255),
2885         problemends integer,
2886         problemstarts integer,
2887         publisher varchar(255),
2888         referenceAbstract longvarchar,
2889         series varchar(255),
2890         seriespart varchar(255),
2891         title longvarchar,
2892         refType integer,
2893         uri varchar(255),
2894         volume varchar(255),
2895         createdby_id integer,
2896         updatedby_id integer,
2897         authorteam_id integer,
2898         inreference_id integer,
2899         institution_id integer,
2900         school_id integer,
2901         abbreviatedReference_id integer,
2902         fullReference_id integer,
2903         primary key (id, REV)
2904     );
2905
2906     create table Reference_Annotation (
2907         Reference_id integer not null,
2908         annotations_id integer not null,
2909         primary key (Reference_id, annotations_id),
2910         unique (annotations_id)
2911     );
2912
2913     create table Reference_Annotation_AUD (
2914         REV integer not null,
2915         Reference_id integer not null,
2916         annotations_id integer not null,
2917         revtype tinyint,
2918         primary key (REV, Reference_id, annotations_id)
2919     );
2920
2921     create table Reference_Credit (
2922         Reference_id integer not null,
2923         credits_id integer not null,
2924         sortIndex integer not null,
2925         primary key (Reference_id, sortIndex),
2926         unique (credits_id)
2927     );
2928
2929     create table Reference_Credit_AUD (
2930         REV integer not null,
2931         Reference_id integer not null,
2932         credits_id integer not null,
2933         sortIndex integer not null,
2934         revtype tinyint,
2935         primary key (REV, Reference_id, credits_id, sortIndex)
2936     );
2937
2938     create table Reference_Extension (
2939         Reference_id integer not null,
2940         extensions_id integer not null,
2941         primary key (Reference_id, extensions_id),
2942         unique (extensions_id)
2943     );
2944
2945     create table Reference_Extension_AUD (
2946         REV integer not null,
2947         Reference_id integer not null,
2948         extensions_id integer not null,
2949         revtype tinyint,
2950         primary key (REV, Reference_id, extensions_id)
2951     );
2952
2953     create table Reference_Marker (
2954         Reference_id integer not null,
2955         markers_id integer not null,
2956         primary key (Reference_id, markers_id),
2957         unique (markers_id)
2958     );
2959
2960     create table Reference_Marker_AUD (
2961         REV integer not null,
2962         Reference_id integer not null,
2963         markers_id integer not null,
2964         revtype tinyint,
2965         primary key (REV, Reference_id, markers_id)
2966     );
2967
2968     create table Reference_Media (
2969         Reference_id integer not null,
2970         media_id integer not null,
2971         primary key (Reference_id, media_id)
2972     );
2973
2974     create table Reference_Media_AUD (
2975         REV integer not null,
2976         Reference_id integer not null,
2977         media_id integer not null,
2978         revtype tinyint,
2979         primary key (REV, Reference_id, media_id)
2980     );
2981
2982     create table Reference_OriginalSourceBase (
2983         Reference_id integer not null,
2984         sources_id integer not null,
2985         primary key (Reference_id, sources_id),
2986         unique (sources_id)
2987     );
2988
2989     create table Reference_OriginalSourceBase_AUD (
2990         REV integer not null,
2991         Reference_id integer not null,
2992         sources_id integer not null,
2993         revtype tinyint,
2994         primary key (REV, Reference_id, sources_id)
2995     );
2996
2997     create table Reference_Rights (
2998         Reference_id integer not null,
2999         rights_id integer not null,
3000         primary key (Reference_id, rights_id),
3001         unique (rights_id)
3002     );
3003
3004     create table Reference_Rights_AUD (
3005         REV integer not null,
3006         Reference_id integer not null,
3007         rights_id integer not null,
3008         revtype tinyint,
3009         primary key (REV, Reference_id, rights_id)
3010     );
3011
3012     create table RelationshipTermBase_inverseRepresentation (
3013         DefinedTermBase_id integer not null,
3014         inverserepresentations_id integer not null,
3015         primary key (DefinedTermBase_id, inverserepresentations_id),
3016         unique (inverserepresentations_id)
3017     );
3018
3019     create table RelationshipTermBase_inverseRepresentation_AUD (
3020         REV integer not null,
3021         DefinedTermBase_id integer not null,
3022         inverserepresentations_id integer not null,
3023         revtype tinyint,
3024         primary key (REV, DefinedTermBase_id, inverserepresentations_id)
3025     );
3026
3027     create table Representation (
3028         id integer not null,
3029         created timestamp,
3030         uuid varchar(36),
3031         updated timestamp,
3032         text longvarchar,
3033         abbreviatedlabel varchar(255),
3034         label varchar(255),
3035         createdby_id integer,
3036         updatedby_id integer,
3037         language_id integer,
3038         primary key (id),
3039         unique (uuid)
3040     );
3041
3042     create table Representation_AUD (
3043         id integer not null,
3044         REV integer not null,
3045         revtype tinyint,
3046         created timestamp,
3047         uuid varchar(36),
3048         updated timestamp,
3049         text longvarchar,
3050         abbreviatedlabel varchar(255),
3051         label varchar(255),
3052         createdby_id integer,
3053         updatedby_id integer,
3054         language_id integer,
3055         primary key (id, REV)
3056     );
3057
3058     create table Representation_Annotation (
3059         Representation_id integer not null,
3060         annotations_id integer not null,
3061         primary key (Representation_id, annotations_id),
3062         unique (annotations_id)
3063     );
3064
3065     create table Representation_Annotation_AUD (
3066         REV integer not null,
3067         Representation_id integer not null,
3068         annotations_id integer not null,
3069         revtype tinyint,
3070         primary key (REV, Representation_id, annotations_id)
3071     );
3072
3073     create table Representation_Marker (
3074         Representation_id integer not null,
3075         markers_id integer not null,
3076         primary key (Representation_id, markers_id),
3077         unique (markers_id)
3078     );
3079
3080     create table Representation_Marker_AUD (
3081         REV integer not null,
3082         Representation_id integer not null,
3083         markers_id integer not null,
3084         revtype tinyint,
3085         primary key (REV, Representation_id, markers_id)
3086     );
3087
3088     create table Rights (
3089         id integer not null,
3090         created timestamp,
3091         uuid varchar(36),
3092         updated timestamp,
3093         text longvarchar,
3094         abbreviatedtext varchar(255),
3095         uri varchar(255),
3096         createdby_id integer,
3097         updatedby_id integer,
3098         language_id integer,
3099         agent_id integer,
3100         type_id integer,
3101         primary key (id),
3102         unique (uuid)
3103     );
3104
3105     create table Rights_AUD (
3106         id integer not null,
3107         REV integer not null,
3108         revtype tinyint,
3109         created timestamp,
3110         uuid varchar(36),
3111         updated timestamp,
3112         text longvarchar,
3113         abbreviatedtext varchar(255),
3114         uri varchar(255),
3115         createdby_id integer,
3116         updatedby_id integer,
3117         language_id integer,
3118         agent_id integer,
3119         type_id integer,
3120         primary key (id, REV)
3121     );
3122
3123     create table Rights_Annotation (
3124         Rights_id integer not null,
3125         annotations_id integer not null,
3126         primary key (Rights_id, annotations_id),
3127         unique (annotations_id)
3128     );
3129
3130     create table Rights_Annotation_AUD (
3131         REV integer not null,
3132         Rights_id integer not null,
3133         annotations_id integer not null,
3134         revtype tinyint,
3135         primary key (REV, Rights_id, annotations_id)
3136     );
3137
3138     create table Rights_Marker (
3139         Rights_id integer not null,
3140         markers_id integer not null,
3141         primary key (Rights_id, markers_id),
3142         unique (markers_id)
3143     );
3144
3145     create table Rights_Marker_AUD (
3146         REV integer not null,
3147         Rights_id integer not null,
3148         markers_id integer not null,
3149         revtype tinyint,
3150         primary key (REV, Rights_id, markers_id)
3151     );
3152
3153     create table Sequence (
3154         id integer not null,
3155         created timestamp,
3156         uuid varchar(36),
3157         updated timestamp,
3158         lsid_authority varchar(255),
3159         lsid_lsid varchar(255),
3160         lsid_namespace varchar(255),
3161         lsid_object varchar(255),
3162         lsid_revision varchar(255),
3163         protectedtitlecache bit not null,
3164         titleCache varchar(255),
3165         barcode bit not null,
3166         citationmicroreference varchar(255),
3167         datesequenced timestamp,
3168         length integer,
3169         sequence varchar(255),
3170         createdby_id integer,
3171         updatedby_id integer,
3172         locus_id integer,
3173         publishedin_id integer,
3174         primary key (id),
3175         unique (uuid)
3176     );
3177
3178     create table Sequence_AUD (
3179         id integer not null,
3180         REV integer not null,
3181         revtype tinyint,
3182         created timestamp,
3183         uuid varchar(36),
3184         updated timestamp,
3185         lsid_authority varchar(255),
3186         lsid_lsid varchar(255),
3187         lsid_namespace varchar(255),
3188         lsid_object varchar(255),
3189         lsid_revision varchar(255),
3190         protectedtitlecache bit,
3191         titleCache varchar(255),
3192         barcode bit,
3193         citationmicroreference varchar(255),
3194         datesequenced timestamp,
3195         length integer,
3196         sequence varchar(255),
3197         createdby_id integer,
3198         updatedby_id integer,
3199         locus_id integer,
3200         publishedin_id integer,
3201         primary key (id, REV)
3202     );
3203
3204     create table Sequence_Annotation (
3205         Sequence_id integer not null,
3206         annotations_id integer not null,
3207         primary key (Sequence_id, annotations_id),
3208         unique (annotations_id)
3209     );
3210
3211     create table Sequence_Annotation_AUD (
3212         REV integer not null,
3213         Sequence_id integer not null,
3214         annotations_id integer not null,
3215         revtype tinyint,
3216         primary key (REV, Sequence_id, annotations_id)
3217     );
3218
3219     create table Sequence_Credit (
3220         Sequence_id integer not null,
3221         credits_id integer not null,
3222         sortIndex integer not null,
3223         primary key (Sequence_id, sortIndex),
3224         unique (credits_id)
3225     );
3226
3227     create table Sequence_Credit_AUD (
3228         REV integer not null,
3229         Sequence_id integer not null,
3230         credits_id integer not null,
3231         sortIndex integer not null,
3232         revtype tinyint,
3233         primary key (REV, Sequence_id, credits_id, sortIndex)
3234     );
3235
3236     create table Sequence_Extension (
3237         Sequence_id integer not null,
3238         extensions_id integer not null,
3239         primary key (Sequence_id, extensions_id),
3240         unique (extensions_id)
3241     );
3242
3243     create table Sequence_Extension_AUD (
3244         REV integer not null,
3245         Sequence_id integer not null,
3246         extensions_id integer not null,
3247         revtype tinyint,
3248         primary key (REV, Sequence_id, extensions_id)
3249     );
3250
3251     create table Sequence_GenBankAccession (
3252         Sequence_id integer not null,
3253         genbankaccession_id integer not null,
3254         primary key (Sequence_id, genbankaccession_id),
3255         unique (genbankaccession_id)
3256     );
3257
3258     create table Sequence_GenBankAccession_AUD (
3259         REV integer not null,
3260         Sequence_id integer not null,
3261         genbankaccession_id integer not null,
3262         revtype tinyint,
3263         primary key (REV, Sequence_id, genbankaccession_id)
3264     );
3265
3266     create table Sequence_Marker (
3267         Sequence_id integer not null,
3268         markers_id integer not null,
3269         primary key (Sequence_id, markers_id),
3270         unique (markers_id)
3271     );
3272
3273     create table Sequence_Marker_AUD (
3274         REV integer not null,
3275         Sequence_id integer not null,
3276         markers_id integer not null,
3277         revtype tinyint,
3278         primary key (REV, Sequence_id, markers_id)
3279     );
3280
3281     create table Sequence_Media (
3282         Sequence_id integer not null,
3283         chromatograms_id integer not null,
3284         primary key (Sequence_id, chromatograms_id),
3285         unique (chromatograms_id)
3286     );
3287
3288     create table Sequence_Media_AUD (
3289         REV integer not null,
3290         Sequence_id integer not null,
3291         chromatograms_id integer not null,
3292         revtype tinyint,
3293         primary key (REV, Sequence_id, chromatograms_id)
3294     );
3295
3296     create table Sequence_OriginalSourceBase (
3297         Sequence_id integer not null,
3298         sources_id integer not null,
3299         primary key (Sequence_id, sources_id),
3300         unique (sources_id)
3301     );
3302
3303     create table Sequence_OriginalSourceBase_AUD (
3304         REV integer not null,
3305         Sequence_id integer not null,
3306         sources_id integer not null,
3307         revtype tinyint,
3308         primary key (REV, Sequence_id, sources_id)
3309     );
3310
3311     create table Sequence_Reference (
3312         Sequence_id integer not null,
3313         citations_id integer not null,
3314         primary key (Sequence_id, citations_id),
3315         unique (citations_id)
3316     );
3317
3318     create table Sequence_Reference_AUD (
3319         REV integer not null,
3320         Sequence_id integer not null,
3321         citations_id integer not null,
3322         revtype tinyint,
3323         primary key (REV, Sequence_id, citations_id)
3324     );
3325
3326     create table Sequence_Rights (
3327         Sequence_id integer not null,
3328         rights_id integer not null,
3329         primary key (Sequence_id, rights_id),
3330         unique (rights_id)
3331     );
3332
3333     create table Sequence_Rights_AUD (
3334         REV integer not null,
3335         Sequence_id integer not null,
3336         rights_id integer not null,
3337         revtype tinyint,
3338         primary key (REV, Sequence_id, rights_id)
3339     );
3340
3341     create table SpecimenOrObservationBase (
3342         DTYPE varchar(31) not null,
3343         id integer not null,
3344         created timestamp,
3345         uuid varchar(36),
3346         updated timestamp,
3347         lsid_authority varchar(255),
3348         lsid_lsid varchar(255),
3349         lsid_namespace varchar(255),
3350         lsid_object varchar(255),
3351         lsid_revision varchar(255),
3352         protectedtitlecache bit not null,
3353         titleCache varchar(255),
3354         individualcount integer,
3355         accessionnumber varchar(255),
3356         catalognumber varchar(255),
3357         collectorsnumber varchar(255),
3358         fieldnotes varchar(255),
3359         fieldnumber varchar(255),
3360         createdby_id integer,
3361         updatedby_id integer,
3362         lifestage_id integer,
3363         sex_id integer,
3364         collection_id integer,
3365         derivationevent_id integer,
3366         storedunder_id integer,
3367         preservation_id integer,
3368         gatheringevent_id integer,
3369         primary key (id),
3370         unique (uuid)
3371     );
3372
3373     create table SpecimenOrObservationBase_AUD (
3374         DTYPE varchar(31) not null,
3375         id integer not null,
3376         REV integer not null,
3377         revtype tinyint,
3378         created timestamp,
3379         uuid varchar(36),
3380         updated timestamp,
3381         lsid_authority varchar(255),
3382         lsid_lsid varchar(255),
3383         lsid_namespace varchar(255),
3384         lsid_object varchar(255),
3385         lsid_revision varchar(255),
3386         protectedtitlecache bit,
3387         titleCache varchar(255),
3388         individualcount integer,
3389         createdby_id integer,
3390         updatedby_id integer,
3391         lifestage_id integer,
3392         sex_id integer,
3393         fieldnotes varchar(255),
3394         fieldnumber varchar(255),
3395         gatheringevent_id integer,
3396         accessionnumber varchar(255),
3397         catalognumber varchar(255),
3398         collectorsnumber varchar(255),
3399         collection_id integer,
3400         derivationevent_id integer,
3401         storedunder_id integer,
3402         preservation_id integer,
3403         primary key (id, REV)
3404     );
3405
3406     create table SpecimenOrObservationBase_Annotation (
3407         SpecimenOrObservationBase_id integer not null,
3408         annotations_id integer not null,
3409         primary key (SpecimenOrObservationBase_id, annotations_id),
3410         unique (annotations_id)
3411     );
3412
3413     create table SpecimenOrObservationBase_Annotation_AUD (
3414         REV integer not null,
3415         SpecimenOrObservationBase_id integer not null,
3416         annotations_id integer not null,
3417         revtype tinyint,
3418         primary key (REV, SpecimenOrObservationBase_id, annotations_id)
3419     );
3420
3421     create table SpecimenOrObservationBase_Credit (
3422         SpecimenOrObservationBase_id integer not null,
3423         credits_id integer not null,
3424         sortIndex integer not null,
3425         primary key (SpecimenOrObservationBase_id, sortIndex),
3426         unique (credits_id)
3427     );
3428
3429     create table SpecimenOrObservationBase_Credit_AUD (
3430         REV integer not null,
3431         SpecimenOrObservationBase_id integer not null,
3432         credits_id integer not null,
3433         sortIndex integer not null,
3434         revtype tinyint,
3435         primary key (REV, SpecimenOrObservationBase_id, credits_id, sortIndex)
3436     );
3437
3438     create table SpecimenOrObservationBase_DerivationEvent (
3439         originals_id integer not null,
3440         derivationevents_id integer not null,
3441         primary key (originals_id, derivationevents_id)
3442     );
3443
3444     create table SpecimenOrObservationBase_DerivationEvent_AUD (
3445         REV integer not null,
3446         originals_id integer not null,
3447         derivationevents_id integer not null,
3448         revtype tinyint,
3449         primary key (REV, originals_id, derivationevents_id)
3450     );
3451
3452     create table SpecimenOrObservationBase_Extension (
3453         SpecimenOrObservationBase_id integer not null,
3454         extensions_id integer not null,
3455         primary key (SpecimenOrObservationBase_id, extensions_id),
3456         unique (extensions_id)
3457     );
3458
3459     create table SpecimenOrObservationBase_Extension_AUD (
3460         REV integer not null,
3461         SpecimenOrObservationBase_id integer not null,
3462         extensions_id integer not null,
3463         revtype tinyint,
3464         primary key (REV, SpecimenOrObservationBase_id, extensions_id)
3465     );
3466
3467     create table SpecimenOrObservationBase_LanguageString (
3468         SpecimenOrObservationBase_id integer not null,
3469         description_id integer not null,
3470         description_mapkey_id integer not null,
3471         primary key (SpecimenOrObservationBase_id, description_mapkey_id),
3472         unique (description_id)
3473     );
3474
3475     create table SpecimenOrObservationBase_LanguageString_AUD (
3476         REV integer not null,
3477         SpecimenOrObservationBase_id integer not null,
3478         description_id integer not null,
3479         description_mapkey_id integer not null,
3480         revtype tinyint,
3481         primary key (REV, SpecimenOrObservationBase_id, description_id, description_mapkey_id)
3482     );
3483
3484     create table SpecimenOrObservationBase_Marker (
3485         SpecimenOrObservationBase_id integer not null,
3486         markers_id integer not null,
3487         primary key (SpecimenOrObservationBase_id, markers_id),
3488         unique (markers_id)
3489     );
3490
3491     create table SpecimenOrObservationBase_Marker_AUD (
3492         REV integer not null,
3493         SpecimenOrObservationBase_id integer not null,
3494         markers_id integer not null,
3495         revtype tinyint,
3496         primary key (REV, SpecimenOrObservationBase_id, markers_id)
3497     );
3498
3499     create table SpecimenOrObservationBase_Media (
3500         SpecimenOrObservationBase_id integer not null,
3501         media_id integer not null,
3502         primary key (SpecimenOrObservationBase_id, media_id)
3503     );
3504
3505     create table SpecimenOrObservationBase_Media_AUD (
3506         REV integer not null,
3507         SpecimenOrObservationBase_id integer not null,
3508         media_id integer not null,
3509         revtype tinyint,
3510         primary key (REV, SpecimenOrObservationBase_id, media_id)
3511     );
3512
3513     create table SpecimenOrObservationBase_OriginalSourceBase (
3514         SpecimenOrObservationBase_id integer not null,
3515         sources_id integer not null,
3516         primary key (SpecimenOrObservationBase_id, sources_id),
3517         unique (sources_id)
3518     );
3519
3520     create table SpecimenOrObservationBase_OriginalSourceBase_AUD (
3521         REV integer not null,
3522         SpecimenOrObservationBase_id integer not null,
3523         sources_id integer not null,
3524         revtype tinyint,
3525         primary key (REV, SpecimenOrObservationBase_id, sources_id)
3526     );
3527
3528     create table SpecimenOrObservationBase_Rights (
3529         SpecimenOrObservationBase_id integer not null,
3530         rights_id integer not null,
3531         primary key (SpecimenOrObservationBase_id, rights_id),
3532         unique (rights_id)
3533     );
3534
3535     create table SpecimenOrObservationBase_Rights_AUD (
3536         REV integer not null,
3537         SpecimenOrObservationBase_id integer not null,
3538         rights_id integer not null,
3539         revtype tinyint,
3540         primary key (REV, SpecimenOrObservationBase_id, rights_id)
3541     );
3542
3543     create table SpecimenOrObservationBase_Sequence (
3544         SpecimenOrObservationBase_id integer not null,
3545         sequences_id integer not null,
3546         primary key (SpecimenOrObservationBase_id, sequences_id),
3547         unique (sequences_id)
3548     );
3549
3550     create table SpecimenOrObservationBase_Sequence_AUD (
3551         REV integer not null,
3552         SpecimenOrObservationBase_id integer not null,
3553         sequences_id integer not null,
3554         revtype tinyint,
3555         primary key (REV, SpecimenOrObservationBase_id, sequences_id)
3556     );
3557
3558     create table StateData (
3559         id integer not null,
3560         created timestamp,
3561         uuid varchar(36),
3562         updated timestamp,
3563         createdby_id integer,
3564         updatedby_id integer,
3565         state_id integer,
3566         primary key (id),
3567         unique (uuid)
3568     );
3569
3570     create table StateData_AUD (
3571         id integer not null,
3572         REV integer not null,
3573         revtype tinyint,
3574         created timestamp,
3575         uuid varchar(36),
3576         updated timestamp,
3577         createdby_id integer,
3578         updatedby_id integer,
3579         state_id integer,
3580         primary key (id, REV)
3581     );
3582
3583     create table StateData_DefinedTermBase (
3584         StateData_id integer not null,
3585         modifiers_id integer not null,
3586         primary key (StateData_id, modifiers_id),
3587         unique (modifiers_id)
3588     );
3589
3590     create table StateData_DefinedTermBase_AUD (
3591         REV integer not null,
3592         StateData_id integer not null,
3593         modifiers_id integer not null,
3594         revtype tinyint,
3595         primary key (REV, StateData_id, modifiers_id)
3596     );
3597
3598     create table StateData_LanguageString (
3599         StateData_id integer not null,
3600         modifyingtext_id integer not null,
3601         modifyingtext_mapkey_id integer not null,
3602         primary key (StateData_id, modifyingtext_mapkey_id),
3603         unique (modifyingtext_id)
3604     );
3605
3606     create table StateData_LanguageString_AUD (
3607         REV integer not null,
3608         StateData_id integer not null,
3609         modifyingtext_id integer not null,
3610         modifyingtext_mapkey_id integer not null,
3611         revtype tinyint,
3612         primary key (REV, StateData_id, modifyingtext_id, modifyingtext_mapkey_id)
3613     );
3614
3615     create table StatisticalMeasurementValue (
3616         id integer not null,
3617         created timestamp,
3618         uuid varchar(36),
3619         updated timestamp,
3620         value float not null,
3621         createdby_id integer,
3622         updatedby_id integer,
3623         type_id integer,
3624         primary key (id),
3625         unique (uuid)
3626     );
3627
3628     create table StatisticalMeasurementValue_AUD (
3629         id integer not null,
3630         REV integer not null,
3631         revtype tinyint,
3632         created timestamp,
3633         uuid varchar(36),
3634         updated timestamp,
3635         value float,
3636         createdby_id integer,
3637         updatedby_id integer,
3638         type_id integer,
3639         primary key (id, REV)
3640     );
3641
3642     create table StatisticalMeasurementValue_DefinedTermBase (
3643         StatisticalMeasurementValue_id integer not null,
3644         modifiers_id integer not null,
3645         primary key (StatisticalMeasurementValue_id, modifiers_id),
3646         unique (modifiers_id)
3647     );
3648
3649     create table StatisticalMeasurementValue_DefinedTermBase_AUD (
3650         REV integer not null,
3651         StatisticalMeasurementValue_id integer not null,
3652         modifiers_id integer not null,
3653         revtype tinyint,
3654         primary key (REV, StatisticalMeasurementValue_id, modifiers_id)
3655     );
3656
3657     create table SynonymRelationship (
3658         id integer not null,
3659         created timestamp,
3660         uuid varchar(36),
3661         updated timestamp,
3662         citationmicroreference varchar(255),
3663         originalnamestring varchar(255),
3664         doubtful bit not null,
3665         partial bit not null,
3666         proparte bit not null,
3667         createdby_id integer,
3668         updatedby_id integer,
3669         citation_id integer,
3670         relatedfrom_id integer,
3671         relatedto_id integer,
3672         type_id integer,
3673         primary key (id),
3674         unique (uuid)
3675     );
3676
3677     create table SynonymRelationship_AUD (
3678         id integer not null,
3679         REV integer not null,
3680         revtype tinyint,
3681         created timestamp,
3682         uuid varchar(36),
3683         updated timestamp,
3684         citationmicroreference varchar(255),
3685         originalnamestring varchar(255),
3686         doubtful bit,
3687         partial bit,
3688         proparte bit,
3689         createdby_id integer,
3690         updatedby_id integer,
3691         citation_id integer,
3692         relatedfrom_id integer,
3693         relatedto_id integer,
3694         type_id integer,
3695         primary key (id, REV)
3696     );
3697
3698     create table SynonymRelationship_Annotation (
3699         SynonymRelationship_id integer not null,
3700         annotations_id integer not null,
3701         primary key (SynonymRelationship_id, annotations_id),
3702         unique (annotations_id)
3703     );
3704
3705     create table SynonymRelationship_Annotation_AUD (
3706         REV integer not null,
3707         SynonymRelationship_id integer not null,
3708         annotations_id integer not null,
3709         revtype tinyint,
3710         primary key (REV, SynonymRelationship_id, annotations_id)
3711     );
3712
3713     create table SynonymRelationship_Marker (
3714         SynonymRelationship_id integer not null,
3715         markers_id integer not null,
3716         primary key (SynonymRelationship_id, markers_id),
3717         unique (markers_id)
3718     );
3719
3720     create table SynonymRelationship_Marker_AUD (
3721         REV integer not null,
3722         SynonymRelationship_id integer not null,
3723         markers_id integer not null,
3724         revtype tinyint,
3725         primary key (REV, SynonymRelationship_id, markers_id)
3726     );
3727
3728     create table TaxonBase (
3729         DTYPE varchar(31) not null,
3730         id integer not null,
3731         created timestamp,
3732         uuid varchar(36),
3733         updated timestamp,
3734         lsid_authority varchar(255),
3735         lsid_lsid varchar(255),
3736         lsid_namespace varchar(255),
3737         lsid_object varchar(255),
3738         lsid_revision varchar(255),
3739         protectedtitlecache bit not null,
3740         titleCache varchar(255),
3741         appendedphrase varchar(255),
3742         doubtful bit not null,
3743         usenamecache bit not null,
3744         taxonstatusunknown bit,
3745         taxonomicchildrencount integer,
3746         createdby_id integer,
3747         updatedby_id integer,
3748         taxonName_fk integer,
3749         sec_id integer,
3750         taxonomicparentcache_id integer,
3751         primary key (id),
3752         unique (uuid)
3753     );
3754
3755     create table TaxonBase_AUD (
3756         DTYPE varchar(31) not null,
3757         id integer not null,
3758         REV integer not null,
3759         revtype tinyint,
3760         created timestamp,
3761         uuid varchar(36),
3762         updated timestamp,
3763         lsid_authority varchar(255),
3764         lsid_lsid varchar(255),
3765         lsid_namespace varchar(255),
3766         lsid_object varchar(255),
3767         lsid_revision varchar(255),
3768         protectedtitlecache bit,
3769         titleCache varchar(255),
3770         appendedphrase varchar(255),
3771         doubtful bit,
3772         usenamecache bit,
3773         createdby_id integer,
3774         updatedby_id integer,
3775         taxonName_fk integer,
3776         sec_id integer,
3777         taxonstatusunknown bit,
3778         taxonomicchildrencount integer,
3779         taxonomicparentcache_id integer,
3780         primary key (id, REV)
3781     );
3782
3783     create table TaxonBase_Annotation (
3784         TaxonBase_id integer not null,
3785         annotations_id integer not null,
3786         primary key (TaxonBase_id, annotations_id),
3787         unique (annotations_id)
3788     );
3789
3790     create table TaxonBase_Annotation_AUD (
3791         REV integer not null,
3792         TaxonBase_id integer not null,
3793         annotations_id integer not null,
3794         revtype tinyint,
3795         primary key (REV, TaxonBase_id, annotations_id)
3796     );
3797
3798     create table TaxonBase_Credit (
3799         TaxonBase_id integer not null,
3800         credits_id integer not null,
3801         sortIndex integer not null,
3802         primary key (TaxonBase_id, sortIndex),
3803         unique (credits_id)
3804     );
3805
3806     create table TaxonBase_Credit_AUD (
3807         REV integer not null,
3808         TaxonBase_id integer not null,
3809         credits_id integer not null,
3810         sortIndex integer not null,
3811         revtype tinyint,
3812         primary key (REV, TaxonBase_id, credits_id, sortIndex)
3813     );
3814
3815     create table TaxonBase_Extension (
3816         TaxonBase_id integer not null,
3817         extensions_id integer not null,
3818         primary key (TaxonBase_id, extensions_id),
3819         unique (extensions_id)
3820     );
3821
3822     create table TaxonBase_Extension_AUD (
3823         REV integer not null,
3824         TaxonBase_id integer not null,
3825         extensions_id integer not null,
3826         revtype tinyint,
3827         primary key (REV, TaxonBase_id, extensions_id)
3828     );
3829
3830     create table TaxonBase_Marker (
3831         TaxonBase_id integer not null,
3832         markers_id integer not null,
3833         primary key (TaxonBase_id, markers_id),
3834         unique (markers_id)
3835     );
3836
3837     create table TaxonBase_Marker_AUD (
3838         REV integer not null,
3839         TaxonBase_id integer not null,
3840         markers_id integer not null,
3841         revtype tinyint,
3842         primary key (REV, TaxonBase_id, markers_id)
3843     );
3844
3845     create table TaxonBase_OriginalSourceBase (
3846         TaxonBase_id integer not null,
3847         sources_id integer not null,
3848         primary key (TaxonBase_id, sources_id),
3849         unique (sources_id)
3850     );
3851
3852     create table TaxonBase_OriginalSourceBase_AUD (
3853         REV integer not null,
3854         TaxonBase_id integer not null,
3855         sources_id integer not null,
3856         revtype tinyint,
3857         primary key (REV, TaxonBase_id, sources_id)
3858     );
3859
3860     create table TaxonBase_Rights (
3861         TaxonBase_id integer not null,
3862         rights_id integer not null,
3863         primary key (TaxonBase_id, rights_id),
3864         unique (rights_id)
3865     );
3866
3867     create table TaxonBase_Rights_AUD (
3868         REV integer not null,
3869         TaxonBase_id integer not null,
3870         rights_id integer not null,
3871         revtype tinyint,
3872         primary key (REV, TaxonBase_id, rights_id)
3873     );
3874
3875     create table TaxonInteraction_LanguageString (
3876         DescriptionElementBase_id integer not null,
3877         description_id integer not null,
3878         description_mapkey_id integer not null,
3879         primary key (DescriptionElementBase_id, description_mapkey_id),
3880         unique (description_id)
3881     );
3882
3883     create table TaxonInteraction_LanguageString_AUD (
3884         REV integer not null,
3885         DescriptionElementBase_id integer not null,
3886         description_id integer not null,
3887         description_mapkey_id integer not null,
3888         revtype tinyint,
3889         primary key (REV, DescriptionElementBase_id, description_id, description_mapkey_id)
3890     );
3891
3892     create table TaxonNameBase (
3893         DTYPE varchar(31) not null,
3894         id integer not null,
3895         created timestamp,
3896         uuid varchar(36),
3897         updated timestamp,
3898         lsid_authority varchar(255),
3899         lsid_lsid varchar(255),
3900         lsid_namespace varchar(255),
3901         lsid_object varchar(255),
3902         lsid_revision varchar(255),
3903         protectedtitlecache bit not null,
3904         titleCache varchar(255),
3905         appendedphrase varchar(255),
3906         fullTitleCache varchar(330),
3907         nomenclaturalmicroreference varchar(255),
3908         parsingproblem integer not null,
3909         problemends integer not null,
3910         problemstarts integer not null,
3911         protectedfulltitlecache bit not null,
3912         authorshipcache varchar(255),
3913         binomhybrid bit,
3914         genusoruninomial varchar(255),
3915         hybridformula bit,
3916         infragenericepithet varchar(255),
3917         infraspecificepithet varchar(255),
3918         monomhybrid bit,
3919         namecache varchar(255),
3920         protectedauthorshipcache bit,
3921         protectednamecache bit,
3922         specificepithet varchar(255),
3923         trinomhybrid bit,
3924         nameapprobation varchar(255),
3925         subgenusauthorship varchar(255),
3926         anamorphic bit,
3927         cultivarname varchar(255),
3928         acronym varchar(255),
3929         breed varchar(255),
3930         originalpublicationyear integer,
3931         publicationyear integer,
3932         createdby_id integer,
3933         updatedby_id integer,
3934         homotypicalgroup_id integer,
3935         nomenclaturalreference_id integer,
3936         rank_id integer,
3937         basionymauthorteam_id integer,
3938         combinationauthorteam_id integer,
3939         exbasionymauthorteam_id integer,
3940         excombinationauthorteam_id integer,
3941         primary key (id),
3942         unique (uuid)
3943     );
3944
3945     create table TaxonNameBase_AUD (
3946         DTYPE varchar(31) not null,
3947         id integer not null,
3948         REV integer not null,
3949         revtype tinyint,
3950         created timestamp,
3951         uuid varchar(36),
3952         updated timestamp,
3953         lsid_authority varchar(255),
3954         lsid_lsid varchar(255),
3955         lsid_namespace varchar(255),
3956         lsid_object varchar(255),
3957         lsid_revision varchar(255),
3958         protectedtitlecache bit,
3959         titleCache varchar(255),
3960         appendedphrase varchar(255),
3961         fullTitleCache varchar(330),
3962         nomenclaturalmicroreference varchar(255),
3963         parsingproblem integer,
3964         problemends integer,
3965         problemstarts integer,
3966         protectedfulltitlecache bit,
3967         createdby_id integer,
3968         updatedby_id integer,
3969         homotypicalgroup_id integer,
3970         nomenclaturalreference_id integer,
3971         rank_id integer,
3972         acronym varchar(255),
3973         authorshipcache varchar(255),
3974         binomhybrid bit,
3975         genusoruninomial varchar(255),
3976         hybridformula bit,
3977         infragenericepithet varchar(255),
3978         infraspecificepithet varchar(255),
3979         monomhybrid bit,
3980         namecache varchar(255),
3981         protectedauthorshipcache bit,
3982         protectednamecache bit,
3983         specificepithet varchar(255),
3984         trinomhybrid bit,
3985         basionymauthorteam_id integer,
3986         combinationauthorteam_id integer,
3987         exbasionymauthorteam_id integer,
3988         excombinationauthorteam_id integer,
3989         anamorphic bit,
3990         breed varchar(255),
3991         originalpublicationyear integer,
3992         publicationyear integer,
3993         cultivarname varchar(255),
3994         nameapprobation varchar(255),
3995         subgenusauthorship varchar(255),
3996         primary key (id, REV)
3997     );
3998
3999     create table TaxonNameBase_Annotation (
4000         TaxonNameBase_id integer not null,
4001         annotations_id integer not null,
4002         primary key (TaxonNameBase_id, annotations_id),
4003         unique (annotations_id)
4004     );
4005
4006     create table TaxonNameBase_Annotation_AUD (
4007         REV integer not null,
4008         TaxonNameBase_id integer not null,
4009         annotations_id integer not null,
4010         revtype tinyint,
4011         primary key (REV, TaxonNameBase_id, annotations_id)
4012     );
4013
4014     create table TaxonNameBase_Credit (
4015         TaxonNameBase_id integer not null,
4016         credits_id integer not null,
4017         sortIndex integer not null,
4018         primary key (TaxonNameBase_id, sortIndex),
4019         unique (credits_id)
4020     );
4021
4022     create table TaxonNameBase_Credit_AUD (
4023         REV integer not null,
4024         TaxonNameBase_id integer not null,
4025         credits_id integer not null,
4026         sortIndex integer not null,
4027         revtype tinyint,
4028         primary key (REV, TaxonNameBase_id, credits_id, sortIndex)
4029     );
4030
4031     create table TaxonNameBase_Extension (
4032         TaxonNameBase_id integer not null,
4033         extensions_id integer not null,
4034         primary key (TaxonNameBase_id, extensions_id),
4035         unique (extensions_id)
4036     );
4037
4038     create table TaxonNameBase_Extension_AUD (
4039         REV integer not null,
4040         TaxonNameBase_id integer not null,
4041         extensions_id integer not null,
4042         revtype tinyint,
4043         primary key (REV, TaxonNameBase_id, extensions_id)
4044     );
4045
4046     create table TaxonNameBase_Marker (
4047         TaxonNameBase_id integer not null,
4048         markers_id integer not null,
4049         primary key (TaxonNameBase_id, markers_id),
4050         unique (markers_id)
4051     );
4052
4053     create table TaxonNameBase_Marker_AUD (
4054         REV integer not null,
4055         TaxonNameBase_id integer not null,
4056         markers_id integer not null,
4057         revtype tinyint,
4058         primary key (REV, TaxonNameBase_id, markers_id)
4059     );
4060
4061     create table TaxonNameBase_NomenclaturalStatus (
4062         TaxonNameBase_id integer not null,
4063         status_id integer not null,
4064         primary key (TaxonNameBase_id, status_id),
4065         unique (status_id)
4066     );
4067
4068     create table TaxonNameBase_NomenclaturalStatus_AUD (
4069         REV integer not null,
4070         TaxonNameBase_id integer not null,
4071         status_id integer not null,
4072         revtype tinyint,
4073         primary key (REV, TaxonNameBase_id, status_id)
4074     );
4075
4076     create table TaxonNameBase_OriginalSourceBase (
4077         TaxonNameBase_id integer not null,
4078         sources_id integer not null,
4079         primary key (TaxonNameBase_id, sources_id),
4080         unique (sources_id)
4081     );
4082
4083     create table TaxonNameBase_OriginalSourceBase_AUD (
4084         REV integer not null,
4085         TaxonNameBase_id integer not null,
4086         sources_id integer not null,
4087         revtype tinyint,
4088         primary key (REV, TaxonNameBase_id, sources_id)
4089     );
4090
4091     create table TaxonNameBase_Rights (
4092         TaxonNameBase_id integer not null,
4093         rights_id integer not null,
4094         primary key (TaxonNameBase_id, rights_id),
4095         unique (rights_id)
4096     );
4097
4098     create table TaxonNameBase_Rights_AUD (
4099         REV integer not null,
4100         TaxonNameBase_id integer not null,
4101         rights_id integer not null,
4102         revtype tinyint,
4103         primary key (REV, TaxonNameBase_id, rights_id)
4104     );
4105
4106     create table TaxonNameBase_TypeDesignationBase (
4107         TaxonNameBase_id integer not null,
4108         typedesignations_id integer not null,
4109         primary key (TaxonNameBase_id, typedesignations_id)
4110     );
4111
4112     create table TaxonNameBase_TypeDesignationBase_AUD (
4113         REV integer not null,
4114         TaxonNameBase_id integer not null,
4115         typedesignations_id integer not null,
4116         revtype tinyint,
4117         primary key (REV, TaxonNameBase_id, typedesignations_id)
4118     );
4119
4120     create table TaxonNode (
4121         id integer not null,
4122         created timestamp,
4123         uuid varchar(36),
4124         updated timestamp,
4125         countchildren integer not null,
4126         microreferenceforparentchildrelation varchar(255),
4127         createdby_id integer,
4128         updatedby_id integer,
4129         parent_id integer,
4130         referenceforparentchildrelation_id integer,
4131         synonymtobeused_id integer,
4132         taxon_id integer,
4133         taxonomictree_id integer,
4134         primary key (id),
4135         unique (uuid)
4136     );
4137
4138     create table TaxonNode_AUD (
4139         id integer not null,
4140         REV integer not null,
4141         revtype tinyint,
4142         created timestamp,
4143         uuid varchar(36),
4144         updated timestamp,
4145         countchildren integer,
4146         microreferenceforparentchildrelation varchar(255),
4147         createdby_id integer,
4148         updatedby_id integer,
4149         parent_id integer,
4150         referenceforparentchildrelation_id integer,
4151         synonymtobeused_id integer,
4152         taxon_id integer,
4153         taxonomictree_id integer,
4154         primary key (id, REV)
4155     );
4156
4157     create table TaxonNode_Annotation (
4158         TaxonNode_id integer not null,
4159         annotations_id integer not null,
4160         primary key (TaxonNode_id, annotations_id),
4161         unique (annotations_id)
4162     );
4163
4164     create table TaxonNode_Annotation_AUD (
4165         REV integer not null,
4166         TaxonNode_id integer not null,
4167         annotations_id integer not null,
4168         revtype tinyint,
4169         primary key (REV, TaxonNode_id, annotations_id)
4170     );
4171
4172     create table TaxonNode_Marker (
4173         TaxonNode_id integer not null,
4174         markers_id integer not null,
4175         primary key (TaxonNode_id, markers_id),
4176         unique (markers_id)
4177     );
4178
4179     create table TaxonNode_Marker_AUD (
4180         REV integer not null,
4181         TaxonNode_id integer not null,
4182         markers_id integer not null,
4183         revtype tinyint,
4184         primary key (REV, TaxonNode_id, markers_id)
4185     );
4186
4187     create table TaxonRelationship (
4188         id integer not null,
4189         created timestamp,
4190         uuid varchar(36),
4191         updated timestamp,
4192         citationmicroreference varchar(255),
4193         originalnamestring varchar(255),
4194         doubtful bit not null,
4195         createdby_id integer,
4196         updatedby_id integer,
4197         citation_id integer,
4198         relatedfrom_id integer,
4199         relatedto_id integer,
4200         type_id integer,
4201         primary key (id),
4202         unique (uuid)
4203     );
4204
4205     create table TaxonRelationship_AUD (
4206         id integer not null,
4207         REV integer not null,
4208         revtype tinyint,
4209         created timestamp,
4210         uuid varchar(36),
4211         updated timestamp,
4212         citationmicroreference varchar(255),
4213         originalnamestring varchar(255),
4214         doubtful bit,
4215         createdby_id integer,
4216         updatedby_id integer,
4217         citation_id integer,
4218         relatedfrom_id integer,
4219         relatedto_id integer,
4220         type_id integer,
4221         primary key (id, REV)
4222     );
4223
4224     create table TaxonRelationship_Annotation (
4225         TaxonRelationship_id integer not null,
4226         annotations_id integer not null,
4227         primary key (TaxonRelationship_id, annotations_id),
4228         unique (annotations_id)
4229     );
4230
4231     create table TaxonRelationship_Annotation_AUD (
4232         REV integer not null,
4233         TaxonRelationship_id integer not null,
4234         annotations_id integer not null,
4235         revtype tinyint,
4236         primary key (REV, TaxonRelationship_id, annotations_id)
4237     );
4238
4239     create table TaxonRelationship_Marker (
4240         TaxonRelationship_id integer not null,
4241         markers_id integer not null,
4242         primary key (TaxonRelationship_id, markers_id),
4243         unique (markers_id)
4244     );
4245
4246     create table TaxonRelationship_Marker_AUD (
4247         REV integer not null,
4248         TaxonRelationship_id integer not null,
4249         markers_id integer not null,
4250         revtype tinyint,
4251         primary key (REV, TaxonRelationship_id, markers_id)
4252     );
4253
4254     create table TaxonomicTree (
4255         id integer not null,
4256         created timestamp,
4257         uuid varchar(36),
4258         updated timestamp,
4259         lsid_authority varchar(255),
4260         lsid_lsid varchar(255),
4261         lsid_namespace varchar(255),
4262         lsid_object varchar(255),
4263         lsid_revision varchar(255),
4264         protectedtitlecache bit not null,
4265         titleCache varchar(255),
4266         microreference varchar(255),
4267         createdby_id integer,
4268         updatedby_id integer,
4269         name_id integer,
4270         reference_id integer,
4271         primary key (id),
4272         unique (uuid)
4273     );
4274
4275     create table TaxonomicTree_AUD (
4276         id integer not null,
4277         REV integer not null,
4278         revtype tinyint,
4279         created timestamp,
4280         uuid varchar(36),
4281         updated timestamp,
4282         lsid_authority varchar(255),
4283         lsid_lsid varchar(255),
4284         lsid_namespace varchar(255),
4285         lsid_object varchar(255),
4286         lsid_revision varchar(255),
4287         protectedtitlecache bit,
4288         titleCache varchar(255),
4289         microreference varchar(255),
4290         createdby_id integer,
4291         updatedby_id integer,
4292         name_id integer,
4293         reference_id integer,
4294         primary key (id, REV)
4295     );
4296
4297     create table TaxonomicTree_Annotation (
4298         TaxonomicTree_id integer not null,
4299         annotations_id integer not null,
4300         primary key (TaxonomicTree_id, annotations_id),
4301         unique (annotations_id)
4302     );
4303
4304     create table TaxonomicTree_Annotation_AUD (
4305         REV integer not null,
4306         TaxonomicTree_id integer not null,
4307         annotations_id integer not null,
4308         revtype tinyint,
4309         primary key (REV, TaxonomicTree_id, annotations_id)
4310     );
4311
4312     create table TaxonomicTree_Credit (
4313         TaxonomicTree_id integer not null,
4314         credits_id integer not null,
4315         sortIndex integer not null,
4316         primary key (TaxonomicTree_id, sortIndex),
4317         unique (credits_id)
4318     );
4319
4320     create table TaxonomicTree_Credit_AUD (
4321         REV integer not null,
4322         TaxonomicTree_id integer not null,
4323         credits_id integer not null,
4324         sortIndex integer not null,
4325         revtype tinyint,
4326         primary key (REV, TaxonomicTree_id, credits_id, sortIndex)
4327     );
4328
4329     create table TaxonomicTree_Extension (
4330         TaxonomicTree_id integer not null,
4331         extensions_id integer not null,
4332         primary key (TaxonomicTree_id, extensions_id),
4333         unique (extensions_id)
4334     );
4335
4336     create table TaxonomicTree_Extension_AUD (
4337         REV integer not null,
4338         TaxonomicTree_id integer not null,
4339         extensions_id integer not null,
4340         revtype tinyint,
4341         primary key (REV, TaxonomicTree_id, extensions_id)
4342     );
4343
4344     create table TaxonomicTree_Marker (
4345         TaxonomicTree_id integer not null,
4346         markers_id integer not null,
4347         primary key (TaxonomicTree_id, markers_id),
4348         unique (markers_id)
4349     );
4350
4351     create table TaxonomicTree_Marker_AUD (
4352         REV integer not null,
4353         TaxonomicTree_id integer not null,
4354         markers_id integer not null,
4355         revtype tinyint,
4356         primary key (REV, TaxonomicTree_id, markers_id)
4357     );
4358
4359     create table TaxonomicTree_OriginalSourceBase (
4360         TaxonomicTree_id integer not null,
4361         sources_id integer not null,
4362         primary key (TaxonomicTree_id, sources_id),
4363         unique (sources_id)
4364     );
4365
4366     create table TaxonomicTree_OriginalSourceBase_AUD (
4367         REV integer not null,
4368         TaxonomicTree_id integer not null,
4369         sources_id integer not null,
4370         revtype tinyint,
4371         primary key (REV, TaxonomicTree_id, sources_id)
4372     );
4373
4374     create table TaxonomicTree_Rights (
4375         TaxonomicTree_id integer not null,
4376         rights_id integer not null,
4377         primary key (TaxonomicTree_id, rights_id),
4378         unique (rights_id)
4379     );
4380
4381     create table TaxonomicTree_Rights_AUD (
4382         REV integer not null,
4383         TaxonomicTree_id integer not null,
4384         rights_id integer not null,
4385         revtype tinyint,
4386         primary key (REV, TaxonomicTree_id, rights_id)
4387     );
4388
4389     create table TaxonomicTree_TaxonNode (
4390         TaxonomicTree_id integer not null,
4391         rootnodes_id integer not null,
4392         primary key (TaxonomicTree_id, rootnodes_id),
4393         unique (rootnodes_id)
4394     );
4395
4396     create table TaxonomicTree_TaxonNode_AUD (
4397         REV integer not null,
4398         TaxonomicTree_id integer not null,
4399         rootnodes_id integer not null,
4400         revtype tinyint,
4401         primary key (REV, TaxonomicTree_id, rootnodes_id)
4402     );
4403
4404     create table TermVocabulary (
4405         DTYPE varchar(31) not null,
4406         id integer not null,
4407         created timestamp,
4408         uuid varchar(36),
4409         updated timestamp,
4410         lsid_authority varchar(255),
4411         lsid_lsid varchar(255),
4412         lsid_namespace varchar(255),
4413         lsid_object varchar(255),
4414         lsid_revision varchar(255),
4415         protectedtitlecache bit not null,
4416         titleCache varchar(255),
4417         uri varchar(255),
4418         termsourceuri varchar(255),
4419         createdby_id integer,
4420         updatedby_id integer,
4421         primary key (id),
4422         unique (uuid)
4423     );
4424
4425     create table TermVocabulary_AUD (
4426         DTYPE varchar(31) not null,
4427         id integer not null,
4428         REV integer not null,
4429         revtype tinyint,
4430         created timestamp,
4431         uuid varchar(36),
4432         updated timestamp,
4433         lsid_authority varchar(255),
4434         lsid_lsid varchar(255),
4435         lsid_namespace varchar(255),
4436         lsid_object varchar(255),
4437         lsid_revision varchar(255),
4438         protectedtitlecache bit,
4439         titleCache varchar(255),
4440         uri varchar(255),
4441         termsourceuri varchar(255),
4442         createdby_id integer,
4443         updatedby_id integer,
4444         primary key (id, REV)
4445     );
4446
4447     create table TermVocabulary_Annotation (
4448         TermVocabulary_id integer not null,
4449         annotations_id integer not null,
4450         primary key (TermVocabulary_id, annotations_id),
4451         unique (annotations_id)
4452     );
4453
4454     create table TermVocabulary_Annotation_AUD (
4455         REV integer not null,
4456         TermVocabulary_id integer not null,
4457         annotations_id integer not null,
4458         revtype tinyint,
4459         primary key (REV, TermVocabulary_id, annotations_id)
4460     );
4461
4462     create table TermVocabulary_Credit (
4463         TermVocabulary_id integer not null,
4464         credits_id integer not null,
4465         sortIndex integer not null,
4466         primary key (TermVocabulary_id, sortIndex),
4467         unique (credits_id)
4468     );
4469
4470     create table TermVocabulary_Credit_AUD (
4471         REV integer not null,
4472         TermVocabulary_id integer not null,
4473         credits_id integer not null,
4474         sortIndex integer not null,
4475         revtype tinyint,
4476         primary key (REV, TermVocabulary_id, credits_id, sortIndex)
4477     );
4478
4479     create table TermVocabulary_Extension (
4480         TermVocabulary_id integer not null,
4481         extensions_id integer not null,
4482         primary key (TermVocabulary_id, extensions_id),
4483         unique (extensions_id)
4484     );
4485
4486     create table TermVocabulary_Extension_AUD (
4487         REV integer not null,
4488         TermVocabulary_id integer not null,
4489         extensions_id integer not null,
4490         revtype tinyint,
4491         primary key (REV, TermVocabulary_id, extensions_id)
4492     );
4493
4494     create table TermVocabulary_Marker (
4495         TermVocabulary_id integer not null,
4496         markers_id integer not null,
4497         primary key (TermVocabulary_id, markers_id),
4498         unique (markers_id)
4499     );
4500
4501     create table TermVocabulary_Marker_AUD (
4502         REV integer not null,
4503         TermVocabulary_id integer not null,
4504         markers_id integer not null,
4505         revtype tinyint,
4506         primary key (REV, TermVocabulary_id, markers_id)
4507     );
4508
4509     create table TermVocabulary_OriginalSourceBase (
4510         TermVocabulary_id integer not null,
4511         sources_id integer not null,
4512         primary key (TermVocabulary_id, sources_id),
4513         unique (sources_id)
4514     );
4515
4516     create table TermVocabulary_OriginalSourceBase_AUD (
4517         REV integer not null,
4518         TermVocabulary_id integer not null,
4519         sources_id integer not null,
4520         revtype tinyint,
4521         primary key (REV, TermVocabulary_id, sources_id)
4522     );
4523
4524     create table TermVocabulary_Representation (
4525         TermVocabulary_id integer not null,
4526         representations_id integer not null,
4527         primary key (TermVocabulary_id, representations_id),
4528         unique (representations_id)
4529     );
4530
4531     create table TermVocabulary_Representation_AUD (
4532         REV integer not null,
4533         TermVocabulary_id integer not null,
4534         representations_id integer not null,
4535         revtype tinyint,
4536         primary key (REV, TermVocabulary_id, representations_id)
4537     );
4538
4539     create table TermVocabulary_Rights (
4540         TermVocabulary_id integer not null,
4541         rights_id integer not null,
4542         primary key (TermVocabulary_id, rights_id),
4543         unique (rights_id)
4544     );
4545
4546     create table TermVocabulary_Rights_AUD (
4547         REV integer not null,
4548         TermVocabulary_id integer not null,
4549         rights_id integer not null,
4550         revtype tinyint,
4551         primary key (REV, TermVocabulary_id, rights_id)
4552     );
4553
4554     create table TypeDesignationBase (
4555         DTYPE varchar(31) not null,
4556         id integer not null,
4557         created timestamp,
4558         uuid varchar(36),
4559         updated timestamp,
4560         citationmicroreference varchar(255),
4561         originalnamestring varchar(255),
4562         notdesignated bit not null,
4563         conservedtype bit,
4564         rejectedtype bit,
4565         createdby_id integer,
4566         updatedby_id integer,
4567         citation_id integer,
4568         homotypicalgroup_id integer,
4569         typestatus_id integer,
4570         typename_id integer,
4571         typespecimen_id integer,
4572         primary key (id),
4573         unique (uuid)
4574     );
4575
4576     create table TypeDesignationBase_AUD (
4577         DTYPE varchar(31) not null,
4578         id integer not null,
4579         REV integer not null,
4580         revtype tinyint,
4581         created timestamp,
4582         uuid varchar(36),
4583         updated timestamp,
4584         citationmicroreference varchar(255),
4585         originalnamestring varchar(255),
4586         notdesignated bit,
4587         createdby_id integer,
4588         updatedby_id integer,
4589         citation_id integer,
4590         homotypicalgroup_id integer,
4591         typestatus_id integer,
4592         typespecimen_id integer,
4593         conservedtype bit,
4594         rejectedtype bit,
4595         typename_id integer,
4596         primary key (id, REV)
4597     );
4598
4599     create table TypeDesignationBase_Annotation (
4600         TypeDesignationBase_id integer not null,
4601         annotations_id integer not null,
4602         primary key (TypeDesignationBase_id, annotations_id),
4603         unique (annotations_id)
4604     );
4605
4606     create table TypeDesignationBase_Annotation_AUD (
4607         REV integer not null,
4608         TypeDesignationBase_id integer not null,
4609         annotations_id integer not null,
4610         revtype tinyint,
4611         primary key (REV, TypeDesignationBase_id, annotations_id)
4612     );
4613
4614     create table TypeDesignationBase_Marker (
4615         TypeDesignationBase_id integer not null,
4616         markers_id integer not null,
4617         primary key (TypeDesignationBase_id, markers_id),
4618         unique (markers_id)
4619     );
4620
4621     create table TypeDesignationBase_Marker_AUD (
4622         REV integer not null,
4623         TypeDesignationBase_id integer not null,
4624         markers_id integer not null,
4625         revtype tinyint,
4626         primary key (REV, TypeDesignationBase_id, markers_id)
4627     );
4628
4629     create table TypeDesignationBase_TaxonNameBase (
4630         TypeDesignationBase_id integer not null,
4631         typifiednames_id integer not null,
4632         primary key (TypeDesignationBase_id, typifiednames_id)
4633     );
4634
4635     create table TypeDesignationBase_TaxonNameBase_AUD (
4636         REV integer not null,
4637         TypeDesignationBase_id integer not null,
4638         typifiednames_id integer not null,
4639         revtype tinyint,
4640         primary key (REV, TypeDesignationBase_id, typifiednames_id)
4641     );
4642
4643     create table UserAccount (
4644         id integer not null,
4645         created timestamp,
4646         uuid varchar(36),
4647         accountnonexpired bit not null,
4648         accountnonlocked bit not null,
4649         credentialsnonexpired bit not null,
4650         emailaddress varchar(255),
4651         enabled bit not null,
4652         password varchar(255),
4653         username varchar(255),
4654         createdby_id integer,
4655         person_id integer,
4656         primary key (id),
4657         unique (uuid, username)
4658     );
4659
4660     create table UserAccount_AUD (
4661         id integer not null,
4662         REV integer not null,
4663         revtype tinyint,
4664         created timestamp,
4665         uuid varchar(36),
4666         accountnonexpired bit,
4667         accountnonlocked bit,
4668         credentialsnonexpired bit,
4669         emailaddress varchar(255),
4670         enabled bit,
4671         username varchar(255),
4672         createdby_id integer,
4673         person_id integer,
4674         primary key (id, REV)
4675     );
4676
4677     create table UserAccount_GrantedAuthorityImpl (
4678         UserAccount_id integer not null,
4679         grantedauthorities_id integer not null,
4680         primary key (UserAccount_id, grantedauthorities_id)
4681     );
4682
4683     create table UserAccount_PermissionGroup (
4684         members_id integer not null,
4685         groups_id integer not null,
4686         primary key (members_id, groups_id)
4687     );
4688
4689     create table WorkingSet (
4690         DTYPE varchar(31) not null,
4691         id integer not null,
4692         created timestamp,
4693         uuid varchar(36),
4694         updated timestamp,
4695         createdby_id integer,
4696         updatedby_id integer,
4697         descriptivesystem_id integer,
4698         primary key (id),
4699         unique (uuid)
4700     );
4701
4702     create table WorkingSet_AUD (
4703         DTYPE varchar(31) not null,
4704         id integer not null,
4705         REV integer not null,
4706         revtype tinyint,
4707         created timestamp,
4708         uuid varchar(36),
4709         updated timestamp,
4710         createdby_id integer,
4711         updatedby_id integer,
4712         descriptivesystem_id integer,
4713         primary key (id, REV)
4714     );
4715
4716     create table WorkingSet_Annotation (
4717         WorkingSet_id integer not null,
4718         annotations_id integer not null,
4719         primary key (WorkingSet_id, annotations_id),
4720         unique (annotations_id)
4721     );
4722
4723     create table WorkingSet_Annotation_AUD (
4724         REV integer not null,
4725         WorkingSet_id integer not null,
4726         annotations_id integer not null,
4727         revtype tinyint,
4728         primary key (REV, WorkingSet_id, annotations_id)
4729     );
4730
4731     create table WorkingSet_DescriptionBase (
4732         WorkingSet_id integer not null,
4733         descriptions_id integer not null,
4734         primary key (WorkingSet_id, descriptions_id)
4735     );
4736
4737     create table WorkingSet_DescriptionBase_AUD (
4738         REV integer not null,
4739         WorkingSet_id integer not null,
4740         descriptions_id integer not null,
4741         revtype tinyint,
4742         primary key (REV, WorkingSet_id, descriptions_id)
4743     );
4744
4745     create table WorkingSet_Marker (
4746         WorkingSet_id integer not null,
4747         markers_id integer not null,
4748         primary key (WorkingSet_id, markers_id),
4749         unique (markers_id)
4750     );
4751
4752     create table WorkingSet_Marker_AUD (
4753         REV integer not null,
4754         WorkingSet_id integer not null,
4755         markers_id integer not null,
4756         revtype tinyint,
4757         primary key (REV, WorkingSet_id, markers_id)
4758     );
4759
4760     create table WorkingSet_Representation (
4761         WorkingSet_id integer not null,
4762         representations_id integer not null,
4763         primary key (WorkingSet_id, representations_id),
4764         unique (representations_id)
4765     );
4766
4767     create table WorkingSet_Representation_AUD (
4768         REV integer not null,
4769         WorkingSet_id integer not null,
4770         representations_id integer not null,
4771         revtype tinyint,
4772         primary key (REV, WorkingSet_id, representations_id)
4773     );
4774
4775     create table WorkingSet_TaxonBase (
4776         WorkingSet_id integer not null,
4777         coveredtaxa_id integer not null,
4778         primary key (WorkingSet_id, coveredtaxa_id)
4779     );
4780
4781     create table WorkingSet_TaxonBase_AUD (
4782         REV integer not null,
4783         WorkingSet_id integer not null,
4784         coveredtaxa_id integer not null,
4785         revtype tinyint,
4786         primary key (REV, WorkingSet_id, coveredtaxa_id)
4787     );
4788
4789     alter table Address
4790         add constraint FK1ED033D44FF2DB2C
4791         foreign key (createdby_id)
4792         references UserAccount;
4793
4794     alter table Address
4795         add constraint FK1ED033D4132A2FE8
4796         foreign key (location_referencesystem_id)
4797         references DefinedTermBase;
4798
4799     alter table Address
4800         add constraint FK1ED033D42687715A
4801         foreign key (country_id)
4802         references DefinedTermBase;
4803
4804     alter table Address
4805         add constraint FK1ED033D4BC5DA539
4806         foreign key (updatedby_id)
4807         references UserAccount;
4808
4809     alter table Address_AUD
4810         add constraint FK115657A534869AAE
4811         foreign key (REV)
4812         references AuditEvent;
4813
4814     create index agentTitleCacheIndex on AgentBase (titleCache);
4815
4816     alter table AgentBase
4817         add constraint FK1205D3564FF2DB2C
4818         foreign key (createdby_id)
4819         references UserAccount;
4820
4821     alter table AgentBase
4822         add constraint FK1205D356A830578
4823         foreign key (ispartof_id)
4824         references AgentBase;
4825
4826     alter table AgentBase
4827         add constraint FK1205D356BC5DA539
4828         foreign key (updatedby_id)
4829         references UserAccount;
4830
4831     alter table AgentBase_AUD
4832         add constraint FK29CC662734869AAE
4833         foreign key (REV)
4834         references AuditEvent;
4835
4836     alter table AgentBase_Address
4837         add constraint FK1EDFF7EB86EFC5D4
4838         foreign key (AgentBase_id)
4839         references AgentBase;
4840
4841     alter table AgentBase_Address
4842         add constraint FK1EDFF7EB50751EC5
4843         foreign key (contact_addresses_id)
4844         references Address;
4845
4846     alter table AgentBase_Address_AUD
4847         add constraint FK3D28383C34869AAE
4848         foreign key (REV)
4849         references AuditEvent;
4850
4851     alter table AgentBase_AgentBase
4852         add constraint FK4D34EDAD1C0E9907
4853         foreign key (AgentBase_id)
4854         references AgentBase;
4855
4856     alter table AgentBase_AgentBase
4857         add constraint FK4D34EDADE9E535F9
4858         foreign key (teammembers_id)
4859         references AgentBase;
4860
4861     alter table AgentBase_AgentBase_AUD
4862         add constraint FKA8A87CFE34869AAE
4863         foreign key (REV)
4864         references AuditEvent;
4865
4866     alter table AgentBase_Annotation
4867         add constraint FK44D5F7D886EFC5D4
4868         foreign key (AgentBase_id)
4869         references AgentBase;
4870
4871     alter table AgentBase_Annotation
4872         add constraint FK44D5F7D81E403E0B
4873         foreign key (annotations_id)
4874         references Annotation;
4875
4876     alter table AgentBase_Annotation_AUD
4877         add constraint FK771279A934869AAE
4878         foreign key (REV)
4879         references AuditEvent;
4880
4881     alter table AgentBase_Credit
4882         add constraint FK2636742286EFC5D4
4883         foreign key (AgentBase_id)
4884         references AgentBase;
4885
4886     alter table AgentBase_Credit
4887         add constraint FK2636742232D1B9F
4888         foreign key (credits_id)
4889         references Credit;
4890
4891     alter table AgentBase_Credit_AUD
4892         add constraint FK7FE7C0F334869AAE
4893         foreign key (REV)
4894         references AuditEvent;
4895
4896     alter table AgentBase_DefinedTermBase
4897         add constraint FK6665C77D8D9AB196
4898         foreign key (AgentBase_id)
4899         references AgentBase;
4900
4901     alter table AgentBase_DefinedTermBase
4902         add constraint FK6665C77D9A161BED
4903         foreign key (types_id)
4904         references DefinedTermBase;
4905
4906     alter table AgentBase_DefinedTermBase_AUD
4907         add constraint FKA737EECE34869AAE
4908         foreign key (REV)
4909         references AuditEvent;
4910
4911     alter table AgentBase_Extension
4912         add constraint FK8E1E567686EFC5D4
4913         foreign key (AgentBase_id)
4914         references AgentBase;
4915
4916     alter table AgentBase_Extension
4917         add constraint FK8E1E5676927DE9DF
4918         foreign key (extensions_id)
4919         references Extension;
4920
4921     alter table AgentBase_Extension_AUD
4922         add constraint FK11AE594734869AAE
4923         foreign key (REV)
4924         references AuditEvent;
4925
4926     alter table AgentBase_Marker
4927         add constraint FK365D5D63777265A1
4928         foreign key (markers_id)
4929         references Marker;
4930
4931     alter table AgentBase_Marker
4932         add constraint FK365D5D6386EFC5D4
4933         foreign key (AgentBase_id)
4934         references AgentBase;
4935
4936     alter table AgentBase_Marker_AUD
4937         add constraint FKE40621B434869AAE
4938         foreign key (REV)
4939         references AuditEvent;
4940
4941     alter table AgentBase_Media
4942         add constraint FKE8FC5D9B86EFC5D4
4943         foreign key (AgentBase_id)
4944         references AgentBase;
4945
4946     alter table AgentBase_Media
4947         add constraint FKE8FC5D9BC2C29593
4948         foreign key (media_id)
4949         references Media;
4950
4951     alter table AgentBase_Media_AUD
4952         add constraint FK323A45EC34869AAE
4953         foreign key (REV)
4954         references AuditEvent;
4955
4956     alter table AgentBase_OriginalSourceBase
4957         add constraint FKB482C5E686EFC5D4
4958         foreign key (AgentBase_id)
4959         references AgentBase;
4960
4961     alter table AgentBase_OriginalSourceBase
4962         add constraint FKB482C5E63A6735D9
4963         foreign key (sources_id)
4964         references OriginalSourceBase;
4965
4966     alter table AgentBase_OriginalSourceBase_AUD
4967         add constraint FK886D90B734869AAE
4968         foreign key (REV)
4969         references AuditEvent;
4970
4971     alter table AgentBase_Rights
4972         add constraint FK3F514B0086EFC5D4
4973         foreign key (AgentBase_id)
4974         references AgentBase;
4975
4976     alter table AgentBase_Rights
4977         add constraint FK3F514B00C13F7B21
4978         foreign key (rights_id)
4979         references Rights;
4980
4981     alter table AgentBase_Rights_AUD
4982         add constraint FK4FDFF8D134869AAE
4983         foreign key (REV)
4984         references AuditEvent;
4985
4986     alter table AgentBase_contact_emailaddresses
4987         add constraint FK4BD2B08E86EFC5D4
4988         foreign key (AgentBase_id)
4989         references AgentBase;
4990
4991     alter table AgentBase_contact_emailaddresses_AUD
4992         add constraint FKCAF7E75F34869AAE
4993         foreign key (REV)
4994         references AuditEvent;
4995
4996     alter table AgentBase_contact_faxnumbers
4997         add constraint FK52E1AD9586EFC5D4
4998         foreign key (AgentBase_id)
4999         references AgentBase;
5000
5001     alter table AgentBase_contact_faxnumbers_AUD
5002         add constraint FK88A308E634869AAE
5003         foreign key (REV)
5004         references AuditEvent;
5005
5006     alter table AgentBase_contact_phonenumbers
5007         add constraint FKC171CC2486EFC5D4
5008         foreign key (AgentBase_id)
5009         references AgentBase;
5010
5011     alter table AgentBase_contact_phonenumbers_AUD
5012         add constraint FKDDD347F534869AAE
5013         foreign key (REV)
5014         references AuditEvent;
5015
5016     alter table AgentBase_contact_urls
5017         add constraint FK9A9643EC86EFC5D4
5018         foreign key (AgentBase_id)
5019         references AgentBase;
5020
5021     alter table AgentBase_contact_urls_AUD
5022         add constraint FK1CE69BBD34869AAE
5023         foreign key (REV)
5024         references AuditEvent;
5025
5026     alter table Annotation
5027         add constraint FK1A21C74F4FF2DB2C
5028         foreign key (createdby_id)
5029         references UserAccount;
5030
5031     alter table Annotation
5032         add constraint FK1A21C74FE7692740
5033         foreign key (commentator_id)
5034         references AgentBase;
5035
5036     alter table Annotation
5037         add constraint FK1A21C74FDF299D00
5038         foreign key (annotationtype_id)
5039         references DefinedTermBase;
5040
5041     alter table Annotation
5042         add constraint FK1A21C74FE8D36B00
5043         foreign key (language_id)
5044         references DefinedTermBase;
5045
5046     alter table Annotation
5047         add constraint FK1A21C74FBC5DA539
5048         foreign key (updatedby_id)
5049         references UserAccount;
5050
5051     alter table Annotation_AUD
5052         add constraint FK1A6BB5A034869AAE
5053         foreign key (REV)
5054         references AuditEvent;
5055
5056     alter table Annotation_Annotation
5057         add constraint FKC99DFE3F994CCE20
5058         foreign key (Annotation_id)
5059         references Annotation;
5060
5061     alter table Annotation_Annotation
5062         add constraint FKC99DFE3F1E403E0B
5063         foreign key (annotations_id)
5064         references Annotation;
5065
5066     alter table Annotation_Annotation_AUD
5067         add constraint FKB212F49034869AAE
5068         foreign key (REV)
5069         references AuditEvent;
5070
5071     alter table Annotation_Marker
5072         add constraint FKB17EAF4A777265A1
5073         foreign key (markers_id)
5074         references Marker;
5075
5076     alter table Annotation_Marker
5077         add constraint FKB17EAF4A994CCE20
5078         foreign key (Annotation_id)
5079         references Annotation;
5080
5081     alter table Annotation_Marker_AUD
5082         add constraint FK68CE281B34869AAE
5083         foreign key (REV)
5084         references AuditEvent;
5085
5086     alter table CDM_VIEW
5087         add constraint FKC5DE8EF84FF2DB2C
5088         foreign key (createdby_id)
5089         references UserAccount;
5090
5091     alter table CDM_VIEW
5092         add constraint FKC5DE8EF8765B124B
5093         foreign key (reference_id)
5094         references Reference;
5095
5096     alter table CDM_VIEW_CDM_VIEW
5097         add constraint FK230A885F7208BB38
5098         foreign key (superviews_id)
5099         references CDM_VIEW;
5100
5101     alter table CDM_VIEW_CDM_VIEW
5102         add constraint FK230A885FC00D1213
5103         foreign key (CDM_VIEW_id)
5104         references CDM_VIEW;
5105
5106     create index collectionTitleCacheIndex on Collection (titleCache);
5107
5108     alter table Collection
5109         add constraint FKF078ABE4FF2DB2C
5110         foreign key (createdby_id)
5111         references UserAccount;
5112
5113     alter table Collection
5114         add constraint FKF078ABE16B9CA77
5115         foreign key (institute_id)
5116         references AgentBase;
5117
5118     alter table Collection
5119         add constraint FKF078ABECEB38EFF
5120         foreign key (supercollection_id)
5121         references Collection;
5122
5123     alter table Collection
5124         add constraint FKF078ABEBC5DA539
5125         foreign key (updatedby_id)
5126         references UserAccount;
5127
5128     alter table Collection_AUD
5129         add constraint FKD6D4298F34869AAE
5130         foreign key (REV)
5131         references AuditEvent;
5132
5133     alter table Collection_Annotation
5134         add constraint FKEA970F70EB62BE9A
5135         foreign key (Collection_id)
5136         references Collection;
5137
5138     alter table Collection_Annotation
5139         add constraint FKEA970F701E403E0B
5140         foreign key (annotations_id)
5141         references Annotation;
5142
5143     alter table Collection_Annotation_AUD
5144         add constraint FKA0CE054134869AAE
5145         foreign key (REV)
5146         references AuditEvent;
5147
5148     alter table Collection_Credit
5149         add constraint FKE0A317BAEB62BE9A
5150         foreign key (Collection_id)
5151         references Collection;
5152
5153     alter table Collection_Credit
5154         add constraint FKE0A317BA32D1B9F
5155         foreign key (credits_id)
5156         references Credit;
5157
5158     alter table Collection_Credit_AUD
5159         add constraint FK25A8D88B34869AAE
5160         foreign key (REV)
5161         references AuditEvent;
5162
5163     alter table Collection_Extension
5164         add constraint FKF68FEBDEEB62BE9A
5165         foreign key (Collection_id)
5166         references Collection;
5167
5168     alter table Collection_Extension
5169         add constraint FKF68FEBDE927DE9DF
5170         foreign key (extensions_id)
5171         references Extension;
5172
5173     alter table Collection_Extension_AUD
5174         add constraint FK1306FAAF34869AAE
5175         foreign key (REV)
5176         references AuditEvent;
5177
5178     alter table Collection_Marker
5179         add constraint FKF0CA00FBEB62BE9A
5180         foreign key (Collection_id)
5181         references Collection;
5182
5183     alter table Collection_Marker
5184         add constraint FKF0CA00FB777265A1
5185         foreign key (markers_id)
5186         references Marker;
5187
5188     alter table Collection_Marker_AUD
5189         add constraint FK89C7394C34869AAE
5190         foreign key (REV)
5191         references AuditEvent;
5192
5193     alter table Collection_Media
5194         add constraint FK7320E703EB62BE9A
5195         foreign key (Collection_id)
5196         references Collection;
5197
5198     alter table Collection_Media
5199         add constraint FK7320E703C2C29593
5200         foreign key (media_id)
5201         references Media;
5202
5203     alter table Collection_Media_AUD
5204         add constraint FK9AABDB5434869AAE
5205         foreign key (REV)
5206         references AuditEvent;
5207
5208     alter table Collection_OriginalSourceBase
5209         add constraint FK37DEC57EEB62BE9A
5210         foreign key (Collection_id)
5211         references Collection;
5212
5213     alter table Collection_OriginalSourceBase
5214         add constraint FK37DEC57E3A6735D9
5215         foreign key (sources_id)
5216         references OriginalSourceBase;
5217
5218     alter table Collection_OriginalSourceBase_AUD
5219         add constraint FKF810044F34869AAE
5220         foreign key (REV)
5221         references AuditEvent;
5222
5223     alter table Collection_Rights
5224         add constraint FKF9BDEE98EB62BE9A
5225         foreign key (Collection_id)
5226         references Collection;
5227
5228     alter table Collection_Rights
5229         add constraint FKF9BDEE98C13F7B21
5230         foreign key (rights_id)
5231         references Rights;
5232
5233     alter table Collection_Rights_AUD
5234         add constraint FKF5A1106934869AAE
5235         foreign key (REV)
5236         references AuditEvent;
5237
5238     alter table Credit
5239         add constraint FK78CA97194FF2DB2C
5240         foreign key (createdby_id)
5241         references UserAccount;
5242
5243     alter table Credit
5244         add constraint FK78CA9719F7976FC5
5245         foreign key (agent_id)
5246         references AgentBase;
5247
5248     alter table Credit
5249         add constraint FK78CA9719E8D36B00
5250         foreign key (language_id)
5251         references DefinedTermBase;
5252
5253     alter table Credit
5254         add constraint FK78CA9719BC5DA539
5255         foreign key (updatedby_id)
5256         references UserAccount;
5257
5258     alter table Credit_AUD
5259         add constraint FK5533906A34869AAE
5260         foreign key (REV)
5261         references AuditEvent;
5262
5263     alter table Credit_Annotation
5264         add constraint FKE8DA4C354CF694E0
5265         foreign key (Credit_id)
5266         references Credit;
5267
5268     alter table Credit_Annotation
5269         add constraint FKE8DA4C351E403E0B
5270         foreign key (annotations_id)
5271         references Annotation;
5272
5273     alter table Credit_Annotation_AUD
5274         add constraint FK1DEB578634869AAE
5275         foreign key (REV)
5276         references AuditEvent;
5277
5278     alter table Credit_Marker
5279         add constraint FK10CC6840777265A1
5280         foreign key (markers_id)
5281         references Marker;
5282
5283     alter table Credit_Marker
5284         add constraint FK10CC68404CF694E0
5285         foreign key (Credit_id)
5286         references Credit;
5287
5288     alter table Credit_Marker_AUD
5289         add constraint FK880A761134869AAE
5290         foreign key (REV)
5291         references AuditEvent;
5292
5293     alter table DefinedTermBase
5294         add constraint FK2E340A664FF2DB2C
5295         foreign key (createdby_id)
5296         references UserAccount;
5297
5298     alter table DefinedTermBase
5299         add constraint FK2E340A66D040DBF0
5300         foreign key (partof_id)
5301         references DefinedTermBase;
5302
5303     alter table DefinedTermBase
5304         add constraint FK2E340A66CC0240B6
5305         foreign key (shape_id)
5306         references Media;
5307
5308     alter table DefinedTermBase
5309         add constraint FK2E340A6647AF954C
5310         foreign key (vocabulary_id)
5311         references TermVocabulary;
5312
5313     alter table DefinedTermBase
5314         add constraint FK2E340A6624AF3F70
5315         foreign key (level_id)
5316         references DefinedTermBase;
5317
5318     alter table DefinedTermBase
5319         add constraint FK2E340A6688206484
5320         foreign key (type_id)
5321         references DefinedTermBase;
5322
5323     alter table DefinedTermBase
5324         add constraint FK2E340A6636C6F6F6
5325         foreign key (pointapproximation_referencesystem_id)
5326         references DefinedTermBase;
5327
5328     alter table DefinedTermBase
5329         add constraint FK2E340A663B0DA0EF
5330         foreign key (kindof_id)
5331         references DefinedTermBase;
5332
5333     alter table DefinedTermBase
5334         add constraint FK2E340A66BC5DA539
5335         foreign key (updatedby_id)
5336         references UserAccount;
5337
5338     alter table DefinedTermBase_AUD
5339         add constraint FK86E8953734869AAE
5340         foreign key (REV)
5341         references AuditEvent;
5342
5343     alter table DefinedTermBase_Annotation
5344         add constraint FK589B6C8C0DB4934
5345         foreign key (DefinedTermBase_id)
5346         references DefinedTermBase;
5347
5348     alter table DefinedTermBase_Annotation
5349         add constraint FK589B6C81E403E0B
5350         foreign key (annotations_id)
5351         references Annotation;
5352
5353     alter table DefinedTermBase_Annotation_AUD
5354         add constraint FK28ED409934869AAE
5355         foreign key (REV)
5356         references AuditEvent;
5357
5358     alter table DefinedTermBase_Continent
5359         add constraint FK45F60AFB3927C853
5360         foreign key (continents_id)
5361         references DefinedTermBase;
5362
5363     alter table DefinedTermBase_Continent
5364         add constraint FK45F60AFBE8CE10AA
5365         foreign key (DefinedTermBase_id)
5366         references DefinedTermBase;
5367
5368     alter table DefinedTermBase_Continent_AUD
5369         add constraint FKF5DE434C34869AAE
5370         foreign key (REV)
5371         references AuditEvent;
5372
5373     alter table DefinedTermBase_Credit
5374         add constraint FK78FF2B12C0DB4934
5375         foreign key (DefinedTermBase_id)
5376         references DefinedTermBase;
5377
5378     alter table DefinedTermBase_Credit
5379         add constraint FK78FF2B1232D1B9F
5380         foreign key (credits_id)
5381         references Credit;
5382
5383     alter table DefinedTermBase_Credit_AUD
5384         add constraint FK409B7FE334869AAE
5385         foreign key (REV)
5386         references AuditEvent;
5387
5388     alter table DefinedTermBase_Extension
5389         add constraint FK397EF986927DE9DF
5390         foreign key (extensions_id)
5391         references Extension;
5392
5393     alter table DefinedTermBase_Extension
5394         add constraint FK397EF986C0DB4934
5395         foreign key (DefinedTermBase_id)
5396         references DefinedTermBase;
5397
5398     alter table DefinedTermBase_Extension_AUD
5399         add constraint FK6E6F45734869AAE
5400         foreign key (REV)
5401         references AuditEvent;
5402
5403     alter table DefinedTermBase_Marker
5404         add constraint FK89261453777265A1
5405         foreign key (markers_id)
5406         references Marker;
5407
5408     alter table DefinedTermBase_Marker
5409         add constraint FK89261453C0DB4934
5410         foreign key (DefinedTermBase_id)
5411         references DefinedTermBase;
5412
5413     alter table DefinedTermBase_Marker_AUD
5414         add constraint FKA4B9E0A434869AAE
5415         foreign key (REV)
5416         references AuditEvent;
5417
5418     alter table DefinedTermBase_MeasurementUnit
5419         add constraint FKE9D17767D0BDAE9B
5420         foreign key (DefinedTermBase_id)
5421         references DefinedTermBase;
5422
5423     alter table DefinedTermBase_MeasurementUnit
5424         add constraint FKE9D17767F3BB39BD
5425         foreign key (recommendedmeasurementunits_id)
5426         references DefinedTermBase;
5427
5428     alter table DefinedTermBase_MeasurementUnit_AUD
5429         add constraint FK2C1599B834869AAE
5430         foreign key (REV)
5431         references AuditEvent;
5432
5433     alter table DefinedTermBase_Media
5434         add constraint FK6FC908ABC0DB4934
5435         foreign key (DefinedTermBase_id)
5436         references DefinedTermBase;
5437
5438     alter table DefinedTermBase_Media
5439         add constraint FK6FC908ABC2C29593
5440         foreign key (media_id)
5441         references Media;
5442
5443     alter table DefinedTermBase_Media_AUD
5444         add constraint FKDD9AE8FC34869AAE
5445         foreign key (REV)
5446         references AuditEvent;
5447
5448     alter table DefinedTermBase_OriginalSourceBase
5449         add constraint FKDCC094D6C0DB4934
5450         foreign key (DefinedTermBase_id)
5451         references DefinedTermBase;
5452
5453     alter table DefinedTermBase_OriginalSourceBase
5454         add constraint FKDCC094D63A6735D9
5455         foreign key (sources_id)
5456         references OriginalSourceBase;
5457
5458     alter table DefinedTermBase_OriginalSourceBase_AUD
5459         add constraint FKAE4A67A734869AAE
5460         foreign key (REV)
5461         references AuditEvent;
5462
5463     alter table DefinedTermBase_RecommendedModifierEnumeration
5464         add constraint FKA72FB5AED0BDAE9B
5465         foreign key (DefinedTermBase_id)
5466         references DefinedTermBase;
5467
5468     alter table DefinedTermBase_RecommendedModifierEnumeration
5469         add constraint FKA72FB5AE5255EAFD
5470         foreign key (recommendedmodifierenumeration_id)
5471         references TermVocabulary;
5472
5473     alter table DefinedTermBase_RecommendedModifierEnumeration_AUD
5474         add constraint FK780D5C7F34869AAE
5475         foreign key (REV)
5476         references AuditEvent;
5477
5478     alter table DefinedTermBase_Representation
5479         add constraint FKAAC8AFE6B31C4747
5480         foreign key (representations_id)
5481         references Representation;
5482
5483     alter table DefinedTermBase_Representation
5484         add constraint FKAAC8AFE6C0DB4934
5485         foreign key (DefinedTermBase_id)
5486         references DefinedTermBase;
5487
5488     alter table DefinedTermBase_Representation_AUD
5489         add constraint FKB5AE7AB734869AAE
5490         foreign key (REV)
5491         references AuditEvent;
5492
5493     alter table DefinedTermBase_Rights
5494         add constraint FK921A01F0C0DB4934
5495         foreign key (DefinedTermBase_id)
5496         references DefinedTermBase;
5497
5498     alter table DefinedTermBase_Rights
5499         add constraint FK921A01F0C13F7B21
5500         foreign key (rights_id)
5501         references Rights;
5502
5503     alter table DefinedTermBase_Rights_AUD
5504         add constraint FK1093B7C134869AAE
5505         foreign key (REV)
5506         references AuditEvent;
5507
5508     alter table DefinedTermBase_StatisticalMeasure
5509         add constraint FK6FF15DFCD0BDAE9B
5510         foreign key (DefinedTermBase_id)
5511         references DefinedTermBase;
5512
5513     alter table DefinedTermBase_StatisticalMeasure
5514         add constraint FK6FF15DFCC9CD5B57
5515         foreign key (recommendedstatisticalmeasures_id)
5516         references DefinedTermBase;
5517
5518     alter table DefinedTermBase_StatisticalMeasure_AUD
5519         add constraint FK3C062DCD34869AAE
5520         foreign key (REV)
5521         references AuditEvent;
5522
5523     alter table DefinedTermBase_SupportedCategoricalEnumeration
5524         add constraint FK2170B25CD0BDAE9B
5525         foreign key (DefinedTermBase_id)
5526         references DefinedTermBase;
5527
5528     alter table DefinedTermBase_SupportedCategoricalEnumeration
5529         add constraint FK2170B25C5AF2C74
5530         foreign key (supportedcategoricalenumerations_id)
5531         references TermVocabulary;
5532
5533     alter table DefinedTermBase_SupportedCategoricalEnumeration_AUD
5534         add constraint FKBB04522D34869AAE
5535         foreign key (REV)
5536         references AuditEvent;
5537
5538     alter table DefinedTermBase_WaterbodyOrCountry
5539         add constraint FKCAF43931603B036
5540         foreign key (waterbodiesorcountries_id)
5541         references DefinedTermBase;
5542
5543     alter table DefinedTermBase_WaterbodyOrCountry
5544         add constraint FKCAF4393CE5C0F9E
5545         foreign key (DefinedTermBase_id)
5546         references DefinedTermBase;
5547
5548     alter table DefinedTermBase_WaterbodyOrCountry_AUD
5549         add constraint FKD5996FE434869AAE
5550         foreign key (REV)
5551         references AuditEvent;
5552
5553     alter table DerivationEvent
5554         add constraint FK426BC034FF2DB2C
5555         foreign key (createdby_id)
5556         references UserAccount;
5557
5558     alter table DerivationEvent
5559         add constraint FK426BC033DA462D5
5560         foreign key (actor_id)
5561         references AgentBase;
5562
5563     alter table DerivationEvent
5564         add constraint FK426BC038524B89D
5565         foreign key (type_id)
5566         references DefinedTermBase;
5567
5568     alter table DerivationEvent
5569         add constraint FK426BC03BC5DA539
5570         foreign key (updatedby_id)
5571         references UserAccount;
5572
5573     alter table DerivationEvent_AUD
5574         add constraint FKDABF305434869AAE
5575         foreign key (REV)
5576         references AuditEvent;
5577
5578     alter table DerivationEvent_Annotation
5579         add constraint FKEFA0D10B4AAB411A
5580         foreign key (DerivationEvent_id)
5581         references DerivationEvent;
5582
5583     alter table DerivationEvent_Annotation
5584         add constraint FKEFA0D10B1E403E0B
5585         foreign key (annotations_id)
5586         references Annotation;
5587
5588     alter table DerivationEvent_Annotation_AUD
5589         add constraint FKA197815C34869AAE
5590         foreign key (REV)
5591         references AuditEvent;
5592
5593     alter table DerivationEvent_Marker
5594         add constraint FKE412C816777265A1
5595         foreign key (markers_id)
5596         references Marker;
5597
5598     alter table DerivationEvent_Marker
5599         add constraint FKE412C8164AAB411A
5600         foreign key (DerivationEvent_id)
5601         references DerivationEvent;
5602
5603     alter table DerivationEvent_Marker_AUD
5604         add constraint FK8ED0FAE734869AAE
5605         foreign key (REV)
5606         references AuditEvent;
5607
5608     alter table DescriptionBase
5609         add constraint FKFF4D58CD4FF2DB2C
5610         foreign key (createdby_id)
5611         references UserAccount;
5612
5613     alter table DescriptionBase
5614         add constraint FKFF4D58CDDE9A3DE3
5615         foreign key (taxon_fk)
5616         references TaxonBase;
5617
5618     alter table DescriptionBase
5619         add constraint FKFF4D58CDDA93512F
5620         foreign key (taxonName_fk)
5621         references TaxonNameBase;
5622
5623     alter table DescriptionBase
5624         add constraint FKFF4D58CDBC5DA539
5625         foreign key (updatedby_id)
5626         references UserAccount;
5627
5628     alter table DescriptionBase_AUD
5629         add constraint FK7456581E34869AAE
5630         foreign key (REV)
5631         references AuditEvent;
5632
5633     alter table DescriptionBase_Annotation
5634         add constraint FKF3AD3201F1DDBFAB
5635         foreign key (DescriptionBase_id)
5636         references DescriptionBase;
5637
5638     alter table DescriptionBase_Annotation
5639         add constraint FKF3AD32011E403E0B
5640         foreign key (annotations_id)
5641         references Annotation;
5642
5643     alter table DescriptionBase_Annotation_AUD
5644         add constraint FK15FE775234869AAE
5645         foreign key (REV)
5646         references AuditEvent;
5647
5648     alter table DescriptionBase_Credit
5649         add constraint FK510B2ACBF1DDBFAB
5650         foreign key (DescriptionBase_id)
5651         references DescriptionBase;
5652
5653     alter table DescriptionBase_Credit
5654         add constraint FK510B2ACB32D1B9F
5655         foreign key (credits_id)
5656         references Credit;
5657
5658     alter table DescriptionBase_Credit_AUD
5659         add constraint FK2EBEFB1C34869AAE
5660         foreign key (REV)
5661         references AuditEvent;
5662
5663     alter table DescriptionBase_Extension
5664         add constraint FKD5D2B32DF1DDBFAB
5665         foreign key (DescriptionBase_id)
5666         references DescriptionBase;
5667
5668     alter table DescriptionBase_Extension
5669         add constraint FKD5D2B32D927DE9DF
5670         foreign key (extensions_id)
5671         references Extension;
5672
5673     alter table DescriptionBase_Extension_AUD
5674         add constraint FK79E7827E34869AAE
5675         foreign key (REV)
5676         references AuditEvent;
5677
5678     alter table DescriptionBase_Feature
5679         add constraint FK58ACF564F1DDBFAB
5680         foreign key (DescriptionBase_id)
5681         references DescriptionBase;
5682
5683     alter table DescriptionBase_Feature
5684         add constraint FK58ACF5649AE62C6
5685         foreign key (descriptivesystem_id)
5686         references DefinedTermBase;
5687
5688     alter table DescriptionBase_Feature_AUD
5689         add constraint FKA4D7D13534869AAE
5690         foreign key (REV)
5691         references AuditEvent;
5692
5693     alter table DescriptionBase_GeoScope
5694         add constraint FK3ADD7CD586D04E74
5695         foreign key (geoscopes_id)
5696         references DefinedTermBase;
5697
5698     alter table DescriptionBase_GeoScope
5699         add constraint FK3ADD7CD5D86445CE
5700         foreign key (DescriptionBase_id)
5701         references DescriptionBase;
5702
5703     alter table DescriptionBase_GeoScope_AUD
5704         add constraint FK63A5382634869AAE
5705         foreign key (REV)
5706         references AuditEvent;
5707
5708     alter table DescriptionBase_Marker
5709         add constraint FK6132140C777265A1
5710         foreign key (markers_id)
5711         references Marker;
5712
5713     alter table DescriptionBase_Marker
5714         add constraint FK6132140CF1DDBFAB
5715         foreign key (DescriptionBase_id)
5716         references DescriptionBase;
5717
5718     alter table DescriptionBase_Marker_AUD
5719         add constraint FK92DD5BDD34869AAE
5720         foreign key (REV)
5721         references AuditEvent;
5722
5723     alter table DescriptionBase_OriginalSourceBase
5724         add constraint FKDC75C70FF1DDBFAB
5725         foreign key (DescriptionBase_id)
5726         references DescriptionBase;
5727
5728     alter table DescriptionBase_OriginalSourceBase
5729         add constraint FKDC75C70F3A6735D9
5730         foreign key (sources_id)
5731         references OriginalSourceBase;
5732
5733     alter table DescriptionBase_OriginalSourceBase_AUD
5734         add constraint FK8F39D56034869AAE
5735         foreign key (REV)
5736         references AuditEvent;
5737
5738     alter table DescriptionBase_Reference
5739         add constraint FKC330D639F1DDBFAB
5740         foreign key (DescriptionBase_id)
5741         references DescriptionBase;
5742
5743     alter table DescriptionBase_Reference
5744         add constraint FKC330D63945AB7BBA
5745         foreign key (descriptionsources_id)
5746         references Reference;
5747
5748     alter table DescriptionBase_Reference_AUD
5749         add constraint FK76253F8A34869AAE
5750         foreign key (REV)
5751         references AuditEvent;
5752
5753     alter table DescriptionBase_Rights
5754         add constraint FK6A2601A9F1DDBFAB
5755         foreign key (DescriptionBase_id)
5756         references DescriptionBase;
5757
5758     alter table DescriptionBase_Rights
5759         add constraint FK6A2601A9C13F7B21
5760         foreign key (rights_id)
5761         references Rights;
5762
5763     alter table DescriptionBase_Rights_AUD
5764         add constraint FKFEB732FA34869AAE
5765         foreign key (REV)
5766         references AuditEvent;
5767
5768     alter table DescriptionBase_Scope
5769         add constraint FKB9257C42951A5D40
5770         foreign key (scopes_id)
5771         references DefinedTermBase;
5772
5773     alter table DescriptionBase_Scope
5774         add constraint FKB9257C42D86445CE
5775         foreign key (DescriptionBase_id)
5776         references DescriptionBase;
5777
5778     alter table DescriptionBase_Scope_AUD
5779         add constraint FK75D5B91334869AAE
5780         foreign key (REV)
5781         references AuditEvent;
5782
5783     alter table DescriptionBase_SpecimenOrObservationBase
5784         add constraint FKDE29CD8033B8A841
5785         foreign key (descriptions_id)
5786         references DescriptionBase;
5787
5788     alter table DescriptionBase_SpecimenOrObservationBase
5789         add constraint FKDE29CD805C9E3461
5790         foreign key (describedspecimenorobservations_id)
5791         references SpecimenOrObservationBase;
5792
5793     alter table DescriptionBase_SpecimenOrObservationBase_AUD
5794         add constraint FKF1B33B5134869AAE
5795         foreign key (REV)
5796         references AuditEvent;
5797
5798     alter table DescriptionElementBase
5799         add constraint FK38FE76711C3C3FF7
5800         foreign key (area_id)
5801         references DefinedTermBase;
5802
5803     alter table DescriptionElementBase
5804         add constraint FK38FE76714FF2DB2C
5805         foreign key (createdby_id)
5806         references UserAccount;
5807
5808     alter table DescriptionElementBase
5809         add constraint FK38FE76716D0D7A56
5810         foreign key (format_id)
5811         references DefinedTermBase;
5812
5813     alter table DescriptionElementBase
5814         add constraint FK38FE76714220AFEB
5815         foreign key (feature_id)
5816         references DefinedTermBase;
5817
5818     alter table DescriptionElementBase
5819         add constraint FK38FE76719108D9B
5820         foreign key (taxon2_id)
5821         references TaxonBase;
5822
5823     alter table DescriptionElementBase
5824         add constraint FK38FE76715E9914B8
5825         foreign key (status_id)
5826         references DefinedTermBase;
5827
5828     alter table DescriptionElementBase
5829         add constraint FK38FE767110A80E07
5830         foreign key (unit_id)
5831         references DefinedTermBase;
5832
5833     alter table DescriptionElementBase
5834         add constraint FK38FE76716561D9B1
5835         foreign key (associatedspecimenorobservation_id)
5836         references SpecimenOrObservationBase;
5837
5838     alter table DescriptionElementBase
5839         add constraint FK38FE767134AF0E81
5840         foreign key (indescription_id)
5841         references DescriptionBase;
5842
5843     alter table DescriptionElementBase
5844         add constraint FK38FE7671E8D36B00
5845         foreign key (language_id)
5846         references DefinedTermBase;
5847
5848     alter table DescriptionElementBase
5849         add constraint FK38FE7671BC5DA539
5850         foreign key (updatedby_id)
5851         references UserAccount;
5852
5853     alter table DescriptionElementBase_AUD
5854         add constraint FKF3803C234869AAE
5855         foreign key (REV)
5856         references AuditEvent;
5857
5858     alter table DescriptionElementBase_Annotation
5859         add constraint FK7EE5E5DD3B8BB609
5860         foreign key (DescriptionElementBase_id)
5861         references DescriptionElementBase;
5862
5863     alter table DescriptionElementBase_Annotation
5864         add constraint FK7EE5E5DD1E403E0B
5865         foreign key (annotations_id)
5866         references Annotation;
5867
5868     alter table DescriptionElementBase_Annotation_AUD
5869         add constraint FK2BC1DD2E34869AAE
5870         foreign key (REV)
5871         references AuditEvent;
5872
5873     alter table DescriptionElementBase_LanguageString
5874         add constraint FKC753F137C086B46F
5875         foreign key (DescriptionElementBase_id)
5876         references DescriptionElementBase;
5877
5878     alter table DescriptionElementBase_LanguageString
5879         add constraint FKC753F137ACF5F60B
5880         foreign key (multilanguagetext_id)
5881         references LanguageString;
5882
5883     alter table DescriptionElementBase_LanguageString
5884         add constraint FKC753F137C6D55834
5885         foreign key (multilanguagetext_mapkey_id)
5886         references DefinedTermBase;
5887
5888     alter table DescriptionElementBase_LanguageString_AUD
5889         add constraint FK2D26AB8834869AAE
5890         foreign key (REV)
5891         references AuditEvent;
5892
5893     alter table DescriptionElementBase_Marker
5894         add constraint FK1CB715E8777265A1
5895         foreign key (markers_id)
5896         references Marker;
5897
5898     alter table DescriptionElementBase_Marker
5899         add constraint FK1CB715E83B8BB609
5900         foreign key (DescriptionElementBase_id)
5901         references DescriptionElementBase;
5902
5903     alter table DescriptionElementBase_Marker_AUD
5904         add constraint FK1E160FB934869AAE
5905         foreign key (REV)
5906         references AuditEvent;
5907
5908     alter table DescriptionElementBase_Media
5909         add constraint FK21F700763B8BB609
5910         foreign key (DescriptionElementBase_id)
5911         references DescriptionElementBase;
5912
5913     alter table DescriptionElementBase_Media
5914         add constraint FK21F70076C2C29593
5915         foreign key (media_id)
5916         references Media;
5917
5918     alter table DescriptionElementBase_Media_AUD
5919         add constraint FK5522034734869AAE
5920         foreign key (REV)
5921         references AuditEvent;
5922
5923     alter table DescriptionElementBase_Modifier
5924         add constraint FK97E0D1053B8BB609
5925         foreign key (DescriptionElementBase_id)
5926         references DescriptionElementBase;
5927
5928     alter table DescriptionElementBase_Modifier
5929         add constraint FK97E0D105E0960EC4
5930         foreign key (modifiers_id)
5931         references DefinedTermBase;
5932
5933     alter table DescriptionElementBase_Modifier_AUD
5934         add constraint FK2982F45634869AAE
5935         foreign key (REV)
5936         references AuditEvent;
5937
5938     alter table DescriptionElementBase_ModifyingText
5939         add constraint FK522D90C73B8BB609
5940         foreign key (DescriptionElementBase_id)
5941         references DescriptionElementBase;
5942
5943     alter table DescriptionElementBase_ModifyingText
5944         add constraint FK522D90C7F05D08D4
5945         foreign key (modifyingtext_id)
5946         references LanguageString;
5947
5948     alter table DescriptionElementBase_ModifyingText
5949         add constraint FK522D90C79682414B
5950         foreign key (modifyingtext_mapkey_id)
5951         references DefinedTermBase;
5952
5953     alter table DescriptionElementBase_ModifyingText_AUD
5954         add constraint FK6C06031834869AAE
5955         foreign key (REV)
5956         references AuditEvent;
5957
5958     alter table DescriptionElementBase_OriginalSourceBase
5959         add constraint FKF41ADEEB3B8BB609
5960         foreign key (DescriptionElementBase_id)
5961         references DescriptionElementBase;
5962
5963     alter table DescriptionElementBase_OriginalSourceBase
5964         add constraint FKF41ADEEB53DD72E3
5965         foreign key (sources_id)
5966         references OriginalSourceBase;
5967
5968     alter table DescriptionElementBase_OriginalSourceBase_AUD
5969         add constraint FK9C979F3C34869AAE
5970         foreign key (REV)
5971         references AuditEvent;
5972
5973     alter table DescriptionElementBase_StateData
5974         add constraint FK592D6F6D15153604
5975         foreign key (states_id)
5976         references StateData;
5977
5978     alter table DescriptionElementBase_StateData
5979         add constraint FK592D6F6D987CC6A4
5980         foreign key (DescriptionElementBase_id)
5981         references DescriptionElementBase;
5982
5983     alter table DescriptionElementBase_StateData_AUD
5984         add constraint FK1D0A1EBE34869AAE
5985         foreign key (REV)
5986         references AuditEvent;
5987
5988     alter table DescriptionElementBase_StatisticalMeasurementValue
5989         add constraint FK8AF511C28F213219
5990         foreign key (DescriptionElementBase_id)
5991         references DescriptionElementBase;
5992
5993     alter table DescriptionElementBase_StatisticalMeasurementValue
5994         add constraint FK8AF511C2D883945E
5995         foreign key (statisticalvalues_id)
5996         references StatisticalMeasurementValue;
5997
5998     alter table DescriptionElementBase_StatisticalMeasurementValue_AUD
5999         add constraint FK2DE8E9334869AAE
6000         foreign key (REV)
6001         references AuditEvent;
6002
6003     alter table DeterminationEvent
6004         add constraint FK1DB24974FF2DB2C
6005         foreign key (createdby_id)
6006         references UserAccount;
6007
6008     alter table DeterminationEvent
6009         add constraint FK1DB24973DA462D5
6010         foreign key (actor_id)
6011         references AgentBase;
6012
6013     alter table DeterminationEvent
6014         add constraint FK1DB2497DE9A3E39
6015         foreign key (taxon_id)
6016         references TaxonBase;
6017
6018     alter table DeterminationEvent
6019         add constraint FK1DB24974B251DAD
6020         foreign key (identifiedunit_id)
6021         references SpecimenOrObservationBase;
6022
6023     alter table DeterminationEvent
6024         add constraint FK1DB2497378D1BD
6025         foreign key (modifier_id)
6026         references DefinedTermBase;
6027
6028     alter table DeterminationEvent
6029         add constraint FK1DB2497BC5DA539
6030         foreign key (updatedby_id)
6031         references UserAccount;
6032
6033     alter table DeterminationEvent_AUD
6034         add constraint FKA0252EE834869AAE
6035         foreign key (REV)
6036         references AuditEvent;
6037
6038     alter table DeterminationEvent_Annotation
6039         add constraint FKB74F03F76BE0BFDA
6040         foreign key (DeterminationEvent_id)
6041         references DeterminationEvent;
6042
6043     alter table DeterminationEvent_Annotation
6044         add constraint FKB74F03F71E403E0B
6045         foreign key (annotations_id)
6046         references Annotation;
6047
6048     alter table DeterminationEvent_Annotation_AUD
6049         add constraint FKAFDA5E4834869AAE
6050         foreign key (REV)
6051         references AuditEvent;
6052
6053     alter table DeterminationEvent_Marker
6054         add constraint FK5C475102777265A1
6055         foreign key (markers_id)
6056         references Marker;
6057
6058     alter table DeterminationEvent_Marker
6059         add constraint FK5C4751026BE0BFDA
6060         foreign key (DeterminationEvent_id)
6061         references DeterminationEvent;
6062
6063     alter table DeterminationEvent_Marker_AUD
6064         add constraint FK567F2DD334869AAE
6065         foreign key (REV)
6066         references AuditEvent;
6067
6068     alter table DeterminationEvent_Reference
6069         add constraint FK8FB1ED833EF09CD5
6070         foreign key (setofreferences_id)
6071         references Reference;
6072
6073     alter table DeterminationEvent_Reference
6074         add constraint FK8FB1ED836BE0BFDA
6075         foreign key (DeterminationEvent_id)
6076         references DeterminationEvent;
6077
6078     alter table DeterminationEvent_Reference_AUD
6079         add constraint FK6255A1D434869AAE
6080         foreign key (REV)
6081         references AuditEvent;
6082
6083     alter table Extension
6084         add constraint FK52EF3C1F4FF2DB2C
6085         foreign key (createdby_id)
6086         references UserAccount;
6087
6088     alter table Extension
6089         add constraint FK52EF3C1FAD392BD3
6090         foreign key (type_id)
6091         references DefinedTermBase;
6092
6093     alter table Extension
6094         add constraint FK52EF3C1FBC5DA539
6095         foreign key (updatedby_id)
6096         references UserAccount;
6097
6098     alter table Extension_AUD
6099         add constraint FK92D2427034869AAE
6100         foreign key (REV)
6101         references AuditEvent;
6102
6103     alter table FeatureNode
6104         add constraint FK4CEED9F84FF2DB2C
6105         foreign key (createdby_id)
6106         references UserAccount;
6107
6108     alter table FeatureNode
6109         add constraint FK4CEED9F8E0AD2C03
6110         foreign key (parent_fk)
6111         references FeatureNode;
6112
6113     alter table FeatureNode
6114         add constraint FK4CEED9F84220AFEB
6115         foreign key (feature_id)
6116         references DefinedTermBase;
6117
6118     alter table FeatureNode
6119         add constraint FK4CEED9F8DE9A3E39
6120         foreign key (taxon_id)
6121         references TaxonBase;
6122
6123     alter table FeatureNode
6124         add constraint FK4CEED9F8BC5DA539
6125         foreign key (updatedby_id)
6126         references UserAccount;
6127
6128     alter table FeatureNode_AUD
6129         add constraint FK25AD4BC934869AAE
6130         foreign key (REV)
6131         references AuditEvent;
6132
6133     alter table FeatureNode_DefinedTermBase_InapplicableIf
6134         add constraint FK56833D011128E63B
6135         foreign key (inapplicableif_id)
6136         references DefinedTermBase;
6137
6138     alter table FeatureNode_DefinedTermBase_InapplicableIf
6139         add constraint FK56833D0152FCC4B
6140         foreign key (FeatureNode_id)
6141         references FeatureNode;
6142
6143     alter table FeatureNode_DefinedTermBase_InapplicableIf_AUD
6144         add constraint FKB8D7025234869AAE
6145         foreign key (REV)
6146         references AuditEvent;
6147
6148     alter table FeatureNode_DefinedTermBase_OnlyApplicable
6149         add constraint FK6AE876AB57FA94D4
6150         foreign key (onlyapplicableif_id)
6151         references DefinedTermBase;
6152
6153     alter table FeatureNode_DefinedTermBase_OnlyApplicable
6154         add constraint FK6AE876AB52FCC4B
6155         foreign key (FeatureNode_id)
6156         references FeatureNode;
6157
6158     alter table FeatureNode_DefinedTermBase_OnlyApplicable_AUD
6159         add constraint FK3F5356FC34869AAE
6160         foreign key (REV)
6161         references AuditEvent;
6162
6163     alter table FeatureNode_Representation
6164         add constraint FK98668A14ED54F5E0
6165         foreign key (questions_id)
6166         references Representation;
6167
6168     alter table FeatureNode_Representation
6169         add constraint FK98668A1452FCC4B
6170         foreign key (FeatureNode_id)
6171         references FeatureNode;
6172
6173     alter table FeatureNode_Representation_AUD
6174         add constraint FK8F578DE534869AAE
6175         foreign key (REV)
6176         references AuditEvent;
6177
6178     alter table FeatureTree
6179         add constraint FK4CF19F944FF2DB2C
6180         foreign key (createdby_id)
6181         references UserAccount;
6182
6183     alter table FeatureTree
6184         add constraint FK4CF19F94B7892921
6185         foreign key (root_id)
6186         references FeatureNode;
6187
6188     alter table FeatureTree
6189         add constraint FK4CF19F94BC5DA539
6190         foreign key (updatedby_id)
6191         references UserAccount;
6192
6193     alter table FeatureTree_AUD
6194         add constraint FK355BE36534869AAE
6195         foreign key (REV)
6196         references AuditEvent;
6197
6198     alter table FeatureTree_Annotation
6199         add constraint FK5D8B8DA47C496CB
6200         foreign key (FeatureTree_id)
6201         references FeatureTree;
6202
6203     alter table FeatureTree_Annotation
6204         add constraint FK5D8B8DA1E403E0B
6205         foreign key (annotations_id)
6206         references Annotation;
6207
6208     alter table FeatureTree_Annotation_AUD
6209         add constraint FK86E8E9AB34869AAE
6210         foreign key (REV)
6211         references AuditEvent;
6212
6213     alter table FeatureTree_Credit
6214         add constraint FK7536062432D1B9F
6215         foreign key (credits_id)
6216         references Credit;
6217
6218     alter table FeatureTree_Credit
6219         add constraint FK7536062447C496CB
6220         foreign key (FeatureTree_id)
6221         references FeatureTree;
6222
6223     alter table FeatureTree_Credit_AUD
6224         add constraint FK40EA81F534869AAE
6225         foreign key (REV)
6226         references AuditEvent;
6227
6228     alter table FeatureTree_Extension
6229         add constraint FKAD1E6D34927DE9DF
6230         foreign key (extensions_id)
6231         references Extension;
6232
6233     alter table FeatureTree_Extension
6234         add constraint FKAD1E6D3447C496CB
6235         foreign key (FeatureTree_id)
6236         references FeatureTree;
6237
6238     alter table FeatureTree_Extension_AUD
6239         add constraint FKF128E10534869AAE
6240         foreign key (REV)
6241         references AuditEvent;
6242
6243     alter table FeatureTree_Marker
6244         add constraint FK855CEF65777265A1
6245         foreign key (markers_id)
6246         references Marker;
6247
6248     alter table FeatureTree_Marker
6249         add constraint FK855CEF6547C496CB
6250         foreign key (FeatureTree_id)
6251         references FeatureTree;
6252
6253     alter table FeatureTree_Marker_AUD
6254         add constraint FKA508E2B634869AAE
6255         foreign key (REV)
6256         references AuditEvent;
6257
6258     alter table FeatureTree_OriginalSourceBase
6259         add constraint FK13BD64E847C496CB
6260         foreign key (FeatureTree_id)
6261         references FeatureTree;
6262
6263     alter table FeatureTree_OriginalSourceBase
6264         add constraint FK13BD64E83A6735D9
6265         foreign key (sources_id)
6266         references OriginalSourceBase;
6267
6268     alter table FeatureTree_OriginalSourceBase_AUD
6269         add constraint FK7B5CDEB934869AAE
6270         foreign key (REV)
6271         references AuditEvent;
6272
6273     alter table FeatureTree_Representation
6274         add constraint FK8C458F8B31C4747
6275         foreign key (representations_id)
6276         references Representation;
6277
6278     alter table FeatureTree_Representation
6279         add constraint FK8C458F847C496CB
6280         foreign key (FeatureTree_id)
6281         references FeatureTree;
6282
6283     alter table FeatureTree_Representation_AUD
6284         add constraint FKECAB4AC934869AAE
6285         foreign key (REV)
6286         references AuditEvent;
6287
6288     alter table FeatureTree_Rights
6289         add constraint FK8E50DD0247C496CB
6290         foreign key (FeatureTree_id)
6291         references FeatureTree;
6292
6293     alter table FeatureTree_Rights
6294         add constraint FK8E50DD02C13F7B21
6295         foreign key (rights_id)
6296         references Rights;
6297
6298     alter table FeatureTree_Rights_AUD
6299         add constraint FK10E2B9D334869AAE
6300         foreign key (REV)
6301         references AuditEvent;
6302
6303     alter table FeatureTree_TaxonBase
6304         add constraint FKEC78E5B0ED57882F
6305         foreign key (FeatureTree_id)
6306         references FeatureTree;
6307
6308     alter table FeatureTree_TaxonBase
6309         add constraint FKEC78E5B07C3D0017
6310         foreign key (coveredtaxa_id)
6311         references TaxonBase;
6312
6313     alter table FeatureTree_TaxonBase_AUD
6314         add constraint FK955ABB8134869AAE
6315         foreign key (REV)
6316         references AuditEvent;
6317
6318     alter table GatheringEvent
6319         add constraint FK6F1286F38B455EC6
6320         foreign key (locality_id)
6321         references LanguageString;
6322
6323     alter table GatheringEvent
6324         add constraint FK6F1286F34FF2DB2C
6325         foreign key (createdby_id)
6326         references UserAccount;
6327
6328     alter table GatheringEvent
6329         add constraint FK6F1286F33DA462D5
6330         foreign key (actor_id)
6331         references AgentBase;
6332
6333     alter table GatheringEvent
6334         add constraint FK6F1286F3F55AFD89
6335         foreign key (exactlocation_referencesystem_id)
6336         references DefinedTermBase;
6337
6338     alter table GatheringEvent
6339         add constraint FK6F1286F3BC5DA539
6340         foreign key (updatedby_id)
6341         references UserAccount;
6342
6343     alter table GatheringEvent_AUD
6344         add constraint FK3EC034434869AAE
6345         foreign key (REV)
6346         references AuditEvent;
6347
6348     alter table GatheringEvent_Annotation
6349         add constraint FK76DDD01BF95F225A
6350         foreign key (GatheringEvent_id)
6351         references GatheringEvent;
6352
6353     alter table GatheringEvent_Annotation
6354         add constraint FK76DDD01B1E403E0B
6355         foreign key (annotations_id)
6356         references Annotation;
6357
6358     alter table GatheringEvent_Annotation_AUD
6359         add constraint FK351E786C34869AAE
6360         foreign key (REV)
6361         references AuditEvent;
6362
6363     alter table GatheringEvent_DefinedTermBase
6364         add constraint FK69D9A11A7C34B6D6
6365         foreign key (collectingareas_id)
6366         references DefinedTermBase;
6367
6368     alter table GatheringEvent_DefinedTermBase
6369         add constraint FK69D9A11AF95F225A
6370         foreign key (GatheringEvent_id)
6371         references GatheringEvent;
6372
6373     alter table GatheringEvent_DefinedTermBase_AUD
6374         add constraint FKB3BBB1EB34869AAE
6375         foreign key (REV)
6376         references AuditEvent;
6377
6378     alter table GatheringEvent_Marker
6379         add constraint FK7B49CF26777265A1
6380         foreign key (markers_id)
6381         references Marker;
6382
6383     alter table GatheringEvent_Marker
6384         add constraint FK7B49CF26F95F225A
6385         foreign key (GatheringEvent_id)
6386         references GatheringEvent;
6387
6388     alter table GatheringEvent_Marker_AUD
6389         add constraint FK160DF9F734869AAE
6390         foreign key (REV)
6391         references AuditEvent;
6392
6393     alter table GenBankAccession
6394         add constraint FK86C1DBF84FF2DB2C
6395         foreign key (createdby_id)
6396         references UserAccount;
6397
6398     alter table GenBankAccession
6399         add constraint FK86C1DBF8BC5DA539
6400         foreign key (updatedby_id)
6401         references UserAccount;
6402
6403     alter table GenBankAccession_AUD
6404         add constraint FK5A2F4DC934869AAE
6405         foreign key (REV)
6406         references AuditEvent;
6407
6408     alter table GrantedAuthorityImpl
6409         add constraint FKB05CF9284FF2DB2C
6410         foreign key (createdby_id)
6411         references UserAccount;
6412
6413     alter table HomotypicalGroup
6414         add constraint FK7DECCC184FF2DB2C
6415         foreign key (createdby_id)
6416         references UserAccount;
6417
6418     alter table HomotypicalGroup
6419         add constraint FK7DECCC18BC5DA539
6420         foreign key (updatedby_id)
6421         references UserAccount;
6422
6423     alter table HomotypicalGroup_AUD
6424         add constraint FKE4252DE934869AAE
6425         foreign key (REV)
6426         references AuditEvent;
6427
6428     alter table HomotypicalGroup_Annotation
6429         add constraint FK7A0351D6BFEAE500
6430         foreign key (HomotypicalGroup_id)
6431         references HomotypicalGroup;
6432
6433     alter table HomotypicalGroup_Annotation
6434         add constraint FK7A0351D61E403E0B
6435         foreign key (annotations_id)
6436         references Annotation;
6437
6438     alter table HomotypicalGroup_Annotation_AUD
6439         add constraint FK41E6A4A734869AAE
6440         foreign key (REV)
6441         references AuditEvent;
6442
6443     alter table HomotypicalGroup_Marker
6444         add constraint FK97D36661777265A1
6445         foreign key (markers_id)
6446         references Marker;
6447
6448     alter table HomotypicalGroup_Marker
6449         add constraint FK97D36661BFEAE500
6450         foreign key (HomotypicalGroup_id)
6451         references HomotypicalGroup;
6452
6453     alter table HomotypicalGroup_Marker_AUD
6454         add constraint FK19337BB234869AAE
6455         foreign key (REV)
6456         references AuditEvent;
6457
6458     alter table HybridRelationship
6459         add constraint FK9033CE744FF2DB2C
6460         foreign key (createdby_id)
6461         references UserAccount;
6462
6463     alter table HybridRelationship
6464         add constraint FK9033CE749803512F
6465         foreign key (citation_id)
6466         references Reference;
6467
6468     alter table HybridRelationship
6469         add constraint FK9033CE749DD57A93
6470         foreign key (relatedfrom_id)
6471         references TaxonNameBase;
6472
6473     alter table HybridRelationship
6474         add constraint FK9033CE7455F241D4
6475         foreign key (type_id)
6476         references DefinedTermBase;
6477
6478     alter table HybridRelationship
6479         add constraint FK9033CE74AF4F9F62
6480         foreign key (relatedto_id)
6481         references TaxonNameBase;
6482
6483     alter table HybridRelationship
6484         add constraint FK9033CE74BC5DA539
6485         foreign key (updatedby_id)
6486         references UserAccount;
6487
6488     alter table HybridRelationship_AUD
6489         add constraint FK9C2BA24534869AAE
6490         foreign key (REV)
6491         references AuditEvent;
6492
6493     alter table HybridRelationship_Annotation
6494         add constraint FK2C7E7DFA59832240
6495         foreign key (HybridRelationship_id)
6496         references HybridRelationship;
6497
6498     alter table HybridRelationship_Annotation
6499         add constraint FK2C7E7DFA1E403E0B
6500         foreign key (annotations_id)
6501         references Annotation;
6502
6503     alter table HybridRelationship_Annotation_AUD
6504         add constraint FKACE71ECB34869AAE
6505         foreign key (REV)
6506         references AuditEvent;
6507
6508     alter table HybridRelationship_Marker
6509         add constraint FKCEF24485777265A1
6510         foreign key (markers_id)
6511         references Marker;
6512
6513     alter table HybridRelationship_Marker
6514         add constraint FKCEF2448559832240
6515         foreign key (HybridRelationship_id)
6516         references HybridRelationship;
6517
6518     alter table HybridRelationship_Marker_AUD
6519         add constraint FKCBAEA7D634869AAE
6520         foreign key (REV)
6521         references AuditEvent;
6522
6523     alter table IndividualAssociation_LanguageString
6524         add constraint FKB5C75EC028459272
6525         foreign key (description_mapkey_id)
6526         references DefinedTermBase;
6527
6528     alter table IndividualAssociation_LanguageString
6529         add constraint FKB5C75EC084FF3EDF
6530         foreign key (DescriptionElementBase_id)
6531         references DescriptionElementBase;
6532
6533     alter table IndividualAssociation_LanguageString
6534         add constraint FKB5C75EC02BEBA58D
6535         foreign key (description_id)
6536         references LanguageString;
6537
6538     alter table IndividualAssociation_LanguageString_AUD
6539         add constraint FKB1A62C9134869AAE
6540         foreign key (REV)
6541         references AuditEvent;
6542
6543     alter table InstitutionalMembership
6544         add constraint FK3C8E1FF94FF2DB2C
6545         foreign key (createdby_id)
6546         references UserAccount;
6547
6548     alter table InstitutionalMembership
6549         add constraint FK3C8E1FF9AAC1B820
6550         foreign key (person_id)
6551         references AgentBase;
6552
6553     alter table InstitutionalMembership
6554         add constraint FK3C8E1FF916B9CA77
6555         foreign key (institute_id)
6556         references AgentBase;
6557
6558     alter table InstitutionalMembership
6559         add constraint FK3C8E1FF9BC5DA539
6560         foreign key (updatedby_id)
6561         references UserAccount;
6562
6563     alter table InstitutionalMembership_AUD
6564         add constraint FK847A94A34869AAE
6565         foreign key (REV)
6566         references AuditEvent;
6567
6568     alter table LSIDAuthority
6569         add constraint FK759DB8814FF2DB2C
6570         foreign key (createdby_id)
6571         references UserAccount;
6572
6573     alter table LSIDAuthority_namespaces
6574         add constraint FKB04948F64FFCFD94
6575         foreign key (LSIDAuthority_id)
6576         references LSIDAuthority;
6577
6578     alter table LanguageString
6579         add constraint FKB5FDC9A94FF2DB2C
6580         foreign key (createdby_id)
6581         references UserAccount;
6582
6583     alter table LanguageString
6584         add constraint FKB5FDC9A9E8D36B00
6585         foreign key (language_id)
6586         references DefinedTermBase;
6587
6588     alter table LanguageString
6589         add constraint FKB5FDC9A9BC5DA539
6590         foreign key (updatedby_id)
6591         references UserAccount;
6592
6593     alter table LanguageString_AUD
6594         add constraint FK896AFAFA34869AAE
6595         foreign key (REV)
6596         references AuditEvent;
6597
6598     alter table LanguageString_Annotation
6599         add constraint FK8400DFA537998500
6600         foreign key (LanguageString_id)
6601         references LanguageString;
6602
6603     alter table LanguageString_Annotation
6604         add constraint FK8400DFA51E403E0B
6605         foreign key (annotations_id)
6606         references Annotation;
6607
6608     alter table LanguageString_Annotation_AUD
6609         add constraint FKD3BAB2F634869AAE
6610         foreign key (REV)
6611         references AuditEvent;
6612
6613     alter table LanguageString_Marker
6614         add constraint FK8DA633B0777265A1
6615         foreign key (markers_id)
6616         references Marker;
6617
6618     alter table LanguageString_Marker
6619         add constraint FK8DA633B037998500
6620         foreign key (LanguageString_id)
6621         references LanguageString;
6622
6623     alter table LanguageString_Marker_AUD
6624         add constraint FK2331098134869AAE
6625         foreign key (REV)
6626         references AuditEvent;
6627
6628     alter table Locus
6629         add constraint FK462F1BE4FF2DB2C
6630         foreign key (createdby_id)
6631         references UserAccount;
6632
6633     alter table Locus
6634         add constraint FK462F1BEBC5DA539
6635         foreign key (updatedby_id)
6636         references UserAccount;
6637
6638     alter table Locus_AUD
6639         add constraint FK5224108F34869AAE
6640         foreign key (REV)
6641         references AuditEvent;
6642
6643     alter table Marker
6644         add constraint FK88F1805A4FF2DB2C
6645         foreign key (createdby_id)
6646         references UserAccount;
6647
6648     alter table Marker
6649         add constraint FK88F1805AD64DC020
6650         foreign key (markertype_id)
6651         references DefinedTermBase;
6652
6653     alter table Marker
6654         add constraint FK88F1805ABC5DA539
6655         foreign key (updatedby_id)
6656         references UserAccount;
6657
6658     alter table Marker_AUD
6659         add constraint FKB951F12B34869AAE
6660         foreign key (REV)
6661         references AuditEvent;
6662
6663     alter table Media
6664         add constraint FK46C7FC44FF2DB2C
6665         foreign key (createdby_id)
6666         references UserAccount;
6667
6668     alter table Media
6669         add constraint FK46C7FC49803512F
6670         foreign key (citation_id)
6671         references Reference;
6672
6673     alter table Media
6674         add constraint FK46C7FC4C2445443
6675         foreign key (artist_id)
6676         references AgentBase;
6677
6678     alter table Media
6679         add constraint FK46C7FC4BC5DA539
6680         foreign key (updatedby_id)
6681         references UserAccount;
6682
6683     alter table MediaKey_NamedArea
6684         add constraint FK31E7D4023FF8E7B2
6685         foreign key (geographicalscope_id)
6686         references DefinedTermBase;
6687
6688     alter table MediaKey_NamedArea
6689         add constraint FK31E7D402BE59D760
6690         foreign key (Media_id)
6691         references Media;
6692
6693     alter table MediaKey_NamedArea_AUD
6694         add constraint FK922630D334869AAE
6695         foreign key (REV)
6696         references AuditEvent;
6697
6698     alter table MediaKey_Scope
6699         add constraint FKBFFEE8F0BE59D760
6700         foreign key (Media_id)
6701         references Media;
6702
6703     alter table MediaKey_Scope
6704         add constraint FKBFFEE8F0546985E4
6705         foreign key (scoperestrictions_id)
6706         references DefinedTermBase;
6707
6708     alter table MediaKey_Scope_AUD
6709         add constraint FK63AD1EC134869AAE
6710         foreign key (REV)
6711         references AuditEvent;
6712
6713     alter table MediaKey_Taxon
6714         add constraint FKC00C3966815C793
6715         foreign key (mediaKey_fk)
6716         references Media;
6717
6718     alter table MediaKey_Taxon
6719         add constraint FKC00C3966DE9A3DE3
6720         foreign key (taxon_fk)
6721         references TaxonBase;
6722
6723     alter table MediaKey_Taxon_AUD
6724         add constraint FK311443734869AAE
6725         foreign key (REV)
6726         references AuditEvent;
6727
6728     alter table MediaRepresentation
6729         add constraint FK1966BDB14FF2DB2C
6730         foreign key (createdby_id)
6731         references UserAccount;
6732
6733     alter table MediaRepresentation
6734         add constraint FK1966BDB1C2C29593
6735         foreign key (media_id)
6736         references Media;
6737
6738     alter table MediaRepresentation
6739         add constraint FK1966BDB1BC5DA539
6740         foreign key (updatedby_id)
6741         references UserAccount;
6742
6743     alter table MediaRepresentationPart
6744         add constraint FK67A455444FF2DB2C
6745         foreign key (createdby_id)
6746         references UserAccount;
6747
6748     alter table MediaRepresentationPart
6749         add constraint FK67A45544E3818E37
6750         foreign key (representation_id)
6751         references MediaRepresentation;
6752
6753     alter table MediaRepresentationPart
6754         add constraint FK67A45544BC5DA539
6755         foreign key (updatedby_id)
6756         references UserAccount;
6757
6758     alter table MediaRepresentationPart_AUD
6759         add constraint FKA75C411534869AAE
6760         foreign key (REV)
6761         references AuditEvent;
6762
6763     alter table MediaRepresentation_AUD
6764         add constraint FK67AAAB0234869AAE
6765         foreign key (REV)
6766         references AuditEvent;
6767
6768     alter table MediaRepresentation_MediaRepresentationPart_AUD
6769         add constraint FK3544378734869AAE
6770         foreign key (REV)
6771         references AuditEvent;
6772
6773     alter table Media_AUD
6774         add constraint FKF70B2B9534869AAE
6775         foreign key (REV)
6776         references AuditEvent;
6777
6778     alter table Media_Annotation
6779         add constraint FKA020DAAAC2C29593
6780         foreign key (Media_id)
6781         references Media;
6782
6783     alter table Media_Annotation
6784         add constraint FKA020DAAA1E403E0B
6785         foreign key (annotations_id)
6786         references Annotation;
6787
6788     alter table Media_Annotation_AUD
6789         add constraint FK99ABA37B34869AAE
6790         foreign key (REV)
6791         references AuditEvent;
6792
6793     alter table Media_Credit
6794         add constraint FKC1F78FF432D1B9F
6795         foreign key (credits_id)
6796         references Credit;
6797
6798     alter table Media_Credit
6799         add constraint FKC1F78FF4C2C29593
6800         foreign key (Media_id)
6801         references Media;
6802
6803     alter table Media_Credit_AUD
6804         add constraint FKDB32A3C534869AAE
6805         foreign key (REV)
6806         references AuditEvent;
6807
6808     alter table Media_Description
6809         add constraint FK368283E128459272
6810         foreign key (description_mapkey_id)
6811         references DefinedTermBase;
6812
6813     alter table Media_Description
6814         add constraint FK368283E12BEBA58D
6815         foreign key (description_id)
6816         references LanguageString;
6817
6818     alter table Media_Description
6819         add constraint FK368283E1C2C29593
6820         foreign key (Media_id)
6821         references Media;
6822
6823     alter table Media_Description_AUD
6824         add constraint FK6817D93234869AAE
6825         foreign key (REV)
6826         references AuditEvent;
6827
6828     alter table Media_Extension
6829         add constraint FKDB62D164927DE9DF
6830         foreign key (extensions_id)
6831         references Extension;
6832
6833     alter table Media_Extension
6834         add constraint FKDB62D164C2C29593
6835         foreign key (Media_id)
6836         references Media;
6837
6838     alter table Media_Extension_AUD
6839         add constraint FKE13FAD3534869AAE
6840         foreign key (REV)
6841         references AuditEvent;
6842
6843     alter table Media_LanguageString
6844         add constraint FK353DB784A0A6EDCE
6845         foreign key (title_mapkey_id)
6846         references DefinedTermBase;
6847
6848     alter table Media_LanguageString
6849         add constraint FK353DB784C2C29593
6850         foreign key (Media_id)
6851         references Media;
6852
6853     alter table Media_LanguageString
6854         add constraint FK353DB784A1CA19B1
6855         foreign key (title_id)
6856         references LanguageString;
6857
6858     alter table Media_LanguageString_AUD
6859         add constraint FK68FA835534869AAE
6860         foreign key (REV)
6861         references AuditEvent;
6862
6863     alter table Media_Marker
6864         add constraint FKD21E7935777265A1
6865         foreign key (markers_id)
6866         references Marker;
6867
6868     alter table Media_Marker
6869         add constraint FKD21E7935C2C29593
6870         foreign key (Media_id)
6871         references Media;
6872
6873     alter table Media_Marker_AUD
6874         add constraint FK3F51048634869AAE
6875         foreign key (REV)
6876         references AuditEvent;
6877
6878     alter table Media_OriginalSourceBase
6879         add constraint FK2FEEB6B8C2C29593
6880         foreign key (Media_id)
6881         references Media;
6882
6883     alter table Media_OriginalSourceBase
6884         add constraint FK2FEEB6B83A6735D9
6885         foreign key (sources_id)
6886         references OriginalSourceBase;
6887
6888     alter table Media_OriginalSourceBase_AUD
6889         add constraint FK97F0C88934869AAE
6890         foreign key (REV)
6891         references AuditEvent;
6892
6893     alter table Media_Representation
6894         add constraint FK1B8712C8BE59D760
6895         foreign key (Media_id)
6896         references Media;
6897
6898     alter table Media_Representation
6899         add constraint FK1B8712C88F6CABE6
6900         foreign key (keyrepresentations_id)
6901         references Representation;
6902
6903     alter table Media_Representation_AUD
6904         add constraint FK8DC9C9934869AAE
6905         foreign key (REV)
6906         references AuditEvent;
6907
6908     alter table Media_Rights
6909         add constraint FKDB1266D2C13F7B21
6910         foreign key (rights_id)
6911         references Rights;
6912
6913     alter table Media_Rights
6914         add constraint FKDB1266D2C2C29593
6915         foreign key (Media_id)
6916         references Media;
6917
6918     alter table Media_Rights_AUD
6919         add constraint FKAB2ADBA334869AAE
6920         foreign key (REV)
6921         references AuditEvent;
6922
6923     alter table Media_Sequence
6924         add constraint FK61D09FCF29B4761
6925         foreign key (usedsequences_id)
6926         references Sequence;
6927
6928     alter table Media_Sequence
6929         add constraint FK61D09FC3282B64
6930         foreign key (Media_id)
6931         references Media;
6932
6933     alter table Media_Sequence_AUD
6934         add constraint FK3C7BD9CD34869AAE
6935         foreign key (REV)
6936         references AuditEvent;
6937
6938     alter table Media_TaxonBase
6939         add constraint FK1ABD49E0BE59D760
6940         foreign key (Media_id)
6941         references Media;
6942
6943     alter table Media_TaxonBase
6944         add constraint FK1ABD49E07C3D0017
6945         foreign key (coveredtaxa_id)
6946         references TaxonBase;
6947
6948     alter table Media_TaxonBase_AUD
6949         add constraint FK857187B134869AAE
6950         foreign key (REV)
6951         references AuditEvent;
6952
6953     alter table MultiAccessKey_NamedArea
6954         add constraint FK1F5A74893FF8E7B2
6955         foreign key (geographicalscope_id)
6956         references DefinedTermBase;
6957
6958     alter table MultiAccessKey_NamedArea
6959         add constraint FK1F5A7489B4555A9A
6960         foreign key (WorkingSet_id)
6961         references WorkingSet;
6962
6963     alter table MultiAccessKey_NamedArea_AUD
6964         add constraint FK4CB735DA34869AAE
6965         foreign key (REV)
6966         references AuditEvent;
6967
6968     alter table MultiAccessKey_Scope
6969         add constraint FKCC6CE4F7546985E4
6970         foreign key (scoperestrictions_id)
6971         references DefinedTermBase;
6972
6973     alter table MultiAccessKey_Scope
6974         add constraint FKCC6CE4F7B4555A9A
6975         foreign key (WorkingSet_id)
6976         references WorkingSet;
6977
6978     alter table MultiAccessKey_Scope_AUD
6979         add constraint FK511FBF4834869AAE
6980         foreign key (REV)
6981         references AuditEvent;
6982
6983     alter table MultiAccessKey_Taxon
6984         add constraint FKCC7A356DB64A7AD3
6985         foreign key (multiAccessKey_fk)
6986         references WorkingSet;
6987
6988     alter table MultiAccessKey_Taxon
6989         add constraint FKCC7A356DDE9A3DE3
6990         foreign key (taxon_fk)
6991         references TaxonBase;
6992
6993     alter table MultiAccessKey_Taxon_AUD
6994         add constraint FKF083E4BE34869AAE
6995         foreign key (REV)
6996         references AuditEvent;
6997
6998     alter table NameRelationship
6999         add constraint FK5E510834FF2DB2C
7000         foreign key (createdby_id)
7001         references UserAccount;
7002
7003     alter table NameRelationship
7004         add constraint FK5E510839803512F
7005         foreign key (citation_id)
7006         references Reference;
7007
7008     alter table NameRelationship
7009         add constraint FK5E5108316CDFF85
7010         foreign key (relatedfrom_id)
7011         references TaxonNameBase;
7012
7013     alter table NameRelationship
7014         add constraint FK5E51083AF619DE3
7015         foreign key (type_id)
7016         references DefinedTermBase;
7017
7018     alter table NameRelationship
7019         add constraint FK5E5108328482454
7020         foreign key (relatedto_id)
7021         references TaxonNameBase;
7022
7023     alter table NameRelationship
7024         add constraint FK5E51083BC5DA539
7025         foreign key (updatedby_id)
7026         references UserAccount;
7027
7028     alter table NameRelationship_AUD
7029         add constraint FK743F44D434869AAE
7030         foreign key (REV)
7031         references AuditEvent;
7032
7033     alter table NameRelationship_Annotation
7034         add constraint FK2E38AC8B7B4CB560
7035         foreign key (NameRelationship_id)
7036         references NameRelationship;
7037
7038     alter table NameRelationship_Annotation
7039         add constraint FK2E38AC8B1E403E0B
7040         foreign key (annotations_id)
7041         references Annotation;
7042
7043     alter table NameRelationship_Annotation_AUD
7044         add constraint FKD1D59CDC34869AAE
7045         foreign key (REV)
7046         references AuditEvent;
7047
7048     alter table NameRelationship_Marker
7049         add constraint FKE3E46396777265A1
7050         foreign key (markers_id)
7051         references Marker;
7052
7053     alter table NameRelationship_Marker
7054         add constraint FKE3E463967B4CB560
7055         foreign key (NameRelationship_id)
7056         references NameRelationship;
7057
7058     alter table NameRelationship_Marker_AUD
7059         add constraint FKCD68D66734869AAE
7060         foreign key (REV)
7061         references AuditEvent;
7062
7063     alter table NomenclaturalStatus
7064         add constraint FK1FFEC88B4FF2DB2C
7065         foreign key (createdby_id)
7066         references UserAccount;
7067
7068     alter table NomenclaturalStatus
7069         add constraint FK1FFEC88B9803512F
7070         foreign key (citation_id)
7071         references Reference;
7072
7073     alter table NomenclaturalStatus
7074         add constraint FK1FFEC88B7029BD9F
7075         foreign key (type_id)
7076         references DefinedTermBase;
7077
7078     alter table NomenclaturalStatus
7079         add constraint FK1FFEC88BBC5DA539
7080         foreign key (updatedby_id)
7081         references UserAccount;
7082
7083     alter table NomenclaturalStatus_AUD
7084         add constraint FKFB2DB8DC34869AAE
7085         foreign key (REV)
7086         references AuditEvent;
7087
7088     alter table NomenclaturalStatus_Annotation
7089         add constraint FKE6E91F838D2CB1D4
7090         foreign key (NomenclaturalStatus_id)
7091         references NomenclaturalStatus;
7092
7093     alter table NomenclaturalStatus_Annotation
7094         add constraint FKE6E91F831E403E0B
7095         foreign key (annotations_id)
7096         references Annotation;
7097
7098     alter table NomenclaturalStatus_Annotation_AUD
7099         add constraint FK6A3D3D434869AAE
7100         foreign key (REV)
7101         references AuditEvent;
7102
7103     alter table NomenclaturalStatus_Marker
7104         add constraint FK2F5128E777265A1
7105         foreign key (markers_id)
7106         references Marker;
7107
7108     alter table NomenclaturalStatus_Marker
7109         add constraint FK2F5128E8D2CB1D4
7110         foreign key (NomenclaturalStatus_id)
7111         references NomenclaturalStatus;
7112
7113     alter table NomenclaturalStatus_Marker_AUD
7114         add constraint FK8619495F34869AAE
7115         foreign key (REV)
7116         references AuditEvent;
7117
7118     alter table OriginalSourceBase
7119         add constraint FK505F2E5D4FF2DB2C
7120         foreign key (createdby_id)
7121         references UserAccount;
7122
7123     alter table OriginalSourceBase
7124         add constraint FK505F2E5D966B96B2
7125         foreign key (nameusedinsource_id)
7126         references TaxonNameBase;
7127
7128     alter table OriginalSourceBase
7129         add constraint FK505F2E5D9803512F
7130         foreign key (citation_id)
7131         references Reference;
7132
7133     alter table OriginalSourceBase
7134         add constraint FK505F2E5DBC5DA539
7135         foreign key (updatedby_id)
7136         references UserAccount;
7137
7138     alter table OriginalSourceBase_AUD
7139         add constraint FK9662E5AE34869AAE
7140         foreign key (REV)
7141         references AuditEvent;
7142
7143     alter table OriginalSourceBase_Annotation
7144         add constraint FK20814271B029DDA0
7145         foreign key (OriginalSourceBase_id)
7146         references OriginalSourceBase;
7147
7148     alter table OriginalSourceBase_Annotation
7149         add constraint FK208142711E403E0B
7150         foreign key (annotations_id)
7151         references Annotation;
7152
7153     alter table OriginalSourceBase_Annotation_AUD
7154         add constraint FKA074CFC234869AAE
7155         foreign key (REV)
7156         references AuditEvent;
7157
7158     alter table OriginalSourceBase_Marker
7159         add constraint FKB3FFDC7C777265A1
7160         foreign key (markers_id)
7161         references Marker;
7162
7163     alter table OriginalSourceBase_Marker
7164         add constraint FKB3FFDC7CB029DDA0
7165         foreign key (OriginalSourceBase_id)
7166         references OriginalSourceBase;
7167
7168     alter table OriginalSourceBase_Marker_AUD
7169         add constraint FKBFB16C4D34869AAE
7170         foreign key (REV)
7171         references AuditEvent;
7172
7173     alter table PermissionGroup
7174         add constraint FK629941D04FF2DB2C
7175         foreign key (createdby_id)
7176         references UserAccount;
7177
7178     alter table PermissionGroup_GrantedAuthorityImpl
7179         add constraint FK5311437CA0971A3
7180         foreign key (PermissionGroup_id)
7181         references PermissionGroup;
7182
7183     alter table PermissionGroup_GrantedAuthorityImpl
7184         add constraint FK53114371857F6C2
7185         foreign key (grantedauthorities_id)
7186         references GrantedAuthorityImpl;
7187
7188     alter table PolytomousKey_NamedArea
7189         add constraint FK1C727CFF3FF8E7B2
7190         foreign key (geographicalscope_id)
7191         references DefinedTermBase;
7192
7193     alter table PolytomousKey_NamedArea
7194         add constraint FK1C727CFFED57882F
7195         foreign key (FeatureTree_id)
7196         references FeatureTree;
7197
7198     alter table PolytomousKey_NamedArea_AUD
7199         add constraint FK750A135034869AAE
7200         foreign key (REV)
7201         references AuditEvent;
7202
7203     alter table PolytomousKey_Scope
7204         add constraint FK8D97986DED57882F
7205         foreign key (FeatureTree_id)
7206         references FeatureTree;
7207
7208     alter table PolytomousKey_Scope
7209         add constraint FK8D97986D546985E4
7210         foreign key (scoperestrictions_id)
7211         references DefinedTermBase;
7212
7213     alter table PolytomousKey_Scope_AUD
7214         add constraint FK4E37C7BE34869AAE
7215         foreign key (REV)
7216         references AuditEvent;
7217
7218     alter table PolytomousKey_Taxon
7219         add constraint FK8DA4E8E389D9775
7220         foreign key (polytomousKey_fk)
7221         references FeatureTree;
7222
7223     alter table PolytomousKey_Taxon
7224         add constraint FK8DA4E8E3DE9A3DE3
7225         foreign key (taxon_fk)
7226         references TaxonBase;
7227
7228     alter table PolytomousKey_Taxon_AUD
7229         add constraint FKED9BED3434869AAE
7230         foreign key (REV)
7231         references AuditEvent;
7232
7233     create index ReferenceTitleCacheIndex on Reference (titleCache);
7234
7235     alter table Reference
7236         add constraint FK404D5F2B4FF2DB2C
7237         foreign key (createdby_id)
7238         references UserAccount;
7239
7240     alter table Reference
7241         add constraint FK404D5F2B403E17F4
7242         foreign key (institution_id)
7243         references AgentBase;
7244
7245     alter table Reference
7246         add constraint FK404D5F2B969F8FF0
7247         foreign key (inreference_id)
7248         references Reference;
7249
7250     alter table Reference
7251         add constraint FK404D5F2BAEC3B8B8
7252         foreign key (school_id)
7253         references AgentBase;
7254
7255     alter table Reference
7256         add constraint FK404D5F2B697665E
7257         foreign key (authorteam_id)
7258         references AgentBase;
7259
7260     alter table Reference
7261         add constraint FK404D5F2BBC5DA539
7262         foreign key (updatedby_id)
7263         references UserAccount;
7264
7265     alter table Reference_AUD
7266         add constraint FK8F0FFF7C34869AAE
7267         foreign key (REV)
7268         references AuditEvent;
7269
7270     alter table Reference_Annotation
7271         add constraint FKFC824E3765B124B
7272         foreign key (Reference_id)
7273         references Reference;
7274
7275     alter table Reference_Annotation
7276         add constraint FKFC824E31E403E0B
7277         foreign key (annotations_id)
7278         references Annotation;
7279
7280     alter table Reference_Annotation_AUD
7281         add constraint FKF3C1293434869AAE
7282         foreign key (REV)
7283         references AuditEvent;
7284
7285     alter table Reference_Credit
7286         add constraint FK5BC6DEAD32D1B9F
7287         foreign key (credits_id)
7288         references Credit;
7289
7290     alter table Reference_Credit
7291         add constraint FK5BC6DEAD765B124B
7292         foreign key (Reference_id)
7293         references Reference;
7294
7295     alter table Reference_Credit_AUD
7296         add constraint FK4AD9EDFE34869AAE
7297         foreign key (REV)
7298         references AuditEvent;
7299
7300     alter table Reference_Extension
7301         add constraint FKDEFCDC0B927DE9DF
7302         foreign key (extensions_id)
7303         references Extension;
7304
7305     alter table Reference_Extension
7306         add constraint FKDEFCDC0B765B124B
7307         foreign key (Reference_id)
7308         references Reference;
7309
7310     alter table Reference_Extension_AUD
7311         add constraint FK1DF60C5C34869AAE
7312         foreign key (REV)
7313         references AuditEvent;
7314
7315     alter table Reference_Marker
7316         add constraint FK6BEDC7EE777265A1
7317         foreign key (markers_id)
7318         references Marker;
7319
7320     alter table Reference_Marker
7321         add constraint FK6BEDC7EE765B124B
7322         foreign key (Reference_id)
7323         references Reference;
7324
7325     alter table Reference_Marker_AUD
7326         add constraint FKAEF84EBF34869AAE
7327         foreign key (REV)
7328         references AuditEvent;
7329
7330     alter table Reference_Media
7331         add constraint FKBBEF5B0765B124B
7332         foreign key (Reference_id)
7333         references Reference;
7334
7335     alter table Reference_Media
7336         add constraint FKBBEF5B0C2C29593
7337         foreign key (media_id)
7338         references Media;
7339
7340     alter table Reference_Media_AUD
7341         add constraint FK8318CB8134869AAE
7342         foreign key (REV)
7343         references AuditEvent;
7344
7345     alter table Reference_OriginalSourceBase
7346         add constraint FKD3E8B7F1765B124B
7347         foreign key (Reference_id)
7348         references Reference;
7349
7350     alter table Reference_OriginalSourceBase
7351         add constraint FKD3E8B7F13A6735D9
7352         foreign key (sources_id)
7353         references OriginalSourceBase;
7354
7355     alter table Reference_OriginalSourceBase_AUD
7356         add constraint FKC025854234869AAE
7357         foreign key (REV)
7358         references AuditEvent;
7359
7360     alter table Reference_Rights
7361         add constraint FK74E1B58BC13F7B21
7362         foreign key (rights_id)
7363         references Rights;
7364
7365     alter table Reference_Rights
7366         add constraint FK74E1B58B765B124B
7367         foreign key (Reference_id)
7368         references Reference;
7369
7370     alter table Reference_Rights_AUD
7371         add constraint FK1AD225DC34869AAE
7372         foreign key (REV)
7373         references AuditEvent;
7374
7375     alter table RelationshipTermBase_inverseRepresentation
7376         add constraint FK98592F33ECEEF4AF
7377         foreign key (DefinedTermBase_id)
7378         references DefinedTermBase;
7379
7380     alter table RelationshipTermBase_inverseRepresentation
7381         add constraint FK98592F33473FB677
7382         foreign key (inverserepresentations_id)
7383         references Representation;
7384
7385     alter table RelationshipTermBase_inverseRepresentation_AUD
7386         add constraint FK5D248B8434869AAE
7387         foreign key (REV)
7388         references AuditEvent;
7389
7390     alter table Representation
7391         add constraint FK9C4724ED4FF2DB2C
7392         foreign key (createdby_id)
7393         references UserAccount;
7394
7395     alter table Representation
7396         add constraint FK9C4724EDE8D36B00
7397         foreign key (language_id)
7398         references DefinedTermBase;
7399
7400     alter table Representation
7401         add constraint FK9C4724EDBC5DA539
7402         foreign key (updatedby_id)
7403         references UserAccount;
7404
7405     alter table Representation_AUD
7406         add constraint FK294D143E34869AAE
7407         foreign key (REV)
7408         references AuditEvent;
7409
7410     alter table Representation_Annotation
7411         add constraint FK371091E147E8AE60
7412         foreign key (Representation_id)
7413         references Representation;
7414
7415     alter table Representation_Annotation
7416         add constraint FK371091E11E403E0B
7417         foreign key (annotations_id)
7418         references Annotation;
7419
7420     alter table Representation_Annotation_AUD
7421         add constraint FK36EEE73234869AAE
7422         foreign key (REV)
7423         references AuditEvent;
7424
7425     alter table Representation_Marker
7426         add constraint FK560063EC777265A1
7427         foreign key (markers_id)
7428         references Marker;
7429
7430     alter table Representation_Marker
7431         add constraint FK560063EC47E8AE60
7432         foreign key (Representation_id)
7433         references Representation;
7434
7435     alter table Representation_Marker_AUD
7436         add constraint FKD640BBBD34869AAE
7437         foreign key (REV)
7438         references AuditEvent;
7439
7440     alter table Rights
7441         add constraint FK91E56DF74FF2DB2C
7442         foreign key (createdby_id)
7443         references UserAccount;
7444
7445     alter table Rights
7446         add constraint FK91E56DF7F7976FC5
7447         foreign key (agent_id)
7448         references AgentBase;
7449
7450     alter table Rights
7451         add constraint FK91E56DF7E6D2886A
7452         foreign key (type_id)
7453         references DefinedTermBase;
7454
7455     alter table Rights
7456         add constraint FK91E56DF7E8D36B00
7457         foreign key (language_id)
7458         references DefinedTermBase;
7459
7460     alter table Rights
7461         add constraint FK91E56DF7BC5DA539
7462         foreign key (updatedby_id)
7463         references UserAccount;
7464
7465     alter table Rights_AUD
7466         add constraint FK252BC84834869AAE
7467         foreign key (REV)
7468         references AuditEvent;
7469
7470     alter table Rights_Annotation
7471         add constraint FK27CB1E97C13F7B21
7472         foreign key (Rights_id)
7473         references Rights;
7474
7475     alter table Rights_Annotation
7476         add constraint FK27CB1E971E403E0B
7477         foreign key (annotations_id)
7478         references Annotation;
7479
7480     alter table Rights_Annotation_AUD
7481         add constraint FKF98828E834869AAE
7482         foreign key (REV)
7483         references AuditEvent;
7484
7485     alter table Rights_Marker
7486         add constraint FKB739BBA2777265A1
7487         foreign key (markers_id)
7488         references Marker;
7489
7490     alter table Rights_Marker
7491         add constraint FKB739BBA2C13F7B21
7492         foreign key (Rights_id)
7493         references Rights;
7494
7495     alter table Rights_Marker_AUD
7496         add constraint FKC6FB487334869AAE
7497         foreign key (REV)
7498         references AuditEvent;
7499
7500     create index sequenceTitleCacheIndex on Sequence (titleCache);
7501
7502     alter table Sequence
7503         add constraint FK544ADBE14FF2DB2C
7504         foreign key (createdby_id)
7505         references UserAccount;
7506
7507     alter table Sequence
7508         add constraint FK544ADBE1B982A103
7509         foreign key (publishedin_id)
7510         references Reference;
7511
7512     alter table Sequence
7513         add constraint FK544ADBE12DBE1F1F
7514         foreign key (locus_id)
7515         references Locus;
7516
7517     alter table Sequence
7518         add constraint FK544ADBE1BC5DA539
7519         foreign key (updatedby_id)
7520         references UserAccount;
7521
7522     alter table Sequence_AUD
7523         add constraint FK39F4313234869AAE
7524         foreign key (REV)
7525         references AuditEvent;
7526
7527     alter table Sequence_Annotation
7528         add constraint FK1010BA6DD57FFDD5
7529         foreign key (Sequence_id)
7530         references Sequence;
7531
7532     alter table Sequence_Annotation
7533         add constraint FK1010BA6D1E403E0B
7534         foreign key (annotations_id)
7535         references Annotation;
7536
7537     alter table Sequence_Annotation_AUD
7538         add constraint FKCB4FE9BE34869AAE
7539         foreign key (REV)
7540         references AuditEvent;
7541
7542     alter table Sequence_Credit
7543         add constraint FK2CFBC93732D1B9F
7544         foreign key (credits_id)
7545         references Credit;
7546
7547     alter table Sequence_Credit
7548         add constraint FK2CFBC937D57FFDD5
7549         foreign key (Sequence_id)
7550         references Sequence;
7551
7552     alter table Sequence_Credit_AUD
7553         add constraint FK4B22838834869AAE
7554         foreign key (REV)
7555         references AuditEvent;
7556
7557     alter table Sequence_Extension
7558         add constraint FK7BE66D41927DE9DF
7559         foreign key (extensions_id)
7560         references Extension;
7561
7562     alter table Sequence_Extension
7563         add constraint FK7BE66D41D57FFDD5
7564         foreign key (Sequence_id)
7565         references Sequence;
7566
7567     alter table Sequence_Extension_AUD
7568         add constraint FK1CA8129234869AAE
7569         foreign key (REV)
7570         references AuditEvent;
7571
7572     alter table Sequence_GenBankAccession
7573         add constraint FK8F698096D57FFDD5
7574         foreign key (Sequence_id)
7575         references Sequence;
7576
7577     alter table Sequence_GenBankAccession
7578         add constraint FK8F69809615C4EF35
7579         foreign key (genbankaccession_id)
7580         references GenBankAccession;
7581
7582     alter table Sequence_GenBankAccession_AUD
7583         add constraint FKC717736734869AAE
7584         foreign key (REV)
7585         references AuditEvent;
7586
7587     alter table Sequence_Marker
7588         add constraint FK3D22B278777265A1
7589         foreign key (markers_id)
7590         references Marker;
7591
7592     alter table Sequence_Marker
7593         add constraint FK3D22B278D57FFDD5
7594         foreign key (Sequence_id)
7595         references Sequence;
7596
7597     alter table Sequence_Marker_AUD
7598         add constraint FKAF40E44934869AAE
7599         foreign key (REV)
7600         references AuditEvent;
7601
7602     alter table Sequence_Media
7603         add constraint FK8E5D91E666ACA7EC
7604         foreign key (chromatograms_id)
7605         references Media;
7606
7607     alter table Sequence_Media
7608         add constraint FK8E5D91E6D57FFDD5
7609         foreign key (Sequence_id)
7610         references Sequence;
7611
7612     alter table Sequence_Media_AUD
7613         add constraint FK20025CB734869AAE
7614         foreign key (REV)
7615         references AuditEvent;
7616
7617     alter table Sequence_OriginalSourceBase
7618         add constraint FKCDB0237BD57FFDD5
7619         foreign key (Sequence_id)
7620         references Sequence;
7621
7622     alter table Sequence_OriginalSourceBase
7623         add constraint FKCDB0237B3A6735D9
7624         foreign key (sources_id)
7625         references OriginalSourceBase;
7626
7627     alter table Sequence_OriginalSourceBase_AUD
7628         add constraint FK69D81BCC34869AAE
7629         foreign key (REV)
7630         references AuditEvent;
7631
7632     alter table Sequence_Reference
7633         add constraint FK6944904D7291F8A
7634         foreign key (citations_id)
7635         references Reference;
7636
7637     alter table Sequence_Reference
7638         add constraint FK6944904DD57FFDD5
7639         foreign key (Sequence_id)
7640         references Sequence;
7641
7642     alter table Sequence_Reference_AUD
7643         add constraint FK18E5CF9E34869AAE
7644         foreign key (REV)
7645         references AuditEvent;
7646
7647     alter table Sequence_Rights
7648         add constraint FK4616A015C13F7B21
7649         foreign key (rights_id)
7650         references Rights;
7651
7652     alter table Sequence_Rights
7653         add constraint FK4616A015D57FFDD5
7654         foreign key (Sequence_id)
7655         references Sequence;
7656
7657     alter table Sequence_Rights_AUD
7658         add constraint FK1B1ABB6634869AAE
7659         foreign key (REV)
7660         references AuditEvent;
7661
7662     create index specimenOrObservationBaseTitleCacheIndex on SpecimenOrObservationBase (titleCache);
7663
7664     alter table SpecimenOrObservationBase
7665         add constraint FK21CA32727CC340C5
7666         foreign key (storedunder_id)
7667         references TaxonNameBase;
7668
7669     alter table SpecimenOrObservationBase
7670         add constraint FK21CA32728C750E27
7671         foreign key (lifestage_id)
7672         references DefinedTermBase;
7673
7674     alter table SpecimenOrObservationBase
7675         add constraint FK21CA32724FF2DB2C
7676         foreign key (createdby_id)
7677         references UserAccount;
7678
7679     alter table SpecimenOrObservationBase
7680         add constraint FK21CA3272EB62BE9A
7681         foreign key (collection_id)
7682         references Collection;
7683
7684     alter table SpecimenOrObservationBase
7685         add constraint FK21CA3272E17C9A6B
7686         foreign key (sex_id)
7687         references DefinedTermBase;
7688
7689     alter table SpecimenOrObservationBase
7690         add constraint FK21CA3272C8505DB
7691         foreign key (preservation_id)
7692         references DefinedTermBase;
7693
7694     alter table SpecimenOrObservationBase
7695         add constraint FK21CA32724AAB411A
7696         foreign key (derivationevent_id)
7697         references DerivationEvent;
7698
7699     alter table SpecimenOrObservationBase
7700         add constraint FK21CA3272F95F225A
7701         foreign key (gatheringevent_id)
7702         references GatheringEvent;
7703
7704     alter table SpecimenOrObservationBase
7705         add constraint FK21CA3272BC5DA539
7706         foreign key (updatedby_id)
7707         references UserAccount;
7708
7709     alter table SpecimenOrObservationBase_AUD
7710         add constraint FKF3D3D74334869AAE
7711         foreign key (REV)
7712         references AuditEvent;
7713
7714     alter table SpecimenOrObservationBase_Annotation
7715         add constraint FK365E4F3C3B8A5ABA
7716         foreign key (SpecimenOrObservationBase_id)
7717         references SpecimenOrObservationBase;
7718
7719     alter table SpecimenOrObservationBase_Annotation
7720         add constraint FK365E4F3C1E403E0B
7721         foreign key (annotations_id)
7722         references Annotation;
7723
7724     alter table SpecimenOrObservationBase_Annotation_AUD
7725         add constraint FK34187F0D34869AAE
7726         foreign key (REV)
7727         references AuditEvent;
7728
7729     alter table SpecimenOrObservationBase_Credit
7730         add constraint FK7E3A1D8632D1B9F
7731         foreign key (credits_id)
7732         references Credit;
7733
7734     alter table SpecimenOrObservationBase_Credit
7735         add constraint FK7E3A1D863B8A5ABA
7736         foreign key (SpecimenOrObservationBase_id)
7737         references SpecimenOrObservationBase;
7738
7739     alter table SpecimenOrObservationBase_Credit_AUD
7740         add constraint FK7170185734869AAE
7741         foreign key (REV)
7742         references AuditEvent;
7743
7744     alter table SpecimenOrObservationBase_DerivationEvent
7745         add constraint FK20132036BD59A1AD
7746         foreign key (derivationevents_id)
7747         references DerivationEvent;
7748
7749     alter table SpecimenOrObservationBase_DerivationEvent
7750         add constraint FK2013203654C216AA
7751         foreign key (originals_id)
7752         references SpecimenOrObservationBase;
7753
7754     alter table SpecimenOrObservationBase_DerivationEvent_AUD
7755         add constraint FKA4A8430734869AAE
7756         foreign key (REV)
7757         references AuditEvent;
7758
7759     alter table SpecimenOrObservationBase_Extension
7760         add constraint FKE03B8292927DE9DF
7761         foreign key (extensions_id)
7762         references Extension;
7763
7764     alter table SpecimenOrObservationBase_Extension
7765         add constraint FKE03B82923B8A5ABA
7766         foreign key (SpecimenOrObservationBase_id)
7767         references SpecimenOrObservationBase;
7768
7769     alter table SpecimenOrObservationBase_Extension_AUD
7770         add constraint FK7AE0176334869AAE
7771         foreign key (REV)
7772         references AuditEvent;
7773
7774     alter table SpecimenOrObservationBase_LanguageString
7775         add constraint FKCFAA931628459272
7776         foreign key (description_mapkey_id)
7777         references DefinedTermBase;
7778
7779     alter table SpecimenOrObservationBase_LanguageString
7780         add constraint FKCFAA93162BEBA58D
7781         foreign key (description_id)
7782         references LanguageString;
7783
7784     alter table SpecimenOrObservationBase_LanguageString
7785         add constraint FKCFAA93163B8A5ABA
7786         foreign key (SpecimenOrObservationBase_id)
7787         references SpecimenOrObservationBase;
7788
7789     alter table SpecimenOrObservationBase_LanguageString_AUD
7790         add constraint FK38B45E734869AAE
7791         foreign key (REV)
7792         references AuditEvent;
7793
7794     alter table SpecimenOrObservationBase_Marker
7795         add constraint FK8E6106C7777265A1
7796         foreign key (markers_id)
7797         references Marker;
7798
7799     alter table SpecimenOrObservationBase_Marker
7800         add constraint FK8E6106C73B8A5ABA
7801         foreign key (SpecimenOrObservationBase_id)
7802         references SpecimenOrObservationBase;
7803
7804     alter table SpecimenOrObservationBase_Marker_AUD
7805         add constraint FKD58E791834869AAE
7806         foreign key (REV)
7807         references AuditEvent;
7808
7809     alter table SpecimenOrObservationBase_Media
7810         add constraint FK4EEBF7B7C2C29593
7811         foreign key (media_id)
7812         references Media;
7813
7814     alter table SpecimenOrObservationBase_Media
7815         add constraint FK4EEBF7B73B8A5ABA
7816         foreign key (SpecimenOrObservationBase_id)
7817         references SpecimenOrObservationBase;
7818
7819     alter table SpecimenOrObservationBase_Media_AUD
7820         add constraint FK8457720834869AAE
7821         foreign key (REV)
7822         references AuditEvent;
7823
7824     alter table SpecimenOrObservationBase_OriginalSourceBase
7825         add constraint FKCA7F794A3B8A5ABA
7826         foreign key (SpecimenOrObservationBase_id)
7827         references SpecimenOrObservationBase;
7828
7829     alter table SpecimenOrObservationBase_OriginalSourceBase
7830         add constraint FKCA7F794A3A6735D9
7831         foreign key (sources_id)
7832         references OriginalSourceBase;
7833
7834     alter table SpecimenOrObservationBase_OriginalSourceBase_AUD
7835         add constraint FK2059F21B34869AAE
7836         foreign key (REV)
7837         references AuditEvent;
7838
7839     alter table SpecimenOrObservationBase_Rights
7840         add constraint FK9754F464C13F7B21
7841         foreign key (rights_id)
7842         references Rights;
7843
7844     alter table SpecimenOrObservationBase_Rights
7845         add constraint FK9754F4643B8A5ABA
7846         foreign key (SpecimenOrObservationBase_id)
7847         references SpecimenOrObservationBase;
7848
7849     alter table SpecimenOrObservationBase_Rights_AUD
7850         add constraint FK4168503534869AAE
7851         foreign key (REV)
7852         references AuditEvent;
7853
7854     alter table SpecimenOrObservationBase_Sequence
7855         add constraint FKBBF27B0E35B10F24
7856         foreign key (sequences_id)
7857         references Sequence;
7858
7859     alter table SpecimenOrObservationBase_Sequence
7860         add constraint FKBBF27B0E7EE2770E
7861         foreign key (SpecimenOrObservationBase_id)
7862         references SpecimenOrObservationBase;
7863
7864     alter table SpecimenOrObservationBase_Sequence_AUD
7865         add constraint FK392E71DF34869AAE
7866         foreign key (REV)
7867         references AuditEvent;
7868
7869     alter table StateData
7870         add constraint FKFB1697BB4FF2DB2C
7871         foreign key (createdby_id)
7872         references UserAccount;
7873
7874     alter table StateData
7875         add constraint FKFB1697BB682A4E4B
7876         foreign key (state_id)
7877         references DefinedTermBase;
7878
7879     alter table StateData
7880         add constraint FKFB1697BBBC5DA539
7881         foreign key (updatedby_id)
7882         references UserAccount;
7883
7884     alter table StateData_AUD
7885         add constraint FKDA6A700C34869AAE
7886         foreign key (REV)
7887         references AuditEvent;
7888
7889     alter table StateData_DefinedTermBase
7890         add constraint FK107321E28E7BF9AB
7891         foreign key (StateData_id)
7892         references StateData;
7893
7894     alter table StateData_DefinedTermBase
7895         add constraint FK107321E2E0960EC4
7896         foreign key (modifiers_id)
7897         references DefinedTermBase;
7898
7899     alter table StateData_DefinedTermBase_AUD
7900         add constraint FK7C978EB334869AAE
7901         foreign key (REV)
7902         references AuditEvent;
7903
7904     alter table StateData_LanguageString
7905         add constraint FK93FFD2AD8E7BF9AB
7906         foreign key (StateData_id)
7907         references StateData;
7908
7909     alter table StateData_LanguageString
7910         add constraint FK93FFD2ADF05D08D4
7911         foreign key (modifyingtext_id)
7912         references LanguageString;
7913
7914     alter table StateData_LanguageString
7915         add constraint FK93FFD2AD9682414B
7916         foreign key (modifyingtext_mapkey_id)
7917         references DefinedTermBase;
7918
7919     alter table StateData_LanguageString_AUD
7920         add constraint FK1578E1FE34869AAE
7921         foreign key (REV)
7922         references AuditEvent;
7923
7924     alter table StatisticalMeasurementValue
7925         add constraint FK2DCE02904FF2DB2C
7926         foreign key (createdby_id)
7927         references UserAccount;
7928
7929     alter table StatisticalMeasurementValue
7930         add constraint FK2DCE02904C428112
7931         foreign key (type_id)
7932         references DefinedTermBase;
7933
7934     alter table StatisticalMeasurementValue
7935         add constraint FK2DCE0290BC5DA539
7936         foreign key (updatedby_id)
7937         references UserAccount;
7938
7939     alter table StatisticalMeasurementValue_AUD
7940         add constraint FKBB16686134869AAE
7941         foreign key (REV)
7942         references AuditEvent;
7943
7944     alter table StatisticalMeasurementValue_DefinedTermBase
7945         add constraint FK686C42B7E0960EC4
7946         foreign key (modifiers_id)
7947         references DefinedTermBase;
7948
7949     alter table StatisticalMeasurementValue_DefinedTermBase
7950         add constraint FK686C42B75C9F4F2B
7951         foreign key (StatisticalMeasurementValue_id)
7952         references StatisticalMeasurementValue;
7953
7954     alter table StatisticalMeasurementValue_DefinedTermBase_AUD
7955         add constraint FKFEBA3D0834869AAE
7956         foreign key (REV)
7957         references AuditEvent;
7958
7959     alter table SynonymRelationship
7960         add constraint FKF483ADB34FF2DB2C
7961         foreign key (createdby_id)
7962         references UserAccount;
7963
7964     alter table SynonymRelationship
7965         add constraint FKF483ADB39803512F
7966         foreign key (citation_id)
7967         references Reference;
7968
7969     alter table SynonymRelationship
7970         add constraint FKF483ADB34BAC703F
7971         foreign key (relatedfrom_id)
7972         references TaxonBase;
7973
7974     alter table SynonymRelationship
7975         add constraint FKF483ADB380924EEC
7976         foreign key (type_id)
7977         references DefinedTermBase;
7978
7979     alter table SynonymRelationship
7980         add constraint FKF483ADB3F8991B9D
7981         foreign key (relatedto_id)
7982         references TaxonBase;
7983
7984     alter table SynonymRelationship
7985         add constraint FKF483ADB3BC5DA539
7986         foreign key (updatedby_id)
7987         references UserAccount;
7988
7989     alter table SynonymRelationship_AUD
7990         add constraint FK8AEBCA0434869AAE
7991         foreign key (REV)
7992         references AuditEvent;
7993
7994     alter table SynonymRelationship_Annotation
7995         add constraint FKF494F15B260A8379
7996         foreign key (SynonymRelationship_id)
7997         references SynonymRelationship;
7998
7999     alter table SynonymRelationship_Annotation
8000         add constraint FKF494F15B1E403E0B
8001         foreign key (annotations_id)
8002         references Annotation;
8003
8004     alter table SynonymRelationship_Annotation_AUD
8005         add constraint FKD3E2F9AC34869AAE
8006         foreign key (REV)
8007         references AuditEvent;
8008
8009     alter table SynonymRelationship_Marker
8010         add constraint FK7A439066777265A1
8011         foreign key (markers_id)
8012         references Marker;
8013
8014     alter table SynonymRelationship_Marker
8015         add constraint FK7A439066260A8379
8016         foreign key (SynonymRelationship_id)
8017         references SynonymRelationship;
8018
8019     alter table SynonymRelationship_Marker_AUD
8020         add constraint FK93C51B3734869AAE
8021         foreign key (REV)
8022         references AuditEvent;
8023
8024     create index taxonBaseTitleCacheIndex on TaxonBase (titleCache);
8025
8026     alter table TaxonBase
8027         add constraint FK9249B49B4FF2DB2C
8028         foreign key (createdby_id)
8029         references UserAccount;
8030
8031     alter table TaxonBase
8032         add constraint FK9249B49B5E4A2F85
8033         foreign key (sec_id)
8034         references Reference;
8035
8036     alter table TaxonBase
8037         add constraint FK9249B49B7C7B5AED
8038         foreign key (taxonomicparentcache_id)
8039         references TaxonBase;
8040
8041     alter table TaxonBase
8042         add constraint FK9249B49BDA93512F
8043         foreign key (taxonName_fk)
8044         references TaxonNameBase;
8045
8046     alter table TaxonBase
8047         add constraint FK9249B49BBC5DA539
8048         foreign key (updatedby_id)
8049         references UserAccount;
8050
8051     alter table TaxonBase_AUD
8052         add constraint FK37041CEC34869AAE
8053         foreign key (REV)
8054         references AuditEvent;
8055
8056     alter table TaxonBase_Annotation
8057         add constraint FK41ED09739C9D39
8058         foreign key (TaxonBase_id)
8059         references TaxonBase;
8060
8061     alter table TaxonBase_Annotation
8062         add constraint FK41ED09731E403E0B
8063         foreign key (annotations_id)
8064         references Annotation;
8065
8066     alter table TaxonBase_Annotation_AUD
8067         add constraint FK8C145C434869AAE
8068         foreign key (REV)
8069         references AuditEvent;
8070
8071     alter table TaxonBase_Credit
8072         add constraint FK4CB48B3D9C9D39
8073         foreign key (TaxonBase_id)
8074         references TaxonBase;
8075
8076     alter table TaxonBase_Credit
8077         add constraint FK4CB48B3D32D1B9F
8078         foreign key (credits_id)
8079         references Credit;
8080
8081     alter table TaxonBase_Credit_AUD
8082         add constraint FK7CFED28E34869AAE
8083         foreign key (REV)
8084         references AuditEvent;
8085
8086     alter table TaxonBase_Extension
8087         add constraint FKF961257B927DE9DF
8088         foreign key (extensions_id)
8089         references Extension;
8090
8091     alter table TaxonBase_Extension
8092         add constraint FKF961257B9C9D39
8093         foreign key (TaxonBase_id)
8094         references TaxonBase;
8095
8096     alter table TaxonBase_Extension_AUD
8097         add constraint FK71381DCC34869AAE
8098         foreign key (REV)
8099         references AuditEvent;
8100
8101     alter table TaxonBase_Marker
8102         add constraint FK5CDB747E777265A1
8103         foreign key (markers_id)
8104         references Marker;
8105
8106     alter table TaxonBase_Marker
8107         add constraint FK5CDB747E9C9D39
8108         foreign key (TaxonBase_id)
8109         references TaxonBase;
8110
8111     alter table TaxonBase_Marker_AUD
8112         add constraint FKE11D334F34869AAE
8113         foreign key (REV)
8114         references AuditEvent;
8115
8116     alter table TaxonBase_OriginalSourceBase
8117         add constraint FKFB680C819C9D39
8118         foreign key (TaxonBase_id)
8119         references TaxonBase;
8120
8121     alter table TaxonBase_OriginalSourceBase
8122         add constraint FKFB680C813A6735D9
8123         foreign key (sources_id)
8124         references OriginalSourceBase;
8125
8126     alter table TaxonBase_OriginalSourceBase_AUD
8127         add constraint FKB7C811D234869AAE
8128         foreign key (REV)
8129         references AuditEvent;
8130
8131     alter table TaxonBase_Rights
8132         add constraint FK65CF621B9C9D39
8133         foreign key (TaxonBase_id)
8134         references TaxonBase;
8135
8136     alter table TaxonBase_Rights
8137         add constraint FK65CF621BC13F7B21
8138         foreign key (rights_id)
8139         references Rights;
8140
8141     alter table TaxonBase_Rights_AUD
8142         add constraint FK4CF70A6C34869AAE
8143         foreign key (REV)
8144         references AuditEvent;
8145
8146     alter table TaxonInteraction_LanguageString
8147         add constraint FK579A1DC028459272
8148         foreign key (description_mapkey_id)
8149         references DefinedTermBase;
8150
8151     alter table TaxonInteraction_LanguageString
8152         add constraint FK579A1DC086C86FE0
8153         foreign key (DescriptionElementBase_id)
8154         references DescriptionElementBase;
8155
8156     alter table TaxonInteraction_LanguageString
8157         add constraint FK579A1DC02BEBA58D
8158         foreign key (description_id)
8159         references LanguageString;
8160
8161     alter table TaxonInteraction_LanguageString_AUD
8162         add constraint FK9E016B9134869AAE
8163         foreign key (REV)
8164         references AuditEvent;
8165
8166     create index taxonNameBaseTitleCacheIndex on TaxonNameBase (titleCache);
8167
8168     alter table TaxonNameBase
8169         add constraint FKB4870C64FF2DB2C
8170         foreign key (createdby_id)
8171         references UserAccount;
8172
8173     alter table TaxonNameBase
8174         add constraint FKB4870C662AD57A2
8175         foreign key (excombinationauthorteam_id)
8176         references AgentBase;
8177
8178     alter table TaxonNameBase
8179         add constraint FKB4870C6BFEAE500
8180         foreign key (homotypicalgroup_id)
8181         references HomotypicalGroup;
8182
8183     alter table TaxonNameBase
8184         add constraint FKB4870C6D7BE55A0
8185         foreign key (rank_id)
8186         references DefinedTermBase;
8187
8188     alter table TaxonNameBase
8189         add constraint FKB4870C67F90DF03
8190         foreign key (exbasionymauthorteam_id)
8191         references AgentBase;
8192
8193     alter table TaxonNameBase
8194         add constraint FKB4870C62B4FEDD6
8195         foreign key (basionymauthorteam_id)
8196         references AgentBase;
8197
8198     alter table TaxonNameBase
8199         add constraint FKB4870C64AC9C024
8200         foreign key (nomenclaturalreference_id)
8201         references Reference;
8202
8203     alter table TaxonNameBase
8204         add constraint FKB4870C6B14B73EF
8205         foreign key (combinationauthorteam_id)
8206         references AgentBase;
8207
8208     alter table TaxonNameBase
8209         add constraint FKB4870C6BC5DA539
8210         foreign key (updatedby_id)
8211         references UserAccount;
8212
8213     alter table TaxonNameBase_AUD
8214         add constraint FK5CA2CB9734869AAE
8215         foreign key (REV)
8216         references AuditEvent;
8217
8218     alter table TaxonNameBase_Annotation
8219         add constraint FK9E7794688C85CF94
8220         foreign key (TaxonNameBase_id)
8221         references TaxonNameBase;
8222
8223     alter table TaxonNameBase_Annotation
8224         add constraint FK9E7794681E403E0B
8225         foreign key (annotations_id)
8226         references Annotation;
8227
8228     alter table TaxonNameBase_Annotation_AUD
8229         add constraint FKB6734E3934869AAE
8230         foreign key (REV)
8231         references AuditEvent;
8232
8233     alter table TaxonNameBase_Credit
8234         add constraint FK29BCD8B28C85CF94
8235         foreign key (TaxonNameBase_id)
8236         references TaxonNameBase;
8237
8238     alter table TaxonNameBase_Credit
8239         add constraint FK29BCD8B232D1B9F
8240         foreign key (credits_id)
8241         references Credit;
8242
8243     alter table TaxonNameBase_Credit_AUD
8244         add constraint FKD9895D8334869AAE
8245         foreign key (REV)
8246         references AuditEvent;
8247
8248     alter table TaxonNameBase_Extension
8249         add constraint FKC28EE7E68C85CF94
8250         foreign key (TaxonNameBase_id)
8251         references TaxonNameBase;
8252
8253     alter table TaxonNameBase_Extension
8254         add constraint FKC28EE7E6927DE9DF
8255         foreign key (extensions_id)
8256         references Extension;
8257
8258     alter table TaxonNameBase_Extension_AUD
8259         add constraint FK8F98B2B734869AAE
8260         foreign key (REV)
8261         references AuditEvent;
8262
8263     alter table TaxonNameBase_Marker
8264         add constraint FK39E3C1F3777265A1
8265         foreign key (markers_id)
8266         references Marker;
8267
8268     alter table TaxonNameBase_Marker
8269         add constraint FK39E3C1F38C85CF94
8270         foreign key (TaxonNameBase_id)
8271         references TaxonNameBase;
8272
8273     alter table TaxonNameBase_Marker_AUD
8274         add constraint FK3DA7BE4434869AAE
8275         foreign key (REV)
8276         references AuditEvent;
8277
8278     alter table TaxonNameBase_NomenclaturalStatus
8279         add constraint FK560BA7928C85CF94
8280         foreign key (TaxonNameBase_id)
8281         references TaxonNameBase;
8282
8283     alter table TaxonNameBase_NomenclaturalStatus
8284         add constraint FK560BA7926615E90D
8285         foreign key (status_id)
8286         references NomenclaturalStatus;
8287
8288     alter table TaxonNameBase_NomenclaturalStatus_AUD
8289         add constraint FK9215BC6334869AAE
8290         foreign key (REV)
8291         references AuditEvent;
8292
8293     alter table TaxonNameBase_OriginalSourceBase
8294         add constraint FKF746D2768C85CF94
8295         foreign key (TaxonNameBase_id)
8296         references TaxonNameBase;
8297
8298     alter table TaxonNameBase_OriginalSourceBase
8299         add constraint FKF746D2763A6735D9
8300         foreign key (sources_id)
8301         references OriginalSourceBase;
8302
8303     alter table TaxonNameBase_OriginalSourceBase_AUD
8304         add constraint FK7A38D54734869AAE
8305         foreign key (REV)
8306         references AuditEvent;
8307
8308     alter table TaxonNameBase_Rights
8309         add constraint FK42D7AF908C85CF94
8310         foreign key (TaxonNameBase_id)
8311         references TaxonNameBase;
8312
8313     alter table TaxonNameBase_Rights
8314         add constraint FK42D7AF90C13F7B21
8315         foreign key (rights_id)
8316         references Rights;
8317
8318     alter table TaxonNameBase_Rights_AUD
8319         add constraint FKA981956134869AAE
8320         foreign key (REV)
8321         references AuditEvent;
8322
8323     alter table TaxonNameBase_TypeDesignationBase
8324         add constraint FKC0D6BBB58C85CF94
8325         foreign key (TaxonNameBase_id)
8326         references TaxonNameBase;
8327
8328     alter table TaxonNameBase_TypeDesignationBase
8329         add constraint FKC0D6BBB5C7DF530C
8330         foreign key (typedesignations_id)
8331         references TypeDesignationBase;
8332
8333     alter table TaxonNameBase_TypeDesignationBase_AUD
8334         add constraint FKBB24070634869AAE
8335         foreign key (REV)
8336         references AuditEvent;
8337
8338     alter table TaxonNode
8339         add constraint FK924F5BCC4FF2DB2C
8340         foreign key (createdby_id)
8341         references UserAccount;
8342
8343     alter table TaxonNode
8344         add constraint FK924F5BCC215EDF26
8345         foreign key (referenceforparentchildrelation_id)
8346         references Reference;
8347
8348     alter table TaxonNode
8349         add constraint FK924F5BCC759FE399
8350         foreign key (taxonomictree_id)
8351         references TaxonomicTree;
8352
8353     alter table TaxonNode
8354         add constraint FK924F5BCCDE9A3E39
8355         foreign key (taxon_id)
8356         references TaxonBase;
8357
8358     alter table TaxonNode
8359         add constraint FK924F5BCCCC05993E
8360         foreign key (synonymtobeused_id)
8361         references TaxonBase;
8362
8363     alter table TaxonNode
8364         add constraint FK924F5BCC39DB2DFB
8365         foreign key (parent_id)
8366         references TaxonNode;
8367
8368     alter table TaxonNode
8369         add constraint FK924F5BCCBC5DA539
8370         foreign key (updatedby_id)
8371         references UserAccount;
8372
8373     alter table TaxonNode_AUD
8374         add constraint FKE090C39D34869AAE
8375         foreign key (REV)
8376         references AuditEvent;
8377
8378     alter table TaxonNode_Annotation
8379         add constraint FKD8A9A9A2927D8399
8380         foreign key (TaxonNode_id)
8381         references TaxonNode;
8382
8383     alter table TaxonNode_Annotation
8384         add constraint FKD8A9A9A21E403E0B
8385         foreign key (annotations_id)
8386         references Annotation;
8387
8388     alter table TaxonNode_Annotation_AUD
8389         add constraint FKB2C4367334869AAE
8390         foreign key (REV)
8391         references AuditEvent;
8392
8393     alter table TaxonNode_Marker
8394         add constraint FK395842D777265A1
8395         foreign key (markers_id)
8396         references Marker;
8397
8398     alter table TaxonNode_Marker
8399         add constraint FK395842D927D8399
8400         foreign key (TaxonNode_id)
8401         references TaxonNode;
8402
8403     alter table TaxonNode_Marker_AUD
8404         add constraint FK77D9D37E34869AAE
8405         foreign key (REV)
8406         references AuditEvent;
8407
8408     alter table TaxonRelationship
8409         add constraint FK7482BA024FF2DB2C
8410         foreign key (createdby_id)
8411         references UserAccount;
8412
8413     alter table TaxonRelationship
8414         add constraint FK7482BA029803512F
8415         foreign key (citation_id)
8416         references Reference;
8417
8418     alter table TaxonRelationship
8419         add constraint FK7482BA02E71EF6CE
8420         foreign key (relatedfrom_id)
8421         references TaxonBase;
8422
8423     alter table TaxonRelationship
8424         add constraint FK7482BA02F11BD77B
8425         foreign key (type_id)
8426         references DefinedTermBase;
8427
8428     alter table TaxonRelationship
8429         add constraint FK7482BA02F8991B9D
8430         foreign key (relatedto_id)
8431         references TaxonBase;
8432
8433     alter table TaxonRelationship
8434         add constraint FK7482BA02BC5DA539
8435         foreign key (updatedby_id)
8436         references UserAccount;
8437
8438     alter table TaxonRelationship_AUD
8439         add constraint FKA0DE16D334869AAE
8440         foreign key (REV)
8441         references AuditEvent;
8442
8443     alter table TaxonRelationship_Annotation
8444         add constraint FK82C86DAC2BD180D9
8445         foreign key (TaxonRelationship_id)
8446         references TaxonRelationship;
8447
8448     alter table TaxonRelationship_Annotation
8449         add constraint FK82C86DAC1E403E0B
8450         foreign key (annotations_id)
8451         references Annotation;
8452
8453     alter table TaxonRelationship_Annotation_AUD
8454         add constraint FKE86DE57D34869AAE
8455         foreign key (REV)
8456         references AuditEvent;
8457
8458     alter table TaxonRelationship_Marker
8459         add constraint FK69FBDD37777265A1
8460         foreign key (markers_id)
8461         references Marker;
8462
8463     alter table TaxonRelationship_Marker
8464         add constraint FK69FBDD372BD180D9
8465         foreign key (TaxonRelationship_id)
8466         references TaxonRelationship;
8467
8468     alter table TaxonRelationship_Marker_AUD
8469         add constraint FK21F8978834869AAE
8470         foreign key (REV)
8471         references AuditEvent;
8472
8473     alter table TaxonomicTree
8474         add constraint FKE332DBE04FF2DB2C
8475         foreign key (createdby_id)
8476         references UserAccount;
8477
8478     alter table TaxonomicTree
8479         add constraint FKE332DBE0765B124B
8480         foreign key (reference_id)
8481         references Reference;
8482
8483     alter table TaxonomicTree
8484         add constraint FKE332DBE077E2F09E
8485         foreign key (name_id)
8486         references LanguageString;
8487
8488     alter table TaxonomicTree
8489         add constraint FKE332DBE0BC5DA539
8490         foreign key (updatedby_id)
8491         references UserAccount;
8492
8493     alter table TaxonomicTree_AUD
8494         add constraint FK14CE19B134869AAE
8495         foreign key (REV)
8496         references AuditEvent;
8497
8498     alter table TaxonomicTree_Annotation
8499         add constraint FK9877150E759FE399
8500         foreign key (TaxonomicTree_id)
8501         references TaxonomicTree;
8502
8503     alter table TaxonomicTree_Annotation
8504         add constraint FK9877150E1E403E0B
8505         foreign key (annotations_id)
8506         references Annotation;
8507
8508     alter table TaxonomicTree_Annotation_AUD
8509         add constraint FKADD60BDF34869AAE
8510         foreign key (REV)
8511         references AuditEvent;
8512
8513     alter table TaxonomicTree_Credit
8514         add constraint FK21329C58759FE399
8515         foreign key (TaxonomicTree_id)
8516         references TaxonomicTree;
8517
8518     alter table TaxonomicTree_Credit
8519         add constraint FK21329C5832D1B9F
8520         foreign key (credits_id)
8521         references Credit;
8522
8523     alter table TaxonomicTree_Credit_AUD
8524         add constraint FKD388DE2934869AAE
8525         foreign key (REV)
8526         references AuditEvent;
8527
8528     alter table TaxonomicTree_Extension
8529         add constraint FKF3E9BA80759FE399
8530         foreign key (TaxonomicTree_id)
8531         references TaxonomicTree;
8532
8533     alter table TaxonomicTree_Extension
8534         add constraint FKF3E9BA80927DE9DF
8535         foreign key (extensions_id)
8536         references Extension;
8537
8538     alter table TaxonomicTree_Extension_AUD
8539         add constraint FK1BB4A85134869AAE
8540         foreign key (REV)
8541         references AuditEvent;
8542
8543     alter table TaxonomicTree_Marker
8544         add constraint FK31598599777265A1
8545         foreign key (markers_id)
8546         references Marker;
8547
8548     alter table TaxonomicTree_Marker
8549         add constraint FK31598599759FE399
8550         foreign key (TaxonomicTree_id)
8551         references TaxonomicTree;
8552
8553     alter table TaxonomicTree_Marker_AUD
8554         add constraint FK37A73EEA34869AAE
8555         foreign key (REV)
8556         references AuditEvent;
8557
8558     alter table TaxonomicTree_OriginalSourceBase
8559         add constraint FKDE264D1C759FE399
8560         foreign key (TaxonomicTree_id)
8561         references TaxonomicTree;
8562
8563     alter table TaxonomicTree_OriginalSourceBase
8564         add constraint FKDE264D1C3A6735D9
8565         foreign key (sources_id)
8566         references OriginalSourceBase;
8567
8568     alter table TaxonomicTree_OriginalSourceBase_AUD
8569         add constraint FK99EE8CED34869AAE
8570         foreign key (REV)
8571         references AuditEvent;
8572
8573     alter table TaxonomicTree_Rights
8574         add constraint FK3A4D7336759FE399
8575         foreign key (TaxonomicTree_id)
8576         references TaxonomicTree;
8577
8578     alter table TaxonomicTree_Rights
8579         add constraint FK3A4D7336C13F7B21
8580         foreign key (rights_id)
8581         references Rights;
8582
8583     alter table TaxonomicTree_Rights_AUD
8584         add constraint FKA381160734869AAE
8585         foreign key (REV)
8586         references AuditEvent;
8587
8588     alter table TaxonomicTree_TaxonNode
8589         add constraint FK3349DA2D759FE399
8590         foreign key (TaxonomicTree_id)
8591         references TaxonomicTree;
8592
8593     alter table TaxonomicTree_TaxonNode
8594         add constraint FK3349DA2D18929176
8595         foreign key (rootnodes_id)
8596         references TaxonNode;
8597
8598     alter table TaxonomicTree_TaxonNode_AUD
8599         add constraint FK6973297E34869AAE
8600         foreign key (REV)
8601         references AuditEvent;
8602
8603     alter table TermVocabulary
8604         add constraint FK487AA6924FF2DB2C
8605         foreign key (createdby_id)
8606         references UserAccount;
8607
8608     alter table TermVocabulary
8609         add constraint FK487AA692BC5DA539
8610         foreign key (updatedby_id)
8611         references UserAccount;
8612
8613     alter table TermVocabulary_AUD
8614         add constraint FKA6ED3B6334869AAE
8615         foreign key (REV)
8616         references AuditEvent;
8617
8618     alter table TermVocabulary_Annotation
8619         add constraint FK76D2071C258E060
8620         foreign key (TermVocabulary_id)
8621         references TermVocabulary;
8622
8623     alter table TermVocabulary_Annotation
8624         add constraint FK76D2071C1E403E0B
8625         foreign key (annotations_id)
8626         references Annotation;
8627
8628     alter table TermVocabulary_Annotation_AUD
8629         add constraint FK222D46ED34869AAE
8630         foreign key (REV)
8631         references AuditEvent;
8632
8633     alter table TermVocabulary_Credit
8634         add constraint FK7604C566258E060
8635         foreign key (TermVocabulary_id)
8636         references TermVocabulary;
8637
8638     alter table TermVocabulary_Credit
8639         add constraint FK7604C56632D1B9F
8640         foreign key (credits_id)
8641         references Credit;
8642
8643     alter table TermVocabulary_Credit_AUD
8644         add constraint FKB1E3D03734869AAE
8645         foreign key (REV)
8646         references AuditEvent;
8647
8648     alter table TermVocabulary_Extension
8649         add constraint FKA8814EB2258E060
8650         foreign key (TermVocabulary_id)
8651         references TermVocabulary;
8652
8653     alter table TermVocabulary_Extension
8654         add constraint FKA8814EB2927DE9DF
8655         foreign key (extensions_id)
8656         references Extension;
8657
8658     alter table TermVocabulary_Extension_AUD
8659         add constraint FKD522D38334869AAE
8660         foreign key (REV)
8661         references AuditEvent;
8662
8663     alter table TermVocabulary_Marker
8664         add constraint FK862BAEA7777265A1
8665         foreign key (markers_id)
8666         references Marker;
8667
8668     alter table TermVocabulary_Marker
8669         add constraint FK862BAEA7258E060
8670         foreign key (TermVocabulary_id)
8671         references TermVocabulary;
8672
8673     alter table TermVocabulary_Marker_AUD
8674         add constraint FK160230F834869AAE
8675         foreign key (REV)
8676         references AuditEvent;
8677
8678     alter table TermVocabulary_OriginalSourceBase
8679         add constraint FK8F2D512A258E060
8680         foreign key (TermVocabulary_id)
8681         references TermVocabulary;
8682
8683     alter table TermVocabulary_OriginalSourceBase
8684         add constraint FK8F2D512A3A6735D9
8685         foreign key (sources_id)
8686         references OriginalSourceBase;
8687
8688     alter table TermVocabulary_OriginalSourceBase_AUD
8689         add constraint FKA898D9FB34869AAE
8690         foreign key (REV)
8691         references AuditEvent;
8692
8693     alter table TermVocabulary_Representation
8694         add constraint FKA408B63A258E060
8695         foreign key (TermVocabulary_id)
8696         references TermVocabulary;
8697
8698     alter table TermVocabulary_Representation
8699         add constraint FKA408B63AB31C4747
8700         foreign key (representations_id)
8701         references Representation;
8702
8703     alter table TermVocabulary_Representation_AUD
8704         add constraint FK681B370B34869AAE
8705         foreign key (REV)
8706         references AuditEvent;
8707
8708     alter table TermVocabulary_Rights
8709         add constraint FK8F1F9C44258E060
8710         foreign key (TermVocabulary_id)
8711         references TermVocabulary;
8712
8713     alter table TermVocabulary_Rights
8714         add constraint FK8F1F9C44C13F7B21
8715         foreign key (rights_id)
8716         references Rights;
8717
8718     alter table TermVocabulary_Rights_AUD
8719         add constraint FK81DC081534869AAE
8720         foreign key (REV)
8721         references AuditEvent;
8722
8723     alter table TypeDesignationBase
8724         add constraint FK8AC9DCAE4FF2DB2C
8725         foreign key (createdby_id)
8726         references UserAccount;
8727
8728     alter table TypeDesignationBase
8729         add constraint FK8AC9DCAE9803512F
8730         foreign key (citation_id)
8731         references Reference;
8732
8733     alter table TypeDesignationBase
8734         add constraint FK8AC9DCAEBFEAE500
8735         foreign key (homotypicalgroup_id)
8736         references HomotypicalGroup;
8737
8738     alter table TypeDesignationBase
8739         add constraint FK8AC9DCAE94DB044A
8740         foreign key (typespecimen_id)
8741         references SpecimenOrObservationBase;
8742
8743     alter table TypeDesignationBase
8744         add constraint FK8AC9DCAE4CB0F315
8745         foreign key (typename_id)
8746         references TaxonNameBase;
8747
8748     alter table TypeDesignationBase
8749         add constraint FK8AC9DCAE9E3ED08
8750         foreign key (typestatus_id)
8751         references DefinedTermBase;
8752
8753     alter table TypeDesignationBase
8754         add constraint FK8AC9DCAEBC5DA539
8755         foreign key (updatedby_id)
8756         references UserAccount;
8757
8758     alter table TypeDesignationBase_AUD
8759         add constraint FK243C037F34869AAE
8760         foreign key (REV)
8761         references AuditEvent;
8762
8763     alter table TypeDesignationBase_Annotation
8764         add constraint FK4D73278044E9E6D4
8765         foreign key (TypeDesignationBase_id)
8766         references TypeDesignationBase;
8767
8768     alter table TypeDesignationBase_Annotation
8769         add constraint FK4D7327801E403E0B
8770         foreign key (annotations_id)
8771         references Annotation;
8772
8773     alter table TypeDesignationBase_Annotation_AUD
8774         add constraint FK88BF955134869AAE
8775         foreign key (REV)
8776         references AuditEvent;
8777
8778     alter table TypeDesignationBase_Marker
8779         add constraint FKB914A10B777265A1
8780         foreign key (markers_id)
8781         references Marker;
8782
8783     alter table TypeDesignationBase_Marker
8784         add constraint FKB914A10B44E9E6D4
8785         foreign key (TypeDesignationBase_id)
8786         references TypeDesignationBase;
8787
8788     alter table TypeDesignationBase_Marker_AUD
8789         add constraint FKECA3515C34869AAE
8790         foreign key (REV)
8791         references AuditEvent;
8792
8793     alter table TypeDesignationBase_TaxonNameBase
8794         add constraint FKF61156F54D901A92
8795         foreign key (typifiednames_id)
8796         references TaxonNameBase;
8797
8798     alter table TypeDesignationBase_TaxonNameBase
8799         add constraint FKF61156F544E9E6D4
8800         foreign key (TypeDesignationBase_id)
8801         references TypeDesignationBase;
8802
8803     alter table TypeDesignationBase_TaxonNameBase_AUD
8804         add constraint FK4F1F024634869AAE
8805         foreign key (REV)
8806         references AuditEvent;
8807
8808     alter table UserAccount
8809         add constraint FKB3F13C24FF2DB2C
8810         foreign key (createdby_id)
8811         references UserAccount;
8812
8813     alter table UserAccount
8814         add constraint FKB3F13C2AAC1B820
8815         foreign key (person_id)
8816         references AgentBase;
8817
8818     alter table UserAccount_AUD
8819         add constraint FK6A57909334869AAE
8820         foreign key (REV)
8821         references AuditEvent;
8822
8823     alter table UserAccount_GrantedAuthorityImpl
8824         add constraint FKFD724D855EA5DD89
8825         foreign key (UserAccount_id)
8826         references UserAccount;
8827
8828     alter table UserAccount_GrantedAuthorityImpl
8829         add constraint FKFD724D851857F6C2
8830         foreign key (grantedauthorities_id)
8831         references GrantedAuthorityImpl;
8832
8833     alter table UserAccount_PermissionGroup
8834         add constraint FK812DE753887E3D12
8835         foreign key (members_id)
8836         references UserAccount;
8837
8838     alter table UserAccount_PermissionGroup
8839         add constraint FK812DE753DA9DCB5F
8840         foreign key (groups_id)
8841         references PermissionGroup;
8842
8843     alter table WorkingSet
8844         add constraint FK668D5B914FF2DB2C
8845         foreign key (createdby_id)
8846         references UserAccount;
8847
8848     alter table WorkingSet
8849         add constraint FK668D5B9123DB7F04
8850         foreign key (descriptivesystem_id)
8851         references FeatureTree;
8852
8853     alter table WorkingSet
8854         add constraint FK668D5B91BC5DA539
8855         foreign key (updatedby_id)
8856         references UserAccount;
8857
8858     alter table WorkingSet_AUD
8859         add constraint FK628F58E234869AAE
8860         foreign key (REV)
8861         references AuditEvent;
8862
8863     alter table WorkingSet_Annotation
8864         add constraint FKCBBA8CBDBBD2C869
8865         foreign key (WorkingSet_id)
8866         references WorkingSet;
8867
8868     alter table WorkingSet_Annotation
8869         add constraint FKCBBA8CBD1E403E0B
8870         foreign key (annotations_id)
8871         references Annotation;
8872
8873     alter table WorkingSet_Annotation_AUD
8874         add constraint FK1E28140E34869AAE
8875         foreign key (REV)
8876         references AuditEvent;
8877
8878     alter table WorkingSet_DescriptionBase
8879         add constraint FK731CC81F33B8A841
8880         foreign key (descriptions_id)
8881         references DescriptionBase;
8882
8883     alter table WorkingSet_DescriptionBase
8884         add constraint FK731CC81FBBD2C869
8885         foreign key (WorkingSet_id)
8886         references WorkingSet;
8887
8888     alter table WorkingSet_DescriptionBase_AUD
8889         add constraint FK8959CE7034869AAE
8890         foreign key (REV)
8891         references AuditEvent;
8892
8893     alter table WorkingSet_Marker
8894         add constraint FK9CB22CC8777265A1
8895         foreign key (markers_id)
8896         references Marker;
8897
8898     alter table WorkingSet_Marker
8899         add constraint FK9CB22CC8BBD2C869
8900         foreign key (WorkingSet_id)
8901         references WorkingSet;
8902
8903     alter table WorkingSet_Marker_AUD
8904         add constraint FK6AEAB69934869AAE
8905         foreign key (REV)
8906         references AuditEvent;
8907
8908     alter table WorkingSet_Representation
8909         add constraint FKA003835BB31C4747
8910         foreign key (representations_id)
8911         references Representation;
8912
8913     alter table WorkingSet_Representation
8914         add constraint FKA003835BBBD2C869
8915         foreign key (WorkingSet_id)
8916         references WorkingSet;
8917
8918     alter table WorkingSet_Representation_AUD
8919         add constraint FK21B88BAC34869AAE
8920         foreign key (REV)
8921         references AuditEvent;
8922
8923     alter table WorkingSet_TaxonBase
8924         add constraint FK34EB896DB4555A9A
8925         foreign key (WorkingSet_id)
8926         references WorkingSet;
8927
8928     alter table WorkingSet_TaxonBase
8929         add constraint FK34EB896D7C3D0017
8930         foreign key (coveredtaxa_id)
8931         references TaxonBase;
8932
8933     alter table WorkingSet_TaxonBase_AUD
8934         add constraint FK582B38BE34869AAE
8935         foreign key (REV)
8936         references AuditEvent;