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