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