POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A rock fluid interaction characterized by two mobile phases. One phase is characterized as being the wetting phase, the other is characterized as being the nonwetting phase. Other phases are immobile. Examples of these are oleic-aqueous and vapor-liquid systems.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- rock_fluid_interaction.identifier
The identifier of the fluid-rock system. Often this identifier is constructed from the names of associated fluid bodies and fluid systems.
- 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).
- nonwetting_phase_s (FSK, M: CHAR VARYING(19))
nonwetting_phase_t (M: CHAR VARYING(30))
- two_phase_rock_fl_interact.nonwetting_phase
The fluid phase that behaves as the nonwetting phase in a two phase rock fluid interaction.
nonwetting_phase_s: Implements a foreign key to a row in one of the tables projected from entity fluid_phase depending on the value of the next column (See below).
nonwetting_phase_t: Defines the name of the referenced table. Possible values are defined in @fluid_phase.
- wetting_phase_s (FSK, M: CHAR VARYING(19))
wetting_phase_t (M: CHAR VARYING(30))
- rock_fluid_interaction.wetting_phase
The fluid phase that acts as the wetting phase in the rock fluid interaction (one, two or three phase).
wetting_phase_s: Implements a foreign key to a row in one of the tables projected from entity fluid_phase depending on the value of the next column (See below).
wetting_phase_t: Defines the name of the referenced table. Possible values are defined in @fluid_phase.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- immobile_saturation (O: FLOAT(6))
- two_phase_rock_fl_interact.immobile_saturation
The saturation value of an immobile third phase that may be present in a two phase fluid rock system. This value is constant for the system.
- 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".
- immobile_phase_s (FSK, O: CHAR VARYING(19))
immobile_phase_t (O: CHAR VARYING(30))
- two_phase_rock_fl_interact.immobile_phase
The fluid phase that behaves as the immobile phase in a two phase rock fluid interaction.
immobile_phase_s: Implements a foreign key to a row in one of the tables projected from entity fluid_phase depending on the value of the next column (See below).
immobile_phase_t: Defines the name of the referenced table. Possible values are defined in @fluid_phase.
Table is related to: capillary_pressure_curve, capillary_pressure_point, data_collection_content, derived_interest_makeup, document_specification_part, fluid_interaction_material, @graphical_element, object_activity_involvement, rock_fluid_characterization, two_phase_rel_perm_curve, two_phase_rel_perm_point
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 17:08:25 2001
© Copyright 2001 POSC. All rights reserved.