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).
general_coordinate_system.origin_location
This is the location of the origin of the coordinate system when the location does not represent a known object. origin_location_1_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure. origin_location_cs_s: Defines the coordinate system of the coordinate value(s). Defines a foreign key to table coordinate_system.
coordinate_system.ref_coordinate_sys_constraint
The type of the coordinate system. This type specifies the number, order and kinds of axes that must be defined for this coordinate system. For example, a coordinate system of geographical 2D must have two axes of latitude and longitude in order.
Defines a foreign key to table r_coordinate_sys_constraint.
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.
origin_location_2_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure. origin_location_3_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure. origin_location_4_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure. origin_location_5_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure. origin_location_o_s: Defines the origin of the coordinate value(s). Defines a foreign key to table spatial_object.
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".
source_content (O: CHAR VARYING(80))
technical_reference.source_content
This is the original source of the data. This is the person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc. This may be the same as or different from the provider of the instance (e.g., POSC).
source_reference (O: CHAR VARYING(2000))
technical_reference.source_reference
The reference used by source to provide the standard instance, such as Petroleum Industry Data Dictionary (PIDD), Websters Ninth New Collegiate Dictionary, etc.
status (O: CHAR VARYING(11))
technical_reference.status
The status of this instance in the version of Epicentre running in a data store. This is an enumerated datatype for which the following are the possible values: current, provisional, deprecated. Current - use without restriction. Provisional - use with caution, this value is for comment and may not appear in future releases of Epicentre. Deprecated - avoid use if possible, it is planned to remove this value in the next major release of Epicentre.
first_system_s (FSK, O: CHAR VARYING(19))
compound_coordinate_system.first_system
This is the first coordinate system in the compound system. For well formed geodetic systems this will normally be a horizontal 2D system.
Defines a foreign key to table coordinate_system.
geodetic_datum_s (FSK, O: CHAR VARYING(19))
geocentric_coordinate_system.geodetic_datum
This describes the geodetic datum that is the basis of this geocentric coordinate system. geographic_2d_coord_system.geodetic_datum
This is the geodetic datum that this geographic coordinate system is based upon. This defines the surface upon which the coordinate values in this coordinate system are expressed. geographic_3d_coord_system.geodetic_datum
This is the geodetic datum that this geographic coordinate system is based upon. This defines the surface upon which the coordinate values in this coordinate system are expressed.
Defines a foreign key to table geodetic_datum.
geographic_3d_coord_system.geographic_2d_coord_system
This is the 2D geographic which was derived from this system by dropping the vertical axis. The standard identifiers for geographic systems should be loaded in the 2d system with the inverse of this relationship used to locate the related 3d system.
Defines a foreign key to table coordinate_system.
general_coordinate_system.local_context
The topological object which provides the context for this coordinate system. For parameterized coordinate systems (e.g., measured depth), this will be the object which is being parameterized (e.g., the Wellbore). local_context_s: Implements a foreign key to a row in one of the tables projected from entity topological_object depending on the value of the next column (See below). local_context_t: Defines the name of the referenced table. Possible values are defined in @topological_object.
aliasable_technical_reference.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_display_orientation (FNK, O: CHAR VARYING(80))
general_coordinate_system.ref_display_orientation
This describes the default location of the origin that may be used when displaying information using this local coordinate system.
Defines a foreign key to table r_display_orientation.
second_system_s (FSK, O: CHAR VARYING(19))
compound_coordinate_system.second_system
This is the second coordinate system in the compound system. For well formed geodetic systems this will normally be a vertical 1D system.
Defines a foreign key to table coordinate_system.
projected_2d_coordinate_system.source_geodetic_system
This is the related geographic system. The datum for the projected system is the same as for the geographic system. The only transformation between this projected system and a geographic system will be to/from the source geodetic system.
Defines a foreign key to table coordinate_system.
spatial_reference_s (FSK, O: CHAR VARYING(19))
general_coordinate_system.spatial_reference
Indicates the usage of a spatial object as the reference origin or (local, engineering, etc) datum for the coordinate system. For example, a vertex representation of a kelly bushing used as the origin of a measured depth system or a face representation of a geologic feature used as the datum of an isopach system.
Defines a foreign key to table spatial_object.
version_s (FSK, O: CHAR VARYING(19))
technical_reference.version
This describes the version of this instance as defined by the provider.
Defines a foreign key to table r_version.