POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
CREATE TABLE GEOLOGIC_PROVINCE_AGE_CLSN
(
DESCRIPTION | CHAR VARYING (2000) | , |
GEOLOGIC_PROVINCE_S | CHAR VARYING (19) | NOT NULL REFERENCES GEOLOGIC_PROVINCE (INSTANCE_S), |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
SOURCE | CHAR VARYING (80) | , |
SOURCE_CONTENT | CHAR VARYING (80) | , |
SOURCE_REFERENCE | CHAR VARYING (2000) | , |
STATUS | CHAR VARYING (11) | , |
TEMPORAL_OBJECT_S | CHAR VARYING (19) | NOT NULL, |
TEMPORAL_OBJECT_T | CHAR VARYING (30) | NOT NULL, |
VERSION_S | CHAR VARYING (19) | REFERENCES R_VERSION (INSTANCE_S) |