POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
This defines a set of fluid phase properties. These include data for aqueous, oleic and vapor phases. This set of properties is unordered and each property in the set should be defined with a pressure and temperature, with bubble point pressures for oleic phases and dew point pressures for vapor phases.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- instance_create_date (O: TIMESTAMP)
- e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
- last_updated (O: TIMESTAMP)
- e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
- fluid_system_s (FSK, M: CHAR VARYING(19))
- fluid_property_set.fluid_system
This is the fluid system for which this set of fluid properties is defined.
Defines a foreign key to table bulk_material.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- instance_creator (O: CHAR VARYING(80))
- e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
- last_updated_by (O: CHAR VARYING(80))
- e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
- preferred_flag (O: CHAR(1))
- fluid_property_set.preferred_flag
The flag is set to True if this instance of fluid property set is the preferred set for the designated fluid system. Only one fluid property set should be preferred for each fluid system.
- source (O: CHAR VARYING(80))
- e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
- activity_s (FSK, O: CHAR VARYING(19))
- process_data.activity
Defines the activity which created this instance.
Defines a foreign key to table activity.
Table is related to: data_collection_content, document_specification_part, fluid_phase_aqueous_pvt, fluid_phase_oleic_pvt, fluid_phase_vapor_pvt, @graphical_element, process_data_item
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:26:51 2001
© Copyright 2001 POSC. All rights reserved.