A liquid fluid phase in which the dominant continuous materials are liquid hydrocarbons. This phase is often called the "oil phase".
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
identifier (M: CHAR VARYING(80))
specific_fluid_phase.identifier
The name of the fluid phase, which may be used to distinguish between phases of the same kind, such as two aqueous or surfactant phases.
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).
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.
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".
fluid_system_s (FSK, O: CHAR VARYING(19))
specific_fluid_phase.fluid_system
This is the fluid system from which these fluid phases have evolved. The characteristics of all fluid phases together (i.e., total density) are defined in the fluid system.
Defines a foreign key to table bulk_material.
fluid_system_state_s (FSK, O: CHAR VARYING(19))
specific_fluid_phase.fluid_system_state
This defines the environmental conditions (pressure, temperature, etc.) that were used to define this fluid phase.
Defines a foreign key to table fluid_system_state.