| Name | Application_Project_N |
|---|---|
| Entity Type | ObjectView |
| Description | PSS 2013.1 Application_Project_N DOV |
| 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 | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| DATASTORE_NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| GUID | STRING128 | NA |
_ | No |
VARCHAR2(128) |
| ID | NUMBER2 | NA |
_ | Yes |
NUMBER(2) |
| INSERT_DATE | DATE | NA |
_ | No |
DATE |
| INSERT_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| MASTER_PROJECT_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| ORIGINAL_SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PRODUCED_BY | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PROJECT_CRS_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| PROJECT_DATASTORE_ID | NUMBER2 | NA |
_ | Yes |
NUMBER(2) |
| REMARKS | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| UPDATE_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
CREATE OR REPLACE FORCE VIEW Application_Project_N(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) 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
from PROJECT_DATASTORE, APPLICATION_PROJECT
where PROJECT_DATASTORE.ID = APPLICATION_PROJECT.PROJECT_DATASTORE_ID
|