EDIT

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;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADDRESS;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ADDRESS_AUD;

CREATE CACHED 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(255),

	PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL,

	COLLECTORTITLE VARCHAR(255),

	PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,

    NOMENCLATURALTITLE VARCHAR(255),

    CODE VARCHAR(255),

    NAME VARCHAR(255),

    FIRSTNAME VARCHAR(255),

	INITIALS VARCHAR(50),

    LASTNAME VARCHAR(255),

    LIFESPAN_END VARCHAR(255),

    LIFESPAN_FREETEXT VARCHAR(255),

    LIFESPAN_START VARCHAR(255),

    PREFIX VARCHAR(255),

    SUFFIX VARCHAR(255),

	HASMOREMEMBERS BOOLEAN,

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    ISPARTOF_ID INTEGER

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE;

CREATE INDEX PUBLIC.AGENTTITLECACHEINDEX ON PUBLIC.AGENTBASE(TITLECACHE);

CREATE CACHED TABLE PUBLIC.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 BOOLEAN,

    TITLECACHE VARCHAR(255),

    PROTECTEDCOLLECTORTITLECACHE BOOLEAN NOT NULL,

	COLLECTORTITLE VARCHAR(255),

    NOMENCLATURALTITLE VARCHAR(255),

    PROTECTEDNOMENCLATURALTITLECACHE BOOLEAN,

    FIRSTNAME VARCHAR(255),

    INITIALS VARCHAR(50),

	LASTNAME VARCHAR(255),

    LIFESPAN_END VARCHAR(255),

    LIFESPAN_FREETEXT VARCHAR(255),

    LIFESPAN_START VARCHAR(255),

    PREFIX VARCHAR(255),

    SUFFIX VARCHAR(255),

    CODE VARCHAR(255),

    NAME VARCHAR(255),	

	HASMOREMEMBERS BOOLEAN,

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

   	ISPARTOF_ID INTEGER,

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS(

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_ADDRESSES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS;

CREATE CACHED TABLE PUBLIC.AGENTBASE_ADDRESS_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_ADDRESSES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ADDRESS_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_AGENTBASE(

    TEAM_ID INTEGER NOT NULL,

    TEAMMEMBERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_AGENTBASE_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_ANNOTATION(

    AGENTBASE_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ANNOTATION;

CREATE CACHED TABLE PUBLIC.AGENTBASE_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CREDIT(

    AGENTBASE_ID INTEGER NOT NULL,

    CREDITS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CREDIT_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE(

    INSTITUTION_ID INTEGER NOT NULL,

    TYPES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE;

CREATE CACHED TABLE PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD(

    REV INTEGER NOT NULL,

    INSTITUTION_ID INTEGER NOT NULL,

    TYPES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_DEFINEDTERMBASE_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_EXTENSION(

    AGENTBASE_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_EXTENSION;

CREATE CACHED TABLE PUBLIC.AGENTBASE_EXTENSION_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_EXTENSION_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_IDENTIFIER(

    AGENTBASE_ID INTEGER NOT NULL,

    IDENTIFIERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_IDENTIFIER;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_IDENTIFIER_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_MARKER(

    AGENTBASE_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MARKER;

CREATE CACHED TABLE PUBLIC.AGENTBASE_MARKER_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_MEDIA(

    AGENTBASE_ID INTEGER NOT NULL,

    MEDIA_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MEDIA;

CREATE CACHED TABLE PUBLIC.AGENTBASE_MEDIA_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    MEDIA_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_MEDIA_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE(

    AGENTBASE_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ORIGINALSOURCEBASE;

CREATE CACHED TABLE PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_ORIGINALSOURCEBASE_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_RIGHTSINFO(

    AGENTBASE_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_RIGHTSINFO;

CREATE CACHED TABLE PUBLIC.AGENTBASE_RIGHTSINFO_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES(

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_EMAILADDRESSES_ELEMENT VARCHAR(255)

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_EMAILADDRESSES_ELEMENT VARCHAR(255) NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_EMAILADDRESSES_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS(

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_FAXNUMBERS_ELEMENT VARCHAR(255)

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_FAXNUMBERS_ELEMENT VARCHAR(255) NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_FAXNUMBERS_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS(

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_PHONENUMBERS_ELEMENT VARCHAR(255)

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_PHONENUMBERS_ELEMENT VARCHAR(255) NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_PHONENUMBERS_AUD;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS(

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_URLS_ELEMENT VARCHAR(255)

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS;

CREATE CACHED TABLE PUBLIC.AGENTBASE_CONTACT_URLS_AUD(

    REV INTEGER NOT NULL,

    AGENTBASE_ID INTEGER NOT NULL,

    CONTACT_URLS_ELEMENT VARCHAR(255) NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.AGENTBASE_CONTACT_URLS_AUD;

CREATE TABLE 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,

     LADDERUSED VARCHAR(255),

	 LABELCACHE VARCHAR(255),

     CREATEDBY_ID INTEGER,

     UPDATEDBY_ID INTEGER,

     ACTOR_ID INTEGER,

     FORWARDPRIMER_ID INTEGER,

     DNAMARKER_ID INTEGER,

     PURIFICATION_ID INTEGER,

     INSTITUTION_ID INTEGER,

	 REVERSEPRIMER_ID INTEGER,

     PRIMARY KEY (ID)

);

CREATE TABLE 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,

    LADDERUSED VARCHAR(255),

    LABELCACHE VARCHAR(255),

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    ACTOR_ID INTEGER,

    FORWARDPRIMER_ID INTEGER,

    DNAMARKER_ID INTEGER,

    PURIFICATION_ID INTEGER,

    INSTITUTION_ID INTEGER,

	REVERSEPRIMER_ID INTEGER,

    PRIMARY KEY (ID)

);

CREATE TABLE AMPLIFICATION_ANNOTATION (

    AMPLIFICATION_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    PRIMARY KEY (AMPLIFICATION_ID, ANNOTATIONS_ID)

);

CREATE TABLE AMPLIFICATION_ANNOTATION_AUD (

    REV INTEGER NOT NULL,

    REVTYPE TINYINT,

    AMPLIFICATION_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

CREATE TABLE AMPLIFICATION_MARKER (

    AMPLIFICATION_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    PRIMARY KEY (AMPLIFICATION_ID, MARKERS_ID)

);

CREATE TABLE AMPLIFICATION_MARKER_AUD (

    REV INTEGER NOT NULL,

    REVTYPE TINYINT,

    AMPLIFICATION_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

);

CREATE TABLE AMPLIFICATIONRESULT (

     ID INTEGER NOT NULL,

     CREATED TIMESTAMP,

     UUID VARCHAR(36),

     UPDATED TIMESTAMP,

     SUCCESSTEXT VARCHAR(255),

     SUCCESSFUL BOOLEAN,

     CREATEDBY_ID INTEGER,

     UPDATEDBY_ID INTEGER,

     CLONING_ID INTEGER,

     DNASAMPLE_ID INTEGER,

	 AMPLIFICATION_ID INTEGER,

	 GELPHOTO_ID INTEGER,

     PRIMARY KEY (ID)

);

CREATE TABLE 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,

     CLONING_ID INTEGER,

     DNASAMPLE_ID INTEGER,

     AMPLIFICATION_ID INTEGER,

	 GELPHOTO_ID INTEGER,

     PRIMARY KEY (ID)

);

CREATE TABLE AMPLIFICATIONRESULT_ANNOTATION (

    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    PRIMARY KEY (AMPLIFICATIONRESULT_ID, ANNOTATIONS_ID)

);

CREATE TABLE AMPLIFICATIONRESULT_ANNOTATION_AUD (

    REV INTEGER NOT NULL,

    REVTYPE TINYINT,

    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

CREATE TABLE AMPLIFICATIONRESULT_MARKER (

    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    PRIMARY KEY (AMPLIFICATIONRESULT_ID, MARKERS_ID)

);

CREATE TABLE AMPLIFICATIONRESULT_MARKER_AUD (

    REV INTEGER NOT NULL,

    REVTYPE TINYINT,

    AMPLIFICATIONRESULT_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

);

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.ANNOTATION_ANNOTATION(

    ANNOTATION_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_ANNOTATION;

CREATE CACHED TABLE PUBLIC.ANNOTATION_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    ANNOTATION_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.ANNOTATION_MARKER(

    ANNOTATION_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_MARKER;

CREATE CACHED TABLE PUBLIC.ANNOTATION_MARKER_AUD(

    REV INTEGER NOT NULL,

    ANNOTATION_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.ANNOTATION_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.AUDITEVENT(

    REVISIONNUMBER INTEGER DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_10A55F0A_EE57_42DB_8046_6240A60AD0EC,

    DATE TIMESTAMP,

    TIMESTAMP BIGINT,

    UUID VARCHAR(255)

);

-- 3 +/- SELECT COUNT(*) FROM PUBLIC.AUDITEVENT;

CREATE CACHED TABLE PUBLIC.CDM_VIEW(

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

    UUID VARCHAR(36),

    DESCRIPTION VARCHAR(255),

    NAME VARCHAR(255),

    CREATEDBY_ID INTEGER,

    REFERENCE_ID INTEGER

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CDM_VIEW;

CREATE CACHED TABLE PUBLIC.CDM_VIEW_CDM_VIEW(

    CDM_VIEW_ID INTEGER NOT NULL,

    SUPERVIEWS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CDM_VIEW_CDM_VIEW;

CREATE CACHED TABLE PUBLIC.CDMMETADATA(

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

    UUID VARCHAR(36),

    PROPERTYNAME VARCHAR(20),

    VALUE VARCHAR(255),

    CREATEDBY_ID INTEGER

);

-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;

CREATE CACHED TABLE PUBLIC.CDMPREFERENCE(

    KEY_SUBJECT VARCHAR(100),

    KEY_PREDICATE VARCHAR(100),

    VALUE VARCHAR(1023),

	ALLOWOVERRIDE BOOLEAN NOT NULL

);

-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMPREFERENCE;

CREATE CACHED 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(255),

    MICROREFERENCE VARCHAR(255),

    TIMEPERIOD_START VARCHAR(255),

    TIMEPERIOD_FREETEXT VARCHAR(255),

    TIMEPERIOD_END VARCHAR(255),

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    NAME_ID INTEGER,

    REFERENCE_ID INTEGER,

    ROOTNODE_ID INTEGER

);

-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION;

CREATE CACHED 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(255),

    MICROREFERENCE VARCHAR(255),

    TIMEPERIOD_START VARCHAR(255),

    TIMEPERIOD_FREETEXT VARCHAR(255),

    TIMEPERIOD_END VARCHAR(255),

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    NAME_ID INTEGER,

    REFERENCE_ID INTEGER,

    ROOTNODE_ID INTEGER

);

-- 1 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION(

    CLASSIFICATION_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    CLASSIFICATION_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_CREDIT(

    CLASSIFICATION_ID INTEGER NOT NULL,

    CREDITS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_CREDIT_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_DESCRIPTION(

    CLASSIFICATION_ID INTEGER NOT NULL,

   	DESCRIPTION_ID INTEGER NOT NULL,

   	DESCRIPTION_MAPKEY_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_DESCRIPTION;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_DESCRIPTION_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION(

    CLASSIFICATION_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_EXTENSION;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_EXTENSION_AUD(

    REV INTEGER NOT NULL,

    CLASSIFICATION_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_EXTENSION_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_GEOSCOPE(

    CLASSIFICATION_ID INTEGER NOT NULL,

    GEOSCOPES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_GEOSCOPE;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_GEOSCOPE_AUD(

    REV INTEGER NOT NULL,

    CLASSIFICATION_ID INTEGER NOT NULL,

    GEOSCOPES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_GEOSCOPE_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_IDENTIFIER(

    CLASSIFICATION_ID INTEGER NOT NULL,

    IDENTIFIERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_IDENTIFIER;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_IDENTIFIER_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_MARKER(

    CLASSIFICATION_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_MARKER;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_MARKER_AUD(

    REV INTEGER NOT NULL,

    CLASSIFICATION_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE(

    CLASSIFICATION_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD(

    REV INTEGER NOT NULL,

    CLASSIFICATION_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_ORIGINALSOURCEBASE_AUD;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO(

    CLASSIFICATION_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTSINFO;

CREATE CACHED TABLE PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD(

    REV INTEGER NOT NULL,

    CLASSIFICATION_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_RIGHTSINFO_AUD;

CREATE CACHED 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(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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION;

CREATE INDEX PUBLIC.COLLECTIONTITLECACHEINDEX ON PUBLIC.COLLECTION(TITLECACHE);

CREATE CACHED 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(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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_AUD;

CREATE CACHED TABLE PUBLIC.COLLECTION_ANNOTATION(

    COLLECTION_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ANNOTATION;

CREATE CACHED TABLE PUBLIC.COLLECTION_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    COLLECTION_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.COLLECTION_CREDIT(

    COLLECTION_ID INTEGER NOT NULL,

    CREDITS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_CREDIT;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_CREDIT_AUD;

CREATE CACHED TABLE PUBLIC.COLLECTION_EXTENSION(

    COLLECTION_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_EXTENSION;

CREATE CACHED TABLE PUBLIC.COLLECTION_EXTENSION_AUD(

    REV INTEGER NOT NULL,

    COLLECTION_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_EXTENSION_AUD;

CREATE CACHED TABLE PUBLIC.COLLECTION_IDENTIFIER(

    COLLECTION_ID INTEGER NOT NULL,

    IDENTIFIERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_IDENTIFIER;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_IDENTIFIER_AUD;

CREATE CACHED TABLE PUBLIC.COLLECTION_MARKER(

    COLLECTION_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MARKER;

CREATE CACHED TABLE PUBLIC.COLLECTION_MARKER_AUD(

    REV INTEGER NOT NULL,

    COLLECTION_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.COLLECTION_MEDIA(

    COLLECTION_ID INTEGER NOT NULL,

    MEDIA_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MEDIA;

CREATE CACHED TABLE PUBLIC.COLLECTION_MEDIA_AUD(

    REV INTEGER NOT NULL,

    COLLECTION_ID INTEGER NOT NULL,

    MEDIA_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_MEDIA_AUD;

CREATE CACHED TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE(

    COLLECTION_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ORIGINALSOURCEBASE;

CREATE CACHED TABLE PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD(

    REV INTEGER NOT NULL,

    COLLECTION_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_ORIGINALSOURCEBASE_AUD;

CREATE CACHED TABLE PUBLIC.COLLECTION_RIGHTSINFO(

    COLLECTION_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_RIGHTSINFO;

CREATE CACHED TABLE PUBLIC.COLLECTION_RIGHTSINFO_AUD(

    REV INTEGER NOT NULL,

    COLLECTION_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.COLLECTION_RIGHTSINFO_AUD;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_AUD;

CREATE CACHED TABLE PUBLIC.CREDIT_ANNOTATION(

    CREDIT_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_ANNOTATION;

CREATE CACHED TABLE PUBLIC.CREDIT_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    CREDIT_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.CREDIT_MARKER(

    CREDIT_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_MARKER;

CREATE CACHED TABLE PUBLIC.CREDIT_MARKER_AUD(

    REV INTEGER NOT NULL,

    CREDIT_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CREDIT_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE(

    DTYPE VARCHAR(31) NOT NULL,

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

    UUID VARCHAR(36),

    UPDATED TIMESTAMP,

    TERMTYPE VARCHAR(4),

    IDINVOCABULARY VARCHAR(255),

	SYMBOL VARCHAR(30),

	INVERSESYMBOL VARCHAR(30),

    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(255),

    URI CLOB,

    ISO639_1 VARCHAR(2),

    RANKCLASS VARCHAR(4) NOT NULL,

    ISTECHNICAL BOOLEAN,

    ABSENCETERM BOOLEAN NOT NULL,

    ORDERINDEX INTEGER,

    SYMMETRICAL BOOLEAN,

    TRANSITIVE BOOLEAN,

    DEFAULTCOLOR VARCHAR(255),

    SUPPORTSCATEGORICALDATA BOOLEAN,

    SUPPORTSCOMMONTAXONNAME BOOLEAN,

    SUPPORTSDISTRIBUTION BOOLEAN,

    SUPPORTSINDIVIDUALASSOCIATION BOOLEAN,

    SUPPORTSQUANTITATIVEDATA BOOLEAN,

    SUPPORTSTAXONINTERACTION BOOLEAN,

    SUPPORTSTEXTDATA BOOLEAN,

    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,

	STRUCTURE_ID INTEGER,

	PROPERTY_ID INTEGER,

);

-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_AUD(

    DTYPE VARCHAR(31) NOT NULL,

    ID INTEGER NOT NULL,

    REV INTEGER NOT NULL,

    REVTYPE TINYINT,

    CREATED TIMESTAMP,

    UUID VARCHAR(36),

    UPDATED TIMESTAMP,

    TERMTYPE VARCHAR(4),

    IDINVOCABULARY VARCHAR(255),

	SYMBOL VARCHAR(30),

	INVERSESYMBOL VARCHAR(30),

    LSID_AUTHORITY VARCHAR(255),

    LSID_LSID VARCHAR(255),

    LSID_NAMESPACE VARCHAR(255),

    LSID_OBJECT VARCHAR(255),

    LSID_REVISION VARCHAR(255),

    PROTECTEDTITLECACHE BOOLEAN,

    TITLECACHE VARCHAR(255),

    URI CLOB,

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    KINDOF_ID INTEGER,

    PARTOF_ID INTEGER,

    VOCABULARY_ID INTEGER,

    ORDERINDEX INTEGER,

    ISO639_1 VARCHAR(2),

    RANKCLASS VARCHAR(4) NOT NULL,

    SUPPORTSCATEGORICALDATA BOOLEAN,

    SUPPORTSCOMMONTAXONNAME BOOLEAN,

    SUPPORTSDISTRIBUTION BOOLEAN,

    SUPPORTSINDIVIDUALASSOCIATION BOOLEAN,

    SUPPORTSQUANTITATIVEDATA BOOLEAN,

    SUPPORTSTAXONINTERACTION BOOLEAN,

    SUPPORTSTEXTDATA BOOLEAN,

    SYMMETRICAL BOOLEAN,

    TRANSITIVE BOOLEAN,

    ISTECHNICAL BOOLEAN,

    ABSENCETERM BOOLEAN NOT NULL,

    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),

 	LEVEL_ID INTEGER,

    POINTAPPROXIMATION_REFERENCESYSTEM_ID INTEGER,

    SHAPE_ID INTEGER,

    TYPE_ID INTEGER,

    STRUCTURE_ID INTEGER,

	PROPERTY_ID INTEGER,

);

-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT(

    COUNTRY_ID INTEGER NOT NULL,

    CONTINENTS_ID INTEGER NOT NULL

);

-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD(

    REV INTEGER NOT NULL,

    COUNTRY_ID INTEGER NOT NULL,

    CONTINENTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 242 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CONTINENT_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_CREDIT(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    CREDITS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CREDIT;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_CREDIT_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_EXTENSION;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD(

    REV INTEGER NOT NULL,

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_EXTENSION_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_IDENTIFIER(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    IDENTIFIERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_IDENTIFIER;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_IDENTIFIER_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MARKER(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MARKER_AUD(

    REV INTEGER NOT NULL,

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT(

    FEATURE_ID INTEGER NOT NULL,

    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD(

    REV INTEGER NOT NULL,

    FEATURE_ID INTEGER NOT NULL,

    RECOMMENDEDMEASUREMENTUNITS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEASUREMENTUNIT_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEDIA(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    MEDIA_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEDIA;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_MEDIA_AUD(

    REV INTEGER NOT NULL,

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    MEDIA_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_MEDIA_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD(

    REV INTEGER NOT NULL,

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_ORIGINALSOURCEBASE_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION(

    FEATURE_ID INTEGER NOT NULL,

    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD(

    REV INTEGER NOT NULL,

    FEATURE_ID INTEGER NOT NULL,

    RECOMMENDEDMODIFIERENUMERATION_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RECOMMENDEDMODIFIERENUMERATION_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    REPRESENTATIONS_ID INTEGER NOT NULL

);

-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_REPRESENTATION;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD(

    REV INTEGER NOT NULL,

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    REPRESENTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 2084 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_REPRESENTATION_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO(

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTSINFO;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD(

    REV INTEGER NOT NULL,

    DEFINEDTERMBASE_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE(

    FEATURE_ID INTEGER NOT NULL,

    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD(

    REV INTEGER NOT NULL,

    FEATURE_ID INTEGER NOT NULL,

    RECOMMENDEDSTATISTICALMEASURES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_STATISTICALMEASURE_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION(

    FEATURE_ID INTEGER NOT NULL,

    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD(

    REV INTEGER NOT NULL,

    FEATURE_ID INTEGER NOT NULL,

    SUPPORTEDCATEGORICALENUMERATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_SUPPORTEDCATEGORICALENUMERATION_AUD;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY(

    NAMEDAREA_ID INTEGER NOT NULL,

    COUNTRIES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_COUNTRY;

CREATE CACHED TABLE PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD(

    REV INTEGER NOT NULL,

    NAMEDAREA_ID INTEGER NOT NULL,

    COUNTRIES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DEFINEDTERMBASE_COUNTRY_AUD;

CREATE CACHED 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

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT;

CREATE CACHED TABLE PUBLIC.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,

    INSTITUTION_ID INTEGER,

	TYPE_ID INTEGER

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_AUD;

CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION(

    DERIVATIONEVENT_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_ANNOTATION;

CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    DERIVATIONEVENT_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_MARKER(

    DERIVATIONEVENT_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_MARKER;

CREATE CACHED TABLE PUBLIC.DERIVATIONEVENT_MARKER_AUD(

    REV INTEGER NOT NULL,

    DERIVATIONEVENT_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DERIVATIONEVENT_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.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 BOOLEAN NOT NULL,

    TITLECACHE VARCHAR(255),

    IMAGEGALLERY BOOLEAN NOT NULL,

	ISDEFAULT BOOLEAN NOT NULL,

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    SPECIMEN_ID INTEGER,

    TAXON_ID INTEGER,

    TAXONNAME_ID INTEGER

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE;

CREATE CACHED TABLE PUBLIC.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 BOOLEAN,

    TITLECACHE VARCHAR(255),

    IMAGEGALLERY BOOLEAN,

	ISDEFAULT BOOLEAN,

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    SPECIMEN_ID INTEGER,

    TAXON_ID INTEGER,

    TAXONNAME_ID INTEGER

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ANNOTATION;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ANNOTATION_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_CREDIT(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    CREDITS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_CREDIT;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_CREDIT_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    CREDITS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_CREDIT_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_EXTENSION;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_EXTENSION_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_EXTENSION_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_IDENTIFIER(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    IDENTIFIERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_IDENTIFIER;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_IDENTIFIER_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    IDENTIFIERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_IDENTIFIER_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_FEATURE(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    DESCRIPTIVESYSTEM_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_FEATURE;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_FEATURE_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    DESCRIPTIVESYSTEM_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_FEATURE_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE(

    TAXONDESCRIPTION_ID INTEGER NOT NULL,

    GEOSCOPES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_GEOSCOPE;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_GEOSCOPE_AUD(

    REV INTEGER NOT NULL,

    TAXONDESCRIPTION_ID INTEGER NOT NULL,

    GEOSCOPES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_GEOSCOPE_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_MARKER(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_MARKER;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_MARKER_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_MARKER_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_ORIGINALSOURCEBASE_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    DESCRIPTIONSOURCES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_REFERENCE;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    DESCRIPTIONSOURCES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_REFERENCE_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_RIGHTSINFO(

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_RIGHTSINFO;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_RIGHTSINFO_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIONBASE_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_RIGHTSINFO_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE(

    TAXONDESCRIPTION_ID INTEGER NOT NULL,

    SCOPES_ID INTEGER NOT NULL

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SCOPE;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONBASE_SCOPE_AUD(

    REV INTEGER NOT NULL,

    TAXONDESCRIPTION_ID INTEGER NOT NULL,

    SCOPES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONBASE_SCOPE_AUD;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE(

    DTYPE VARCHAR(31) NOT NULL,

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

    UUID VARCHAR(36),

    UPDATED TIMESTAMP,

    NAME VARCHAR(255),

    TIMEPERIOD_START VARCHAR(255),

    TIMEPERIOD_END VARCHAR(255),

    TIMEPERIOD_FREETEXT VARCHAR(255),

    ORDERRELEVANT BOOLEAN,

--  MINIMUM DOUBLE,

--	MAXIMUM DOUBLE,

--	AVERAGE DOUBLE,

--	TYPCALLOWERBOUNDARY DOUBLE,

--	TYPCALHIGHERBOUNDARY DOUBLE,

--	VARIANCE DOUBLE,

--	STANDARDDEVIATION DOUBLE,

--	SINGLEVALUE DOUBLE,

--	SAMPLESIZE INTEGER,

	UNKNOWNDATA BOOLEAN,

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    FEATURE_ID INTEGER,

    INDESCRIPTION_ID INTEGER,

    AREA_ID INTEGER,

    LANGUAGE_ID INTEGER,

    STATUS_ID INTEGER,

    ASSOCIATEDSPECIMENOROBSERVATION_ID INTEGER,

    UNIT_ID INTEGER,

    TAXON2_ID INTEGER,

    FORMAT_ID INTEGER,

);

-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE;

CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_AUD(

    DTYPE VARCHAR(31) NOT NULL,

    ID INTEGER NOT NULL,

    REV INTEGER NOT NULL,

    REVTYPE TINYINT,

    CREATED TIMESTAMP,

    UUID VARCHAR(36),

    UPDATED TIMESTAMP,

    NAME VARCHAR(255),

    TIMEPERIOD_START VARCHAR(255),

    TIMEPERIOD_END VARCHAR(255),

    TIMEPERIOD_FREETEXT VARCHAR(255),

--  MINIMUM DOUBLE,

--	MAXIMUM DOUBLE,

--	AVERAGE DOUBLE,

--	TYPCALLOWERBOUNDARY DOUBLE,