POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A document specification depicting measured or derived properties of the environment, within, along, or surrounding a length of an actual or typical borehole of a well or other earth surface feature, such as a field or geologic province.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- identifier (M: CHAR VARYING(80))
- document_specification.identifier
The label by which a document specification is identified, such as a title.
- 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.
- document_date (O: DATE)
- document_specification.document_date
This is the date this document specification was created. Note: this is not necessarily the date it was loaded into the data store.
- 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".
- earth_feature_s (FSK, O: CHAR VARYING(19))
earth_feature_t (O: CHAR VARYING(30))
- well_log.earth_feature
The earth feature that is characterized by the well log trace data contained in this well log.
earth_feature_s: Implements a foreign key to a row in one of the tables projected from entity earth_feature depending on the value of the next column (See below).
earth_feature_t: Defines the name of the referenced table. Possible values are defined in @earth_feature.
- kind_s (FSK, O: CHAR VARYING(19))
- document_specification.kind
The class which asserts the fundamental nature of the specification.
Defines a foreign key to table document_specification_class.
- naming_system (FNK, O: CHAR VARYING(80))
- document_specification.naming_system
The naming system in which the identifier is specified and determined to be unique.
Defines a foreign key to table naming_system.
- r_well_log_process_state (FNK, O: CHAR VARYING(80))
- well_log.ref_well_log_process_state
The level of analytical processing which represents a common characteristic of a set of well log traces.
Defines a foreign key to table r_well_log_process_state.
- wellbore_s (FSK, O: CHAR VARYING(19))
- well_log.wellbore
Indicates the wellbore which is being depicted by the well log.
Defines a foreign key to table wellbore.
Table is related to: contract_object_designation, contract_oblig_object_fulfil, data_collection, data_collection_content, derived_interest_makeup, document, document_specification_part, document_specification_alias, document_specification_clsn, document_spec_business_assoc, @graphical_element, guideline_compliance, object_activity_involvement, object_remark, object_subject_to_guideline, subject_of_contract
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 17:14:49 2001
© Copyright 2001 POSC. All rights reserved.