| Name | Well_Remark_DOV |
|---|---|
| Entity Type | ObjectView |
| Description | Data Object View. The Well Remark DOV contains any general comments concerning a well. |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Effective_Date | DATE | NA |
The effective date for the remark made about the well | Yes |
DATE |
| End_Date | DATE | NA |
The End Date for the remark made about the well | No |
DATE |
| 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) |
| Remark | STRING2000 | NA |
A remark made about a well | Yes |
VARCHAR2(2000) |
| Remark_Type | STRING64 | NA |
The type of Well Remark | No |
VARCHAR2(64) |
| Sequence_Number | int | NA |
A sequence number to provide an order to the remarks | Yes 1 |
NUMBER(10) |
| UWI | WELL_IDENTIFIER | NA |
Unique Well Identifier | Yes |
VARCHAR2(64) |
| Well_Id | Well |
|
READ ONLY: Unique identifier for the well. | No |
NUMBER(38) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Well | Well | READ ONLY: Unique identifier for the well. | Cascade | No |
CREATE OR REPLACE FORCE VIEW Well_Remark_DOV(ID, UWI, SEQUENCE_NUMBER, EFFECTIVE_DATE, END_DATE, REMARK_TYPE, REMARK, INSERT_DATE, INSERT_USER, WELL_ID) AS SELECT wr.Id Id, w.UWI UWI, wr.Sequence_Number Sequence_Number, wr.Effective_Date Effective_Date, wr.End_Date End_Date, wr.remark_type Remark_Type, wr.Remark Remark, wr.Insert_Date Insert_Date, wr.Insert_User Insert_User, w.Id Well_Id FROM Well w, Well_Remark wr WHERE w.Id = wr.Well_Id |