| Name | Application_Prj_N_Shape |
|---|---|
| Entity Type | ObjectView |
| Description | Application_Prj_N_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 |
|---|---|---|---|---|---|
| ACCOUNT_NAME | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| ACCOUNT_PASSWORD | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| APP_PROJECT_UNIQUE_LOCATOR | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| DATASTORE_NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| 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) |
| MASTER_PROJECT_ID | NUMBER | NA |
_ | No |
NUMBER |
| NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| ORIGINAL_SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PRODUCED_BY | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PROJECT_CRS_ID | NUMBER | NA |
_ | No |
NUMBER |
| PROJECT_DATASTORE_ID | NUMBER | NA |
_ | Yes |
NUMBER |
| REMARKS | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| Shape | GEOMETRY | NA |
_ | No |
ST_GEOMETRY |
| UPDATE_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
CREATE OR REPLACE FORCE VIEW Application_Prj_N_Shape(ID, PROJECT_DATASTORE_ID, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, DATASTORE_NAME, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, ACCOUNT_NAME, ACCOUNT_PASSWORD, APP_PROJECT_UNIQUE_LOCATOR, MASTER_PROJECT_ID, PROJECT_CRS_ID, SHAPE) AS SELECT APPLICATION_PROJECT.ID,
PROJECT_DATASTORE.ID,
APPLICATION_PROJECT.INSERT_DATE,
APPLICATION_PROJECT.INSERT_USER,
APPLICATION_PROJECT.UPDATE_DATE,
APPLICATION_PROJECT.UPDATE_USER,
APPLICATION_PROJECT.GUID,
APPLICATION_PROJECT.NAME,
PROJECT_DATASTORE.NAME,
APPLICATION_PROJECT.ORIGINAL_SOURCE,
APPLICATION_PROJECT.PRODUCED_BY,
APPLICATION_PROJECT.REMARKS,
APPLICATION_PROJECT.SOURCE,
APPLICATION_PROJECT.ACCOUNT_NAME,
APPLICATION_PROJECT.ACCOUNT_PASSWORD,
APPLICATION_PROJECT.APP_PROJECT_UNIQUE_LOCATOR,
APPLICATION_PROJECT.MASTER_PROJECT_ID,
APPLICATION_PROJECT.PROJECT_CRS_ID,
AREA.SHAPE
FROM PROJECT_BOUNDARY,
AREA,
PROJECT_DATASTORE,
APPLICATION_PROJECT
WHERE APPLICATION_PROJECT.ID =
PROJECT_BOUNDARY.APPLICATION_PROJECT_ID
AND PROJECT_BOUNDARY.POLYGON_GEOMETRY_ID = AREA.ID
AND PROJECT_DATASTORE.ID = APPLICATION_PROJECT.PROJECT_DATASTORE_ID
|