| Name | Seismic_File_Arc_File |
|---|---|
| Entity Type | ObjectView |
| Description | PSS 2013.1 Seismic_File_ARCHIVE_FILE DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| ARCHIVE_FILE_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| ARCHIVE_FILE_NAME | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| ARCHIVE_FILE_WITHIN_FILE | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| ARCHIVE_FOLDER_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| FILE_WITHIN_ARCHIVE_FILE | STRING2000 | NA |
_ | No |
VARCHAR2(2000) |
| GEOPHYSICAL_INVENTORY_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
CREATE OR REPLACE FORCE VIEW Seismic_File_Arc_File(ID, GEOPHYSICAL_INVENTORY_ID, ARCHIVE_FILE_ID, ARCHIVE_FILE_WITHIN_FILE, FILE_WITHIN_ARCHIVE_FILE, ARCHIVE_FOLDER_ID, ARCHIVE_FILE_NAME) AS SELECT ARCHIVE_FILE_INVENTORY_X.GEOPHYSICAL_INVENTORY_ID||'_'||ARCHIVE_FILE_INVENTORY_X.ARCHIVE_FILE_ID||'_'||ARCHIVE_FILE.ARCHIVE_FOLDER_ID as ID, ARCHIVE_FILE_INVENTORY_X.GEOPHYSICAL_INVENTORY_ID, ARCHIVE_FILE_INVENTORY_X.ARCHIVE_FILE_ID, ARCHIVE_FILE_INVENTORY_X.ARCHIVE_FILE_WITHIN_FILE, ARCHIVE_FILE_INVENTORY_X.FILE_WITHIN_ARCHIVE_FILE, ARCHIVE_FILE.ARCHIVE_FOLDER_ID, ARCHIVE_FOLDER.HOST_DIRECTORY_NAME||'/'||ARCHIVE_FILE.NAME ARCHIVE_FILE_NAME FROM ARCHIVE_FOLDER, ARCHIVE_FILE, ARCHIVE_FILE_INVENTORY_X, GEOPHYSICAL_INVENTORY WHERE ARCHIVE_FOLDER.ID = ARCHIVE_FILE.ARCHIVE_FOLDER_ID AND ARCHIVE_FILE.ID = ARCHIVE_FILE_INVENTORY_X.ARCHIVE_FILE_ID AND ARCHIVE_FILE_INVENTORY_X.GEOPHYSICAL_INVENTORY_ID = GEOPHYSICAL_INVENTORY.ID |