POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A rock fluid interaction characterized by three mobile phases. One phase is characterized as being the wetting phase, a second phase is characterized as being the nonwetting phase, and the third phase is characterized as an intermediate wetting phase. The gaseous-oleic-aqueous system is an example of this rock fluid interaction.
- 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).
- intermediate_phase_s (FSK, M: CHAR VARYING(19))
intermediate_phase_t (M: CHAR VARYING(30))
- three_phase_rock_fl_interact.intermediate_phase
The fluid phase that behaves as the intermediate wetting phase in a three phase rock fluid interaction.
intermediate_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).
intermediate_phase_t: Defines the name of the referenced table. Possible values are defined in @fluid_phase.
- nonwetting_phase_s (FSK, M: CHAR VARYING(19))
nonwetting_phase_t (M: CHAR VARYING(30))
- three_phase_rock_fl_interact.nonwetting_phase
The fluid phase that behaves as the nonwetting phase in a three 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.
- 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".
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, three_phase_rel_perm_curve, three_phase_rel_perm_point
Primary Key Constraint on: INSTANCE_S
Fully implemented Unique Constraint on: IDENTIFIER, WETTING_PHASE_S, WETTING_PHASE_T, INTERMEDIATE_PHASE_S, INTERMEDIATE_PHASE_T, NONWETTING_PHASE_S, NONWETTING_PHASE_T
Generated on Tue Jul 10 17:06:21 2001
© Copyright 2001 POSC. All rights reserved.