| Name | Survey_2D_Doc |
|---|---|
| Entity Type | ObjectView |
| Description | PSS 2013.1 Survey_2D_Doc DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| CONTRIBUTOR | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| COVERAGE | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| CREATOR | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| DOCUMENT_BODY | BLOB | NA |
_ | No |
BLOB |
| DOCUMENT_DATE | DATE | NA |
_ | No |
DATE |
| DOCUMENT_FOLDER_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| DOCUMENT_FORMAT | STRING64 | NA |
_ | Yes |
VARCHAR2(64) |
| DOCUMENT_ID | NUMBER2 | NA |
_ | Yes |
NUMBER(2) |
| DOCUMENT_TYPE | STRING64 | NA |
_ | Yes |
VARCHAR2(64) |
| END_DATE | DATE | NA |
_ | No |
DATE |
| END_INDEX | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| ENTITY_ID | NUMBER2 | NA |
_ | Yes |
NUMBER(2) |
| FILE_SIZE | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| 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) |
| MEDIA_TYPE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| ORIGINAL_PATH | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| ORIGINAL_SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PATH | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| PRODUCED_BY | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| PUBLISHER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| REMARKS | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| RIGHTS | STRING128 | NA |
_ | No |
VARCHAR2(128) |
| SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| SOURCE_LANGUAGE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| START_DATE | DATE | NA |
_ | No |
DATE |
| START_INDEX | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| STORAGE_TYPE | STRING32 | NA |
_ | No |
VARCHAR2(32) |
| SUBJECT | STRING128 | NA |
_ | No |
VARCHAR2(128) |
| TITLE | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| UPDATE_DATE | DATE | NA |
_ | No |
DATE |
| UPDATE_USER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| VERSION | STRING255 | NA |
_ | Yes |
VARCHAR2(255) |
| VIEWER | STRING64 | NA |
_ | No |
VARCHAR2(64) |
CREATE OR REPLACE FORCE VIEW Survey_2D_Doc(ID, DOCUMENT_ID, ENTITY_ID, STORAGE_TYPE, INSERT_DATE, INSERT_USER, UPDATE_DATE, UPDATE_USER, GUID, NAME, VERSION, ORIGINAL_SOURCE, PRODUCED_BY, REMARKS, SOURCE, CONTRIBUTOR, COVERAGE, CREATOR, DOCUMENT_BODY, DOCUMENT_DATE, DOCUMENT_FOLDER_ID, DOCUMENT_FORMAT, DOCUMENT_TYPE, FILE_SIZE, MEDIA_TYPE, ORIGINAL_PATH, PATH, PUBLISHER, RIGHTS, SOURCE_LANGUAGE, SUBJECT, TITLE, VIEWER, START_DATE, END_DATE, START_INDEX, END_INDEX) AS SELECT
EDI.ID,
D.ID DOCUMENT_ID,
EDI.ENTITY_ID ENTITY_ID,
CASE
WHEN DOCUMENT_BODY IS NOT NULL THEN 'Database'
WHEN PATH IS NOT NULL THEN 'File'
ELSE 'Reference'
END STORAGE_TYPE,
D.INSERT_DATE,
D.INSERT_USER,
D.UPDATE_DATE,
D.UPDATE_USER,
D.GUID,
D.NAME,
D.VERSION,
D.ORIGINAL_SOURCE,
D.PRODUCED_BY,
D.REMARKS,
D.SOURCE,
D.CONTRIBUTOR,
D.COVERAGE,
D.CREATOR,
D.DOCUMENT_BODY,
D.DOCUMENT_DATE,
D.DOCUMENT_FOLDER_ID,
D.DOCUMENT_FORMAT,
D.DOCUMENT_TYPE,
D.FILE_SIZE,
D.MEDIA_TYPE,
D.ORIGINAL_PATH,
D.PATH,
D.PUBLISHER,
D.RIGHTS,
D.SOURCE_LANGUAGE,
D.SUBJECT,
D.TITLE,
D.VIEWER,
EDI.START_DATE,
EDI.END_DATE,
EDI.START_INDEX,
EDI.END_INDEX
FROM
ENTITY_DOC_INVOLVEMENT EDI,
DOCUMENT D
WHERE
D.ID=EDI.DOCUMENT_ID AND EDI.ENTITY_TBL='Survey_2D'
|