| Name | Dataset_Boundary_Shape |
|---|---|
| Entity Type | ObjectView |
| Description | Dataset_Boundary_Shape Object View |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| EXISTENCE_KIND | REF_EXISTENCE_KIND | NA |
_ | Yes |
VARCHAR2(64) |
| GUID | STRING128 | NA |
_ | No |
VARCHAR2(128) |
| ID | ID | NA |
_ | Yes |
NUMBER(38) |
| INSERT_DATE | DATE | NA |
_ | No |
DATE |
| INSERT_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| ORIGINAL_SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| POLYGON_GEOMETRY_ID | NUMBER | NA |
_ | No |
NUMBER |
| PRODUCED_BY | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| REMARKS | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| SDAT_LABEL | NUMBER | No_Unit |
_ | No |
NUMBER |
| SEISMIC_DATASET_ID | NUMBER | NA |
_ | No |
NUMBER |
| SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| SUB_TYPE | STRING32 | NA |
_ | No |
VARCHAR2(32) |
| Shape | GEOMETRY | NA |
_ | No |
ST_GEOMETRY |
| UPDATE_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| VERSION | STRING255 | NA |
_ | Yes |
VARCHAR2(255) |
CREATE OR REPLACE FORCE VIEW Dataset_Boundary_Shape(INSERT_DATE, INSERT_USER, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, EXISTENCE_KIND, GUID, ID, VERSION, NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, POLYGON_GEOMETRY_ID, SUB_TYPE, SEISMIC_DATASET_ID, SHAPE) AS SELECT DATASET_BOUNDARY.insert_date,
DATASET_BOUNDARY.insert_user,
DATASET_BOUNDARY.produced_by,
DATASET_BOUNDARY.sdat_label,
DATASET_BOUNDARY.update_date,
DATASET_BOUNDARY.update_user,
DATASET_BOUNDARY.existence_kind, dataset_boundary.guid,
DATASET_BOUNDARY.ID,
DATASET_BOUNDARY.VERSION,
DATASET_BOUNDARY.NAME,
DATASET_BOUNDARY.original_source,
DATASET_BOUNDARY.remarks,
DATASET_BOUNDARY.SOURCE,
DATASET_BOUNDARY.polygon_geometry_id,
DATASET_BOUNDARY.sub_type,
DATASET_BOUNDARY.seismic_dataset_id,
AREA.shape
FROM DATASET_BOUNDARY, AREA
WHERE
DATASET_BOUNDARY.polygon_geometry_id = AREA.ID
|