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