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_PolytomousKeyNode_AUD(
3187         id integer not null,
3188         REV integer not null,
3189         revtype tinyint,
3190         parent_id integer,
3191         sortIndex integer
3192     )
3193
3194     create table Reference (
3195         DTYPE varchar(31) not null,
3196         id integer not null,
3197         created timestamp,
3198         uuid varchar(36),
3199         updated timestamp,
3200         lsid_authority varchar(255),
3201         lsid_lsid varchar(255),
3202         lsid_namespace varchar(255),
3203         lsid_object varchar(255),
3204         lsid_revision varchar(255),
3205         protectedtitlecache bit not null,
3206         titleCache varchar(255),
3207         datepublished_end varchar(255),
3208         datepublished_freetext varchar(255),
3209         datepublished_start varchar(255),
3210         edition varchar(255),
3211         editor varchar(255),
3212         isbn varchar(255),
3213         issn varchar(255),
3214         nomenclaturallyrelevant bit not null,
3215         organization varchar(255),
3216         pages varchar(255),
3217         parsingproblem integer not null,
3218         placepublished varchar(255),
3219         problemends integer not null,
3220         problemstarts integer not null,
3221         publisher varchar(255),
3222         referenceAbstract longvarchar,
3223         series varchar(255),
3224         seriespart varchar(255),
3225         title longvarchar,
3226         refType integer,
3227         uri varchar(255),
3228         volume varchar(255),
3229         createdby_id integer,
3230         updatedby_id integer,
3231         authorteam_id integer,
3232         inreference_id integer,
3233         institution_id integer,
3234         school_id integer,
3235         abbreviatedReference_id integer,
3236         fullReference_id integer,
3237         primary key (id),
3238         unique (uuid)
3239     );
3240
3241     create table Reference_AUD (
3242         DTYPE varchar(31) not null,
3243         id integer not null,
3244         REV integer not null,
3245         revtype tinyint,
3246         created timestamp,
3247         uuid varchar(36),
3248         updated timestamp,
3249         lsid_authority varchar(255),
3250         lsid_lsid varchar(255),
3251         lsid_namespace varchar(255),
3252         lsid_object varchar(255),
3253         lsid_revision varchar(255),
3254         protectedtitlecache bit,
3255         titleCache varchar(255),
3256         datepublished_end varchar(255),
3257         datepublished_freetext varchar(255),
3258         datepublished_start varchar(255),
3259         edition varchar(255),
3260         editor varchar(255),
3261         isbn varchar(255),
3262         issn varchar(255),
3263         nomenclaturallyrelevant bit,
3264         organization varchar(255),
3265         pages varchar(255),
3266         parsingproblem integer,
3267         placepublished varchar(255),
3268         problemends integer,
3269         problemstarts integer,
3270         publisher varchar(255),
3271         referenceAbstract longvarchar,
3272         series varchar(255),
3273         seriespart varchar(255),
3274         title longvarchar,
3275         refType integer,
3276         uri varchar(255),
3277         volume varchar(255),
3278         createdby_id integer,
3279         updatedby_id integer,
3280         authorteam_id integer,
3281         inreference_id integer,
3282         institution_id integer,
3283         school_id integer,
3284         abbreviatedReference_id integer,
3285         fullReference_id integer,
3286         primary key (id, REV)
3287     );
3288
3289     create table Reference_Annotation (
3290         Reference_id integer not null,
3291         annotations_id integer not null,
3292         primary key (Reference_id, annotations_id),
3293         unique (annotations_id)
3294     );
3295
3296     create table Reference_Annotation_AUD (
3297         REV integer not null,
3298         Reference_id integer not null,
3299         annotations_id integer not null,
3300         revtype tinyint,
3301         primary key (REV, Reference_id, annotations_id)
3302     );
3303
3304     create table Reference_Credit (
3305         Reference_id integer not null,
3306         credits_id integer not null,
3307         sortIndex integer not null,
3308         primary key (Reference_id, sortIndex),
3309         unique (credits_id)
3310     );
3311
3312     create table Reference_Credit_AUD (
3313         REV integer not null,
3314         Reference_id integer not null,
3315         credits_id integer not null,
3316         sortIndex integer not null,
3317         revtype tinyint,
3318         primary key (REV, Reference_id, credits_id, sortIndex)
3319     );
3320
3321     create table Reference_Extension (
3322         Reference_id integer not null,
3323         extensions_id integer not null,
3324         primary key (Reference_id, extensions_id),
3325         unique (extensions_id)
3326     );
3327
3328     create table Reference_Extension_AUD (
3329         REV integer not null,
3330         Reference_id integer not null,
3331         extensions_id integer not null,
3332         revtype tinyint,
3333         primary key (REV, Reference_id, extensions_id)
3334     );
3335
3336     create table Reference_Marker (
3337         Reference_id integer not null,
3338         markers_id integer not null,
3339         primary key (Reference_id, markers_id),
3340         unique (markers_id)
3341     );
3342
3343     create table Reference_Marker_AUD (
3344         REV integer not null,
3345         Reference_id integer not null,
3346         markers_id integer not null,
3347         revtype tinyint,
3348         primary key (REV, Reference_id, markers_id)
3349     );
3350
3351     create table Reference_Media (
3352         Reference_id integer not null,
3353         media_id integer not null,
3354         primary key (Reference_id, media_id)
3355     );
3356
3357     create table Reference_Media_AUD (
3358         REV integer not null,
3359         Reference_id integer not null,
3360         media_id integer not null,
3361         revtype tinyint,
3362         primary key (REV, Reference_id, media_id)
3363     );
3364
3365     create table Reference_OriginalSourceBase (
3366         Reference_id integer not null,
3367         sources_id integer not null,
3368         primary key (Reference_id, sources_id),
3369         unique (sources_id)
3370     );
3371
3372     create table Reference_OriginalSourceBase_AUD (
3373         REV integer not null,
3374         Reference_id integer not null,
3375         sources_id integer not null,
3376         revtype tinyint,
3377         primary key (REV, Reference_id, sources_id)
3378     );
3379
3380     create table Reference_Rights (
3381         Reference_id integer not null,
3382         rights_id integer not null,
3383         primary key (Reference_id, rights_id),
3384         unique (rights_id)
3385     );
3386
3387     create table Reference_Rights_AUD (
3388         REV integer not null,
3389         Reference_id integer not null,
3390         rights_id integer not null,
3391         revtype tinyint,
3392         primary key (REV, Reference_id, rights_id)
3393     );
3394
3395     create table RelationshipTermBase_inverseRepresentation (
3396         DefinedTermBase_id integer not null,
3397         inverserepresentations_id integer not null,
3398         primary key (DefinedTermBase_id, inverserepresentations_id),
3399         unique (inverserepresentations_id)
3400     );
3401
3402     create table RelationshipTermBase_inverseRepresentation_AUD (
3403         REV integer not null,
3404         DefinedTermBase_id integer not null,
3405         inverserepresentations_id integer not null,
3406         revtype tinyint,
3407         primary key (REV, DefinedTermBase_id, inverserepresentations_id)
3408     );
3409
3410     create table Representation (
3411         id integer not null,
3412         created timestamp,
3413         uuid varchar(36),
3414         updated timestamp,
3415         text longvarchar,
3416         abbreviatedlabel varchar(255),
3417         label varchar(255),
3418         createdby_id integer,
3419         updatedby_id integer,
3420         language_id integer,
3421         primary key (id),
3422         unique (uuid)
3423     );
3424
3425     create table Representation_AUD (
3426         id integer not null,
3427         REV integer not null,
3428         revtype tinyint,
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, REV)
3439     );
3440
3441     create table Representation_Annotation (
3442         Representation_id integer not null,
3443         annotations_id integer not null,
3444         primary key (Representation_id, annotations_id),
3445         unique (annotations_id)
3446     );
3447
3448     create table Representation_Annotation_AUD (
3449         REV integer not null,
3450         Representation_id integer not null,
3451         annotations_id integer not null,
3452         revtype tinyint,
3453         primary key (REV, Representation_id, annotations_id)
3454     );
3455
3456     create table Representation_Marker (
3457         Representation_id integer not null,
3458         markers_id integer not null,
3459         primary key (Representation_id, markers_id),
3460         unique (markers_id)
3461     );
3462
3463     create table Representation_Marker_AUD (
3464         REV integer not null,
3465         Representation_id integer not null,
3466         markers_id integer not null,
3467         revtype tinyint,
3468         primary key (REV, Representation_id, markers_id)
3469     );
3470
3471     create table Rights (
3472         id integer not null,
3473         created timestamp,
3474         uuid varchar(36),
3475         updated timestamp,
3476         text longvarchar,
3477         abbreviatedtext varchar(255),
3478         uri varchar(255),
3479         createdby_id integer,
3480         updatedby_id integer,
3481         language_id integer,
3482         agent_id integer,
3483         type_id integer,
3484         primary key (id),
3485         unique (uuid)
3486     );
3487
3488     create table Rights_AUD (
3489         id integer not null,
3490         REV integer not null,
3491         revtype tinyint,
3492         created timestamp,
3493         uuid varchar(36),
3494         updated timestamp,
3495         text longvarchar,
3496         abbreviatedtext varchar(255),
3497         uri varchar(255),
3498         createdby_id integer,
3499         updatedby_id integer,
3500         language_id integer,
3501         agent_id integer,
3502         type_id integer,
3503         primary key (id, REV)
3504     );
3505
3506     create table Rights_Annotation (
3507         Rights_id integer not null,
3508         annotations_id integer not null,
3509         primary key (Rights_id, annotations_id),
3510         unique (annotations_id)
3511     );
3512
3513     create table Rights_Annotation_AUD (
3514         REV integer not null,
3515         Rights_id integer not null,
3516         annotations_id integer not null,
3517         revtype tinyint,
3518         primary key (REV, Rights_id, annotations_id)
3519     );
3520
3521     create table Rights_Marker (
3522         Rights_id integer not null,
3523         markers_id integer not null,
3524         primary key (Rights_id, markers_id),
3525         unique (markers_id)
3526     );
3527
3528     create table Rights_Marker_AUD (
3529         REV integer not null,
3530         Rights_id integer not null,
3531         markers_id integer not null,
3532         revtype tinyint,
3533         primary key (REV, Rights_id, markers_id)
3534     );
3535
3536     create table Sequence (
3537         id integer not null,
3538         created timestamp,
3539         uuid varchar(36),
3540         updated timestamp,
3541         lsid_authority varchar(255),
3542         lsid_lsid varchar(255),
3543         lsid_namespace varchar(255),
3544         lsid_object varchar(255),
3545         lsid_revision varchar(255),
3546         protectedtitlecache bit not null,
3547         titleCache varchar(255),
3548         barcode bit not null,
3549         citationmicroreference varchar(255),
3550         datesequenced timestamp,
3551         length integer,
3552         sequence varchar(255),
3553         createdby_id integer,
3554         updatedby_id integer,
3555         locus_id integer,
3556         publishedin_id integer,
3557         primary key (id),
3558         unique (uuid)
3559     );
3560
3561     create table Sequence_AUD (
3562         id integer not null,
3563         REV integer not null,
3564         revtype tinyint,
3565         created timestamp,
3566         uuid varchar(36),
3567         updated timestamp,
3568         lsid_authority varchar(255),
3569         lsid_lsid varchar(255),
3570         lsid_namespace varchar(255),
3571         lsid_object varchar(255),
3572         lsid_revision varchar(255),
3573         protectedtitlecache bit,
3574         titleCache varchar(255),
3575         barcode bit,
3576         citationmicroreference varchar(255),
3577         datesequenced timestamp,
3578         length integer,
3579         sequence varchar(255),
3580         createdby_id integer,
3581         updatedby_id integer,
3582         locus_id integer,
3583         publishedin_id integer,
3584         primary key (id, REV)
3585     );
3586
3587     create table Sequence_Annotation (
3588         Sequence_id integer not null,
3589         annotations_id integer not null,
3590         primary key (Sequence_id, annotations_id),
3591         unique (annotations_id)
3592     );
3593
3594     create table Sequence_Annotation_AUD (
3595         REV integer not null,
3596         Sequence_id integer not null,
3597         annotations_id integer not null,
3598         revtype tinyint,
3599         primary key (REV, Sequence_id, annotations_id)
3600     );
3601
3602     create table Sequence_Credit (
3603         Sequence_id integer not null,
3604         credits_id integer not null,
3605         sortIndex integer not null,
3606         primary key (Sequence_id, sortIndex),
3607         unique (credits_id)
3608     );
3609
3610     create table Sequence_Credit_AUD (
3611         REV integer not null,
3612         Sequence_id integer not null,
3613         credits_id integer not null,
3614         sortIndex integer not null,
3615         revtype tinyint,
3616         primary key (REV, Sequence_id, credits_id, sortIndex)
3617     );
3618
3619     create table Sequence_Extension (
3620         Sequence_id integer not null,
3621         extensions_id integer not null,
3622         primary key (Sequence_id, extensions_id),
3623         unique (extensions_id)
3624     );
3625
3626     create table Sequence_Extension_AUD (
3627         REV integer not null,
3628         Sequence_id integer not null,
3629         extensions_id integer not null,
3630         revtype tinyint,
3631         primary key (REV, Sequence_id, extensions_id)
3632     );
3633
3634     create table Sequence_GenBankAccession (
3635         Sequence_id integer not null,
3636         genbankaccession_id integer not null,
3637         primary key (Sequence_id, genbankaccession_id),
3638         unique (genbankaccession_id)
3639     );
3640
3641     create table Sequence_GenBankAccession_AUD (
3642         REV integer not null,
3643         Sequence_id integer not null,
3644         genbankaccession_id integer not null,
3645         revtype tinyint,
3646         primary key (REV, Sequence_id, genbankaccession_id)
3647     );
3648
3649     create table Sequence_Marker (
3650         Sequence_id integer not null,
3651         markers_id integer not null,
3652         primary key (Sequence_id, markers_id),
3653         unique (markers_id)
3654     );
3655
3656     create table Sequence_Marker_AUD (
3657         REV integer not null,
3658         Sequence_id integer not null,
3659         markers_id integer not null,
3660         revtype tinyint,
3661         primary key (REV, Sequence_id, markers_id)
3662     );
3663
3664     create table Sequence_Media (
3665         Sequence_id integer not null,
3666         chromatograms_id integer not null,
3667         primary key (Sequence_id, chromatograms_id),
3668         unique (chromatograms_id)
3669     );
3670
3671     create table Sequence_Media_AUD (
3672         REV integer not null,
3673         Sequence_id integer not null,
3674         chromatograms_id integer not null,
3675         revtype tinyint,
3676         primary key (REV, Sequence_id, chromatograms_id)
3677     );
3678
3679     create table Sequence_OriginalSourceBase (
3680         Sequence_id integer not null,
3681         sources_id integer not null,
3682         primary key (Sequence_id, sources_id),
3683         unique (sources_id)
3684     );
3685
3686     create table Sequence_OriginalSourceBase_AUD (
3687         REV integer not null,
3688         Sequence_id integer not null,
3689         sources_id integer not null,
3690         revtype tinyint,
3691         primary key (REV, Sequence_id, sources_id)
3692     );
3693
3694     create table Sequence_Reference (
3695         Sequence_id integer not null,
3696         citations_id integer not null,
3697         primary key (Sequence_id, citations_id),
3698         unique (citations_id)
3699     );
3700
3701     create table Sequence_Reference_AUD (
3702         REV integer not null,
3703         Sequence_id integer not null,
3704         citations_id integer not null,
3705         revtype tinyint,
3706         primary key (REV, Sequence_id, citations_id)
3707     );
3708
3709     create table Sequence_Rights (
3710         Sequence_id integer not null,
3711         rights_id integer not null,
3712         primary key (Sequence_id, rights_id),
3713         unique (rights_id)
3714     );
3715
3716     create table Sequence_Rights_AUD (
3717         REV integer not null,
3718         Sequence_id integer not null,
3719         rights_id integer not null,
3720         revtype tinyint,
3721         primary key (REV, Sequence_id, rights_id)
3722     );
3723
3724     create table SpecimenOrObservationBase (
3725         DTYPE varchar(31) not null,
3726         id integer not null,
3727         created timestamp,
3728         uuid varchar(36),
3729         updated timestamp,
3730         lsid_authority varchar(255),
3731         lsid_lsid varchar(255),
3732         lsid_namespace varchar(255),
3733         lsid_object varchar(255),
3734         lsid_revision varchar(255),
3735         protectedtitlecache bit not null,
3736         titleCache varchar(255),
3737         individualcount integer,
3738         accessionnumber varchar(255),
3739         catalognumber varchar(255),
3740         collectorsnumber varchar(255),
3741         barcode varchar(255),
3742         fieldnotes varchar(255),
3743         fieldnumber varchar(255),
3744         createdby_id integer,
3745         updatedby_id integer,
3746         lifestage_id integer,
3747         sex_id integer,
3748         exsiccatum varchar(255),
3749         primarycollector_id integer,
3750         collection_id integer,
3751         derivedfrom_id integer,
3752         storedunder_id integer,
3753         preservation_id integer,
3754         gatheringevent_id integer,
3755         primary key (id),
3756         unique (uuid)
3757     );
3758
3759
3760     create table SpecimenOrObservationBase_AUD (
3761         DTYPE varchar(31) not null,
3762         id integer not null,
3763         REV integer not null,
3764         revtype tinyint,
3765         created timestamp,
3766         uuid varchar(36),
3767         updated timestamp,
3768         lsid_authority varchar(255),
3769         lsid_lsid varchar(255),
3770         lsid_namespace varchar(255),
3771         lsid_object varchar(255),
3772         lsid_revision varchar(255),
3773         protectedtitlecache bit,
3774         titleCache varchar(255),
3775         individualcount integer,
3776         createdby_id integer,
3777         updatedby_id integer,
3778         lifestage_id integer,
3779         sex_id integer,
3780         fieldnotes varchar(255),
3781         fieldnumber varchar(255),
3782         barcode varchar(255),
3783         exsiccatum varchar(255),
3784         gatheringevent_id integer,
3785         accessionnumber varchar(255),
3786         catalognumber varchar(255),
3787         collectorsnumber varchar(255),
3788         primarycollector_id integer,
3789         collection_id integer,
3790         derivedfrom_id integer,
3791         storedunder_id integer,
3792         preservation_id integer,
3793         primary key (id, REV)
3794     );
3795
3796     create table SpecimenOrObservationBase_Annotation (
3797         SpecimenOrObservationBase_id integer not null,
3798         annotations_id integer not null,
3799         primary key (SpecimenOrObservationBase_id, annotations_id),
3800         unique (annotations_id)
3801     );
3802
3803     create table SpecimenOrObservationBase_Annotation_AUD (
3804         REV integer not null,
3805         SpecimenOrObservationBase_id integer not null,
3806         annotations_id integer not null,
3807         revtype tinyint,
3808         primary key (REV, SpecimenOrObservationBase_id, annotations_id)
3809     );
3810
3811     create table SpecimenOrObservationBase_Credit (
3812         SpecimenOrObservationBase_id integer not null,
3813         credits_id integer not null,
3814         sortIndex integer not null,
3815         primary key (SpecimenOrObservationBase_id, sortIndex),
3816         unique (credits_id)
3817     );
3818
3819     create table SpecimenOrObservationBase_Credit_AUD (
3820         REV integer not null,
3821         SpecimenOrObservationBase_id integer not null,
3822         credits_id integer not null,
3823         sortIndex integer not null,
3824         revtype tinyint,
3825         primary key (REV, SpecimenOrObservationBase_id, credits_id, sortIndex)
3826     );
3827
3828     create table SpecimenOrObservationBase_DerivationEvent (
3829         originals_id integer not null,
3830         derivationevents_id integer not null,
3831         primary key (originals_id, derivationevents_id)
3832     );
3833
3834     create table SpecimenOrObservationBase_DerivationEvent_AUD (
3835         REV integer not null,
3836         originals_id integer not null,
3837         derivationevents_id integer not null,
3838         revtype tinyint,
3839         primary key (REV, originals_id, derivationevents_id)
3840     );
3841
3842     create table SpecimenOrObservationBase_Extension (
3843         SpecimenOrObservationBase_id integer not null,
3844         extensions_id integer not null,
3845         primary key (SpecimenOrObservationBase_id, extensions_id),
3846         unique (extensions_id)
3847     );
3848
3849     create table SpecimenOrObservationBase_Extension_AUD (
3850         REV integer not null,
3851         SpecimenOrObservationBase_id integer not null,
3852         extensions_id integer not null,
3853         revtype tinyint,
3854         primary key (REV, SpecimenOrObservationBase_id, extensions_id)
3855     );
3856
3857     create table SpecimenOrObservationBase_LanguageString (
3858         SpecimenOrObservationBase_id integer not null,
3859         definition_id integer not null,
3860         definition_mapkey_id integer not null,
3861         primary key (SpecimenOrObservationBase_id, definition_mapkey_id),
3862         unique (definition_id)
3863     );
3864
3865     create table SpecimenOrObservationBase_LanguageString_AUD (
3866         REV integer not null,
3867         SpecimenOrObservationBase_id integer not null,
3868         definition_id integer not null,
3869         definition_mapkey_id integer not null,
3870         revtype tinyint,
3871         primary key (REV, SpecimenOrObservationBase_id, definition_id, definition_mapkey_id)
3872     );
3873
3874     create table SpecimenOrObservationBase_Marker (
3875         SpecimenOrObservationBase_id integer not null,
3876         markers_id integer not null,
3877         primary key (SpecimenOrObservationBase_id, markers_id),
3878         unique (markers_id)
3879     );
3880
3881     create table SpecimenOrObservationBase_Marker_AUD (
3882         REV integer not null,
3883         SpecimenOrObservationBase_id integer not null,
3884         markers_id integer not null,
3885         revtype tinyint,
3886         primary key (REV, SpecimenOrObservationBase_id, markers_id)
3887     );
3888
3889     create table SpecimenOrObservationBase_Media (
3890         SpecimenOrObservationBase_id integer not null,
3891         media_id integer not null,
3892         primary key (SpecimenOrObservationBase_id, media_id)
3893     );
3894
3895     create table SpecimenOrObservationBase_Media_AUD (
3896         REV integer not null,
3897         SpecimenOrObservationBase_id integer not null,
3898         media_id integer not null,
3899         revtype tinyint,
3900         primary key (REV, SpecimenOrObservationBase_id, media_id)
3901     );
3902
3903     create table SpecimenOrObservationBase_OriginalSourceBase (
3904         SpecimenOrObservationBase_id integer not null,
3905         sources_id integer not null,
3906         primary key (SpecimenOrObservationBase_id, sources_id),
3907         unique (sources_id)
3908     );
3909
3910     create table SpecimenOrObservationBase_OriginalSourceBase_AUD (
3911         REV integer not null,
3912         SpecimenOrObservationBase_id integer not null,
3913         sources_id integer not null,
3914         revtype tinyint,
3915         primary key (REV, SpecimenOrObservationBase_id, sources_id)
3916     );
3917
3918     create table SpecimenOrObservationBase_Rights (
3919         SpecimenOrObservationBase_id integer not null,
3920         rights_id integer not null,
3921         primary key (SpecimenOrObservationBase_id, rights_id),
3922         unique (rights_id)
3923     );
3924
3925     create table SpecimenOrObservationBase_Rights_AUD (
3926         REV integer not null,
3927         SpecimenOrObservationBase_id integer not null,
3928         rights_id integer not null,
3929         revtype tinyint,
3930         primary key (REV, SpecimenOrObservationBase_id, rights_id)
3931     );
3932
3933     create table SpecimenOrObservationBase_Sequence (
3934         SpecimenOrObservationBase_id integer not null,
3935         sequences_id integer not null,
3936         primary key (SpecimenOrObservationBase_id, sequences_id),
3937         unique (sequences_id)
3938     );
3939
3940     create table SpecimenOrObservationBase_Sequence_AUD (
3941         REV integer not null,
3942         SpecimenOrObservationBase_id integer not null,
3943         sequences_id integer not null,
3944         revtype tinyint,
3945         primary key (REV, SpecimenOrObservationBase_id, sequences_id)
3946     );
3947
3948     create table StateData (
3949         id integer not null,
3950         created timestamp,
3951         uuid varchar(36),
3952         updated timestamp,
3953         createdby_id integer,
3954         updatedby_id integer,
3955         state_id integer,
3956         primary key (id),
3957         unique (uuid)
3958     );
3959
3960     create table StateData_AUD (
3961         id integer not null,
3962         REV integer not null,
3963         revtype tinyint,
3964         created timestamp,
3965         uuid varchar(36),
3966         updated timestamp,
3967         createdby_id integer,
3968         updatedby_id integer,
3969         state_id integer,
3970         primary key (id, REV)
3971     );
3972
3973     create table StateData_DefinedTermBase (
3974         StateData_id integer not null,
3975         modifiers_id integer not null,
3976         primary key (StateData_id, modifiers_id),
3977         unique (modifiers_id)
3978     );
3979
3980     create table StateData_DefinedTermBase_AUD (
3981         REV integer not null,
3982         StateData_id integer not null,
3983         modifiers_id integer not null,
3984         revtype tinyint,
3985         primary key (REV, StateData_id, modifiers_id)
3986     );
3987
3988     create table StateData_LanguageString (
3989         StateData_id integer not null,
3990         modifyingtext_id integer not null,
3991         modifyingtext_mapkey_id integer not null,
3992         primary key (StateData_id, modifyingtext_mapkey_id),
3993         unique (modifyingtext_id)
3994     );
3995
3996     create table StateData_LanguageString_AUD (
3997         REV integer not null,
3998         StateData_id integer not null,
3999         modifyingtext_id integer not null,
4000         modifyingtext_mapkey_id integer not null,
4001         revtype tinyint,
4002         primary key (REV, StateData_id, modifyingtext_id, modifyingtext_mapkey_id)
4003     );
4004
4005     create table StatisticalMeasurementValue (
4006         id integer not null,
4007         created timestamp,
4008         uuid varchar(36),
4009         updated timestamp,
4010         value float not null,
4011         createdby_id integer,
4012         updatedby_id integer,
4013         type_id integer,
4014         primary key (id),
4015         unique (uuid)
4016     );
4017
4018     create table StatisticalMeasurementValue_AUD (
4019         id integer not null,
4020         REV integer not null,
4021         revtype tinyint,
4022         created timestamp,
4023         uuid varchar(36),
4024         updated timestamp,
4025         value float,
4026         createdby_id integer,
4027         updatedby_id integer,
4028         type_id integer,
4029         primary key (id, REV)
4030     );
4031
4032     create table StatisticalMeasurementValue_DefinedTermBase (
4033         StatisticalMeasurementValue_id integer not null,
4034         modifiers_id integer not null,
4035         primary key (StatisticalMeasurementValue_id, modifiers_id),
4036         unique (modifiers_id)
4037     );
4038
4039     create table StatisticalMeasurementValue_DefinedTermBase_AUD (
4040         REV integer not null,
4041         StatisticalMeasurementValue_id integer not null,
4042         modifiers_id integer not null,
4043         revtype tinyint,
4044         primary key (REV, StatisticalMeasurementValue_id, modifiers_id)
4045     );
4046
4047     create table SynonymRelationship (
4048         id integer not null,
4049         created timestamp,
4050         uuid varchar(36),
4051         updated timestamp,
4052         citationmicroreference varchar(255),
4053         originalnamestring varchar(255),
4054         doubtful bit not null,
4055         partial bit not null,
4056         proparte bit not null,
4057         createdby_id integer,
4058         updatedby_id integer,
4059         citation_id integer,
4060         relatedfrom_id integer,
4061         relatedto_id integer,
4062         type_id integer,
4063         primary key (id),
4064         unique (uuid)
4065     );
4066
4067     create table SynonymRelationship_AUD (
4068         id integer not null,
4069         REV integer not null,
4070         revtype tinyint,
4071         created timestamp,
4072         uuid varchar(36),
4073         updated timestamp,
4074         citationmicroreference varchar(255),
4075         originalnamestring varchar(255),
4076         doubtful bit,
4077         partial bit,
4078         proparte bit,
4079         createdby_id integer,
4080         updatedby_id integer,
4081         citation_id integer,
4082         relatedfrom_id integer,
4083         relatedto_id integer,
4084         type_id integer,
4085         primary key (id, REV)
4086     );
4087
4088     create table SynonymRelationship_Annotation (
4089         SynonymRelationship_id integer not null,
4090         annotations_id integer not null,
4091         primary key (SynonymRelationship_id, annotations_id),
4092         unique (annotations_id)
4093     );
4094
4095     create table SynonymRelationship_Annotation_AUD (
4096         REV integer not null,
4097         SynonymRelationship_id integer not null,
4098         annotations_id integer not null,
4099         revtype tinyint,
4100         primary key (REV, SynonymRelationship_id, annotations_id)
4101     );
4102
4103     create table SynonymRelationship_Marker (
4104         SynonymRelationship_id integer not null,
4105         markers_id integer not null,
4106         primary key (SynonymRelationship_id, markers_id),
4107         unique (markers_id)
4108     );
4109
4110     create table SynonymRelationship_Marker_AUD (
4111         REV integer not null,
4112         SynonymRelationship_id integer not null,
4113         markers_id integer not null,
4114         revtype tinyint,
4115         primary key (REV, SynonymRelationship_id, markers_id)
4116     );
4117
4118     create table TaxonBase (
4119         DTYPE varchar(31) not null,
4120         id integer not null,
4121         created timestamp,
4122         uuid varchar(36),
4123         updated timestamp,
4124         lsid_authority varchar(255),
4125         lsid_lsid varchar(255),
4126         lsid_namespace varchar(255),
4127         lsid_object varchar(255),
4128         lsid_revision varchar(255),
4129         protectedtitlecache bit not null,
4130         titleCache varchar(255),
4131         appendedphrase varchar(255),
4132         doubtful bit not null,
4133         usenamecache bit not null,
4134         taxonstatusunknown bit,
4135         unplaced bit,
4136         excluded bit,
4137         taxonomicchildrencount integer,
4138         createdby_id integer,
4139         updatedby_id integer,
4140         name_id integer,
4141         sec_id integer,
4142         taxonomicparentcache_id integer,
4143         primary key (id),
4144         unique (uuid)
4145     );
4146
4147     create table TaxonBase_AUD (
4148         DTYPE varchar(31) not null,
4149         id integer not null,
4150         REV integer not null,
4151         revtype tinyint,
4152         created timestamp,
4153         uuid varchar(36),
4154         updated timestamp,
4155         lsid_authority varchar(255),
4156         lsid_lsid varchar(255),
4157         lsid_namespace varchar(255),
4158         lsid_object varchar(255),
4159         lsid_revision varchar(255),
4160         protectedtitlecache bit,
4161         titleCache varchar(255),
4162         appendedphrase varchar(255),
4163         doubtful bit,
4164         usenamecache bit,
4165         createdby_id integer,
4166         updatedby_id integer,
4167         name_id integer,
4168         sec_id integer,
4169         taxonstatusunknown bit,
4170         unplaced bit,
4171         excluded bit,
4172         taxonomicchildrencount integer,
4173         taxonomicparentcache_id integer,
4174         primary key (id, REV)
4175     );
4176
4177     create table TaxonBase_Annotation (
4178         TaxonBase_id integer not null,
4179         annotations_id integer not null,
4180         primary key (TaxonBase_id, annotations_id),
4181         unique (annotations_id)
4182     );
4183
4184     create table TaxonBase_Annotation_AUD (
4185         REV integer not null,
4186         TaxonBase_id integer not null,
4187         annotations_id integer not null,
4188         revtype tinyint,
4189         primary key (REV, TaxonBase_id, annotations_id)
4190     );
4191
4192     create table TaxonBase_Credit (
4193         TaxonBase_id integer not null,
4194         credits_id integer not null,
4195         sortIndex integer not null,
4196         primary key (TaxonBase_id, sortIndex),
4197         unique (credits_id)
4198     );
4199
4200     create table TaxonBase_Credit_AUD (
4201         REV integer not null,
4202         TaxonBase_id integer not null,
4203         credits_id integer not null,
4204         sortIndex integer not null,
4205         revtype tinyint,
4206         primary key (REV, TaxonBase_id, credits_id, sortIndex)
4207     );
4208
4209     create table TaxonBase_Extension (
4210         TaxonBase_id integer not null,
4211         extensions_id integer not null,
4212         primary key (TaxonBase_id, extensions_id),
4213         unique (extensions_id)
4214     );
4215
4216     create table TaxonBase_Extension_AUD (
4217         REV integer not null,
4218         TaxonBase_id integer not null,
4219         extensions_id integer not null,
4220         revtype tinyint,
4221         primary key (REV, TaxonBase_id, extensions_id)
4222     );
4223
4224     create table TaxonBase_Marker (
4225         TaxonBase_id integer not null,
4226         markers_id integer not null,
4227         primary key (TaxonBase_id, markers_id),
4228         unique (markers_id)
4229     );
4230
4231     create table TaxonBase_Marker_AUD (
4232         REV integer not null,
4233         TaxonBase_id integer not null,
4234         markers_id integer not null,
4235         revtype tinyint,
4236         primary key (REV, TaxonBase_id, markers_id)
4237     );
4238
4239     create table TaxonBase_OriginalSourceBase (
4240         TaxonBase_id integer not null,
4241         sources_id integer not null,
4242         primary key (TaxonBase_id, sources_id),
4243         unique (sources_id)
4244     );
4245
4246     create table TaxonBase_OriginalSourceBase_AUD (
4247         REV integer not null,
4248         TaxonBase_id integer not null,
4249         sources_id integer not null,
4250         revtype tinyint,
4251         primary key (REV, TaxonBase_id, sources_id)
4252     );
4253
4254     create table TaxonBase_Rights (
4255         TaxonBase_id integer not null,
4256         rights_id integer not null,
4257         primary key (TaxonBase_id, rights_id),
4258         unique (rights_id)
4259     );
4260
4261     create table TaxonBase_Rights_AUD (
4262         REV integer not null,
4263         TaxonBase_id integer not null,
4264         rights_id integer not null,
4265         revtype tinyint,
4266         primary key (REV, TaxonBase_id, rights_id)
4267     );
4268
4269     create table TaxonInteraction_LanguageString (
4270         DescriptionElementBase_id integer not null,
4271         description_id integer not null,
4272         description_mapkey_id integer not null,
4273         primary key (DescriptionElementBase_id, description_mapkey_id),
4274         unique (description_id)
4275     );
4276
4277     create table TaxonInteraction_LanguageString_AUD (
4278         REV integer not null,
4279         DescriptionElementBase_id integer not null,
4280         description_id integer not null,
4281         description_mapkey_id integer not null,
4282         revtype tinyint,
4283         primary key (REV, DescriptionElementBase_id, description_id, description_mapkey_id)
4284     );
4285
4286     create table TaxonNameBase (
4287         DTYPE varchar(31) not null,
4288         id integer not null,
4289         created timestamp,
4290         uuid varchar(36),
4291         updated timestamp,
4292         lsid_authority varchar(255),
4293         lsid_lsid varchar(255),
4294         lsid_namespace varchar(255),
4295         lsid_object varchar(255),
4296         lsid_revision varchar(255),
4297         protectedtitlecache bit not null,
4298         titleCache varchar(255),
4299         appendedphrase varchar(255),
4300         fullTitleCache varchar(330),
4301         nomenclaturalmicroreference varchar(255),
4302         parsingproblem integer not null,
4303         problemends integer not null,
4304         problemstarts integer not null,
4305         protectedfulltitlecache bit not null,
4306         authorshipcache varchar(255),
4307         binomhybrid bit,
4308         genusoruninomial varchar(255),
4309         hybridformula bit,
4310         infragenericepithet varchar(255),
4311         infraspecificepithet varchar(255),
4312         monomhybrid bit,
4313         namecache varchar(255),
4314         protectedauthorshipcache bit,
4315         protectednamecache bit,
4316         specificepithet varchar(255),
4317         trinomhybrid bit,
4318         nameapprobation varchar(255),
4319         subgenusauthorship varchar(255),
4320         anamorphic bit,
4321         cultivarname varchar(255),
4322         acronym varchar(255),
4323         breed varchar(255),
4324         originalpublicationyear integer,
4325         publicationyear integer,
4326         createdby_id integer,
4327         updatedby_id integer,
4328         homotypicalgroup_id integer,
4329         nomenclaturalreference_id integer,
4330         rank_id integer,
4331         basionymauthorteam_id integer,
4332         combinationauthorteam_id integer,
4333         exbasionymauthorteam_id integer,
4334         excombinationauthorteam_id integer,
4335         primary key (id),
4336         unique (uuid)
4337     );
4338
4339     create table TaxonNameBase_AUD (
4340         DTYPE varchar(31) not null,
4341         id integer not null,
4342         REV integer not null,
4343         revtype tinyint,
4344         created timestamp,
4345         uuid varchar(36),
4346         updated timestamp,
4347         lsid_authority varchar(255),
4348         lsid_lsid varchar(255),
4349         lsid_namespace varchar(255),
4350         lsid_object varchar(255),
4351         lsid_revision varchar(255),
4352         protectedtitlecache bit,
4353         titleCache varchar(255),
4354         appendedphrase varchar(255),
4355         fullTitleCache varchar(330),
4356         nomenclaturalmicroreference varchar(255),
4357         parsingproblem integer,
4358         problemends integer,
4359         problemstarts integer,
4360         protectedfulltitlecache bit,
4361         createdby_id integer,
4362         updatedby_id integer,
4363         homotypicalgroup_id integer,
4364         nomenclaturalreference_id integer,
4365         rank_id integer,
4366         acronym varchar(255),
4367         authorshipcache varchar(255),
4368         binomhybrid bit,
4369         genusoruninomial varchar(255),
4370         hybridformula bit,
4371         infragenericepithet varchar(255),
4372         infraspecificepithet varchar(255),
4373         monomhybrid bit,
4374         namecache varchar(255),
4375         protectedauthorshipcache bit,
4376         protectednamecache bit,
4377         specificepithet varchar(255),
4378         trinomhybrid bit,
4379         basionymauthorteam_id integer,
4380         combinationauthorteam_id integer,
4381         exbasionymauthorteam_id integer,
4382         excombinationauthorteam_id integer,
4383         anamorphic bit,
4384         breed varchar(255),
4385         originalpublicationyear integer,
4386         publicationyear integer,
4387         cultivarname varchar(255),
4388         nameapprobation varchar(255),
4389         subgenusauthorship varchar(255),
4390         primary key (id, REV)
4391     );
4392
4393     create table TaxonNameBase_Annotation (
4394         TaxonNameBase_id integer not null,
4395         annotations_id integer not null,
4396         primary key (TaxonNameBase_id, annotations_id),
4397         unique (annotations_id)
4398     );
4399
4400     create table TaxonNameBase_Annotation_AUD (
4401         REV integer not null,
4402         TaxonNameBase_id integer not null,
4403         annotations_id integer not null,
4404         revtype tinyint,
4405         primary key (REV, TaxonNameBase_id, annotations_id)
4406     );
4407
4408     create table TaxonNameBase_Credit (
4409         TaxonNameBase_id integer not null,
4410         credits_id integer not null,
4411         sortIndex integer not null,
4412         primary key (TaxonNameBase_id, sortIndex),
4413         unique (credits_id)
4414     );
4415
4416     create table TaxonNameBase_Credit_AUD (
4417         REV integer not null,
4418         TaxonNameBase_id integer not null,
4419         credits_id integer not null,
4420         sortIndex integer not null,
4421         revtype tinyint,
4422         primary key (REV, TaxonNameBase_id, credits_id, sortIndex)
4423     );
4424
4425     create table TaxonNameBase_Extension (
4426         TaxonNameBase_id integer not null,
4427         extensions_id integer not null,
4428         primary key (TaxonNameBase_id, extensions_id),
4429         unique (extensions_id)
4430     );
4431
4432     create table TaxonNameBase_Extension_AUD (
4433         REV integer not null,
4434         TaxonNameBase_id integer not null,
4435         extensions_id integer not null,
4436         revtype tinyint,
4437         primary key (REV, TaxonNameBase_id, extensions_id)
4438     );
4439
4440     create table TaxonNameBase_Marker (
4441         TaxonNameBase_id integer not null,
4442         markers_id integer not null,
4443         primary key (TaxonNameBase_id, markers_id),
4444         unique (markers_id)
4445     );
4446
4447     create table TaxonNameBase_Marker_AUD (
4448         REV integer not null,
4449         TaxonNameBase_id integer not null,
4450         markers_id integer not null,
4451         revtype tinyint,
4452         primary key (REV, TaxonNameBase_id, markers_id)
4453     );
4454
4455     create table TaxonNameBase_NomenclaturalStatus (
4456         TaxonNameBase_id integer not null,
4457         status_id integer not null,
4458         primary key (TaxonNameBase_id, status_id),
4459         unique (status_id)
4460     );
4461
4462     create table TaxonNameBase_NomenclaturalStatus_AUD (
4463         REV integer not null,
4464         TaxonNameBase_id integer not null,
4465         status_id integer not null,
4466         revtype tinyint,
4467         primary key (REV, TaxonNameBase_id, status_id)
4468     );
4469
4470     create table TaxonNameBase_OriginalSourceBase (
4471         TaxonNameBase_id integer not null,
4472         sources_id integer not null,
4473         primary key (TaxonNameBase_id, sources_id),
4474         unique (sources_id)
4475     );
4476
4477     create table TaxonNameBase_OriginalSourceBase_AUD (
4478         REV integer not null,
4479         TaxonNameBase_id integer not null,
4480         sources_id integer not null,
4481         revtype tinyint,
4482         primary key (REV, TaxonNameBase_id, sources_id)
4483     );
4484
4485     create table TaxonNameBase_Rights (
4486         TaxonNameBase_id integer not null,
4487         rights_id integer not null,
4488         primary key (TaxonNameBase_id, rights_id),
4489         unique (rights_id)
4490     );
4491
4492     create table TaxonNameBase_Rights_AUD (
4493         REV integer not null,
4494         TaxonNameBase_id integer not null,
4495         rights_id integer not null,
4496         revtype tinyint,
4497         primary key (REV, TaxonNameBase_id, rights_id)
4498     );
4499
4500     create table TaxonNameBase_TypeDesignationBase (
4501         TaxonNameBase_id integer not null,
4502         typedesignations_id integer not null,
4503         primary key (TaxonNameBase_id, typedesignations_id)
4504     );
4505
4506     create table TaxonNameBase_TypeDesignationBase_AUD (
4507         REV integer not null,
4508         TaxonNameBase_id integer not null,
4509         typedesignations_id integer not null,
4510         revtype tinyint,
4511         primary key (REV, TaxonNameBase_id, typedesignations_id)
4512     );
4513
4514     create table TaxonNode (
4515         id integer not null,
4516         created timestamp,
4517         uuid varchar(36),
4518         updated timestamp,
4519         countchildren integer not null,
4520         microreferenceforparentchildrelation varchar(255),
4521         createdby_id integer,
4522         updatedby_id integer,
4523         parent_id integer,
4524         referenceforparentchildrelation_id integer,
4525         synonymtobeused_id integer,
4526         taxon_id integer,
4527         classification_id integer,
4528         primary key (id),
4529         unique (uuid)
4530     );
4531
4532     create table TaxonNode_AUD (
4533         id integer not null,
4534         REV integer not null,
4535         revtype tinyint,
4536         created timestamp,
4537         uuid varchar(36),
4538         updated timestamp,
4539         countchildren integer,
4540         microreferenceforparentchildrelation varchar(255),
4541         createdby_id integer,
4542         updatedby_id integer,
4543         parent_id integer,
4544         referenceforparentchildrelation_id integer,
4545         synonymtobeused_id integer,
4546         taxon_id integer,
4547         classification_id integer,
4548         primary key (id, REV)
4549     );
4550
4551     create table TaxonNode_Annotation (
4552         TaxonNode_id integer not null,
4553         annotations_id integer not null,
4554         primary key (TaxonNode_id, annotations_id),
4555         unique (annotations_id)
4556     );
4557
4558     create table TaxonNode_Annotation_AUD (
4559         REV integer not null,
4560         TaxonNode_id integer not null,
4561         annotations_id integer not null,
4562         revtype tinyint,
4563         primary key (REV, TaxonNode_id, annotations_id)
4564     );
4565
4566     create table TaxonNode_Marker (
4567         TaxonNode_id integer not null,
4568         markers_id integer not null,
4569         primary key (TaxonNode_id, markers_id),
4570         unique (markers_id)
4571     );
4572
4573     create table TaxonNode_Marker_AUD (
4574         REV integer not null,
4575         TaxonNode_id integer not null,
4576         markers_id integer not null,
4577         revtype tinyint,
4578         primary key (REV, TaxonNode_id, markers_id)
4579     );
4580
4581     create table TaxonRelationship (
4582         id integer not null,
4583         created timestamp,
4584         uuid varchar(36),
4585         updated timestamp,
4586         citationmicroreference varchar(255),
4587         originalnamestring varchar(255),
4588         doubtful bit not null,
4589         createdby_id integer,
4590         updatedby_id integer,
4591         citation_id integer,
4592         relatedfrom_id integer,
4593         relatedto_id integer,
4594         type_id integer,
4595         primary key (id),
4596         unique (uuid)
4597     );
4598
4599     create table TaxonRelationship_AUD (
4600         id integer not null,
4601         REV integer not null,
4602         revtype tinyint,
4603         created timestamp,
4604         uuid varchar(36),
4605         updated timestamp,
4606         citationmicroreference varchar(255),
4607         originalnamestring varchar(255),
4608         doubtful bit,
4609         createdby_id integer,
4610         updatedby_id integer,
4611         citation_id integer,
4612         relatedfrom_id integer,
4613         relatedto_id integer,
4614         type_id integer,
4615         primary key (id, REV)
4616     );
4617
4618     create table TaxonRelationship_Annotation (
4619         TaxonRelationship_id integer not null,
4620         annotations_id integer not null,
4621         primary key (TaxonRelationship_id, annotations_id),
4622         unique (annotations_id)
4623     );
4624
4625     create table TaxonRelationship_Annotation_AUD (
4626         REV integer not null,
4627         TaxonRelationship_id integer not null,
4628         annotations_id integer not null,
4629         revtype tinyint,
4630         primary key (REV, TaxonRelationship_id, annotations_id)
4631     );
4632
4633     create table TaxonRelationship_Marker (
4634         TaxonRelationship_id integer not null,
4635         markers_id integer not null,
4636         primary key (TaxonRelationship_id, markers_id),
4637         unique (markers_id)
4638     );
4639
4640     create table TaxonRelationship_Marker_AUD (
4641         REV integer not null,
4642         TaxonRelationship_id integer not null,
4643         markers_id integer not null,
4644         revtype tinyint,
4645         primary key (REV, TaxonRelationship_id, markers_id)
4646     );
4647
4648     create table TermVocabulary (
4649         DTYPE varchar(31) not null,
4650         id integer not null,
4651         created timestamp,
4652         uuid varchar(36),
4653         updated timestamp,
4654         lsid_authority varchar(255),
4655         lsid_lsid varchar(255),
4656         lsid_namespace varchar(255),
4657         lsid_object varchar(255),
4658         lsid_revision varchar(255),
4659         protectedtitlecache bit not null,
4660         titleCache varchar(255),
4661         uri varchar(255),
4662         termsourceuri varchar(255),
4663         createdby_id integer,
4664         updatedby_id integer,
4665         primary key (id),
4666         unique (uuid)
4667     );
4668
4669     create table TermVocabulary_AUD (
4670         DTYPE varchar(31) not null,
4671         id integer not null,
4672         REV integer not null,
4673         revtype tinyint,
4674         created timestamp,
4675         uuid varchar(36),
4676         updated timestamp,
4677         lsid_authority varchar(255),
4678         lsid_lsid varchar(255),
4679         lsid_namespace varchar(255),
4680         lsid_object varchar(255),
4681         lsid_revision varchar(255),
4682         protectedtitlecache bit,
4683         titleCache varchar(255),
4684         uri varchar(255),
4685         termsourceuri varchar(255),
4686         createdby_id integer,
4687         updatedby_id integer,
4688         primary key (id, REV)
4689     );
4690
4691     create table TermVocabulary_Annotation (
4692         TermVocabulary_id integer not null,
4693         annotations_id integer not null,
4694         primary key (TermVocabulary_id, annotations_id),
4695         unique (annotations_id)
4696     );
4697
4698     create table TermVocabulary_Annotation_AUD (
4699         REV integer not null,
4700         TermVocabulary_id integer not null,
4701         annotations_id integer not null,
4702         revtype tinyint,
4703         primary key (REV, TermVocabulary_id, annotations_id)
4704     );
4705
4706     create table TermVocabulary_Credit (
4707         TermVocabulary_id integer not null,
4708         credits_id integer not null,
4709         sortIndex integer not null,
4710         primary key (TermVocabulary_id, sortIndex),
4711         unique (credits_id)
4712     );
4713
4714     create table TermVocabulary_Credit_AUD (
4715         REV integer not null,
4716         TermVocabulary_id integer not null,
4717         credits_id integer not null,
4718         sortIndex integer not null,
4719         revtype tinyint,
4720         primary key (REV, TermVocabulary_id, credits_id, sortIndex)
4721     );
4722
4723     create table TermVocabulary_Extension (
4724         TermVocabulary_id integer not null,
4725         extensions_id integer not null,
4726         primary key (TermVocabulary_id, extensions_id),
4727         unique (extensions_id)
4728     );
4729
4730     create table TermVocabulary_Extension_AUD (
4731         REV integer not null,
4732         TermVocabulary_id integer not null,
4733         extensions_id integer not null,
4734         revtype tinyint,
4735         primary key (REV, TermVocabulary_id, extensions_id)
4736     );
4737
4738     create table TermVocabulary_Marker (
4739         TermVocabulary_id integer not null,
4740         markers_id integer not null,
4741         primary key (TermVocabulary_id, markers_id),
4742         unique (markers_id)
4743     );
4744
4745     create table TermVocabulary_Marker_AUD (
4746         REV integer not null,
4747         TermVocabulary_id integer not null,
4748         markers_id integer not null,
4749         revtype tinyint,
4750         primary key (REV, TermVocabulary_id, markers_id)
4751     );
4752
4753     create table TermVocabulary_OriginalSourceBase (
4754         TermVocabulary_id integer not null,
4755         sources_id integer not null,
4756         primary key (TermVocabulary_id, sources_id),
4757         unique (sources_id)
4758     );
4759
4760     create table TermVocabulary_OriginalSourceBase_AUD (
4761         REV integer not null,
4762         TermVocabulary_id integer not null,
4763         sources_id integer not null,
4764         revtype tinyint,
4765         primary key (REV, TermVocabulary_id, sources_id)
4766     );
4767
4768     create table TermVocabulary_Representation (
4769         TermVocabulary_id integer not null,
4770         representations_id integer not null,
4771         primary key (TermVocabulary_id, representations_id),
4772         unique (representations_id)
4773     );
4774
4775     create table TermVocabulary_Representation_AUD (
4776         REV integer not null,
4777         TermVocabulary_id integer not null,
4778         representations_id integer not null,
4779         revtype tinyint,
4780         primary key (REV, TermVocabulary_id, representations_id)
4781     );
4782
4783     create table TermVocabulary_Rights (
4784         TermVocabulary_id integer not null,
4785         rights_id integer not null,
4786         primary key (TermVocabulary_id, rights_id),
4787         unique (rights_id)
4788     );
4789
4790     create table TermVocabulary_Rights_AUD (
4791         REV integer not null,
4792         TermVocabulary_id integer not null,
4793         rights_id integer not null,
4794         revtype tinyint,
4795         primary key (REV, TermVocabulary_id, rights_id)
4796     );
4797
4798     create table TypeDesignationBase (
4799         DTYPE varchar(31) not null,
4800         id integer not null,
4801         created timestamp,
4802         uuid varchar(36),
4803         updated timestamp,
4804         citationmicroreference varchar(255),
4805         originalnamestring varchar(255),
4806         notdesignated bit not null,
4807         conservedtype bit,
4808         rejectedtype bit,
4809         createdby_id integer,
4810         updatedby_id integer,
4811         citation_id integer,
4812         homotypicalgroup_id integer,
4813         typestatus_id integer,
4814         typename_id integer,
4815         typespecimen_id integer,
4816         primary key (id),
4817         unique (uuid)
4818     );
4819
4820     create table TypeDesignationBase_AUD (
4821         DTYPE varchar(31) not null,
4822         id integer not null,
4823         REV integer not null,
4824         revtype tinyint,
4825         created timestamp,
4826         uuid varchar(36),
4827         updated timestamp,
4828         citationmicroreference varchar(255),
4829         originalnamestring varchar(255),
4830         notdesignated bit,
4831         createdby_id integer,
4832         updatedby_id integer,
4833         citation_id integer,
4834         homotypicalgroup_id integer,
4835         typestatus_id integer,
4836         typespecimen_id integer,
4837         conservedtype bit,
4838         rejectedtype bit,
4839         typename_id integer,
4840         primary key (id, REV)
4841     );
4842
4843     create table TypeDesignationBase_Annotation (
4844         TypeDesignationBase_id integer not null,
4845         annotations_id integer not null,
4846         primary key (TypeDesignationBase_id, annotations_id),
4847         unique (annotations_id)
4848     );
4849
4850     create table TypeDesignationBase_Annotation_AUD (
4851         REV integer not null,
4852         TypeDesignationBase_id integer not null,
4853         annotations_id integer not null,
4854         revtype tinyint,
4855         primary key (REV, TypeDesignationBase_id, annotations_id)
4856     );
4857
4858     create table TypeDesignationBase_Marker (
4859         TypeDesignationBase_id integer not null,
4860         markers_id integer not null,
4861         primary key (TypeDesignationBase_id, markers_id),
4862         unique (markers_id)
4863     );
4864
4865     create table TypeDesignationBase_Marker_AUD (
4866         REV integer not null,
4867         TypeDesignationBase_id integer not null,
4868         markers_id integer not null,
4869         revtype tinyint,
4870         primary key (REV, TypeDesignationBase_id, markers_id)
4871     );
4872
4873     create table TypeDesignationBase_TaxonNameBase (
4874         TypeDesignationBase_id integer not null,
4875         typifiednames_id integer not null,
4876         primary key (TypeDesignationBase_id, typifiednames_id)
4877     );
4878
4879     create table TypeDesignationBase_TaxonNameBase_AUD (
4880         REV integer not null,
4881         TypeDesignationBase_id integer not null,
4882         typifiednames_id integer not null,
4883         revtype tinyint,
4884         primary key (REV, TypeDesignationBase_id, typifiednames_id)
4885     );
4886
4887     create table UserAccount (
4888         id integer not null,
4889         created timestamp,
4890         uuid varchar(36),
4891         accountnonexpired bit not null,
4892         accountnonlocked bit not null,
4893         credentialsnonexpired bit not null,
4894         emailaddress varchar(255),
4895         enabled bit not null,
4896         password varchar(255),
4897         username varchar(255),
4898         createdby_id integer,
4899         person_id integer,
4900         primary key (id),
4901         unique (uuid, username)
4902     );
4903
4904     create table UserAccount_AUD (
4905         id integer not null,
4906         REV integer not null,
4907         revtype tinyint,
4908         created timestamp,
4909         uuid varchar(36),
4910         accountnonexpired bit,
4911         accountnonlocked bit,
4912         credentialsnonexpired bit,
4913         emailaddress varchar(255),
4914         enabled bit,
4915         username varchar(255),
4916         createdby_id integer,
4917         person_id integer,
4918         primary key (id, REV)
4919     );
4920
4921     create table UserAccount_GrantedAuthorityImpl (
4922         UserAccount_id integer not null,
4923         grantedauthorities_id integer not null,
4924         primary key (UserAccount_id, grantedauthorities_id)
4925     );
4926
4927     create table UserAccount_PermissionGroup (
4928         members_id integer not null,
4929         groups_id integer not null,
4930         primary key (members_id, groups_id)
4931     );
4932
4933     create table WorkingSet (
4934         DTYPE varchar(31) not null,
4935         id integer not null,
4936         created timestamp,
4937         uuid varchar(36),
4938         updated timestamp,
4939         createdby_id integer,
4940         updatedby_id integer,
4941         descriptivesystem_id integer,
4942         primary key (id),
4943         unique (uuid)
4944     );
4945
4946     create table WorkingSet_AUD (
4947         DTYPE varchar(31) not null,
4948         id integer not null,
4949         REV integer not null,
4950         revtype tinyint,
4951         created timestamp,
4952         uuid varchar(36),
4953         updated timestamp,
4954         createdby_id integer,
4955         updatedby_id integer,
4956         descriptivesystem_id integer,
4957         primary key (id, REV)
4958     );
4959
4960     create table WorkingSet_Annotation (
4961         WorkingSet_id integer not null,
4962         annotations_id integer not null,
4963         primary key (WorkingSet_id, annotations_id),
4964         unique (annotations_id)
4965     );
4966
4967     create table WorkingSet_Annotation_AUD (
4968         REV integer not null,
4969         WorkingSet_id integer not null,
4970         annotations_id integer not null,
4971         revtype tinyint,
4972         primary key (REV, WorkingSet_id, annotations_id)
4973     );
4974
4975     create table WorkingSet_DescriptionBase (
4976         WorkingSet_id integer not null,
4977         descriptions_id integer not null,
4978         primary key (WorkingSet_id, descriptions_id)
4979     );
4980
4981     create table WorkingSet_DescriptionBase_AUD (
4982         REV integer not null,
4983         WorkingSet_id integer not null,
4984         descriptions_id integer not null,
4985         revtype tinyint,
4986         primary key (REV, WorkingSet_id, descriptions_id)
4987     );
4988
4989     create table WorkingSet_Marker (
4990         WorkingSet_id integer not null,
4991         markers_id integer not null,
4992         primary key (WorkingSet_id, markers_id),
4993         unique (markers_id)
4994     );
4995
4996     create table WorkingSet_Marker_AUD (
4997         REV integer not null,
4998         WorkingSet_id integer not null,
4999         markers_id integer not null,
5000         revtype tinyint,
5001         primary key (REV, WorkingSet_id, markers_id)
5002     );
5003
5004     create table WorkingSet_Representation (
5005         WorkingSet_id integer not null,
5006         representations_id integer not null,
5007         primary key (WorkingSet_id, representations_id),
5008         unique (representations_id)
5009     );
5010
5011     create table WorkingSet_Representation_AUD (
5012         REV integer not null,
5013         WorkingSet_id integer not null,
5014         representations_id integer not null,
5015         revtype tinyint,
5016         primary key (REV, WorkingSet_id, representations_id)
5017     );
5018
5019     create table WorkingSet_TaxonBase (
5020         WorkingSet_id integer not null,
5021         coveredtaxa_id integer not null,
5022         primary key (WorkingSet_id, coveredtaxa_id)
5023     );
5024
5025     create table WorkingSet_TaxonBase_AUD (
5026         REV integer not null,
5027         WorkingSet_id integer not null,
5028         coveredtaxa_id integer not null,
5029         revtype tinyint,
5030         primary key (REV, WorkingSet_id, coveredtaxa_id)
5031     );
5032
5033     alter table Address
5034         add constraint FK1ED033D44FF2DB2C
5035         foreign key (createdby_id)
5036         references UserAccount;
5037
5038     alter table Address
5039         add constraint FK1ED033D4132A2FE8
5040         foreign key (location_referencesystem_id)
5041         references DefinedTermBase;
5042
5043     alter table Address
5044         add constraint FK1ED033D42687715A
5045         foreign key (country_id)
5046         references DefinedTermBase;
5047
5048     alter table Address
5049         add constraint FK1ED033D4BC5DA539
5050         foreign key (updatedby_id)
5051         references UserAccount;
5052
5053     alter table Address_AUD
5054         add constraint FK115657A534869AAE
5055         foreign key (REV)
5056         references AuditEvent;
5057
5058     create index agentTitleCacheIndex on AgentBase (titleCache);
5059
5060     alter table AgentBase
5061         add constraint FK1205D3564FF2DB2C
5062         foreign key (createdby_id)
5063         references UserAccount;
5064
5065     alter table AgentBase
5066         add constraint FK1205D356A830578
5067         foreign key (ispartof_id)
5068         references AgentBase;
5069
5070     alter table AgentBase
5071         add constraint FK1205D356BC5DA539
5072         foreign key (updatedby_id)
5073         references UserAccount;
5074
5075     alter table AgentBase_AUD
5076         add constraint FK29CC662734869AAE
5077         foreign key (REV)
5078         references AuditEvent;
5079
5080     alter table AgentBase_Address
5081         add constraint FK1EDFF7EB86EFC5D4
5082         foreign key (AgentBase_id)
5083         references AgentBase;
5084
5085     alter table AgentBase_Address
5086         add constraint FK1EDFF7EB50751EC5
5087         foreign key (contact_addresses_id)
5088         references Address;
5089
5090     alter table AgentBase_Address_AUD
5091         add constraint FK3D28383C34869AAE
5092         foreign key (REV)
5093         references AuditEvent;
5094
5095     alter table AgentBase_AgentBase
5096         add constraint FK4D34EDAD1C0E9907
5097         foreign key (AgentBase_id)
5098         references AgentBase;
5099
5100     alter table AgentBase_AgentBase
5101         add constraint FK4D34EDADE9E535F9
5102         foreign key (teammembers_id)
5103         references AgentBase;
5104
5105     alter table AgentBase_AgentBase_AUD
5106         add constraint FKA8A87CFE34869AAE
5107         foreign key (REV)
5108         references AuditEvent;
5109
5110     alter table AgentBase_Annotation
5111         add constraint FK44D5F7D886EFC5D4
5112         foreign key (AgentBase_id)
5113         references AgentBase;
5114
5115     alter table AgentBase_Annotation
5116         add constraint FK44D5F7D81E403E0B
5117         foreign key (annotations_id)
5118         references Annotation;
5119
5120     alter table AgentBase_Annotation_AUD
5121         add constraint FK771279A934869AAE
5122         foreign key (REV)
5123         references AuditEvent;
5124
5125     alter table AgentBase_Credit
5126         add constraint FK2636742286EFC5D4
5127         foreign key (AgentBase_id)
5128         references AgentBase;
5129
5130     alter table AgentBase_Credit
5131         add constraint FK2636742232D1B9F
5132         foreign key (credits_id)
5133         references Credit;
5134
5135     alter table AgentBase_Credit_AUD
5136         add constraint FK7FE7C0F334869AAE
5137         foreign key (REV)
5138         references AuditEvent;
5139
5140     alter table AgentBase_DefinedTermBase
5141         add constraint FK6665C77D8D9AB196
5142         foreign key (AgentBase_id)
5143         references AgentBase;
5144
5145     alter table AgentBase_DefinedTermBase
5146         add constraint FK6665C77D9A161BED
5147         foreign key (types_id)
5148         references DefinedTermBase;
5149
5150     alter table AgentBase_DefinedTermBase_AUD
5151         add constraint FKA737EECE34869AAE
5152         foreign key (REV)
5153         references AuditEvent;
5154
5155     alter table AgentBase_Extension
5156         add constraint FK8E1E567686EFC5D4
5157         foreign key (AgentBase_id)
5158         references AgentBase;
5159
5160     alter table AgentBase_Extension
5161         add constraint FK8E1E5676927DE9DF
5162         foreign key (extensions_id)
5163         references Extension;
5164
5165     alter table AgentBase_Extension_AUD
5166         add constraint FK11AE594734869AAE
5167         foreign key (REV)
5168         references AuditEvent;
5169
5170     alter table AgentBase_Marker
5171         add constraint FK365D5D63777265A1
5172         foreign key (markers_id)
5173         references Marker;
5174
5175     alter table AgentBase_Marker
5176         add constraint FK365D5D6386EFC5D4
5177         foreign key (AgentBase_id)
5178         references AgentBase;
5179
5180     alter table AgentBase_Marker_AUD
5181         add constraint FKE40621B434869AAE
5182         foreign key (REV)
5183         references AuditEvent;
5184
5185     alter table AgentBase_Media
5186         add constraint FKE8FC5D9B86EFC5D4
5187         foreign key (AgentBase_id)
5188         references AgentBase;
5189
5190     alter table AgentBase_Media
5191         add constraint FKE8FC5D9BC2C29593
5192         foreign key (media_id)
5193         references Media;
5194
5195     alter table AgentBase_Media_AUD
5196         add constraint FK323A45EC34869AAE
5197         foreign key (REV)
5198         references AuditEvent;
5199
5200     alter table AgentBase_OriginalSourceBase
5201         add constraint FKB482C5E686EFC5D4
5202         foreign key (AgentBase_id)
5203         references AgentBase;
5204
5205     alter table AgentBase_OriginalSourceBase
5206         add constraint FKB482C5E63A6735D9
5207         foreign key (sources_id)
5208         references OriginalSourceBase;
5209
5210     alter table AgentBase_OriginalSourceBase_AUD
5211         add constraint FK886D90B734869AAE
5212         foreign key (REV)
5213         references AuditEvent;
5214
5215     alter table AgentBase_Rights
5216         add constraint FK3F514B0086EFC5D4
5217         foreign key (AgentBase_id)
5218         references AgentBase;
5219
5220     alter table AgentBase_Rights
5221         add constraint FK3F514B00C13F7B21
5222         foreign key (rights_id)
5223         references Rights;
5224
5225     alter table AgentBase_Rights_AUD
5226         add constraint FK4FDFF8D134869AAE
5227         foreign key (REV)
5228         references AuditEvent;
5229
5230     alter table AgentBase_contact_emailaddresses
5231         add constraint FK4BD2B08E86EFC5D4
5232         foreign key (AgentBase_id)
5233         references AgentBase;
5234
5235     alter table AgentBase_contact_emailaddresses_AUD
5236         add constraint FKCAF7E75F34869AAE
5237         foreign key (REV)
5238         references AuditEvent;
5239
5240     alter table AgentBase_contact_faxnumbers
5241         add constraint FK52E1AD9586EFC5D4
5242         foreign key (AgentBase_id)
5243         references AgentBase;
5244
5245     alter table AgentBase_contact_faxnumbers_AUD
5246         add constraint FK88A308E634869AAE
5247         foreign key (REV)
5248         references AuditEvent;
5249
5250     alter table AgentBase_contact_phonenumbers
5251         add constraint FKC171CC2486EFC5D4
5252         foreign key (AgentBase_id)
5253         references AgentBase;
5254
5255     alter table AgentBase_contact_phonenumbers_AUD
5256         add constraint FKDDD347F534869AAE
5257         foreign key (REV)
5258         references AuditEvent;
5259
5260     alter table AgentBase_contact_urls
5261         add constraint FK9A9643EC86EFC5D4
5262         foreign key (AgentBase_id)
5263         references AgentBase;
5264
5265     alter table AgentBase_contact_urls_AUD
5266         add constraint FK1CE69BBD34869AAE
5267         foreign key (REV)
5268         references AuditEvent;
5269
5270     alter table Annotation
5271         add constraint FK1A21C74F4FF2DB2C
5272         foreign key (createdby_id)
5273         references UserAccount;
5274
5275     alter table Annotation
5276         add constraint FK1A21C74FE7692740
5277         foreign key (commentator_id)
5278         references AgentBase;
5279
5280     alter table Annotation
5281         add constraint FK1A21C74FDF299D00
5282         foreign key (annotationtype_id)
5283         references DefinedTermBase;
5284
5285     alter table Annotation
5286         add constraint FK1A21C74FE8D36B00
5287         foreign key (language_id)
5288         references DefinedTermBase;
5289
5290     alter table Annotation
5291         add constraint FK1A21C74FBC5DA539
5292         foreign key (updatedby_id)
5293         references UserAccount;
5294
5295     alter table Annotation_AUD
5296         add constraint FK1A6BB5A034869AAE
5297         foreign key (REV)
5298         references AuditEvent;
5299
5300     alter table Annotation_Annotation
5301         add constraint FKC99DFE3F994CCE20
5302         foreign key (Annotation_id)
5303         references Annotation;
5304
5305     alter table Annotation_Annotation
5306         add constraint FKC99DFE3F1E403E0B
5307         foreign key (annotations_id)
5308         references Annotation;
5309
5310     alter table Annotation_Annotation_AUD
5311         add constraint FKB212F49034869AAE
5312         foreign key (REV)
5313         references AuditEvent;
5314
5315     alter table Annotation_Marker
5316         add constraint FKB17EAF4A777265A1
5317         foreign key (markers_id)
5318         references Marker;
5319
5320     alter table Annotation_Marker
5321         add constraint FKB17EAF4A994CCE20
5322         foreign key (Annotation_id)
5323         references Annotation;
5324
5325     alter table Annotation_Marker_AUD
5326         add constraint FK68CE281B34869AAE
5327         foreign key (REV)
5328         references AuditEvent;
5329
5330     alter table CDM_VIEW
5331         add constraint FKC5DE8EF84FF2DB2C
5332         foreign key (createdby_id)
5333         references UserAccount;
5334
5335     alter table CDM_VIEW
5336         add constraint FKC5DE8EF8765B124B
5337         foreign key (reference_id)
5338         references Reference;
5339
5340     alter table CDM_VIEW_CDM_VIEW
5341         add constraint FK230A885F7208BB38
5342         foreign key (superviews_id)
5343         references CDM_VIEW;
5344
5345     alter table CDM_VIEW_CDM_VIEW
5346         add constraint FK230A885FC00D1213
5347         foreign key (CDM_VIEW_id)
5348         references CDM_VIEW;
5349
5350     create index collectionTitleCacheIndex on Collection (titleCache);
5351
5352     alter table Collection
5353         add constraint FKF078ABE4FF2DB2C
5354         foreign key (createdby_id)
5355         references UserAccount;
5356
5357     alter table Collection
5358         add constraint FKF078ABE16B9CA77
5359         foreign key (institute_id)
5360         references AgentBase;
5361
5362     alter table Collection
5363         add constraint FKF078ABECEB38EFF
5364         foreign key (supercollection_id)
5365         references Collection;
5366
5367     alter table Collection
5368         add constraint FKF078ABEBC5DA539
5369         foreign key (updatedby_id)
5370         references UserAccount;
5371
5372     alter table Collection_AUD
5373         add constraint FKD6D4298F34869AAE
5374         foreign key (REV)
5375         references AuditEvent;
5376
5377     alter table Collection_Annotation
5378         add constraint FKEA970F70EB62BE9A
5379         foreign key (Collection_id)
5380         references Collection;
5381
5382     alter table Collection_Annotation
5383         add constraint FKEA970F701E403E0B
5384         foreign key (annotations_id)
5385         references Annotation;
5386
5387     alter table Collection_Annotation_AUD
5388         add constraint FKA0CE054134869AAE
5389         foreign key (REV)
5390         references AuditEvent;
5391
5392     alter table Collection_Credit
5393         add constraint FKE0A317BAEB62BE9A
5394         foreign key (Collection_id)
5395         references Collection;
5396
5397     alter table Collection_Credit
5398         add constraint FKE0A317BA32D1B9F
5399         foreign key (credits_id)
5400         references Credit;
5401
5402     alter table Collection_Credit_AUD
5403         add constraint FK25A8D88B34869AAE
5404         foreign key (REV)
5405         references AuditEvent;
5406
5407     alter table Collection_Extension
5408         add constraint FKF68FEBDEEB62BE9A
5409         foreign key (Collection_id)
5410         references Collection;
5411
5412     alter table Collection_Extension
5413         add constraint FKF68FEBDE927DE9DF
5414         foreign key (extensions_id)
5415         references Extension;
5416
5417     alter table Collection_Extension_AUD
5418         add constraint FK1306FAAF34869AAE
5419         foreign key (REV)
5420         references AuditEvent;
5421
5422     alter table Collection_Marker
5423         add constraint FKF0CA00FBEB62BE9A
5424         foreign key (Collection_id)
5425         references Collection;
5426
5427     alter table Collection_Marker
5428         add constraint FKF0CA00FB777265A1
5429         foreign key (markers_id)
5430         references Marker;
5431
5432     alter table Collection_Marker_AUD
5433         add constraint FK89C7394C34869AAE
5434         foreign key (REV)
5435         references AuditEvent;
5436
5437     alter table Collection_Media
5438         add constraint FK7320E703EB62BE9A
5439         foreign key (Collection_id)
5440         references Collection;
5441
5442     alter table Collection_Media
5443         add constraint FK7320E703C2C29593
5444         foreign key (media_id)
5445         references Media;
5446
5447     alter table Collection_Media_AUD
5448         add constraint FK9AABDB5434869AAE
5449         foreign key (REV)
5450         references AuditEvent;
5451
5452     alter table Collection_OriginalSourceBase
5453         add constraint FK37DEC57EEB62BE9A
5454         foreign key (Collection_id)
5455         references Collection;
5456
5457     alter table Collection_OriginalSourceBase
5458         add constraint FK37DEC57E3A6735D9
5459         foreign key (sources_id)
5460         references OriginalSourceBase;
5461
5462     alter table Collection_OriginalSourceBase_AUD
5463         add constraint FKF810044F34869AAE
5464         foreign key (REV)
5465         references AuditEvent;
5466
5467     alter table Collection_Rights
5468         add constraint FKF9BDEE98EB62BE9A
5469         foreign key (Collection_id)
5470         references Collection;
5471
5472     alter table Collection_Rights
5473         add constraint FKF9BDEE98C13F7B21
5474         foreign key (rights_id)
5475         references Rights;
5476
5477     alter table Collection_Rights_AUD
5478         add constraint FKF5A1106934869AAE
5479         foreign key (REV)
5480         references AuditEvent;
5481
5482     alter table Credit
5483         add constraint FK78CA97194FF2DB2C
5484         foreign key (createdby_id)
5485         references UserAccount;
5486
5487     alter table Credit
5488         add constraint FK78CA9719F7976FC5
5489         foreign key (agent_id)
5490         references AgentBase;
5491
5492     alter table Credit
5493         add constraint FK78CA9719E8D36B00
5494         foreign key (language_id)
5495         references DefinedTermBase;
5496
5497     alter table Credit
5498         add constraint FK78CA9719BC5DA539
5499         foreign key (updatedby_id)
5500         references UserAccount;
5501
5502     alter table Credit_AUD
5503         add constraint FK5533906A34869AAE
5504         foreign key (REV)
5505         references AuditEvent;
5506
5507     alter table Credit_Annotation
5508         add constraint FKE8DA4C354CF694E0
5509         foreign key (Credit_id)
5510         references Credit;
5511
5512     alter table Credit_Annotation
5513         add constraint FKE8DA4C351E403E0B
5514         foreign key (annotations_id)
5515         references Annotation;
5516
5517     alter table Credit_Annotation_AUD
5518         add constraint FK1DEB578634869AAE
5519         foreign key (REV)
5520         references AuditEvent;
5521
5522     alter table Credit_Marker
5523         add constraint FK10CC6840777265A1
5524         foreign key (markers_id)
5525         references Marker;
5526
5527     alter table Credit_Marker
5528         add constraint FK10CC68404CF694E0
5529         foreign key (Credit_id)
5530         references Credit;
5531
5532     alter table Credit_Marker_AUD
5533         add constraint FK880A761134869AAE
5534         foreign key (REV)
5535         references AuditEvent;
5536
5537     alter table DefinedTermBase
5538         add constraint FK2E340A664FF2DB2C
5539         foreign key (createdby_id)
5540         references UserAccount;
5541
5542     alter table DefinedTermBase
5543         add constraint FK2E340A66D040DBF0
5544         foreign key (partof_id)
5545         references DefinedTermBase;
5546
5547     alter table DefinedTermBase
5548         add constraint FK2E340A66CC0240B6
5549         foreign key (shape_id)
5550         references Media;
5551
5552     alter table DefinedTermBase
5553         add constraint FK2E340A6647AF954C
5554         foreign key (vocabulary_id)
5555         references TermVocabulary;
5556
5557     alter table DefinedTermBase
5558         add constraint FK2E340A6624AF3F70
5559         foreign key (level_id)
5560         references DefinedTermBase;
5561
5562     alter table DefinedTermBase
5563         add constraint FK2E340A6688206484
5564         foreign key (type_id)
5565         references DefinedTermBase;
5566
5567     alter table DefinedTermBase
5568         add constraint FK2E340A6636C6F6F6
5569         foreign key (pointapproximation_referencesystem_id)
5570         references DefinedTermBase;
5571
5572     alter table DefinedTermBase
5573         add constraint FK2E340A663B0DA0EF
5574         foreign key (kindof_id)
5575         references DefinedTermBase;
5576
5577     alter table DefinedTermBase
5578         add constraint FK2E340A66BC5DA539
5579         foreign key (updatedby_id)
5580         references UserAccount;
5581
5582     alter table DefinedTermBase_AUD
5583         add constraint FK86E8953734869AAE
5584         foreign key (REV)
5585         references AuditEvent;
5586
5587     alter table DefinedTermBase_Annotation
5588         add constraint FK589B6C8C0DB4934
5589         foreign key (DefinedTermBase_id)
5590         references DefinedTermBase;
5591
5592     alter table DefinedTermBase_Annotation
5593         add constraint FK589B6C81E403E0B
5594         foreign key (annotations_id)
5595         references Annotation;
5596
5597     alter table DefinedTermBase_Annotation_AUD
5598         add constraint FK28ED409934869AAE
5599         foreign key (REV)
5600         references AuditEvent;
5601
5602     alter table DefinedTermBase_Continent
5603         add constraint FK45F60AFB3927C853
5604         foreign key (continents_id)
5605         references DefinedTermBase;
5606
5607     alter table DefinedTermBase_Continent
5608         add constraint FK45F60AFBE8CE10AA
5609         foreign key (DefinedTermBase_id)
5610         references DefinedTermBase;
5611
5612     alter table DefinedTermBase_Continent_AUD
5613         add constraint FKF5DE434C34869AAE
5614         foreign key (REV)
5615         references AuditEvent;
5616
5617     alter table DefinedTermBase_Credit
5618         add constraint FK78FF2B12C0DB4934
5619         foreign key (DefinedTermBase_id)
5620         references DefinedTermBase;
5621
5622     alter table DefinedTermBase_Credit
5623         add constraint FK78FF2B1232D1B9F
5624         foreign key (credits_id)
5625         references Credit;
5626
5627     alter table DefinedTermBase_Credit_AUD
5628         add constraint FK409B7FE334869AAE
5629         foreign key (REV)
5630         references AuditEvent;
5631
5632     alter table DefinedTermBase_Extension
5633         add constraint FK397EF986927DE9DF
5634         foreign key (extensions_id)
5635         references Extension;
5636
5637     alter table DefinedTermBase_Extension
5638         add constraint FK397EF986C0DB4934
5639         foreign key (DefinedTermBase_id)
5640         references DefinedTermBase;
5641
5642     alter table DefinedTermBase_Extension_AUD
5643         add constraint FK6E6F45734869AAE
5644         foreign key (REV)
5645         references AuditEvent;
5646
5647     alter table DefinedTermBase_Marker
5648         add constraint FK89261453777265A1
5649         foreign key (markers_id)
5650         references Marker;
5651
5652     alter table DefinedTermBase_Marker
5653         add constraint FK89261453C0DB4934
5654         foreign key (DefinedTermBase_id)
5655         references DefinedTermBase;
5656
5657     alter table DefinedTermBase_Marker_AUD
5658         add constraint FKA4B9E0A434869AAE
5659         foreign key (REV)
5660         references AuditEvent;
5661
5662     alter table DefinedTermBase_MeasurementUnit
5663         add constraint FKE9D17767D0BDAE9B
5664         foreign key (DefinedTermBase_id)
5665         references DefinedTermBase;
5666
5667     alter table DefinedTermBase_MeasurementUnit
5668         add constraint FKE9D17767F3BB39BD
5669         foreign key (recommendedmeasurementunits_id)
5670         references DefinedTermBase;
5671
5672     alter table DefinedTermBase_MeasurementUnit_AUD
5673         add constraint FK2C1599B834869AAE
5674         foreign key (REV)
5675         references AuditEvent;
5676
5677     alter table DefinedTermBase_Media
5678         add constraint FK6FC908ABC0DB4934
5679         foreign key (DefinedTermBase_id)
5680         references DefinedTermBase;
5681
5682     alter table DefinedTermBase_Media
5683         add constraint FK6FC908ABC2C29593
5684         foreign key (media_id)
5685         references Media;
5686
5687     alter table DefinedTermBase_Media_AUD
5688         add constraint FKDD9AE8FC34869AAE
5689         foreign key (REV)
5690         references AuditEvent;
5691
5692     alter table DefinedTermBase_OriginalSourceBase
5693         add constraint FKDCC094D6C0DB4934
5694         foreign key (DefinedTermBase_id)
5695         references DefinedTermBase;
5696
5697     alter table DefinedTermBase_OriginalSourceBase
5698         add constraint FKDCC094D63A6735D9
5699         foreign key (sources_id)
5700         references OriginalSourceBase;
5701
5702     alter table DefinedTermBase_OriginalSourceBase_AUD
5703         add constraint FKAE4A67A734869AAE
5704         foreign key (REV)
5705         references AuditEvent;
5706
5707     alter table DefinedTermBase_RecommendedModifierEnumeration
5708         add constraint FKA72FB5AED0BDAE9B
5709         foreign key (DefinedTermBase_id)
5710         references DefinedTermBase;
5711
5712     alter table DefinedTermBase_RecommendedModifierEnumeration
5713         add constraint FKA72FB5AE5255EAFD
5714         foreign key (recommendedmodifierenumeration_id)
5715         references TermVocabulary;
5716
5717     alter table DefinedTermBase_RecommendedModifierEnumeration_AUD
5718         add constraint FK780D5C7F34869AAE
5719         foreign key (REV)
5720         references AuditEvent;
5721
5722     alter table DefinedTermBase_Representation
5723         add constraint FKAAC8AFE6B31C4747
5724         foreign key (representations_id)
5725         references Representation;
5726
5727     alter table DefinedTermBase_Representation
5728         add constraint FKAAC8AFE6C0DB4934
5729         foreign key (DefinedTermBase_id)
5730         references DefinedTermBase;
5731
5732     alter table DefinedTermBase_Representation_AUD
5733         add constraint FKB5AE7AB734869AAE
5734         foreign key (REV)
5735         references AuditEvent;
5736
5737     alter table DefinedTermBase_Rights
5738         add constraint FK921A01F0C0DB4934
5739         foreign key (DefinedTermBase_id)
5740         references DefinedTermBase;
5741
5742     alter table DefinedTermBase_Rights
5743         add constraint FK921A01F0C13F7B21
5744         foreign key (rights_id)
5745         references Rights;
5746
5747     alter table DefinedTermBase_Rights_AUD
5748         add constraint FK1093B7C134869AAE
5749         foreign key (REV)
5750         references AuditEvent;
5751
5752     alter table DefinedTermBase_StatisticalMeasure
5753         add constraint FK6FF15DFCD0BDAE9B
5754         foreign key (DefinedTermBase_id)
5755         references DefinedTermBase;
5756
5757     alter table DefinedTermBase_StatisticalMeasure
5758         add constraint FK6FF15DFCC9CD5B57
5759         foreign key (recommendedstatisticalmeasures_id)
5760         references DefinedTermBase;
5761
5762     alter table DefinedTermBase_StatisticalMeasure_AUD
5763         add constraint FK3C062DCD34869AAE
5764         foreign key (REV)
5765         references AuditEvent;
5766
5767     alter table DefinedTermBase_SupportedCategoricalEnumeration
5768         add constraint FK2170B25CD0BDAE9B
5769         foreign key (DefinedTermBase_id)
5770         references DefinedTermBase;
5771
5772     alter table DefinedTermBase_SupportedCategoricalEnumeration
5773         add constraint FK2170B25C5AF2C74
5774         foreign key (supportedcategoricalenumerations_id)
5775         references TermVocabulary;
5776
5777     alter table DefinedTermBase_SupportedCategoricalEnumeration_AUD
5778         add constraint FKBB04522D34869AAE
5779         foreign key (REV)
5780         references AuditEvent;
5781
5782     alter table DefinedTermBase_WaterbodyOrCountry
5783         add constraint FKCAF43931603B036
5784         foreign key (waterbodiesorcountries_id)
5785         references DefinedTermBase;
5786
5787     alter table DefinedTermBase_WaterbodyOrCountry
5788         add constraint FKCAF4393CE5C0F9E
5789         foreign key (DefinedTermBase_id)
5790         references DefinedTermBase;
5791
5792     alter table DefinedTermBase_WaterbodyOrCountry_AUD
5793         add constraint FKD5996FE434869AAE
5794         foreign key (REV)
5795         references AuditEvent;
5796
5797     alter table DerivationEvent
5798         add constraint FK426BC034FF2DB2C
5799         foreign key (createdby_id)
5800         references UserAccount;
5801
5802     alter table DerivationEvent
5803         add constraint FK426BC033DA462D5
5804         foreign key (actor_id)
5805         references AgentBase;
5806
5807     alter table DerivationEvent
5808         add constraint FK426BC038524B89D
5809         foreign key (type_id)
5810         references DefinedTermBase;
5811
5812     alter table DerivationEvent
5813         add constraint FK426BC03BC5DA539
5814         foreign key (updatedby_id)
5815         references UserAccount;
5816
5817     alter table DerivationEvent_AUD
5818         add constraint FKDABF305434869AAE
5819         foreign key (REV)
5820         references AuditEvent;
5821
5822     alter table DerivationEvent_Annotation
5823         add constraint FKEFA0D10B4AAB411A
5824         foreign key (DerivationEvent_id)
5825         references DerivationEvent;
5826
5827     alter table DerivationEvent_Annotation
5828         add constraint FKEFA0D10B1E403E0B
5829         foreign key (annotations_id)
5830         references Annotation;
5831
5832     alter table DerivationEvent_Annotation_AUD
5833         add constraint FKA197815C34869AAE
5834         foreign key (REV)
5835         references AuditEvent;
5836
5837     alter table DerivationEvent_Marker
5838         add constraint FKE412C816777265A1
5839         foreign key (markers_id)
5840         references Marker;
5841
5842     alter table DerivationEvent_Marker
5843         add constraint FKE412C8164AAB411A
5844         foreign key (DerivationEvent_id)
5845         references DerivationEvent;
5846
5847     alter table DerivationEvent_Marker_AUD
5848         add constraint FK8ED0FAE734869AAE
5849         foreign key (REV)
5850         references AuditEvent;
5851
5852     alter table DescriptionBase
5853         add constraint FKFF4D58CD4FF2DB2C
5854         foreign key (createdby_id)
5855         references UserAccount;
5856
5857     alter table DescriptionBase
5858         add constraint FKFF4D58CDDE9A3DE3
5859         foreign key (taxon_id)
5860         references TaxonBase;
5861
5862     alter table DescriptionBase
5863         add constraint FKFF4D58CDDA93512F
5864         foreign key (taxonname_id)
5865         references TaxonNameBase;
5866
5867     alter table DescriptionBase
5868         add constraint FKFF4D58CDBC5DA539
5869         foreign key (updatedby_id)
5870         references UserAccount;
5871
5872     alter table DescriptionBase_AUD
5873         add constraint FK7456581E34869AAE
5874         foreign key (REV)
5875         references AuditEvent;
5876
5877     alter table DescriptionBase_Annotation
5878         add constraint FKF3AD3201F1DDBFAB
5879         foreign key (DescriptionBase_id)
5880         references DescriptionBase;
5881
5882     alter table DescriptionBase_Annotation
5883         add constraint FKF3AD32011E403E0B
5884         foreign key (annotations_id)
5885         references Annotation;
5886
5887     alter table DescriptionBase_Annotation_AUD
5888         add constraint FK15FE775234869AAE
5889         foreign key (REV)
5890         references AuditEvent;
5891
5892     alter table DescriptionBase_Credit
5893         add constraint FK510B2ACBF1DDBFAB
5894         foreign key (DescriptionBase_id)
5895         references DescriptionBase;
5896
5897     alter table DescriptionBase_Credit
5898         add constraint FK510B2ACB32D1B9F
5899         foreign key (credits_id)
5900         references Credit;
5901
5902     alter table DescriptionBase_Credit_AUD
5903         add constraint FK2EBEFB1C34869AAE
5904         foreign key (REV)
5905         references AuditEvent;
5906
5907     alter table DescriptionBase_Extension
5908         add constraint FKD5D2B32DF1DDBFAB
5909         foreign key (DescriptionBase_id)
5910         references DescriptionBase;
5911
5912     alter table DescriptionBase_Extension
5913         add constraint FKD5D2B32D927DE9DF
5914         foreign key (extensions_id)
5915         references Extension;
5916
5917     alter table DescriptionBase_Extension_AUD
5918         add constraint FK79E7827E34869AAE
5919         foreign key (REV)
5920         references AuditEvent;
5921
5922     alter table DescriptionBase_Feature
5923         add constraint FK58ACF564F1DDBFAB
5924         foreign key (DescriptionBase_id)
5925         references DescriptionBase;
5926
5927     alter table DescriptionBase_Feature
5928         add constraint FK58ACF5649AE62C6
5929         foreign key (descriptivesystem_id)
5930         references DefinedTermBase;
5931
5932     alter table DescriptionBase_Feature_AUD
5933         add constraint FKA4D7D13534869AAE
5934         foreign key (REV)
5935         references AuditEvent;
5936
5937     alter table DescriptionBase_GeoScope
5938         add constraint FK3ADD7CD586D04E74
5939         foreign key (geoscopes_id)
5940         references DefinedTermBase;
5941
5942     alter table DescriptionBase_GeoScope
5943         add constraint FK3ADD7CD5D86445CE
5944         foreign key (DescriptionBase_id)
5945         references DescriptionBase;
5946
5947     alter table DescriptionBase_GeoScope_AUD
5948         add constraint FK63A5382634869AAE
5949         foreign key (REV)
5950         references AuditEvent;
5951
5952     alter table DescriptionBase_Marker
5953         add constraint FK6132140C777265A1
5954         foreign key (markers_id)
5955         references Marker;
5956
5957     alter table DescriptionBase_Marker
5958         add constraint FK6132140CF1DDBFAB
5959         foreign key (DescriptionBase_id)
5960         references DescriptionBase;
5961
5962     alter table DescriptionBase_Marker_AUD
5963         add constraint FK92DD5BDD34869AAE
5964         foreign key (REV)
5965         references AuditEvent;
5966
5967     alter table DescriptionBase_OriginalSourceBase
5968         add constraint FKDC75C70FF1DDBFAB
5969         foreign key (DescriptionBase_id)
5970         references DescriptionBase;
5971
5972     alter table DescriptionBase_OriginalSourceBase
5973         add constraint FKDC75C70F3A6735D9
5974         foreign key (sources_id)
5975         references OriginalSourceBase;
5976
5977     alter table DescriptionBase_OriginalSourceBase_AUD
5978         add constraint FK8F39D56034869AAE
5979         foreign key (REV)
5980         references AuditEvent;
5981
5982     alter table DescriptionBase_Reference
5983         add constraint FKC330D639F1DDBFAB
5984         foreign key (DescriptionBase_id)
5985         references DescriptionBase;
5986
5987     alter table DescriptionBase_Reference
5988         add constraint FKC330D63945AB7BBA
5989         foreign key (descriptionsources_id)
5990         references Reference;
5991
5992     alter table DescriptionBase_Reference_AUD
5993         add constraint FK76253F8A34869AAE
5994         foreign key (REV)
5995         references AuditEvent;
5996
5997     alter table DescriptionBase_Rights
5998         add constraint FK6A2601A9F1DDBFAB
5999         foreign key (DescriptionBase_id)
6000         references DescriptionBase;
6001
6002     alter table DescriptionBase_Rights
6003         add constraint FK6A2601A9C13F7B21
6004         foreign key (rights_id)
6005         references Rights;
6006
6007     alter table DescriptionBase_Rights_AUD
6008         add constraint FKFEB732FA34869AAE
6009         foreign key (REV)
6010         references AuditEvent;
6011
6012     alter table DescriptionBase_Scope
6013         add constraint FKB9257C42951A5D40
6014         foreign key (scopes_id)
6015         references DefinedTermBase;
6016
6017     alter table DescriptionBase_Scope
6018         add constraint FKB9257C42D86445CE
6019         foreign key (DescriptionBase_id)
6020         references DescriptionBase;
6021
6022     alter table DescriptionBase_Scope_AUD
6023         add constraint FK75D5B91334869AAE
6024         foreign key (REV)
6025         references AuditEvent;
6026
6027     alter table DescriptionBase_SpecimenOrObservationBase
6028         add constraint FKDE29CD8033B8A841
6029         foreign key (descriptions_id)
6030         references DescriptionBase;
6031
6032     alter table DescriptionBase_SpecimenOrObservationBase
6033         add constraint FKDE29CD805C9E3461
6034         foreign key (describedspecimenorobservations_id)
6035         references SpecimenOrObservationBase;
6036
6037     alter table DescriptionBase_SpecimenOrObservationBase_AUD
6038         add constraint FKF1B33B5134869AAE
6039         foreign key (REV)
6040         references AuditEvent;
6041
6042     alter table DescriptionElementBase
6043         add constraint FK38FE76711C3C3FF7
6044         foreign key (area_id)
6045         references DefinedTermBase;
6046
6047     alter table DescriptionElementBase
6048         add constraint FK38FE76714FF2DB2C
6049         foreign key (createdby_id)
6050         references UserAccount;
6051
6052     alter table DescriptionElementBase
6053         add constraint FK38FE76716D0D7A56
6054         foreign key (format_id)
6055         references DefinedTermBase;
6056
6057     alter table DescriptionElementBase
6058         add constraint FK38FE76714220AFEB
6059         foreign key (feature_id)
6060         references DefinedTermBase;
6061
6062     alter table DescriptionElementBase
6063         add constraint FK38FE76719108D9B
6064         foreign key (taxon2_id)
6065         references TaxonBase;
6066
6067     alter table DescriptionElementBase
6068         add constraint FK38FE76715E9914B8
6069         foreign key (status_id)
6070         references DefinedTermBase;
6071
6072     alter table DescriptionElementBase
6073         add constraint FK38FE767110A80E07
6074         foreign key (unit_id)
6075         references DefinedTermBase;
6076
6077     alter table DescriptionElementBase
6078         add constraint FK38FE76716561D9B1
6079         foreign key (associatedspecimenorobservation_id)
6080         references SpecimenOrObservationBase;
6081
6082     alter table DescriptionElementBase
6083         add constraint FK38FE767134AF0E81
6084         foreign key (indescription_id)
6085         references DescriptionBase;
6086
6087     alter table DescriptionElementBase
6088         add constraint FK38FE7671E8D36B00
6089         foreign key (language_id)
6090         references DefinedTermBase;
6091
6092     alter table DescriptionElementBase
6093         add constraint FK38FE7671BC5DA539
6094         foreign key (updatedby_id)
6095         references UserAccount;
6096
6097     alter table DescriptionElementBase_AUD
6098         add constraint FKF3803C234869AAE
6099         foreign key (REV)
6100         references AuditEvent;
6101
6102     alter table DescriptionElementBase_Annotation
6103         add constraint FK7EE5E5DD3B8BB609
6104         foreign key (DescriptionElementBase_id)
6105         references DescriptionElementBase;
6106
6107     alter table DescriptionElementBase_Annotation
6108         add constraint FK7EE5E5DD1E403E0B
6109         foreign key (annotations_id)
6110         references Annotation;
6111
6112     alter table DescriptionElementBase_Annotation_AUD
6113         add constraint FK2BC1DD2E34869AAE
6114         foreign key (REV)
6115         references AuditEvent;
6116
6117     alter table DescriptionElementBase_LanguageString
6118         add constraint FKC753F137C086B46F
6119         foreign key (DescriptionElementBase_id)
6120         references DescriptionElementBase;
6121
6122     alter table DescriptionElementBase_LanguageString
6123         add constraint FKC753F137ACF5F60B
6124         foreign key (multilanguagetext_id)
6125         references LanguageString;
6126
6127     alter table DescriptionElementBase_LanguageString
6128         add constraint FKC753F137C6D55834
6129         foreign key (multilanguagetext_mapkey_id)
6130         references DefinedTermBase;
6131
6132     alter table DescriptionElementBase_LanguageString_AUD
6133         add constraint FK2D26AB8834869AAE
6134         foreign key (REV)
6135         references AuditEvent;
6136
6137     alter table DescriptionElementBase_Marker
6138         add constraint FK1CB715E8777265A1
6139         foreign key (markers_id)
6140         references Marker;
6141
6142     alter table DescriptionElementBase_Marker
6143         add constraint FK1CB715E83B8BB609
6144         foreign key (DescriptionElementBase_id)
6145         references DescriptionElementBase;
6146
6147     alter table DescriptionElementBase_Marker_AUD
6148         add constraint FK1E160FB934869AAE
6149         foreign key (REV)
6150         references AuditEvent;
6151
6152     alter table DescriptionElementBase_Media
6153         add constraint FK21F700763B8BB609
6154         foreign key (DescriptionElementBase_id)
6155         references DescriptionElementBase;
6156
6157     alter table DescriptionElementBase_Media
6158         add constraint FK21F70076C2C29593
6159         foreign key (media_id)
6160         references Media;
6161
6162     alter table DescriptionElementBase_Media_AUD
6163         add constraint FK5522034734869AAE
6164         foreign key (REV)
6165         references AuditEvent;
6166
6167     alter table DescriptionElementBase_Modifier
6168         add constraint FK97E0D1053B8BB609
6169         foreign key (DescriptionElementBase_id)
6170         references DescriptionElementBase;
6171
6172     alter table DescriptionElementBase_Modifier
6173         add constraint FK97E0D105E0960EC4
6174         foreign key (modifiers_id)
6175         references DefinedTermBase;
6176
6177     alter table DescriptionElementBase_Modifier_AUD
6178         add constraint FK2982F45634869AAE
6179         foreign key (REV)
6180         references AuditEvent;
6181
6182     alter table DescriptionElementBase_ModifyingText
6183         add constraint FK522D90C73B8BB609
6184         foreign key (DescriptionElementBase_id)
6185         references DescriptionElementBase;
6186
6187     alter table DescriptionElementBase_ModifyingText
6188         add constraint FK522D90C7F05D08D4
6189         foreign key (modifyingtext_id)
6190         references LanguageString;
6191
6192     alter table DescriptionElementBase_ModifyingText
6193         add constraint FK522D90C79682414B
6194         foreign key (modifyingtext_mapkey_id)
6195         references DefinedTermBase;
6196
6197     alter table DescriptionElementBase_ModifyingText_AUD
6198         add constraint FK6C06031834869AAE
6199         foreign key (REV)
6200         references AuditEvent;
6201
6202     alter table DescriptionElementBase_OriginalSourceBase
6203         add constraint FKF41ADEEB3B8BB609
6204         foreign key (DescriptionElementBase_id)
6205         references DescriptionElementBase;
6206
6207     alter table DescriptionElementBase_OriginalSourceBase
6208         add constraint FKF41ADEEB53DD72E3
6209         foreign key (sources_id)
6210         references OriginalSourceBase;
6211
6212     alter table DescriptionElementBase_OriginalSourceBase_AUD
6213         add constraint FK9C979F3C34869AAE
6214         foreign key (REV)
6215         references AuditEvent;
6216
6217     alter table DescriptionElementBase_StateData
6218         add constraint FK592D6F6D15153604
6219         foreign key (states_id)
6220         references StateData;
6221
6222     alter table DescriptionElementBase_StateData
6223         add constraint FK592D6F6D987CC6A4
6224         foreign key (DescriptionElementBase_id)
6225         references DescriptionElementBase;
6226
6227     alter table DescriptionElementBase_StateData_AUD
6228         add constraint FK1D0A1EBE34869AAE
6229         foreign key (REV)
6230         references AuditEvent;
6231
6232     alter table DescriptionElementBase_StatisticalMeasurementValue
6233         add constraint FK8AF511C28F213219
6234         foreign key (DescriptionElementBase_id)
6235         references DescriptionElementBase;
6236
6237     alter table DescriptionElementBase_StatisticalMeasurementValue
6238         add constraint FK8AF511C2D883945E
6239         foreign key (statisticalvalues_id)
6240         references StatisticalMeasurementValue;
6241
6242     alter table DescriptionElementBase_StatisticalMeasurementValue_AUD
6243         add constraint FK2DE8E9334869AAE
6244         foreign key (REV)
6245         references AuditEvent;
6246
6247     alter table DeterminationEvent
6248         add constraint FK1DB24974FF2DB2C
6249         foreign key (createdby_id)
6250         references UserAccount;
6251
6252     alter table DeterminationEvent
6253         add constraint FK1DB24973DA462D5
6254         foreign key (actor_id)
6255         references AgentBase;
6256
6257     alter table DeterminationEvent
6258         add constraint FK1DB2497DE9A3E39
6259         foreign key (taxon_id)
6260         references TaxonBase;
6261
6262     alter table DeterminationEvent
6263         add constraint FK1DB24974B251DAD
6264         foreign key (identifiedunit_id)
6265         references SpecimenOrObservationBase;
6266
6267     alter table DeterminationEvent
6268         add constraint FK1DB2497378D1BD
6269         foreign key (modifier_id)
6270         references DefinedTermBase;
6271
6272     alter table DeterminationEvent
6273         add constraint FK1DB2497BC5DA539
6274         foreign key (updatedby_id)
6275         references UserAccount;
6276
6277     alter table DeterminationEvent_AUD
6278         add constraint FKA0252EE834869AAE
6279         foreign key (REV)
6280         references AuditEvent;
6281
6282     alter table DeterminationEvent_Annotation
6283         add constraint FKB74F03F76BE0BFDA
6284         foreign key (DeterminationEvent_id)
6285         references DeterminationEvent;
6286
6287     alter table DeterminationEvent_Annotation
6288         add constraint FKB74F03F71E403E0B
6289         foreign key (annotations_id)
6290         references Annotation;
6291
6292     alter table DeterminationEvent_Annotation_AUD
6293         add constraint FKAFDA5E4834869AAE
6294         foreign key (REV)
6295         references AuditEvent;
6296
6297     alter table DeterminationEvent_Marker
6298         add constraint FK5C475102777265A1
6299         foreign key (markers_id)
6300         references Marker;
6301
6302     alter table DeterminationEvent_Marker
6303         add constraint FK5C4751026BE0BFDA
6304         foreign key (DeterminationEvent_id)
6305         references DeterminationEvent;
6306
6307     alter table DeterminationEvent_Marker_AUD
6308         add constraint FK567F2DD334869AAE
6309         foreign key (REV)
6310         references AuditEvent;
6311
6312     alter table DeterminationEvent_Reference
6313         add constraint FK8FB1ED833EF09CD5
6314         foreign key (setofreferences_id)
6315         references Reference;
6316
6317     alter table DeterminationEvent_Reference
6318         add constraint FK8FB1ED836BE0BFDA
6319         foreign key (DeterminationEvent_id)
6320         references DeterminationEvent;
6321
6322     alter table DeterminationEvent_Reference_AUD
6323         add constraint FK6255A1D434869AAE
6324         foreign key (REV)
6325         references AuditEvent;
6326
6327     alter table Extension
6328         add constraint FK52EF3C1F4FF2DB2C
6329         foreign key (createdby_id)
6330         references UserAccount;
6331
6332     alter table Extension
6333         add constraint FK52EF3C1FAD392BD3
6334         foreign key (type_id)
6335         references DefinedTermBase;
6336
6337     alter table Extension
6338         add constraint FK52EF3C1FBC5DA539
6339         foreign key (updatedby_id)
6340         references UserAccount;
6341
6342     alter table Extension_AUD
6343         add constraint FK92D2427034869AAE
6344         foreign key (REV)
6345         references AuditEvent;
6346
6347     alter table FeatureNode
6348         add constraint FK4CEED9F84FF2DB2C
6349         foreign key (createdby_id)
6350         references UserAccount;
6351
6352     alter table FeatureNode
6353         add constraint FK4CEED9F8E0AD2C03
6354         foreign key (parent_id)
6355         references FeatureNode;
6356
6357     alter table FeatureNode
6358         add constraint FK4CEED9F8DE9A3E39
6359         foreign key (featureTree_id)
6360         references FeatureTree;
6361
6362     alter table FeatureNode
6363         add constraint FK4CEED9F84220AFEB
6364         foreign key (feature_id)
6365         references DefinedTermBase;
6366
6367     alter table FeatureNode
6368         add constraint FK4CEED9F8BC5DA539
6369         foreign key (updatedby_id)
6370         references UserAccount;
6371
6372     alter table FeatureNode_AUD
6373         add constraint FK25AD4BC934869AAE
6374         foreign key (REV)
6375         references AuditEvent;
6376
6377     alter table FeatureNode_DefinedTermBase_InapplicableIf
6378         add constraint FK56833D011128E63B
6379         foreign key (inapplicableif_id)
6380         references DefinedTermBase;
6381
6382     alter table FeatureNode_DefinedTermBase_InapplicableIf
6383         add constraint FK56833D0152FCC4B
6384         foreign key (FeatureNode_id)
6385         references FeatureNode;
6386
6387     alter table FeatureNode_DefinedTermBase_InapplicableIf_AUD
6388         add constraint FKB8D7025234869AAE
6389         foreign key (REV)
6390         references AuditEvent;
6391
6392     alter table FeatureNode_DefinedTermBase_OnlyApplicable
6393         add constraint FK6AE876AB57FA94D4
6394         foreign key (onlyapplicableif_id)
6395         references DefinedTermBase;
6396
6397     alter table FeatureNode_DefinedTermBase_OnlyApplicable
6398         add constraint FK6AE876AB52FCC4B
6399         foreign key (FeatureNode_id)
6400         references FeatureNode;
6401
6402     alter table FeatureNode_DefinedTermBase_OnlyApplicable_AUD
6403         add constraint FK3F5356FC34869AAE
6404         foreign key (REV)
6405         references AuditEvent;
6406
6407     alter table FeatureTree
6408         add constraint FK4CF19F944FF2DB2C
6409         foreign key (createdby_id)
6410         references UserAccount;
6411
6412     alter table FeatureTree
6413         add constraint FK4CF19F94B7892921
6414         foreign key (root_id)
6415         references FeatureNode;
6416
6417     alter table FeatureTree
6418         add constraint FK4CF19F94BC5DA539
6419         foreign key (updatedby_id)
6420         references UserAccount;
6421
6422     alter table FeatureTree_AUD
6423         add constraint FK355BE36534869AAE
6424         foreign key (REV)
6425         references AuditEvent;
6426
6427     alter table FeatureTree_Annotation
6428         add constraint FK5D8B8DA47C496CB
6429         foreign key (FeatureTree_id)
6430         references FeatureTree;
6431
6432     alter table FeatureTree_Annotation
6433         add constraint FK5D8B8DA1E403E0B
6434         foreign key (annotations_id)
6435         references Annotation;
6436
6437     alter table FeatureTree_Annotation_AUD
6438         add constraint FK86E8E9AB34869AAE
6439         foreign key (REV)
6440         references AuditEvent;
6441
6442     alter table FeatureTree_Credit
6443         add constraint FK7536062432D1B9F
6444         foreign key (credits_id)
6445         references Credit;
6446
6447     alter table FeatureTree_Credit
6448         add constraint FK7536062447C496CB
6449         foreign key (FeatureTree_id)
6450         references FeatureTree;
6451
6452     alter table FeatureTree_Credit_AUD
6453         add constraint FK40EA81F534869AAE
6454         foreign key (REV)
6455         references AuditEvent;
6456
6457     alter table FeatureTree_Extension
6458         add constraint FKAD1E6D34927DE9DF
6459         foreign key (extensions_id)
6460         references Extension;
6461
6462     alter table FeatureTree_Extension
6463         add constraint FKAD1E6D3447C496CB
6464         foreign key (FeatureTree_id)
6465         references FeatureTree;
6466
6467     alter table FeatureTree_Extension_AUD
6468         add constraint FKF128E10534869AAE
6469         foreign key (REV)
6470         references AuditEvent;
6471
6472     alter table FeatureTree_Marker
6473         add constraint FK855CEF65777265A1
6474         foreign key (markers_id)
6475         references Marker;
6476
6477     alter table FeatureTree_Marker
6478         add constraint FK855CEF6547C496CB
6479         foreign key (FeatureTree_id)
6480         references FeatureTree;
6481
6482     alter table FeatureTree_Marker_AUD
6483         add constraint FKA508E2B634869AAE
6484         foreign key (REV)
6485         references AuditEvent;
6486
6487     alter table FeatureTree_OriginalSourceBase
6488         add constraint FK13BD64E847C496CB
6489         foreign key (FeatureTree_id)
6490         references FeatureTree;
6491
6492     alter table FeatureTree_OriginalSourceBase
6493         add constraint FK13BD64E83A6735D9
6494         foreign key (sources_id)
6495         references OriginalSourceBase;
6496
6497     alter table FeatureTree_OriginalSourceBase_AUD
6498         add constraint FK7B5CDEB934869AAE
6499         foreign key (REV)
6500         references AuditEvent;
6501
6502     alter table FeatureTree_Representation
6503         add constraint FK8C458F8B31C4747
6504         foreign key (representations_id)
6505         references Representation;
6506
6507     alter table FeatureTree_Representation
6508         add constraint FK8C458F847C496CB
6509         foreign key (FeatureTree_id)
6510         references FeatureTree;
6511
6512     alter table FeatureTree_Representation_AUD
6513         add constraint FKECAB4AC934869AAE
6514         foreign key (REV)
6515         references AuditEvent;
6516
6517     alter table FeatureTree_Rights
6518         add constraint FK8E50DD0247C496CB
6519         foreign key (FeatureTree_id)
6520         references FeatureTree;
6521
6522     alter table FeatureTree_Rights
6523         add constraint FK8E50DD02C13F7B21
6524         foreign key (rights_id)
6525         references Rights;
6526
6527     alter table FeatureTree_Rights_AUD
6528         add constraint FK10E2B9D334869AAE
6529         foreign key (REV)
6530         references AuditEvent;
6531
6532     alter table FeatureTree_TaxonBase
6533         add constraint FKEC78E5B0ED57882F
6534         foreign key (FeatureTree_id)
6535         references FeatureTree;
6536
6537     alter table FeatureTree_TaxonBase
6538         add constraint FKEC78E5B07C3D0017
6539         foreign key (coveredtaxa_id)
6540         references TaxonBase;
6541
6542     alter table FeatureTree_TaxonBase_AUD
6543         add constraint FK955ABB8134869AAE
6544         foreign key (REV)
6545         references AuditEvent;
6546
6547     alter table GatheringEvent
6548         add constraint FK6F1286F38B455EC6
6549         foreign key (locality_id)
6550         references LanguageString;
6551
6552     alter table GatheringEvent
6553         add constraint FK6F1286F34FF2DB2C
6554         foreign key (createdby_id)
6555         references UserAccount;
6556
6557     alter table GatheringEvent
6558         add constraint FK6F1286F33DA462D5
6559         foreign key (actor_id)
6560         references AgentBase;
6561
6562     alter table GatheringEvent
6563         add constraint FK6F1286F3F55AFD89
6564         foreign key (exactlocation_referencesystem_id)
6565         references DefinedTermBase;
6566
6567     alter table GatheringEvent
6568         add constraint FK6F1286F3BC5DA539
6569         foreign key (updatedby_id)
6570         references UserAccount;
6571
6572     alter table GatheringEvent_AUD
6573         add constraint FK3EC034434869AAE
6574         foreign key (REV)
6575         references AuditEvent;
6576
6577     alter table GatheringEvent_Annotation
6578         add constraint FK76DDD01BF95F225A
6579         foreign key (GatheringEvent_id)
6580         references GatheringEvent;
6581
6582     alter table GatheringEvent_Annotation
6583         add constraint FK76DDD01B1E403E0B
6584         foreign key (annotations_id)
6585         references Annotation;
6586
6587     alter table GatheringEvent_Annotation_AUD
6588         add constraint FK351E786C34869AAE
6589         foreign key (REV)
6590         references AuditEvent;
6591
6592     alter table GatheringEvent_DefinedTermBase
6593         add constraint FK69D9A11A7C34B6D6
6594         foreign key (collectingareas_id)
6595         references DefinedTermBase;
6596
6597     alter table GatheringEvent_DefinedTermBase
6598         add constraint FK69D9A11AF95F225A
6599         foreign key (GatheringEvent_id)
6600         references GatheringEvent;
6601
6602     alter table GatheringEvent_DefinedTermBase_AUD
6603         add constraint FKB3BBB1EB34869AAE
6604         foreign key (REV)
6605         references AuditEvent;
6606
6607     alter table GatheringEvent_Marker
6608         add constraint FK7B49CF26777265A1
6609         foreign key (markers_id)
6610         references Marker;
6611
6612     alter table GatheringEvent_Marker
6613         add constraint FK7B49CF26F95F225A
6614         foreign key (GatheringEvent_id)
6615         references GatheringEvent;
6616
6617     alter table GatheringEvent_Marker_AUD
6618         add constraint FK160DF9F734869AAE
6619         foreign key (REV)
6620         references AuditEvent;
6621
6622     alter table GenBankAccession
6623         add constraint FK86C1DBF84FF2DB2C
6624         foreign key (createdby_id)
6625         references UserAccount;
6626
6627     alter table GenBankAccession
6628         add constraint FK86C1DBF8BC5DA539
6629         foreign key (updatedby_id)
6630         references UserAccount;
6631
6632     alter table GenBankAccession_AUD
6633         add constraint FK5A2F4DC934869AAE
6634         foreign key (REV)
6635         references AuditEvent;
6636
6637     alter table GrantedAuthorityImpl
6638         add constraint FKB05CF9284FF2DB2C
6639         foreign key (createdby_id)
6640         references UserAccount;
6641
6642     alter table HomotypicalGroup
6643         add constraint FK7DECCC184FF2DB2C
6644         foreign key (createdby_id)
6645         references UserAccount;
6646
6647     alter table HomotypicalGroup
6648         add constraint FK7DECCC18BC5DA539
6649         foreign key (updatedby_id)
6650         references UserAccount;
6651
6652     alter table HomotypicalGroup_AUD
6653         add constraint FKE4252DE934869AAE
6654         foreign key (REV)
6655         references AuditEvent;
6656
6657     alter table HomotypicalGroup_Annotation
6658         add constraint FK7A0351D6BFEAE500
6659         foreign key (HomotypicalGroup_id)
6660         references HomotypicalGroup;
6661
6662     alter table HomotypicalGroup_Annotation
6663         add constraint FK7A0351D61E403E0B
6664         foreign key (annotations_id)
6665         references Annotation;
6666
6667     alter table HomotypicalGroup_Annotation_AUD
6668         add constraint FK41E6A4A734869AAE
6669         foreign key (REV)
6670         references AuditEvent;
6671
6672     alter table HomotypicalGroup_Marker
6673         add constraint FK97D36661777265A1
6674         foreign key (markers_id)
6675         references Marker;
6676
6677     alter table HomotypicalGroup_Marker
6678         add constraint FK97D36661BFEAE500
6679         foreign key (HomotypicalGroup_id)
6680         references HomotypicalGroup;
6681
6682     alter table HomotypicalGroup_Marker_AUD
6683         add constraint FK19337BB234869AAE
6684         foreign key (REV)
6685         references AuditEvent;
6686
6687     alter table HybridRelationship
6688         add constraint FK9033CE744FF2DB2C
6689         foreign key (createdby_id)
6690         references UserAccount;
6691
6692     alter table HybridRelationship
6693         add constraint FK9033CE749803512F
6694         foreign key (citation_id)
6695         references Reference;
6696
6697     alter table HybridRelationship
6698         add constraint FK9033CE749DD57A93
6699         foreign key (relatedfrom_id)
6700         references TaxonNameBase;
6701
6702     alter table HybridRelationship
6703         add constraint FK9033CE7455F241D4
6704         foreign key (type_id)
6705         references DefinedTermBase;
6706
6707     alter table HybridRelationship
6708         add constraint FK9033CE74AF4F9F62
6709         foreign key (relatedto_id)
6710         references TaxonNameBase;
6711
6712     alter table HybridRelationship
6713         add constraint FK9033CE74BC5DA539
6714         foreign key (updatedby_id)
6715         references UserAccount;
6716
6717     alter table HybridRelationship_AUD
6718         add constraint FK9C2BA24534869AAE
6719         foreign key (REV)
6720         references AuditEvent;
6721
6722     alter table HybridRelationship_Annotation
6723         add constraint FK2C7E7DFA59832240
6724         foreign key (HybridRelationship_id)
6725         references HybridRelationship;
6726
6727     alter table HybridRelationship_Annotation
6728         add constraint FK2C7E7DFA1E403E0B
6729         foreign key (annotations_id)
6730         references Annotation;
6731
6732     alter table HybridRelationship_Annotation_AUD
6733         add constraint FKACE71ECB34869AAE
6734         foreign key (REV)
6735         references AuditEvent;
6736
6737     alter table HybridRelationship_Marker
6738         add constraint FKCEF24485777265A1
6739         foreign key (markers_id)
6740         references Marker;
6741
6742     alter table HybridRelationship_Marker
6743         add constraint FKCEF2448559832240
6744         foreign key (HybridRelationship_id)
6745         references HybridRelationship;
6746
6747     alter table HybridRelationship_Marker_AUD
6748         add constraint FKCBAEA7D634869AAE
6749         foreign key (REV)
6750         references AuditEvent;
6751
6752     alter table IndividualAssociation_LanguageString
6753         add constraint FKB5C75EC028459272
6754         foreign key (description_mapkey_id)
6755         references DefinedTermBase;
6756
6757     alter table IndividualAssociation_LanguageString
6758         add constraint FKB5C75EC084FF3EDF
6759         foreign key (DescriptionElementBase_id)
6760         references DescriptionElementBase;
6761
6762     alter table IndividualAssociation_LanguageString
6763         add constraint FKB5C75EC02BEBA58D
6764         foreign key (description_id)
6765         references LanguageString;
6766
6767     alter table IndividualAssociation_LanguageString_AUD
6768         add constraint FKB1A62C9134869AAE
6769         foreign key (REV)
6770         references AuditEvent;
6771
6772     alter table InstitutionalMembership
6773         add constraint FK3C8E1FF94FF2DB2C
6774         foreign key (createdby_id)
6775         references UserAccount;
6776
6777     alter table InstitutionalMembership
6778         add constraint FK3C8E1FF9AAC1B820
6779         foreign key (person_id)
6780         references AgentBase;
6781
6782     alter table InstitutionalMembership
6783         add constraint FK3C8E1FF916B9CA77
6784         foreign key (institute_id)
6785         references AgentBase;
6786
6787     alter table InstitutionalMembership
6788         add constraint FK3C8E1FF9BC5DA539
6789         foreign key (updatedby_id)
6790         references UserAccount;
6791
6792     alter table InstitutionalMembership_AUD
6793         add constraint FK847A94A34869AAE
6794         foreign key (REV)
6795         references AuditEvent;
6796
6797     alter table LSIDAuthority
6798         add constraint FK759DB8814FF2DB2C
6799         foreign key (createdby_id)
6800         references UserAccount;
6801
6802     alter table LSIDAuthority_namespaces
6803         add constraint FKB04948F64FFCFD94
6804         foreign key (LSIDAuthority_id)
6805         references LSIDAuthority;
6806
6807     alter table LanguageString
6808         add constraint FKB5FDC9A94FF2DB2C
6809         foreign key (createdby_id)
6810         references UserAccount;
6811
6812     alter table LanguageString
6813         add constraint FKB5FDC9A9E8D36B00
6814         foreign key (language_id)
6815         references DefinedTermBase;
6816
6817     alter table LanguageString
6818         add constraint FKB5FDC9A9BC5DA539
6819         foreign key (updatedby_id)
6820         references UserAccount;
6821
6822     alter table LanguageString_AUD
6823         add constraint FK896AFAFA34869AAE
6824         foreign key (REV)
6825         references AuditEvent;
6826
6827     alter table LanguageString_Annotation
6828         add constraint FK8400DFA537998500
6829         foreign key (LanguageString_id)
6830         references LanguageString;
6831
6832     alter table LanguageString_Annotation
6833         add constraint FK8400DFA51E403E0B
6834         foreign key (annotations_id)
6835         references Annotation;
6836
6837     alter table LanguageString_Annotation_AUD
6838         add constraint FKD3BAB2F634869AAE
6839         foreign key (REV)
6840         references AuditEvent;
6841
6842     alter table LanguageString_Marker
6843         add constraint FK8DA633B0777265A1
6844         foreign key (markers_id)
6845         references Marker;
6846
6847     alter table LanguageString_Marker
6848         add constraint FK8DA633B037998500
6849         foreign key (LanguageString_id)
6850         references LanguageString;
6851
6852     alter table LanguageString_Marker_AUD
6853         add constraint FK2331098134869AAE
6854         foreign key (REV)
6855         references AuditEvent;
6856
6857     alter table Locus
6858         add constraint FK462F1BE4FF2DB2C
6859         foreign key (createdby_id)
6860         references UserAccount;
6861
6862     alter table Locus
6863         add constraint FK462F1BEBC5DA539
6864         foreign key (updatedby_id)
6865         references UserAccount;
6866
6867     alter table Locus_AUD
6868         add constraint FK5224108F34869AAE
6869         foreign key (REV)
6870         references AuditEvent;
6871
6872     alter table Marker
6873         add constraint FK88F1805A4FF2DB2C
6874         foreign key (createdby_id)
6875         references UserAccount;
6876
6877     alter table Marker
6878         add constraint FK88F1805AD64DC020
6879         foreign key (markertype_id)
6880         references DefinedTermBase;
6881
6882     alter table Marker
6883         add constraint FK88F1805ABC5DA539
6884         foreign key (updatedby_id)
6885         references UserAccount;
6886
6887     alter table Marker_AUD
6888         add constraint FKB951F12B34869AAE
6889         foreign key (REV)
6890         references AuditEvent;
6891
6892     alter table Media
6893         add constraint FK46C7FC44FF2DB2C
6894         foreign key (createdby_id)
6895         references UserAccount;
6896
6897     alter table Media
6898         add constraint FK46C7FC49803512F
6899         foreign key (citation_id)
6900         references Reference;
6901
6902     alter table Media
6903         add constraint FK46C7FC4C2445443
6904         foreign key (artist_id)
6905         references AgentBase;
6906
6907     alter table Media
6908         add constraint FK46C7FC4BC5DA539
6909         foreign key (updatedby_id)
6910         references UserAccount;
6911
6912     alter table MediaKey_NamedArea
6913         add constraint FK31E7D4023FF8E7B2
6914         foreign key (geographicalscope_id)
6915         references DefinedTermBase;
6916
6917     alter table MediaKey_NamedArea
6918         add constraint FK31E7D402BE59D760
6919         foreign key (Media_id)
6920         references Media;
6921
6922     alter table MediaKey_NamedArea_AUD
6923         add constraint FK922630D334869AAE
6924         foreign key (REV)
6925         references AuditEvent;
6926
6927     alter table MediaKey_Scope
6928         add constraint FKBFFEE8F0BE59D760
6929         foreign key (Media_id)
6930         references Media;
6931
6932     alter table MediaKey_Scope
6933         add constraint FKBFFEE8F0546985E4
6934         foreign key (scoperestrictions_id)
6935         references DefinedTermBase;
6936
6937     alter table MediaKey_Scope_AUD
6938         add constraint FK63AD1EC134869AAE
6939         foreign key (REV)
6940         references AuditEvent;
6941
6942     alter table MediaKey_Taxon
6943         add constraint FKC00C3966815C793
6944         foreign key (mediaKey_id)
6945         references Media;
6946
6947     alter table MediaKey_Taxon
6948         add constraint FKC00C3966DE9A3DE3
6949         foreign key (taxon_id)
6950         references TaxonBase;
6951
6952     alter table MediaKey_Taxon_AUD
6953         add constraint FK311443734869AAE
6954         foreign key (REV)
6955         references AuditEvent;
6956
6957     alter table MediaRepresentation
6958         add constraint FK1966BDB14FF2DB2C
6959         foreign key (createdby_id)
6960         references UserAccount;
6961
6962     alter table MediaRepresentation
6963         add constraint FK1966BDB1C2C29593
6964         foreign key (media_id)
6965         references Media;
6966
6967     alter table MediaRepresentation
6968         add constraint FK1966BDB1BC5DA539
6969         foreign key (updatedby_id)
6970         references UserAccount;
6971
6972     alter table MediaRepresentationPart
6973         add constraint FK67A455444FF2DB2C
6974         foreign key (createdby_id)
6975         references UserAccount;
6976
6977     alter table MediaRepresentationPart
6978         add constraint FK67A45544E3818E37
6979         foreign key (representation_id)
6980         references MediaRepresentation;
6981
6982     alter table MediaRepresentationPart
6983         add constraint FK67A45544BC5DA539
6984         foreign key (updatedby_id)
6985         references UserAccount;
6986
6987     alter table MediaRepresentationPart_AUD
6988         add constraint FKA75C411534869AAE
6989         foreign key (REV)
6990         references AuditEvent;
6991
6992     alter table MediaRepresentation_AUD
6993         add constraint FK67AAAB0234869AAE
6994         foreign key (REV)
6995         references AuditEvent;
6996
6997     alter table MediaRepresentation_MediaRepresentationPart_AUD
6998         add constraint FK3544378734869AAE
6999         foreign key (REV)
7000         references AuditEvent;
7001
7002     alter table Media_AUD
7003         add constraint FKF70B2B9534869AAE
7004         foreign key (REV)
7005         references AuditEvent;
7006
7007     alter table Media_Annotation
7008         add constraint FKA020DAAAC2C29593
7009         foreign key (Media_id)
7010         references Media;
7011
7012     alter table Media_Annotation
7013         add constraint FKA020DAAA1E403E0B
7014         foreign key (annotations_id)
7015         references Annotation;
7016
7017     alter table Media_Annotation_AUD
7018         add constraint FK99ABA37B34869AAE
7019         foreign key (REV)
7020         references AuditEvent;
7021
7022     alter table Media_Credit
7023         add constraint FKC1F78FF432D1B9F
7024         foreign key (credits_id)
7025         references Credit;
7026
7027     alter table Media_Credit
7028         add constraint FKC1F78FF4C2C29593
7029         foreign key (Media_id)
7030         references Media;
7031
7032     alter table Media_Credit_AUD
7033         add constraint FKDB32A3C534869AAE
7034         foreign key (REV)
7035         references AuditEvent;
7036
7037     alter table Media_Description
7038         add constraint FK368283E128459272
7039         foreign key (description_mapkey_id)
7040         references DefinedTermBase;
7041
7042     alter table Media_Description
7043         add constraint FK368283E12BEBA58D
7044         foreign key (description_id)
7045         references LanguageString;
7046
7047     alter table Media_Description
7048         add constraint FK368283E1C2C29593
7049         foreign key (Media_id)
7050         references Media;
7051
7052     alter table Media_Description_AUD
7053         add constraint FK6817D93234869AAE
7054         foreign key (REV)
7055         references AuditEvent;
7056
7057     alter table Media_Extension
7058         add constraint FKDB62D164927DE9DF
7059         foreign key (extensions_id)
7060         references Extension;
7061
7062     alter table Media_Extension
7063         add constraint FKDB62D164C2C29593
7064         foreign key (Media_id)
7065         references Media;
7066
7067     alter table Media_Extension_AUD
7068         add constraint FKE13FAD3534869AAE
7069         foreign key (REV)
7070         references AuditEvent;
7071
7072     alter table Media_LanguageString
7073         add constraint FK353DB784A0A6EDCE
7074         foreign key (title_mapkey_id)
7075         references DefinedTermBase;
7076
7077     alter table Media_LanguageString
7078         add constraint FK353DB784C2C29593
7079         foreign key (Media_id)
7080         references Media;
7081
7082     alter table Media_LanguageString
7083         add constraint FK353DB784A1CA19B1
7084         foreign key (title_id)
7085         references LanguageString;
7086
7087     alter table Media_LanguageString_AUD
7088         add constraint FK68FA835534869AAE
7089         foreign key (REV)
7090         references AuditEvent;
7091
7092     alter table Media_Marker
7093         add constraint FKD21E7935777265A1
7094         foreign key (markers_id)
7095         references Marker;
7096
7097     alter table Media_Marker
7098         add constraint FKD21E7935C2C29593
7099         foreign key (Media_id)
7100         references Media;
7101
7102     alter table Media_Marker_AUD
7103         add constraint FK3F51048634869AAE
7104         foreign key (REV)
7105         references AuditEvent;
7106
7107     alter table Media_OriginalSourceBase
7108         add constraint FK2FEEB6B8C2C29593
7109         foreign key (Media_id)
7110         references Media;
7111
7112     alter table Media_OriginalSourceBase
7113         add constraint FK2FEEB6B83A6735D9
7114         foreign key (sources_id)
7115         references OriginalSourceBase;
7116
7117     alter table Media_OriginalSourceBase_AUD
7118         add constraint FK97F0C88934869AAE
7119         foreign key (REV)
7120         references AuditEvent;
7121
7122     alter table Media_Representation
7123         add constraint FK1B8712C8BE59D760
7124         foreign key (Media_id)
7125         references Media;
7126
7127     alter table Media_Representation
7128         add constraint FK1B8712C88F6CABE6
7129         foreign key (keyrepresentations_id)
7130         references Representation;
7131
7132     alter table Media_Representation_AUD
7133         add constraint FK8DC9C9934869AAE
7134         foreign key (REV)
7135         references AuditEvent;
7136
7137     alter table Media_Rights
7138         add constraint FKDB1266D2C13F7B21
7139         foreign key (rights_id)
7140         references Rights;
7141
7142     alter table Media_Rights
7143         add constraint FKDB1266D2C2C29593
7144         foreign key (Media_id)
7145         references Media;
7146
7147     alter table Media_Rights_AUD
7148         add constraint FKAB2ADBA334869AAE
7149         foreign key (REV)
7150         references AuditEvent;
7151
7152     alter table Media_Sequence
7153         add constraint FK61D09FCF29B4761
7154         foreign key (usedsequences_id)
7155         references Sequence;
7156
7157     alter table Media_Sequence
7158         add constraint FK61D09FC3282B64
7159         foreign key (Media_id)
7160         references Media;
7161
7162     alter table Media_Sequence_AUD
7163         add constraint FK3C7BD9CD34869AAE
7164         foreign key (REV)
7165         references AuditEvent;
7166
7167     alter table Media_TaxonBase
7168         add constraint FK1ABD49E0BE59D760
7169         foreign key (Media_id)
7170         references Media;
7171
7172     alter table Media_TaxonBase
7173         add constraint FK1ABD49E07C3D0017
7174         foreign key (coveredtaxa_id)
7175         references TaxonBase;
7176
7177     alter table Media_TaxonBase_AUD
7178         add constraint FK857187B134869AAE
7179         foreign key (REV)
7180         references AuditEvent;
7181
7182     alter table MultiAccessKey_NamedArea
7183         add constraint FK1F5A74893FF8E7B2
7184         foreign key (geographicalscope_id)
7185         references DefinedTermBase;
7186
7187     alter table MultiAccessKey_NamedArea
7188         add constraint FK1F5A7489B4555A9A
7189         foreign key (WorkingSet_id)
7190         references WorkingSet;
7191
7192     alter table MultiAccessKey_NamedArea_AUD
7193         add constraint FK4CB735DA34869AAE
7194         foreign key (REV)
7195         references AuditEvent;
7196
7197     alter table MultiAccessKey_Scope
7198         add constraint FKCC6CE4F7546985E4
7199         foreign key (scoperestrictions_id)
7200         references DefinedTermBase;
7201
7202     alter table MultiAccessKey_Scope
7203         add constraint FKCC6CE4F7B4555A9A
7204         foreign key (WorkingSet_id)
7205         references WorkingSet;
7206
7207     alter table MultiAccessKey_Scope_AUD
7208         add constraint FK511FBF4834869AAE
7209         foreign key (REV)
7210         references AuditEvent;
7211
7212     alter table MultiAccessKey_Taxon
7213         add constraint FKCC7A356DB64A7AD3
7214         foreign key (multiAccessKey_id)
7215         references WorkingSet;
7216
7217     alter table MultiAccessKey_Taxon
7218         add constraint FKCC7A356DDE9A3DE3
7219         foreign key (taxon_id)
7220         references TaxonBase;
7221
7222     alter table MultiAccessKey_Taxon_AUD
7223         add constraint FKF083E4BE34869AAE
7224         foreign key (REV)
7225         references AuditEvent;
7226
7227     alter table NameRelationship
7228         add constraint FK5E510834FF2DB2C
7229         foreign key (createdby_id)
7230         references UserAccount;
7231
7232     alter table NameRelationship
7233         add constraint FK5E510839803512F
7234         foreign key (citation_id)
7235         references Reference;
7236
7237     alter table NameRelationship
7238         add constraint FK5E5108316CDFF85
7239         foreign key (relatedfrom_id)
7240         references TaxonNameBase;
7241
7242     alter table NameRelationship
7243         add constraint FK5E51083AF619DE3
7244         foreign key (type_id)
7245         references DefinedTermBase;
7246
7247     alter table NameRelationship
7248         add constraint FK5E5108328482454
7249         foreign key (relatedto_id)
7250         references TaxonNameBase;
7251
7252     alter table NameRelationship
7253         add constraint FK5E51083BC5DA539
7254         foreign key (updatedby_id)
7255         references UserAccount;
7256
7257     alter table NameRelationship_AUD
7258         add constraint FK743F44D434869AAE
7259         foreign key (REV)
7260         references AuditEvent;
7261
7262     alter table NameRelationship_Annotation
7263         add constraint FK2E38AC8B7B4CB560
7264         foreign key (NameRelationship_id)
7265         references NameRelationship;
7266
7267     alter table NameRelationship_Annotation
7268         add constraint FK2E38AC8B1E403E0B
7269         foreign key (annotations_id)
7270         references Annotation;
7271
7272     alter table NameRelationship_Annotation_AUD
7273         add constraint FKD1D59CDC34869AAE
7274         foreign key (REV)
7275         references AuditEvent;
7276
7277     alter table NameRelationship_Marker
7278         add constraint FKE3E46396777265A1
7279         foreign key (markers_id)
7280         references Marker;
7281
7282     alter table NameRelationship_Marker
7283         add constraint FKE3E463967B4CB560
7284         foreign key (NameRelationship_id)
7285         references NameRelationship;
7286
7287     alter table NameRelationship_Marker_AUD
7288         add constraint FKCD68D66734869AAE
7289         foreign key (REV)
7290         references AuditEvent;
7291
7292     alter table NomenclaturalStatus
7293         add constraint FK1FFEC88B4FF2DB2C
7294         foreign key (createdby_id)
7295         references UserAccount;
7296
7297     alter table NomenclaturalStatus
7298         add constraint FK1FFEC88B9803512F
7299         foreign key (citation_id)
7300         references Reference;
7301
7302     alter table NomenclaturalStatus
7303         add constraint FK1FFEC88B7029BD9F
7304         foreign key (type_id)
7305         references DefinedTermBase;
7306
7307     alter table NomenclaturalStatus
7308         add constraint FK1FFEC88BBC5DA539
7309         foreign key (updatedby_id)
7310         references UserAccount;
7311
7312     alter table NomenclaturalStatus_AUD
7313         add constraint FKFB2DB8DC34869AAE
7314         foreign key (REV)
7315         references AuditEvent;
7316
7317     alter table NomenclaturalStatus_Annotation
7318         add constraint FKE6E91F838D2CB1D4
7319         foreign key (NomenclaturalStatus_id)
7320         references NomenclaturalStatus;
7321
7322     alter table NomenclaturalStatus_Annotation
7323         add constraint FKE6E91F831E403E0B
7324         foreign key (annotations_id)
7325         references Annotation;
7326
7327     alter table NomenclaturalStatus_Annotation_AUD
7328         add constraint FK6A3D3D434869AAE
7329         foreign key (REV)
7330         references AuditEvent;
7331
7332     alter table NomenclaturalStatus_Marker
7333         add constraint FK2F5128E777265A1
7334         foreign key (markers_id)
7335         references Marker;
7336
7337     alter table NomenclaturalStatus_Marker
7338         add constraint FK2F5128E8D2CB1D4
7339         foreign key (NomenclaturalStatus_id)
7340         references NomenclaturalStatus;
7341
7342     alter table NomenclaturalStatus_Marker_AUD
7343         add constraint FK8619495F34869AAE
7344         foreign key (REV)
7345         references AuditEvent;
7346
7347     alter table OriginalSourceBase
7348         add constraint FK505F2E5D4FF2DB2C
7349         foreign key (createdby_id)
7350         references UserAccount;
7351
7352     alter table OriginalSourceBase
7353         add constraint FK505F2E5D966B96B2
7354         foreign key (nameusedinsource_id)
7355         references TaxonNameBase;
7356
7357     alter table OriginalSourceBase
7358         add constraint FK505F2E5D9803512F
7359         foreign key (citation_id)
7360         references Reference;
7361
7362     alter table OriginalSourceBase
7363         add constraint FK505F2E5DBC5DA539
7364         foreign key (updatedby_id)
7365         references UserAccount;
7366
7367     alter table OriginalSourceBase_AUD
7368         add constraint FK9662E5AE34869AAE
7369         foreign key (REV)
7370         references AuditEvent;
7371
7372     alter table OriginalSourceBase_Annotation
7373         add constraint FK20814271B029DDA0
7374         foreign key (OriginalSourceBase_id)
7375         references OriginalSourceBase;
7376
7377     alter table OriginalSourceBase_Annotation
7378         add constraint FK208142711E403E0B
7379         foreign key (annotations_id)
7380         references Annotation;
7381
7382     alter table OriginalSourceBase_Annotation_AUD
7383         add constraint FKA074CFC234869AAE
7384         foreign key (REV)
7385         references AuditEvent;
7386
7387     alter table OriginalSourceBase_Marker
7388         add constraint FKB3FFDC7C777265A1
7389         foreign key (markers_id)
7390         references Marker;
7391
7392     alter table OriginalSourceBase_Marker
7393         add constraint FKB3FFDC7CB029DDA0
7394         foreign key (OriginalSourceBase_id)
7395         references OriginalSourceBase;
7396
7397     alter table OriginalSourceBase_Marker_AUD
7398         add constraint FKBFB16C4D34869AAE
7399         foreign key (REV)
7400         references AuditEvent;
7401
7402     alter table PermissionGroup
7403         add constraint FK629941D04FF2DB2C
7404         foreign key (createdby_id)
7405         references UserAccount;
7406
7407     alter table PermissionGroup_GrantedAuthorityImpl
7408         add constraint FK5311437CA0971A3
7409         foreign key (PermissionGroup_id)
7410         references PermissionGroup;
7411
7412     alter table PermissionGroup_GrantedAuthorityImpl
7413         add constraint FK53114371857F6C2
7414         foreign key (grantedauthorities_id)
7415         references GrantedAuthorityImpl;
7416
7417     alter table PolytomousKey_NamedArea
7418         add constraint FK1C727CFF3FF8E7B2
7419         foreign key (geographicalscope_id)
7420         references DefinedTermBase;
7421
7422     alter table PolytomousKey_NamedArea
7423         add constraint FK1C727CFFED57882F
7424         foreign key (PolytomousKey_id)
7425         references PolytomousKey;
7426
7427     alter table PolytomousKey_NamedArea_AUD
7428         add constraint FK750A135034869AAE
7429         foreign key (REV)
7430         references AuditEvent;
7431
7432     alter table PolytomousKey_Scope
7433         add constraint FK8D97986DED57882F
7434         foreign key (PolytomousKey_id)
7435         references PolytomousKey;
7436
7437     alter table PolytomousKey_Scope
7438         add constraint FK8D97986D546985E4
7439         foreign key (scoperestrictions_id)
7440         references DefinedTermBase;
7441
7442     alter table PolytomousKey_Scope_AUD
7443         add constraint FK4E37C7BE34869AAE
7444         foreign key (REV)
7445         references AuditEvent;
7446
7447     alter table PolytomousKey_Taxon
7448         add constraint FK8DA4E8E389D9775
7449         foreign key (polytomousKey_id)
7450         references PolytomousKey;
7451
7452     alter table PolytomousKey_Taxon
7453         add constraint FK8DA4E8E3DE9A3DE3
7454         foreign key (taxon_id)
7455         references TaxonBase;
7456
7457     alter table PolytomousKey_Taxon_AUD
7458         add constraint FKED9BED3434869AAE
7459         foreign key (REV)
7460         references AuditEvent;
7461
7462     create index ReferenceTitleCacheIndex on Reference (titleCache);
7463
7464     alter table Reference
7465         add constraint FK404D5F2B4FF2DB2C
7466         foreign key (createdby_id)
7467         references UserAccount;
7468
7469     alter table Reference
7470         add constraint FK404D5F2B403E17F4
7471         foreign key (institution_id)
7472         references AgentBase;
7473
7474     alter table Reference
7475         add constraint FK404D5F2B969F8FF0
7476         foreign key (inreference_id)
7477         references Reference;
7478
7479     alter table Reference
7480         add constraint FK404D5F2BAEC3B8B8
7481         foreign key (school_id)
7482         references AgentBase;
7483
7484     alter table Reference
7485         add constraint FK404D5F2B697665E
7486         foreign key (authorteam_id)
7487         references AgentBase;
7488
7489     alter table Reference
7490         add constraint FK404D5F2BBC5DA539
7491         foreign key (updatedby_id)
7492         references UserAccount;
7493
7494     alter table Reference_AUD
7495         add constraint FK8F0FFF7C34869AAE
7496         foreign key (REV)
7497         references AuditEvent;
7498
7499     alter table Reference_Annotation
7500         add constraint FKFC824E3765B124B
7501         foreign key (Reference_id)
7502         references Reference;
7503
7504     alter table Reference_Annotation
7505         add constraint FKFC824E31E403E0B
7506         foreign key (annotations_id)
7507         references Annotation;
7508
7509     alter table Reference_Annotation_AUD
7510         add constraint FKF3C1293434869AAE
7511         foreign key (REV)
7512         references AuditEvent;
7513
7514     alter table Reference_Credit
7515         add constraint FK5BC6DEAD32D1B9F
7516         foreign key (credits_id)
7517         references Credit;
7518
7519     alter table Reference_Credit
7520         add constraint FK5BC6DEAD765B124B
7521         foreign key (Reference_id)
7522         references Reference;
7523
7524     alter table Reference_Credit_AUD
7525         add constraint FK4AD9EDFE34869AAE
7526         foreign key (REV)
7527         references AuditEvent;
7528
7529     alter table Reference_Extension
7530         add constraint FKDEFCDC0B927DE9DF
7531         foreign key (extensions_id)
7532         references Extension;
7533
7534     alter table Reference_Extension
7535         add constraint FKDEFCDC0B765B124B
7536         foreign key (Reference_id)
7537         references Reference;
7538
7539     alter table Reference_Extension_AUD
7540         add constraint FK1DF60C5C34869AAE
7541         foreign key (REV)
7542         references AuditEvent;
7543
7544     alter table Reference_Marker
7545         add constraint FK6BEDC7EE777265A1
7546         foreign key (markers_id)
7547         references Marker;
7548
7549     alter table Reference_Marker
7550         add constraint FK6BEDC7EE765B124B
7551         foreign key (Reference_id)
7552         references Reference;
7553
7554     alter table Reference_Marker_AUD
7555         add constraint FKAEF84EBF34869AAE
7556         foreign key (REV)
7557         references AuditEvent;
7558
7559     alter table Reference_Media
7560         add constraint FKBBEF5B0765B124B
7561         foreign key (Reference_id)
7562         references Reference;
7563
7564     alter table Reference_Media
7565         add constraint FKBBEF5B0C2C29593
7566         foreign key (media_id)
7567         references Media;
7568
7569     alter table Reference_Media_AUD
7570         add constraint FK8318CB8134869AAE
7571         foreign key (REV)
7572         references AuditEvent;
7573
7574     alter table Reference_OriginalSourceBase
7575         add constraint FKD3E8B7F1765B124B
7576         foreign key (Reference_id)
7577         references Reference;
7578
7579     alter table Reference_OriginalSourceBase
7580         add constraint FKD3E8B7F13A6735D9
7581         foreign key (sources_id)
7582         references OriginalSourceBase;
7583
7584     alter table Reference_OriginalSourceBase_AUD
7585         add constraint FKC025854234869AAE
7586         foreign key (REV)
7587         references AuditEvent;
7588
7589     alter table Reference_Rights
7590         add constraint FK74E1B58BC13F7B21
7591         foreign key (rights_id)
7592         references Rights;
7593
7594     alter table Reference_Rights
7595         add constraint FK74E1B58B765B124B
7596         foreign key (Reference_id)
7597         references Reference;
7598
7599     alter table Reference_Rights_AUD
7600         add constraint FK1AD225DC34869AAE
7601         foreign key (REV)
7602         references AuditEvent;
7603
7604     alter table RelationshipTermBase_inverseRepresentation
7605         add constraint FK98592F33ECEEF4AF
7606         foreign key (DefinedTermBase_id)
7607         references DefinedTermBase;
7608
7609     alter table RelationshipTermBase_inverseRepresentation
7610         add constraint FK98592F33473FB677
7611         foreign key (inverserepresentations_id)
7612         references Representation;
7613
7614     alter table RelationshipTermBase_inverseRepresentation_AUD
7615         add constraint FK5D248B8434869AAE
7616         foreign key (REV)
7617         references AuditEvent;
7618
7619     alter table Representation
7620         add constraint FK9C4724ED4FF2DB2C
7621         foreign key (createdby_id)
7622         references UserAccount;
7623
7624     alter table Representation
7625         add constraint FK9C4724EDE8D36B00
7626         foreign key (language_id)
7627         references DefinedTermBase;
7628
7629     alter table Representation
7630         add constraint FK9C4724EDBC5DA539
7631         foreign key (updatedby_id)
7632         references UserAccount;
7633
7634     alter table Representation_AUD
7635         add constraint FK294D143E34869AAE
7636         foreign key (REV)
7637         references AuditEvent;
7638
7639     alter table Representation_Annotation
7640         add constraint FK371091E147E8AE60
7641         foreign key (Representation_id)
7642         references Representation;
7643
7644     alter table Representation_Annotation
7645         add constraint FK371091E11E403E0B
7646         foreign key (annotations_id)
7647         references Annotation;
7648
7649     alter table Representation_Annotation_AUD
7650         add constraint FK36EEE73234869AAE
7651         foreign key (REV)
7652         references AuditEvent;
7653
7654     alter table Representation_Marker
7655         add constraint FK560063EC777265A1
7656         foreign key (markers_id)
7657         references Marker;
7658
7659     alter table Representation_Marker
7660         add constraint FK560063EC47E8AE60
7661         foreign key (Representation_id)
7662         references Representation;
7663
7664     alter table Representation_Marker_AUD
7665         add constraint FKD640BBBD34869AAE
7666         foreign key (REV)
7667         references AuditEvent;
7668
7669     alter table Rights
7670         add constraint FK91E56DF74FF2DB2C
7671         foreign key (createdby_id)
7672         references UserAccount;
7673
7674     alter table Rights
7675         add constraint FK91E56DF7F7976FC5
7676         foreign key (agent_id)
7677         references AgentBase;
7678
7679     alter table Rights
7680         add constraint FK91E56DF7E6D2886A
7681         foreign key (type_id)
7682         references DefinedTermBase;
7683
7684     alter table Rights
7685         add constraint FK91E56DF7E8D36B00
7686         foreign key (language_id)
7687         references DefinedTermBase;
7688
7689     alter table Rights
7690         add constraint FK91E56DF7BC5DA539
7691         foreign key (updatedby_id)
7692         references UserAccount;
7693
7694     alter table Rights_AUD
7695         add constraint FK252BC84834869AAE
7696         foreign key (REV)
7697         references AuditEvent;
7698
7699     alter table Rights_Annotation
7700         add constraint FK27CB1E97C13F7B21
7701         foreign key (Rights_id)
7702         references Rights;
7703
7704     alter table Rights_Annotation
7705         add constraint FK27CB1E971E403E0B
7706         foreign key (annotations_id)
7707         references Annotation;
7708
7709     alter table Rights_Annotation_AUD
7710         add constraint FKF98828E834869AAE
7711         foreign key (REV)
7712         references AuditEvent;
7713
7714     alter table Rights_Marker
7715         add constraint FKB739BBA2777265A1
7716         foreign key (markers_id)
7717         references Marker;
7718
7719     alter table Rights_Marker
7720         add constraint FKB739BBA2C13F7B21
7721         foreign key (Rights_id)
7722         references Rights;
7723
7724     alter table Rights_Marker_AUD
7725         add constraint FKC6FB487334869AAE
7726         foreign key (REV)
7727         references AuditEvent;
7728
7729     create index sequenceTitleCacheIndex on Sequence (titleCache);
7730
7731     alter table Sequence
7732         add constraint FK544ADBE14FF2DB2C
7733         foreign key (createdby_id)
7734         references UserAccount;
7735
7736     alter table Sequence
7737         add constraint FK544ADBE1B982A103
7738         foreign key (publishedin_id)
7739         references Reference;
7740
7741     alter table Sequence
7742         add constraint FK544ADBE12DBE1F1F
7743         foreign key (locus_id)
7744         references Locus;
7745
7746     alter table Sequence
7747         add constraint FK544ADBE1BC5DA539
7748         foreign key (updatedby_id)
7749         references UserAccount;
7750
7751     alter table Sequence_AUD
7752         add constraint FK39F4313234869AAE
7753         foreign key (REV)
7754         references AuditEvent;
7755
7756     alter table Sequence_Annotation
7757         add constraint FK1010BA6DD57FFDD5
7758         foreign key (Sequence_id)
7759         references Sequence;
7760
7761     alter table Sequence_Annotation
7762         add constraint FK1010BA6D1E403E0B
7763         foreign key (annotations_id)
7764         references Annotation;
7765
7766     alter table Sequence_Annotation_AUD
7767         add constraint FKCB4FE9BE34869AAE
7768         foreign key (REV)
7769         references AuditEvent;
7770
7771     alter table Sequence_Credit
7772         add constraint FK2CFBC93732D1B9F
7773         foreign key (credits_id)
7774         references Credit;
7775
7776     alter table Sequence_Credit
7777         add constraint FK2CFBC937D57FFDD5
7778         foreign key (Sequence_id)
7779         references Sequence;
7780
7781     alter table Sequence_Credit_AUD
7782         add constraint FK4B22838834869AAE
7783         foreign key (REV)
7784         references AuditEvent;
7785
7786     alter table Sequence_Extension
7787         add constraint FK7BE66D41927DE9DF
7788         foreign key (extensions_id)
7789         references Extension;
7790
7791     alter table Sequence_Extension
7792         add constraint FK7BE66D41D57FFDD5
7793         foreign key (Sequence_id)
7794         references Sequence;
7795
7796     alter table Sequence_Extension_AUD
7797         add constraint FK1CA8129234869AAE
7798         foreign key (REV)
7799         references AuditEvent;
7800
7801     alter table Sequence_GenBankAccession
7802         add constraint FK8F698096D57FFDD5
7803         foreign key (Sequence_id)
7804         references Sequence;
7805
7806     alter table Sequence_GenBankAccession
7807         add constraint FK8F69809615C4EF35
7808         foreign key (genbankaccession_id)
7809         references GenBankAccession;
7810
7811     alter table Sequence_GenBankAccession_AUD
7812         add constraint FKC717736734869AAE
7813         foreign key (REV)
7814         references AuditEvent;
7815
7816     alter table Sequence_Marker
7817         add constraint FK3D22B278777265A1
7818         foreign key (markers_id)
7819         references Marker;
7820
7821     alter table Sequence_Marker
7822         add constraint FK3D22B278D57FFDD5
7823         foreign key (Sequence_id)
7824         references Sequence;
7825
7826     alter table Sequence_Marker_AUD
7827         add constraint FKAF40E44934869AAE
7828         foreign key (REV)
7829         references AuditEvent;
7830
7831     alter table Sequence_Media
7832         add constraint FK8E5D91E666ACA7EC
7833         foreign key (chromatograms_id)
7834         references Media;
7835
7836     alter table Sequence_Media
7837         add constraint FK8E5D91E6D57FFDD5
7838         foreign key (Sequence_id)
7839         references Sequence;
7840
7841     alter table Sequence_Media_AUD
7842         add constraint FK20025CB734869AAE
7843         foreign key (REV)
7844         references AuditEvent;
7845
7846     alter table Sequence_OriginalSourceBase
7847         add constraint FKCDB0237BD57FFDD5
7848         foreign key (Sequence_id)
7849         references Sequence;
7850
7851     alter table Sequence_OriginalSourceBase
7852         add constraint FKCDB0237B3A6735D9
7853         foreign key (sources_id)
7854         references OriginalSourceBase;
7855
7856     alter table Sequence_OriginalSourceBase_AUD
7857         add constraint FK69D81BCC34869AAE
7858         foreign key (REV)
7859         references AuditEvent;
7860
7861     alter table Sequence_Reference
7862         add constraint FK6944904D7291F8A
7863         foreign key (citations_id)
7864         references Reference;
7865
7866     alter table Sequence_Reference
7867         add constraint FK6944904DD57FFDD5
7868         foreign key (Sequence_id)
7869         references Sequence;
7870
7871     alter table Sequence_Reference_AUD
7872         add constraint FK18E5CF9E34869AAE
7873         foreign key (REV)
7874         references AuditEvent;
7875
7876     alter table Sequence_Rights
7877         add constraint FK4616A015C13F7B21
7878         foreign key (rights_id)
7879         references Rights;
7880
7881     alter table Sequence_Rights
7882         add constraint FK4616A015D57FFDD5
7883         foreign key (Sequence_id)
7884         references Sequence;
7885
7886     alter table Sequence_Rights_AUD
7887         add constraint FK1B1ABB6634869AAE
7888         foreign key (REV)
7889         references AuditEvent;
7890
7891     create index specimenOrObservationBaseTitleCacheIndex on SpecimenOrObservationBase (titleCache);
7892
7893
7894     alter table SpecimenOrObservationBase
7895         add constraint FK11CB3232F75F225E
7896         foreign key (primarycollector_id)
7897         references AgentBase;
7898
7899     alter table SpecimenOrObservationBase
7900         add constraint FK21CA32727CC340C5
7901         foreign key (storedunder_id)
7902         references TaxonNameBase;
7903
7904     alter table SpecimenOrObservationBase
7905         add constraint FK21CA32728C750E27
7906         foreign key (lifestage_id)
7907         references DefinedTermBase;
7908
7909     alter table SpecimenOrObservationBase
7910         add constraint FK21CA32724FF2DB2C
7911         foreign key (createdby_id)
7912         references UserAccount;
7913
7914     alter table SpecimenOrObservationBase
7915         add constraint FK21CA3272EB62BE9A
7916         foreign key (collection_id)
7917         references Collection;
7918
7919     alter table SpecimenOrObservationBase
7920         add constraint FK21CA3272E17C9A6B
7921         foreign key (sex_id)
7922         references DefinedTermBase;
7923
7924     alter table SpecimenOrObservationBase
7925         add constraint FK21CA3272C8505DB
7926         foreign key (preservation_id)
7927         references DefinedTermBase;
7928
7929     alter table SpecimenOrObservationBase
7930         add constraint FK21CA32724AAB411A
7931         foreign key (derivedfrom_id)
7932         references DerivationEvent;
7933
7934     alter table SpecimenOrObservationBase
7935         add constraint FK21CA3272F95F225A
7936         foreign key (gatheringevent_id)
7937         references GatheringEvent;
7938
7939     alter table SpecimenOrObservationBase
7940         add constraint FK21CA3272BC5DA539
7941         foreign key (updatedby_id)
7942         references UserAccount;
7943
7944     alter table SpecimenOrObservationBase_AUD
7945         add constraint FKF3D3D74334869AAE
7946         foreign key (REV)
7947         references AuditEvent;
7948
7949     alter table SpecimenOrObservationBase_Annotation
7950         add constraint FK365E4F3C3B8A5ABA
7951         foreign key (SpecimenOrObservationBase_id)
7952         references SpecimenOrObservationBase;
7953
7954     alter table SpecimenOrObservationBase_Annotation
7955         add constraint FK365E4F3C1E403E0B
7956         foreign key (annotations_id)
7957         references Annotation;
7958
7959     alter table SpecimenOrObservationBase_Annotation_AUD
7960         add constraint FK34187F0D34869AAE
7961         foreign key (REV)
7962         references AuditEvent;
7963
7964     alter table SpecimenOrObservationBase_Credit
7965         add constraint FK7E3A1D8632D1B9F
7966         foreign key (credits_id)
7967         references Credit;
7968
7969     alter table SpecimenOrObservationBase_Credit
7970         add constraint FK7E3A1D863B8A5ABA
7971         foreign key (SpecimenOrObservationBase_id)
7972         references SpecimenOrObservationBase;
7973
7974     alter table SpecimenOrObservationBase_Credit_AUD
7975         add constraint FK7170185734869AAE
7976         foreign key (REV)
7977         references AuditEvent;
7978
7979     alter table SpecimenOrObservationBase_DerivationEvent
7980         add constraint FK20132036BD59A1AD
7981         foreign key (derivationevents_id)
7982         references DerivationEvent;
7983
7984     alter table SpecimenOrObservationBase_DerivationEvent
7985         add constraint FK2013203654C216AA
7986         foreign key (originals_id)
7987         references SpecimenOrObservationBase;
7988
7989     alter table SpecimenOrObservationBase_DerivationEvent_AUD
7990         add constraint FKA4A8430734869AAE
7991         foreign key (REV)
7992         references AuditEvent;
7993
7994     alter table SpecimenOrObservationBase_Extension
7995         add constraint FKE03B8292927DE9DF
7996         foreign key (extensions_id)
7997         references Extension;
7998
7999     alter table SpecimenOrObservationBase_Extension
8000         add constraint FKE03B82923B8A5ABA
8001         foreign key (SpecimenOrObservationBase_id)
8002         references SpecimenOrObservationBase;
8003
8004     alter table SpecimenOrObservationBase_Extension_AUD
8005         add constraint FK7AE0176334869AAE
8006         foreign key (REV)
8007         references AuditEvent;
8008
8009     alter table SpecimenOrObservationBase_LanguageString
8010         add constraint FKCFAA931628459272
8011         foreign key (definition_mapkey_id)
8012         references DefinedTermBase;
8013
8014     alter table SpecimenOrObservationBase_LanguageString
8015         add constraint FKCFAA93162BEBA58D
8016         foreign key (definition_id)
8017         references LanguageString;
8018
8019     alter table SpecimenOrObservationBase_LanguageString
8020         add constraint FKCFAA93163B8A5ABA
8021         foreign key (SpecimenOrObservationBase_id)
8022         references SpecimenOrObservationBase;
8023
8024     alter table SpecimenOrObservationBase_LanguageString_AUD
8025         add constraint FK38B45E734869AAE
8026         foreign key (REV)
8027         references AuditEvent;
8028
8029     alter table SpecimenOrObservationBase_Marker
8030         add constraint FK8E6106C7777265A1
8031         foreign key (markers_id)
8032         references Marker;
8033
8034     alter table SpecimenOrObservationBase_Marker
8035         add constraint FK8E6106C73B8A5ABA
8036         foreign key (SpecimenOrObservationBase_id)
8037         references SpecimenOrObservationBase;
8038
8039     alter table SpecimenOrObservationBase_Marker_AUD
8040         add constraint FKD58E791834869AAE
8041         foreign key (REV)
8042         references AuditEvent;
8043
8044     alter table SpecimenOrObservationBase_Media
8045         add constraint FK4EEBF7B7C2C29593
8046         foreign key (media_id)
8047         references Media;
8048
8049     alter table SpecimenOrObservationBase_Media
8050         add constraint FK4EEBF7B73B8A5ABA
8051         foreign key (SpecimenOrObservationBase_id)
8052         references SpecimenOrObservationBase;
8053
8054     alter table SpecimenOrObservationBase_Media_AUD
8055         add constraint FK8457720834869AAE
8056         foreign key (REV)
8057         references AuditEvent;
8058
8059     alter table SpecimenOrObservationBase_OriginalSourceBase
8060         add constraint FKCA7F794A3B8A5ABA
8061         foreign key (SpecimenOrObservationBase_id)
8062         references SpecimenOrObservationBase;
8063
8064     alter table SpecimenOrObservationBase_OriginalSourceBase
8065         add constraint FKCA7F794A3A6735D9
8066         foreign key (sources_id)
8067         references OriginalSourceBase;
8068
8069     alter table SpecimenOrObservationBase_OriginalSourceBase_AUD
8070         add constraint FK2059F21B34869AAE
8071         foreign key (REV)
8072         references AuditEvent;
8073
8074     alter table SpecimenOrObservationBase_Rights
8075         add constraint FK9754F464C13F7B21
8076         foreign key (rights_id)
8077         references Rights;
8078
8079     alter table SpecimenOrObservationBase_Rights
8080         add constraint FK9754F4643B8A5ABA
8081         foreign key (SpecimenOrObservationBase_id)
8082         references SpecimenOrObservationBase;
8083
8084     alter table SpecimenOrObservationBase_Rights_AUD
8085         add constraint FK4168503534869AAE
8086         foreign key (REV)
8087         references AuditEvent;
8088
8089     alter table SpecimenOrObservationBase_Sequence
8090         add constraint FKBBF27B0E35B10F24
8091         foreign key (sequences_id)
8092         references Sequence;
8093
8094     alter table SpecimenOrObservationBase_Sequence
8095         add constraint FKBBF27B0E7EE2770E
8096         foreign key (SpecimenOrObservationBase_id)
8097         references SpecimenOrObservationBase;
8098
8099     alter table SpecimenOrObservationBase_Sequence_AUD
8100         add constraint FK392E71DF34869AAE
8101         foreign key (REV)
8102         references AuditEvent;
8103
8104     alter table StateData
8105         add constraint FKFB1697BB4FF2DB2C
8106         foreign key (createdby_id)
8107         references UserAccount;
8108
8109     alter table StateData
8110         add constraint FKFB1697BB682A4E4B
8111         foreign key (state_id)
8112         references DefinedTermBase;
8113
8114     alter table StateData
8115         add constraint FKFB1697BBBC5DA539
8116         foreign key (updatedby_id)
8117         references UserAccount;
8118
8119     alter table StateData_AUD
8120         add constraint FKDA6A700C34869AAE
8121         foreign key (REV)
8122         references AuditEvent;
8123
8124     alter table StateData_DefinedTermBase
8125         add constraint FK107321E28E7BF9AB
8126         foreign key (StateData_id)
8127         references StateData;
8128
8129     alter table StateData_DefinedTermBase
8130         add constraint FK107321E2E0960EC4
8131         foreign key (modifiers_id)
8132         references DefinedTermBase;
8133
8134     alter table StateData_DefinedTermBase_AUD
8135         add constraint FK7C978EB334869AAE
8136         foreign key (REV)
8137         references AuditEvent;
8138
8139     alter table StateData_LanguageString
8140         add constraint FK93FFD2AD8E7BF9AB
8141         foreign key (StateData_id)
8142         references StateData;
8143
8144     alter table StateData_LanguageString
8145         add constraint FK93FFD2ADF05D08D4
8146         foreign key (modifyingtext_id)
8147         references LanguageString;
8148
8149     alter table StateData_LanguageString
8150         add constraint FK93FFD2AD9682414B
8151         foreign key (modifyingtext_mapkey_id)
8152         references DefinedTermBase;
8153
8154     alter table StateData_LanguageString_AUD
8155         add constraint FK1578E1FE34869AAE
8156         foreign key (REV)
8157         references AuditEvent;
8158
8159     alter table StatisticalMeasurementValue
8160         add constraint FK2DCE02904FF2DB2C
8161         foreign key (createdby_id)
8162         references UserAccount;
8163
8164     alter table StatisticalMeasurementValue
8165         add constraint FK2DCE02904C428112
8166         foreign key (type_id)
8167         references DefinedTermBase;
8168
8169     alter table StatisticalMeasurementValue
8170         add constraint FK2DCE0290BC5DA539
8171         foreign key (updatedby_id)
8172         references UserAccount;
8173
8174     alter table StatisticalMeasurementValue_AUD
8175         add constraint FKBB16686134869AAE
8176         foreign key (REV)
8177         references AuditEvent;
8178
8179     alter table StatisticalMeasurementValue_DefinedTermBase
8180         add constraint FK686C42B7E0960EC4
8181         foreign key (modifiers_id)
8182         references DefinedTermBase;
8183
8184     alter table StatisticalMeasurementValue_DefinedTermBase
8185         add constraint FK686C42B75C9F4F2B
8186         foreign key (StatisticalMeasurementValue_id)
8187         references StatisticalMeasurementValue;
8188
8189     alter table StatisticalMeasurementValue_DefinedTermBase_AUD
8190         add constraint FKFEBA3D0834869AAE
8191         foreign key (REV)
8192         references AuditEvent;
8193
8194     alter table SynonymRelationship
8195         add constraint FKF483ADB34FF2DB2C
8196         foreign key (createdby_id)
8197         references UserAccount;
8198
8199     alter table SynonymRelationship
8200         add constraint FKF483ADB39803512F
8201         foreign key (citation_id)
8202         references Reference;
8203
8204     alter table SynonymRelationship
8205         add constraint FKF483ADB34BAC703F
8206         foreign key (relatedfrom_id)
8207         references TaxonBase;
8208
8209     alter table SynonymRelationship
8210         add constraint FKF483ADB380924EEC
8211         foreign key (type_id)
8212         references DefinedTermBase;
8213
8214     alter table SynonymRelationship
8215         add constraint FKF483ADB3F8991B9D
8216         foreign key (relatedto_id)
8217         references TaxonBase;
8218
8219     alter table SynonymRelationship
8220         add constraint FKF483ADB3BC5DA539
8221         foreign key (updatedby_id)
8222         references UserAccount;
8223
8224     alter table SynonymRelationship_AUD
8225         add constraint FK8AEBCA0434869AAE
8226         foreign key (REV)
8227         references AuditEvent;
8228
8229     alter table SynonymRelationship_Annotation
8230         add constraint FKF494F15B260A8379
8231         foreign key (SynonymRelationship_id)
8232         references SynonymRelationship;
8233
8234     alter table SynonymRelationship_Annotation
8235         add constraint FKF494F15B1E403E0B
8236         foreign key (annotations_id)
8237         references Annotation;
8238
8239     alter table SynonymRelationship_Annotation_AUD
8240         add constraint FKD3E2F9AC34869AAE
8241         foreign key (REV)
8242         references AuditEvent;
8243
8244     alter table SynonymRelationship_Marker
8245         add constraint FK7A439066777265A1
8246         foreign key (markers_id)
8247         references Marker;
8248
8249     alter table SynonymRelationship_Marker
8250         add constraint FK7A439066260A8379
8251         foreign key (SynonymRelationship_id)
8252         references SynonymRelationship;
8253
8254     alter table SynonymRelationship_Marker_AUD
8255         add constraint FK93C51B3734869AAE
8256         foreign key (REV)
8257         references AuditEvent;
8258
8259     create index taxonBaseTitleCacheIndex on TaxonBase (titleCache);
8260
8261     alter table TaxonBase
8262         add constraint FK9249B49B4FF2DB2C
8263         foreign key (createdby_id)
8264         references UserAccount;
8265
8266     alter table TaxonBase
8267         add constraint FK9249B49B5E4A2F85
8268         foreign key (sec_id)
8269         references Reference;
8270
8271     alter table TaxonBase
8272         add constraint FK9249B49B7C7B5AED
8273         foreign key (taxonomicparentcache_id)
8274         references TaxonBase;
8275
8276     alter table TaxonBase
8277         add constraint FK9249B49BDA93512F
8278         foreign key (name_id)
8279         references TaxonNameBase;
8280
8281     alter table TaxonBase
8282         add constraint FK9249B49BBC5DA539
8283         foreign key (updatedby_id)
8284         references UserAccount;
8285
8286     alter table TaxonBase_AUD
8287         add constraint FK37041CEC34869AAE
8288         foreign key (REV)
8289         references AuditEvent;
8290
8291     alter table TaxonBase_Annotation
8292         add constraint FK41ED09739C9D39
8293         foreign key (TaxonBase_id)
8294         references TaxonBase;
8295
8296     alter table TaxonBase_Annotation
8297         add constraint FK41ED09731E403E0B
8298         foreign key (annotations_id)
8299         references Annotation;
8300
8301     alter table TaxonBase_Annotation_AUD
8302         add constraint FK8C145C434869AAE
8303         foreign key (REV)
8304         references AuditEvent;
8305
8306     alter table TaxonBase_Credit
8307         add constraint FK4CB48B3D9C9D39
8308         foreign key (TaxonBase_id)
8309         references TaxonBase;
8310
8311     alter table TaxonBase_Credit
8312         add constraint FK4CB48B3D32D1B9F
8313         foreign key (credits_id)
8314         references Credit;
8315
8316     alter table TaxonBase_Credit_AUD
8317         add constraint FK7CFED28E34869AAE
8318         foreign key (REV)
8319         references AuditEvent;
8320
8321     alter table TaxonBase_Extension
8322         add constraint FKF961257B927DE9DF
8323         foreign key (extensions_id)
8324         references Extension;
8325
8326     alter table TaxonBase_Extension
8327         add constraint FKF961257B9C9D39
8328         foreign key (TaxonBase_id)
8329         references TaxonBase;
8330
8331     alter table TaxonBase_Extension_AUD
8332         add constraint FK71381DCC34869AAE
8333         foreign key (REV)
8334         references AuditEvent;
8335
8336     alter table TaxonBase_Marker
8337         add constraint FK5CDB747E777265A1
8338         foreign key (markers_id)
8339         references Marker;
8340
8341     alter table TaxonBase_Marker
8342         add constraint FK5CDB747E9C9D39
8343         foreign key (TaxonBase_id)
8344         references TaxonBase;
8345
8346     alter table TaxonBase_Marker_AUD
8347         add constraint FKE11D334F34869AAE
8348         foreign key (REV)
8349         references AuditEvent;
8350
8351     alter table TaxonBase_OriginalSourceBase
8352         add constraint FKFB680C819C9D39
8353         foreign key (TaxonBase_id)
8354         references TaxonBase;
8355
8356     alter table TaxonBase_OriginalSourceBase
8357         add constraint FKFB680C813A6735D9
8358         foreign key (sources_id)
8359         references OriginalSourceBase;
8360
8361     alter table TaxonBase_OriginalSourceBase_AUD
8362         add constraint FKB7C811D234869AAE
8363         foreign key (REV)
8364         references AuditEvent;
8365
8366     alter table TaxonBase_Rights
8367         add constraint FK65CF621B9C9D39
8368         foreign key (TaxonBase_id)
8369         references TaxonBase;
8370
8371     alter table TaxonBase_Rights
8372         add constraint FK65CF621BC13F7B21
8373         foreign key (rights_id)
8374         references Rights;
8375
8376     alter table TaxonBase_Rights_AUD
8377         add constraint FK4CF70A6C34869AAE
8378         foreign key (REV)
8379         references AuditEvent;
8380
8381     alter table TaxonInteraction_LanguageString
8382         add constraint FK579A1DC028459272
8383         foreign key (description_mapkey_id)
8384         references DefinedTermBase;
8385
8386     alter table TaxonInteraction_LanguageString
8387         add constraint FK579A1DC086C86FE0
8388         foreign key (DescriptionElementBase_id)
8389         references DescriptionElementBase;
8390
8391     alter table TaxonInteraction_LanguageString
8392         add constraint FK579A1DC02BEBA58D
8393         foreign key (description_id)
8394         references LanguageString;
8395
8396     alter table TaxonInteraction_LanguageString_AUD
8397         add constraint FK9E016B9134869AAE
8398         foreign key (REV)
8399         references AuditEvent;
8400
8401     create index taxonNameBaseTitleCacheIndex on TaxonNameBase (titleCache);
8402
8403     alter table TaxonNameBase
8404         add constraint FKB4870C64FF2DB2C
8405         foreign key (createdby_id)
8406         references UserAccount;
8407
8408     alter table TaxonNameBase
8409         add constraint FKB4870C662AD57A2
8410         foreign key (excombinationauthorteam_id)
8411         references AgentBase;
8412
8413     alter table TaxonNameBase
8414         add constraint FKB4870C6BFEAE500
8415         foreign key (homotypicalgroup_id)
8416         references HomotypicalGroup;
8417
8418     alter table TaxonNameBase
8419         add constraint FKB4870C6D7BE55A0
8420         foreign key (rank_id)
8421         references DefinedTermBase;
8422
8423     alter table TaxonNameBase
8424         add constraint FKB4870C67F90DF03
8425         foreign key (exbasionymauthorteam_id)
8426         references AgentBase;
8427
8428     alter table TaxonNameBase
8429         add constraint FKB4870C62B4FEDD6
8430         foreign key (basionymauthorteam_id)
8431         references AgentBase;
8432
8433     alter table TaxonNameBase
8434         add constraint FKB4870C64AC9C024
8435         foreign key (nomenclaturalreference_id)
8436         references Reference;
8437
8438     alter table TaxonNameBase
8439         add constraint FKB4870C6B14B73EF
8440         foreign key (combinationauthorteam_id)
8441         references AgentBase;
8442
8443     alter table TaxonNameBase
8444         add constraint FKB4870C6BC5DA539
8445         foreign key (updatedby_id)
8446         references UserAccount;
8447
8448     alter table TaxonNameBase_AUD
8449         add constraint FK5CA2CB9734869AAE
8450         foreign key (REV)
8451         references AuditEvent;
8452
8453     alter table TaxonNameBase_Annotation
8454         add constraint FK9E7794688C85CF94
8455         foreign key (TaxonNameBase_id)
8456         references TaxonNameBase;
8457
8458     alter table TaxonNameBase_Annotation
8459         add constraint FK9E7794681E403E0B
8460         foreign key (annotations_id)
8461         references Annotation;
8462
8463     alter table TaxonNameBase_Annotation_AUD
8464         add constraint FKB6734E3934869AAE
8465         foreign key (REV)
8466         references AuditEvent;
8467
8468     alter table TaxonNameBase_Credit
8469         add constraint FK29BCD8B28C85CF94
8470         foreign key (TaxonNameBase_id)
8471         references TaxonNameBase;
8472
8473     alter table TaxonNameBase_Credit
8474         add constraint FK29BCD8B232D1B9F
8475         foreign key (credits_id)
8476         references Credit;
8477
8478     alter table TaxonNameBase_Credit_AUD
8479         add constraint FKD9895D8334869AAE
8480         foreign key (REV)
8481         references AuditEvent;
8482
8483     alter table TaxonNameBase_Extension
8484         add constraint FKC28EE7E68C85CF94
8485         foreign key (TaxonNameBase_id)
8486         references TaxonNameBase;
8487
8488     alter table TaxonNameBase_Extension
8489         add constraint FKC28EE7E6927DE9DF
8490         foreign key (extensions_id)
8491         references Extension;
8492
8493     alter table TaxonNameBase_Extension_AUD
8494         add constraint FK8F98B2B734869AAE
8495         foreign key (REV)
8496         references AuditEvent;
8497
8498     alter table TaxonNameBase_Marker
8499         add constraint FK39E3C1F3777265A1
8500         foreign key (markers_id)
8501         references Marker;
8502
8503     alter table TaxonNameBase_Marker
8504         add constraint FK39E3C1F38C85CF94
8505         foreign key (TaxonNameBase_id)
8506         references TaxonNameBase;
8507
8508     alter table TaxonNameBase_Marker_AUD
8509         add constraint FK3DA7BE4434869AAE
8510         foreign key (REV)
8511         references AuditEvent;
8512
8513     alter table TaxonNameBase_NomenclaturalStatus
8514         add constraint FK560BA7928C85CF94
8515         foreign key (TaxonNameBase_id)
8516         references TaxonNameBase;
8517
8518     alter table TaxonNameBase_NomenclaturalStatus
8519         add constraint FK560BA7926615E90D
8520         foreign key (status_id)
8521         references NomenclaturalStatus;
8522
8523     alter table TaxonNameBase_NomenclaturalStatus_AUD
8524         add constraint FK9215BC6334869AAE
8525         foreign key (REV)
8526         references AuditEvent;
8527
8528     alter table TaxonNameBase_OriginalSourceBase
8529         add constraint FKF746D2768C85CF94
8530         foreign key (TaxonNameBase_id)
8531         references TaxonNameBase;
8532
8533     alter table TaxonNameBase_OriginalSourceBase
8534         add constraint FKF746D2763A6735D9
8535         foreign key (sources_id)
8536         references OriginalSourceBase;
8537
8538     alter table TaxonNameBase_OriginalSourceBase_AUD
8539         add constraint FK7A38D54734869AAE
8540         foreign key (REV)
8541         references AuditEvent;
8542
8543     alter table TaxonNameBase_Rights
8544         add constraint FK42D7AF908C85CF94
8545         foreign key (TaxonNameBase_id)
8546         references TaxonNameBase;
8547
8548     alter table TaxonNameBase_Rights
8549         add constraint FK42D7AF90C13F7B21
8550         foreign key (rights_id)
8551         references Rights;
8552
8553     alter table TaxonNameBase_Rights_AUD
8554         add constraint FKA981956134869AAE
8555         foreign key (REV)
8556         references AuditEvent;
8557
8558     alter table TaxonNameBase_TypeDesignationBase
8559         add constraint FKC0D6BBB58C85CF94
8560         foreign key (TaxonNameBase_id)
8561         references TaxonNameBase;
8562
8563     alter table TaxonNameBase_TypeDesignationBase
8564         add constraint FKC0D6BBB5C7DF530C
8565         foreign key (typedesignations_id)
8566         references TypeDesignationBase;
8567
8568     alter table TaxonNameBase_TypeDesignationBase_AUD
8569         add constraint FKBB24070634869AAE
8570         foreign key (REV)
8571         references AuditEvent;
8572
8573     alter table TaxonNode
8574         add constraint FK924F5BCC4FF2DB2C
8575         foreign key (createdby_id)
8576         references UserAccount;
8577
8578     alter table TaxonNode
8579         add constraint FK924F5BCC215EDF26
8580         foreign key (referenceforparentchildrelation_id)
8581         references Reference;
8582
8583     alter table TaxonNode
8584         add constraint FK924F5BCC759FE399
8585         foreign key (classification_id)
8586         references Classification;
8587
8588     alter table TaxonNode
8589         add constraint FK924F5BCCDE9A3E39
8590         foreign key (taxon_id)
8591         references TaxonBase;
8592
8593     alter table TaxonNode
8594         add constraint FK924F5BCCCC05993E
8595         foreign key (synonymtobeused_id)
8596         references TaxonBase;
8597
8598     alter table TaxonNode
8599         add constraint FK924F5BCC39DB2DFB
8600         foreign key (parent_id)
8601         references TaxonNode;
8602
8603     alter table TaxonNode
8604         add constraint FK924F5BCCBC5DA539
8605         foreign key (updatedby_id)
8606         references UserAccount;
8607
8608     alter table TaxonNode_AUD
8609         add constraint FKE090C39D34869AAE
8610         foreign key (REV)
8611         references AuditEvent;
8612
8613     alter table TaxonNode_Annotation
8614         add constraint FKD8A9A9A2927D8399
8615         foreign key (TaxonNode_id)
8616         references TaxonNode;
8617
8618     alter table TaxonNode_Annotation
8619         add constraint FKD8A9A9A21E403E0B
8620         foreign key (annotations_id)
8621         references Annotation;
8622
8623     alter table TaxonNode_Annotation_AUD
8624         add constraint FKB2C4367334869AAE
8625         foreign key (REV)
8626         references AuditEvent;
8627
8628     alter table TaxonNode_Marker
8629         add constraint FK395842D777265A1
8630         foreign key (markers_id)
8631         references Marker;
8632
8633     alter table TaxonNode_Marker
8634         add constraint FK395842D927D8399
8635         foreign key (TaxonNode_id)
8636         references TaxonNode;
8637
8638     alter table TaxonNode_Marker_AUD
8639         add constraint FK77D9D37E34869AAE
8640         foreign key (REV)
8641         references AuditEvent;
8642
8643     alter table TaxonRelationship
8644         add constraint FK7482BA024FF2DB2C
8645         foreign key (createdby_id)
8646         references UserAccount;
8647
8648     alter table TaxonRelationship
8649         add constraint FK7482BA029803512F
8650         foreign key (citation_id)
8651         references Reference;
8652
8653     alter table TaxonRelationship
8654         add constraint FK7482BA02E71EF6CE
8655         foreign key (relatedfrom_id)
8656         references TaxonBase;
8657
8658     alter table TaxonRelationship
8659         add constraint FK7482BA02F11BD77B
8660         foreign key (type_id)
8661         references DefinedTermBase;
8662
8663     alter table TaxonRelationship
8664         add constraint FK7482BA02F8991B9D
8665         foreign key (relatedto_id)
8666         references TaxonBase;
8667
8668     alter table TaxonRelationship
8669         add constraint FK7482BA02BC5DA539
8670         foreign key (updatedby_id)
8671         references UserAccount;
8672
8673     alter table TaxonRelationship_AUD
8674         add constraint FKA0DE16D334869AAE
8675         foreign key (REV)
8676         references AuditEvent;
8677
8678     alter table TaxonRelationship_Annotation
8679         add constraint FK82C86DAC2BD180D9
8680         foreign key (TaxonRelationship_id)
8681         references TaxonRelationship;
8682
8683     alter table TaxonRelationship_Annotation
8684         add constraint FK82C86DAC1E403E0B
8685         foreign key (annotations_id)
8686         references Annotation;
8687
8688     alter table TaxonRelationship_Annotation_AUD
8689         add constraint FKE86DE57D34869AAE
8690         foreign key (REV)
8691         references AuditEvent;
8692
8693     alter table TaxonRelationship_Marker
8694         add constraint FK69FBDD37777265A1
8695         foreign key (markers_id)
8696         references Marker;
8697
8698     alter table TaxonRelationship_Marker
8699         add constraint FK69FBDD372BD180D9
8700         foreign key (TaxonRelationship_id)
8701         references TaxonRelationship;
8702
8703     alter table TaxonRelationship_Marker_AUD
8704         add constraint FK21F8978834869AAE
8705         foreign key (REV)
8706         references AuditEvent;
8707
8708     alter table Classification
8709         add constraint FKE332DBE04FF2DB2C
8710         foreign key (createdby_id)
8711         references UserAccount;
8712
8713     alter table Classification
8714         add constraint FKE332DBE0765B124B
8715         foreign key (reference_id)
8716         references Reference;
8717
8718     alter table Classification
8719         add constraint FKE332DBE077E2F09E
8720         foreign key (name_id)
8721         references LanguageString;
8722
8723     alter table Classification
8724         add constraint FKE332DBE0BC5DA539
8725         foreign key (updatedby_id)
8726         references UserAccount;
8727
8728     alter table Classification_AUD
8729         add constraint FK14CE19B134869AAE
8730         foreign key (REV)
8731         references AuditEvent;
8732
8733     alter table Classification_Annotation
8734         add constraint FK9877150E759FE399
8735         foreign key (Classification_id)
8736         references Classification;
8737
8738     alter table Classification_Annotation
8739         add constraint FK9877150E1E403E0B
8740         foreign key (annotations_id)
8741         references Annotation;
8742
8743     alter table Classification_Annotation_AUD
8744         add constraint FKADD60BDF34869AAE
8745         foreign key (REV)
8746         references AuditEvent;
8747
8748     alter table Classification_Credit
8749         add constraint FK21329C58759FE399
8750         foreign key (Classification_id)
8751         references Classification;
8752
8753     alter table Classification_Credit
8754         add constraint FK21329C5832D1B9F
8755         foreign key (credits_id)
8756         references Credit;
8757
8758     alter table Classification_Credit_AUD
8759         add constraint FKD388DE2934869AAE
8760         foreign key (REV)
8761         references AuditEvent;
8762
8763     alter table Classification_Extension
8764         add constraint FKF3E9BA80759FE399
8765         foreign key (Classification_id)
8766         references Classification;
8767
8768     alter table Classification_Extension
8769         add constraint FKF3E9BA80927DE9DF
8770         foreign key (extensions_id)
8771         references Extension;
8772
8773     alter table Classification_Extension_AUD
8774         add constraint FK1BB4A85134869AAE
8775         foreign key (REV)
8776         references AuditEvent;
8777
8778     alter table Classification_Marker
8779         add constraint FK31598599777265A1
8780         foreign key (markers_id)
8781         references Marker;
8782
8783     alter table Classification_Marker
8784         add constraint FK31598599759FE399
8785         foreign key (Classification_id)
8786         references Classification;
8787
8788     alter table Classification_Marker_AUD
8789         add constraint FK37A73EEA34869AAE
8790         foreign key (REV)
8791         references AuditEvent;
8792
8793     alter table Classification_OriginalSourceBase
8794         add constraint FKDE264D1C759FE399
8795         foreign key (Classification_id)
8796         references Classification;
8797
8798     alter table Classification_OriginalSourceBase
8799         add constraint FKDE264D1C3A6735D9
8800         foreign key (sources_id)
8801         references OriginalSourceBase;
8802
8803     alter table Classification_OriginalSourceBase_AUD
8804         add constraint FK99EE8CED34869AAE
8805         foreign key (REV)
8806         references AuditEvent;
8807
8808     alter table Classification_Rights
8809         add constraint FK3A4D7336759FE399
8810         foreign key (Classification_id)
8811         references Classification;
8812
8813     alter table Classification_Rights
8814         add constraint FK3A4D7336C13F7B21
8815         foreign key (rights_id)
8816         references Rights;
8817
8818     alter table Classification_Rights_AUD
8819         add constraint FKA381160734869AAE
8820         foreign key (REV)
8821         references AuditEvent;
8822
8823     alter table Classification_TaxonNode
8824         add constraint FK3349DA2D759FE399
8825         foreign key (Classification_id)
8826         references Classification;
8827
8828     alter table Classification_TaxonNode
8829         add constraint FK3349DA2D18929176
8830         foreign key (rootnodes_id)
8831         references TaxonNode;
8832
8833     alter table Classification_TaxonNode_AUD
8834         add constraint FK6973297E34869AAE
8835         foreign key (REV)
8836         references AuditEvent;
8837
8838     alter table TermVocabulary
8839         add constraint FK487AA6924FF2DB2C
8840         foreign key (createdby_id)
8841         references UserAccount;
8842
8843     alter table TermVocabulary
8844         add constraint FK487AA692BC5DA539
8845         foreign key (updatedby_id)
8846         references UserAccount;
8847
8848     alter table TermVocabulary_AUD
8849         add constraint FKA6ED3B6334869AAE
8850         foreign key (REV)
8851         references AuditEvent;
8852
8853     alter table TermVocabulary_Annotation
8854         add constraint FK76D2071C258E060
8855         foreign key (TermVocabulary_id)
8856         references TermVocabulary;
8857
8858     alter table TermVocabulary_Annotation
8859         add constraint FK76D2071C1E403E0B
8860         foreign key (annotations_id)
8861         references Annotation;
8862
8863     alter table TermVocabulary_Annotation_AUD
8864         add constraint FK222D46ED34869AAE
8865         foreign key (REV)
8866         references AuditEvent;
8867
8868     alter table TermVocabulary_Credit
8869         add constraint FK7604C566258E060
8870         foreign key (TermVocabulary_id)
8871         references TermVocabulary;
8872
8873     alter table TermVocabulary_Credit
8874         add constraint FK7604C56632D1B9F
8875         foreign key (credits_id)
8876         references Credit;
8877
8878     alter table TermVocabulary_Credit_AUD
8879         add constraint FKB1E3D03734869AAE
8880         foreign key (REV)
8881         references AuditEvent;
8882
8883     alter table TermVocabulary_Extension
8884         add constraint FKA8814EB2258E060
8885         foreign key (TermVocabulary_id)
8886         references TermVocabulary;
8887
8888     alter table TermVocabulary_Extension
8889         add constraint FKA8814EB2927DE9DF
8890         foreign key (extensions_id)
8891         references Extension;
8892
8893     alter table TermVocabulary_Extension_AUD
8894         add constraint FKD522D38334869AAE
8895         foreign key (REV)
8896         references AuditEvent;
8897
8898     alter table TermVocabulary_Marker
8899         add constraint FK862BAEA7777265A1
8900         foreign key (markers_id)
8901         references Marker;
8902
8903     alter table TermVocabulary_Marker
8904         add constraint FK862BAEA7258E060
8905         foreign key (TermVocabulary_id)
8906         references TermVocabulary;
8907
8908     alter table TermVocabulary_Marker_AUD
8909         add constraint FK160230F834869AAE
8910         foreign key (REV)
8911         references AuditEvent;
8912
8913     alter table TermVocabulary_OriginalSourceBase
8914         add constraint FK8F2D512A258E060
8915         foreign key (TermVocabulary_id)
8916         references TermVocabulary;
8917
8918     alter table TermVocabulary_OriginalSourceBase
8919         add constraint FK8F2D512A3A6735D9
8920         foreign key (sources_id)
8921         references OriginalSourceBase;
8922
8923     alter table TermVocabulary_OriginalSourceBase_AUD
8924         add constraint FKA898D9FB34869AAE
8925         foreign key (REV)
8926         references AuditEvent;
8927
8928     alter table TermVocabulary_Representation
8929         add constraint FKA408B63A258E060
8930         foreign key (TermVocabulary_id)
8931         references TermVocabulary;
8932
8933     alter table TermVocabulary_Representation
8934         add constraint FKA408B63AB31C4747
8935         foreign key (representations_id)
8936         references Representation;
8937
8938     alter table TermVocabulary_Representation_AUD
8939         add constraint FK681B370B34869AAE
8940         foreign key (REV)
8941         references AuditEvent;
8942
8943     alter table TermVocabulary_Rights
8944         add constraint FK8F1F9C44258E060
8945         foreign key (TermVocabulary_id)
8946         references TermVocabulary;
8947
8948     alter table TermVocabulary_Rights
8949         add constraint FK8F1F9C44C13F7B21
8950         foreign key (rights_id)
8951         references Rights;
8952
8953     alter table TermVocabulary_Rights_AUD
8954         add constraint FK81DC081534869AAE
8955         foreign key (REV)
8956         references AuditEvent;
8957
8958     alter table TypeDesignationBase
8959         add constraint FK8AC9DCAE4FF2DB2C
8960         foreign key (createdby_id)
8961         references UserAccount;
8962
8963     alter table TypeDesignationBase
8964         add constraint FK8AC9DCAE9803512F
8965         foreign key (citation_id)
8966         references Reference;
8967
8968     alter table TypeDesignationBase
8969         add constraint FK8AC9DCAEBFEAE500
8970         foreign key (homotypicalgroup_id)
8971         references HomotypicalGroup;
8972
8973     alter table TypeDesignationBase
8974         add constraint FK8AC9DCAE94DB044A
8975         foreign key (typespecimen_id)
8976         references SpecimenOrObservationBase;
8977
8978     alter table TypeDesignationBase
8979         add constraint FK8AC9DCAE4CB0F315
8980         foreign key (typename_id)
8981         references TaxonNameBase;
8982
8983     alter table TypeDesignationBase
8984         add constraint FK8AC9DCAE9E3ED08
8985         foreign key (typestatus_id)
8986         references DefinedTermBase;
8987
8988     alter table TypeDesignationBase
8989         add constraint FK8AC9DCAEBC5DA539
8990         foreign key (updatedby_id)
8991         references UserAccount;
8992
8993     alter table TypeDesignationBase_AUD
8994         add constraint FK243C037F34869AAE
8995         foreign key (REV)
8996         references AuditEvent;
8997
8998     alter table TypeDesignationBase_Annotation
8999         add constraint FK4D73278044E9E6D4
9000         foreign key (TypeDesignationBase_id)
9001         references TypeDesignationBase;
9002
9003     alter table TypeDesignationBase_Annotation
9004         add constraint FK4D7327801E403E0B
9005         foreign key (annotations_id)
9006         references Annotation;
9007
9008     alter table TypeDesignationBase_Annotation_AUD
9009         add constraint FK88BF955134869AAE
9010         foreign key (REV)
9011         references AuditEvent;
9012
9013     alter table TypeDesignationBase_Marker
9014         add constraint FKB914A10B777265A1
9015         foreign key (markers_id)
9016         references Marker;
9017
9018     alter table TypeDesignationBase_Marker
9019         add constraint FKB914A10B44E9E6D4
9020         foreign key (TypeDesignationBase_id)
9021         references TypeDesignationBase;
9022
9023     alter table TypeDesignationBase_Marker_AUD
9024         add constraint FKECA3515C34869AAE
9025         foreign key (REV)
9026         references AuditEvent;
9027
9028     alter table TypeDesignationBase_TaxonNameBase
9029         add constraint FKF61156F54D901A92
9030         foreign key (typifiednames_id)
9031         references TaxonNameBase;
9032
9033     alter table TypeDesignationBase_TaxonNameBase
9034         add constraint FKF61156F544E9E6D4
9035         foreign key (TypeDesignationBase_id)
9036         references TypeDesignationBase;
9037
9038     alter table TypeDesignationBase_TaxonNameBase_AUD
9039         add constraint FK4F1F024634869AAE
9040         foreign key (REV)
9041         references AuditEvent;
9042
9043     alter table UserAccount
9044         add constraint FKB3F13C24FF2DB2C
9045         foreign key (createdby_id)
9046         references UserAccount;
9047
9048     alter table UserAccount
9049         add constraint FKB3F13C2AAC1B820
9050         foreign key (person_id)
9051         references AgentBase;
9052
9053     alter table UserAccount_AUD
9054         add constraint FK6A57909334869AAE
9055         foreign key (REV)
9056         references AuditEvent;
9057
9058     alter table UserAccount_GrantedAuthorityImpl
9059         add constraint FKFD724D855EA5DD89
9060         foreign key (UserAccount_id)
9061         references UserAccount;
9062
9063     alter table UserAccount_GrantedAuthorityImpl
9064         add constraint FKFD724D851857F6C2
9065         foreign key (grantedauthorities_id)
9066         references GrantedAuthorityImpl;
9067
9068     alter table UserAccount_PermissionGroup
9069         add constraint FK812DE753887E3D12
9070         foreign key (members_id)
9071         references UserAccount;
9072
9073     alter table UserAccount_PermissionGroup
9074         add constraint FK812DE753DA9DCB5F
9075         foreign key (groups_id)
9076         references PermissionGroup;
9077
9078     alter table WorkingSet
9079         add constraint FK668D5B914FF2DB2C
9080         foreign key (createdby_id)
9081         references UserAccount;
9082
9083     alter table WorkingSet
9084         add constraint FK668D5B9123DB7F04
9085         foreign key (descriptivesystem_id)
9086         references FeatureTree;
9087
9088     alter table WorkingSet
9089         add constraint FK668D5B91BC5DA539
9090         foreign key (updatedby_id)
9091         references UserAccount;
9092
9093     alter table WorkingSet_AUD
9094         add constraint FK628F58E234869AAE
9095         foreign key (REV)
9096         references AuditEvent;
9097
9098     alter table WorkingSet_Annotation
9099         add constraint FKCBBA8CBDBBD2C869
9100         foreign key (WorkingSet_id)
9101         references WorkingSet;
9102
9103     alter table WorkingSet_Annotation
9104         add constraint FKCBBA8CBD1E403E0B
9105         foreign key (annotations_id)
9106         references Annotation;
9107
9108     alter table WorkingSet_Annotation_AUD
9109         add constraint FK1E28140E34869AAE
9110         foreign key (REV)
9111         references AuditEvent;
9112
9113     alter table WorkingSet_DescriptionBase
9114         add constraint FK731CC81F33B8A841
9115         foreign key (descriptions_id)
9116         references DescriptionBase;
9117
9118     alter table WorkingSet_DescriptionBase
9119         add constraint FK731CC81FBBD2C869
9120         foreign key (WorkingSet_id)
9121         references WorkingSet;
9122
9123     alter table WorkingSet_DescriptionBase_AUD
9124         add constraint FK8959CE7034869AAE
9125         foreign key (REV)
9126         references AuditEvent;
9127
9128     alter table WorkingSet_Marker
9129         add constraint FK9CB22CC8777265A1
9130         foreign key (markers_id)
9131         references Marker;
9132
9133     alter table WorkingSet_Marker
9134         add constraint FK9CB22CC8BBD2C869
9135         foreign key (WorkingSet_id)
9136         references WorkingSet;
9137
9138     alter table WorkingSet_Marker_AUD
9139         add constraint FK6AEAB69934869AAE
9140         foreign key (REV)
9141         references AuditEvent;
9142
9143     alter table WorkingSet_Representation
9144         add constraint FKA003835BB31C4747
9145         foreign key (representations_id)
9146         references Representation;
9147
9148     alter table WorkingSet_Representation
9149         add constraint FKA003835BBBD2C869
9150         foreign key (WorkingSet_id)
9151         references WorkingSet;
9152
9153     alter table WorkingSet_Representation_AUD
9154         add constraint FK21B88BAC34869AAE
9155         foreign key (REV)
9156         references AuditEvent;
9157
9158     alter table WorkingSet_TaxonBase
9159         add constraint FK34EB896DB4555A9A
9160         foreign key (WorkingSet_id)
9161         references WorkingSet;
9162
9163     alter table WorkingSet_TaxonBase
9164         add constraint FK34EB896D7C3D0017
9165         foreign key (coveredtaxa_id)
9166         references TaxonBase;
9167
9168     alter table WorkingSet_TaxonBase_AUD
9169         add constraint FK582B38BE34869AAE
9170         foreign key (REV)
9171         references AuditEvent;