| Name | Survey_2D_Dataset |
|---|---|
| Entity Type | ObjectView |
| Description | PSS 2013.1 Survey_2D_Dataset DOV |
| Submodel | Data_Object |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
| NAME | STRING255 | NA |
_ | No |
VARCHAR2(255) |
| SOURCE | STRING64 | NA |
_ | No |
VARCHAR2(64) |
| SURVEY_2D_ID | NUMBER2 | NA |
_ | No |
NUMBER(2) |
CREATE OR REPLACE FORCE VIEW Survey_2D_Dataset(ID, SURVEY_2D_ID, NAME, SOURCE) AS (SELECT DISTINCT seismic_line.survey_2d_id AS ID, seismic_line.survey_2d_id,
seismic_dataset_2d.NAME, seismic_dataset_2d.SOURCE
FROM seismic_dataset_2d, seismic_line
WHERE seismic_dataset_2d.seismic_line_id = seismic_line.ID)
UNION
(SELECT DISTINCT seismic_line.survey_2d_id AS ID, seismic_line.survey_2d_id,
seismic_dataset_2d.NAME, seismic_dataset_2d.SOURCE
FROM seismic_dataset_2d, alternative_navigation, seismic_line
WHERE seismic_dataset_2d.alternative_navigation_id = alternative_navigation.ID
and seismic_line.ID = alternative_navigation.seismic_line_id)
|