POSC Specifications: Epicentre Version 3.0 Relational Implementation

CREATE TABLE FLUID_PHASE_VAPOR_PVT
(
ACTIVITY_SCHAR VARYING (19) REFERENCES ACTIVITY (INSTANCE_S),
COMPRESSIBILITYFLOAT,
COMPRESSIBILITY_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
DENSITYFLOAT,
DENSITY_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
DESCRIPTIONCHAR VARYING (2000),
DEW_POINTFLOAT,
DEW_POINT_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
FLUID_PHASE_VAPOR_SCHAR VARYING (19) NOT NULL REFERENCES SPECIFIC_FLUID_PHASE (INSTANCE_S),
FLUID_PROPERTY_SET_SCHAR VARYING (19) REFERENCES FLUID_PROPERTY_SET (INSTANCE_S),
FORMATION_VOLUME_FACTORFLOAT,
FORMATION_VOLUME_FACTOR_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
GAS_PSEUDO_PRESSUREFLOAT,
GAS_PSEUDO_PRESSURE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
INSTANCE_CREATE_DATETIMESTAMP ,
INSTANCE_CREATORCHAR VARYING (80),
INSTANCE_SCHAR VARYING (19) NOT NULL PRIMARY KEY,
LAST_UPDATEDTIMESTAMP ,
LAST_UPDATED_BYCHAR VARYING (80),
MOLAR_DENSITYFLOAT,
MOLAR_DENSITY_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
PRESSUREFLOAT,
PRESSURE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
PSEUDOREDUCED_COMPRESSIBILITYFLOAT (6),
PSEUDOREDUCED_PRESSUREFLOAT (6),
PSEUDOREDUCED_TEMPERATUREFLOAT (6),
SHRINKAGE_FACTORFLOAT,
SHRINKAGE_FACTOR_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
SOURCECHAR VARYING (80),
SPECIFIC_MOLAR_VOLUMEFLOAT,
SPECIFIC_MOLAR_VOLUME_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
SPECIFIC_VOLUMEFLOAT,
SPECIFIC_VOLUME_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
TEMPERATUREFLOAT,
TEMPERATURE_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
VISCOSITYFLOAT,
VISCOSITY_KINEMATICFLOAT,
VISCOSITY_KINEMATIC_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
VISCOSITY_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
VISCOUS_COMPRESSIBILITYFLOAT,
VISCOUS_COMPRESSIBILITY_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
VOLATILE_OIL_GAS_RATIOFLOAT,
VOLATILE_OIL_GAS_RATIO_UCHAR VARYING (15) REFERENCES R_UNIT_OF_MEASURE (ACRONYM),
Z_FACTORFLOAT (6)
)


Generated on Tue Jul 10 19:40:24 2001
© Copyright 2001 POSC. All rights reserved.