Export_Boundary_Shape


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name Export_Boundary_Shape
Entity Type ObjectView
Description Export_Boundary_Shape Object View
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
EXISTENCE_KIND REF_EXISTENCE_KIND NA
_ Yes
VARCHAR2(64)
EXPORT_JOB_ITEM_ID NUMBER NA
_ No
NUMBER
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
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)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Export_Boundary_Shape(NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, POLYGON_GEOMETRY_ID, SUB_TYPE, EXPORT_JOB_ITEM_ID, INSERT_DATE, INSERT_USER, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, EXISTENCE_KIND, GUID, ID, VERSION, SHAPE) AS SELECT EXPORT_BOUNDARY.NAME,
          EXPORT_BOUNDARY.original_source,
          EXPORT_BOUNDARY.remarks,
          EXPORT_BOUNDARY.SOURCE,
          EXPORT_BOUNDARY.polygon_geometry_id,
          EXPORT_BOUNDARY.sub_type,
          EXPORT_BOUNDARY.export_job_item_id,
          EXPORT_BOUNDARY.insert_date,
          EXPORT_BOUNDARY.insert_user,
          EXPORT_BOUNDARY.produced_by,
          EXPORT_BOUNDARY.sdat_label,
          EXPORT_BOUNDARY.update_date,
          EXPORT_BOUNDARY.update_user,
          EXPORT_BOUNDARY.existence_kind,
          EXPORT_BOUNDARY.guid,
          EXPORT_BOUNDARY.ID,
          EXPORT_BOUNDARY.VERSION,
          AREA.shape
     FROM EXPORT_BOUNDARY, AREA
    WHERE 
EXPORT_BOUNDARY.polygon_geometry_id = AREA.ID
   


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.