| Name | Live_Trace_Boundary_Shape |
|---|---|
| Entity Type | ObjectView |
| Description | Live_Trace_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_LIVE_TRACE_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 Live_Trace_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_LIVE_TRACE_ID, SHAPE) AS SELECT LIVE_TRACE_BOUNDARY.insert_date,
LIVE_TRACE_BOUNDARY.insert_user,
LIVE_TRACE_BOUNDARY.produced_by,
LIVE_TRACE_BOUNDARY.sdat_label,
LIVE_TRACE_BOUNDARY.update_date,
LIVE_TRACE_BOUNDARY.update_user,
LIVE_TRACE_BOUNDARY.existence_kind,
LIVE_TRACE_BOUNDARY.guid,
LIVE_TRACE_BOUNDARY.ID,
LIVE_TRACE_BOUNDARY.VERSION,
LIVE_TRACE_BOUNDARY.NAME,
LIVE_TRACE_BOUNDARY.original_source,
LIVE_TRACE_BOUNDARY.remarks,
LIVE_TRACE_BOUNDARY.SOURCE,
LIVE_TRACE_BOUNDARY.polygon_geometry_id,
LIVE_TRACE_BOUNDARY.sub_type,
LIVE_TRACE_BOUNDARY.seismic_dataset_live_trace_id,
AREA.shape
FROM LIVE_TRACE_BOUNDARY, AREA
WHERE LIVE_TRACE_BOUNDARY.POLYGON_GEOMETRY_ID = AREA.ID
|