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 |
Name | Value Domain | Property / Storage Unit | Description | Required / 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) |
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 |