POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
CREATE TABLE P_SOURCE_START_TIME
(
ACTIVITY_S | CHAR VARYING (19) | REFERENCES ACTIVITY (INSTANCE_S), |
DATA_VALUE_SL | CHAR VARYING (16) | , |
DESCRIPTION | CHAR VARYING (2000) | , |
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) | , |
ORIGIN_TIME | TIMESTAMP | , |
ORIGIN_TIME_CD | CHAR (1) | , |
ORIGIN_TIME_DY | INTEGER | , |
ORIGIN_TIME_HR | INTEGER | , |
ORIGIN_TIME_MT | INTEGER | , |
ORIGIN_TIME_OF | FLOAT | , |
ORIGIN_TIME_ST | FLOAT | , |
ORIGIN_TIME_YP | INTEGER | , |
ORIGIN_TIME_YR | FLOAT | , |
PREFERRED_FLAG | CHAR (1) | , |
REPRESENT_S | CHAR VARYING (19) | , |
REPRESENT_T | CHAR VARYING (30) | , |
SEISMIC_GEOMETRY_SET_S | CHAR VARYING (19) | REFERENCES GEOPHYSICAL_GEOMETRY_SET (INSTANCE_S), |
SOURCE | CHAR VARYING (80) |