POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
This describes the orientation of a geologic feature intersected by this wellbore. This orientation is described with respect to vertical and north, not relative to the axis of the wellbore. The geologic feature is defined by the wellbore pick.
- 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).
- azimuth (O: FLOAT)
azimuth_u (FNK, O: CHAR VARYING(15))
- pty_geologic_feature_orient.azimuth
This is the azimuth of a geologic at this pick in this wellbore . This azimuth is measured in the horizontal plane from north. When provided, the attribute ref north axis direction defines the type of north used.
azimuth_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- inclination_from_horizontal (O: FLOAT)
inclination_from_horizontal_u (FNK, O: CHAR VARYING(15))
- pty_geologic_feature_orient.inclination_from_horizontal
This describes the inclination of the geologic feature at this pick where it is intersected by this wellbore.
inclination_from_horizontal_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- 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))
- property.preferred_flag
The flag is set to True if this instance of property is the preferred value in this data store of this type of property for the object which this property describes.
- 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.
- r_north_axis_direction (FNK, O: CHAR VARYING(80))
- pty_geologic_feature_orient.ref_north_axis_direction
This describes the type of north used for the azimuth. Possible values include true north, magnetic north, and local grid north.
Defines a foreign key to table r_north_axis_direction.
- represent_s (FSK, O: CHAR VARYING(19))
represent_t (O: CHAR VARYING(30))
- property.represent
This is the property that is the original for which this representation is an equivalent representation.
represent_s: Implements a foreign key to a row in one of the tables projected from entity property depending on the value of the next column (See below).
represent_t: Defines the name of the referenced table. Possible values are defined in @property.
- wellbore_pick_s (FSK, O: CHAR VARYING(19))
- pty_geologic_feature_orient.wellbore_pick
This is the wellbore pick that is the intersection of the geologic feature and the wellbore. Both the wellbore and the geologic feature are defined by this pick.
Defines a foreign key to table wellbore_pick.
Table is related to: data_collection_content, document_specification_part, @graphical_element, process_data_item, @property
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 17:58:50 2001
© Copyright 2001 POSC. All rights reserved.