cdmlib-services/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         protectednomenclaturaltitlecache bit,
  98         firstname varchar(255),
  99         lastname varchar(255),
 100         lifespan_end varchar(255),
 101         lifespan_freetext varchar(255),
 102         lifespan_start varchar(255),
 103         prefix varchar(255),
 104         suffix varchar(255),
 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_OriginalSource (
 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_OriginalSource_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_OriginalSource (
 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_OriginalSource_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         uri varchar(255),
 626         orderindex integer,
 627         iso639_1 varchar(2),
 628         iso639_2 varchar(3),
 629         symmetric bit,
 630         transitive bit,
 631         defaultcolor varchar(255),
 632         supportscategoricaldata bit,
 633         supportscommontaxonname bit,
 634         supportsdistribution bit,
 635         supportsindividualassociation bit,
 636         supportsquantitativedata bit,
 637         supportstaxoninteraction bit,
 638         supportstextdata bit,
 639         pointapproximation_errorradius integer,
 640         pointapproximation_latitude double,
 641         pointapproximation_longitude double,
 642         validperiod_end varchar(255),
 643         validperiod_freetext varchar(255),
 644         validperiod_start varchar(255),
 645         iso3166_a2 varchar(2),
 646         createdby_id integer,
 647         updatedby_id integer,
 648         kindof_id integer,
 649         partof_id integer,
 650         vocabulary_id integer,
 651         level_id integer,
 652         pointapproximation_referencesystem_id integer,
 653         shape_id integer,
 654         type_id integer,
 655         primary key (id),
 656         unique (uuid)
 657     );
 658
 659     create table DefinedTermBase_AUD (
 660         DTYPE varchar(31) not null,
 661         id integer not null,
 662         REV integer not null,
 663         revtype tinyint,
 664         created timestamp,
 665         uuid varchar(36),
 666         updated timestamp,
 667         uri varchar(255),
 668         createdby_id integer,
 669         updatedby_id integer,
 670         kindof_id integer,
 671         partof_id integer,
 672         vocabulary_id integer,
 673         iso639_1 varchar(2),
 674         iso639_2 varchar(3),
 675         orderindex integer,
 676         pointapproximation_errorradius integer,
 677         pointapproximation_latitude double,
 678         pointapproximation_longitude double,
 679         validperiod_end varchar(255),
 680         validperiod_freetext varchar(255),
 681         validperiod_start varchar(255),
 682         level_id integer,
 683         pointapproximation_referencesystem_id integer,
 684         shape_id integer,
 685         type_id integer,
 686         symmetric bit,
 687         transitive bit,
 688         iso3166_a2 varchar(2),
 689         supportscategoricaldata bit,
 690         supportscommontaxonname bit,
 691         supportsdistribution bit,
 692         supportsindividualassociation bit,
 693         supportsquantitativedata bit,
 694         supportstaxoninteraction bit,
 695         supportstextdata bit,
 696         defaultcolor varchar(255),
 697         primary key (id, REV)
 698     );
 699
 700     create table DefinedTermBase_Continent (
 701         DefinedTermBase_id integer not null,
 702         continents_id integer not null,
 703         primary key (DefinedTermBase_id, continents_id)
 704     );
 705
 706     create table DefinedTermBase_Continent_AUD (
 707         REV integer not null,
 708         DefinedTermBase_id integer not null,
 709         continents_id integer not null,
 710         revtype tinyint,
 711         primary key (REV, DefinedTermBase_id, continents_id)
 712     );
 713
 714     create table DefinedTermBase_MeasurementUnit (
 715         DefinedTermBase_id integer not null,
 716         recommendedmeasurementunits_id integer not null,
 717         primary key (DefinedTermBase_id, recommendedmeasurementunits_id)
 718     );
 719
 720     create table DefinedTermBase_MeasurementUnit_AUD (
 721         REV integer not null,
 722         DefinedTermBase_id integer not null,
 723         recommendedmeasurementunits_id integer not null,
 724         revtype tinyint,
 725         primary key (REV, DefinedTermBase_id, recommendedmeasurementunits_id)
 726     );
 727
 728     create table DefinedTermBase_Media (
 729         DefinedTermBase_id integer not null,
 730         media_id integer not null,
 731         primary key (DefinedTermBase_id, media_id),
 732         unique (media_id)
 733     );
 734
 735     create table DefinedTermBase_Media_AUD (
 736         REV integer not null,
 737         DefinedTermBase_id integer not null,
 738         media_id integer not null,
 739         revtype tinyint,
 740         primary key (REV, DefinedTermBase_id, media_id)
 741     );
 742
 743     create table DefinedTermBase_RecommendedModifierEnumeration (
 744         DefinedTermBase_id integer not null,
 745         recommendedmodifierenumeration_id integer not null,
 746         primary key (DefinedTermBase_id, recommendedmodifierenumeration_id),
 747         unique (recommendedmodifierenumeration_id)
 748     );
 749
 750     create table DefinedTermBase_RecommendedModifierEnumeration_AUD (
 751         REV integer not null,
 752         DefinedTermBase_id integer not null,
 753         recommendedmodifierenumeration_id integer not null,
 754         revtype tinyint,
 755         primary key (REV, DefinedTermBase_id, recommendedmodifierenumeration_id)
 756     );
 757
 758     create table DefinedTermBase_Representation (
 759         DefinedTermBase_id integer not null,
 760         representations_id integer not null,
 761         primary key (DefinedTermBase_id, representations_id),
 762         unique (representations_id)
 763     );
 764
 765     create table DefinedTermBase_Representation_AUD (
 766         REV integer not null,
 767         DefinedTermBase_id integer not null,
 768         representations_id integer not null,
 769         revtype tinyint,
 770         primary key (REV, DefinedTermBase_id, representations_id)
 771     );
 772
 773     create table DefinedTermBase_StatisticalMeasure (
 774         DefinedTermBase_id integer not null,
 775         recommendedstatisticalmeasures_id integer not null,
 776         primary key (DefinedTermBase_id, recommendedstatisticalmeasures_id)
 777     );
 778
 779     create table DefinedTermBase_StatisticalMeasure_AUD (
 780         REV integer not null,
 781         DefinedTermBase_id integer not null,
 782         recommendedstatisticalmeasures_id integer not null,
 783         revtype tinyint,
 784         primary key (REV, DefinedTermBase_id, recommendedstatisticalmeasures_id)
 785     );
 786
 787     create table DefinedTermBase_SupportedCategoricalEnumeration (
 788         DefinedTermBase_id integer not null,
 789         supportedcategoricalenumerations_id integer not null,
 790         primary key (DefinedTermBase_id, supportedcategoricalenumerations_id),
 791         unique (supportedcategoricalenumerations_id)
 792     );
 793
 794     create table DefinedTermBase_SupportedCategoricalEnumeration_AUD (
 795         REV integer not null,
 796         DefinedTermBase_id integer not null,
 797         supportedcategoricalenumerations_id integer not null,
 798         revtype tinyint,
 799         primary key (REV, DefinedTermBase_id, supportedcategoricalenumerations_id)
 800     );
 801
 802     create table DefinedTermBase_WaterbodyOrCountry (
 803         DefinedTermBase_id integer not null,
 804         waterbodiesorcountries_id integer not null,
 805         primary key (DefinedTermBase_id, waterbodiesorcountries_id)
 806     );
 807
 808     create table DefinedTermBase_WaterbodyOrCountry_AUD (
 809         REV integer not null,
 810         DefinedTermBase_id integer not null,
 811         waterbodiesorcountries_id integer not null,
 812         revtype tinyint,
 813         primary key (REV, DefinedTermBase_id, waterbodiesorcountries_id)
 814     );
 815
 816     create table DerivationEvent (
 817         id integer not null,
 818         created timestamp,
 819         uuid varchar(36),
 820         updated timestamp,
 821         description varchar(255),
 822         timeperiod_end varchar(255),
 823         timeperiod_freetext varchar(255),
 824         timeperiod_start varchar(255),
 825         createdby_id integer,
 826         updatedby_id integer,
 827         actor_id integer,
 828         type_id integer,
 829         primary key (id),
 830         unique (uuid)
 831     );
 832
 833     create table DerivationEvent_AUD (
 834         id integer not null,
 835         REV integer not null,
 836         revtype tinyint,
 837         created timestamp,
 838         uuid varchar(36),
 839         updated timestamp,
 840         description varchar(255),
 841         timeperiod_end varchar(255),
 842         timeperiod_freetext varchar(255),
 843         timeperiod_start varchar(255),
 844         createdby_id integer,
 845         updatedby_id integer,
 846         actor_id integer,
 847         type_id integer,
 848         primary key (id, REV)
 849     );
 850
 851     create table DerivationEvent_Annotation (
 852         DerivationEvent_id integer not null,
 853         annotations_id integer not null,
 854         primary key (DerivationEvent_id, annotations_id),
 855         unique (annotations_id)
 856     );
 857
 858     create table DerivationEvent_Annotation_AUD (
 859         REV integer not null,
 860         DerivationEvent_id integer not null,
 861         annotations_id integer not null,
 862         revtype tinyint,
 863         primary key (REV, DerivationEvent_id, annotations_id)
 864     );
 865
 866     create table DerivationEvent_Marker (
 867         DerivationEvent_id integer not null,
 868         markers_id integer not null,
 869         primary key (DerivationEvent_id, markers_id),
 870         unique (markers_id)
 871     );
 872
 873     create table DerivationEvent_Marker_AUD (
 874         REV integer not null,
 875         DerivationEvent_id integer not null,
 876         markers_id integer not null,
 877         revtype tinyint,
 878         primary key (REV, DerivationEvent_id, markers_id)
 879     );
 880
 881     create table DescriptionBase (
 882         DTYPE varchar(31) not null,
 883         id integer not null,
 884         created timestamp,
 885         uuid varchar(36),
 886         updated timestamp,
 887         lsid_authority varchar(255),
 888         lsid_lsid varchar(255),
 889         lsid_namespace varchar(255),
 890         lsid_object varchar(255),
 891         lsid_revision varchar(255),
 892         protectedtitlecache bit not null,
 893         titleCache varchar(255),
 894         imagegallery bit not null,
 895         createdby_id integer,
 896         updatedby_id integer,
 897         taxon_fk integer,
 898         taxonName_fk integer,
 899         primary key (id),
 900         unique (uuid)
 901     );
 902
 903     create table DescriptionBase_AUD (
 904         DTYPE varchar(31) not null,
 905         id integer not null,
 906         REV integer not null,
 907         revtype tinyint,
 908         created timestamp,
 909         uuid varchar(36),
 910         updated timestamp,
 911         lsid_authority varchar(255),
 912         lsid_lsid varchar(255),
 913         lsid_namespace varchar(255),
 914         lsid_object varchar(255),
 915         lsid_revision varchar(255),
 916         protectedtitlecache bit,
 917         titleCache varchar(255),
 918         imagegallery bit,
 919         createdby_id integer,
 920         updatedby_id integer,
 921         taxonName_fk integer,
 922         taxon_fk integer,
 923         primary key (id, REV)
 924     );
 925
 926     create table DescriptionBase_Annotation (
 927         DescriptionBase_id integer not null,
 928         annotations_id integer not null,
 929         primary key (DescriptionBase_id, annotations_id),
 930         unique (annotations_id)
 931     );
 932
 933     create table DescriptionBase_Annotation_AUD (
 934         REV integer not null,
 935         DescriptionBase_id integer not null,
 936         annotations_id integer not null,
 937         revtype tinyint,
 938         primary key (REV, DescriptionBase_id, annotations_id)
 939     );
 940
 941     create table DescriptionBase_Credit (
 942         DescriptionBase_id integer not null,
 943         credits_id integer not null,
 944         sortIndex integer not null,
 945         primary key (DescriptionBase_id, sortIndex),
 946         unique (credits_id)
 947     );
 948
 949     create table DescriptionBase_Credit_AUD (
 950         REV integer not null,
 951         DescriptionBase_id integer not null,
 952         credits_id integer not null,
 953         sortIndex integer not null,
 954         revtype tinyint,
 955         primary key (REV, DescriptionBase_id, credits_id, sortIndex)
 956     );
 957
 958     create table DescriptionBase_Extension (
 959         DescriptionBase_id integer not null,
 960         extensions_id integer not null,
 961         primary key (DescriptionBase_id, extensions_id),
 962         unique (extensions_id)
 963     );
 964
 965     create table DescriptionBase_Extension_AUD (
 966         REV integer not null,
 967         DescriptionBase_id integer not null,
 968         extensions_id integer not null,
 969         revtype tinyint,
 970         primary key (REV, DescriptionBase_id, extensions_id)
 971     );
 972
 973     create table DescriptionBase_Feature (
 974         DescriptionBase_id integer not null,
 975         descriptivesystem_id integer not null,
 976         primary key (DescriptionBase_id, descriptivesystem_id)
 977     );
 978
 979     create table DescriptionBase_Feature_AUD (
 980         REV integer not null,
 981         DescriptionBase_id integer not null,
 982         descriptivesystem_id integer not null,
 983         revtype tinyint,
 984         primary key (REV, DescriptionBase_id, descriptivesystem_id)
 985     );
 986
 987     create table DescriptionBase_GeoScope (
 988         DescriptionBase_id integer not null,
 989         geoscopes_id integer not null,
 990         primary key (DescriptionBase_id, geoscopes_id)
 991     );
 992
 993     create table DescriptionBase_GeoScope_AUD (
 994         REV integer not null,
 995         DescriptionBase_id integer not null,
 996         geoscopes_id integer not null,
 997         revtype tinyint,
 998         primary key (REV, DescriptionBase_id, geoscopes_id)
 999     );
1000
1001     create table DescriptionBase_Marker (
1002         DescriptionBase_id integer not null,
1003         markers_id integer not null,
1004         primary key (DescriptionBase_id, markers_id),
1005         unique (markers_id)
1006     );
1007
1008     create table DescriptionBase_Marker_AUD (
1009         REV integer not null,
1010         DescriptionBase_id integer not null,
1011         markers_id integer not null,
1012         revtype tinyint,
1013         primary key (REV, DescriptionBase_id, markers_id)
1014     );
1015
1016     create table DescriptionBase_OriginalSource (
1017         DescriptionBase_id integer not null,
1018         sources_id integer not null,
1019         primary key (DescriptionBase_id, sources_id),
1020         unique (sources_id)
1021     );
1022
1023     create table DescriptionBase_OriginalSource_AUD (
1024         REV integer not null,
1025         DescriptionBase_id integer not null,
1026         sources_id integer not null,
1027         revtype tinyint,
1028         primary key (REV, DescriptionBase_id, sources_id)
1029     );
1030
1031     create table DescriptionBase_ReferenceBase (
1032         DescriptionBase_id integer not null,
1033         descriptionsources_id integer not null,
1034         primary key (DescriptionBase_id, descriptionsources_id)
1035     );
1036
1037     create table DescriptionBase_ReferenceBase_AUD (
1038         REV integer not null,
1039         DescriptionBase_id integer not null,
1040         descriptionsources_id integer not null,
1041         revtype tinyint,
1042         primary key (REV, DescriptionBase_id, descriptionsources_id)
1043     );
1044
1045     create table DescriptionBase_Rights (
1046         DescriptionBase_id integer not null,
1047         rights_id integer not null,
1048         primary key (DescriptionBase_id, rights_id),
1049         unique (rights_id)
1050     );
1051
1052     create table DescriptionBase_Rights_AUD (
1053         REV integer not null,
1054         DescriptionBase_id integer not null,
1055         rights_id integer not null,
1056         revtype tinyint,
1057         primary key (REV, DescriptionBase_id, rights_id)
1058     );
1059
1060     create table DescriptionBase_Scope (
1061         DescriptionBase_id integer not null,
1062         scopes_id integer not null,
1063         primary key (DescriptionBase_id, scopes_id)
1064     );
1065
1066     create table DescriptionBase_Scope_AUD (
1067         REV integer not null,
1068         DescriptionBase_id integer not null,
1069         scopes_id integer not null,
1070         revtype tinyint,
1071         primary key (REV, DescriptionBase_id, scopes_id)
1072     );
1073
1074     create table DescriptionBase_SpecimenOrObservationBase (
1075         descriptions_id integer not null,
1076         describedspecimenorobservations_id integer not null,
1077         primary key (descriptions_id, describedspecimenorobservations_id)
1078     );
1079
1080     create table DescriptionBase_SpecimenOrObservationBase_AUD (
1081         REV integer not null,
1082         descriptions_id integer not null,
1083         describedspecimenorobservations_id integer not null,
1084         revtype tinyint,
1085         primary key (REV, descriptions_id, describedspecimenorobservations_id)
1086     );
1087
1088     create table DescriptionElementBase (
1089         DTYPE varchar(31) not null,
1090         id integer not null,
1091         created timestamp,
1092         uuid varchar(36),
1093         updated timestamp,
1094         citationmicroreference varchar(255),
1095         originalnamestring varchar(255),
1096         orderrelevant bit,
1097         name varchar(255),
1098         createdby_id integer,
1099         updatedby_id integer,
1100         citation_id integer,
1101         feature_id integer,
1102         indescription_id integer,
1103         nameusedinreference_id integer,
1104         language_id integer,
1105         area_id integer,
1106         status_id integer,
1107         associatedspecimenorobservation_id integer,
1108         unit_id integer,
1109         taxon2_id integer,
1110         format_id integer,
1111         primary key (id),
1112         unique (uuid)
1113     );
1114
1115     create table DescriptionElementBase_AUD (
1116         DTYPE varchar(31) not null,
1117         id integer not null,
1118         REV integer not null,
1119         revtype tinyint,
1120         created timestamp,
1121         uuid varchar(36),
1122         updated timestamp,
1123         citationmicroreference varchar(255),
1124         originalnamestring varchar(255),
1125         createdby_id integer,
1126         updatedby_id integer,
1127         citation_id integer,
1128         feature_id integer,
1129         indescription_id integer,
1130         nameusedinreference_id integer,
1131         unit_id integer,
1132         associatedspecimenorobservation_id integer,
1133         taxon2_id integer,
1134         area_id integer,
1135         status_id integer,
1136         orderrelevant bit,
1137         format_id integer,
1138         name varchar(255),
1139         language_id integer,
1140         primary key (id, REV)
1141     );
1142
1143     create table DescriptionElementBase_Annotation (
1144         DescriptionElementBase_id integer not null,
1145         annotations_id integer not null,
1146         primary key (DescriptionElementBase_id, annotations_id),
1147         unique (annotations_id)
1148     );
1149
1150     create table DescriptionElementBase_Annotation_AUD (
1151         REV integer not null,
1152         DescriptionElementBase_id integer not null,
1153         annotations_id integer not null,
1154         revtype tinyint,
1155         primary key (REV, DescriptionElementBase_id, annotations_id)
1156     );
1157
1158     create table DescriptionElementBase_LanguageString (
1159         DescriptionElementBase_id integer not null,
1160         multilanguagetext_id integer not null,
1161         multilanguagetext_mapkey_id integer not null,
1162         primary key (DescriptionElementBase_id, multilanguagetext_mapkey_id),
1163         unique (multilanguagetext_id)
1164     );
1165
1166     create table DescriptionElementBase_LanguageString_AUD (
1167         REV integer not null,
1168         DescriptionElementBase_id integer not null,
1169         multilanguagetext_id integer not null,
1170         multilanguagetext_mapkey_id integer not null,
1171         revtype tinyint,
1172         primary key (REV, DescriptionElementBase_id, multilanguagetext_id, multilanguagetext_mapkey_id)
1173     );
1174
1175     create table DescriptionElementBase_Marker (
1176         DescriptionElementBase_id integer not null,
1177         markers_id integer not null,
1178         primary key (DescriptionElementBase_id, markers_id),
1179         unique (markers_id)
1180     );
1181
1182     create table DescriptionElementBase_Marker_AUD (
1183         REV integer not null,
1184         DescriptionElementBase_id integer not null,
1185         markers_id integer not null,
1186         revtype tinyint,
1187         primary key (REV, DescriptionElementBase_id, markers_id)
1188     );
1189
1190     create table DescriptionElementBase_Media (
1191         DescriptionElementBase_id integer not null,
1192         media_id integer not null,
1193         sortIndex integer not null,
1194         primary key (DescriptionElementBase_id, sortIndex)
1195     );
1196
1197     create table DescriptionElementBase_Media_AUD (
1198         REV integer not null,
1199         DescriptionElementBase_id integer not null,
1200         media_id integer not null,
1201         sortIndex integer not null,
1202         revtype tinyint,
1203         primary key (REV, DescriptionElementBase_id, media_id, sortIndex)
1204     );
1205
1206     create table DescriptionElementBase_Modifier (
1207         DescriptionElementBase_id integer not null,
1208         modifiers_id integer not null,
1209         primary key (DescriptionElementBase_id, modifiers_id)
1210     );
1211
1212     create table DescriptionElementBase_Modifier_AUD (
1213         REV integer not null,
1214         DescriptionElementBase_id integer not null,
1215         modifiers_id integer not null,
1216         revtype tinyint,
1217         primary key (REV, DescriptionElementBase_id, modifiers_id)
1218     );
1219
1220     create table DescriptionElementBase_ModifyingText (
1221         DescriptionElementBase_id integer not null,
1222         modifyingtext_id integer not null,
1223         modifyingtext_mapkey_id integer not null,
1224         primary key (DescriptionElementBase_id, modifyingtext_mapkey_id),
1225         unique (modifyingtext_id)
1226     );
1227
1228     create table DescriptionElementBase_ModifyingText_AUD (
1229         REV integer not null,
1230         DescriptionElementBase_id integer not null,
1231         modifyingtext_id integer not null,
1232         modifyingtext_mapkey_id integer not null,
1233         revtype tinyint,
1234         primary key (REV, DescriptionElementBase_id, modifyingtext_id, modifyingtext_mapkey_id)
1235     );
1236
1237     create table DescriptionElementBase_StateData (
1238         DescriptionElementBase_id integer not null,
1239         states_id integer not null
1240     );
1241
1242     create table DescriptionElementBase_StateData_AUD (
1243         REV integer not null,
1244         DescriptionElementBase_id integer not null,
1245         states_id integer not null,
1246         revtype tinyint,
1247         primary key (REV, DescriptionElementBase_id, states_id)
1248     );
1249
1250     create table DescriptionElementBase_StatisticalMeasurementValue (
1251         DescriptionElementBase_id integer not null,
1252         statisticalvalues_id integer not null,
1253         primary key (DescriptionElementBase_id, statisticalvalues_id),
1254         unique (statisticalvalues_id)
1255     );
1256
1257     create table DescriptionElementBase_StatisticalMeasurementValue_AUD (
1258         REV integer not null,
1259         DescriptionElementBase_id integer not null,
1260         statisticalvalues_id integer not null,
1261         revtype tinyint,
1262         primary key (REV, DescriptionElementBase_id, statisticalvalues_id)
1263     );
1264
1265     create table DeterminationEvent (
1266         id integer not null,
1267         created timestamp,
1268         uuid varchar(36),
1269         updated timestamp,
1270         description varchar(255),
1271         timeperiod_end varchar(255),
1272         timeperiod_freetext varchar(255),
1273         timeperiod_start varchar(255),
1274         preferredflag bit not null,
1275         createdby_id integer,
1276         updatedby_id integer,
1277         actor_id integer,
1278         identifiedunit_id integer,
1279         modifier_id integer,
1280         taxon_id integer,
1281         primary key (id),
1282         unique (uuid)
1283     );
1284
1285     create table DeterminationEvent_AUD (
1286         id integer not null,
1287         REV integer not null,
1288         revtype tinyint,
1289         created timestamp,
1290         uuid varchar(36),
1291         updated timestamp,
1292         description varchar(255),
1293         timeperiod_end varchar(255),
1294         timeperiod_freetext varchar(255),
1295         timeperiod_start varchar(255),
1296         preferredflag bit,
1297         createdby_id integer,
1298         updatedby_id integer,
1299         actor_id integer,
1300         identifiedunit_id integer,
1301         modifier_id integer,
1302         taxon_id integer,
1303         primary key (id, REV)
1304     );
1305
1306     create table DeterminationEvent_Annotation (
1307         DeterminationEvent_id integer not null,
1308         annotations_id integer not null,
1309         primary key (DeterminationEvent_id, annotations_id),
1310         unique (annotations_id)
1311     );
1312
1313     create table DeterminationEvent_Annotation_AUD (
1314         REV integer not null,
1315         DeterminationEvent_id integer not null,
1316         annotations_id integer not null,
1317         revtype tinyint,
1318         primary key (REV, DeterminationEvent_id, annotations_id)
1319     );
1320
1321     create table DeterminationEvent_Marker (
1322         DeterminationEvent_id integer not null,
1323         markers_id integer not null,
1324         primary key (DeterminationEvent_id, markers_id),
1325         unique (markers_id)
1326     );
1327
1328     create table DeterminationEvent_Marker_AUD (
1329         REV integer not null,
1330         DeterminationEvent_id integer not null,
1331         markers_id integer not null,
1332         revtype tinyint,
1333         primary key (REV, DeterminationEvent_id, markers_id)
1334     );
1335
1336     create table DeterminationEvent_ReferenceBase (
1337         DeterminationEvent_id integer not null,
1338         setofreferences_id integer not null,
1339         primary key (DeterminationEvent_id, setofreferences_id)
1340     );
1341
1342     create table DeterminationEvent_ReferenceBase_AUD (
1343         REV integer not null,
1344         DeterminationEvent_id integer not null,
1345         setofreferences_id integer not null,
1346         revtype tinyint,
1347         primary key (REV, DeterminationEvent_id, setofreferences_id)
1348     );
1349
1350     create table Extension (
1351         id integer not null,
1352         created timestamp,
1353         uuid varchar(36),
1354         updated timestamp,
1355         extendedObj_type varchar(255),
1356         extendedObj_id integer not null,
1357         value longvarchar,
1358         createdby_id integer,
1359         updatedby_id integer,
1360         type_id integer,
1361         primary key (id),
1362         unique (uuid)
1363     );
1364
1365     create table Extension_AUD (
1366         id integer not null,
1367         REV integer not null,
1368         revtype tinyint,
1369         created timestamp,
1370         uuid varchar(36),
1371         updated timestamp,
1372         value longvarchar,
1373         createdby_id integer,
1374         updatedby_id integer,
1375         type_id integer,
1376         primary key (id, REV)
1377     );
1378
1379     create table FeatureNode (
1380         id integer not null,
1381         created timestamp,
1382         uuid varchar(36),
1383         updated timestamp,
1384         createdby_id integer,
1385         updatedby_id integer,
1386         feature_id integer,
1387         parent_fk integer,
1388         primary key (id),
1389         unique (uuid)
1390     );
1391
1392     create table FeatureNode_AUD (
1393         id integer not null,
1394         REV integer not null,
1395         revtype tinyint,
1396         created timestamp,
1397         uuid varchar(36),
1398         updated timestamp,
1399         createdby_id integer,
1400         updatedby_id integer,
1401         feature_id integer,
1402         parent_fk integer,
1403         primary key (id, REV)
1404     );
1405
1406     create table FeatureTree (
1407         id integer not null,
1408         created timestamp,
1409         uuid varchar(36),
1410         updated timestamp,
1411         uri varchar(255),
1412         descriptionseparated bit not null,
1413         createdby_id integer,
1414         updatedby_id integer,
1415         root_id integer,
1416         primary key (id),
1417         unique (uuid)
1418     );
1419
1420     create table FeatureTree_AUD (
1421         id integer not null,
1422         REV integer not null,
1423         revtype tinyint,
1424         created timestamp,
1425         uuid varchar(36),
1426         updated timestamp,
1427         uri varchar(255),
1428         descriptionseparated bit,
1429         createdby_id integer,
1430         updatedby_id integer,
1431         root_id integer,
1432         primary key (id, REV)
1433     );
1434
1435     create table FeatureTree_Representation (
1436         FeatureTree_id integer not null,
1437         representations_id integer not null,
1438         primary key (FeatureTree_id, representations_id),
1439         unique (representations_id)
1440     );
1441
1442     create table FeatureTree_Representation_AUD (
1443         REV integer not null,
1444         FeatureTree_id integer not null,
1445         representations_id integer not null,
1446         revtype tinyint,
1447         primary key (REV, FeatureTree_id, representations_id)
1448     );
1449
1450     create table GatheringEvent (
1451         id integer not null,
1452         created timestamp,
1453         uuid varchar(36),
1454         updated timestamp,
1455         description varchar(255),
1456         timeperiod_end varchar(255),
1457         timeperiod_freetext varchar(255),
1458         timeperiod_start varchar(255),
1459         absoluteelevation integer,
1460         absoluteelevationerror integer,
1461         collectingmethod varchar(255),
1462         distancetoground integer,
1463         distancetowatersurface integer,
1464         exactlocation_errorradius integer,
1465         exactlocation_latitude double,
1466         exactlocation_longitude double,
1467         createdby_id integer,
1468         updatedby_id integer,
1469         actor_id integer,
1470         exactlocation_referencesystem_id integer,
1471         locality_id integer,
1472         primary key (id),
1473         unique (uuid)
1474     );
1475
1476     create table GatheringEvent_AUD (
1477         id integer not null,
1478         REV integer not null,
1479         revtype tinyint,
1480         created timestamp,
1481         uuid varchar(36),
1482         updated timestamp,
1483         description varchar(255),
1484         timeperiod_end varchar(255),
1485         timeperiod_freetext varchar(255),
1486         timeperiod_start varchar(255),
1487         absoluteelevation integer,
1488         absoluteelevationerror integer,
1489         collectingmethod varchar(255),
1490         distancetoground integer,
1491         distancetowatersurface integer,
1492         exactlocation_errorradius integer,
1493         exactlocation_latitude double,
1494         exactlocation_longitude double,
1495         createdby_id integer,
1496         updatedby_id integer,
1497         actor_id integer,
1498         exactlocation_referencesystem_id integer,
1499         locality_id integer,
1500         primary key (id, REV)
1501     );
1502
1503     create table GatheringEvent_Annotation (
1504         GatheringEvent_id integer not null,
1505         annotations_id integer not null,
1506         primary key (GatheringEvent_id, annotations_id),
1507         unique (annotations_id)
1508     );
1509
1510     create table GatheringEvent_Annotation_AUD (
1511         REV integer not null,
1512         GatheringEvent_id integer not null,
1513         annotations_id integer not null,
1514         revtype tinyint,
1515         primary key (REV, GatheringEvent_id, annotations_id)
1516     );
1517
1518     create table GatheringEvent_DefinedTermBase (
1519         GatheringEvent_id integer not null,
1520         collectingareas_id integer not null,
1521         primary key (GatheringEvent_id, collectingareas_id)
1522     );
1523
1524     create table GatheringEvent_DefinedTermBase_AUD (
1525         REV integer not null,
1526         GatheringEvent_id integer not null,
1527         collectingareas_id integer not null,
1528         revtype tinyint,
1529         primary key (REV, GatheringEvent_id, collectingareas_id)
1530     );
1531
1532     create table GatheringEvent_Marker (
1533         GatheringEvent_id integer not null,
1534         markers_id integer not null,
1535         primary key (GatheringEvent_id, markers_id),
1536         unique (markers_id)
1537     );
1538
1539     create table GatheringEvent_Marker_AUD (
1540         REV integer not null,
1541         GatheringEvent_id integer not null,
1542         markers_id integer not null,
1543         revtype tinyint,
1544         primary key (REV, GatheringEvent_id, markers_id)
1545     );
1546
1547     create table GenBankAccession (
1548         id integer not null,
1549         created timestamp,
1550         uuid varchar(36),
1551         updated timestamp,
1552         accessionnumber varchar(255),
1553         uri varchar(255),
1554         createdby_id integer,
1555         updatedby_id integer,
1556         primary key (id),
1557         unique (uuid)
1558     );
1559
1560     create table GenBankAccession_AUD (
1561         id integer not null,
1562         REV integer not null,
1563         revtype tinyint,
1564         created timestamp,
1565         uuid varchar(36),
1566         updated timestamp,
1567         accessionnumber varchar(255),
1568         uri varchar(255),
1569         createdby_id integer,
1570         updatedby_id integer,
1571         primary key (id, REV)
1572     );
1573
1574     create table GrantedAuthorityImpl (
1575         id integer not null,
1576         created timestamp,
1577         uuid varchar(36),
1578         authority varchar(255),
1579         createdby_id integer,
1580         primary key (id),
1581         unique (uuid, authority)
1582     );
1583
1584     create table HomotypicalGroup (
1585         id integer not null,
1586         created timestamp,
1587         uuid varchar(36),
1588         updated timestamp,
1589         createdby_id integer,
1590         updatedby_id integer,
1591         primary key (id),
1592         unique (uuid)
1593     );
1594
1595     create table HomotypicalGroup_AUD (
1596         id integer not null,
1597         REV integer not null,
1598         revtype tinyint,
1599         created timestamp,
1600         uuid varchar(36),
1601         updated timestamp,
1602         createdby_id integer,
1603         updatedby_id integer,
1604         primary key (id, REV)
1605     );
1606
1607     create table HomotypicalGroup_Annotation (
1608         HomotypicalGroup_id integer not null,
1609         annotations_id integer not null,
1610         primary key (HomotypicalGroup_id, annotations_id),
1611         unique (annotations_id)
1612     );
1613
1614     create table HomotypicalGroup_Annotation_AUD (
1615         REV integer not null,
1616         HomotypicalGroup_id integer not null,
1617         annotations_id integer not null,
1618         revtype tinyint,
1619         primary key (REV, HomotypicalGroup_id, annotations_id)
1620     );
1621
1622     create table HomotypicalGroup_Marker (
1623         HomotypicalGroup_id integer not null,
1624         markers_id integer not null,
1625         primary key (HomotypicalGroup_id, markers_id),
1626         unique (markers_id)
1627     );
1628
1629     create table HomotypicalGroup_Marker_AUD (
1630         REV integer not null,
1631         HomotypicalGroup_id integer not null,
1632         markers_id integer not null,
1633         revtype tinyint,
1634         primary key (REV, HomotypicalGroup_id, markers_id)
1635     );
1636
1637     create table HybridRelationship (
1638         id integer not null,
1639         created timestamp,
1640         uuid varchar(36),
1641         updated timestamp,
1642         citationmicroreference varchar(255),
1643         originalnamestring varchar(255),
1644         doubtful bit not null,
1645         ruleconsidered varchar(255),
1646         createdby_id integer,
1647         updatedby_id integer,
1648         citation_id integer,
1649         relatedfrom_id integer,
1650         relatedto_id integer,
1651         type_id integer,
1652         primary key (id),
1653         unique (uuid)
1654     );
1655
1656     create table HybridRelationship_AUD (
1657         id integer not null,
1658         REV integer not null,
1659         revtype tinyint,
1660         created timestamp,
1661         uuid varchar(36),
1662         updated timestamp,
1663         citationmicroreference varchar(255),
1664         originalnamestring varchar(255),
1665         doubtful bit,
1666         ruleconsidered varchar(255),
1667         createdby_id integer,
1668         updatedby_id integer,
1669         citation_id integer,
1670         relatedfrom_id integer,
1671         relatedto_id integer,
1672         type_id integer,
1673         primary key (id, REV)
1674     );
1675
1676     create table HybridRelationship_Annotation (
1677         HybridRelationship_id integer not null,
1678         annotations_id integer not null,
1679         primary key (HybridRelationship_id, annotations_id),
1680         unique (annotations_id)
1681     );
1682
1683     create table HybridRelationship_Annotation_AUD (
1684         REV integer not null,
1685         HybridRelationship_id integer not null,
1686         annotations_id integer not null,
1687         revtype tinyint,
1688         primary key (REV, HybridRelationship_id, annotations_id)
1689     );
1690
1691     create table HybridRelationship_Marker (
1692         HybridRelationship_id integer not null,
1693         markers_id integer not null,
1694         primary key (HybridRelationship_id, markers_id),
1695         unique (markers_id)
1696     );
1697
1698     create table HybridRelationship_Marker_AUD (
1699         REV integer not null,
1700         HybridRelationship_id integer not null,
1701         markers_id integer not null,
1702         revtype tinyint,
1703         primary key (REV, HybridRelationship_id, markers_id)
1704     );
1705
1706     create table MediaKey_Taxon (
1707         mediaKey_fk integer not null,
1708         taxon_fk integer not null,
1709         primary key (mediaKey_fk, taxon_fk)
1710     );
1711
1712     create table MediaKey_Taxon_AUD (
1713         REV integer not null,
1714         mediaKey_fk integer not null,
1715         taxon_fk integer not null,
1716         revtype tinyint,
1717         primary key (REV, mediaKey_fk, taxon_fk)
1718     );
1719
1720     create table IndividualAssociation_LanguageString (
1721         DescriptionElementBase_id integer not null,
1722         description_id integer not null,
1723         description_mapkey_id integer not null,
1724         primary key (DescriptionElementBase_id, description_mapkey_id),
1725         unique (description_id)
1726     );
1727
1728     create table IndividualAssociation_LanguageString_AUD (
1729         REV integer not null,
1730         DescriptionElementBase_id integer not null,
1731         description_id integer not null,
1732         description_mapkey_id integer not null,
1733         revtype tinyint,
1734         primary key (REV, DescriptionElementBase_id, description_id, description_mapkey_id)
1735     );
1736
1737     create table InstitutionalMembership (
1738         id integer not null,
1739         created timestamp,
1740         uuid varchar(36),
1741         updated timestamp,
1742         department varchar(255),
1743         period_end varchar(255),
1744         period_freetext varchar(255),
1745         period_start varchar(255),
1746         role varchar(255),
1747         createdby_id integer,
1748         updatedby_id integer,
1749         institute_id integer,
1750         person_id integer,
1751         primary key (id),
1752         unique (uuid)
1753     );
1754
1755     create table InstitutionalMembership_AUD (
1756         id integer not null,
1757         REV integer not null,
1758         revtype tinyint,
1759         created timestamp,
1760         uuid varchar(36),
1761         updated timestamp,
1762         department varchar(255),
1763         period_end varchar(255),
1764         period_freetext varchar(255),
1765         period_start varchar(255),
1766         role varchar(255),
1767         createdby_id integer,
1768         updatedby_id integer,
1769         institute_id integer,
1770         person_id integer,
1771         primary key (id, REV)
1772     );
1773
1774     create table LSIDAuthority (
1775         id integer not null,
1776         created timestamp,
1777         uuid varchar(36),
1778         authority varchar(255),
1779         authoritywsdl longvarchar,
1780         port integer not null,
1781         server varchar(255),
1782         url varchar(255),
1783         createdby_id integer,
1784         primary key (id),
1785         unique (uuid, authority)
1786     );
1787
1788     create table LSIDAuthority_namespaces (
1789         LSIDAuthority_id integer not null,
1790         namespaces_element varchar(255),
1791         namespaces_mapkey varchar(255),
1792         primary key (LSIDAuthority_id, namespaces_mapkey)
1793     );
1794
1795     create table LanguageString (
1796         id integer not null,
1797         created timestamp,
1798         uuid varchar(36),
1799         updated timestamp,
1800         text longvarchar,
1801         createdby_id integer,
1802         updatedby_id integer,
1803         language_id integer,
1804         primary key (id),
1805         unique (uuid)
1806     );
1807
1808     create table LanguageString_AUD (
1809         id integer not null,
1810         REV integer not null,
1811         revtype tinyint,
1812         created timestamp,
1813         uuid varchar(36),
1814         updated timestamp,
1815         text longvarchar,
1816         createdby_id integer,
1817         updatedby_id integer,
1818         language_id integer,
1819         primary key (id, REV)
1820     );
1821
1822     create table LanguageString_Annotation (
1823         LanguageString_id integer not null,
1824         annotations_id integer not null,
1825         primary key (LanguageString_id, annotations_id),
1826         unique (annotations_id)
1827     );
1828
1829     create table LanguageString_Annotation_AUD (
1830         REV integer not null,
1831         LanguageString_id integer not null,
1832         annotations_id integer not null,
1833         revtype tinyint,
1834         primary key (REV, LanguageString_id, annotations_id)
1835     );
1836
1837     create table LanguageString_Marker (
1838         LanguageString_id integer not null,
1839         markers_id integer not null,
1840         primary key (LanguageString_id, markers_id),
1841         unique (markers_id)
1842     );
1843
1844     create table LanguageString_Marker_AUD (
1845         REV integer not null,
1846         LanguageString_id integer not null,
1847         markers_id integer not null,
1848         revtype tinyint,
1849         primary key (REV, LanguageString_id, markers_id)
1850     );
1851
1852     create table Locus (
1853         id integer not null,
1854         created timestamp,
1855         uuid varchar(36),
1856         updated timestamp,
1857         description varchar(255),
1858         name varchar(255),
1859         createdby_id integer,
1860         updatedby_id integer,
1861         primary key (id),
1862         unique (uuid)
1863     );
1864
1865     create table Locus_AUD (
1866         id integer not null,
1867         REV integer not null,
1868         revtype tinyint,
1869         created timestamp,
1870         uuid varchar(36),
1871         updated timestamp,
1872         description varchar(255),
1873         name varchar(255),
1874         createdby_id integer,
1875         updatedby_id integer,
1876         primary key (id, REV)
1877     );
1878
1879     create table Marker (
1880         id integer not null,
1881         created timestamp,
1882         uuid varchar(36),
1883         updated timestamp,
1884         flag bit not null,
1885         markedObj_type varchar(255),
1886         markedObj_id integer not null,
1887         createdby_id integer,
1888         updatedby_id integer,
1889         markertype_id integer,
1890         primary key (id),
1891         unique (uuid)
1892     );
1893
1894     create table Marker_AUD (
1895         id integer not null,
1896         REV integer not null,
1897         revtype tinyint,
1898         created timestamp,
1899         uuid varchar(36),
1900         updated timestamp,
1901         flag bit,
1902         createdby_id integer,
1903         updatedby_id integer,
1904         markertype_id integer,
1905         primary key (id, REV)
1906     );
1907
1908     create table Media (
1909         DTYPE varchar(31) not null,
1910         id integer not null,
1911         created timestamp,
1912         uuid varchar(36),
1913         updated timestamp,
1914         mediacreated timestamp,
1915         citationmicroreference varchar(255),
1916         createdby_id integer,
1917         updatedby_id integer,
1918         artist_id integer,
1919         citation_id integer,
1920         primary key (id),
1921         unique (uuid)
1922     );
1923
1924     create table MediaRepresentation (
1925         id integer not null,
1926         created timestamp,
1927         uuid varchar(36),
1928         updated timestamp,
1929         mimetype varchar(255),
1930         suffix varchar(255),
1931         createdby_id integer,
1932         updatedby_id integer,
1933         media_id integer,
1934         primary key (id),
1935         unique (uuid)
1936     );
1937
1938     create table MediaRepresentationPart (
1939         DTYPE varchar(31) not null,
1940         id integer not null,
1941         created timestamp,
1942         uuid varchar(36),
1943         updated timestamp,
1944         size integer,
1945         uri varchar(255),
1946         duration integer,
1947         height integer,
1948         width integer,
1949         createdby_id integer,
1950         updatedby_id integer,
1951         representation_id integer not null,
1952         sortIndex integer,
1953         primary key (id),
1954         unique (uuid)
1955     );
1956
1957     create table MediaRepresentationPart_AUD (
1958         DTYPE varchar(31) not null,
1959         id integer not null,
1960         REV integer not null,
1961         revtype tinyint,
1962         created timestamp,
1963         uuid varchar(36),
1964         updated timestamp,
1965         size integer,
1966         uri varchar(255),
1967         createdby_id integer,
1968         updatedby_id integer,
1969         representation_id integer,
1970         height integer,
1971         width integer,
1972         duration integer,
1973         primary key (id, REV)
1974     );
1975
1976     create table MediaRepresentation_AUD (
1977         id integer not null,
1978         REV integer not null,
1979         revtype tinyint,
1980         created timestamp,
1981         uuid varchar(36),
1982         updated timestamp,
1983         mimetype varchar(255),
1984         suffix varchar(255),
1985         createdby_id integer,
1986         updatedby_id integer,
1987         media_id integer,
1988         primary key (id, REV)
1989     );
1990
1991     create table MediaRepresentation_MediaRepresentationPart_AUD (
1992         REV integer not null,
1993         representation_id integer not null,
1994         id integer not null,
1995         sortIndex integer not null,
1996         revtype tinyint,
1997         primary key (REV, representation_id, id, sortIndex)
1998     );
1999
2000     create table Media_AUD (
2001         DTYPE varchar(31) not null,
2002         id integer not null,
2003         REV integer not null,
2004         revtype tinyint,
2005         created timestamp,
2006         uuid varchar(36),
2007         updated timestamp,
2008         mediacreated timestamp,
2009         createdby_id integer,
2010         updatedby_id integer,
2011         artist_id integer,
2012         citationmicroreference varchar(255),
2013         citation_id integer,
2014         primary key (id, REV)
2015     );
2016
2017     create table Media_Annotation (
2018         Media_id integer not null,
2019         annotations_id integer not null,
2020         primary key (Media_id, annotations_id),
2021         unique (annotations_id)
2022     );
2023
2024     create table Media_Annotation_AUD (
2025         REV integer not null,
2026         Media_id integer not null,
2027         annotations_id integer not null,
2028         revtype tinyint,
2029         primary key (REV, Media_id, annotations_id)
2030     );
2031
2032     create table Media_DefinedTermBase (
2033         Media_id integer not null,
2034         geoscopes_id integer not null,
2035         primary key (Media_id, geoscopes_id)
2036     );
2037
2038     create table Media_DefinedTermBase_AUD (
2039         REV integer not null,
2040         Media_id integer not null,
2041         geoscopes_id integer not null,
2042         revtype tinyint,
2043         primary key (REV, Media_id, geoscopes_id)
2044     );
2045
2046     create table Media_Description (
2047         Media_id integer not null,
2048         description_id integer not null,
2049         description_mapkey_id integer not null,
2050         primary key (Media_id, description_mapkey_id),
2051         unique (description_id)
2052     );
2053
2054     create table Media_Description_AUD (
2055         REV integer not null,
2056         Media_id integer not null,
2057         description_id integer not null,
2058         description_mapkey_id integer not null,
2059         revtype tinyint,
2060         primary key (REV, Media_id, description_id, description_mapkey_id)
2061     );
2062
2063     create table Media_LanguageString (
2064         Media_id integer not null,
2065         title_id integer not null,
2066         title_mapkey_id integer not null,
2067         primary key (Media_id, title_mapkey_id),
2068         unique (title_id)
2069     );
2070
2071     create table Media_LanguageString_AUD (
2072         REV integer not null,
2073         Media_id integer not null,
2074         title_id integer not null,
2075         title_mapkey_id integer not null,
2076         revtype tinyint,
2077         primary key (REV, Media_id, title_id, title_mapkey_id)
2078     );
2079
2080     create table Media_Marker (
2081         Media_id integer not null,
2082         markers_id integer not null,
2083         primary key (Media_id, markers_id),
2084         unique (markers_id)
2085     );
2086
2087     create table Media_Marker_AUD (
2088         REV integer not null,
2089         Media_id integer not null,
2090         markers_id integer not null,
2091         revtype tinyint,
2092         primary key (REV, Media_id, markers_id)
2093     );
2094
2095     create table Media_Rights (
2096         Media_id integer not null,
2097         rights_id integer not null,
2098         primary key (Media_id, rights_id)
2099     );
2100
2101     create table Media_Rights_AUD (
2102         REV integer not null,
2103         Media_id integer not null,
2104         rights_id integer not null,
2105         revtype tinyint,
2106         primary key (REV, Media_id, rights_id)
2107     );
2108
2109     create table Media_Sequence (
2110         Media_id integer not null,
2111         usedsequences_id integer not null,
2112         primary key (Media_id, usedsequences_id),
2113         unique (usedsequences_id)
2114     );
2115
2116     create table Media_Sequence_AUD (
2117         REV integer not null,
2118         Media_id integer not null,
2119         usedsequences_id integer not null,
2120         revtype tinyint,
2121         primary key (REV, Media_id, usedsequences_id)
2122     );
2123
2124     create table Media_TaxonBase (
2125         Media_id integer not null,
2126         coveredtaxa_id integer not null,
2127         primary key (Media_id, coveredtaxa_id)
2128     );
2129
2130     create table Media_TaxonBase_AUD (
2131         REV integer not null,
2132         Media_id integer not null,
2133         coveredtaxa_id integer not null,
2134         revtype tinyint,
2135         primary key (REV, Media_id, coveredtaxa_id)
2136     );
2137
2138     create table NameRelationship (
2139         id integer not null,
2140         created timestamp,
2141         uuid varchar(36),
2142         updated timestamp,
2143         citationmicroreference varchar(255),
2144         originalnamestring varchar(255),
2145         doubtful bit not null,
2146         ruleconsidered varchar(255),
2147         createdby_id integer,
2148         updatedby_id integer,
2149         citation_id integer,
2150         relatedfrom_id integer,
2151         relatedto_id integer,
2152         type_id integer,
2153         primary key (id),
2154         unique (uuid)
2155     );
2156
2157     create table NameRelationship_AUD (
2158         id integer not null,
2159         REV integer not null,
2160         revtype tinyint,
2161         created timestamp,
2162         uuid varchar(36),
2163         updated timestamp,
2164         citationmicroreference varchar(255),
2165         originalnamestring varchar(255),
2166         doubtful bit,
2167         ruleconsidered varchar(255),
2168         createdby_id integer,
2169         updatedby_id integer,
2170         citation_id integer,
2171         relatedfrom_id integer,
2172         relatedto_id integer,
2173         type_id integer,
2174         primary key (id, REV)
2175     );
2176
2177     create table NameRelationship_Annotation (
2178         NameRelationship_id integer not null,
2179         annotations_id integer not null,
2180         primary key (NameRelationship_id, annotations_id),
2181         unique (annotations_id)
2182     );
2183
2184     create table NameRelationship_Annotation_AUD (
2185         REV integer not null,
2186         NameRelationship_id integer not null,
2187         annotations_id integer not null,
2188         revtype tinyint,
2189         primary key (REV, NameRelationship_id, annotations_id)
2190     );
2191
2192     create table NameRelationship_Marker (
2193         NameRelationship_id integer not null,
2194         markers_id integer not null,
2195         primary key (NameRelationship_id, markers_id),
2196         unique (markers_id)
2197     );
2198
2199     create table NameRelationship_Marker_AUD (
2200         REV integer not null,
2201         NameRelationship_id integer not null,
2202         markers_id integer not null,
2203         revtype tinyint,
2204         primary key (REV, NameRelationship_id, markers_id)
2205     );
2206
2207     create table NomenclaturalStatus (
2208         id integer not null,
2209         created timestamp,
2210         uuid varchar(36),
2211         updated timestamp,
2212         citationmicroreference varchar(255),
2213         originalnamestring varchar(255),
2214         ruleconsidered varchar(255),
2215         createdby_id integer,
2216         updatedby_id integer,
2217         citation_id integer,
2218         type_id integer,
2219         primary key (id),
2220         unique (uuid)
2221     );
2222
2223     create table NomenclaturalStatus_AUD (
2224         id integer not null,
2225         REV integer not null,
2226         revtype tinyint,
2227         created timestamp,
2228         uuid varchar(36),
2229         updated timestamp,
2230         citationmicroreference varchar(255),
2231         originalnamestring varchar(255),
2232         ruleconsidered varchar(255),
2233         createdby_id integer,
2234         updatedby_id integer,
2235         citation_id integer,
2236         type_id integer,
2237         primary key (id, REV)
2238     );
2239
2240     create table NomenclaturalStatus_Annotation (
2241         NomenclaturalStatus_id integer not null,
2242         annotations_id integer not null,
2243         primary key (NomenclaturalStatus_id, annotations_id),
2244         unique (annotations_id)
2245     );
2246
2247     create table NomenclaturalStatus_Annotation_AUD (
2248         REV integer not null,
2249         NomenclaturalStatus_id integer not null,
2250         annotations_id integer not null,
2251         revtype tinyint,
2252         primary key (REV, NomenclaturalStatus_id, annotations_id)
2253     );
2254
2255     create table NomenclaturalStatus_Marker (
2256         NomenclaturalStatus_id integer not null,
2257         markers_id integer not null,
2258         primary key (NomenclaturalStatus_id, markers_id),
2259         unique (markers_id)
2260     );
2261
2262     create table NomenclaturalStatus_Marker_AUD (
2263         REV integer not null,
2264         NomenclaturalStatus_id integer not null,
2265         markers_id integer not null,
2266         revtype tinyint,
2267         primary key (REV, NomenclaturalStatus_id, markers_id)
2268     );
2269
2270     create table OriginalSource (
2271         id integer not null,
2272         created timestamp,
2273         uuid varchar(36),
2274         updated timestamp,
2275         citationmicroreference varchar(255),
2276         originalnamestring varchar(255),
2277         idinsource varchar(255),
2278         idnamespace varchar(255),
2279         sourcedObj_type varchar(255),
2280         sourcedObj_id integer not null,
2281         createdby_id integer,
2282         updatedby_id integer,
2283         citation_id integer,
2284         primary key (id),
2285         unique (uuid)
2286     );
2287
2288     create table OriginalSource_AUD (
2289         id integer not null,
2290         REV integer not null,
2291         revtype tinyint,
2292         created timestamp,
2293         uuid varchar(36),
2294         updated timestamp,
2295         citationmicroreference varchar(255),
2296         originalnamestring varchar(255),
2297         idinsource varchar(255),
2298         idnamespace varchar(255),
2299         createdby_id integer,
2300         updatedby_id integer,
2301         citation_id integer,
2302         primary key (id, REV)
2303     );
2304
2305     create table OriginalSource_Annotation (
2306         OriginalSource_id integer not null,
2307         annotations_id integer not null,
2308         primary key (OriginalSource_id, annotations_id),
2309         unique (annotations_id)
2310     );
2311
2312     create table OriginalSource_Annotation_AUD (
2313         REV integer not null,
2314         OriginalSource_id integer not null,
2315         annotations_id integer not null,
2316         revtype tinyint,
2317         primary key (REV, OriginalSource_id, annotations_id)
2318     );
2319
2320     create table OriginalSource_Marker (
2321         OriginalSource_id integer not null,
2322         markers_id integer not null,
2323         primary key (OriginalSource_id, markers_id),
2324         unique (markers_id)
2325     );
2326
2327     create table OriginalSource_Marker_AUD (
2328         REV integer not null,
2329         OriginalSource_id integer not null,
2330         markers_id integer not null,
2331         revtype tinyint,
2332         primary key (REV, OriginalSource_id, markers_id)
2333     );
2334
2335     create table PermissionGroup (
2336         id integer not null,
2337         created timestamp,
2338         uuid varchar(36),
2339         name varchar(255),
2340         createdby_id integer,
2341         primary key (id),
2342         unique (uuid, name)
2343     );
2344
2345     create table PermissionGroup_GrantedAuthorityImpl (
2346         PermissionGroup_id integer not null,
2347         grantedauthorities_id integer not null,
2348         primary key (PermissionGroup_id, grantedauthorities_id)
2349     );
2350
2351     create table Person_Keyword (
2352         person_fk integer not null,
2353         keyword_fk integer not null,
2354         primary key (person_fk, keyword_fk)
2355     );
2356
2357     create table Person_Keyword_AUD (
2358         REV integer not null,
2359         person_fk integer not null,
2360         keyword_fk integer not null,
2361         revtype tinyint,
2362         primary key (REV, person_fk, keyword_fk)
2363     );
2364
2365     create table Publisher (
2366         id integer not null,
2367         created timestamp,
2368         uuid varchar(36),
2369         place varchar(255),
2370         publishername varchar(255),
2371         createdby_id integer,
2372         primary key (id),
2373         unique (uuid)
2374     );
2375
2376     create table Publisher_AUD (
2377         id integer not null,
2378         REV integer not null,
2379         revtype tinyint,
2380         created timestamp,
2381         uuid varchar(36),
2382         place varchar(255),
2383         publishername varchar(255),
2384         createdby_id integer,
2385         primary key (id, REV)
2386     );
2387
2388     create table ReferenceBase (
2389         DTYPE varchar(31) not null,
2390         id integer not null,
2391         created timestamp,
2392         uuid varchar(36),
2393         updated timestamp,
2394         lsid_authority varchar(255),
2395         lsid_lsid varchar(255),
2396         lsid_namespace varchar(255),
2397         lsid_object varchar(255),
2398         lsid_revision varchar(255),
2399         protectedtitlecache bit not null,
2400         titleCache varchar(255),
2401         hasproblem bit not null,
2402         nomenclaturallyrelevant bit not null,
2403         problemends integer not null,
2404         problemstarts integer not null,
2405         uri varchar(255),
2406         datepublished_end varchar(255),
2407         datepublished_freetext varchar(255),
2408         datepublished_start varchar(255),
2409         title longvarchar,
2410         pages varchar(255),
2411         series varchar(255),
2412         volume varchar(255),
2413         address varchar(255),
2414         annote varchar(255),
2415         booktitle varchar(255),
2416         chapter varchar(255),
2417         edition varchar(255),
2418         editor varchar(255),
2419         eprint varchar(255),
2420         howpublished varchar(255),
2421         institution varchar(255),
2422         journal varchar(255),
2423         month varchar(255),
2424         note varchar(255),
2425         number varchar(255),
2426         organization varchar(255),
2427         publisher varchar(255),
2428         reporttype varchar(255),
2429         school varchar(255),
2430         year varchar(255),
2431         placepublished varchar(255),
2432         seriespart varchar(255),
2433         isbn varchar(255),
2434         issn varchar(255),
2435         createdby_id integer,
2436         updatedby_id integer,
2437         authorteam_id integer,
2438         injournal_id integer,
2439         crossref_id integer,
2440         type_id integer,
2441         inseries_id integer,
2442         inbook_id integer,
2443         inproceedings_id integer,
2444         institution_id integer,
2445         school_id integer,
2446         primary key (id),
2447         unique (uuid)
2448     );
2449
2450     create table ReferenceBase_AUD (
2451         DTYPE varchar(31) not null,
2452         id integer not null,
2453         REV integer not null,
2454         revtype tinyint,
2455         created timestamp,
2456         uuid varchar(36),
2457         updated timestamp,
2458         lsid_authority varchar(255),
2459         lsid_lsid varchar(255),
2460         lsid_namespace varchar(255),
2461         lsid_object varchar(255),
2462         lsid_revision varchar(255),
2463         protectedtitlecache bit,
2464         titleCache varchar(255),
2465         hasproblem bit,
2466         nomenclaturallyrelevant bit,
2467         problemends integer,
2468         problemstarts integer,
2469         uri varchar(255),
2470         createdby_id integer,
2471         updatedby_id integer,
2472         authorteam_id integer,
2473         datepublished_end varchar(255),
2474         datepublished_freetext varchar(255),
2475         datepublished_start varchar(255),
2476         title longvarchar,
2477         pages varchar(255),
2478         series varchar(255),
2479         volume varchar(255),
2480         injournal_id integer,
2481         inproceedings_id integer,
2482         inbook_id integer,
2483         placepublished varchar(255),
2484         publisher varchar(255),
2485         editor varchar(255),
2486         institution_id integer,
2487         issn varchar(255),
2488         school_id integer,
2489         address varchar(255),
2490         annote varchar(255),
2491         booktitle varchar(255),
2492         chapter varchar(255),
2493         edition varchar(255),
2494         eprint varchar(255),
2495         howpublished varchar(255),
2496         institution varchar(255),
2497         journal varchar(255),
2498         month varchar(255),
2499         note varchar(255),
2500         number varchar(255),
2501         organization varchar(255),
2502         reporttype varchar(255),
2503         school varchar(255),
2504         year varchar(255),
2505         crossref_id integer,
2506         type_id integer,
2507         seriespart varchar(255),
2508         inseries_id integer,
2509         isbn varchar(255),
2510         primary key (id, REV)
2511     );
2512
2513     create table ReferenceBase_Annotation (
2514         ReferenceBase_id integer not null,
2515         annotations_id integer not null,
2516         primary key (ReferenceBase_id, annotations_id),
2517         unique (annotations_id)
2518     );
2519
2520     create table ReferenceBase_Annotation_AUD (
2521         REV integer not null,
2522         ReferenceBase_id integer not null,
2523         annotations_id integer not null,
2524         revtype tinyint,
2525         primary key (REV, ReferenceBase_id, annotations_id)
2526     );
2527
2528     create table ReferenceBase_Credit (
2529         ReferenceBase_id integer not null,
2530         credits_id integer not null,
2531         sortIndex integer not null,
2532         primary key (ReferenceBase_id, sortIndex),
2533         unique (credits_id)
2534     );
2535
2536     create table ReferenceBase_Credit_AUD (
2537         REV integer not null,
2538         ReferenceBase_id integer not null,
2539         credits_id integer not null,
2540         sortIndex integer not null,
2541         revtype tinyint,
2542         primary key (REV, ReferenceBase_id, credits_id, sortIndex)
2543     );
2544
2545     create table ReferenceBase_Extension (
2546         ReferenceBase_id integer not null,
2547         extensions_id integer not null,
2548         primary key (ReferenceBase_id, extensions_id),
2549         unique (extensions_id)
2550     );
2551
2552     create table ReferenceBase_Extension_AUD (
2553         REV integer not null,
2554         ReferenceBase_id integer not null,
2555         extensions_id integer not null,
2556         revtype tinyint,
2557         primary key (REV, ReferenceBase_id, extensions_id)
2558     );
2559
2560     create table ReferenceBase_Marker (
2561         ReferenceBase_id integer not null,
2562         markers_id integer not null,
2563         primary key (ReferenceBase_id, markers_id),
2564         unique (markers_id)
2565     );
2566
2567     create table ReferenceBase_Marker_AUD (
2568         REV integer not null,
2569         ReferenceBase_id integer not null,
2570         markers_id integer not null,
2571         revtype tinyint,
2572         primary key (REV, ReferenceBase_id, markers_id)
2573     );
2574
2575     create table ReferenceBase_Media (
2576         ReferenceBase_id integer not null,
2577         media_id integer not null,
2578         primary key (ReferenceBase_id, media_id)
2579     );
2580
2581     create table ReferenceBase_Media_AUD (
2582         REV integer not null,
2583         ReferenceBase_id integer not null,
2584         media_id integer not null,
2585         revtype tinyint,
2586         primary key (REV, ReferenceBase_id, media_id)
2587     );
2588
2589     create table ReferenceBase_OriginalSource (
2590         ReferenceBase_id integer not null,
2591         sources_id integer not null,
2592         primary key (ReferenceBase_id, sources_id),
2593         unique (sources_id)
2594     );
2595
2596     create table ReferenceBase_OriginalSource_AUD (
2597         REV integer not null,
2598         ReferenceBase_id integer not null,
2599         sources_id integer not null,
2600         revtype tinyint,
2601         primary key (REV, ReferenceBase_id, sources_id)
2602     );
2603
2604     create table ReferenceBase_Rights (
2605         ReferenceBase_id integer not null,
2606         rights_id integer not null,
2607         primary key (ReferenceBase_id, rights_id),
2608         unique (rights_id)
2609     );
2610
2611     create table ReferenceBase_Rights_AUD (
2612         REV integer not null,
2613         ReferenceBase_id integer not null,
2614         rights_id integer not null,
2615         revtype tinyint,
2616         primary key (REV, ReferenceBase_id, rights_id)
2617     );
2618
2619     create table RelationshipTermBase_inverseRepresentation (
2620         DefinedTermBase_id integer not null,
2621         inverserepresentations_id integer not null,
2622         primary key (DefinedTermBase_id, inverserepresentations_id),
2623         unique (inverserepresentations_id)
2624     );
2625
2626     create table RelationshipTermBase_inverseRepresentation_AUD (
2627         REV integer not null,
2628         DefinedTermBase_id integer not null,
2629         inverserepresentations_id integer not null,
2630         revtype tinyint,
2631         primary key (REV, DefinedTermBase_id, inverserepresentations_id)
2632     );
2633
2634     create table Representation (
2635         id integer not null,
2636         created timestamp,
2637         uuid varchar(36),
2638         updated timestamp,
2639         text longvarchar,
2640         abbreviatedlabel varchar(255),
2641         label varchar(255),
2642         createdby_id integer,
2643         updatedby_id integer,
2644         language_id integer,
2645         primary key (id),
2646         unique (uuid)
2647     );
2648
2649     create table Representation_AUD (
2650         id integer not null,
2651         REV integer not null,
2652         revtype tinyint,
2653         created timestamp,
2654         uuid varchar(36),
2655         updated timestamp,
2656         text longvarchar,
2657         abbreviatedlabel varchar(255),
2658         label varchar(255),
2659         createdby_id integer,
2660         updatedby_id integer,
2661         language_id integer,
2662         primary key (id, REV)
2663     );
2664
2665     create table Representation_Annotation (
2666         Representation_id integer not null,
2667         annotations_id integer not null,
2668         primary key (Representation_id, annotations_id),
2669         unique (annotations_id)
2670     );
2671
2672     create table Representation_Annotation_AUD (
2673         REV integer not null,
2674         Representation_id integer not null,
2675         annotations_id integer not null,
2676         revtype tinyint,
2677         primary key (REV, Representation_id, annotations_id)
2678     );
2679
2680     create table Representation_Marker (
2681         Representation_id integer not null,
2682         markers_id integer not null,
2683         primary key (Representation_id, markers_id),
2684         unique (markers_id)
2685     );
2686
2687     create table Representation_Marker_AUD (
2688         REV integer not null,
2689         Representation_id integer not null,
2690         markers_id integer not null,
2691         revtype tinyint,
2692         primary key (REV, Representation_id, markers_id)
2693     );
2694
2695     create table Rights (
2696         id integer not null,
2697         created timestamp,
2698         uuid varchar(36),
2699         updated timestamp,
2700         text longvarchar,
2701         abbreviatedtext varchar(255),
2702         uri varchar(255),
2703         createdby_id integer,
2704         updatedby_id integer,
2705         language_id integer,
2706         agent_id integer,
2707         type_id integer,
2708         primary key (id),
2709         unique (uuid)
2710     );
2711
2712     create table Rights_AUD (
2713         id integer not null,
2714         REV integer not null,
2715         revtype tinyint,
2716         created timestamp,
2717         uuid varchar(36),
2718         updated timestamp,
2719         text longvarchar,
2720         abbreviatedtext varchar(255),
2721         uri varchar(255),
2722         createdby_id integer,
2723         updatedby_id integer,
2724         language_id integer,
2725         agent_id integer,
2726         type_id integer,
2727         primary key (id, REV)
2728     );
2729
2730     create table Rights_Annotation (
2731         Rights_id integer not null,
2732         annotations_id integer not null,
2733         primary key (Rights_id, annotations_id),
2734         unique (annotations_id)
2735     );
2736
2737     create table Rights_Annotation_AUD (
2738         REV integer not null,
2739         Rights_id integer not null,
2740         annotations_id integer not null,
2741         revtype tinyint,
2742         primary key (REV, Rights_id, annotations_id)
2743     );
2744
2745     create table Rights_Marker (
2746         Rights_id integer not null,
2747         markers_id integer not null,
2748         primary key (Rights_id, markers_id),
2749         unique (markers_id)
2750     );
2751
2752     create table Rights_Marker_AUD (
2753         REV integer not null,
2754         Rights_id integer not null,
2755         markers_id integer not null,
2756         revtype tinyint,
2757         primary key (REV, Rights_id, markers_id)
2758     );
2759
2760     create table Sequence (
2761         id integer not null,
2762         created timestamp,
2763         uuid varchar(36),
2764         updated timestamp,
2765         lsid_authority varchar(255),
2766         lsid_lsid varchar(255),
2767         lsid_namespace varchar(255),
2768         lsid_object varchar(255),
2769         lsid_revision varchar(255),
2770         protectedtitlecache bit not null,
2771         titleCache varchar(255),
2772         barcode bit not null,
2773         citationmicroreference varchar(255),
2774         datesequenced date,
2775         length integer,
2776         sequence varchar(255),
2777         createdby_id integer,
2778         updatedby_id integer,
2779         locus_id integer,
2780         publishedin_id integer,
2781         primary key (id),
2782         unique (uuid)
2783     );
2784
2785     create table Sequence_AUD (
2786         id integer not null,
2787         REV integer not null,
2788         revtype tinyint,
2789         created timestamp,
2790         uuid varchar(36),
2791         updated timestamp,
2792         lsid_authority varchar(255),
2793         lsid_lsid varchar(255),
2794         lsid_namespace varchar(255),
2795         lsid_object varchar(255),
2796         lsid_revision varchar(255),
2797         protectedtitlecache bit,
2798         titleCache varchar(255),
2799         barcode bit,
2800         citationmicroreference varchar(255),
2801         datesequenced date,
2802         length integer,
2803         sequence varchar(255),
2804         createdby_id integer,
2805         updatedby_id integer,
2806         locus_id integer,
2807         publishedin_id integer,
2808         primary key (id, REV)
2809     );
2810
2811     create table Sequence_Annotation (
2812         Sequence_id integer not null,
2813         annotations_id integer not null,
2814         primary key (Sequence_id, annotations_id),
2815         unique (annotations_id)
2816     );
2817
2818     create table Sequence_Annotation_AUD (
2819         REV integer not null,
2820         Sequence_id integer not null,
2821         annotations_id integer not null,
2822         revtype tinyint,
2823         primary key (REV, Sequence_id, annotations_id)
2824     );
2825
2826     create table Sequence_Credit (
2827         Sequence_id integer not null,
2828         credits_id integer not null,
2829         sortIndex integer not null,
2830         primary key (Sequence_id, sortIndex),
2831         unique (credits_id)
2832     );
2833
2834     create table Sequence_Credit_AUD (
2835         REV integer not null,
2836         Sequence_id integer not null,
2837         credits_id integer not null,
2838         sortIndex integer not null,
2839         revtype tinyint,
2840         primary key (REV, Sequence_id, credits_id, sortIndex)
2841     );
2842
2843     create table Sequence_Extension (
2844         Sequence_id integer not null,
2845         extensions_id integer not null,
2846         primary key (Sequence_id, extensions_id),
2847         unique (extensions_id)
2848     );
2849
2850     create table Sequence_Extension_AUD (
2851         REV integer not null,
2852         Sequence_id integer not null,
2853         extensions_id integer not null,
2854         revtype tinyint,
2855         primary key (REV, Sequence_id, extensions_id)
2856     );
2857
2858     create table Sequence_GenBankAccession (
2859         Sequence_id integer not null,
2860         genbankaccession_id integer not null,
2861         primary key (Sequence_id, genbankaccession_id),
2862         unique (genbankaccession_id)
2863     );
2864
2865     create table Sequence_GenBankAccession_AUD (
2866         REV integer not null,
2867         Sequence_id integer not null,
2868         genbankaccession_id integer not null,
2869         revtype tinyint,
2870         primary key (REV, Sequence_id, genbankaccession_id)
2871     );
2872
2873     create table Sequence_Marker (
2874         Sequence_id integer not null,
2875         markers_id integer not null,
2876         primary key (Sequence_id, markers_id),
2877         unique (markers_id)
2878     );
2879
2880     create table Sequence_Marker_AUD (
2881         REV integer not null,
2882         Sequence_id integer not null,
2883         markers_id integer not null,
2884         revtype tinyint,
2885         primary key (REV, Sequence_id, markers_id)
2886     );
2887
2888     create table Sequence_Media (
2889         Sequence_id integer not null,
2890         chromatograms_id integer not null,
2891         primary key (Sequence_id, chromatograms_id),
2892         unique (chromatograms_id)
2893     );
2894
2895     create table Sequence_Media_AUD (
2896         REV integer not null,
2897         Sequence_id integer not null,
2898         chromatograms_id integer not null,
2899         revtype tinyint,
2900         primary key (REV, Sequence_id, chromatograms_id)
2901     );
2902
2903     create table Sequence_OriginalSource (
2904         Sequence_id integer not null,
2905         sources_id integer not null,
2906         primary key (Sequence_id, sources_id),
2907         unique (sources_id)
2908     );
2909
2910     create table Sequence_OriginalSource_AUD (
2911         REV integer not null,
2912         Sequence_id integer not null,
2913         sources_id integer not null,
2914         revtype tinyint,
2915         primary key (REV, Sequence_id, sources_id)
2916     );
2917
2918     create table Sequence_ReferenceBase (
2919         Sequence_id integer not null,
2920         citations_id integer not null,
2921         primary key (Sequence_id, citations_id),
2922         unique (citations_id)
2923     );
2924
2925     create table Sequence_ReferenceBase_AUD (
2926         REV integer not null,
2927         Sequence_id integer not null,
2928         citations_id integer not null,
2929         revtype tinyint,
2930         primary key (REV, Sequence_id, citations_id)
2931     );
2932
2933     create table Sequence_Rights (
2934         Sequence_id integer not null,
2935         rights_id integer not null,
2936         primary key (Sequence_id, rights_id),
2937         unique (rights_id)
2938     );
2939
2940     create table Sequence_Rights_AUD (
2941         REV integer not null,
2942         Sequence_id integer not null,
2943         rights_id integer not null,
2944         revtype tinyint,
2945         primary key (REV, Sequence_id, rights_id)
2946     );
2947
2948     create table SpecimenOrObservationBase (
2949         DTYPE varchar(31) not null,
2950         id integer not null,
2951         created timestamp,
2952         uuid varchar(36),
2953         updated timestamp,
2954         lsid_authority varchar(255),
2955         lsid_lsid varchar(255),
2956         lsid_namespace varchar(255),
2957         lsid_object varchar(255),
2958         lsid_revision varchar(255),
2959         protectedtitlecache bit not null,
2960         titleCache varchar(255),
2961         individualcount integer,
2962         accessionnumber varchar(255),
2963         catalognumber varchar(255),
2964         collectorsnumber varchar(255),
2965         fieldnotes varchar(255),
2966         fieldnumber varchar(255),
2967         createdby_id integer,
2968         updatedby_id integer,
2969         lifestage_id integer,
2970         sex_id integer,
2971         collection_id integer,
2972         derivationevent_id integer,
2973         storedunder_id integer,
2974         preservation_id integer,
2975         gatheringevent_id integer,
2976         primary key (id),
2977         unique (uuid)
2978     );
2979
2980     create table SpecimenOrObservationBase_AUD (
2981         DTYPE varchar(31) not null,
2982         id integer not null,
2983         REV integer not null,
2984         revtype tinyint,
2985         created timestamp,
2986         uuid varchar(36),
2987         updated timestamp,
2988         lsid_authority varchar(255),
2989         lsid_lsid varchar(255),
2990         lsid_namespace varchar(255),
2991         lsid_object varchar(255),
2992         lsid_revision varchar(255),
2993         protectedtitlecache bit,
2994         titleCache varchar(255),
2995         individualcount integer,
2996         createdby_id integer,
2997         updatedby_id integer,
2998         lifestage_id integer,
2999         sex_id integer,
3000         accessionnumber varchar(255),
3001         catalognumber varchar(255),
3002         collectorsnumber varchar(255),
3003         collection_id integer,
3004         derivationevent_id integer,
3005         storedunder_id integer,
3006         fieldnotes varchar(255),
3007         fieldnumber varchar(255),
3008         gatheringevent_id integer,
3009         preservation_id integer,
3010         primary key (id, REV)
3011     );
3012
3013     create table SpecimenOrObservationBase_Annotation (
3014         SpecimenOrObservationBase_id integer not null,
3015         annotations_id integer not null,
3016         primary key (SpecimenOrObservationBase_id, annotations_id),
3017         unique (annotations_id)
3018     );
3019
3020     create table SpecimenOrObservationBase_Annotation_AUD (
3021         REV integer not null,
3022         SpecimenOrObservationBase_id integer not null,
3023         annotations_id integer not null,
3024         revtype tinyint,
3025         primary key (REV, SpecimenOrObservationBase_id, annotations_id)
3026     );
3027
3028     create table SpecimenOrObservationBase_Credit (
3029         SpecimenOrObservationBase_id integer not null,
3030         credits_id integer not null,
3031         sortIndex integer not null,
3032         primary key (SpecimenOrObservationBase_id, sortIndex),
3033         unique (credits_id)
3034     );
3035
3036     create table SpecimenOrObservationBase_Credit_AUD (
3037         REV integer not null,
3038         SpecimenOrObservationBase_id integer not null,
3039         credits_id integer not null,
3040         sortIndex integer not null,
3041         revtype tinyint,
3042         primary key (REV, SpecimenOrObservationBase_id, credits_id, sortIndex)
3043     );
3044
3045     create table SpecimenOrObservationBase_DerivationEvent (
3046         originals_id integer not null,
3047         derivationevents_id integer not null,
3048         primary key (originals_id, derivationevents_id)
3049     );
3050
3051     create table SpecimenOrObservationBase_DerivationEvent_AUD (
3052         REV integer not null,
3053         originals_id integer not null,
3054         derivationevents_id integer not null,
3055         revtype tinyint,
3056         primary key (REV, originals_id, derivationevents_id)
3057     );
3058
3059     create table SpecimenOrObservationBase_Extension (
3060         SpecimenOrObservationBase_id integer not null,
3061         extensions_id integer not null,
3062         primary key (SpecimenOrObservationBase_id, extensions_id),
3063         unique (extensions_id)
3064     );
3065
3066     create table SpecimenOrObservationBase_Extension_AUD (
3067         REV integer not null,
3068         SpecimenOrObservationBase_id integer not null,
3069         extensions_id integer not null,
3070         revtype tinyint,
3071         primary key (REV, SpecimenOrObservationBase_id, extensions_id)
3072     );
3073
3074     create table SpecimenOrObservationBase_LanguageString (
3075         SpecimenOrObservationBase_id integer not null,
3076         description_id integer not null,
3077         description_mapkey_id integer not null,
3078         primary key (SpecimenOrObservationBase_id, description_mapkey_id),
3079         unique (description_id)
3080     );
3081
3082     create table SpecimenOrObservationBase_LanguageString_AUD (
3083         REV integer not null,
3084         SpecimenOrObservationBase_id integer not null,
3085         description_id integer not null,
3086         description_mapkey_id integer not null,
3087         revtype tinyint,
3088         primary key (REV, SpecimenOrObservationBase_id, description_id, description_mapkey_id)
3089     );
3090
3091     create table SpecimenOrObservationBase_Marker (
3092         SpecimenOrObservationBase_id integer not null,
3093         markers_id integer not null,
3094         primary key (SpecimenOrObservationBase_id, markers_id),
3095         unique (markers_id)
3096     );
3097
3098     create table SpecimenOrObservationBase_Marker_AUD (
3099         REV integer not null,
3100         SpecimenOrObservationBase_id integer not null,
3101         markers_id integer not null,
3102         revtype tinyint,
3103         primary key (REV, SpecimenOrObservationBase_id, markers_id)
3104     );
3105
3106     create table SpecimenOrObservationBase_Media (
3107         SpecimenOrObservationBase_id integer not null,
3108         media_id integer not null,
3109         primary key (SpecimenOrObservationBase_id, media_id)
3110     );
3111
3112     create table SpecimenOrObservationBase_Media_AUD (
3113         REV integer not null,
3114         SpecimenOrObservationBase_id integer not null,
3115         media_id integer not null,
3116         revtype tinyint,
3117         primary key (REV, SpecimenOrObservationBase_id, media_id)
3118     );
3119
3120     create table SpecimenOrObservationBase_OriginalSource (
3121         SpecimenOrObservationBase_id integer not null,
3122         sources_id integer not null,
3123         primary key (SpecimenOrObservationBase_id, sources_id),
3124         unique (sources_id)
3125     );
3126
3127     create table SpecimenOrObservationBase_OriginalSource_AUD (
3128         REV integer not null,
3129         SpecimenOrObservationBase_id integer not null,
3130         sources_id integer not null,
3131         revtype tinyint,
3132         primary key (REV, SpecimenOrObservationBase_id, sources_id)
3133     );
3134
3135     create table SpecimenOrObservationBase_Rights (
3136         SpecimenOrObservationBase_id integer not null,
3137         rights_id integer not null,
3138         primary key (SpecimenOrObservationBase_id, rights_id),
3139         unique (rights_id)
3140     );
3141
3142     create table SpecimenOrObservationBase_Rights_AUD (
3143         REV integer not null,
3144         SpecimenOrObservationBase_id integer not null,
3145         rights_id integer not null,
3146         revtype tinyint,
3147         primary key (REV, SpecimenOrObservationBase_id, rights_id)
3148     );
3149
3150     create table SpecimenOrObservationBase_Sequence (
3151         SpecimenOrObservationBase_id integer not null,
3152         sequences_id integer not null,
3153         primary key (SpecimenOrObservationBase_id, sequences_id),
3154         unique (sequences_id)
3155     );
3156
3157     create table SpecimenOrObservationBase_Sequence_AUD (
3158         REV integer not null,
3159         SpecimenOrObservationBase_id integer not null,
3160         sequences_id integer not null,
3161         revtype tinyint,
3162         primary key (REV, SpecimenOrObservationBase_id, sequences_id)
3163     );
3164
3165     create table StateData (
3166         id integer not null,
3167         created timestamp,
3168         uuid varchar(36),
3169         updated timestamp,
3170         createdby_id integer,
3171         updatedby_id integer,
3172         state_id integer,
3173         primary key (id),
3174         unique (uuid)
3175     );
3176
3177     create table StateData_AUD (
3178         id integer not null,
3179         REV integer not null,
3180         revtype tinyint,
3181         created timestamp,
3182         uuid varchar(36),
3183         updated timestamp,
3184         createdby_id integer,
3185         updatedby_id integer,
3186         state_id integer,
3187         primary key (id, REV)
3188     );
3189
3190     create table StateData_DefinedTermBase (
3191         StateData_id integer not null,
3192         modifiers_id integer not null,
3193         primary key (StateData_id, modifiers_id),
3194         unique (modifiers_id)
3195     );
3196
3197     create table StateData_DefinedTermBase_AUD (
3198         REV integer not null,
3199         StateData_id integer not null,
3200         modifiers_id integer not null,
3201         revtype tinyint,
3202         primary key (REV, StateData_id, modifiers_id)
3203     );
3204
3205     create table StateData_LanguageString (
3206         StateData_id integer not null,
3207         modifyingtext_id integer not null,
3208         modifyingtext_mapkey_id integer not null,
3209         primary key (StateData_id, modifyingtext_mapkey_id),
3210         unique (modifyingtext_id)
3211     );
3212
3213     create table StateData_LanguageString_AUD (
3214         REV integer not null,
3215         StateData_id integer not null,
3216         modifyingtext_id integer not null,
3217         modifyingtext_mapkey_id integer not null,
3218         revtype tinyint,
3219         primary key (REV, StateData_id, modifyingtext_id, modifyingtext_mapkey_id)
3220     );
3221
3222     create table StatisticalMeasurementValue (
3223         id integer not null,
3224         created timestamp,
3225         uuid varchar(36),
3226         updated timestamp,
3227         value float not null,
3228         createdby_id integer,
3229         updatedby_id integer,
3230         type_id integer,
3231         primary key (id),
3232         unique (uuid)
3233     );
3234
3235     create table StatisticalMeasurementValue_AUD (
3236         id integer not null,
3237         REV integer not null,
3238         revtype tinyint,
3239         created timestamp,
3240         uuid varchar(36),
3241         updated timestamp,
3242         value float,
3243         createdby_id integer,
3244         updatedby_id integer,
3245         type_id integer,
3246         primary key (id, REV)
3247     );
3248
3249     create table StatisticalMeasurementValue_DefinedTermBase (
3250         StatisticalMeasurementValue_id integer not null,
3251         modifiers_id integer not null,
3252         primary key (StatisticalMeasurementValue_id, modifiers_id),
3253         unique (modifiers_id)
3254     );
3255
3256     create table StatisticalMeasurementValue_DefinedTermBase_AUD (
3257         REV integer not null,
3258         StatisticalMeasurementValue_id integer not null,
3259         modifiers_id integer not null,
3260         revtype tinyint,
3261         primary key (REV, StatisticalMeasurementValue_id, modifiers_id)
3262     );
3263
3264     create table SynonymRelationship (
3265         id integer not null,
3266         created timestamp,
3267         uuid varchar(36),
3268         updated timestamp,
3269         citationmicroreference varchar(255),
3270         originalnamestring varchar(255),
3271         doubtful bit not null,
3272         partial bit not null,
3273         proparte bit not null,
3274         createdby_id integer,
3275         updatedby_id integer,
3276         citation_id integer,
3277         relatedfrom_id integer,
3278         relatedto_id integer,
3279         type_id integer,
3280         primary key (id),
3281         unique (uuid)
3282     );
3283
3284     create table SynonymRelationship_AUD (
3285         id integer not null,
3286         REV integer not null,
3287         revtype tinyint,
3288         created timestamp,
3289         uuid varchar(36),
3290         updated timestamp,
3291         citationmicroreference varchar(255),
3292         originalnamestring varchar(255),
3293         doubtful bit,
3294         partial bit,
3295         proparte bit,
3296         createdby_id integer,
3297         updatedby_id integer,
3298         citation_id integer,
3299         relatedfrom_id integer,
3300         relatedto_id integer,
3301         type_id integer,
3302         primary key (id, REV)
3303     );
3304
3305     create table SynonymRelationship_Annotation (
3306         SynonymRelationship_id integer not null,
3307         annotations_id integer not null,
3308         primary key (SynonymRelationship_id, annotations_id),
3309         unique (annotations_id)
3310     );
3311
3312     create table SynonymRelationship_Annotation_AUD (
3313         REV integer not null,
3314         SynonymRelationship_id integer not null,
3315         annotations_id integer not null,
3316         revtype tinyint,
3317         primary key (REV, SynonymRelationship_id, annotations_id)
3318     );
3319
3320     create table SynonymRelationship_Marker (
3321         SynonymRelationship_id integer not null,
3322         markers_id integer not null,
3323         primary key (SynonymRelationship_id, markers_id),
3324         unique (markers_id)
3325     );
3326
3327     create table SynonymRelationship_Marker_AUD (
3328         REV integer not null,
3329         SynonymRelationship_id integer not null,
3330         markers_id integer not null,
3331         revtype tinyint,
3332         primary key (REV, SynonymRelationship_id, markers_id)
3333     );
3334
3335     create table TaxonBase (
3336         DTYPE varchar(31) not null,
3337         id integer not null,
3338         created timestamp,
3339         uuid varchar(36),
3340         updated timestamp,
3341         lsid_authority varchar(255),
3342         lsid_lsid varchar(255),
3343         lsid_namespace varchar(255),
3344         lsid_object varchar(255),
3345         lsid_revision varchar(255),
3346         protectedtitlecache bit not null,
3347         titleCache varchar(255),
3348         doubtful bit not null,
3349         taxonstatusunknown bit,
3350         taxonomicchildrencount integer,
3351         createdby_id integer,
3352         updatedby_id integer,
3353         taxonName_fk integer,
3354         sec_id integer,
3355         taxonomicparentcache_id integer,
3356         primary key (id),
3357         unique (uuid)
3358     );
3359
3360     create table TaxonBase_AUD (
3361         DTYPE varchar(31) not null,
3362         id integer not null,
3363         REV integer not null,
3364         revtype tinyint,
3365         created timestamp,
3366         uuid varchar(36),
3367         updated timestamp,
3368         lsid_authority varchar(255),
3369         lsid_lsid varchar(255),
3370         lsid_namespace varchar(255),
3371         lsid_object varchar(255),
3372         lsid_revision varchar(255),
3373         protectedtitlecache bit,
3374         titleCache varchar(255),
3375         doubtful bit,
3376         createdby_id integer,
3377         updatedby_id integer,
3378         taxonName_fk integer,
3379         sec_id integer,
3380         taxonstatusunknown bit,
3381         taxonomicchildrencount integer,
3382         taxonomicparentcache_id integer,
3383         primary key (id, REV)
3384     );
3385
3386     create table TaxonBase_Annotation (
3387         TaxonBase_id integer not null,
3388         annotations_id integer not null,
3389         primary key (TaxonBase_id, annotations_id),
3390         unique (annotations_id)
3391     );
3392
3393     create table TaxonBase_Annotation_AUD (
3394         REV integer not null,
3395         TaxonBase_id integer not null,
3396         annotations_id integer not null,
3397         revtype tinyint,
3398         primary key (REV, TaxonBase_id, annotations_id)
3399     );
3400
3401     create table TaxonBase_Credit (
3402         TaxonBase_id integer not null,
3403         credits_id integer not null,
3404         sortIndex integer not null,
3405         primary key (TaxonBase_id, sortIndex),
3406         unique (credits_id)
3407     );
3408
3409     create table TaxonBase_Credit_AUD (
3410         REV integer not null,
3411         TaxonBase_id integer not null,
3412         credits_id integer not null,
3413         sortIndex integer not null,
3414         revtype tinyint,
3415         primary key (REV, TaxonBase_id, credits_id, sortIndex)
3416     );
3417
3418     create table TaxonBase_Extension (
3419         TaxonBase_id integer not null,
3420         extensions_id integer not null,
3421         primary key (TaxonBase_id, extensions_id),
3422         unique (extensions_id)
3423     );
3424
3425     create table TaxonBase_Extension_AUD (
3426         REV integer not null,
3427         TaxonBase_id integer not null,
3428         extensions_id integer not null,
3429         revtype tinyint,
3430         primary key (REV, TaxonBase_id, extensions_id)
3431     );
3432
3433     create table TaxonBase_Marker (
3434         TaxonBase_id integer not null,
3435         markers_id integer not null,
3436         primary key (TaxonBase_id, markers_id),
3437         unique (markers_id)
3438     );
3439
3440     create table TaxonBase_Marker_AUD (
3441         REV integer not null,
3442         TaxonBase_id integer not null,
3443         markers_id integer not null,
3444         revtype tinyint,
3445         primary key (REV, TaxonBase_id, markers_id)
3446     );
3447
3448     create table TaxonBase_OriginalSource (
3449         TaxonBase_id integer not null,
3450         sources_id integer not null,
3451         primary key (TaxonBase_id, sources_id),
3452         unique (sources_id)
3453     );
3454
3455     create table TaxonBase_OriginalSource_AUD (
3456         REV integer not null,
3457         TaxonBase_id integer not null,
3458         sources_id integer not null,
3459         revtype tinyint,
3460         primary key (REV, TaxonBase_id, sources_id)
3461     );
3462
3463     create table TaxonBase_Rights (
3464         TaxonBase_id integer not null,
3465         rights_id integer not null,
3466         primary key (TaxonBase_id, rights_id),
3467         unique (rights_id)
3468     );
3469
3470     create table TaxonBase_Rights_AUD (
3471         REV integer not null,
3472         TaxonBase_id integer not null,
3473         rights_id integer not null,
3474         revtype tinyint,
3475         primary key (REV, TaxonBase_id, rights_id)
3476     );
3477
3478     create table TaxonInteraction_LanguageString (
3479         DescriptionElementBase_id integer not null,
3480         description_id integer not null,
3481         description_mapkey_id integer not null,
3482         primary key (DescriptionElementBase_id, description_mapkey_id),
3483         unique (description_id)
3484     );
3485
3486     create table TaxonInteraction_LanguageString_AUD (
3487         REV integer not null,
3488         DescriptionElementBase_id integer not null,
3489         description_id integer not null,
3490         description_mapkey_id integer not null,
3491         revtype tinyint,
3492         primary key (REV, DescriptionElementBase_id, description_id, description_mapkey_id)
3493     );
3494
3495     create table TaxonNameBase (
3496         DTYPE varchar(31) not null,
3497         id integer not null,
3498         created timestamp,
3499         uuid varchar(36),
3500         updated timestamp,
3501         lsid_authority varchar(255),
3502         lsid_lsid varchar(255),
3503         lsid_namespace varchar(255),
3504         lsid_object varchar(255),
3505         lsid_revision varchar(255),
3506         protectedtitlecache bit not null,
3507         titleCache varchar(255),
3508         appendedphrase varchar(255),
3509         fullTitleCache varchar(330),
3510         hasproblem bit not null,
3511         nomenclaturalmicroreference varchar(255),
3512         problemends integer not null,
3513         problemstarts integer not null,
3514         protectedfulltitlecache bit not null,
3515         authorshipcache varchar(255),
3516         genusoruninomial varchar(255),
3517         infragenericepithet varchar(255),
3518         infraspecificepithet varchar(255),
3519         namecache varchar(255),
3520         protectedauthorshipcache bit,
3521         protectednamecache bit,
3522         specificepithet varchar(255),
3523         nameapprobation varchar(255),
3524         subgenusauthorship varchar(255),
3525         anamorphic bit,
3526         binomhybrid bit,
3527         hybridformula bit,
3528         monomhybrid bit,
3529         trinomhybrid bit,
3530         cultivarname varchar(255),
3531         acronym varchar(255),
3532         breed varchar(255),
3533         originalpublicationyear integer,
3534         publicationyear integer,
3535         createdby_id integer,
3536         updatedby_id integer,
3537         homotypicalgroup_id integer,
3538         nomenclaturalreference_id integer,
3539         rank_id integer,
3540         basionymauthorteam_id integer,
3541         combinationauthorteam_id integer,
3542         exbasionymauthorteam_id integer,
3543         excombinationauthorteam_id integer,
3544         primary key (id),
3545         unique (uuid)
3546     );
3547
3548     create table TaxonNameBase_AUD (
3549         DTYPE varchar(31) not null,
3550         id integer not null,
3551         REV integer not null,
3552         revtype tinyint,
3553         created timestamp,
3554         uuid varchar(36),
3555         updated timestamp,
3556         lsid_authority varchar(255),
3557         lsid_lsid varchar(255),
3558         lsid_namespace varchar(255),
3559         lsid_object varchar(255),
3560         lsid_revision varchar(255),
3561         protectedtitlecache bit,
3562         titleCache varchar(255),
3563         appendedphrase varchar(255),
3564         fullTitleCache varchar(330),
3565         hasproblem bit,
3566         nomenclaturalmicroreference varchar(255),
3567         problemends integer,
3568         problemstarts integer,
3569         protectedfulltitlecache bit,
3570         createdby_id integer,
3571         updatedby_id integer,
3572         homotypicalgroup_id integer,
3573         nomenclaturalreference_id integer,
3574         rank_id integer,
3575         acronym varchar(255),
3576         authorshipcache varchar(255),
3577         genusoruninomial varchar(255),
3578         infragenericepithet varchar(255),
3579         infraspecificepithet varchar(255),
3580         namecache varchar(255),
3581         protectedauthorshipcache bit,
3582         protectednamecache bit,
3583         specificepithet varchar(255),
3584         basionymauthorteam_id integer,
3585         combinationauthorteam_id integer,
3586         exbasionymauthorteam_id integer,
3587         excombinationauthorteam_id integer,
3588         breed varchar(255),
3589         originalpublicationyear integer,
3590         publicationyear integer,
3591         anamorphic bit,
3592         binomhybrid bit,
3593         hybridformula bit,
3594         monomhybrid bit,
3595         trinomhybrid bit,
3596         cultivarname varchar(255),
3597         nameapprobation varchar(255),
3598         subgenusauthorship varchar(255),
3599         primary key (id, REV)
3600     );
3601
3602     create table TaxonNameBase_Annotation (
3603         TaxonNameBase_id integer not null,
3604         annotations_id integer not null,
3605         primary key (TaxonNameBase_id, annotations_id),
3606         unique (annotations_id)
3607     );
3608
3609     create table TaxonNameBase_Annotation_AUD (
3610         REV integer not null,
3611         TaxonNameBase_id integer not null,
3612         annotations_id integer not null,
3613         revtype tinyint,
3614         primary key (REV, TaxonNameBase_id, annotations_id)
3615     );
3616
3617     create table TaxonNameBase_Credit (
3618         TaxonNameBase_id integer not null,
3619         credits_id integer not null,
3620         sortIndex integer not null,
3621         primary key (TaxonNameBase_id, sortIndex),
3622         unique (credits_id)
3623     );
3624
3625     create table TaxonNameBase_Credit_AUD (
3626         REV integer not null,
3627         TaxonNameBase_id integer not null,
3628         credits_id integer not null,
3629         sortIndex integer not null,
3630         revtype tinyint,
3631         primary key (REV, TaxonNameBase_id, credits_id, sortIndex)
3632     );
3633
3634     create table TaxonNameBase_Extension (
3635         TaxonNameBase_id integer not null,
3636         extensions_id integer not null,
3637         primary key (TaxonNameBase_id, extensions_id),
3638         unique (extensions_id)
3639     );
3640
3641     create table TaxonNameBase_Extension_AUD (
3642         REV integer not null,
3643         TaxonNameBase_id integer not null,
3644         extensions_id integer not null,
3645         revtype tinyint,
3646         primary key (REV, TaxonNameBase_id, extensions_id)
3647     );
3648
3649     create table TaxonNameBase_HybridRelationship (
3650         TaxonNameBase_id integer not null,
3651         hybridrelationships_id integer not null,
3652         primary key (TaxonNameBase_id, hybridrelationships_id),
3653         unique (hybridrelationships_id)
3654     );
3655
3656     create table TaxonNameBase_HybridRelationship_AUD (
3657         REV integer not null,
3658         TaxonNameBase_id integer not null,
3659         hybridrelationships_id integer not null,
3660         revtype tinyint,
3661         primary key (REV, TaxonNameBase_id, hybridrelationships_id)
3662     );
3663
3664     create table TaxonNameBase_Marker (
3665         TaxonNameBase_id integer not null,
3666         markers_id integer not null,
3667         primary key (TaxonNameBase_id, markers_id),
3668         unique (markers_id)
3669     );
3670
3671     create table TaxonNameBase_Marker_AUD (
3672         REV integer not null,
3673         TaxonNameBase_id integer not null,
3674         markers_id integer not null,
3675         revtype tinyint,
3676         primary key (REV, TaxonNameBase_id, markers_id)
3677     );
3678
3679     create table TaxonNameBase_NomenclaturalStatus (
3680         TaxonNameBase_id integer not null,
3681         status_id integer not null,
3682         primary key (TaxonNameBase_id, status_id),
3683         unique (status_id)
3684     );
3685
3686     create table TaxonNameBase_NomenclaturalStatus_AUD (
3687         REV integer not null,
3688         TaxonNameBase_id integer not null,
3689         status_id integer not null,
3690         revtype tinyint,
3691         primary key (REV, TaxonNameBase_id, status_id)
3692     );
3693
3694     create table TaxonNameBase_OriginalSource (
3695         TaxonNameBase_id integer not null,
3696         sources_id integer not null,
3697         primary key (TaxonNameBase_id, sources_id),
3698         unique (sources_id)
3699     );
3700
3701     create table TaxonNameBase_OriginalSource_AUD (
3702         REV integer not null,
3703         TaxonNameBase_id integer not null,
3704         sources_id integer not null,
3705         revtype tinyint,
3706         primary key (REV, TaxonNameBase_id, sources_id)
3707     );
3708
3709     create table TaxonNameBase_Rights (
3710         TaxonNameBase_id integer not null,
3711         rights_id integer not null,
3712         primary key (TaxonNameBase_id, rights_id),
3713         unique (rights_id)
3714     );
3715
3716     create table TaxonNameBase_Rights_AUD (
3717         REV integer not null,
3718         TaxonNameBase_id integer not null,
3719         rights_id integer not null,
3720         revtype tinyint,
3721         primary key (REV, TaxonNameBase_id, rights_id)
3722     );
3723
3724     create table TaxonNameBase_TypeDesignationBase (
3725         TaxonNameBase_id integer not null,
3726         typedesignations_id integer not null,
3727         primary key (TaxonNameBase_id, typedesignations_id)
3728     );
3729
3730     create table TaxonNameBase_TypeDesignationBase_AUD (
3731         REV integer not null,
3732         TaxonNameBase_id integer not null,
3733         typedesignations_id integer not null,
3734         revtype tinyint,
3735         primary key (REV, TaxonNameBase_id, typedesignations_id)
3736     );
3737
3738     create table TaxonNode (
3739         id integer not null,
3740         created timestamp,
3741         uuid varchar(36),
3742         updated timestamp,
3743         countchildren integer not null,
3744         microreferenceforparentchildrelation varchar(255),
3745         createdby_id integer,
3746         updatedby_id integer,
3747         parent_id integer,
3748         referenceforparentchildrelation_id integer,
3749         synonymtobeused_id integer,
3750         taxon_id integer,
3751         taxonomictree_id integer,
3752         primary key (id),
3753         unique (uuid)
3754     );
3755
3756     create table TaxonNode_AUD (
3757         id integer not null,
3758         REV integer not null,
3759         revtype tinyint,
3760         created timestamp,
3761         uuid varchar(36),
3762         updated timestamp,
3763         countchildren integer,
3764         microreferenceforparentchildrelation varchar(255),
3765         createdby_id integer,
3766         updatedby_id integer,
3767         parent_id integer,
3768         referenceforparentchildrelation_id integer,
3769         synonymtobeused_id integer,
3770         taxon_id integer,
3771         taxonomictree_id integer,
3772         primary key (id, REV)
3773     );
3774
3775     create table TaxonNode_Annotation (
3776         TaxonNode_id integer not null,
3777         annotations_id integer not null,
3778         primary key (TaxonNode_id, annotations_id),
3779         unique (annotations_id)
3780     );
3781
3782     create table TaxonNode_Annotation_AUD (
3783         REV integer not null,
3784         TaxonNode_id integer not null,
3785         annotations_id integer not null,
3786         revtype tinyint,
3787         primary key (REV, TaxonNode_id, annotations_id)
3788     );
3789
3790     create table TaxonNode_Marker (
3791         TaxonNode_id integer not null,
3792         markers_id integer not null,
3793         primary key (TaxonNode_id, markers_id),
3794         unique (markers_id)
3795     );
3796
3797     create table TaxonNode_Marker_AUD (
3798         REV integer not null,
3799         TaxonNode_id integer not null,
3800         markers_id integer not null,
3801         revtype tinyint,
3802         primary key (REV, TaxonNode_id, markers_id)
3803     );
3804
3805     create table TaxonRelationship (
3806         id integer not null,
3807         created timestamp,
3808         uuid varchar(36),
3809         updated timestamp,
3810         citationmicroreference varchar(255),
3811         originalnamestring varchar(255),
3812         doubtful bit not null,
3813         createdby_id integer,
3814         updatedby_id integer,
3815         citation_id integer,
3816         relatedfrom_id integer,
3817         relatedto_id integer,
3818         type_id integer,
3819         primary key (id),
3820         unique (uuid)
3821     );
3822
3823     create table TaxonRelationship_AUD (
3824         id integer not null,
3825         REV integer not null,
3826         revtype tinyint,
3827         created timestamp,
3828         uuid varchar(36),
3829         updated timestamp,
3830         citationmicroreference varchar(255),
3831         originalnamestring varchar(255),
3832         doubtful bit,
3833         createdby_id integer,
3834         updatedby_id integer,
3835         citation_id integer,
3836         relatedfrom_id integer,
3837         relatedto_id integer,
3838         type_id integer,
3839         primary key (id, REV)
3840     );
3841
3842     create table TaxonRelationship_Annotation (
3843         TaxonRelationship_id integer not null,
3844         annotations_id integer not null,
3845         primary key (TaxonRelationship_id, annotations_id),
3846         unique (annotations_id)
3847     );
3848
3849     create table TaxonRelationship_Annotation_AUD (
3850         REV integer not null,
3851         TaxonRelationship_id integer not null,
3852         annotations_id integer not null,
3853         revtype tinyint,
3854         primary key (REV, TaxonRelationship_id, annotations_id)
3855     );
3856
3857     create table TaxonRelationship_Marker (
3858         TaxonRelationship_id integer not null,
3859         markers_id integer not null,
3860         primary key (TaxonRelationship_id, markers_id),
3861         unique (markers_id)
3862     );
3863
3864     create table TaxonRelationship_Marker_AUD (
3865         REV integer not null,
3866         TaxonRelationship_id integer not null,
3867         markers_id integer not null,
3868         revtype tinyint,
3869         primary key (REV, TaxonRelationship_id, markers_id)
3870     );
3871
3872     create table TaxonomicTree (
3873         id integer not null,
3874         created timestamp,
3875         uuid varchar(36),
3876         updated timestamp,
3877         lsid_authority varchar(255),
3878         lsid_lsid varchar(255),
3879         lsid_namespace varchar(255),
3880         lsid_object varchar(255),
3881         lsid_revision varchar(255),
3882         protectedtitlecache bit not null,
3883         titleCache varchar(255),
3884         microreference varchar(255),
3885         createdby_id integer,
3886         updatedby_id integer,
3887         name_id integer,
3888         reference_id integer,
3889         primary key (id),
3890         unique (uuid)
3891     );
3892
3893     create table TaxonomicTree_AUD (
3894         id integer not null,
3895         REV integer not null,
3896         revtype tinyint,
3897         created timestamp,
3898         uuid varchar(36),
3899         updated timestamp,
3900         lsid_authority varchar(255),
3901         lsid_lsid varchar(255),
3902         lsid_namespace varchar(255),
3903         lsid_object varchar(255),
3904         lsid_revision varchar(255),
3905         protectedtitlecache bit,
3906         titleCache varchar(255),
3907         microreference varchar(255),
3908         createdby_id integer,
3909         updatedby_id integer,
3910         name_id integer,
3911         reference_id integer,
3912         primary key (id, REV)
3913     );
3914
3915     create table TaxonomicTree_Annotation (
3916         taxonomictree_id integer not null,
3917         annotations_id integer not null,
3918         primary key (taxonomictree_id, annotations_id),
3919         unique (annotations_id)
3920     );
3921
3922     create table TaxonomicTree_Annotation_AUD (
3923         REV integer not null,
3924         taxonomictree_id integer not null,
3925         annotations_id integer not null,
3926         revtype tinyint,
3927         primary key (REV, taxonomictree_id, annotations_id)
3928     );
3929
3930     create table TaxonomicTree_Credit (
3931         taxonomictree_id integer not null,
3932         credits_id integer not null,
3933         sortIndex integer not null,
3934         primary key (taxonomictree_id, sortIndex),
3935         unique (credits_id)
3936     );
3937
3938     create table TaxonomicTree_Credit_AUD (
3939         REV integer not null,
3940         taxonomictree_id integer not null,
3941         credits_id integer not null,
3942         sortIndex integer not null,
3943         revtype tinyint,
3944         primary key (REV, taxonomictree_id, credits_id, sortIndex)
3945     );
3946
3947     create table TaxonomicTree_Extension (
3948         taxonomictree_id integer not null,
3949         extensions_id integer not null,
3950         primary key (taxonomictree_id, extensions_id),
3951         unique (extensions_id)
3952     );
3953
3954     create table TaxonomicTree_Extension_AUD (
3955         REV integer not null,
3956         taxonomictree_id integer not null,
3957         extensions_id integer not null,
3958         revtype tinyint,
3959         primary key (REV, taxonomictree_id, extensions_id)
3960     );
3961
3962     create table TaxonomicTree_Marker (
3963         taxonomictree_id integer not null,
3964         markers_id integer not null,
3965         primary key (taxonomictree_id, markers_id),
3966         unique (markers_id)
3967     );
3968
3969     create table TaxonomicTree_Marker_AUD (
3970         REV integer not null,
3971         taxonomictree_id integer not null,
3972         markers_id integer not null,
3973         revtype tinyint,
3974         primary key (REV, taxonomictree_id, markers_id)
3975     );
3976
3977     create table TaxonomicTree_OriginalSource (
3978         taxonomictree_id integer not null,
3979         sources_id integer not null,
3980         primary key (taxonomictree_id, sources_id),
3981         unique (sources_id)
3982     );
3983
3984     create table TaxonomicTree_OriginalSource_AUD (
3985         REV integer not null,
3986         taxonomictree_id integer not null,
3987         sources_id integer not null,
3988         revtype tinyint,
3989         primary key (REV, taxonomictree_id, sources_id)
3990     );
3991
3992     create table TaxonomicTree_Rights (
3993         taxonomictree_id integer not null,
3994         rights_id integer not null,
3995         primary key (taxonomictree_id, rights_id),
3996         unique (rights_id)
3997     );
3998
3999     create table TaxonomicTree_Rights_AUD (
4000         REV integer not null,
4001         taxonomictree_id integer not null,
4002         rights_id integer not null,
4003         revtype tinyint,
4004         primary key (REV, taxonomictree_id, rights_id)
4005     );
4006
4007     create table TaxonomicTree_TaxonNode (
4008         taxonomictree_id integer not null,
4009         rootnodes_id integer not null,
4010         primary key (taxonomictree_id, rootnodes_id),
4011         unique (rootnodes_id)
4012     );
4013
4014     create table TaxonomicTree_TaxonNode_AUD (
4015         REV integer not null,
4016         taxonomictree_id integer not null,
4017         rootnodes_id integer not null,
4018         revtype tinyint,
4019         primary key (REV, taxonomictree_id, rootnodes_id)
4020     );
4021
4022     create table TermVocabulary (
4023         DTYPE varchar(31) not null,
4024         id integer not null,
4025         created timestamp,
4026         uuid varchar(36),
4027         updated timestamp,
4028         uri varchar(255),
4029         termsourceuri varchar(255),
4030         createdby_id integer,
4031         updatedby_id integer,
4032         primary key (id),
4033         unique (uuid)
4034     );
4035
4036     create table TermVocabulary_AUD (
4037         DTYPE varchar(31) not null,
4038         id integer not null,
4039         REV integer not null,
4040         revtype tinyint,
4041         created timestamp,
4042         uuid varchar(36),
4043         updated timestamp,
4044         uri varchar(255),
4045         termsourceuri varchar(255),
4046         createdby_id integer,
4047         updatedby_id integer,
4048         primary key (id, REV)
4049     );
4050
4051     create table TermVocabulary_Representation (
4052         TermVocabulary_id integer not null,
4053         representations_id integer not null,
4054         primary key (TermVocabulary_id, representations_id),
4055         unique (representations_id)
4056     );
4057
4058     create table TermVocabulary_Representation_AUD (
4059         REV integer not null,
4060         TermVocabulary_id integer not null,
4061         representations_id integer not null,
4062         revtype tinyint,
4063         primary key (REV, TermVocabulary_id, representations_id)
4064     );
4065
4066     create table TypeDesignationBase (
4067         DTYPE varchar(31) not null,
4068         id integer not null,
4069         created timestamp,
4070         uuid varchar(36),
4071         updated timestamp,
4072         citationmicroreference varchar(255),
4073         originalnamestring varchar(255),
4074         notdesignated bit not null,
4075         conservedtype bit,
4076         lectotype bit,
4077         rejectedtype bit,
4078         createdby_id integer,
4079         updatedby_id integer,
4080         citation_id integer,
4081         homotypicalgroup_id integer,
4082         typestatus_id integer,
4083         typename_id integer,
4084         typespecimen_id integer,
4085         primary key (id),
4086         unique (uuid)
4087     );
4088
4089     create table TypeDesignationBase_AUD (
4090         DTYPE varchar(31) not null,
4091         id integer not null,
4092         REV integer not null,
4093         revtype tinyint,
4094         created timestamp,
4095         uuid varchar(36),
4096         updated timestamp,
4097         citationmicroreference varchar(255),
4098         originalnamestring varchar(255),
4099         notdesignated bit,
4100         createdby_id integer,
4101         updatedby_id integer,
4102         citation_id integer,
4103         homotypicalgroup_id integer,
4104         typestatus_id integer,
4105         conservedtype bit,
4106         lectotype bit,
4107         rejectedtype bit,
4108         typename_id integer,
4109         typespecimen_id integer,
4110         primary key (id, REV)
4111     );
4112
4113     create table TypeDesignationBase_Annotation (
4114         TypeDesignationBase_id integer not null,
4115         annotations_id integer not null,
4116         primary key (TypeDesignationBase_id, annotations_id),
4117         unique (annotations_id)
4118     );
4119
4120     create table TypeDesignationBase_Annotation_AUD (
4121         REV integer not null,
4122         TypeDesignationBase_id integer not null,
4123         annotations_id integer not null,
4124         revtype tinyint,
4125         primary key (REV, TypeDesignationBase_id, annotations_id)
4126     );
4127
4128     create table TypeDesignationBase_Marker (
4129         TypeDesignationBase_id integer not null,
4130         markers_id integer not null,
4131         primary key (TypeDesignationBase_id, markers_id),
4132         unique (markers_id)
4133     );
4134
4135     create table TypeDesignationBase_Marker_AUD (
4136         REV integer not null,
4137         TypeDesignationBase_id integer not null,
4138         markers_id integer not null,
4139         revtype tinyint,
4140         primary key (REV, TypeDesignationBase_id, markers_id)
4141     );
4142
4143     create table TypeDesignationBase_TaxonNameBase (
4144         TypeDesignationBase_id integer not null,
4145         typifiednames_id integer not null,
4146         primary key (TypeDesignationBase_id, typifiednames_id)
4147     );
4148
4149     create table TypeDesignationBase_TaxonNameBase_AUD (
4150         REV integer not null,
4151         TypeDesignationBase_id integer not null,
4152         typifiednames_id integer not null,
4153         revtype tinyint,
4154         primary key (REV, TypeDesignationBase_id, typifiednames_id)
4155     );
4156
4157     create table UserAccount (
4158         id integer not null,
4159         created timestamp,
4160         uuid varchar(36),
4161         accountnonexpired bit not null,
4162         accountnonlocked bit not null,
4163         credentialsnonexpired bit not null,
4164         emailaddress varchar(255),
4165         enabled bit not null,
4166         password varchar(255),
4167         username varchar(255),
4168         createdby_id integer,
4169         person_id integer,
4170         primary key (id),
4171         unique (uuid, username)
4172     );
4173
4174     create table UserAccount_AUD (
4175         id integer not null,
4176         REV integer not null,
4177         revtype tinyint,
4178         created timestamp,
4179         uuid varchar(36),
4180         accountnonexpired bit,
4181         accountnonlocked bit,
4182         credentialsnonexpired bit,
4183         emailaddress varchar(255),
4184         enabled bit,
4185         username varchar(255),
4186         createdby_id integer,
4187         person_id integer,
4188         primary key (id, REV)
4189     );
4190
4191     create table UserAccount_GrantedAuthorityImpl (
4192         UserAccount_id integer not null,
4193         grantedauthorities_id integer not null,
4194         primary key (UserAccount_id, grantedauthorities_id)
4195     );
4196
4197     create table UserAccount_PermissionGroup (
4198         members_id integer not null,
4199         groups_id integer not null,
4200         primary key (members_id, groups_id)
4201     );
4202
4203     alter table Address
4204         add constraint FK1ED033D4132A2FE8
4205         foreign key (location_referencesystem_id)
4206         references DefinedTermBase;
4207
4208     alter table Address
4209         add constraint FK1ED033D44FF2DB2C
4210         foreign key (createdby_id)
4211         references UserAccount;
4212
4213     alter table Address
4214         add constraint FK1ED033D42687715A
4215         foreign key (country_id)
4216         references DefinedTermBase;
4217
4218     alter table Address
4219         add constraint FK1ED033D4BC5DA539
4220         foreign key (updatedby_id)
4221         references UserAccount;
4222
4223     alter table Address_AUD
4224         add constraint FK115657A534869AAE
4225         foreign key (REV)
4226         references AuditEvent;
4227
4228     create index agentTitleCacheIndex on AgentBase (titleCache);
4229
4230     alter table AgentBase
4231         add constraint FK1205D3564FF2DB2C
4232         foreign key (createdby_id)
4233         references UserAccount;
4234
4235     alter table AgentBase
4236         add constraint FK1205D356A830578
4237         foreign key (ispartof_id)
4238         references AgentBase;
4239
4240     alter table AgentBase
4241         add constraint FK1205D356BC5DA539
4242         foreign key (updatedby_id)
4243         references UserAccount;
4244
4245     alter table AgentBase_AUD
4246         add constraint FK29CC662734869AAE
4247         foreign key (REV)
4248         references AuditEvent;
4249
4250     alter table AgentBase_Address
4251         add constraint FK1EDFF7EB50751EC5
4252         foreign key (contact_addresses_id)
4253         references Address;
4254
4255     alter table AgentBase_Address
4256         add constraint FK1EDFF7EB86EFC5D4
4257         foreign key (AgentBase_id)
4258         references AgentBase;
4259
4260     alter table AgentBase_Address_AUD
4261         add constraint FK3D28383C34869AAE
4262         foreign key (REV)
4263         references AuditEvent;
4264
4265     alter table AgentBase_AgentBase
4266         add constraint FK4D34EDAD1C0E9907
4267         foreign key (AgentBase_id)
4268         references AgentBase;
4269
4270     alter table AgentBase_AgentBase
4271         add constraint FK4D34EDADE9E535F9
4272         foreign key (teammembers_id)
4273         references AgentBase;
4274
4275     alter table AgentBase_AgentBase_AUD
4276         add constraint FKA8A87CFE34869AAE
4277         foreign key (REV)
4278         references AuditEvent;
4279
4280     alter table AgentBase_Annotation
4281         add constraint FK44D5F7D886EFC5D4
4282         foreign key (AgentBase_id)
4283         references AgentBase;
4284
4285     alter table AgentBase_Annotation
4286         add constraint FK44D5F7D81E403E0B
4287         foreign key (annotations_id)
4288         references Annotation;
4289
4290     alter table AgentBase_Annotation_AUD
4291         add constraint FK771279A934869AAE
4292         foreign key (REV)
4293         references AuditEvent;
4294
4295     alter table AgentBase_Credit
4296         add constraint FK2636742286EFC5D4
4297         foreign key (AgentBase_id)
4298         references AgentBase;
4299
4300     alter table AgentBase_Credit
4301         add constraint FK2636742232D1B9F
4302         foreign key (credits_id)
4303         references Credit;
4304
4305     alter table AgentBase_Credit_AUD
4306         add constraint FK7FE7C0F334869AAE
4307         foreign key (REV)
4308         references AuditEvent;
4309
4310     alter table AgentBase_DefinedTermBase
4311         add constraint FK6665C77D9A161BED
4312         foreign key (types_id)
4313         references DefinedTermBase;
4314
4315     alter table AgentBase_DefinedTermBase
4316         add constraint FK6665C77D8D9AB196
4317         foreign key (AgentBase_id)
4318         references AgentBase;
4319
4320     alter table AgentBase_DefinedTermBase_AUD
4321         add constraint FKA737EECE34869AAE
4322         foreign key (REV)
4323         references AuditEvent;
4324
4325     alter table AgentBase_Extension
4326         add constraint FK8E1E5676927DE9DF
4327         foreign key (extensions_id)
4328         references Extension;
4329
4330     alter table AgentBase_Extension
4331         add constraint FK8E1E567686EFC5D4
4332         foreign key (AgentBase_id)
4333         references AgentBase;
4334
4335     alter table AgentBase_Extension_AUD
4336         add constraint FK11AE594734869AAE
4337         foreign key (REV)
4338         references AuditEvent;
4339
4340     alter table AgentBase_Marker
4341         add constraint FK365D5D6386EFC5D4
4342         foreign key (AgentBase_id)
4343         references AgentBase;
4344
4345     alter table AgentBase_Marker
4346         add constraint FK365D5D63777265A1
4347         foreign key (markers_id)
4348         references Marker;
4349
4350     alter table AgentBase_Marker_AUD
4351         add constraint FKE40621B434869AAE
4352         foreign key (REV)
4353         references AuditEvent;
4354
4355     alter table AgentBase_Media
4356         add constraint FKE8FC5D9BC2C29593
4357         foreign key (media_id)
4358         references Media;
4359
4360     alter table AgentBase_Media
4361         add constraint FKE8FC5D9B86EFC5D4
4362         foreign key (AgentBase_id)
4363         references AgentBase;
4364
4365     alter table AgentBase_Media_AUD
4366         add constraint FK323A45EC34869AAE
4367         foreign key (REV)
4368         references AuditEvent;
4369
4370     alter table AgentBase_OriginalSource
4371         add constraint FK7F410D753BAB2414
4372         foreign key (sources_id)
4373         references OriginalSource;
4374
4375     alter table AgentBase_OriginalSource
4376         add constraint FK7F410D7586EFC5D4
4377         foreign key (AgentBase_id)
4378         references AgentBase;
4379
4380     alter table AgentBase_OriginalSource_AUD
4381         add constraint FKB48F78C634869AAE
4382         foreign key (REV)
4383         references AuditEvent;
4384
4385     alter table AgentBase_Rights
4386         add constraint FK3F514B0086EFC5D4
4387         foreign key (AgentBase_id)
4388         references AgentBase;
4389
4390     alter table AgentBase_Rights
4391         add constraint FK3F514B00C13F7B21
4392         foreign key (rights_id)
4393         references Rights;
4394
4395     alter table AgentBase_Rights_AUD
4396         add constraint FK4FDFF8D134869AAE
4397         foreign key (REV)
4398         references AuditEvent;
4399
4400     alter table AgentBase_contact_emailaddresses
4401         add constraint FK4BD2B08E86EFC5D4
4402         foreign key (AgentBase_id)
4403         references AgentBase;
4404
4405     alter table AgentBase_contact_emailaddresses_AUD
4406         add constraint FKCAF7E75F34869AAE
4407         foreign key (REV)
4408         references AuditEvent;
4409
4410     alter table AgentBase_contact_faxnumbers
4411         add constraint FK52E1AD9586EFC5D4
4412         foreign key (AgentBase_id)
4413         references AgentBase;
4414
4415     alter table AgentBase_contact_faxnumbers_AUD
4416         add constraint FK88A308E634869AAE
4417         foreign key (REV)
4418         references AuditEvent;
4419
4420     alter table AgentBase_contact_phonenumbers
4421         add constraint FKC171CC2486EFC5D4
4422         foreign key (AgentBase_id)
4423         references AgentBase;
4424
4425     alter table AgentBase_contact_phonenumbers_AUD
4426         add constraint FKDDD347F534869AAE
4427         foreign key (REV)
4428         references AuditEvent;
4429
4430     alter table AgentBase_contact_urls
4431         add constraint FK9A9643EC86EFC5D4
4432         foreign key (AgentBase_id)
4433         references AgentBase;
4434
4435     alter table AgentBase_contact_urls_AUD
4436         add constraint FK1CE69BBD34869AAE
4437         foreign key (REV)
4438         references AuditEvent;
4439
4440     alter table Annotation
4441         add constraint FK1A21C74FDF299D00
4442         foreign key (annotationtype_id)
4443         references DefinedTermBase;
4444
4445     alter table Annotation
4446         add constraint FK1A21C74F4FF2DB2C
4447         foreign key (createdby_id)
4448         references UserAccount;
4449
4450     alter table Annotation
4451         add constraint FK1A21C74FE7692740
4452         foreign key (commentator_id)
4453         references AgentBase;
4454
4455     alter table Annotation
4456         add constraint FK1A21C74FBC5DA539
4457         foreign key (updatedby_id)
4458         references UserAccount;
4459
4460     alter table Annotation
4461         add constraint FK1A21C74FE8D36B00
4462         foreign key (language_id)
4463         references DefinedTermBase;
4464
4465     alter table Annotation_AUD
4466         add constraint FK1A6BB5A034869AAE
4467         foreign key (REV)
4468         references AuditEvent;
4469
4470     alter table Annotation_Annotation
4471         add constraint FKC99DFE3F994CCE20
4472         foreign key (Annotation_id)
4473         references Annotation;
4474
4475     alter table Annotation_Annotation
4476         add constraint FKC99DFE3F1E403E0B
4477         foreign key (annotations_id)
4478         references Annotation;
4479
4480     alter table Annotation_Annotation_AUD
4481         add constraint FKB212F49034869AAE
4482         foreign key (REV)
4483         references AuditEvent;
4484
4485     alter table Annotation_Marker
4486         add constraint FKB17EAF4A994CCE20
4487         foreign key (Annotation_id)
4488         references Annotation;
4489
4490     alter table Annotation_Marker
4491         add constraint FKB17EAF4A777265A1
4492         foreign key (markers_id)
4493         references Marker;
4494
4495     alter table Annotation_Marker_AUD
4496         add constraint FK68CE281B34869AAE
4497         foreign key (REV)
4498         references AuditEvent;
4499
4500     alter table CDM_VIEW
4501         add constraint FKC5DE8EF8765B124B
4502         foreign key (reference_id)
4503         references ReferenceBase;
4504
4505     alter table CDM_VIEW
4506         add constraint FKC5DE8EF84FF2DB2C
4507         foreign key (createdby_id)
4508         references UserAccount;
4509
4510     alter table CDM_VIEW_CDM_VIEW
4511         add constraint FK230A885F7208BB38
4512         foreign key (superviews_id)
4513         references CDM_VIEW;
4514
4515     alter table CDM_VIEW_CDM_VIEW
4516         add constraint FK230A885FC00D1213
4517         foreign key (CDM_VIEW_id)
4518         references CDM_VIEW;
4519
4520     create index collectionTitleCacheIndex on Collection (titleCache);
4521
4522     alter table Collection
4523         add constraint FKF078ABECEB38EFF
4524         foreign key (supercollection_id)
4525         references Collection;
4526
4527     alter table Collection
4528         add constraint FKF078ABE4FF2DB2C
4529         foreign key (createdby_id)
4530         references UserAccount;
4531
4532     alter table Collection
4533         add constraint FKF078ABE16B9CA77
4534         foreign key (institute_id)
4535         references AgentBase;
4536
4537     alter table Collection
4538         add constraint FKF078ABEBC5DA539
4539         foreign key (updatedby_id)
4540         references UserAccount;
4541
4542     alter table Collection_AUD
4543         add constraint FKD6D4298F34869AAE
4544         foreign key (REV)
4545         references AuditEvent;
4546
4547     alter table Collection_Annotation
4548         add constraint FKEA970F70EB62BE9A
4549         foreign key (Collection_id)
4550         references Collection;
4551
4552     alter table Collection_Annotation
4553         add constraint FKEA970F701E403E0B
4554         foreign key (annotations_id)
4555         references Annotation;
4556
4557     alter table Collection_Annotation_AUD
4558         add constraint FKA0CE054134869AAE
4559         foreign key (REV)
4560         references AuditEvent;
4561
4562     alter table Collection_Credit
4563         add constraint FKE0A317BAEB62BE9A
4564         foreign key (Collection_id)
4565         references Collection;
4566
4567     alter table Collection_Credit
4568         add constraint FKE0A317BA32D1B9F
4569         foreign key (credits_id)
4570         references Credit;
4571
4572     alter table Collection_Credit_AUD
4573         add constraint FK25A8D88B34869AAE
4574         foreign key (REV)
4575         references AuditEvent;
4576
4577     alter table Collection_Extension
4578         add constraint FKF68FEBDE927DE9DF
4579         foreign key (extensions_id)
4580         references Extension;
4581
4582     alter table Collection_Extension
4583         add constraint FKF68FEBDEEB62BE9A
4584         foreign key (Collection_id)
4585         references Collection;
4586
4587     alter table Collection_Extension_AUD
4588         add constraint FK1306FAAF34869AAE
4589         foreign key (REV)
4590         references AuditEvent;
4591
4592     alter table Collection_Marker
4593         add constraint FKF0CA00FBEB62BE9A
4594         foreign key (Collection_id)
4595         references Collection;
4596
4597     alter table Collection_Marker
4598         add constraint FKF0CA00FB777265A1
4599         foreign key (markers_id)
4600         references Marker;
4601
4602     alter table Collection_Marker_AUD
4603         add constraint FK89C7394C34869AAE
4604         foreign key (REV)
4605         references AuditEvent;
4606
4607     alter table Collection_Media
4608         add constraint FK7320E703EB62BE9A
4609         foreign key (Collection_id)
4610         references Collection;
4611
4612     alter table Collection_Media
4613         add constraint FK7320E703C2C29593
4614         foreign key (media_id)
4615         references Media;
4616
4617     alter table Collection_Media_AUD
4618         add constraint FK9AABDB5434869AAE
4619         foreign key (REV)
4620         references AuditEvent;
4621
4622     alter table Collection_OriginalSource
4623         add constraint FKA8FC990DEB62BE9A
4624         foreign key (Collection_id)
4625         references Collection;
4626
4627     alter table Collection_OriginalSource
4628         add constraint FKA8FC990D3BAB2414
4629         foreign key (sources_id)
4630         references OriginalSource;
4631
4632     alter table Collection_OriginalSource_AUD
4633         add constraint FK37EB785E34869AAE
4634         foreign key (REV)
4635         references AuditEvent;
4636
4637     alter table Collection_Rights
4638         add constraint FKF9BDEE98EB62BE9A
4639         foreign key (Collection_id)
4640         references Collection;
4641
4642     alter table Collection_Rights
4643         add constraint FKF9BDEE98C13F7B21
4644         foreign key (rights_id)
4645         references Rights;
4646
4647     alter table Collection_Rights_AUD
4648         add constraint FKF5A1106934869AAE
4649         foreign key (REV)
4650         references AuditEvent;
4651
4652     alter table Credit
4653         add constraint FK78CA9719F7976FC5
4654         foreign key (agent_id)
4655         references AgentBase;
4656
4657     alter table Credit
4658         add constraint FK78CA97194FF2DB2C
4659         foreign key (createdby_id)
4660         references UserAccount;
4661
4662     alter table Credit
4663         add constraint FK78CA9719BC5DA539
4664         foreign key (updatedby_id)
4665         references UserAccount;
4666
4667     alter table Credit
4668         add constraint FK78CA9719E8D36B00
4669         foreign key (language_id)
4670         references DefinedTermBase;
4671
4672     alter table Credit_AUD
4673         add constraint FK5533906A34869AAE
4674         foreign key (REV)
4675         references AuditEvent;
4676
4677     alter table Credit_Annotation
4678         add constraint FKE8DA4C354CF694E0
4679         foreign key (Credit_id)
4680         references Credit;
4681
4682     alter table Credit_Annotation
4683         add constraint FKE8DA4C351E403E0B
4684         foreign key (annotations_id)
4685         references Annotation;
4686
4687     alter table Credit_Annotation_AUD
4688         add constraint FK1DEB578634869AAE
4689         foreign key (REV)
4690         references AuditEvent;
4691
4692     alter table Credit_Marker
4693         add constraint FK10CC68404CF694E0
4694         foreign key (Credit_id)
4695         references Credit;
4696
4697     alter table Credit_Marker
4698         add constraint FK10CC6840777265A1
4699         foreign key (markers_id)
4700         references Marker;
4701
4702     alter table Credit_Marker_AUD
4703         add constraint FK880A761134869AAE
4704         foreign key (REV)
4705         references AuditEvent;
4706
4707     alter table DefinedTermBase
4708         add constraint FK2E340A6636C6F6F6
4709         foreign key (pointapproximation_referencesystem_id)
4710         references DefinedTermBase;
4711
4712     alter table DefinedTermBase
4713         add constraint FK2E340A664FF2DB2C
4714         foreign key (createdby_id)
4715         references UserAccount;
4716
4717     alter table DefinedTermBase
4718         add constraint FK2E340A6688206484
4719         foreign key (type_id)
4720         references DefinedTermBase;
4721
4722     alter table DefinedTermBase
4723         add constraint FK2E340A6647AF954C
4724         foreign key (vocabulary_id)
4725         references TermVocabulary;
4726
4727     alter table DefinedTermBase
4728         add constraint FK2E340A663B0DA0EF
4729         foreign key (kindof_id)
4730         references DefinedTermBase;
4731
4732     alter table DefinedTermBase
4733         add constraint FK2E340A6624AF3F70
4734         foreign key (level_id)
4735         references DefinedTermBase;
4736
4737     alter table DefinedTermBase
4738         add constraint FK2E340A66BC5DA539
4739         foreign key (updatedby_id)
4740         references UserAccount;
4741
4742     alter table DefinedTermBase
4743         add constraint FK2E340A66CC0240B6
4744         foreign key (shape_id)
4745         references Media;
4746
4747     alter table DefinedTermBase
4748         add constraint FK2E340A66D040DBF0
4749         foreign key (partof_id)
4750         references DefinedTermBase;
4751
4752     alter table DefinedTermBase_AUD
4753         add constraint FK86E8953734869AAE
4754         foreign key (REV)
4755         references AuditEvent;
4756
4757     alter table DefinedTermBase_Continent
4758         add constraint FK45F60AFBE8CE10AA
4759         foreign key (DefinedTermBase_id)
4760         references DefinedTermBase;
4761
4762     alter table DefinedTermBase_Continent
4763         add constraint FK45F60AFB3927C853
4764         foreign key (continents_id)
4765         references DefinedTermBase;
4766
4767     alter table DefinedTermBase_Continent_AUD
4768         add constraint FKF5DE434C34869AAE
4769         foreign key (REV)
4770         references AuditEvent;
4771
4772     alter table DefinedTermBase_MeasurementUnit
4773         add constraint FKE9D17767D0BDAE9B
4774         foreign key (DefinedTermBase_id)
4775         references DefinedTermBase;
4776
4777     alter table DefinedTermBase_MeasurementUnit
4778         add constraint FKE9D17767F3BB39BD
4779         foreign key (recommendedmeasurementunits_id)
4780         references DefinedTermBase;
4781
4782     alter table DefinedTermBase_MeasurementUnit_AUD
4783         add constraint FK2C1599B834869AAE
4784         foreign key (REV)
4785         references AuditEvent;
4786
4787     alter table DefinedTermBase_Media
4788         add constraint FK6FC908ABC0DB4934
4789         foreign key (DefinedTermBase_id)
4790         references DefinedTermBase;
4791
4792     alter table DefinedTermBase_Media
4793         add constraint FK6FC908ABC2C29593
4794         foreign key (media_id)
4795         references Media;
4796
4797     alter table DefinedTermBase_Media_AUD
4798         add constraint FKDD9AE8FC34869AAE
4799         foreign key (REV)
4800         references AuditEvent;
4801
4802     alter table DefinedTermBase_RecommendedModifierEnumeration
4803         add constraint FKA72FB5AED0BDAE9B
4804         foreign key (DefinedTermBase_id)
4805         references DefinedTermBase;
4806
4807     alter table DefinedTermBase_RecommendedModifierEnumeration
4808         add constraint FKA72FB5AE5255EAFD
4809         foreign key (recommendedmodifierenumeration_id)
4810         references TermVocabulary;
4811
4812     alter table DefinedTermBase_RecommendedModifierEnumeration_AUD
4813         add constraint FK780D5C7F34869AAE
4814         foreign key (REV)
4815         references AuditEvent;
4816
4817     alter table DefinedTermBase_Representation
4818         add constraint FKAAC8AFE6C0DB4934
4819         foreign key (DefinedTermBase_id)
4820         references DefinedTermBase;
4821
4822     alter table DefinedTermBase_Representation
4823         add constraint FKAAC8AFE6B31C4747
4824         foreign key (representations_id)
4825         references Representation;
4826
4827     alter table DefinedTermBase_Representation_AUD
4828         add constraint FKB5AE7AB734869AAE
4829         foreign key (REV)
4830         references AuditEvent;
4831
4832     alter table DefinedTermBase_StatisticalMeasure
4833         add constraint FK6FF15DFCD0BDAE9B
4834         foreign key (DefinedTermBase_id)
4835         references DefinedTermBase;
4836
4837     alter table DefinedTermBase_StatisticalMeasure
4838         add constraint FK6FF15DFCC9CD5B57
4839         foreign key (recommendedstatisticalmeasures_id)
4840         references DefinedTermBase;
4841
4842     alter table DefinedTermBase_StatisticalMeasure_AUD
4843         add constraint FK3C062DCD34869AAE
4844         foreign key (REV)
4845         references AuditEvent;
4846
4847     alter table DefinedTermBase_SupportedCategoricalEnumeration
4848         add constraint FK2170B25CD0BDAE9B
4849         foreign key (DefinedTermBase_id)
4850         references DefinedTermBase;
4851
4852     alter table DefinedTermBase_SupportedCategoricalEnumeration
4853         add constraint FK2170B25C5AF2C74
4854         foreign key (supportedcategoricalenumerations_id)
4855         references TermVocabulary;
4856
4857     alter table DefinedTermBase_SupportedCategoricalEnumeration_AUD
4858         add constraint FKBB04522D34869AAE
4859         foreign key (REV)
4860         references AuditEvent;
4861
4862     alter table DefinedTermBase_WaterbodyOrCountry
4863         add constraint FKCAF4393CE5C0F9E
4864         foreign key (DefinedTermBase_id)
4865         references DefinedTermBase;
4866
4867     alter table DefinedTermBase_WaterbodyOrCountry
4868         add constraint FKCAF43931603B036
4869         foreign key (waterbodiesorcountries_id)
4870         references DefinedTermBase;
4871
4872     alter table DefinedTermBase_WaterbodyOrCountry_AUD
4873         add constraint FKD5996FE434869AAE
4874         foreign key (REV)
4875         references AuditEvent;
4876
4877     alter table DerivationEvent
4878         add constraint FK426BC034FF2DB2C
4879         foreign key (createdby_id)
4880         references UserAccount;
4881
4882     alter table DerivationEvent
4883         add constraint FK426BC038524B89D
4884         foreign key (type_id)
4885         references DefinedTermBase;
4886
4887     alter table DerivationEvent
4888         add constraint FK426BC03BC5DA539
4889         foreign key (updatedby_id)
4890         references UserAccount;
4891
4892     alter table DerivationEvent
4893         add constraint FK426BC033DA462D5
4894         foreign key (actor_id)
4895         references AgentBase;
4896
4897     alter table DerivationEvent_AUD
4898         add constraint FKDABF305434869AAE
4899         foreign key (REV)
4900         references AuditEvent;
4901
4902     alter table DerivationEvent_Annotation
4903         add constraint FKEFA0D10B4AAB411A
4904         foreign key (DerivationEvent_id)
4905         references DerivationEvent;
4906
4907     alter table DerivationEvent_Annotation
4908         add constraint FKEFA0D10B1E403E0B
4909         foreign key (annotations_id)
4910         references Annotation;
4911
4912     alter table DerivationEvent_Annotation_AUD
4913         add constraint FKA197815C34869AAE
4914         foreign key (REV)
4915         references AuditEvent;
4916
4917     alter table DerivationEvent_Marker
4918         add constraint FKE412C8164AAB411A
4919         foreign key (DerivationEvent_id)
4920         references DerivationEvent;
4921
4922     alter table DerivationEvent_Marker
4923         add constraint FKE412C816777265A1
4924         foreign key (markers_id)
4925         references Marker;
4926
4927     alter table DerivationEvent_Marker_AUD
4928         add constraint FK8ED0FAE734869AAE
4929         foreign key (REV)
4930         references AuditEvent;
4931
4932     alter table DescriptionBase
4933         add constraint FKFF4D58CD4FF2DB2C
4934         foreign key (createdby_id)
4935         references UserAccount;
4936
4937     alter table DescriptionBase
4938         add constraint FKFF4D58CDDA93512F
4939         foreign key (taxonName_fk)
4940         references TaxonNameBase;
4941
4942     alter table DescriptionBase
4943         add constraint FKFF4D58CDBC5DA539
4944         foreign key (updatedby_id)
4945         references UserAccount;
4946
4947     alter table DescriptionBase
4948         add constraint FKFF4D58CDDE9A3DE3
4949         foreign key (taxon_fk)
4950         references TaxonBase;
4951
4952     alter table DescriptionBase_AUD
4953         add constraint FK7456581E34869AAE
4954         foreign key (REV)
4955         references AuditEvent;
4956
4957     alter table DescriptionBase_Annotation
4958         add constraint FKF3AD3201F1DDBFAB
4959         foreign key (DescriptionBase_id)
4960         references DescriptionBase;
4961
4962     alter table DescriptionBase_Annotation
4963         add constraint FKF3AD32011E403E0B
4964         foreign key (annotations_id)
4965         references Annotation;
4966
4967     alter table DescriptionBase_Annotation_AUD
4968         add constraint FK15FE775234869AAE
4969         foreign key (REV)
4970         references AuditEvent;
4971
4972     alter table DescriptionBase_Credit
4973         add constraint FK510B2ACBF1DDBFAB
4974         foreign key (DescriptionBase_id)
4975         references DescriptionBase;
4976
4977     alter table DescriptionBase_Credit
4978         add constraint FK510B2ACB32D1B9F
4979         foreign key (credits_id)
4980         references Credit;
4981
4982     alter table DescriptionBase_Credit_AUD
4983         add constraint FK2EBEFB1C34869AAE
4984         foreign key (REV)
4985         references AuditEvent;
4986
4987     alter table DescriptionBase_Extension
4988         add constraint FKD5D2B32DF1DDBFAB
4989         foreign key (DescriptionBase_id)
4990         references DescriptionBase;
4991
4992     alter table DescriptionBase_Extension
4993         add constraint FKD5D2B32D927DE9DF
4994         foreign key (extensions_id)
4995         references Extension;
4996
4997     alter table DescriptionBase_Extension_AUD
4998         add constraint FK79E7827E34869AAE
4999         foreign key (REV)
5000         references AuditEvent;
5001
5002     alter table DescriptionBase_Feature
5003         add constraint FK58ACF564F1DDBFAB
5004         foreign key (DescriptionBase_id)
5005         references DescriptionBase;
5006
5007     alter table DescriptionBase_Feature
5008         add constraint FK58ACF5649AE62C6
5009         foreign key (descriptivesystem_id)
5010         references DefinedTermBase;
5011
5012     alter table DescriptionBase_Feature_AUD
5013         add constraint FKA4D7D13534869AAE
5014         foreign key (REV)
5015         references AuditEvent;
5016
5017     alter table DescriptionBase_GeoScope
5018         add constraint FK3ADD7CD5D86445CE
5019         foreign key (DescriptionBase_id)
5020         references DescriptionBase;
5021
5022     alter table DescriptionBase_GeoScope
5023         add constraint FK3ADD7CD586D04E74
5024         foreign key (geoscopes_id)
5025         references DefinedTermBase;
5026
5027     alter table DescriptionBase_GeoScope_AUD
5028         add constraint FK63A5382634869AAE
5029         foreign key (REV)
5030         references AuditEvent;
5031
5032     alter table DescriptionBase_Marker
5033         add constraint FK6132140CF1DDBFAB
5034         foreign key (DescriptionBase_id)
5035         references DescriptionBase;
5036
5037     alter table DescriptionBase_Marker
5038         add constraint FK6132140C777265A1
5039         foreign key (markers_id)
5040         references Marker;
5041
5042     alter table DescriptionBase_Marker_AUD
5043         add constraint FK92DD5BDD34869AAE
5044         foreign key (REV)
5045         references AuditEvent;
5046
5047     alter table DescriptionBase_OriginalSource
5048         add constraint FK1E2D0B1EF1DDBFAB
5049         foreign key (DescriptionBase_id)
5050         references DescriptionBase;
5051
5052     alter table DescriptionBase_OriginalSource
5053         add constraint FK1E2D0B1E3BAB2414
5054         foreign key (sources_id)
5055         references OriginalSource;
5056
5057     alter table DescriptionBase_OriginalSource_AUD
5058         add constraint FKDC8279EF34869AAE
5059         foreign key (REV)
5060         references AuditEvent;
5061
5062     alter table DescriptionBase_ReferenceBase
5063         add constraint FK76188CAAF1DDBFAB
5064         foreign key (DescriptionBase_id)
5065         references DescriptionBase;
5066
5067     alter table DescriptionBase_ReferenceBase
5068         add constraint FK76188CAA45AB7BBA
5069         foreign key (descriptionsources_id)
5070         references ReferenceBase;
5071
5072     alter table DescriptionBase_ReferenceBase_AUD
5073         add constraint FK687A557B34869AAE
5074         foreign key (REV)
5075         references AuditEvent;
5076
5077     alter table DescriptionBase_Rights
5078         add constraint FK6A2601A9F1DDBFAB
5079         foreign key (DescriptionBase_id)
5080         references DescriptionBase;
5081
5082     alter table DescriptionBase_Rights
5083         add constraint FK6A2601A9C13F7B21
5084         foreign key (rights_id)
5085         references Rights;
5086
5087     alter table DescriptionBase_Rights_AUD
5088         add constraint FKFEB732FA34869AAE
5089         foreign key (REV)
5090         references AuditEvent;
5091
5092     alter table DescriptionBase_Scope
5093         add constraint FKB9257C42D86445CE
5094         foreign key (DescriptionBase_id)
5095         references DescriptionBase;
5096
5097     alter table DescriptionBase_Scope
5098         add constraint FKB9257C42951A5D40
5099         foreign key (scopes_id)
5100         references DefinedTermBase;
5101
5102     alter table DescriptionBase_Scope_AUD
5103         add constraint FK75D5B91334869AAE
5104         foreign key (REV)
5105         references AuditEvent;
5106
5107     alter table DescriptionBase_SpecimenOrObservationBase
5108         add constraint FKDE29CD8033B8A841
5109         foreign key (descriptions_id)
5110         references DescriptionBase;
5111
5112     alter table DescriptionBase_SpecimenOrObservationBase
5113         add constraint FKDE29CD805C9E3461
5114         foreign key (describedspecimenorobservations_id)
5115         references SpecimenOrObservationBase;
5116
5117     alter table DescriptionBase_SpecimenOrObservationBase_AUD
5118         add constraint FKF1B33B5134869AAE
5119         foreign key (REV)
5120         references AuditEvent;
5121
5122     alter table DescriptionElementBase
5123         add constraint FK38FE767134AF0E81
5124         foreign key (indescription_id)
5125         references DescriptionBase;
5126
5127     alter table DescriptionElementBase
5128         add constraint FK38FE76716561D9B1
5129         foreign key (associatedspecimenorobservation_id)
5130         references SpecimenOrObservationBase;
5131
5132     alter table DescriptionElementBase
5133         add constraint FK38FE76714220AFEB
5134         foreign key (feature_id)
5135         references DefinedTermBase;
5136
5137     alter table DescriptionElementBase
5138         add constraint FK38FE7671BC5DA539
5139         foreign key (updatedby_id)
5140         references UserAccount;
5141
5142     alter table DescriptionElementBase
5143         add constraint FK38FE76719108D9B
5144         foreign key (taxon2_id)
5145         references TaxonBase;
5146
5147     alter table DescriptionElementBase
5148         add constraint FK38FE76714FF2DB2C
5149         foreign key (createdby_id)
5150         references UserAccount;
5151
5152     alter table DescriptionElementBase
5153         add constraint FK38FE7671A308E33C
5154         foreign key (nameusedinreference_id)
5155         references TaxonNameBase;
5156
5157     alter table DescriptionElementBase
5158         add constraint FK38FE767110A80E07
5159         foreign key (unit_id)
5160         references DefinedTermBase;
5161
5162     alter table DescriptionElementBase
5163         add constraint FK38FE76715E9914B8
5164         foreign key (status_id)
5165         references DefinedTermBase;
5166
5167     alter table DescriptionElementBase
5168         add constraint FK38FE76716D0D7A56
5169         foreign key (format_id)
5170         references DefinedTermBase;
5171
5172     alter table DescriptionElementBase
5173         add constraint FK38FE76719803512F
5174         foreign key (citation_id)
5175         references ReferenceBase;
5176
5177     alter table DescriptionElementBase
5178         add constraint FK38FE7671E8D36B00
5179         foreign key (language_id)
5180         references DefinedTermBase;
5181
5182     alter table DescriptionElementBase
5183         add constraint FK38FE76711C3C3FF7
5184         foreign key (area_id)
5185         references DefinedTermBase;
5186
5187     alter table DescriptionElementBase_AUD
5188         add constraint FKF3803C234869AAE
5189         foreign key (REV)
5190         references AuditEvent;
5191
5192     alter table DescriptionElementBase_Annotation
5193         add constraint FK7EE5E5DD3B8BB609
5194         foreign key (DescriptionElementBase_id)
5195         references DescriptionElementBase;
5196
5197     alter table DescriptionElementBase_Annotation
5198         add constraint FK7EE5E5DD1E403E0B
5199         foreign key (annotations_id)
5200         references Annotation;
5201
5202     alter table DescriptionElementBase_Annotation_AUD
5203         add constraint FK2BC1DD2E34869AAE
5204         foreign key (REV)
5205         references AuditEvent;
5206
5207     alter table DescriptionElementBase_LanguageString
5208         add constraint FKC753F137C6D55834
5209         foreign key (multilanguagetext_mapkey_id)
5210         references DefinedTermBase;
5211
5212     alter table DescriptionElementBase_LanguageString
5213         add constraint FKC753F137ACF5F60B
5214         foreign key (multilanguagetext_id)
5215         references LanguageString;
5216
5217     alter table DescriptionElementBase_LanguageString
5218         add constraint FKC753F137C086B46F
5219         foreign key (DescriptionElementBase_id)
5220         references DescriptionElementBase;
5221
5222     alter table DescriptionElementBase_LanguageString_AUD
5223         add constraint FK2D26AB8834869AAE
5224         foreign key (REV)
5225         references AuditEvent;
5226
5227     alter table DescriptionElementBase_Marker
5228         add constraint FK1CB715E83B8BB609
5229         foreign key (DescriptionElementBase_id)
5230         references DescriptionElementBase;
5231
5232     alter table DescriptionElementBase_Marker
5233         add constraint FK1CB715E8777265A1
5234         foreign key (markers_id)
5235         references Marker;
5236
5237     alter table DescriptionElementBase_Marker_AUD
5238         add constraint FK1E160FB934869AAE
5239         foreign key (REV)
5240         references AuditEvent;
5241
5242     alter table DescriptionElementBase_Media
5243         add constraint FK21F70076C2C29593
5244         foreign key (media_id)
5245         references Media;
5246
5247     alter table DescriptionElementBase_Media
5248         add constraint FK21F700763B8BB609
5249         foreign key (DescriptionElementBase_id)
5250         references DescriptionElementBase;
5251
5252     alter table DescriptionElementBase_Media_AUD
5253         add constraint FK5522034734869AAE
5254         foreign key (REV)
5255         references AuditEvent;
5256
5257     alter table DescriptionElementBase_Modifier
5258         add constraint FK97E0D105E0960EC4
5259         foreign key (modifiers_id)
5260         references DefinedTermBase;
5261
5262     alter table DescriptionElementBase_Modifier
5263         add constraint FK97E0D1053B8BB609
5264         foreign key (DescriptionElementBase_id)
5265         references DescriptionElementBase;
5266
5267     alter table DescriptionElementBase_Modifier_AUD
5268         add constraint FK2982F45634869AAE
5269         foreign key (REV)
5270         references AuditEvent;
5271
5272     alter table DescriptionElementBase_ModifyingText
5273         add constraint FK522D90C7F05D08D4
5274         foreign key (modifyingtext_id)
5275         references LanguageString;
5276
5277     alter table DescriptionElementBase_ModifyingText
5278         add constraint FK522D90C73B8BB609
5279         foreign key (DescriptionElementBase_id)
5280         references DescriptionElementBase;
5281
5282     alter table DescriptionElementBase_ModifyingText
5283         add constraint FK522D90C79682414B
5284         foreign key (modifyingtext_mapkey_id)
5285         references DefinedTermBase;
5286
5287     alter table DescriptionElementBase_ModifyingText_AUD
5288         add constraint FK6C06031834869AAE
5289         foreign key (REV)
5290         references AuditEvent;
5291
5292     alter table DescriptionElementBase_StateData
5293         add constraint FK592D6F6D987CC6A4
5294         foreign key (DescriptionElementBase_id)
5295         references DescriptionElementBase;
5296
5297     alter table DescriptionElementBase_StateData
5298         add constraint FK592D6F6D15153604
5299         foreign key (states_id)
5300         references StateData;
5301
5302     alter table DescriptionElementBase_StateData_AUD
5303         add constraint FK1D0A1EBE34869AAE
5304         foreign key (REV)
5305         references AuditEvent;
5306
5307     alter table DescriptionElementBase_StatisticalMeasurementValue
5308         add constraint FK8AF511C2D883945E
5309         foreign key (statisticalvalues_id)
5310         references StatisticalMeasurementValue;
5311
5312     alter table DescriptionElementBase_StatisticalMeasurementValue
5313         add constraint FK8AF511C28F213219
5314         foreign key (DescriptionElementBase_id)
5315         references DescriptionElementBase;
5316
5317     alter table DescriptionElementBase_StatisticalMeasurementValue_AUD
5318         add constraint FK2DE8E9334869AAE
5319         foreign key (REV)
5320         references AuditEvent;
5321
5322     alter table DeterminationEvent
5323         add constraint FK1DB24974FF2DB2C
5324         foreign key (createdby_id)
5325         references UserAccount;
5326
5327     alter table DeterminationEvent
5328         add constraint FK1DB2497378D1BD
5329         foreign key (modifier_id)
5330         references DefinedTermBase;
5331
5332     alter table DeterminationEvent
5333         add constraint FK1DB2497DE9A3E39
5334         foreign key (taxon_id)
5335         references TaxonBase;
5336
5337     alter table DeterminationEvent
5338         add constraint FK1DB24974B251DAD
5339         foreign key (identifiedunit_id)
5340         references SpecimenOrObservationBase;
5341
5342     alter table DeterminationEvent
5343         add constraint FK1DB2497BC5DA539
5344         foreign key (updatedby_id)
5345         references UserAccount;
5346
5347     alter table DeterminationEvent
5348         add constraint FK1DB24973DA462D5
5349         foreign key (actor_id)
5350         references AgentBase;
5351
5352     alter table DeterminationEvent_AUD
5353         add constraint FKA0252EE834869AAE
5354         foreign key (REV)
5355         references AuditEvent;
5356
5357     alter table DeterminationEvent_Annotation
5358         add constraint FKB74F03F76BE0BFDA
5359         foreign key (DeterminationEvent_id)
5360         references DeterminationEvent;
5361
5362     alter table DeterminationEvent_Annotation
5363         add constraint FKB74F03F71E403E0B
5364         foreign key (annotations_id)
5365         references Annotation;
5366
5367     alter table DeterminationEvent_Annotation_AUD
5368         add constraint FKAFDA5E4834869AAE
5369         foreign key (REV)
5370         references AuditEvent;
5371
5372     alter table DeterminationEvent_Marker
5373         add constraint FK5C475102777265A1
5374         foreign key (markers_id)
5375         references Marker;
5376
5377     alter table DeterminationEvent_Marker
5378         add constraint FK5C4751026BE0BFDA
5379         foreign key (DeterminationEvent_id)
5380         references DeterminationEvent;
5381
5382     alter table DeterminationEvent_Marker_AUD
5383         add constraint FK567F2DD334869AAE
5384         foreign key (REV)
5385         references AuditEvent;
5386
5387     alter table DeterminationEvent_ReferenceBase
5388         add constraint FK6248EEF43EF09CD5
5389         foreign key (setofreferences_id)
5390         references ReferenceBase;
5391
5392     alter table DeterminationEvent_ReferenceBase
5393         add constraint FK6248EEF46BE0BFDA
5394         foreign key (DeterminationEvent_id)
5395         references DeterminationEvent;
5396
5397     alter table DeterminationEvent_ReferenceBase_AUD
5398         add constraint FK25BC82C534869AAE
5399         foreign key (REV)
5400         references AuditEvent;
5401
5402     alter table Extension
5403         add constraint FK52EF3C1F4FF2DB2C
5404         foreign key (createdby_id)
5405         references UserAccount;
5406
5407     alter table Extension
5408         add constraint FK52EF3C1FAD392BD3
5409         foreign key (type_id)
5410         references DefinedTermBase;
5411
5412     alter table Extension
5413         add constraint FK52EF3C1FBC5DA539
5414         foreign key (updatedby_id)
5415         references UserAccount;
5416
5417     alter table Extension_AUD
5418         add constraint FK92D2427034869AAE
5419         foreign key (REV)
5420         references AuditEvent;
5421
5422     alter table FeatureNode
5423         add constraint FK4CEED9F8E0AD2C03
5424         foreign key (parent_fk)
5425         references FeatureNode;
5426
5427     alter table FeatureNode
5428         add constraint FK4CEED9F84FF2DB2C
5429         foreign key (createdby_id)
5430         references UserAccount;
5431
5432     alter table FeatureNode
5433         add constraint FK4CEED9F84220AFEB
5434         foreign key (feature_id)
5435         references DefinedTermBase;
5436
5437     alter table FeatureNode
5438         add constraint FK4CEED9F8BC5DA539
5439         foreign key (updatedby_id)
5440         references UserAccount;
5441
5442     alter table FeatureNode_AUD
5443         add constraint FK25AD4BC934869AAE
5444         foreign key (REV)
5445         references AuditEvent;
5446
5447     alter table FeatureTree
5448         add constraint FK4CF19F944FF2DB2C
5449         foreign key (createdby_id)
5450         references UserAccount;
5451
5452     alter table FeatureTree
5453         add constraint FK4CF19F94B7892921
5454         foreign key (root_id)
5455         references FeatureNode;
5456
5457     alter table FeatureTree
5458         add constraint FK4CF19F94BC5DA539
5459         foreign key (updatedby_id)
5460         references UserAccount;
5461
5462     alter table FeatureTree_AUD
5463         add constraint FK355BE36534869AAE
5464         foreign key (REV)
5465         references AuditEvent;
5466
5467     alter table FeatureTree_Representation
5468         add constraint FK8C458F847C496CB
5469         foreign key (FeatureTree_id)
5470         references FeatureTree;
5471
5472     alter table FeatureTree_Representation
5473         add constraint FK8C458F8B31C4747
5474         foreign key (representations_id)
5475         references Representation;
5476
5477     alter table FeatureTree_Representation_AUD
5478         add constraint FKECAB4AC934869AAE
5479         foreign key (REV)
5480         references AuditEvent;
5481
5482     alter table GatheringEvent
5483         add constraint FK6F1286F3F55AFD89
5484         foreign key (exactlocation_referencesystem_id)
5485         references DefinedTermBase;
5486
5487     alter table GatheringEvent
5488         add constraint FK6F1286F38B455EC6
5489         foreign key (locality_id)
5490         references LanguageString;
5491
5492     alter table GatheringEvent
5493         add constraint FK6F1286F34FF2DB2C
5494         foreign key (createdby_id)
5495         references UserAccount;
5496
5497     alter table GatheringEvent
5498         add constraint FK6F1286F3BC5DA539
5499         foreign key (updatedby_id)
5500         references UserAccount;
5501
5502     alter table GatheringEvent
5503         add constraint FK6F1286F33DA462D5
5504         foreign key (actor_id)
5505         references AgentBase;
5506
5507     alter table GatheringEvent_AUD
5508         add constraint FK3EC034434869AAE
5509         foreign key (REV)
5510         references AuditEvent;
5511
5512     alter table GatheringEvent_Annotation
5513         add constraint FK76DDD01BF95F225A
5514         foreign key (GatheringEvent_id)
5515         references GatheringEvent;
5516
5517     alter table GatheringEvent_Annotation
5518         add constraint FK76DDD01B1E403E0B
5519         foreign key (annotations_id)
5520         references Annotation;
5521
5522     alter table GatheringEvent_Annotation_AUD
5523         add constraint FK351E786C34869AAE
5524         foreign key (REV)
5525         references AuditEvent;
5526
5527     alter table GatheringEvent_DefinedTermBase
5528         add constraint FK69D9A11A7C34B6D6
5529         foreign key (collectingareas_id)
5530         references DefinedTermBase;
5531
5532     alter table GatheringEvent_DefinedTermBase
5533         add constraint FK69D9A11AF95F225A
5534         foreign key (GatheringEvent_id)
5535         references GatheringEvent;
5536
5537     alter table GatheringEvent_DefinedTermBase_AUD
5538         add constraint FKB3BBB1EB34869AAE
5539         foreign key (REV)
5540         references AuditEvent;
5541
5542     alter table GatheringEvent_Marker
5543         add constraint FK7B49CF26777265A1
5544         foreign key (markers_id)
5545         references Marker;
5546
5547     alter table GatheringEvent_Marker
5548         add constraint FK7B49CF26F95F225A
5549         foreign key (GatheringEvent_id)
5550         references GatheringEvent;
5551
5552     alter table GatheringEvent_Marker_AUD
5553         add constraint FK160DF9F734869AAE
5554         foreign key (REV)
5555         references AuditEvent;
5556
5557     alter table GenBankAccession
5558         add constraint FK86C1DBF84FF2DB2C
5559         foreign key (createdby_id)
5560         references UserAccount;
5561
5562     alter table GenBankAccession
5563         add constraint FK86C1DBF8BC5DA539
5564         foreign key (updatedby_id)
5565         references UserAccount;
5566
5567     alter table GenBankAccession_AUD
5568         add constraint FK5A2F4DC934869AAE
5569         foreign key (REV)
5570         references AuditEvent;
5571
5572     alter table GrantedAuthorityImpl
5573         add constraint FKB05CF9284FF2DB2C
5574         foreign key (createdby_id)
5575         references UserAccount;
5576
5577     alter table HomotypicalGroup
5578         add constraint FK7DECCC184FF2DB2C
5579         foreign key (createdby_id)
5580         references UserAccount;
5581
5582     alter table HomotypicalGroup
5583         add constraint FK7DECCC18BC5DA539
5584         foreign key (updatedby_id)
5585         references UserAccount;
5586
5587     alter table HomotypicalGroup_AUD
5588         add constraint FKE4252DE934869AAE
5589         foreign key (REV)
5590         references AuditEvent;
5591
5592     alter table HomotypicalGroup_Annotation
5593         add constraint FK7A0351D6BFEAE500
5594         foreign key (HomotypicalGroup_id)
5595         references HomotypicalGroup;
5596
5597     alter table HomotypicalGroup_Annotation
5598         add constraint FK7A0351D61E403E0B
5599         foreign key (annotations_id)
5600         references Annotation;
5601
5602     alter table HomotypicalGroup_Annotation_AUD
5603         add constraint FK41E6A4A734869AAE
5604         foreign key (REV)
5605         references AuditEvent;
5606
5607     alter table HomotypicalGroup_Marker
5608         add constraint FK97D36661BFEAE500
5609         foreign key (HomotypicalGroup_id)
5610         references HomotypicalGroup;
5611
5612     alter table HomotypicalGroup_Marker
5613         add constraint FK97D36661777265A1
5614         foreign key (markers_id)
5615         references Marker;
5616
5617     alter table HomotypicalGroup_Marker_AUD
5618         add constraint FK19337BB234869AAE
5619         foreign key (REV)
5620         references AuditEvent;
5621
5622     alter table HybridRelationship
5623         add constraint FK9033CE745831BDC3
5624         foreign key (relatedfrom_id)
5625         references TaxonNameBase;
5626
5627     alter table HybridRelationship
5628         add constraint FK9033CE7469ABE292
5629         foreign key (relatedto_id)
5630         references TaxonNameBase;
5631
5632     alter table HybridRelationship
5633         add constraint FK9033CE744FF2DB2C
5634         foreign key (createdby_id)
5635         references UserAccount;
5636
5637     alter table HybridRelationship
5638         add constraint FK9033CE7455F241D4
5639         foreign key (type_id)
5640         references DefinedTermBase;
5641
5642     alter table HybridRelationship
5643         add constraint FK9033CE749803512F
5644         foreign key (citation_id)
5645         references ReferenceBase;
5646
5647     alter table HybridRelationship
5648         add constraint FK9033CE74BC5DA539
5649         foreign key (updatedby_id)
5650         references UserAccount;
5651
5652     alter table HybridRelationship_AUD
5653         add constraint FK9C2BA24534869AAE
5654         foreign key (REV)
5655         references AuditEvent;
5656
5657     alter table HybridRelationship_Annotation
5658         add constraint FK2C7E7DFA59832240
5659         foreign key (HybridRelationship_id)
5660         references HybridRelationship;
5661
5662     alter table HybridRelationship_Annotation
5663         add constraint FK2C7E7DFA1E403E0B
5664         foreign key (annotations_id)
5665         references Annotation;
5666
5667     alter table HybridRelationship_Annotation_AUD
5668         add constraint FKACE71ECB34869AAE
5669         foreign key (REV)
5670         references AuditEvent;
5671
5672     alter table HybridRelationship_Marker
5673         add constraint FKCEF2448559832240
5674         foreign key (HybridRelationship_id)
5675         references HybridRelationship;
5676
5677     alter table HybridRelationship_Marker
5678         add constraint FKCEF24485777265A1
5679         foreign key (markers_id)
5680         references Marker;
5681
5682     alter table HybridRelationship_Marker_AUD
5683         add constraint FKCBAEA7D634869AAE
5684         foreign key (REV)
5685         references AuditEvent;
5686
5687     alter table MediaKey_Taxon
5688         add constraint FKD847ADDC996CD055
5689         foreign key (mediaKey_fk)
5690         references Media;
5691
5692     alter table MediaKey_Taxon
5693         add constraint FKD847ADDCDE9A3DE3
5694         foreign key (taxon_fk)
5695         references TaxonBase;
5696
5697     alter table MediaKey_Taxon_AUD
5698         add constraint FKEEF18DAD34869AAE
5699         foreign key (REV)
5700         references AuditEvent;
5701
5702     alter table IndividualAssociation_LanguageString
5703         add constraint FKB5C75EC02BEBA58D
5704         foreign key (description_id)
5705         references LanguageString;
5706
5707     alter table IndividualAssociation_LanguageString
5708         add constraint FKB5C75EC084FF3EDF
5709         foreign key (DescriptionElementBase_id)
5710         references DescriptionElementBase;
5711
5712     alter table IndividualAssociation_LanguageString
5713         add constraint FKB5C75EC028459272
5714         foreign key (description_mapkey_id)
5715         references DefinedTermBase;
5716
5717     alter table IndividualAssociation_LanguageString_AUD
5718         add constraint FKB1A62C9134869AAE
5719         foreign key (REV)
5720         references AuditEvent;
5721
5722     alter table InstitutionalMembership
5723         add constraint FK3C8E1FF94FF2DB2C
5724         foreign key (createdby_id)
5725         references UserAccount;
5726
5727     alter table InstitutionalMembership
5728         add constraint FK3C8E1FF9AAC1B820
5729         foreign key (person_id)
5730         references AgentBase;
5731
5732     alter table InstitutionalMembership
5733         add constraint FK3C8E1FF916B9CA77
5734         foreign key (institute_id)
5735         references AgentBase;
5736
5737     alter table InstitutionalMembership
5738         add constraint FK3C8E1FF9BC5DA539
5739         foreign key (updatedby_id)
5740         references UserAccount;
5741
5742     alter table InstitutionalMembership_AUD
5743         add constraint FK847A94A34869AAE
5744         foreign key (REV)
5745         references AuditEvent;
5746
5747     alter table LSIDAuthority
5748         add constraint FK759DB8814FF2DB2C
5749         foreign key (createdby_id)
5750         references UserAccount;
5751
5752     alter table LSIDAuthority_namespaces
5753         add constraint FKB04948F64FFCFD94
5754         foreign key (LSIDAuthority_id)
5755         references LSIDAuthority;
5756
5757     alter table LanguageString
5758         add constraint FKB5FDC9A94FF2DB2C
5759         foreign key (createdby_id)
5760         references UserAccount;
5761
5762     alter table LanguageString
5763         add constraint FKB5FDC9A9BC5DA539
5764         foreign key (updatedby_id)
5765         references UserAccount;
5766
5767     alter table LanguageString
5768         add constraint FKB5FDC9A9E8D36B00
5769         foreign key (language_id)
5770         references DefinedTermBase;
5771
5772     alter table LanguageString_AUD
5773         add constraint FK896AFAFA34869AAE
5774         foreign key (REV)
5775         references AuditEvent;
5776
5777     alter table LanguageString_Annotation
5778         add constraint FK8400DFA51E403E0B
5779         foreign key (annotations_id)
5780         references Annotation;
5781
5782     alter table LanguageString_Annotation
5783         add constraint FK8400DFA537998500
5784         foreign key (LanguageString_id)
5785         references LanguageString;
5786
5787     alter table LanguageString_Annotation_AUD
5788         add constraint FKD3BAB2F634869AAE
5789         foreign key (REV)
5790         references AuditEvent;
5791
5792     alter table LanguageString_Marker
5793         add constraint FK8DA633B0777265A1
5794         foreign key (markers_id)
5795         references Marker;
5796
5797     alter table LanguageString_Marker
5798         add constraint FK8DA633B037998500
5799         foreign key (LanguageString_id)
5800         references LanguageString;
5801
5802     alter table LanguageString_Marker_AUD
5803         add constraint FK2331098134869AAE
5804         foreign key (REV)
5805         references AuditEvent;
5806
5807     alter table Locus
5808         add constraint FK462F1BE4FF2DB2C
5809         foreign key (createdby_id)
5810         references UserAccount;
5811
5812     alter table Locus
5813         add constraint FK462F1BEBC5DA539
5814         foreign key (updatedby_id)
5815         references UserAccount;
5816
5817     alter table Locus_AUD
5818         add constraint FK5224108F34869AAE
5819         foreign key (REV)
5820         references AuditEvent;
5821
5822     alter table Marker
5823         add constraint FK88F1805A4FF2DB2C
5824         foreign key (createdby_id)
5825         references UserAccount;
5826
5827     alter table Marker
5828         add constraint FK88F1805AD64DC020
5829         foreign key (markertype_id)
5830         references DefinedTermBase;
5831
5832     alter table Marker
5833         add constraint FK88F1805ABC5DA539
5834         foreign key (updatedby_id)
5835         references UserAccount;
5836
5837     alter table Marker_AUD
5838         add constraint FKB951F12B34869AAE
5839         foreign key (REV)
5840         references AuditEvent;
5841
5842     alter table Media
5843         add constraint FK46C7FC44FF2DB2C
5844         foreign key (createdby_id)
5845         references UserAccount;
5846
5847     alter table Media
5848         add constraint FK46C7FC4C2445443
5849         foreign key (artist_id)
5850         references AgentBase;
5851
5852     alter table Media
5853         add constraint FK46C7FC49803512F
5854         foreign key (citation_id)
5855         references ReferenceBase;
5856
5857     alter table Media
5858         add constraint FK46C7FC4BC5DA539
5859         foreign key (updatedby_id)
5860         references UserAccount;
5861
5862     alter table MediaRepresentation
5863         add constraint FK1966BDB14FF2DB2C
5864         foreign key (createdby_id)
5865         references UserAccount;
5866
5867     alter table MediaRepresentation
5868         add constraint FK1966BDB1C2C29593
5869         foreign key (media_id)
5870         references Media;
5871
5872     alter table MediaRepresentation
5873         add constraint FK1966BDB1BC5DA539
5874         foreign key (updatedby_id)
5875         references UserAccount;
5876
5877     alter table MediaRepresentationPart
5878         add constraint FK67A45544E3818E37
5879         foreign key (representation_id)
5880         references MediaRepresentation;
5881
5882     alter table MediaRepresentationPart
5883         add constraint FK67A455444FF2DB2C
5884         foreign key (createdby_id)
5885         references UserAccount;
5886
5887     alter table MediaRepresentationPart
5888         add constraint FK67A45544BC5DA539
5889         foreign key (updatedby_id)
5890         references UserAccount;
5891
5892     alter table MediaRepresentationPart_AUD
5893         add constraint FKA75C411534869AAE
5894         foreign key (REV)
5895         references AuditEvent;
5896
5897     alter table MediaRepresentation_AUD
5898         add constraint FK67AAAB0234869AAE
5899         foreign key (REV)
5900         references AuditEvent;
5901
5902     alter table MediaRepresentation_MediaRepresentationPart_AUD
5903         add constraint FK3544378734869AAE
5904         foreign key (REV)
5905         references AuditEvent;
5906
5907     alter table Media_AUD
5908         add constraint FKF70B2B9534869AAE
5909         foreign key (REV)
5910         references AuditEvent;
5911
5912     alter table Media_Annotation
5913         add constraint FKA020DAAAC2C29593
5914         foreign key (Media_id)
5915         references Media;
5916
5917     alter table Media_Annotation
5918         add constraint FKA020DAAA1E403E0B
5919         foreign key (annotations_id)
5920         references Annotation;
5921
5922     alter table Media_Annotation_AUD
5923         add constraint FK99ABA37B34869AAE
5924         foreign key (REV)
5925         references AuditEvent;
5926
5927     alter table Media_DefinedTermBase
5928         add constraint FK96F1D7EB8A6C9D18
5929         foreign key (Media_id)
5930         references Media;
5931
5932     alter table Media_DefinedTermBase
5933         add constraint FK96F1D7EB86D04E74
5934         foreign key (geoscopes_id)
5935         references DefinedTermBase;
5936
5937     alter table Media_DefinedTermBase_AUD
5938         add constraint FK994A183C34869AAE
5939         foreign key (REV)
5940         references AuditEvent;
5941
5942     alter table Media_Description
5943         add constraint FK368283E1C2C29593
5944         foreign key (Media_id)
5945         references Media;
5946
5947     alter table Media_Description
5948         add constraint FK368283E12BEBA58D
5949         foreign key (description_id)
5950         references LanguageString;
5951
5952     alter table Media_Description
5953         add constraint FK368283E128459272
5954         foreign key (description_mapkey_id)
5955         references DefinedTermBase;
5956
5957     alter table Media_Description_AUD
5958         add constraint FK6817D93234869AAE
5959         foreign key (REV)
5960         references AuditEvent;
5961
5962     alter table Media_LanguageString
5963         add constraint FK353DB784A0A6EDCE
5964         foreign key (title_mapkey_id)
5965         references DefinedTermBase;
5966
5967     alter table Media_LanguageString
5968         add constraint FK353DB784C2C29593
5969         foreign key (Media_id)
5970         references Media;
5971
5972     alter table Media_LanguageString
5973         add constraint FK353DB784A1CA19B1
5974         foreign key (title_id)
5975         references LanguageString;
5976
5977     alter table Media_LanguageString_AUD
5978         add constraint FK68FA835534869AAE
5979         foreign key (REV)
5980         references AuditEvent;
5981
5982     alter table Media_Marker
5983         add constraint FKD21E7935C2C29593
5984         foreign key (Media_id)
5985         references Media;
5986
5987     alter table Media_Marker
5988         add constraint FKD21E7935777265A1
5989         foreign key (markers_id)
5990         references Marker;
5991
5992     alter table Media_Marker_AUD
5993         add constraint FK3F51048634869AAE
5994         foreign key (REV)
5995         references AuditEvent;
5996
5997     alter table Media_Rights
5998         add constraint FKDB1266D2C2C29593
5999         foreign key (Media_id)
6000         references Media;
6001
6002     alter table Media_Rights
6003         add constraint FKDB1266D2C13F7B21
6004         foreign key (rights_id)
6005         references Rights;
6006
6007     alter table Media_Rights_AUD
6008         add constraint FKAB2ADBA334869AAE
6009         foreign key (REV)
6010         references AuditEvent;
6011
6012     alter table Media_Sequence
6013         add constraint FK61D09FC3282B64
6014         foreign key (Media_id)
6015         references Media;
6016
6017     alter table Media_Sequence
6018         add constraint FK61D09FCF29B4761
6019         foreign key (usedsequences_id)
6020         references Sequence;
6021
6022     alter table Media_Sequence_AUD
6023         add constraint FK3C7BD9CD34869AAE
6024         foreign key (REV)
6025         references AuditEvent;
6026
6027     alter table Media_TaxonBase
6028         add constraint FK1ABD49E07C3D0017
6029         foreign key (coveredtaxa_id)
6030         references TaxonBase;
6031
6032     alter table Media_TaxonBase
6033         add constraint FK1ABD49E08A6C9D18
6034         foreign key (Media_id)
6035         references Media;
6036
6037     alter table Media_TaxonBase_AUD
6038         add constraint FK857187B134869AAE
6039         foreign key (REV)
6040         references AuditEvent;
6041
6042     alter table NameRelationship
6043         add constraint FK5E5108316CDFF85
6044         foreign key (relatedfrom_id)
6045         references TaxonNameBase;
6046
6047     alter table NameRelationship
6048         add constraint FK5E5108328482454
6049         foreign key (relatedto_id)
6050         references TaxonNameBase;
6051
6052     alter table NameRelationship
6053         add constraint FK5E510834FF2DB2C
6054         foreign key (createdby_id)
6055         references UserAccount;
6056
6057     alter table NameRelationship
6058         add constraint FK5E51083AF619DE3
6059         foreign key (type_id)
6060         references DefinedTermBase;
6061
6062     alter table NameRelationship
6063         add constraint FK5E510839803512F
6064         foreign key (citation_id)
6065         references ReferenceBase;
6066
6067     alter table NameRelationship
6068         add constraint FK5E51083BC5DA539
6069         foreign key (updatedby_id)
6070         references UserAccount;
6071
6072     alter table NameRelationship_AUD
6073         add constraint FK743F44D434869AAE
6074         foreign key (REV)
6075         references AuditEvent;
6076
6077     alter table NameRelationship_Annotation
6078         add constraint FK2E38AC8B7B4CB560
6079         foreign key (NameRelationship_id)
6080         references NameRelationship;
6081
6082     alter table NameRelationship_Annotation
6083         add constraint FK2E38AC8B1E403E0B
6084         foreign key (annotations_id)
6085         references Annotation;
6086
6087     alter table NameRelationship_Annotation_AUD
6088         add constraint FKD1D59CDC34869AAE
6089         foreign key (REV)
6090         references AuditEvent;
6091
6092     alter table NameRelationship_Marker
6093         add constraint FKE3E463967B4CB560
6094         foreign key (NameRelationship_id)
6095         references NameRelationship;
6096
6097     alter table NameRelationship_Marker
6098         add constraint FKE3E46396777265A1
6099         foreign key (markers_id)
6100         references Marker;
6101
6102     alter table NameRelationship_Marker_AUD
6103         add constraint FKCD68D66734869AAE
6104         foreign key (REV)
6105         references AuditEvent;
6106
6107     alter table NomenclaturalStatus
6108         add constraint FK1FFEC88B4FF2DB2C
6109         foreign key (createdby_id)
6110         references UserAccount;
6111
6112     alter table NomenclaturalStatus
6113         add constraint FK1FFEC88B7029BD9F
6114         foreign key (type_id)
6115         references DefinedTermBase;
6116
6117     alter table NomenclaturalStatus
6118         add constraint FK1FFEC88B9803512F
6119         foreign key (citation_id)
6120         references ReferenceBase;
6121
6122     alter table NomenclaturalStatus
6123         add constraint FK1FFEC88BBC5DA539
6124         foreign key (updatedby_id)
6125         references UserAccount;
6126
6127     alter table NomenclaturalStatus_AUD
6128         add constraint FKFB2DB8DC34869AAE
6129         foreign key (REV)
6130         references AuditEvent;
6131
6132     alter table NomenclaturalStatus_Annotation
6133         add constraint FKE6E91F838D2CB1D4
6134         foreign key (NomenclaturalStatus_id)
6135         references NomenclaturalStatus;
6136
6137     alter table NomenclaturalStatus_Annotation
6138         add constraint FKE6E91F831E403E0B
6139         foreign key (annotations_id)
6140         references Annotation;
6141
6142     alter table NomenclaturalStatus_Annotation_AUD
6143         add constraint FK6A3D3D434869AAE
6144         foreign key (REV)
6145         references AuditEvent;
6146
6147     alter table NomenclaturalStatus_Marker
6148         add constraint FK2F5128E8D2CB1D4
6149         foreign key (NomenclaturalStatus_id)
6150         references NomenclaturalStatus;
6151
6152     alter table NomenclaturalStatus_Marker
6153         add constraint FK2F5128E777265A1
6154         foreign key (markers_id)
6155         references Marker;
6156
6157     alter table NomenclaturalStatus_Marker_AUD
6158         add constraint FK8619495F34869AAE
6159         foreign key (REV)
6160         references AuditEvent;
6161
6162     alter table OriginalSource
6163         add constraint FK229A496C4FF2DB2C
6164         foreign key (createdby_id)
6165         references UserAccount;
6166
6167     alter table OriginalSource
6168         add constraint FK229A496C9803512F
6169         foreign key (citation_id)
6170         references ReferenceBase;
6171
6172     alter table OriginalSource
6173         add constraint FK229A496CBC5DA539
6174         foreign key (updatedby_id)
6175         references UserAccount;
6176
6177     alter table OriginalSource_AUD
6178         add constraint FK506BE13D34869AAE
6179         foreign key (REV)
6180         references AuditEvent;
6181
6182     alter table OriginalSource_Annotation
6183         add constraint FK5B3FF802DC2DCA20
6184         foreign key (OriginalSource_id)
6185         references OriginalSource;
6186
6187     alter table OriginalSource_Annotation
6188         add constraint FK5B3FF8021E403E0B
6189         foreign key (annotations_id)
6190         references Annotation;
6191
6192     alter table OriginalSource_Annotation_AUD
6193         add constraint FK4ACC54D334869AAE
6194         foreign key (REV)
6195         references AuditEvent;
6196
6197     alter table OriginalSource_Marker
6198         add constraint FKCF52028DDC2DCA20
6199         foreign key (OriginalSource_id)
6200         references OriginalSource;
6201
6202     alter table OriginalSource_Marker
6203         add constraint FKCF52028D777265A1
6204         foreign key (markers_id)
6205         references Marker;
6206
6207     alter table OriginalSource_Marker_AUD
6208         add constraint FKFA7021DE34869AAE
6209         foreign key (REV)
6210         references AuditEvent;
6211
6212     alter table PermissionGroup
6213         add constraint FK629941D04FF2DB2C
6214         foreign key (createdby_id)
6215         references UserAccount;
6216
6217     alter table PermissionGroup_GrantedAuthorityImpl
6218         add constraint FK5311437CA0971A3
6219         foreign key (PermissionGroup_id)
6220         references PermissionGroup;
6221
6222     alter table PermissionGroup_GrantedAuthorityImpl
6223         add constraint FK53114371857F6C2
6224         foreign key (grantedauthorities_id)
6225         references GrantedAuthorityImpl;
6226
6227     alter table Person_Keyword
6228         add constraint FK5F559EFF13A443BE
6229         foreign key (keyword_fk)
6230         references DefinedTermBase;
6231
6232     alter table Person_Keyword
6233         add constraint FK5F559EFFAAC1B7CA
6234         foreign key (person_fk)
6235         references AgentBase;
6236
6237     alter table Person_Keyword_AUD
6238         add constraint FK6D8C355034869AAE
6239         foreign key (REV)
6240         references AuditEvent;
6241
6242     alter table Publisher
6243         add constraint FKCDB7C1DC4FF2DB2C
6244         foreign key (createdby_id)
6245         references UserAccount;
6246
6247     alter table Publisher_AUD
6248         add constraint FKC637A1AD34869AAE
6249         foreign key (REV)
6250         references AuditEvent;
6251
6252     create index ReferenceBaseTitleCacheIndex on ReferenceBase (titleCache);
6253
6254     alter table ReferenceBase
6255         add constraint FK8F034C9C1A488155
6256         foreign key (inbook_id)
6257         references ReferenceBase;
6258
6259     alter table ReferenceBase
6260         add constraint FK8F034C9C4FF2DB2C
6261         foreign key (createdby_id)
6262         references UserAccount;
6263
6264     alter table ReferenceBase
6265         add constraint FK8F034C9C403E17F4
6266         foreign key (institution_id)
6267         references AgentBase;
6268
6269     alter table ReferenceBase
6270         add constraint FK8F034C9CCCE9AAE2
6271         foreign key (inseries_id)
6272         references ReferenceBase;
6273
6274     alter table ReferenceBase
6275         add constraint FK8F034C9CD893F6E6
6276         foreign key (crossref_id)
6277         references ReferenceBase;
6278
6279     alter table ReferenceBase
6280         add constraint FK8F034C9CAEC3B8B8
6281         foreign key (school_id)
6282         references AgentBase;
6283
6284     alter table ReferenceBase
6285         add constraint FK8F034C9CE3A02620
6286         foreign key (type_id)
6287         references DefinedTermBase;
6288
6289     alter table ReferenceBase
6290         add constraint FK8F034C9CE87E60BF
6291         foreign key (inproceedings_id)
6292         references ReferenceBase;
6293
6294     alter table ReferenceBase
6295         add constraint FK8F034C9CE019003F
6296         foreign key (injournal_id)
6297         references ReferenceBase;
6298
6299     alter table ReferenceBase
6300         add constraint FK8F034C9C697665E
6301         foreign key (authorteam_id)
6302         references AgentBase;
6303
6304     alter table ReferenceBase
6305         add constraint FK8F034C9CBC5DA539
6306         foreign key (updatedby_id)
6307         references UserAccount;
6308
6309     alter table ReferenceBase_AUD
6310         add constraint FK8D3FCC6D34869AAE
6311         foreign key (REV)
6312         references AuditEvent;
6313
6314     alter table ReferenceBase_Annotation
6315         add constraint FKC97616D2F443DB5A
6316         foreign key (ReferenceBase_id)
6317         references ReferenceBase;
6318
6319     alter table ReferenceBase_Annotation
6320         add constraint FKC97616D21E403E0B
6321         foreign key (annotations_id)
6322         references Annotation;
6323
6324     alter table ReferenceBase_Annotation_AUD
6325         add constraint FK60368BA334869AAE
6326         foreign key (REV)
6327         references AuditEvent;
6328
6329     alter table ReferenceBase_Credit
6330         add constraint FK5861201CF443DB5A
6331         foreign key (ReferenceBase_id)
6332         references ReferenceBase;
6333
6334     alter table ReferenceBase_Credit
6335         add constraint FK5861201C32D1B9F
6336         foreign key (credits_id)
6337         references Credit;
6338
6339     alter table ReferenceBase_Credit_AUD
6340         add constraint FK487DFED34869AAE
6341         foreign key (REV)
6342         references AuditEvent;
6343
6344     alter table ReferenceBase_Extension
6345         add constraint FK81E1703C927DE9DF
6346         foreign key (extensions_id)
6347         references Extension;
6348
6349     alter table ReferenceBase_Extension
6350         add constraint FK81E1703CF443DB5A
6351         foreign key (ReferenceBase_id)
6352         references ReferenceBase;
6353
6354     alter table ReferenceBase_Extension_AUD
6355         add constraint FKD723200D34869AAE
6356         foreign key (REV)
6357         references AuditEvent;
6358
6359     alter table ReferenceBase_Marker
6360         add constraint FK6888095DF443DB5A
6361         foreign key (ReferenceBase_id)
6362         references ReferenceBase;
6363
6364     alter table ReferenceBase_Marker
6365         add constraint FK6888095D777265A1
6366         foreign key (markers_id)
6367         references Marker;
6368
6369     alter table ReferenceBase_Marker_AUD
6370         add constraint FK68A640AE34869AAE
6371         foreign key (REV)
6372         references AuditEvent;
6373
6374     alter table ReferenceBase_Media
6375         add constraint FK3D2F4A61C2C29593
6376         foreign key (media_id)
6377         references Media;
6378
6379     alter table ReferenceBase_Media
6380         add constraint FK3D2F4A61F443DB5A
6381         foreign key (ReferenceBase_id)
6382         references ReferenceBase;
6383
6384     alter table ReferenceBase_Media_AUD
6385         add constraint FK25FD5FB234869AAE
6386         foreign key (REV)
6387         references AuditEvent;
6388
6389     alter table ReferenceBase_OriginalSource
6390         add constraint FK68651F6F3BAB2414
6391         foreign key (sources_id)
6392         references OriginalSource;
6393
6394     alter table ReferenceBase_OriginalSource
6395         add constraint FK68651F6FF443DB5A
6396         foreign key (ReferenceBase_id)
6397         references ReferenceBase;
6398
6399     alter table ReferenceBase_OriginalSource_AUD
6400         add constraint FK6905FDC034869AAE
6401         foreign key (REV)
6402         references AuditEvent;
6403
6404     alter table ReferenceBase_Rights
6405         add constraint FK717BF6FAF443DB5A
6406         foreign key (ReferenceBase_id)
6407         references ReferenceBase;
6408
6409     alter table ReferenceBase_Rights
6410         add constraint FK717BF6FAC13F7B21
6411         foreign key (rights_id)
6412         references Rights;
6413
6414     alter table ReferenceBase_Rights_AUD
6415         add constraint FKD48017CB34869AAE
6416         foreign key (REV)
6417         references AuditEvent;
6418
6419     alter table RelationshipTermBase_inverseRepresentation
6420         add constraint FK98592F33ECEEF4AF
6421         foreign key (DefinedTermBase_id)
6422         references DefinedTermBase;
6423
6424     alter table RelationshipTermBase_inverseRepresentation
6425         add constraint FK98592F33473FB677
6426         foreign key (inverserepresentations_id)
6427         references Representation;
6428
6429     alter table RelationshipTermBase_inverseRepresentation_AUD
6430         add constraint FK5D248B8434869AAE
6431         foreign key (REV)
6432         references AuditEvent;
6433
6434     alter table Representation
6435         add constraint FK9C4724ED4FF2DB2C
6436         foreign key (createdby_id)
6437         references UserAccount;
6438
6439     alter table Representation
6440         add constraint FK9C4724EDBC5DA539
6441         foreign key (updatedby_id)
6442         references UserAccount;
6443
6444     alter table Representation
6445         add constraint FK9C4724EDE8D36B00
6446         foreign key (language_id)
6447         references DefinedTermBase;
6448
6449     alter table Representation_AUD
6450         add constraint FK294D143E34869AAE
6451         foreign key (REV)
6452         references AuditEvent;
6453
6454     alter table Representation_Annotation
6455         add constraint FK371091E147E8AE60
6456         foreign key (Representation_id)
6457         references Representation;
6458
6459     alter table Representation_Annotation
6460         add constraint FK371091E11E403E0B
6461         foreign key (annotations_id)
6462         references Annotation;
6463
6464     alter table Representation_Annotation_AUD
6465         add constraint FK36EEE73234869AAE
6466         foreign key (REV)
6467         references AuditEvent;
6468
6469     alter table Representation_Marker
6470         add constraint FK560063EC47E8AE60
6471         foreign key (Representation_id)
6472         references Representation;
6473
6474     alter table Representation_Marker
6475         add constraint FK560063EC777265A1
6476         foreign key (markers_id)
6477         references Marker;
6478
6479     alter table Representation_Marker_AUD
6480         add constraint FKD640BBBD34869AAE
6481         foreign key (REV)
6482         references AuditEvent;
6483
6484     alter table Rights
6485         add constraint FK91E56DF7F7976FC5
6486         foreign key (agent_id)
6487         references AgentBase;
6488
6489     alter table Rights
6490         add constraint FK91E56DF74FF2DB2C
6491         foreign key (createdby_id)
6492         references UserAccount;
6493
6494     alter table Rights
6495         add constraint FK91E56DF7E6D2886A
6496         foreign key (type_id)
6497         references DefinedTermBase;
6498
6499     alter table Rights
6500         add constraint FK91E56DF7BC5DA539
6501         foreign key (updatedby_id)
6502         references UserAccount;
6503
6504     alter table Rights
6505         add constraint FK91E56DF7E8D36B00
6506         foreign key (language_id)
6507         references DefinedTermBase;
6508
6509     alter table Rights_AUD
6510         add constraint FK252BC84834869AAE
6511         foreign key (REV)
6512         references AuditEvent;
6513
6514     alter table Rights_Annotation
6515         add constraint FK27CB1E97C13F7B21
6516         foreign key (Rights_id)
6517         references Rights;
6518
6519     alter table Rights_Annotation
6520         add constraint FK27CB1E971E403E0B
6521         foreign key (annotations_id)
6522         references Annotation;
6523
6524     alter table Rights_Annotation_AUD
6525         add constraint FKF98828E834869AAE
6526         foreign key (REV)
6527         references AuditEvent;
6528
6529     alter table Rights_Marker
6530         add constraint FKB739BBA2C13F7B21
6531         foreign key (Rights_id)
6532         references Rights;
6533
6534     alter table Rights_Marker
6535         add constraint FKB739BBA2777265A1
6536         foreign key (markers_id)
6537         references Marker;
6538
6539     alter table Rights_Marker_AUD
6540         add constraint FKC6FB487334869AAE
6541         foreign key (REV)
6542         references AuditEvent;
6543
6544     create index sequenceTitleCacheIndex on Sequence (titleCache);
6545
6546     alter table Sequence
6547         add constraint FK544ADBE14FF2DB2C
6548         foreign key (createdby_id)
6549         references UserAccount;
6550
6551     alter table Sequence
6552         add constraint FK544ADBE1B982A103
6553         foreign key (publishedin_id)
6554         references ReferenceBase;
6555
6556     alter table Sequence
6557         add constraint FK544ADBE12DBE1F1F
6558         foreign key (locus_id)
6559         references Locus;
6560
6561     alter table Sequence
6562         add constraint FK544ADBE1BC5DA539
6563         foreign key (updatedby_id)
6564         references UserAccount;
6565
6566     alter table Sequence_AUD
6567         add constraint FK39F4313234869AAE
6568         foreign key (REV)
6569         references AuditEvent;
6570
6571     alter table Sequence_Annotation
6572         add constraint FK1010BA6D1E403E0B
6573         foreign key (annotations_id)
6574         references Annotation;
6575
6576     alter table Sequence_Annotation
6577         add constraint FK1010BA6DD57FFDD5
6578         foreign key (Sequence_id)
6579         references Sequence;
6580
6581     alter table Sequence_Annotation_AUD
6582         add constraint FKCB4FE9BE34869AAE
6583         foreign key (REV)
6584         references AuditEvent;
6585
6586     alter table Sequence_Credit
6587         add constraint FK2CFBC93732D1B9F
6588         foreign key (credits_id)
6589         references Credit;
6590
6591     alter table Sequence_Credit
6592         add constraint FK2CFBC937D57FFDD5
6593         foreign key (Sequence_id)
6594         references Sequence;
6595
6596     alter table Sequence_Credit_AUD
6597         add constraint FK4B22838834869AAE
6598         foreign key (REV)
6599         references AuditEvent;
6600
6601     alter table Sequence_Extension
6602         add constraint FK7BE66D41927DE9DF
6603         foreign key (extensions_id)
6604         references Extension;
6605
6606     alter table Sequence_Extension
6607         add constraint FK7BE66D41D57FFDD5
6608         foreign key (Sequence_id)
6609         references Sequence;
6610
6611     alter table Sequence_Extension_AUD
6612         add constraint FK1CA8129234869AAE
6613         foreign key (REV)
6614         references AuditEvent;
6615
6616     alter table Sequence_GenBankAccession
6617         add constraint FK8F69809615C4EF35
6618         foreign key (genbankaccession_id)
6619         references GenBankAccession;
6620
6621     alter table Sequence_GenBankAccession
6622         add constraint FK8F698096D57FFDD5
6623         foreign key (Sequence_id)
6624         references Sequence;
6625
6626     alter table Sequence_GenBankAccession_AUD
6627         add constraint FKC717736734869AAE
6628         foreign key (REV)
6629         references AuditEvent;
6630
6631     alter table Sequence_Marker
6632         add constraint FK3D22B278777265A1
6633         foreign key (markers_id)
6634         references Marker;
6635
6636     alter table Sequence_Marker
6637         add constraint FK3D22B278D57FFDD5
6638         foreign key (Sequence_id)
6639         references Sequence;
6640
6641     alter table Sequence_Marker_AUD
6642         add constraint FKAF40E44934869AAE
6643         foreign key (REV)
6644         references AuditEvent;
6645
6646     alter table Sequence_Media
6647         add constraint FK8E5D91E666ACA7EC
6648         foreign key (chromatograms_id)
6649         references Media;
6650
6651     alter table Sequence_Media
6652         add constraint FK8E5D91E6D57FFDD5
6653         foreign key (Sequence_id)
6654         references Sequence;
6655
6656     alter table Sequence_Media_AUD
6657         add constraint FK20025CB734869AAE
6658         foreign key (REV)
6659         references AuditEvent;
6660
6661     alter table Sequence_OriginalSource
6662         add constraint FKD37E7D8A3BAB2414
6663         foreign key (sources_id)
6664         references OriginalSource;
6665
6666     alter table Sequence_OriginalSource
6667         add constraint FKD37E7D8AD57FFDD5
6668         foreign key (Sequence_id)
6669         references Sequence;
6670
6671     alter table Sequence_OriginalSource_AUD
6672         add constraint FKCDBCD65B34869AAE
6673         foreign key (REV)
6674         references AuditEvent;
6675
6676     alter table Sequence_ReferenceBase
6677         add constraint FK18D91CBE7291F8A
6678         foreign key (citations_id)
6679         references ReferenceBase;
6680
6681     alter table Sequence_ReferenceBase
6682         add constraint FK18D91CBED57FFDD5
6683         foreign key (Sequence_id)
6684         references Sequence;
6685
6686     alter table Sequence_ReferenceBase_AUD
6687         add constraint FK998CBB8F34869AAE
6688         foreign key (REV)
6689         references AuditEvent;
6690
6691     alter table Sequence_Rights
6692         add constraint FK4616A015C13F7B21
6693         foreign key (rights_id)
6694         references Rights;
6695
6696     alter table Sequence_Rights
6697         add constraint FK4616A015D57FFDD5
6698         foreign key (Sequence_id)
6699         references Sequence;
6700
6701     alter table Sequence_Rights_AUD
6702         add constraint FK1B1ABB6634869AAE
6703         foreign key (REV)
6704         references AuditEvent;
6705
6706     create index specimenOrObservationBaseTitleCacheIndex on SpecimenOrObservationBase (titleCache);
6707
6708     alter table SpecimenOrObservationBase
6709         add constraint FK21CA3272C8505DB
6710         foreign key (preservation_id)
6711         references DefinedTermBase;
6712
6713     alter table SpecimenOrObservationBase
6714         add constraint FK21CA32724FF2DB2C
6715         foreign key (createdby_id)
6716         references UserAccount;
6717
6718     alter table SpecimenOrObservationBase
6719         add constraint FK21CA32727CC340C5
6720         foreign key (storedunder_id)
6721         references TaxonNameBase;
6722
6723     alter table SpecimenOrObservationBase
6724         add constraint FK21CA3272EB62BE9A
6725         foreign key (collection_id)
6726         references Collection;
6727
6728     alter table SpecimenOrObservationBase
6729         add constraint FK21CA3272E17C9A6B
6730         foreign key (sex_id)
6731         references DefinedTermBase;
6732
6733     alter table SpecimenOrObservationBase
6734         add constraint FK21CA32728C750E27
6735         foreign key (lifestage_id)
6736         references DefinedTermBase;
6737
6738     alter table SpecimenOrObservationBase
6739         add constraint FK21CA32724AAB411A
6740         foreign key (derivationevent_id)
6741         references DerivationEvent;
6742
6743     alter table SpecimenOrObservationBase
6744         add constraint FK21CA3272F95F225A
6745         foreign key (gatheringevent_id)
6746         references GatheringEvent;
6747
6748     alter table SpecimenOrObservationBase
6749         add constraint FK21CA3272BC5DA539
6750         foreign key (updatedby_id)
6751         references UserAccount;
6752
6753     alter table SpecimenOrObservationBase_AUD
6754         add constraint FKF3D3D74334869AAE
6755         foreign key (REV)
6756         references AuditEvent;
6757
6758     alter table SpecimenOrObservationBase_Annotation
6759         add constraint FK365E4F3C3B8A5ABA
6760         foreign key (SpecimenOrObservationBase_id)
6761         references SpecimenOrObservationBase;
6762
6763     alter table SpecimenOrObservationBase_Annotation
6764         add constraint FK365E4F3C1E403E0B
6765         foreign key (annotations_id)
6766         references Annotation;
6767
6768     alter table SpecimenOrObservationBase_Annotation_AUD
6769         add constraint FK34187F0D34869AAE
6770         foreign key (REV)
6771         references AuditEvent;
6772
6773     alter table SpecimenOrObservationBase_Credit
6774         add constraint FK7E3A1D863B8A5ABA
6775         foreign key (SpecimenOrObservationBase_id)
6776         references SpecimenOrObservationBase;
6777
6778     alter table SpecimenOrObservationBase_Credit
6779         add constraint FK7E3A1D8632D1B9F
6780         foreign key (credits_id)
6781         references Credit;
6782
6783     alter table SpecimenOrObservationBase_Credit_AUD
6784         add constraint FK7170185734869AAE
6785         foreign key (REV)
6786         references AuditEvent;
6787
6788     alter table SpecimenOrObservationBase_DerivationEvent
6789         add constraint FK20132036BD59A1AD
6790         foreign key (derivationevents_id)
6791         references DerivationEvent;
6792
6793     alter table SpecimenOrObservationBase_DerivationEvent
6794         add constraint FK2013203654C216AA
6795         foreign key (originals_id)
6796         references SpecimenOrObservationBase;
6797
6798     alter table SpecimenOrObservationBase_DerivationEvent_AUD
6799         add constraint FKA4A8430734869AAE
6800         foreign key (REV)
6801         references AuditEvent;
6802
6803     alter table SpecimenOrObservationBase_Extension
6804         add constraint FKE03B82923B8A5ABA
6805         foreign key (SpecimenOrObservationBase_id)
6806         references SpecimenOrObservationBase;
6807
6808     alter table SpecimenOrObservationBase_Extension
6809         add constraint FKE03B8292927DE9DF
6810         foreign key (extensions_id)
6811         references Extension;
6812
6813     alter table SpecimenOrObservationBase_Extension_AUD
6814         add constraint FK7AE0176334869AAE
6815         foreign key (REV)
6816         references AuditEvent;
6817
6818     alter table SpecimenOrObservationBase_LanguageString
6819         add constraint FKCFAA93163B8A5ABA
6820         foreign key (SpecimenOrObservationBase_id)
6821         references SpecimenOrObservationBase;
6822
6823     alter table SpecimenOrObservationBase_LanguageString
6824         add constraint FKCFAA93162BEBA58D
6825         foreign key (description_id)
6826         references LanguageString;
6827
6828     alter table SpecimenOrObservationBase_LanguageString
6829         add constraint FKCFAA931628459272
6830         foreign key (description_mapkey_id)
6831         references DefinedTermBase;
6832
6833     alter table SpecimenOrObservationBase_LanguageString_AUD
6834         add constraint FK38B45E734869AAE
6835         foreign key (REV)
6836         references AuditEvent;
6837
6838     alter table SpecimenOrObservationBase_Marker
6839         add constraint FK8E6106C73B8A5ABA
6840         foreign key (SpecimenOrObservationBase_id)
6841         references SpecimenOrObservationBase;
6842
6843     alter table SpecimenOrObservationBase_Marker
6844         add constraint FK8E6106C7777265A1
6845         foreign key (markers_id)
6846         references Marker;
6847
6848     alter table SpecimenOrObservationBase_Marker_AUD
6849         add constraint FKD58E791834869AAE
6850         foreign key (REV)
6851         references AuditEvent;
6852
6853     alter table SpecimenOrObservationBase_Media
6854         add constraint FK4EEBF7B73B8A5ABA
6855         foreign key (SpecimenOrObservationBase_id)
6856         references SpecimenOrObservationBase;
6857
6858     alter table SpecimenOrObservationBase_Media
6859         add constraint FK4EEBF7B7C2C29593
6860         foreign key (media_id)
6861         references Media;
6862
6863     alter table SpecimenOrObservationBase_Media_AUD
6864         add constraint FK8457720834869AAE
6865         foreign key (REV)
6866         references AuditEvent;
6867
6868     alter table SpecimenOrObservationBase_OriginalSource
6869         add constraint FK3C4712D93B8A5ABA
6870         foreign key (SpecimenOrObservationBase_id)
6871         references SpecimenOrObservationBase;
6872
6873     alter table SpecimenOrObservationBase_OriginalSource
6874         add constraint FK3C4712D93BAB2414
6875         foreign key (sources_id)
6876         references OriginalSource;
6877
6878     alter table SpecimenOrObservationBase_OriginalSource_AUD
6879         add constraint FKCA8C2C2A34869AAE
6880         foreign key (REV)
6881         references AuditEvent;
6882
6883     alter table SpecimenOrObservationBase_Rights
6884         add constraint FK9754F4643B8A5ABA
6885         foreign key (SpecimenOrObservationBase_id)
6886         references SpecimenOrObservationBase;
6887
6888     alter table SpecimenOrObservationBase_Rights
6889         add constraint FK9754F464C13F7B21
6890         foreign key (rights_id)
6891         references Rights;
6892
6893     alter table SpecimenOrObservationBase_Rights_AUD
6894         add constraint FK4168503534869AAE
6895         foreign key (REV)
6896         references AuditEvent;
6897
6898     alter table SpecimenOrObservationBase_Sequence
6899         add constraint FKBBF27B0E7EE2770E
6900         foreign key (SpecimenOrObservationBase_id)
6901         references SpecimenOrObservationBase;
6902
6903     alter table SpecimenOrObservationBase_Sequence
6904         add constraint FKBBF27B0E35B10F24
6905         foreign key (sequences_id)
6906         references Sequence;
6907
6908     alter table SpecimenOrObservationBase_Sequence_AUD
6909         add constraint FK392E71DF34869AAE
6910         foreign key (REV)
6911         references AuditEvent;
6912
6913     alter table StateData
6914         add constraint FKFB1697BB4FF2DB2C
6915         foreign key (createdby_id)
6916         references UserAccount;
6917
6918     alter table StateData
6919         add constraint FKFB1697BB682A4E4B
6920         foreign key (state_id)
6921         references DefinedTermBase;
6922
6923     alter table StateData
6924         add constraint FKFB1697BBBC5DA539
6925         foreign key (updatedby_id)
6926         references UserAccount;
6927
6928     alter table StateData_AUD
6929         add constraint FKDA6A700C34869AAE
6930         foreign key (REV)
6931         references AuditEvent;
6932
6933     alter table StateData_DefinedTermBase
6934         add constraint FK107321E28E7BF9AB
6935         foreign key (StateData_id)
6936         references StateData;
6937
6938     alter table StateData_DefinedTermBase
6939         add constraint FK107321E2E0960EC4
6940         foreign key (modifiers_id)
6941         references DefinedTermBase;
6942
6943     alter table StateData_DefinedTermBase_AUD
6944         add constraint FK7C978EB334869AAE
6945         foreign key (REV)
6946         references AuditEvent;
6947
6948     alter table StateData_LanguageString
6949         add constraint FK93FFD2AD8E7BF9AB
6950         foreign key (StateData_id)
6951         references StateData;
6952
6953     alter table StateData_LanguageString
6954         add constraint FK93FFD2ADF05D08D4
6955         foreign key (modifyingtext_id)
6956         references LanguageString;
6957
6958     alter table StateData_LanguageString
6959         add constraint FK93FFD2AD9682414B
6960         foreign key (modifyingtext_mapkey_id)
6961         references DefinedTermBase;
6962
6963     alter table StateData_LanguageString_AUD
6964         add constraint FK1578E1FE34869AAE
6965         foreign key (REV)
6966         references AuditEvent;
6967
6968     alter table StatisticalMeasurementValue
6969         add constraint FK2DCE02904FF2DB2C
6970         foreign key (createdby_id)
6971         references UserAccount;
6972
6973     alter table StatisticalMeasurementValue
6974         add constraint FK2DCE02904C428112
6975         foreign key (type_id)
6976         references DefinedTermBase;
6977
6978     alter table StatisticalMeasurementValue
6979         add constraint FK2DCE0290BC5DA539
6980         foreign key (updatedby_id)
6981         references UserAccount;
6982
6983     alter table StatisticalMeasurementValue_AUD
6984         add constraint FKBB16686134869AAE
6985         foreign key (REV)
6986         references AuditEvent;
6987
6988     alter table StatisticalMeasurementValue_DefinedTermBase
6989         add constraint FK686C42B75C9F4F2B
6990         foreign key (StatisticalMeasurementValue_id)
6991         references StatisticalMeasurementValue;
6992
6993     alter table StatisticalMeasurementValue_DefinedTermBase
6994         add constraint FK686C42B7E0960EC4
6995         foreign key (modifiers_id)
6996         references DefinedTermBase;
6997
6998     alter table StatisticalMeasurementValue_DefinedTermBase_AUD
6999         add constraint FKFEBA3D0834869AAE
7000         foreign key (REV)
7001         references AuditEvent;
7002
7003     alter table SynonymRelationship
7004         add constraint FKF483ADB34BAC703F
7005         foreign key (relatedfrom_id)
7006         references TaxonBase;
7007
7008     alter table SynonymRelationship
7009         add constraint FKF483ADB3F8991B9D
7010         foreign key (relatedto_id)
7011         references TaxonBase;
7012
7013     alter table SynonymRelationship
7014         add constraint FKF483ADB34FF2DB2C
7015         foreign key (createdby_id)
7016         references UserAccount;
7017
7018     alter table SynonymRelationship
7019         add constraint FKF483ADB380924EEC
7020         foreign key (type_id)
7021         references DefinedTermBase;
7022
7023     alter table SynonymRelationship
7024         add constraint FKF483ADB39803512F
7025         foreign key (citation_id)
7026         references ReferenceBase;
7027
7028     alter table SynonymRelationship
7029         add constraint FKF483ADB3BC5DA539
7030         foreign key (updatedby_id)
7031         references UserAccount;
7032
7033     alter table SynonymRelationship_AUD
7034         add constraint FK8AEBCA0434869AAE
7035         foreign key (REV)
7036         references AuditEvent;
7037
7038     alter table SynonymRelationship_Annotation
7039         add constraint FKF494F15B260A8379
7040         foreign key (SynonymRelationship_id)
7041         references SynonymRelationship;
7042
7043     alter table SynonymRelationship_Annotation
7044         add constraint FKF494F15B1E403E0B
7045         foreign key (annotations_id)
7046         references Annotation;
7047
7048     alter table SynonymRelationship_Annotation_AUD
7049         add constraint FKD3E2F9AC34869AAE
7050         foreign key (REV)
7051         references AuditEvent;
7052
7053     alter table SynonymRelationship_Marker
7054         add constraint FK7A439066260A8379
7055         foreign key (SynonymRelationship_id)
7056         references SynonymRelationship;
7057
7058     alter table SynonymRelationship_Marker
7059         add constraint FK7A439066777265A1
7060         foreign key (markers_id)
7061         references Marker;
7062
7063     alter table SynonymRelationship_Marker_AUD
7064         add constraint FK93C51B3734869AAE
7065         foreign key (REV)
7066         references AuditEvent;
7067
7068     create index taxonBaseTitleCacheIndex on TaxonBase (titleCache);
7069
7070     alter table TaxonBase
7071         add constraint FK9249B49B4FF2DB2C
7072         foreign key (createdby_id)
7073         references UserAccount;
7074
7075     alter table TaxonBase
7076         add constraint FK9249B49BDA93512F
7077         foreign key (taxonName_fk)
7078         references TaxonNameBase;
7079
7080     alter table TaxonBase
7081         add constraint FK9249B49B7C7B5AED
7082         foreign key (taxonomicparentcache_id)
7083         references TaxonBase;
7084
7085     alter table TaxonBase
7086         add constraint FK9249B49B5E4A2F85
7087         foreign key (sec_id)
7088         references ReferenceBase;
7089
7090     alter table TaxonBase
7091         add constraint FK9249B49BBC5DA539
7092         foreign key (updatedby_id)
7093         references UserAccount;
7094
7095     alter table TaxonBase_AUD
7096         add constraint FK37041CEC34869AAE
7097         foreign key (REV)
7098         references AuditEvent;
7099
7100     alter table TaxonBase_Annotation
7101         add constraint FK41ED09739C9D39
7102         foreign key (TaxonBase_id)
7103         references TaxonBase;
7104
7105     alter table TaxonBase_Annotation
7106         add constraint FK41ED09731E403E0B
7107         foreign key (annotations_id)
7108         references Annotation;
7109
7110     alter table TaxonBase_Annotation_AUD
7111         add constraint FK8C145C434869AAE
7112         foreign key (REV)
7113         references AuditEvent;
7114
7115     alter table TaxonBase_Credit
7116         add constraint FK4CB48B3D32D1B9F
7117         foreign key (credits_id)
7118         references Credit;
7119
7120     alter table TaxonBase_Credit
7121         add constraint FK4CB48B3D9C9D39
7122         foreign key (TaxonBase_id)
7123         references TaxonBase;
7124
7125     alter table TaxonBase_Credit_AUD
7126         add constraint FK7CFED28E34869AAE
7127         foreign key (REV)
7128         references AuditEvent;
7129
7130     alter table TaxonBase_Extension
7131         add constraint FKF961257B927DE9DF
7132         foreign key (extensions_id)
7133         references Extension;
7134
7135     alter table TaxonBase_Extension
7136         add constraint FKF961257B9C9D39
7137         foreign key (TaxonBase_id)
7138         references TaxonBase;
7139
7140     alter table TaxonBase_Extension_AUD
7141         add constraint FK71381DCC34869AAE
7142         foreign key (REV)
7143         references AuditEvent;
7144
7145     alter table TaxonBase_Marker
7146         add constraint FK5CDB747E9C9D39
7147         foreign key (TaxonBase_id)
7148         references TaxonBase;
7149
7150     alter table TaxonBase_Marker
7151         add constraint FK5CDB747E777265A1
7152         foreign key (markers_id)
7153         references Marker;
7154
7155     alter table TaxonBase_Marker_AUD
7156         add constraint FKE11D334F34869AAE
7157         foreign key (REV)
7158         references AuditEvent;
7159
7160     alter table TaxonBase_OriginalSource
7161         add constraint FK10EFD9903BAB2414
7162         foreign key (sources_id)
7163         references OriginalSource;
7164
7165     alter table TaxonBase_OriginalSource
7166         add constraint FK10EFD9909C9D39
7167         foreign key (TaxonBase_id)
7168         references TaxonBase;
7169
7170     alter table TaxonBase_OriginalSource_AUD
7171         add constraint FKFB74BF6134869AAE
7172         foreign key (REV)
7173         references AuditEvent;
7174
7175     alter table TaxonBase_Rights
7176         add constraint FK65CF621BC13F7B21
7177         foreign key (rights_id)
7178         references Rights;
7179
7180     alter table TaxonBase_Rights
7181         add constraint FK65CF621B9C9D39
7182         foreign key (TaxonBase_id)
7183         references TaxonBase;
7184
7185     alter table TaxonBase_Rights_AUD
7186         add constraint FK4CF70A6C34869AAE
7187         foreign key (REV)
7188         references AuditEvent;
7189
7190     alter table TaxonInteraction_LanguageString
7191         add constraint FK579A1DC02BEBA58D
7192         foreign key (description_id)
7193         references LanguageString;
7194
7195     alter table TaxonInteraction_LanguageString
7196         add constraint FK579A1DC086C86FE0
7197         foreign key (DescriptionElementBase_id)
7198         references DescriptionElementBase;
7199
7200     alter table TaxonInteraction_LanguageString
7201         add constraint FK579A1DC028459272
7202         foreign key (description_mapkey_id)
7203         references DefinedTermBase;
7204
7205     alter table TaxonInteraction_LanguageString_AUD
7206         add constraint FK9E016B9134869AAE
7207         foreign key (REV)
7208         references AuditEvent;
7209
7210     create index taxonNameBaseTitleCacheIndex on TaxonNameBase (titleCache);
7211
7212     alter table TaxonNameBase
7213         add constraint FKB4870C64FF2DB2C
7214         foreign key (createdby_id)
7215         references UserAccount;
7216
7217     alter table TaxonNameBase
7218         add constraint FKB4870C62B4FEDD6
7219         foreign key (basionymauthorteam_id)
7220         references AgentBase;
7221
7222     alter table TaxonNameBase
7223         add constraint FKB4870C64AC9C024
7224         foreign key (nomenclaturalreference_id)
7225         references ReferenceBase;
7226
7227     alter table TaxonNameBase
7228         add constraint FKB4870C6B14B73EF
7229         foreign key (combinationauthorteam_id)
7230         references AgentBase;
7231
7232     alter table TaxonNameBase
7233         add constraint FKB4870C6BFEAE500
7234         foreign key (homotypicalgroup_id)
7235         references HomotypicalGroup;
7236
7237     alter table TaxonNameBase
7238         add constraint FKB4870C662AD57A2
7239         foreign key (excombinationauthorteam_id)
7240         references AgentBase;
7241
7242     alter table TaxonNameBase
7243         add constraint FKB4870C67F90DF03
7244         foreign key (exbasionymauthorteam_id)
7245         references AgentBase;
7246
7247     alter table TaxonNameBase
7248         add constraint FKB4870C6BC5DA539
7249         foreign key (updatedby_id)
7250         references UserAccount;
7251
7252     alter table TaxonNameBase
7253         add constraint FKB4870C6D7BE55A0
7254         foreign key (rank_id)
7255         references DefinedTermBase;
7256
7257     alter table TaxonNameBase_AUD
7258         add constraint FK5CA2CB9734869AAE
7259         foreign key (REV)
7260         references AuditEvent;
7261
7262     alter table TaxonNameBase_Annotation
7263         add constraint FK9E7794688C85CF94
7264         foreign key (TaxonNameBase_id)
7265         references TaxonNameBase;
7266
7267     alter table TaxonNameBase_Annotation
7268         add constraint FK9E7794681E403E0B
7269         foreign key (annotations_id)
7270         references Annotation;
7271
7272     alter table TaxonNameBase_Annotation_AUD
7273         add constraint FKB6734E3934869AAE
7274         foreign key (REV)
7275         references AuditEvent;
7276
7277     alter table TaxonNameBase_Credit
7278         add constraint FK29BCD8B232D1B9F
7279         foreign key (credits_id)
7280         references Credit;
7281
7282     alter table TaxonNameBase_Credit
7283         add constraint FK29BCD8B28C85CF94
7284         foreign key (TaxonNameBase_id)
7285         references TaxonNameBase;
7286
7287     alter table TaxonNameBase_Credit_AUD
7288         add constraint FKD9895D8334869AAE
7289         foreign key (REV)
7290         references AuditEvent;
7291
7292     alter table TaxonNameBase_Extension
7293         add constraint FKC28EE7E6927DE9DF
7294         foreign key (extensions_id)
7295         references Extension;
7296
7297     alter table TaxonNameBase_Extension
7298         add constraint FKC28EE7E68C85CF94
7299         foreign key (TaxonNameBase_id)
7300         references TaxonNameBase;
7301
7302     alter table TaxonNameBase_Extension_AUD
7303         add constraint FK8F98B2B734869AAE
7304         foreign key (REV)
7305         references AuditEvent;
7306
7307     alter table TaxonNameBase_HybridRelationship
7308         add constraint FK371B728D2D57C7D5
7309         foreign key (hybridrelationships_id)
7310         references HybridRelationship;
7311
7312     alter table TaxonNameBase_HybridRelationship
7313         add constraint FK371B728DCDE98DD2
7314         foreign key (TaxonNameBase_id)
7315         references TaxonNameBase;
7316
7317     alter table TaxonNameBase_HybridRelationship_AUD
7318         add constraint FK800191DE34869AAE
7319         foreign key (REV)
7320         references AuditEvent;
7321
7322     alter table TaxonNameBase_Marker
7323         add constraint FK39E3C1F38C85CF94
7324         foreign key (TaxonNameBase_id)
7325         references TaxonNameBase;
7326
7327     alter table TaxonNameBase_Marker
7328         add constraint FK39E3C1F3777265A1
7329         foreign key (markers_id)
7330         references Marker;
7331
7332     alter table TaxonNameBase_Marker_AUD
7333         add constraint FK3DA7BE4434869AAE
7334         foreign key (REV)
7335         references AuditEvent;
7336
7337     alter table TaxonNameBase_NomenclaturalStatus
7338         add constraint FK560BA7926615E90D
7339         foreign key (status_id)
7340         references NomenclaturalStatus;
7341
7342     alter table TaxonNameBase_NomenclaturalStatus
7343         add constraint FK560BA7928C85CF94
7344         foreign key (TaxonNameBase_id)
7345         references TaxonNameBase;
7346
7347     alter table TaxonNameBase_NomenclaturalStatus_AUD
7348         add constraint FK9215BC6334869AAE
7349         foreign key (REV)
7350         references AuditEvent;
7351
7352     alter table TaxonNameBase_OriginalSource
7353         add constraint FKBEA1E2053BAB2414
7354         foreign key (sources_id)
7355         references OriginalSource;
7356
7357     alter table TaxonNameBase_OriginalSource
7358         add constraint FKBEA1E2058C85CF94
7359         foreign key (TaxonNameBase_id)
7360         references TaxonNameBase;
7361
7362     alter table TaxonNameBase_OriginalSource_AUD
7363         add constraint FKF753855634869AAE
7364         foreign key (REV)
7365         references AuditEvent;
7366
7367     alter table TaxonNameBase_Rights
7368         add constraint FK42D7AF90C13F7B21
7369         foreign key (rights_id)
7370         references Rights;
7371
7372     alter table TaxonNameBase_Rights
7373         add constraint FK42D7AF908C85CF94
7374         foreign key (TaxonNameBase_id)
7375         references TaxonNameBase;
7376
7377     alter table TaxonNameBase_Rights_AUD
7378         add constraint FKA981956134869AAE
7379         foreign key (REV)
7380         references AuditEvent;
7381
7382     alter table TaxonNameBase_TypeDesignationBase
7383         add constraint FKC0D6BBB5C7DF530C
7384         foreign key (typedesignations_id)
7385         references TypeDesignationBase;
7386
7387     alter table TaxonNameBase_TypeDesignationBase
7388         add constraint FKC0D6BBB58C85CF94
7389         foreign key (TaxonNameBase_id)
7390         references TaxonNameBase;
7391
7392     alter table TaxonNameBase_TypeDesignationBase_AUD
7393         add constraint FKBB24070634869AAE
7394         foreign key (REV)
7395         references AuditEvent;
7396
7397     alter table TaxonNode
7398         add constraint FK924F5BCC4FF2DB2C
7399         foreign key (createdby_id)
7400         references UserAccount;
7401
7402     alter table TaxonNode
7403         add constraint FK924F5BCCDE9A3E39
7404         foreign key (taxon_id)
7405         references TaxonBase;
7406
7407     alter table TaxonNode
7408         add constraint FK924F5BCCCC05993E
7409         foreign key (synonymtobeused_id)
7410         references TaxonBase;
7411
7412     alter table TaxonNode
7413         add constraint FK924F5BCCD019B239
7414         foreign key (taxonomictree_id)
7415         references TaxonomicTree;
7416
7417     alter table TaxonNode
7418         add constraint FK924F5BCC215EDF26
7419         foreign key (referenceforparentchildrelation_id)
7420         references ReferenceBase;
7421
7422     alter table TaxonNode
7423         add constraint FK924F5BCC39DB2DFB
7424         foreign key (parent_id)
7425         references TaxonNode;
7426
7427     alter table TaxonNode
7428         add constraint FK924F5BCCBC5DA539
7429         foreign key (updatedby_id)
7430         references UserAccount;
7431
7432     alter table TaxonNode_AUD
7433         add constraint FKE090C39D34869AAE
7434         foreign key (REV)
7435         references AuditEvent;
7436
7437     alter table TaxonNode_Annotation
7438         add constraint FKD8A9A9A2927D8399
7439         foreign key (TaxonNode_id)
7440         references TaxonNode;
7441
7442     alter table TaxonNode_Annotation
7443         add constraint FKD8A9A9A21E403E0B
7444         foreign key (annotations_id)
7445         references Annotation;
7446
7447     alter table TaxonNode_Annotation_AUD
7448         add constraint FKB2C4367334869AAE
7449         foreign key (REV)
7450         references AuditEvent;
7451
7452     alter table TaxonNode_Marker
7453         add constraint FK395842D777265A1
7454         foreign key (markers_id)
7455         references Marker;
7456
7457     alter table TaxonNode_Marker
7458         add constraint FK395842D927D8399
7459         foreign key (TaxonNode_id)
7460         references TaxonNode;
7461
7462     alter table TaxonNode_Marker_AUD
7463         add constraint FK77D9D37E34869AAE
7464         foreign key (REV)
7465         references AuditEvent;
7466
7467     alter table TaxonRelationship
7468         add constraint FK7482BA02E71EF6CE
7469         foreign key (relatedfrom_id)
7470         references TaxonBase;
7471
7472     alter table TaxonRelationship
7473         add constraint FK7482BA02F8991B9D
7474         foreign key (relatedto_id)
7475         references TaxonBase;
7476
7477     alter table TaxonRelationship
7478         add constraint FK7482BA024FF2DB2C
7479         foreign key (createdby_id)
7480         references UserAccount;
7481
7482     alter table TaxonRelationship
7483         add constraint FK7482BA02F11BD77B
7484         foreign key (type_id)
7485         references DefinedTermBase;
7486
7487     alter table TaxonRelationship
7488         add constraint FK7482BA029803512F
7489         foreign key (citation_id)
7490         references ReferenceBase;
7491
7492     alter table TaxonRelationship
7493         add constraint FK7482BA02BC5DA539
7494         foreign key (updatedby_id)
7495         references UserAccount;
7496
7497     alter table TaxonRelationship_AUD
7498         add constraint FKA0DE16D334869AAE
7499         foreign key (REV)
7500         references AuditEvent;
7501
7502     alter table TaxonRelationship_Annotation
7503         add constraint FK82C86DAC1E403E0B
7504         foreign key (annotations_id)
7505         references Annotation;
7506
7507     alter table TaxonRelationship_Annotation
7508         add constraint FK82C86DAC2BD180D9
7509         foreign key (TaxonRelationship_id)
7510         references TaxonRelationship;
7511
7512     alter table TaxonRelationship_Annotation_AUD
7513         add constraint FKE86DE57D34869AAE
7514         foreign key (REV)
7515         references AuditEvent;
7516
7517     alter table TaxonRelationship_Marker
7518         add constraint FK69FBDD37777265A1
7519         foreign key (markers_id)
7520         references Marker;
7521
7522     alter table TaxonRelationship_Marker
7523         add constraint FK69FBDD372BD180D9
7524         foreign key (TaxonRelationship_id)
7525         references TaxonRelationship;
7526
7527     alter table TaxonRelationship_Marker_AUD
7528         add constraint FK21F8978834869AAE
7529         foreign key (REV)
7530         references AuditEvent;
7531
7532     alter table TaxonomicTree
7533         add constraint FKE333A2E7765B124B
7534         foreign key (reference_id)
7535         references ReferenceBase;
7536
7537     alter table TaxonomicTree
7538         add constraint FKE333A2E74FF2DB2C
7539         foreign key (createdby_id)
7540         references UserAccount;
7541
7542     alter table TaxonomicTree
7543         add constraint FKE333A2E777E2F09E
7544         foreign key (name_id)
7545         references LanguageString;
7546
7547     alter table TaxonomicTree
7548         add constraint FKE333A2E7BC5DA539
7549         foreign key (updatedby_id)
7550         references UserAccount;
7551
7552     alter table TaxonomicTree_AUD
7553         add constraint FK976053834869AAE
7554         foreign key (REV)
7555         references AuditEvent;
7556
7557     alter table TaxonomicTree_Annotation
7558         add constraint FKE5DF73A7D019B239
7559         foreign key (taxonomictree_id)
7560         references TaxonomicTree;
7561
7562     alter table TaxonomicTree_Annotation
7563         add constraint FKE5DF73A71E403E0B
7564         foreign key (annotations_id)
7565         references Annotation;
7566
7567     alter table TaxonomicTree_Annotation_AUD
7568         add constraint FK3C4B75F834869AAE
7569         foreign key (REV)
7570         references AuditEvent;
7571
7572     alter table TaxonomicTree_Credit
7573         add constraint FK23C2F71D019B239
7574         foreign key (taxonomictree_id)
7575         references TaxonomicTree;
7576
7577     alter table TaxonomicTree_Credit
7578         add constraint FK23C2F7132D1B9F
7579         foreign key (credits_id)
7580         references Credit;
7581
7582     alter table TaxonomicTree_Credit_AUD
7583         add constraint FK20F13CC234869AAE
7584         foreign key (REV)
7585         references AuditEvent;
7586
7587     alter table TaxonomicTree_Extension
7588         add constraint FKCD1EA4C7927DE9DF
7589         foreign key (extensions_id)
7590         references Extension;
7591
7592     alter table TaxonomicTree_Extension
7593         add constraint FKCD1EA4C7D019B239
7594         foreign key (taxonomictree_id)
7595         references TaxonomicTree;
7596
7597     alter table TaxonomicTree_Extension_AUD
7598         add constraint FK204D171834869AAE
7599         foreign key (REV)
7600         references AuditEvent;
7601
7602     alter table TaxonomicTree_Marker
7603         add constraint FK126318B2D019B239
7604         foreign key (taxonomictree_id)
7605         references TaxonomicTree;
7606
7607     alter table TaxonomicTree_Marker
7608         add constraint FK126318B2777265A1
7609         foreign key (markers_id)
7610         references Marker;
7611
7612     alter table TaxonomicTree_Marker_AUD
7613         add constraint FK850F9D8334869AAE
7614         foreign key (REV)
7615         references AuditEvent;
7616
7617     alter table TaxonomicTree_OriginalSource
7618         add constraint FK447A09C43BAB2414
7619         foreign key (sources_id)
7620         references OriginalSource;
7621
7622     alter table TaxonomicTree_OriginalSource
7623         add constraint FK447A09C4D019B239
7624         foreign key (taxonomictree_id)
7625         references TaxonomicTree;
7626
7627     alter table TaxonomicTree_OriginalSource_AUD
7628         add constraint FK143B59534869AAE
7629         foreign key (REV)
7630         references AuditEvent;
7631
7632     alter table TaxonomicTree_Rights
7633         add constraint FK1B57064FD019B239
7634         foreign key (taxonomictree_id)
7635         references TaxonomicTree;
7636
7637     alter table TaxonomicTree_Rights
7638         add constraint FK1B57064FC13F7B21
7639         foreign key (rights_id)
7640         references Rights;
7641
7642     alter table TaxonomicTree_Rights_AUD
7643         add constraint FKF0E974A034869AAE
7644         foreign key (REV)
7645         references AuditEvent;
7646
7647     alter table TaxonomicTree_TaxonNode
7648         add constraint FKC7EC474D019B239
7649         foreign key (taxonomictree_id)
7650         references TaxonomicTree;
7651
7652     alter table TaxonomicTree_TaxonNode
7653         add constraint FKC7EC47418929176
7654         foreign key (rootnodes_id)
7655         references TaxonNode;
7656
7657     alter table TaxonomicTree_TaxonNode_AUD
7658         add constraint FK6E0B984534869AAE
7659         foreign key (REV)
7660         references AuditEvent;
7661
7662     alter table TermVocabulary
7663         add constraint FK487AA6924FF2DB2C
7664         foreign key (createdby_id)
7665         references UserAccount;
7666
7667     alter table TermVocabulary
7668         add constraint FK487AA692BC5DA539
7669         foreign key (updatedby_id)
7670         references UserAccount;
7671
7672     alter table TermVocabulary_AUD
7673         add constraint FKA6ED3B6334869AAE
7674         foreign key (REV)
7675         references AuditEvent;
7676
7677     alter table TermVocabulary_Representation
7678         add constraint FKA408B63A258E060
7679         foreign key (TermVocabulary_id)
7680         references TermVocabulary;
7681
7682     alter table TermVocabulary_Representation
7683         add constraint FKA408B63AB31C4747
7684         foreign key (representations_id)
7685         references Representation;
7686
7687     alter table TermVocabulary_Representation_AUD
7688         add constraint FK681B370B34869AAE
7689         foreign key (REV)
7690         references AuditEvent;
7691
7692     alter table TypeDesignationBase
7693         add constraint FK8AC9DCAE9E3ED08
7694         foreign key (typestatus_id)
7695         references DefinedTermBase;
7696
7697     alter table TypeDesignationBase
7698         add constraint FK8AC9DCAE4FF2DB2C
7699         foreign key (createdby_id)
7700         references UserAccount;
7701
7702     alter table TypeDesignationBase
7703         add constraint FK8AC9DCAE94DB044A
7704         foreign key (typespecimen_id)
7705         references SpecimenOrObservationBase;
7706
7707     alter table TypeDesignationBase
7708         add constraint FK8AC9DCAEBFEAE500
7709         foreign key (homotypicalgroup_id)
7710         references HomotypicalGroup;
7711
7712     alter table TypeDesignationBase
7713         add constraint FK8AC9DCAE9803512F
7714         foreign key (citation_id)
7715         references ReferenceBase;
7716
7717     alter table TypeDesignationBase
7718         add constraint FK8AC9DCAE4CB0F315
7719         foreign key (typename_id)
7720         references TaxonNameBase;
7721
7722     alter table TypeDesignationBase
7723         add constraint FK8AC9DCAEBC5DA539
7724         foreign key (updatedby_id)
7725         references UserAccount;
7726
7727     alter table TypeDesignationBase_AUD
7728         add constraint FK243C037F34869AAE
7729         foreign key (REV)
7730         references AuditEvent;
7731
7732     alter table TypeDesignationBase_Annotation
7733         add constraint FK4D73278044E9E6D4
7734         foreign key (TypeDesignationBase_id)
7735         references TypeDesignationBase;
7736
7737     alter table TypeDesignationBase_Annotation
7738         add constraint FK4D7327801E403E0B
7739         foreign key (annotations_id)
7740         references Annotation;
7741
7742     alter table TypeDesignationBase_Annotation_AUD
7743         add constraint FK88BF955134869AAE
7744         foreign key (REV)
7745         references AuditEvent;
7746
7747     alter table TypeDesignationBase_Marker
7748         add constraint FKB914A10B44E9E6D4
7749         foreign key (TypeDesignationBase_id)
7750         references TypeDesignationBase;
7751
7752     alter table TypeDesignationBase_Marker
7753         add constraint FKB914A10B777265A1
7754         foreign key (markers_id)
7755         references Marker;
7756
7757     alter table TypeDesignationBase_Marker_AUD
7758         add constraint FKECA3515C34869AAE
7759         foreign key (REV)
7760         references AuditEvent;
7761
7762     alter table TypeDesignationBase_TaxonNameBase
7763         add constraint FKF61156F54D901A92
7764         foreign key (typifiednames_id)
7765         references TaxonNameBase;
7766
7767     alter table TypeDesignationBase_TaxonNameBase
7768         add constraint FKF61156F544E9E6D4
7769         foreign key (TypeDesignationBase_id)
7770         references TypeDesignationBase;
7771
7772     alter table TypeDesignationBase_TaxonNameBase_AUD
7773         add constraint FK4F1F024634869AAE
7774         foreign key (REV)
7775         references AuditEvent;
7776
7777     alter table UserAccount
7778         add constraint FKB3F13C24FF2DB2C
7779         foreign key (createdby_id)
7780         references UserAccount;
7781
7782     alter table UserAccount
7783         add constraint FKB3F13C2AAC1B820
7784         foreign key (person_id)
7785         references AgentBase;
7786
7787     alter table UserAccount_AUD
7788         add constraint FK6A57909334869AAE
7789         foreign key (REV)
7790         references AuditEvent;
7791
7792     alter table UserAccount_GrantedAuthorityImpl
7793         add constraint FKFD724D855EA5DD89
7794         foreign key (UserAccount_id)
7795         references UserAccount;
7796
7797     alter table UserAccount_GrantedAuthorityImpl
7798         add constraint FKFD724D851857F6C2
7799         foreign key (grantedauthorities_id)
7800         references GrantedAuthorityImpl;
7801
7802     alter table UserAccount_PermissionGroup
7803         add constraint FK812DE753DA9DCB5F
7804         foreign key (groups_id)
7805         references PermissionGroup;
7806
7807     alter table UserAccount_PermissionGroup
7808         add constraint FK812DE753887E3D12
7809         foreign key (members_id)
7810         references UserAccount;