| Name | Borehole_Zone |
|---|---|
| Entity Type | Table |
| Description | An interval in a borehole. Note, the top point and the base point that define the zone MUST exist in the same borehole. |
| Submodel | Well_Marker |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | Zone_Top_Id , Zone_Base_Id , Geologic_Layer_Id , Borehole_Diameter , Name , Source , Existence_Kind , Version |
| Generalizations | Entity , IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Adjusted_Thickness | double | Length m |
Adjusted thickness | No |
NUMBER |
| Borehole_Diameter | double | Cylinder_Diameter mm |
The diameter of the borehole. | No |
NUMBER |
| Borehole_Zone_Set_Id | Borehole_Zone_Set |
|
A borehole zone set to which the borehole zone belongs. A borehole zone set is collection of zones that subscribe to a common definition. | No |
NUMBER(38) |
| Borehole_Zone_Type | R_Borehole_Zone |
|
The type of borehole zone. | No |
VARCHAR2(64) |
| Cored_Flag | boolean | Flag |
Has this interval been cored? | No |
NUMBER(1) |
| Default_Color | COLOR_RGB | NA |
Default color to be used when rendering this borehole zone. | No |
VARCHAR2(64) |
| Existence_Kind | REF_EXISTENCE_KIND | NA |
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. | Yes Actual |
VARCHAR2(64) |
| GUID | STRING128 | NA |
Globally Unique IDentifier for an instance of a class. USAGE NOTES: There are two cases: 1) GUID is not populated or used; and 2) it is populated with a value that is globally unique. If the GUID is populated there are two means of doing so for a given project: 2a) Seabed automatically generates and populates the GUID when an instance is created (valid only on Oracle based systems); and 2b) the GUID is generated and populated by an application (other than Seabed) on instance creation. Whether Seabed automatically generates GUIDs for a project is determined by the Auto_GUID flag in SDS_Account. Note that techniques 2a and 2b can coexist in the same project. When GUIDs are automatically generated an application can override the automatically generated GUID with its own GUID by simply supplying the GUID value. Applications that generate their own GUIDs and populate the GUID column will function correctly on projects which have automatic GUID generation turned on. | No |
VARCHAR2(128) |
| Geologic_Layer_Id | Geologic_Layer |
|
Geologic layer which is intersected by the borehole across this borehole zone. | No |
NUMBER(38) |
| Id | ID | No_Unit |
Unique identifier for this entity. | Yes |
NUMBER(38) |
| Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| Name | ENTITY_NAME | NA |
The name given to any object or data item, e.g. name of Well, name of Field, etc. | No |
VARCHAR2(255) |
| Original_Source | STRING64 | NA |
The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15" | No |
VARCHAR2(64) |
| Parent_Zone_Id | Borehole_Zone |
|
Defines the parent interval the current zone is contained in. | No |
NUMBER(38) |
| Primary_Lithology | R_Lithology |
|
A value that represents the predominant lithology of the borehole zone. Examples include Sandstone, Shale, Limestone. | No |
VARCHAR2(64) |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| Remarks | STRING2000 | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(2000) |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Source | STRING64 | NA |
Name of the person or organization responsible for this entitys E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User. | No |
VARCHAR2(64) |
| Tested_Flag | boolean | Flag |
Has this interval been tested | No |
NUMBER(1) |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| Version | STRING255 | NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| Zone_Base_Id | Borehole_Point |
|
The point, measured along the borehole, that intersects the base of a zone. | Yes |
NUMBER(38) |
| Zone_Exception | R_Stratigraphic_Exception |
|
This may indicate that part of the layer intersecting the borehole has been eroded, so an extra, projected marker may be set where the projected feature would have intersected the borehole. | No |
VARCHAR2(64) |
| Zone_Penetration | R_Zone_Penetration |
|
The manner in which the zone was penetrated, Inverted means the layer is penetrated from bottom to top, either due to the wellbore or layer geometry, or both. Bottom means both entry points are the base of the layer; Top means both entry points are the top. | No |
VARCHAR2(64) |
| Zone_Top_Id | Borehole_Point |
|
The point, measured along the borehole, that intersects the top of a zone. | Yes |
NUMBER(38) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Aquifer_Pty_Set | Aquifer_Zone | The zone, from top to bottom, that defines the limits of the aquifer in this borehole. | Cascade | Yes |
| Borehole_Activity | Borehole_Zone | The borehole zone associated with the borehole activity. | Assoc to Many | No |
| Borehole_Zone | Parent_Zone | Defines the parent interval the current zone is contained in. | Nullify | No |
| Correlate_Missing_Section | Missing_Section | A borehole zone is correlated to a borehole point where the expected interval is missing. | Cascade | Yes |
| Correlate_Zone | Initial_Zone | Two separate borehole zones can be correlated by entering both an initial and a correlated borehole zone. The association is commutative so ordering is irrelevant(if Borehole Zone A is correlated to Borehole Zone B, then Borehole Zone B is correlated to Borehole Zone A). | Cascade | Yes |
| Correlate_Zone | Correlated_Zone | Two separate borehole zones can be correlated by entering both an initial and a correlated borehole zone. The association is commutative so ordering is irrelevant(if Borehole Zone A is correlated to Borehole Zone B, then Borehole Zone B is correlated to Borehole Zone A). | Cascade | Yes |
| Leak_Off_Test | Formation | The formation that is being tested by the LOT | Nullify | No |
| Reservoir_Zone_Pty_Set | Reservoir_Zone | The zone, from top to bottom, that defines the limits of the reservoir properties in this borehole. | Cascade | Yes |
| Rock_Mechanical_Pty_Set | Mechanical_Zone | The zone, from top to bottom, that defines the limits of the mechanical properties in this borehole. | Cascade | Yes |
| Rock_Pty_Set | Rock_Pty_Zone | The zone, from top to bottom, that defines the limits of the general properties in this borehole. | Cascade | Yes |
| Study_Borehole_Zone | Borehole_Zone | The identifier of a borehole zone that is an element of the study. | Nullify | No |
| Zone_Parameter | Borehole_Zone | The borehole zone for which the parameter is defined. | Cascade | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Zone_Top | Borehole_Point | The point, measured along the borehole, that intersects the top of a zone. | Cascade | Yes |
| Zone_Penetration | R_Zone_Penetration | The manner in which the zone was penetrated, Inverted means the layer is penetrated from bottom to top, either due to the wellbore or layer geometry, or both. Bottom means both entry points are the base of the layer; Top means both entry points are the top. | Restrict | No |
| Zone_Exception | R_Stratigraphic_Exception | This may indicate that part of the layer intersecting the borehole has been eroded, so an extra, projected marker may be set where the projected feature would have intersected the borehole. | Restrict | No |
| Zone_Base | Borehole_Point | The point, measured along the borehole, that intersects the base of a zone. | Cascade | Yes |
| Borehole_Zone_Set | Borehole_Zone_Set | A borehole zone set to which the borehole zone belongs. A borehole zone set is collection of zones that subscribe to a common definition. | Cascade | No |
| Parent_Zone | Borehole_Zone | Defines the parent interval the current zone is contained in. | Nullify | No |
| Primary_Lithology | R_Lithology | A value that represents the predominant lithology of the borehole zone. Examples include Sandstone, Shale, Limestone. | Restrict | No |
| Geologic_Layer | Geologic_Layer | Geologic layer which is intersected by the borehole across this borehole zone. | Restrict | No |
| Borehole_Zone_Type | R_Borehole_Zone | The type of borehole zone. | Restrict | No |