/ - Diff - EDIT - EDIT Project Management

« Previous | Next »

Revision 6eaa7820

Added by Andreas Müller over 1 year ago

ID 6eaa7820bcddd97feba57886f111379eaa469fd6
Parent 811a65d8
Child cebc5b3a

ref #10094 preliminary disable 001-cdm.h2.sql (maybe a java11 issue in jenkins)

                       <id>generate-ddl-create</id>
                       <phase>process-classes</phase>
                       <goals>
                           <goal>run</goal>
                       </goals>
                       <configuration>
                           <target>
                               <skip>true</skip>
                               <delete file="${project.build.outputDirectory}/dbscripts/001-cdm.h2.sql" />
                               <!-- copy template file -->
                               <copy file="${basedir}/src/main/resources/dbscripts/001-cdm.h2.template.sql" tofile="${project.build.outputDirectory}/dbscripts/001-cdm.h2.sql" />

     /*
      * DDL file to generate the database schema for the H2 test database
      */
     -- These settings where taken from the original 001-cdm.h2.sql file:
     SET CLUSTER '';
     SET DEFAULT_TABLE_TYPE 0;
     SET WRITE_DELAY 500;
     SET DEFAULT_LOCK_TIMEOUT 2000;
     SET CACHE_SIZE 16384;
     CREATE USER IF NOT EXISTS EDIT PASSWORD '' ADMIN;
     CREATE SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC START WITH 4 BELONGS_TO_TABLE;
     -- DDL generated by class DdlCreator using maven antrun plugin:
     -- ===========================================================
         create table PUBLIC.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)
         );
         create table PUBLIC.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 PUBLIC.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 boolean not null,
             TITLECACHE varchar(800),
             CODE varchar(255),
             NAME varchar(255),
             COLLECTORTITLECACHE varchar(800),
             NOMENCLATURALTITLECACHE varchar(800),
             COLLECTORTITLE varchar(255),
             FAMILYNAME varchar(255),
             GIVENNAME varchar(255),
             INITIALS varchar(80),
             LIFESPAN_END varchar(255),
             LIFESPAN_FREETEXT varchar(255),
             LIFESPAN_START varchar(255),
             NOMENCLATURALTITLE varchar(255),
             ORCID varchar(16),
             PREFIX varchar(255),
             SUFFIX varchar(255),
             HASMOREMEMBERS boolean,
             PROTECTEDCOLLECTORTITLECACHE boolean,
             PROTECTEDNOMENCLATURALTITLECACHE boolean,
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             ISPARTOF_ID integer,
             primary key (ID)
         );
         create table PUBLIC.AGENTBASE_ADDRESS (
            AGENTBASE_ID integer not null,
             CONTACT_ADDRESSES_ID integer not null,
             primary key (AGENTBASE_ID, CONTACT_ADDRESSES_ID)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_AGENTBASE (
            TEAM_ID integer not null,
             TEAMMEMBERS_ID integer not null,
             SORTINDEX integer not null,
             primary key (TEAM_ID, SORTINDEX)
         );
         create table PUBLIC.AGENTBASE_AGENTBASE_AUD (
            REV integer not null,
             TEAM_ID integer not null,
             TEAMMEMBERS_ID integer not null,
             SORTINDEX integer not null,
             REVTYPE tinyint,
             primary key (REV, TEAM_ID, TEAMMEMBERS_ID, SORTINDEX)
         );
         create table PUBLIC.AGENTBASE_ANNOTATION (
            AGENTBASE_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (AGENTBASE_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_AUD (
            ID integer not null,
             REV integer not null,
             DTYPE varchar(31) 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 boolean,
             TITLECACHE varchar(800),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             CODE varchar(255),
             NAME varchar(255),
             ISPARTOF_ID integer,
             COLLECTORTITLECACHE varchar(800),
             NOMENCLATURALTITLECACHE varchar(800),
             HASMOREMEMBERS boolean,
             PROTECTEDCOLLECTORTITLECACHE boolean,
             PROTECTEDNOMENCLATURALTITLECACHE boolean,
             COLLECTORTITLE varchar(255),
             FAMILYNAME varchar(255),
             GIVENNAME varchar(255),
             INITIALS varchar(80),
             LIFESPAN_END varchar(255),
             LIFESPAN_FREETEXT varchar(255),
             LIFESPAN_START varchar(255),
             NOMENCLATURALTITLE varchar(255),
             ORCID varchar(16),
             PREFIX varchar(255),
             SUFFIX varchar(255),
             primary key (ID, REV)
         );
         create table PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES (
            AGENTBASE_ID integer not null,
             CONTACT_EMAILADDRESSES_ELEMENT varchar(255)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS (
            AGENTBASE_ID integer not null,
             CONTACT_FAXNUMBERS_ELEMENT varchar(255)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS (
            AGENTBASE_ID integer not null,
             CONTACT_PHONENUMBERS_ELEMENT varchar(255)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_CONTACT_URLS (
            AGENTBASE_ID integer not null,
             CONTACT_URLS_ELEMENT varchar(255)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_CREDIT (
            AGENTBASE_ID integer not null,
             CREDITS_ID integer not null,
             SORTINDEX integer not null,
             primary key (AGENTBASE_ID, SORTINDEX)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_DEFINEDTERMBASE (
            INSTITUTION_ID integer not null,
             TYPES_ID integer not null,
             primary key (INSTITUTION_ID, TYPES_ID)
         );
         create table PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD (
            REV integer not null,
             INSTITUTION_ID integer not null,
             TYPES_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, INSTITUTION_ID, TYPES_ID)
         );
         create table PUBLIC.AGENTBASE_EXTENSION (
            AGENTBASE_ID integer not null,
             EXTENSIONS_ID integer not null,
             primary key (AGENTBASE_ID, EXTENSIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_EXTERNALLINK (
            AGENTBASE_ID integer not null,
             LINKS_ID integer not null,
             primary key (AGENTBASE_ID, LINKS_ID)
         );
         create table PUBLIC.AGENTBASE_EXTERNALLINK_AUD (
            REV integer not null,
             AGENTBASE_ID integer not null,
             LINKS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, AGENTBASE_ID, LINKS_ID)
         );
         create table PUBLIC.AGENTBASE_IDENTIFIER (
            AGENTBASE_ID integer not null,
             IDENTIFIERS_ID integer not null,
             SORTINDEX integer not null,
             primary key (AGENTBASE_ID, SORTINDEX)
         );
         create table PUBLIC.AGENTBASE_IDENTIFIER_AUD (
            REV integer not null,
             AGENTBASE_ID integer not null,
             IDENTIFIERS_ID integer not null,
             SORTINDEX integer not null,
             REVTYPE tinyint,
             primary key (REV, AGENTBASE_ID, IDENTIFIERS_ID, SORTINDEX)
         );
         create table PUBLIC.AGENTBASE_MARKER (
            AGENTBASE_ID integer not null,
             MARKERS_ID integer not null,
             primary key (AGENTBASE_ID, MARKERS_ID)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_MEDIA (
            AGENTBASE_ID integer not null,
             MEDIA_ID integer not null,
             primary key (AGENTBASE_ID, MEDIA_ID)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_ORIGINALSOURCEBASE (
            AGENTBASE_ID integer not null,
             SOURCES_ID integer not null,
             primary key (AGENTBASE_ID, SOURCES_ID)
         );
         create table PUBLIC.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 PUBLIC.AGENTBASE_RIGHTSINFO (
            AGENTBASE_ID integer not null,
             RIGHTS_ID integer not null,
             primary key (AGENTBASE_ID, RIGHTS_ID)
         );
         create table PUBLIC.AGENTBASE_RIGHTSINFO_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 PUBLIC.AMPLIFICATION (
            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),
             ELECTROPHORESISVOLTAGE double,
             GELCONCENTRATION double,
             GELRUNNINGTIME double,
             LABELCACHE varchar(255),
             LADDERUSED varchar(255),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             ACTOR_ID integer,
             DNAMARKER_ID integer,
             FORWARDPRIMER_ID integer,
             INSTITUTION_ID integer,
             PURIFICATION_ID integer,
             REVERSEPRIMER_ID integer,
             primary key (ID)
         );
         create table PUBLIC.AMPLIFICATION_ANNOTATION (
            AMPLIFICATION_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (AMPLIFICATION_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.AMPLIFICATION_ANNOTATION_AUD (
            REV integer not null,
             AMPLIFICATION_ID integer not null,
             ANNOTATIONS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, AMPLIFICATION_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.AMPLIFICATION_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),
             ELECTROPHORESISVOLTAGE double,
             GELCONCENTRATION double,
             GELRUNNINGTIME double,
             LABELCACHE varchar(255),
             LADDERUSED varchar(255),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             ACTOR_ID integer,
             DNAMARKER_ID integer,
             FORWARDPRIMER_ID integer,
             INSTITUTION_ID integer,
             PURIFICATION_ID integer,
             REVERSEPRIMER_ID integer,
             primary key (ID, REV)
         );
         create table PUBLIC.AMPLIFICATION_MARKER (
            AMPLIFICATION_ID integer not null,
             MARKERS_ID integer not null,
             primary key (AMPLIFICATION_ID, MARKERS_ID)
         );
         create table PUBLIC.AMPLIFICATION_MARKER_AUD (
            REV integer not null,
             AMPLIFICATION_ID integer not null,
             MARKERS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, AMPLIFICATION_ID, MARKERS_ID)
         );
         create table PUBLIC.AMPLIFICATIONRESULT (
            ID integer not null,
             CREATED timestamp,
             UUID varchar(36),
             UPDATED timestamp,
             SUCCESSTEXT varchar(255),
             SUCCESSFUL boolean,
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             AMPLIFICATION_ID integer,
             CLONING_ID integer,
             DNASAMPLE_ID integer,
             GELPHOTO_ID integer,
             primary key (ID)
         );
         create table PUBLIC.AMPLIFICATIONRESULT_ANNOTATION (
            AMPLIFICATIONRESULT_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (AMPLIFICATIONRESULT_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.AMPLIFICATIONRESULT_ANNOTATION_AUD (
            REV integer not null,
             AMPLIFICATIONRESULT_ID integer not null,
             ANNOTATIONS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, AMPLIFICATIONRESULT_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.AMPLIFICATIONRESULT_AUD (
            ID integer not null,
             REV integer not null,
             REVTYPE tinyint,
             CREATED timestamp,
             UUID varchar(36),
             UPDATED timestamp,
             SUCCESSTEXT varchar(255),
             SUCCESSFUL boolean,
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             AMPLIFICATION_ID integer,
             CLONING_ID integer,
             DNASAMPLE_ID integer,
             GELPHOTO_ID integer,
             primary key (ID, REV)
         );
         create table PUBLIC.AMPLIFICATIONRESULT_MARKER (
            AMPLIFICATIONRESULT_ID integer not null,
             MARKERS_ID integer not null,
             primary key (AMPLIFICATIONRESULT_ID, MARKERS_ID)
         );
         create table PUBLIC.AMPLIFICATIONRESULT_MARKER_AUD (
            REV integer not null,
             AMPLIFICATIONRESULT_ID integer not null,
             MARKERS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, AMPLIFICATIONRESULT_ID, MARKERS_ID)
         );
         create table PUBLIC.ANNOTATION (
            ID integer not null,
             CREATED timestamp,
             UUID varchar(36),
             UPDATED timestamp,
             TEXT clob,
             LINKBACKURI clob,
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             LANGUAGE_ID integer,
             ANNOTATIONTYPE_ID integer,
             COMMENTATOR_ID integer,
             primary key (ID)
         );
         create table PUBLIC.ANNOTATION_ANNOTATION (
            ANNOTATION_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (ANNOTATION_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.ANNOTATION_AUD (
            ID integer not null,
             REV integer not null,
             REVTYPE tinyint,
             CREATED timestamp,
             UUID varchar(36),
             UPDATED timestamp,
             TEXT clob,
             LINKBACKURI clob,
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             LANGUAGE_ID integer,
             ANNOTATIONTYPE_ID integer,
             COMMENTATOR_ID integer,
             primary key (ID, REV)
         );
         create table PUBLIC.ANNOTATION_MARKER (
            ANNOTATION_ID integer not null,
             MARKERS_ID integer not null,
             primary key (ANNOTATION_ID, MARKERS_ID)
         );
         create table PUBLIC.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 PUBLIC.AUDITEVENT (
            REVISIONNUMBER integer not null,
             DATE timestamp,
             TIMESTAMP bigint,
             UUID varchar(255),
             primary key (REVISIONNUMBER)
         );
         create table PUBLIC.AUTHORITY (
            DTYPE varchar(31) not null,
             ID integer not null,
             CREATED timestamp,
             UUID varchar(36),
             OPERATIONS varchar(255),
             PERMISSIONCLASS varchar(255),
             PROPERTY varchar(255),
             TARGETUUID varchar(36),
             ROLE varchar(255),
             CREATEDBY_ID integer,
             primary key (ID)
         );
         create table PUBLIC.CDMLINK (
            DTYPE varchar(31) not null,
             ID integer not null,
             CREATED timestamp,
             UUID varchar(36),
             UPDATED timestamp,
             ENDPOS integer,
             STARTPOS integer,
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             TAXON_ID integer,
             AGENT_ID integer,
             ANNOTATION_ID integer,
             KEY_ID integer,
             LANGUAGESTRING_ID integer,
             MEDIA_ID integer,
             OCCURRENCE_ID integer,
             REFERENCE_ID integer,
             SOURCE_ID integer,
             TAXONNAME_ID integer,
             DESCRIPTION_ID integer,
             primary key (ID)
         );
         create table PUBLIC.CDMLINK_AUD (
            ID integer not null,
             REV integer not null,
             DTYPE varchar(31) not null,
             REVTYPE tinyint,
             CREATED timestamp,
             UUID varchar(36),
             UPDATED timestamp,
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             TAXON_ID integer,
             ENDPOS integer,
             STARTPOS integer,
             AGENT_ID integer,
             ANNOTATION_ID integer,
             KEY_ID integer,
             LANGUAGESTRING_ID integer,
             MEDIA_ID integer,
             OCCURRENCE_ID integer,
             REFERENCE_ID integer,
             SOURCE_ID integer,
             TAXONNAME_ID integer,
             DESCRIPTION_ID integer,
             primary key (ID, REV)
         );
         create table PUBLIC.CDMMETADATA (
            ID integer not null,
             CREATED timestamp,
             UUID varchar(36),
             PROPERTYNAME varchar(20),
             VALUE varchar(255),
             CREATEDBY_ID integer,
             primary key (ID)
         );
         create table PUBLIC.CDMPREFERENCE (
            KEY_PREDICATE varchar(100) not null,
             KEY_SUBJECT varchar(100) not null,
             ALLOWOVERRIDE boolean not null,
             VALUE clob,
             primary key (KEY_PREDICATE, KEY_SUBJECT)
         );
         create table PUBLIC.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 boolean not null,
             TITLECACHE varchar(800),
             TIMEPERIOD_END varchar(255),
             TIMEPERIOD_FREETEXT varchar(255),
             TIMEPERIOD_START varchar(255),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             NAME_ID integer,
             ROOTNODE_ID integer,
             SOURCE_ID integer,
             primary key (ID)
         );
         create table PUBLIC.CLASSIFICATION_ANNOTATION (
            CLASSIFICATION_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (CLASSIFICATION_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.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 boolean,
             TITLECACHE varchar(800),
             TIMEPERIOD_END varchar(255),
             TIMEPERIOD_FREETEXT varchar(255),
             TIMEPERIOD_START varchar(255),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             NAME_ID integer,
             ROOTNODE_ID integer,
             SOURCE_ID integer,
             primary key (ID, REV)
         );
         create table PUBLIC.CLASSIFICATION_CREDIT (
            CLASSIFICATION_ID integer not null,
             CREDITS_ID integer not null,
             SORTINDEX integer not null,
             primary key (CLASSIFICATION_ID, SORTINDEX)
         );
         create table PUBLIC.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 PUBLIC.CLASSIFICATION_DESCRIPTION (
            CLASSIFICATION_ID integer not null,
             DESCRIPTION_ID integer not null,
             DESCRIPTION_MAPKEY_ID integer not null,
             primary key (CLASSIFICATION_ID, DESCRIPTION_MAPKEY_ID)
         );
         create table PUBLIC.CLASSIFICATION_DESCRIPTION_AUD (
            REV integer not null,
             CLASSIFICATION_ID integer not null,
             DESCRIPTION_ID integer not null,
             DESCRIPTION_MAPKEY_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, CLASSIFICATION_ID, DESCRIPTION_ID, DESCRIPTION_MAPKEY_ID)
         );
         create table PUBLIC.CLASSIFICATION_EXTENSION (
            CLASSIFICATION_ID integer not null,
             EXTENSIONS_ID integer not null,
             primary key (CLASSIFICATION_ID, EXTENSIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.CLASSIFICATION_EXTERNALLINK (
            CLASSIFICATION_ID integer not null,
             LINKS_ID integer not null,
             primary key (CLASSIFICATION_ID, LINKS_ID)
         );
         create table PUBLIC.CLASSIFICATION_EXTERNALLINK_AUD (
            REV integer not null,
             CLASSIFICATION_ID integer not null,
             LINKS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, CLASSIFICATION_ID, LINKS_ID)
         );
         create table PUBLIC.CLASSIFICATION_GEOSCOPE (
            CLASSIFICATION_ID integer not null,
             GEOSCOPES_ID integer not null,
             primary key (CLASSIFICATION_ID, GEOSCOPES_ID)
         );
         create table PUBLIC.CLASSIFICATION_GEOSCOPE_AUD (
            REV integer not null,
             CLASSIFICATION_ID integer not null,
             GEOSCOPES_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, CLASSIFICATION_ID, GEOSCOPES_ID)
         );
         create table PUBLIC.CLASSIFICATION_IDENTIFIER (
            CLASSIFICATION_ID integer not null,
             IDENTIFIERS_ID integer not null,
             SORTINDEX integer not null,
             primary key (CLASSIFICATION_ID, SORTINDEX)
         );
         create table PUBLIC.CLASSIFICATION_IDENTIFIER_AUD (
            REV integer not null,
             CLASSIFICATION_ID integer not null,
             IDENTIFIERS_ID integer not null,
             SORTINDEX integer not null,
             REVTYPE tinyint,
             primary key (REV, CLASSIFICATION_ID, IDENTIFIERS_ID, SORTINDEX)
         );
         create table PUBLIC.CLASSIFICATION_MARKER (
            CLASSIFICATION_ID integer not null,
             MARKERS_ID integer not null,
             primary key (CLASSIFICATION_ID, MARKERS_ID)
         );
         create table PUBLIC.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 PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE (
            CLASSIFICATION_ID integer not null,
             SOURCES_ID integer not null,
             primary key (CLASSIFICATION_ID, SOURCES_ID)
         );
         create table PUBLIC.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 PUBLIC.CLASSIFICATION_RIGHTSINFO (
            CLASSIFICATION_ID integer not null,
             RIGHTS_ID integer not null,
             primary key (CLASSIFICATION_ID, RIGHTS_ID)
         );
         create table PUBLIC.CLASSIFICATION_RIGHTSINFO_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 PUBLIC.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 boolean not null,
             TITLECACHE varchar(800),
             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)
         );
         create table PUBLIC.COLLECTION_ANNOTATION (
            COLLECTION_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (COLLECTION_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.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 boolean,
             TITLECACHE varchar(800),
             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 PUBLIC.COLLECTION_CREDIT (
            COLLECTION_ID integer not null,
             CREDITS_ID integer not null,
             SORTINDEX integer not null,
             primary key (COLLECTION_ID, SORTINDEX)
         );
         create table PUBLIC.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 PUBLIC.COLLECTION_EXTENSION (
            COLLECTION_ID integer not null,
             EXTENSIONS_ID integer not null,
             primary key (COLLECTION_ID, EXTENSIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.COLLECTION_EXTERNALLINK (
            COLLECTION_ID integer not null,
             LINKS_ID integer not null,
             primary key (COLLECTION_ID, LINKS_ID)
         );
         create table PUBLIC.COLLECTION_EXTERNALLINK_AUD (
            REV integer not null,
             COLLECTION_ID integer not null,
             LINKS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, COLLECTION_ID, LINKS_ID)
         );
         create table PUBLIC.COLLECTION_IDENTIFIER (
            COLLECTION_ID integer not null,
             IDENTIFIERS_ID integer not null,
             SORTINDEX integer not null,
             primary key (COLLECTION_ID, SORTINDEX)
         );
         create table PUBLIC.COLLECTION_IDENTIFIER_AUD (
            REV integer not null,
             COLLECTION_ID integer not null,
             IDENTIFIERS_ID integer not null,
             SORTINDEX integer not null,
             REVTYPE tinyint,
             primary key (REV, COLLECTION_ID, IDENTIFIERS_ID, SORTINDEX)
         );
         create table PUBLIC.COLLECTION_MARKER (
            COLLECTION_ID integer not null,
             MARKERS_ID integer not null,
             primary key (COLLECTION_ID, MARKERS_ID)
         );
         create table PUBLIC.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 PUBLIC.COLLECTION_MEDIA (
            COLLECTION_ID integer not null,
             MEDIA_ID integer not null,
             primary key (COLLECTION_ID, MEDIA_ID)
         );
         create table PUBLIC.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 PUBLIC.COLLECTION_ORIGINALSOURCEBASE (
            COLLECTION_ID integer not null,
             SOURCES_ID integer not null,
             primary key (COLLECTION_ID, SOURCES_ID)
         );
         create table PUBLIC.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 PUBLIC.COLLECTION_RIGHTSINFO (
            COLLECTION_ID integer not null,
             RIGHTS_ID integer not null,
             primary key (COLLECTION_ID, RIGHTS_ID)
         );
         create table PUBLIC.COLLECTION_RIGHTSINFO_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 PUBLIC.CREDIT (
            ID integer not null,
             CREATED timestamp,
             UUID varchar(36),
             UPDATED timestamp,
             TEXT clob,
             ABBREVIATEDTEXT varchar(255),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             LANGUAGE_ID integer,
             AGENT_ID integer,
             primary key (ID)
         );
         create table PUBLIC.CREDIT_ANNOTATION (
            CREDIT_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (CREDIT_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.CREDIT_AUD (
            ID integer not null,
             REV integer not null,
             REVTYPE tinyint,
             CREATED timestamp,
             UUID varchar(36),
             UPDATED timestamp,
             TEXT clob,
             ABBREVIATEDTEXT varchar(255),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             LANGUAGE_ID integer,
             AGENT_ID integer,
             primary key (ID, REV)
         );
         create table PUBLIC.CREDIT_MARKER (
            CREDIT_ID integer not null,
             MARKERS_ID integer not null,
             primary key (CREDIT_ID, MARKERS_ID)
         );
         create table PUBLIC.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 PUBLIC.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 boolean not null,
             TITLECACHE varchar(800),
             TERMTYPE varchar(255),
             URI clob,
             AUTHORITYTYPE varchar(10),
             EXTERNALID varchar(255),
             EXTERNALLINK clob,
             IMPORTMETHOD varchar(30),
             LASTRETRIEVED timestamp,
             IDINVOCABULARY varchar(255),
             SYMBOL varchar(30),
             SYMBOL2 varchar(30),
             AVAILABLEFOR varchar(255),
             ISO639_1 varchar(2),
             ISTECHNICAL boolean,
             ORDERINDEX integer,
             INVERSESYMBOL varchar(30),
             SYMMETRICAL boolean,
             TRANSITIVE boolean,
             SUPPORTEDDATATYPES varchar(255),
             ABSENCETERM boolean,
             DEFAULTCOLOR varchar(255),
             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),
             NOMENCLATURALSTANDING varchar(255),
             NOMENCLATURALSTANDINGINVERSE varchar(255),
             RANKCLASS varchar(255),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             KINDOF_ID integer,
             PARTOF_ID integer,
             VOCABULARY_ID integer,
             PROPERTY_ID integer,
             PROPERTYMODIFIER_ID integer,
             RATIOTOSTRUCTURE_ID integer,
             STRUCTURE_ID integer,
             STRUCTUREMODIFIER_ID integer,
             LEVEL_ID integer,
             POINTAPPROXIMATION_REFERENCESYSTEM_ID integer,
             SHAPE_ID integer,
             TYPE_ID integer,
             primary key (ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_ANNOTATION (
            DEFINEDTERMBASE_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.DEFINEDTERMBASE_AUD (
            ID integer not null,
             REV integer not null,
             DTYPE varchar(31) 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 boolean,
             TITLECACHE varchar(800),
             TERMTYPE varchar(255),
             URI clob,
             AUTHORITYTYPE varchar(10),
             EXTERNALID varchar(255),
             EXTERNALLINK clob,
             IMPORTMETHOD varchar(30),
             LASTRETRIEVED timestamp,
             IDINVOCABULARY varchar(255),
             SYMBOL varchar(30),
             SYMBOL2 varchar(30),
             CREATEDBY_ID integer,
             UPDATEDBY_ID integer,
             KINDOF_ID integer,
             PARTOF_ID integer,
             VOCABULARY_ID integer,
             AVAILABLEFOR varchar(255),
             SUPPORTEDDATATYPES varchar(255),
             PROPERTY_ID integer,
             PROPERTYMODIFIER_ID integer,
             RATIOTOSTRUCTURE_ID integer,
             STRUCTURE_ID integer,
             STRUCTUREMODIFIER_ID integer,
             ISTECHNICAL boolean,
             ISO639_1 varchar(2),
             ORDERINDEX integer,
             RANKCLASS varchar(255),
             NOMENCLATURALSTANDING varchar(255),
             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),
             ABSENCETERM boolean,
             DEFAULTCOLOR varchar(255),
             INVERSESYMBOL varchar(30),
             SYMMETRICAL boolean,
             TRANSITIVE boolean,
             NOMENCLATURALSTANDINGINVERSE varchar(255),
             primary key (ID, REV)
         );
         create table PUBLIC.DEFINEDTERMBASE_CONTINENT (
            COUNTRY_ID integer not null,
             CONTINENTS_ID integer not null,
             primary key (COUNTRY_ID, CONTINENTS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD (
            REV integer not null,
             COUNTRY_ID integer not null,
             CONTINENTS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, COUNTRY_ID, CONTINENTS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_COUNTRY (
            NAMEDAREA_ID integer not null,
             COUNTRIES_ID integer not null,
             primary key (NAMEDAREA_ID, COUNTRIES_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD (
            REV integer not null,
             NAMEDAREA_ID integer not null,
             COUNTRIES_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, NAMEDAREA_ID, COUNTRIES_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_CREDIT (
            DEFINEDTERMBASE_ID integer not null,
             CREDITS_ID integer not null,
             SORTINDEX integer not null,
             primary key (DEFINEDTERMBASE_ID, SORTINDEX)
         );
         create table PUBLIC.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 PUBLIC.DEFINEDTERMBASE_EXTENSION (
            DEFINEDTERMBASE_ID integer not null,
             EXTENSIONS_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, EXTENSIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.DEFINEDTERMBASE_EXTERNALLINK (
            DEFINEDTERMBASE_ID integer not null,
             LINKS_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, LINKS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_EXTERNALLINK_AUD (
            REV integer not null,
             DEFINEDTERMBASE_ID integer not null,
             LINKS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, DEFINEDTERMBASE_ID, LINKS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_IDENTIFIER (
            DEFINEDTERMBASE_ID integer not null,
             IDENTIFIERS_ID integer not null,
             SORTINDEX integer not null,
             primary key (DEFINEDTERMBASE_ID, SORTINDEX)
         );
         create table PUBLIC.DEFINEDTERMBASE_IDENTIFIER_AUD (
            REV integer not null,
             DEFINEDTERMBASE_ID integer not null,
             IDENTIFIERS_ID integer not null,
             SORTINDEX integer not null,
             REVTYPE tinyint,
             primary key (REV, DEFINEDTERMBASE_ID, IDENTIFIERS_ID, SORTINDEX)
         );
         create table PUBLIC.DEFINEDTERMBASE_INVERSEREPRESENTATION (
            DEFINEDTERMBASE_ID integer not null,
             INVERSEREPRESENTATIONS_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, INVERSEREPRESENTATIONS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_INVERSEREPRESENTATION_AUD (
            REV integer not null,
             DEFINEDTERMBASE_ID integer not null,
             INVERSEREPRESENTATIONS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, DEFINEDTERMBASE_ID, INVERSEREPRESENTATIONS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_MARKER (
            DEFINEDTERMBASE_ID integer not null,
             MARKERS_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, MARKERS_ID)
         );
         create table PUBLIC.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 PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT (
            FEATURE_ID integer not null,
             RECOMMENDEDMEASUREMENTUNITS_ID integer not null,
             primary key (FEATURE_ID, RECOMMENDEDMEASUREMENTUNITS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD (
            REV integer not null,
             FEATURE_ID integer not null,
             RECOMMENDEDMEASUREMENTUNITS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, FEATURE_ID, RECOMMENDEDMEASUREMENTUNITS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_MEDIA (
            DEFINEDTERMBASE_ID integer not null,
             MEDIA_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, MEDIA_ID)
         );
         create table PUBLIC.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 PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE (
            DEFINEDTERMBASE_ID integer not null,
             SOURCES_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, SOURCES_ID)
         );
         create table PUBLIC.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 PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION (
            FEATURE_ID integer not null,
             RECOMMENDEDMODIFIERENUMERATION_ID integer not null,
             primary key (FEATURE_ID, RECOMMENDEDMODIFIERENUMERATION_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD (
            REV integer not null,
             FEATURE_ID integer not null,
             RECOMMENDEDMODIFIERENUMERATION_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, FEATURE_ID, RECOMMENDEDMODIFIERENUMERATION_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_REPRESENTATION (
            DEFINEDTERMBASE_ID integer not null,
             REPRESENTATIONS_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, REPRESENTATIONS_ID)
         );
         create table PUBLIC.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 PUBLIC.DEFINEDTERMBASE_RIGHTSINFO (
            DEFINEDTERMBASE_ID integer not null,
             RIGHTS_ID integer not null,
             primary key (DEFINEDTERMBASE_ID, RIGHTS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_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 PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE (
            FEATURE_ID integer not null,
             RECOMMENDEDSTATISTICALMEASURES_ID integer not null,
             primary key (FEATURE_ID, RECOMMENDEDSTATISTICALMEASURES_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD (
            REV integer not null,
             FEATURE_ID integer not null,
             RECOMMENDEDSTATISTICALMEASURES_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, FEATURE_ID, RECOMMENDEDSTATISTICALMEASURES_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION (
            FEATURE_ID integer not null,
             SUPPORTEDCATEGORICALENUMERATIONS_ID integer not null,
             primary key (FEATURE_ID, SUPPORTEDCATEGORICALENUMERATIONS_ID)
         );
         create table PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD (
            REV integer not null,
             FEATURE_ID integer not null,
             SUPPORTEDCATEGORICALENUMERATIONS_ID integer not null,
             REVTYPE tinyint,
             primary key (REV, FEATURE_ID, SUPPORTEDCATEGORICALENUMERATIONS_ID)
         );
         create table PUBLIC.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,
             INSTITUTION_ID integer,
             TYPE_ID integer,
             primary key (ID)
         );
         create table PUBLIC.DERIVATIONEVENT_ANNOTATION (
            DERIVATIONEVENT_ID integer not null,
             ANNOTATIONS_ID integer not null,
             primary key (DERIVATIONEVENT_ID, ANNOTATIONS_ID)
         );
         create table PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD (

... This diff was truncated because it exceeds the maximum size that can be displayed.

Also available in: Unified diff

Project

General

Profile

EDIT

Revision 6eaa7820

Added by Andreas Müller over 1 year ago

Project

General

Profile

EDIT

Revision 6eaa7820

Added by Andreas Müller over 1 year ago

Related issues