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

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