EDIT

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET(

    DTYPE VARCHAR(31) NOT NULL,

    ID INTEGER NOT NULL,

    CREATED TIMESTAMP,

    UUID VARCHAR(36),

    UPDATED TIMESTAMP,

    PROTECTEDTITLECACHE BOOLEAN,

    TITLECACHE VARCHAR(255),

	LSID_AUTHORITY VARCHAR(255),

    LSID_LSID VARCHAR(255),

    LSID_NAMESPACE VARCHAR(255),

    LSID_OBJECT VARCHAR(255),

    LSID_REVISION VARCHAR(255),

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    DESCRIPTIVESYSTEM_ID INTEGER,

	MAXRANK_ID INTEGER,

	MINRANK_ID INTEGER

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_AUD(

    DTYPE VARCHAR(31) NOT NULL,

    ID INTEGER NOT NULL,

    REV INTEGER NOT NULL,

    REVTYPE TINYINT,

    CREATED TIMESTAMP,

    UUID VARCHAR(36),

    UPDATED TIMESTAMP,

    PROTECTEDTITLECACHE BOOLEAN,

    TITLECACHE VARCHAR(255),

	LSID_AUTHORITY VARCHAR(255),

    LSID_LSID VARCHAR(255),

    LSID_NAMESPACE VARCHAR(255),

    LSID_OBJECT VARCHAR(255),

    LSID_REVISION VARCHAR(255),

    CREATEDBY_ID INTEGER,

    UPDATEDBY_ID INTEGER,

    DESCRIPTIVESYSTEM_ID INTEGER,

	MAXRANK_ID INTEGER,

	MINRANK_ID INTEGER

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_ANNOTATION_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    ANNOTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_CREDIT(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    CREDITS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_CREDIT_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    CREDITS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE(

    DESCRIPTIVEDATASETS_ID INTEGER NOT NULL,

    DESCRIPTIONS_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_DESCRIPTIONBASE_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASETS_ID INTEGER NOT NULL,

    DESCRIPTIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_EXTENSION(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.MEDIA_DESCRIPTIVEDATASET_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    EXTENSIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_IDENTIFIER(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    IDENTIFIERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_IDENTIFIER_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    IDENTIFIERS_ID INTEGER NOT NULL,

    SORTINDEX INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_MARKER_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    MARKERS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_NAMEDAREA(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    GEOFILTER_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_NAMEDAREA_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    GEOFILTER_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_ORIGINALSOURCEBASE(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_ORIGINALSOURCEBASE_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    SOURCES_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    REPRESENTATIONS_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_REPRESENTATION_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    REPRESENTATIONS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_RIGHTSINFO(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_RIGHTSINFO_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    RIGHTS_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_TAXONNODE(

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    TAXONSUBTREEFILTER_ID INTEGER NOT NULL

);

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

CREATE CACHED TABLE PUBLIC.DESCRIPTIVEDATASET_TAXONNODE_AUD(

    REV INTEGER NOT NULL,

    DESCRIPTIVEDATASET_ID INTEGER NOT NULL,

    TAXONSUBTREEFILTER_ID INTEGER NOT NULL,

    REVTYPE TINYINT

);

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