Asserts that the existence of a geologic feature or rock material is being declared within the context of a wellbore
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).
wellbore_s (FSK, M: CHAR VARYING(19))
wellbore_pick.wellbore
The wellbore in which a pick is being made.
Defines a foreign key to table wellbore.
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
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.
missing (O: CHAR(1))
interpreted_feature.missing
TRUE asserts that the feature is missing within the specified context. UNKNOWN asserts that the status is not known (i.e., it could be missing or present). FALSE or not specified asserts that the feature is present in the context.
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".
geologic_feature_s (FSK, O: CHAR VARYING(19))
interpreted_feature.geologic_feature
The geologic feature which is being interpreted within the specified context.
Defines a foreign key to table geologic_feature.
rock_material_s (FSK, O: CHAR VARYING(19))
interpreted_feature.rock_material
The rock material which is being interpreted within the specified context.
Defines a foreign key to table bulk_material.
wellbore_interval_s (FSK, O: CHAR VARYING(19))
wellbore_pick.wellbore_interval
This is an interesting named interval in the wellbore where the existence of the feature or material is being asserted. The location(s) of the interval represents the location of the feature or material. That is, the location of the feature or material moves with different interpretations of the location of the interval.
Defines a foreign key to table wellbore_interval.
wellbore_point_s (FSK, O: CHAR VARYING(19))
wellbore_pick.wellbore_point
This is an interesting named point in the wellbore where the existence of the feature or material is being asserted. The location(s) of the point represents the location of the feature or material. That is, the location of the feature or material moves with different interpretations of the location of the point.
Defines a foreign key to table wellbore_point.