CREATEDBY_ID INTEGER
);
-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;
-CREATE CACHED TABLE PUBLIC.CDMPREFERENCES(
- SUBJECT VARCHAR(255),
- PREDICATE VARCHAR(255),
+CREATE CACHED TABLE PUBLIC.CDMPREFERENCE(
+ KEY_SUBJECT VARCHAR(100),
+ KEY_PREDICATE VARCHAR(100),
VALUE VARCHAR(1023)
);
--- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMMETADATA;
+-- 3 +/- SELECT COUNT(*) FROM PUBLIC.CDMPREFERENCE;
CREATE CACHED TABLE PUBLIC.CLASSIFICATION(
ID INTEGER NOT NULL,
CREATED TIMESTAMP,
REVTYPE TINYINT
);
-CREATE TABLE PUBLIC.CLONING (
- ID INTEGER NOT NULL,
- UUID VARCHAR(36),
- CREATED TIMESTAMP,
- UPDATED TIMESTAMP,
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER,
- DESCRIPTION VARCHAR(255),
- TIMEPERIOD_END VARCHAR(255),
- TIMEPERIOD_FREETEXT VARCHAR(255),
- TIMEPERIOD_START VARCHAR(255),
- STRAIN VARCHAR(255),
- METHOD_ID INTEGER,
- ACTOR_ID INTEGER,
- FORWARDPRIMER_ID INTEGER,
- REVERSEPRIMER_ID INTEGER,
- PRIMARY KEY (ID)
-);
-
-CREATE TABLE PUBLIC.CLONING_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),
- METHOD_ID INTEGER,
- STRAIN VARCHAR(255),
- CREATEDBY_ID INTEGER,
- UPDATEDBY_ID INTEGER,
- ACTOR_ID INTEGER,
- FORWARDPRIMER_ID INTEGER,
- REVERSEPRIMER_ID INTEGER
-);
-
-
-CREATE TABLE PUBLIC.CLONING_ANNOTATION (
- CLONING_ID INTEGER NOT NULL,
- ANNOTATIONS_ID INTEGER NOT NULL,
- PRIMARY KEY (CLONING_ID, ANNOTATIONS_ID)
-);
-
-CREATE TABLE PUBLIC.CLONING_ANNOTATION_AUD (
- REV INTEGER NOT NULL,
- REVTYPE TINYINT,
- CLONING_ID INTEGER NOT NULL,
- ANNOTATIONS_ID INTEGER NOT NULL
-);
-
-CREATE TABLE PUBLIC.CLONING_MARKER (
- CLONING_ID INTEGER NOT NULL,
- MARKERS_ID INTEGER NOT NULL,
- PRIMARY KEY (CLONING_ID, MARKERS_ID)
-);
-
-CREATE TABLE PUBLIC.CLONING_MARKER_AUD (
- REV INTEGER NOT NULL,
- REVTYPE TINYINT,
- CLONING_ID INTEGER NOT NULL,
- MARKERS_ID INTEGER NOT NULL
-);
-
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.CLASSIFICATION_TAXONNODE_AUD;
CREATE CACHED TABLE PUBLIC.COLLECTION(
ID INTEGER NOT NULL,
MARKERTYPE_ID INTEGER
);
-CREATE TABLE MATERIALANDMETHOD (
+CREATE TABLE MATERIALORMETHODEVENT (
ID INTEGER NOT NULL,
+ DTYPE VARCHAR(255),
CREATED TIMESTAMP,
UUID VARCHAR(36),
UPDATED TIMESTAMP,
- MATERIALMETHODTERM BINARY(255),
MATERIALMETHODTEXT VARCHAR(255),
+ DESCRIPTION VARCHAR(255),
+ TIMEPERIOD_END VARCHAR(255),
+ TIMEPERIOD_FREETEXT VARCHAR(255),
+ TIMEPERIOD_START VARCHAR(255),
+ STRAIN VARCHAR(255),
+ TEMPERATURE DOUBLE,
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
+ MATERIALMETHODTERM_ID INTEGER,
+ ACTOR_ID INTEGER,
+ FORWARDPRIMER_ID INTEGER,
+ REVERSEPRIMER_ID INTEGER,
+ MEDIUM_ID INTEGER,
PRIMARY KEY (ID)
);
-CREATE TABLE MATERIALANDMETHOD_AUD (
+CREATE TABLE MATERIALORMETHODEVENT_AUD (
ID INTEGER NOT NULL,
+ DTYPE VARCHAR(255),
CREATED TIMESTAMP,
UUID VARCHAR(36),
UPDATED TIMESTAMP,
- MATERIALMETHODTERM BINARY(255),
MATERIALMETHODTEXT VARCHAR(255),
+ DESCRIPTION VARCHAR(255),
+ TIMEPERIOD_END VARCHAR(255),
+ TIMEPERIOD_FREETEXT VARCHAR(255),
+ TIMEPERIOD_START VARCHAR(255),
+ STRAIN VARCHAR(255),
+ TEMPERATURE DOUBLE,
CREATEDBY_ID INTEGER,
UPDATEDBY_ID INTEGER,
+ MATERIALMETHODTERM_ID INTEGER,
+ ACTOR_ID INTEGER,
+ FORWARDPRIMER_ID INTEGER,
+ REVERSEPRIMER_ID INTEGER,
+ MEDIUM_ID INTEGER
);
-CREATE TABLE MATERIALANDMETHOD_ANNOTATION (
- MATERIALANDMETHOD_ID INTEGER NOT NULL,
+CREATE TABLE MATERIALORMETHODEVENT_ANNOTATION (
+ MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
ANNOTATIONS_ID INTEGER NOT NULL,
- PRIMARY KEY (MATERIALANDMETHOD_ID, ANNOTATIONS_ID)
+ PRIMARY KEY (MATERIALORMETHODEVENT_ID, ANNOTATIONS_ID)
);
-CREATE TABLE MATERIALANDMETHOD_ANNOTATION_AUD (
+CREATE TABLE MATERIALORMETHODEVENT_ANNOTATION_AUD (
REV INTEGER NOT NULL,
REVTYPE TINYINT,
- MATERIALANDMETHOD_ID INTEGER NOT NULL,
+ MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
ANNOTATIONS_ID INTEGER NOT NULL,
);
-CREATE TABLE MATERIALANDMETHOD_MARKER (
- MATERIALANDMETHOD_ID INTEGER NOT NULL,
+CREATE TABLE MATERIALORMETHODEVENT_MARKER (
+ MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
MARKERS_ID INTEGER NOT NULL,
- PRIMARY KEY (MATERIALANDMETHOD_ID, MARKERS_ID)
+ PRIMARY KEY (MATERIALORMETHODEVENT_ID, MARKERS_ID)
);
-CREATE TABLE MATERIALANDMETHOD_MARKER_AUD (
+CREATE TABLE MATERIALORMETHODEVENT_MARKER_AUD (
REV INTEGER NOT NULL,
REVTYPE TINYINT,
- MATERIALANDMETHOD_ID INTEGER NOT NULL,
+ MATERIALORMETHODEVENT_ID INTEGER NOT NULL,
MARKERS_ID INTEGER NOT NULL,
);
UPDATEDBY_ID INTEGER,
ACTOR_ID INTEGER,
AMPLIFICATION_ID INTEGER,
- MATERIALANDMETHOD_ID INTEGER,
+ MATERIALORMETHOD_ID INTEGER,
PHEROGRAM_ID INTEGER,
PRIMER_ID INTEGER,
PRIMARY KEY (ID)
UPDATEDBY_ID INTEGER,
ACTOR_ID INTEGER,
AMPLIFICATION_ID INTEGER,
- MATERIALANDMETHOD_ID INTEGER,
+ MATERIALORMETHOD_ID INTEGER,
PHEROGRAM_ID INTEGER,
PRIMER_ID INTEGER
);