| POSC Specifications Version 2.2 |
Epicentre Relational Implementation |
An interval of the Earth over which mineral rights are granted. The mineral zone is defined by a top marker or depth and a bottom marker or depth. Exclusions are not defined within a mineral zone, so that an exclusion must be described by splitting the original mineral zone into several mineral zones and defining mineral rights accordingly. A definition of the top and base of the mineral zone must be provided.
- mineral_zone_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- mineral_zone_id (M: CHAR VARYING(40))
- mineral_zone.identifier
The identifier of the mineral zone.
- base_depth_1_o (O: FLOAT)
base_depth_1_ou (FNK, O: CHAR VARYING(15))
base_depth_o_s (FSK, O: CHAR VARYING(19))
base_depth_o_t (O: CHAR VARYING(16))
base_depth_cs (FNK, O: CHAR VARYING(40))
- mineral_zone.base_depth
The depth to the base of the mineral zone. The meaning of the depth (measured or true vertical) and the reference from which it is defined (i.e., below KB, GL, etc.) is carried by the related coordinate system.
base_depth_1_ou: Defines the unit of measure. Defines a foreign key to table r_uom.
base_depth_o_s: Defines the origin of the coordinate value(s).Implements a foreign key to a row in one of the tables projected from entity vertex depending on the value of the next column (See below).
base_depth_o_t: Defines the name of the referenced table. Possible values are: .
base_depth_cs: Defines the coordinate system of the coordinate value(s). Defines a foreign key to table coordinate_sys.
- description (O: CHAR VARYING(2000))
- mineral_zone.description
A description of the mineral zone.
- top_depth_1_o (O: FLOAT)
top_depth_1_ou (FNK, O: CHAR VARYING(15))
top_depth_o_s (FSK, O: CHAR VARYING(19))
top_depth_o_t (O: CHAR VARYING(16))
top_depth_cs (FNK, O: CHAR VARYING(40))
- mineral_zone.top_depth
The depth to the top of the mineral zone. The meaning of the depth (measured or true vertical) and the reference from which it is defined (i.e., mean sea level) is carried by the related coordinate system.
top_depth_1_ou: Defines the unit of measure. Defines a foreign key to table r_uom.
top_depth_o_s: Defines the origin of the coordinate value(s).Implements a foreign key to a row in one of the tables projected from entity vertex depending on the value of the next column (See below).
top_depth_o_t: Defines the name of the referenced table. Possible values are: .
top_depth_cs: Defines the coordinate system of the coordinate value(s). Defines a foreign key to table coordinate_sys.
- base_marker_s (FSK, O: CHAR VARYING(19))
- mineral_zone.base_marker
The stratigraphic marker (such as the top or base of a formation) that defines the base of a mineral zone.
Defines a foreign key to table strat_mrk.
- top_marker_s (FSK, O: CHAR VARYING(19))
- mineral_zone.top_marker
The stratigraphic marker (such as defines the top or base of a formation) that defines the top of a mineral zone.
Defines a foreign key to table strat_mrk.
Table is related to: dae_frame, derv_int_mkup, @graphical_element, gdln_priv_com, land_pty_vol, object_ranking, parameter_value, well_completion
Intersection Tables: subj_of_ctrt_x, ctrt_obl_obj_x, ctrt_dsgn_obj_x, coll_cntn_x, business_obj_x
Primary Key Constraint on: MINERAL_ZONE_S
Fully implemented Unique Constraint on: MINERAL_ZONE_ID
Generated on Mon Dec 1 10:18:51 1997
© Copyright 1997 POSC. All rights reserved.