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

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