POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
CREATE TABLE FLUID_SYSTEM_STATE
(
DESCRIPTION | CHAR VARYING (2000) | , |
EQUILIBRIUM | CHAR (1) | , |
FLUID_SYSTEM_S | CHAR VARYING (19) | NOT NULL REFERENCES BULK_MATERIAL (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) | , |
PRESSURE | FLOAT | , |
PRESSURE_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM), |
SOURCE | CHAR VARYING (80) | , |
TEMPERATURE | FLOAT | , |
TEMPERATURE_U | CHAR VARYING (15) | REFERENCES R_UNIT_OF_MEASURE (ACRONYM) |