EDIT

cdmlib-io/src/test/resources/dbscripts/001_cdm.ddl -text

	create table Address (

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        locality varchar(255),

        location_errorradius integer,

        location_latitude double,

        location_longitude double,

        pobox varchar(255),

        postcode varchar(255),

        region varchar(255),

        street varchar(255),

        createdby_id integer,

        updatedby_id integer,

        country_id integer,

        location_referencesystem_id integer,

        primary key (id),

        unique (uuid)

    );

    create table Address_AUD (

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        locality varchar(255),

        location_errorradius integer,

        location_latitude double,

        location_longitude double,

        pobox varchar(255),

        postcode varchar(255),

        region varchar(255),

        street varchar(255),

        createdby_id integer,

        updatedby_id integer,

        country_id integer,

        location_referencesystem_id integer,

        primary key (id, REV)

    );

    create table AgentBase (

        DTYPE varchar(31) not null,

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit not null,

        titleCache varchar(255),

        code varchar(255),

        name varchar(255),

        nomenclaturaltitle varchar(255),

        firstname varchar(255),

        lastname varchar(255),

        lifespan_end varchar(255),

        lifespan_freetext varchar(255),

        lifespan_start varchar(255),

        prefix varchar(255),

        suffix varchar(255),

        protectednomenclaturaltitlecache bit,

        createdby_id integer,

        updatedby_id integer,

        ispartof_id integer,

        primary key (id),

        unique (uuid)

    );

    create table AgentBase_AUD (

        DTYPE varchar(31) not null,

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit,

        titleCache varchar(255),

        createdby_id integer,

        updatedby_id integer,

        code varchar(255),

        name varchar(255),

        ispartof_id integer,

        nomenclaturaltitle varchar(255),

        firstname varchar(255),

        lastname varchar(255),

        lifespan_end varchar(255),

        lifespan_freetext varchar(255),

        lifespan_start varchar(255),

        prefix varchar(255),

        suffix varchar(255),

        protectednomenclaturaltitlecache bit,

        primary key (id, REV)

    );

    create table AgentBase_Address (

        AgentBase_id integer not null,

        contact_addresses_id integer not null,

        primary key (AgentBase_id, contact_addresses_id),

        unique (contact_addresses_id)

    );

    create table AgentBase_Address_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        contact_addresses_id integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, contact_addresses_id)

    );

    create table AgentBase_AgentBase (

        AgentBase_id integer not null,

        teammembers_id integer not null,

        sortIndex integer not null,

        primary key (AgentBase_id, sortIndex)

    );

    create table AgentBase_AgentBase_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        teammembers_id integer not null,

        sortIndex integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, teammembers_id, sortIndex)

    );

    create table AgentBase_Annotation (

        AgentBase_id integer not null,

        annotations_id integer not null,

        primary key (AgentBase_id, annotations_id),

        unique (annotations_id)

    );

    create table AgentBase_Annotation_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, annotations_id)

    );

    create table AgentBase_Credit (

        AgentBase_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        primary key (AgentBase_id, sortIndex),

        unique (credits_id)

    );

    create table AgentBase_Credit_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, credits_id, sortIndex)

    );

    create table AgentBase_DefinedTermBase (

        AgentBase_id integer not null,

        types_id integer not null,

        primary key (AgentBase_id, types_id)

    );

    create table AgentBase_DefinedTermBase_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        types_id integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, types_id)

    );

    create table AgentBase_Extension (

        AgentBase_id integer not null,

        extensions_id integer not null,

        primary key (AgentBase_id, extensions_id),

        unique (extensions_id)

    );

    create table AgentBase_Extension_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        extensions_id integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, extensions_id)

    );

    create table AgentBase_Marker (

        AgentBase_id integer not null,

        markers_id integer not null,

        primary key (AgentBase_id, markers_id),

        unique (markers_id)

    );

    create table AgentBase_Marker_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, markers_id)

    );

    create table AgentBase_Media (

        AgentBase_id integer not null,

        media_id integer not null,

        primary key (AgentBase_id, media_id)

    );

    create table AgentBase_Media_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        media_id integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, media_id)

    );

    create table AgentBase_OriginalSourceBase (

        AgentBase_id integer not null,

        sources_id integer not null,

        primary key (AgentBase_id, sources_id),

        unique (sources_id)

    );

    create table AgentBase_OriginalSourceBase_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        sources_id integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, sources_id)

    );

    create table AgentBase_Rights (

        AgentBase_id integer not null,

        rights_id integer not null,

        primary key (AgentBase_id, rights_id),

        unique (rights_id)

    );

    create table AgentBase_Rights_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        rights_id integer not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, rights_id)

    );

    create table AgentBase_contact_emailaddresses (

        AgentBase_id integer not null,

        contact_emailaddresses_element varchar(255)

    );

    create table AgentBase_contact_emailaddresses_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        contact_emailaddresses_element varchar(255) not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, contact_emailaddresses_element)

    );

    create table AgentBase_contact_faxnumbers (

        AgentBase_id integer not null,

        contact_faxnumbers_element varchar(255)

    );

    create table AgentBase_contact_faxnumbers_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        contact_faxnumbers_element varchar(255) not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, contact_faxnumbers_element)

    );

    create table AgentBase_contact_phonenumbers (

        AgentBase_id integer not null,

        contact_phonenumbers_element varchar(255)

    );

    create table AgentBase_contact_phonenumbers_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        contact_phonenumbers_element varchar(255) not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, contact_phonenumbers_element)

    );

    create table AgentBase_contact_urls (

        AgentBase_id integer not null,

        contact_urls_element varchar(255)

    );

    create table AgentBase_contact_urls_AUD (

        REV integer not null,

        AgentBase_id integer not null,

        contact_urls_element varchar(255) not null,

        revtype tinyint,

        primary key (REV, AgentBase_id, contact_urls_element)

    );

    create table Annotation (

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        text longvarchar,

        annotatedObj_type varchar(255),

        annotatedObj_id integer not null,

        linkbackurl varbinary(255),

        createdby_id integer,

        updatedby_id integer,

        language_id integer,

        annotationtype_id integer,

        commentator_id integer,

        primary key (id),

        unique (uuid)

    );

    create table Annotation_AUD (

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        text longvarchar,

        linkbackurl varbinary(255),

        createdby_id integer,

        updatedby_id integer,

        language_id integer,

        annotationtype_id integer,

        commentator_id integer,

        primary key (id, REV)

    );

    create table Annotation_Annotation (

        Annotation_id integer not null,

        annotations_id integer not null,

        primary key (Annotation_id, annotations_id),

        unique (annotations_id)

    );

    create table Annotation_Annotation_AUD (

        REV integer not null,

        Annotation_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, Annotation_id, annotations_id)

    );

    create table Annotation_Marker (

        Annotation_id integer not null,

        markers_id integer not null,

        primary key (Annotation_id, markers_id),

        unique (markers_id)

    );

    create table Annotation_Marker_AUD (

        REV integer not null,

        Annotation_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, Annotation_id, markers_id)

    );

    create table AuditEvent (

        revisionnumber integer generated by default as identity (start with 1),

        date timestamp,

        timestamp bigint,

        uuid varchar(255),

        primary key (revisionnumber)

    );

    create table CDM_VIEW (

        id integer not null,

        created timestamp,

        uuid varchar(36),

        description varchar(255),

        name varchar(255),

        createdby_id integer,

        reference_id integer,

        primary key (id),

        unique (uuid)

    );

    create table CDM_VIEW_CDM_VIEW (

        CDM_VIEW_id integer not null,

        superviews_id integer not null,

        primary key (CDM_VIEW_id, superviews_id),

        unique (superviews_id)

    );

    create table Classification (

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit not null,

        titleCache varchar(255),

        microreference varchar(255),

        createdby_id integer,

        updatedby_id integer,

        name_id integer,

        reference_id integer,

        primary key (id),

        unique (uuid)

    );

    create table Classification_AUD (

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit,

        titleCache varchar(255),

        microreference varchar(255),

        createdby_id integer,

        updatedby_id integer,

        name_id integer,

        reference_id integer,

        primary key (id, REV)

    );

    create table Classification_Annotation (

        Classification_id integer not null,

        annotations_id integer not null,

        primary key (Classification_id, annotations_id),

        unique (annotations_id)

    );

    create table Classification_Annotation_AUD (

        REV integer not null,

        Classification_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, Classification_id, annotations_id)

    );

    create table Classification_Credit (

        Classification_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        primary key (Classification_id, sortIndex),

        unique (credits_id)

    );

    create table Classification_Credit_AUD (

        REV integer not null,

        Classification_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        revtype tinyint,

        primary key (REV, Classification_id, credits_id, sortIndex)

    );

    create table Classification_Extension (

        Classification_id integer not null,

        extensions_id integer not null,

        primary key (Classification_id, extensions_id),

        unique (extensions_id)

    );

    create table Classification_Extension_AUD (

        REV integer not null,

        Classification_id integer not null,

        extensions_id integer not null,

        revtype tinyint,

        primary key (REV, Classification_id, extensions_id)

    );

    create table Classification_Marker (

        Classification_id integer not null,

        markers_id integer not null,

        primary key (Classification_id, markers_id),

        unique (markers_id)

    );

    create table Classification_Marker_AUD (

        REV integer not null,

        Classification_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, Classification_id, markers_id)

    );

    create table Classification_OriginalSourceBase (

        Classification_id integer not null,

        sources_id integer not null,

        primary key (Classification_id, sources_id),

        unique (sources_id)

    );

    create table Classification_OriginalSourceBase_AUD (

        REV integer not null,

        Classification_id integer not null,

        sources_id integer not null,

        revtype tinyint,

        primary key (REV, Classification_id, sources_id)

    );

    create table Classification_Rights (

        Classification_id integer not null,

        rights_id integer not null,

        primary key (Classification_id, rights_id),

        unique (rights_id)

    );

    create table Classification_Rights_AUD (

        REV integer not null,

        Classification_id integer not null,

        rights_id integer not null,

        revtype tinyint,

        primary key (REV, Classification_id, rights_id)

    );

    create table Classification_TaxonNode (

        Classification_id integer not null,

        rootnodes_id integer not null,

        primary key (Classification_id, rootnodes_id),

        unique (rootnodes_id)

    );

    create table Classification_TaxonNode_AUD (

        REV integer not null,

        Classification_id integer not null,

        rootnodes_id integer not null,

        revtype tinyint,

        primary key (REV, Classification_id, rootnodes_id)

    );

    create table Collection (

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit not null,

        titleCache varchar(255),

        code varchar(255),

        codestandard varchar(255),

        name varchar(255),

        townorlocation varchar(255),

        createdby_id integer,

        updatedby_id integer,

        institute_id integer,

        supercollection_id integer,

        primary key (id),

        unique (uuid)

    );

    create table Collection_AUD (

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit,

        titleCache varchar(255),

        code varchar(255),

        codestandard varchar(255),

        name varchar(255),

        townorlocation varchar(255),

        createdby_id integer,

        updatedby_id integer,

        institute_id integer,

        supercollection_id integer,

        primary key (id, REV)

    );

    create table Collection_Annotation (

        Collection_id integer not null,

        annotations_id integer not null,

        primary key (Collection_id, annotations_id),

        unique (annotations_id)

    );

    create table Collection_Annotation_AUD (

        REV integer not null,

        Collection_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, Collection_id, annotations_id)

    );

    create table Collection_Credit (

        Collection_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        primary key (Collection_id, sortIndex),

        unique (credits_id)

    );

    create table Collection_Credit_AUD (

        REV integer not null,

        Collection_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        revtype tinyint,

        primary key (REV, Collection_id, credits_id, sortIndex)

    );

    create table Collection_Extension (

        Collection_id integer not null,

        extensions_id integer not null,

        primary key (Collection_id, extensions_id),

        unique (extensions_id)

    );

    create table Collection_Extension_AUD (

        REV integer not null,

        Collection_id integer not null,

        extensions_id integer not null,

        revtype tinyint,

        primary key (REV, Collection_id, extensions_id)

    );

    create table Collection_Marker (

        Collection_id integer not null,

        markers_id integer not null,

        primary key (Collection_id, markers_id),

        unique (markers_id)

    );

    create table Collection_Marker_AUD (

        REV integer not null,

        Collection_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, Collection_id, markers_id)

    );

    create table Collection_Media (

        Collection_id integer not null,

        media_id integer not null,

        primary key (Collection_id, media_id)

    );

    create table Collection_Media_AUD (

        REV integer not null,

        Collection_id integer not null,

        media_id integer not null,

        revtype tinyint,

        primary key (REV, Collection_id, media_id)

    );

    create table Collection_OriginalSourceBase (

        Collection_id integer not null,

        sources_id integer not null,

        primary key (Collection_id, sources_id),

        unique (sources_id)

    );

    create table Collection_OriginalSourceBase_AUD (

        REV integer not null,

        Collection_id integer not null,

        sources_id integer not null,

        revtype tinyint,

        primary key (REV, Collection_id, sources_id)

    );

    create table Collection_Rights (

        Collection_id integer not null,

        rights_id integer not null,

        primary key (Collection_id, rights_id),

        unique (rights_id)

    );

    create table Collection_Rights_AUD (

        REV integer not null,

        Collection_id integer not null,

        rights_id integer not null,

        revtype tinyint,

        primary key (REV, Collection_id, rights_id)

    );

    create table Credit (

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        text longvarchar,

        abbreviatedtext varchar(255),

        createdby_id integer,

        updatedby_id integer,

        language_id integer,

        agent_id integer,

        primary key (id),

        unique (uuid)

    );

    create table Credit_AUD (

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        text longvarchar,

        abbreviatedtext varchar(255),

        createdby_id integer,

        updatedby_id integer,

        language_id integer,

        agent_id integer,

        primary key (id, REV)

    );

    create table Credit_Annotation (

        Credit_id integer not null,

        annotations_id integer not null,

        primary key (Credit_id, annotations_id),

        unique (annotations_id)

    );

    create table Credit_Annotation_AUD (

        REV integer not null,

        Credit_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, Credit_id, annotations_id)

    );

    create table Credit_Marker (

        Credit_id integer not null,

        markers_id integer not null,

        primary key (Credit_id, markers_id),

        unique (markers_id)

    );

    create table Credit_Marker_AUD (

        REV integer not null,

        Credit_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, Credit_id, markers_id)

    );

    create table DefinedTermBase (

        DTYPE varchar(31) not null,

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit not null,

        titleCache varchar(255),

        uri varchar(255),

        iso639_1 varchar(2),

        iso639_2 varchar(3),

        istechnical bit,

        orderindex integer,

        symmetrical bit,

        transitive bit,

        defaultcolor varchar(255),

        supportscategoricaldata bit,

        supportscommontaxonname bit,

        supportsdistribution bit,

        supportsindividualassociation bit,

        supportsquantitativedata bit,

        supportstaxoninteraction bit,

        supportstextdata bit,

        pointapproximation_errorradius integer,

        pointapproximation_latitude double,

        pointapproximation_longitude double,

        validperiod_end varchar(255),

        validperiod_freetext varchar(255),

        validperiod_start varchar(255),

        iso3166_a2 varchar(2),

        createdby_id integer,

        updatedby_id integer,

        kindof_id integer,

        partof_id integer,

        vocabulary_id integer,

        level_id integer,

        pointapproximation_referencesystem_id integer,

        shape_id integer,

        type_id integer,

        primary key (id),

        unique (uuid)

    );

    create table DefinedTermBase_AUD (

        DTYPE varchar(31) not null,

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit,

        titleCache varchar(255),

        uri varchar(255),

        createdby_id integer,

        updatedby_id integer,

        kindof_id integer,

        partof_id integer,

        vocabulary_id integer,

        istechnical bit,

        orderindex integer,

        iso639_1 varchar(2),

        iso639_2 varchar(3),

        symmetrical bit,

        transitive bit,

        pointapproximation_errorradius integer,

        pointapproximation_latitude double,

        pointapproximation_longitude double,

        validperiod_end varchar(255),

        validperiod_freetext varchar(255),

        validperiod_start varchar(255),

        level_id integer,

        pointapproximation_referencesystem_id integer,

        shape_id integer,

        type_id integer,

        iso3166_a2 varchar(2),

        defaultcolor varchar(255),

        supportscategoricaldata bit,

        supportscommontaxonname bit,

        supportsdistribution bit,

        supportsindividualassociation bit,

        supportsquantitativedata bit,

        supportstaxoninteraction bit,

        supportstextdata bit,

        primary key (id, REV)

    );

    create table DefinedTermBase_Annotation (

        DefinedTermBase_id integer not null,

        annotations_id integer not null,

        primary key (DefinedTermBase_id, annotations_id),

        unique (annotations_id)

    );

    create table DefinedTermBase_Annotation_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, annotations_id)

    );

    create table DefinedTermBase_Continent (

        DefinedTermBase_id integer not null,

        continents_id integer not null,

        primary key (DefinedTermBase_id, continents_id)

    );

    create table DefinedTermBase_Continent_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        continents_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, continents_id)

    );

    create table DefinedTermBase_Credit (

        DefinedTermBase_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        primary key (DefinedTermBase_id, sortIndex),

        unique (credits_id)

    );

    create table DefinedTermBase_Credit_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, credits_id, sortIndex)

    );

    create table DefinedTermBase_Extension (

        DefinedTermBase_id integer not null,

        extensions_id integer not null,

        primary key (DefinedTermBase_id, extensions_id),

        unique (extensions_id)

    );

    create table DefinedTermBase_Extension_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        extensions_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, extensions_id)

    );

    create table DefinedTermBase_Marker (

        DefinedTermBase_id integer not null,

        markers_id integer not null,

        primary key (DefinedTermBase_id, markers_id),

        unique (markers_id)

    );

    create table DefinedTermBase_Marker_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, markers_id)

    );

    create table DefinedTermBase_MeasurementUnit (

        DefinedTermBase_id integer not null,

        recommendedmeasurementunits_id integer not null,

        primary key (DefinedTermBase_id, recommendedmeasurementunits_id)

    );

    create table DefinedTermBase_MeasurementUnit_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        recommendedmeasurementunits_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, recommendedmeasurementunits_id)

    );

    create table DefinedTermBase_Media (

        DefinedTermBase_id integer not null,

        media_id integer not null,

        primary key (DefinedTermBase_id, media_id),

        unique (media_id)

    );

    create table DefinedTermBase_Media_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        media_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, media_id)

    );

    create table DefinedTermBase_OriginalSourceBase (

        DefinedTermBase_id integer not null,

        sources_id integer not null,

        primary key (DefinedTermBase_id, sources_id),

        unique (sources_id)

    );

    create table DefinedTermBase_OriginalSourceBase_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        sources_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, sources_id)

    );

    create table DefinedTermBase_RecommendedModifierEnumeration (

        DefinedTermBase_id integer not null,

        recommendedmodifierenumeration_id integer not null,

        primary key (DefinedTermBase_id, recommendedmodifierenumeration_id),

        unique (recommendedmodifierenumeration_id)

    );

    create table DefinedTermBase_RecommendedModifierEnumeration_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        recommendedmodifierenumeration_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, recommendedmodifierenumeration_id)

    );

    create table DefinedTermBase_Representation (

        DefinedTermBase_id integer not null,

        representations_id integer not null,

        primary key (DefinedTermBase_id, representations_id),

        unique (representations_id)

    );

    create table DefinedTermBase_Representation_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        representations_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, representations_id)

    );

    create table DefinedTermBase_Rights (

        DefinedTermBase_id integer not null,

        rights_id integer not null,

        primary key (DefinedTermBase_id, rights_id),

        unique (rights_id)

    );

    create table DefinedTermBase_Rights_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        rights_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, rights_id)

    );

    create table DefinedTermBase_StatisticalMeasure (

        DefinedTermBase_id integer not null,

        recommendedstatisticalmeasures_id integer not null,

        primary key (DefinedTermBase_id, recommendedstatisticalmeasures_id)

    );

    create table DefinedTermBase_StatisticalMeasure_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        recommendedstatisticalmeasures_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, recommendedstatisticalmeasures_id)

    );

    create table DefinedTermBase_SupportedCategoricalEnumeration (

        DefinedTermBase_id integer not null,

        supportedcategoricalenumerations_id integer not null,

        primary key (DefinedTermBase_id, supportedcategoricalenumerations_id),

        unique (supportedcategoricalenumerations_id)

    );

    create table DefinedTermBase_SupportedCategoricalEnumeration_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        supportedcategoricalenumerations_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, supportedcategoricalenumerations_id)

    );

    create table DefinedTermBase_WaterbodyOrCountry (

        DefinedTermBase_id integer not null,

        waterbodiesorcountries_id integer not null,

        primary key (DefinedTermBase_id, waterbodiesorcountries_id)

    );

    create table DefinedTermBase_WaterbodyOrCountry_AUD (

        REV integer not null,

        DefinedTermBase_id integer not null,

        waterbodiesorcountries_id integer not null,

        revtype tinyint,

        primary key (REV, DefinedTermBase_id, waterbodiesorcountries_id)

    );

    create table DerivationEvent (

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        description varchar(255),

        timeperiod_end varchar(255),

        timeperiod_freetext varchar(255),

        timeperiod_start varchar(255),

        createdby_id integer,

        updatedby_id integer,

        actor_id integer,

        type_id integer,

        primary key (id),

        unique (uuid)

    );

    create table DerivationEvent_AUD (

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        description varchar(255),

        timeperiod_end varchar(255),

        timeperiod_freetext varchar(255),

        timeperiod_start varchar(255),

        createdby_id integer,

        updatedby_id integer,

        actor_id integer,

        type_id integer,

        primary key (id, REV)

    );

    create table DerivationEvent_Annotation (

        DerivationEvent_id integer not null,

        annotations_id integer not null,

        primary key (DerivationEvent_id, annotations_id),

        unique (annotations_id)

    );

    create table DerivationEvent_Annotation_AUD (

        REV integer not null,

        DerivationEvent_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, DerivationEvent_id, annotations_id)

    );

    create table DerivationEvent_Marker (

        DerivationEvent_id integer not null,

        markers_id integer not null,

        primary key (DerivationEvent_id, markers_id),

        unique (markers_id)

    );

    create table DerivationEvent_Marker_AUD (

        REV integer not null,

        DerivationEvent_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, DerivationEvent_id, markers_id)

    );

    create table DescriptionBase (

        DTYPE varchar(31) not null,

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit not null,

        titleCache varchar(255),

        imagegallery bit not null,

        createdby_id integer,

        updatedby_id integer,

        taxon_id integer,

        taxonname_id integer,

        primary key (id),

        unique (uuid)

    );

    create table DescriptionBase_AUD (

        DTYPE varchar(31) not null,

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        lsid_authority varchar(255),

        lsid_lsid varchar(255),

        lsid_namespace varchar(255),

        lsid_object varchar(255),

        lsid_revision varchar(255),

        protectedtitlecache bit,

        titleCache varchar(255),

        imagegallery bit,

        createdby_id integer,

        updatedby_id integer,

        taxon_id integer,

        taxonname_id integer,

        primary key (id, REV)

    );

    create table DescriptionBase_Annotation (

        DescriptionBase_id integer not null,

        annotations_id integer not null,

        primary key (DescriptionBase_id, annotations_id),

        unique (annotations_id)

    );

    create table DescriptionBase_Annotation_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, annotations_id)

    );

    create table DescriptionBase_Credit (

        DescriptionBase_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        primary key (DescriptionBase_id, sortIndex),

        unique (credits_id)

    );

    create table DescriptionBase_Credit_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        credits_id integer not null,

        sortIndex integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, credits_id, sortIndex)

    );

    create table DescriptionBase_Extension (

        DescriptionBase_id integer not null,

        extensions_id integer not null,

        primary key (DescriptionBase_id, extensions_id),

        unique (extensions_id)

    );

    create table DescriptionBase_Extension_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        extensions_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, extensions_id)

    );

    create table DescriptionBase_Feature (

        DescriptionBase_id integer not null,

        descriptivesystem_id integer not null,

        primary key (DescriptionBase_id, descriptivesystem_id)

    );

    create table DescriptionBase_Feature_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        descriptivesystem_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, descriptivesystem_id)

    );

    create table DescriptionBase_GeoScope (

        DescriptionBase_id integer not null,

        geoscopes_id integer not null,

        primary key (DescriptionBase_id, geoscopes_id)

    );

    create table DescriptionBase_GeoScope_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        geoscopes_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, geoscopes_id)

    );

    create table DescriptionBase_Marker (

        DescriptionBase_id integer not null,

        markers_id integer not null,

        primary key (DescriptionBase_id, markers_id),

        unique (markers_id)

    );

    create table DescriptionBase_Marker_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, markers_id)

    );

    create table DescriptionBase_OriginalSourceBase (

        DescriptionBase_id integer not null,

        sources_id integer not null,

        primary key (DescriptionBase_id, sources_id),

        unique (sources_id)

    );

    create table DescriptionBase_OriginalSourceBase_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        sources_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, sources_id)

    );

    create table DescriptionBase_Reference (

        DescriptionBase_id integer not null,

        descriptionsources_id integer not null,

        primary key (DescriptionBase_id, descriptionsources_id)

    );

    create table DescriptionBase_Reference_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        descriptionsources_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, descriptionsources_id)

    );

    create table DescriptionBase_Rights (

        DescriptionBase_id integer not null,

        rights_id integer not null,

        primary key (DescriptionBase_id, rights_id),

        unique (rights_id)

    );

    create table DescriptionBase_Rights_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        rights_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, rights_id)

    );

    create table DescriptionBase_Scope (

        DescriptionBase_id integer not null,

        scopes_id integer not null,

        primary key (DescriptionBase_id, scopes_id)

    );

    create table DescriptionBase_Scope_AUD (

        REV integer not null,

        DescriptionBase_id integer not null,

        scopes_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionBase_id, scopes_id)

    );

    create table DescriptionBase_SpecimenOrObservationBase (

        descriptions_id integer not null,

        describedspecimenorobservations_id integer not null,

        primary key (descriptions_id, describedspecimenorobservations_id)

    );

    create table DescriptionBase_SpecimenOrObservationBase_AUD (

        REV integer not null,

        descriptions_id integer not null,

        describedspecimenorobservations_id integer not null,

        revtype tinyint,

        primary key (REV, descriptions_id, describedspecimenorobservations_id)

    );

    create table DescriptionElementBase (

        DTYPE varchar(31) not null,

        id integer not null,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        orderrelevant bit,

        name varchar(255),

        createdby_id integer,

        updatedby_id integer,

        feature_id integer,

        indescription_id integer,

        language_id integer,

        area_id integer,

        status_id integer,

        associatedspecimenorobservation_id integer,

        unit_id integer,

        taxon2_id integer,

        format_id integer,

        primary key (id),

        unique (uuid)

    );

    create table DescriptionElementBase_AUD (

        DTYPE varchar(31) not null,

        id integer not null,

        REV integer not null,

        revtype tinyint,

        created timestamp,

        uuid varchar(36),

        updated timestamp,

        createdby_id integer,

        updatedby_id integer,

        feature_id integer,

        indescription_id integer,

        orderrelevant bit,

        associatedspecimenorobservation_id integer,

        name varchar(255),

        language_id integer,

        taxon2_id integer,

        area_id integer,

        status_id integer,

        unit_id integer,

        format_id integer,

        primary key (id, REV)

    );

    create table DescriptionElementBase_Annotation (

        DescriptionElementBase_id integer not null,

        annotations_id integer not null,

        primary key (DescriptionElementBase_id, annotations_id),

        unique (annotations_id)

    );

    create table DescriptionElementBase_Annotation_AUD (

        REV integer not null,

        DescriptionElementBase_id integer not null,

        annotations_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionElementBase_id, annotations_id)

    );

    create table DescriptionElementBase_LanguageString (

        DescriptionElementBase_id integer not null,

        multilanguagetext_id integer not null,

        multilanguagetext_mapkey_id integer not null,

        primary key (DescriptionElementBase_id, multilanguagetext_mapkey_id),

        unique (multilanguagetext_id)

    );

    create table DescriptionElementBase_LanguageString_AUD (

        REV integer not null,

        DescriptionElementBase_id integer not null,

        multilanguagetext_id integer not null,

        multilanguagetext_mapkey_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionElementBase_id, multilanguagetext_id, multilanguagetext_mapkey_id)

    );

    create table DescriptionElementBase_Marker (

        DescriptionElementBase_id integer not null,

        markers_id integer not null,

        primary key (DescriptionElementBase_id, markers_id),

        unique (markers_id)

    );

    create table DescriptionElementBase_Marker_AUD (

        REV integer not null,

        DescriptionElementBase_id integer not null,

        markers_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionElementBase_id, markers_id)

    );

    create table DescriptionElementBase_Media (

        DescriptionElementBase_id integer not null,

        media_id integer not null,

        sortIndex integer not null,

        primary key (DescriptionElementBase_id, sortIndex)

    );

    create table DescriptionElementBase_Media_AUD (

        REV integer not null,

        DescriptionElementBase_id integer not null,

        media_id integer not null,

        sortIndex integer not null,

        revtype tinyint,

        primary key (REV, DescriptionElementBase_id, media_id, sortIndex)

    );

    create table DescriptionElementBase_Modifier (

        DescriptionElementBase_id integer not null,

        modifiers_id integer not null,

        primary key (DescriptionElementBase_id, modifiers_id)

    );

    create table DescriptionElementBase_Modifier_AUD (

        REV integer not null,

        DescriptionElementBase_id integer not null,

        modifiers_id integer not null,

        revtype tinyint,

        primary key (REV, DescriptionElementBase_id, modifiers_id)

    );

    create table DescriptionElementBase_ModifyingText (

        DescriptionElementBase_id integer not null,

        modifyingtext_id integer not null,

        modifyingtext_mapkey_id integer not null,

        primary key (DescriptionElementBase_id, modifyingtext_mapkey_id),

        unique (modifyingtext_id)

    );