POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
CREATE TABLE FLUID_CARGO
(
CONTAINING_FACILITY_S | CHAR VARYING (19) | REFERENCES GENERAL_FACILITY (INSTANCE_S), |
DESCRIPTION | CHAR VARYING (2000) | , |
END_DATE | TIMESTAMP | , |
END_DATE_CD | CHAR (1) | , |
END_DATE_DY | INTEGER | , |
END_DATE_HR | INTEGER | , |
END_DATE_MT | INTEGER | , |
END_DATE_OF | FLOAT | , |
END_DATE_ST | FLOAT | , |
END_DATE_YP | INTEGER | , |
END_DATE_YR | FLOAT | , |
FLUID_COMPONENT_S | CHAR VARYING (19) | NOT NULL, |
FLUID_COMPONENT_T | CHAR VARYING (30) | NOT NULL, |
IDENTIFIER | CHAR VARYING (80) | NOT NULL, |
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) | , |
PFNU_CARGO_CONNECTION_S | CHAR VARYING (19) | REFERENCES PFNU_EXTERNAL_CONNECTION (INSTANCE_S), |
SOURCE | CHAR VARYING (80) | , |
START_DATE | TIMESTAMP | , |
START_DATE_CD | CHAR (1) | , |
START_DATE_DY | INTEGER | , |
START_DATE_HR | INTEGER | , |
START_DATE_MT | INTEGER | , |
START_DATE_OF | FLOAT | , |
START_DATE_ST | FLOAT | , |
START_DATE_YP | INTEGER | , |
START_DATE_YR | FLOAT |