| Name | MicroSeismic_Stage_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. The MicroSeismic Pumping Stage DOV. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Borehole_Id | ID | No_Unit |
Borehole Id associated with the event. | No |
NUMBER(38) |
| Borehole_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) |
| End_Date | DATE | NA |
The date and time at which the activity will end or did end. | Yes |
DATE |
| End_MD | double | Standard_Depth_Index m |
Measured depth at the end of the activity or proposed depth end of the activity. | Yes |
NUMBER |
| 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) |
| Remarks | REMARKS_STR | NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(999) |
| Source | STRING64 | NA |
Name of the person or organization responsible for this entity"s 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) |
| Start_Date | DATE | NA |
The date and time at which the activity will start or did start. | Yes |
DATE |
| Start_MD | double | Standard_Depth_Index m |
Measured depth at the start of the activity or proposed start depth of the activity. | Yes |
NUMBER |
| UBHI | WELL_IDENTIFIER | NA |
The Unique Identifier assigned to a borehole | Yes |
VARCHAR2(64) |
| Update_Date | DATE | NA |
_ | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the updation of this entity in the repository. | No |
VARCHAR2(64) |
CREATE OR REPLACE FORCE VIEW MicroSeismic_Stage_DOV(ID, UBHI, BOREHOLE_NAME, START_DATE, END_DATE, START_MD, END_MD, SOURCE, REMARKS, UPDATE_DATE, UPDATE_USER, INSERT_DATE, INSERT_USER, BOREHOLE_ID) AS SELECT ts.Id Id, bh.UBHI UBHI, bh.Name Borehole_Name, ts.start_date Start_Date, ts.end_date End_Date, ts.start_md Start_MD, ts.end_md End_MD, ts.Source Source, ts.Remarks Remarks, ts.Update_Date Update_Date, ts.Update_User Update_User, ts.Insert_Date Insert_Date, ts.Insert_User Insert_User, bh.Id Borehole_Id FROM Borehole bh, Treatment_Stage ts WHERE ts.Borehole_Id = bh.Id |