SAIL_LINE_3D_N


[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
Name SAIL_LINE_3D_N
Entity Type ObjectView
Description Field Nav DOV - SAIL_LINE_3D_N
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
APPLICATION_PROJECT_ID NUMBER2 NA
_ No
NUMBER(2)
DATASTORE_NAME STRING255 NA
_ No
VARCHAR2(255)
DATE_OF_SURVEY DATE NA
_ No
DATE
EXISTENCE_KIND STRING64 NA
_ Yes
VARCHAR2(64)
FIRST_SHOTPOINT NUMBER2 NA
_ No
NUMBER(2)
INSERT_DATE DATE NA
_ No
DATE
INSERT_USER STRING64 NA
_ No
VARCHAR2(64)
Id ID No_Unit
Unique identifier Yes
NUMBER(38)
LAST_SHOTPOINT 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_DATASTORE_ID NUMBER NA
_ No
NUMBER
PROJECT_NAME STRING255 NA
_ No
VARCHAR2(255)
REMARKS STRING2000 NA
_ No
VARCHAR2(2000)
SEISMIC_DATASET_ID NUMBER NA
_ No
NUMBER
SEISMIC_TECHNOLOGY STRING64 NA
_ No
VARCHAR2(64)
SOURCE STRING64 NA
_ No
VARCHAR2(64)
SURVEY_3D_ID NUMBER2 NA
_ No
NUMBER(2)
SURVEY_NAME STRING255 NA
_ No
VARCHAR2(255)
TAPE_VERSION STRING64 NA
_ No
VARCHAR2(64)
UPDATE_DATE DATE NA
_ No
DATE
UPDATE_USER STRING64 NA
_ No
VARCHAR2(64)
VERSION STRING255 NA
_ Yes
VARCHAR2(255)


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Sail_Line_3D_N(ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, NAME, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME, INSERT_DATE, DATE_OF_SURVEY, ORIGINAL_SOURCE, INSERT_USER, SEISMIC_TECHNOLOGY, EXISTENCE_KIND, PRODUCED_BY, TAPE_VERSION, REMARKS, VERSION, SOURCE, SURVEY_3D_ID, UPDATE_DATE, UPDATE_USER, SEISMIC_DATASET_ID, FIRST_SHOTPOINT, LAST_SHOTPOINT) AS SELECT SAIL_LINE.ID ID,
          SURVEY_3D.APPLICATION_PROJECT_ID APPLICATION_PROJECT_ID,
          APPLICATION_PROJECT.PROJECT_DATASTORE_ID PROJECT_DATASTORE_ID,
          SAIL_LINE.NAME NAME,
          SURVEY_3D.NAME SURVEY_NAME,
          APPLICATION_PROJECT.NAME PROJECT_NAME,
          PROJECT_DATASTORE.NAME DATASTORE_NAME,
          SAIL_LINE.INSERT_DATE INSERT_DATE,
          SAIL_LINE.DATE_OF_SURVEY DATE_OF_SURVEY,
          SAIL_LINE.ORIGINAL_SOURCE ORIGINAL_SOURCE,
          SAIL_LINE.INSERT_USER INSERT_USER,
          SAIL_LINE.SEISMIC_TECHNOLOGY SEISMIC_TECHNOLOGY,
          
SAIL_LINE.EXISTENCE_KIND EXISTENCE_KIND,
          SAIL_LINE.PRODUCED_BY PRODUCED_BY,
          SAIL_LINE.TAPE_VERSION TAPE_VERSION,
          SAIL_LINE.REMARKS REMARKS,
          SAIL_LINE.VERSION VERSION,
          SAIL_LINE.SOURCE SOURCE,
          SAIL_LINE.SURVEY_3D_ID SURVEY_3D_ID,
          SAIL_LINE.UPDATE_DATE UPDATE_DATE,
          SAIL_LINE.UPDATE_USER UPDATE_USER,
          SEISMIC_FILE.SEISMIC_DATASET_ID SEISMIC_DATASET_ID,
          SEISMIC_FILE.FIRST_SHOTPOINT FIRST_SHOTPOINT,
          SEISMIC_FILE.LAST_SHOTPOINT LAST_SHOTPOINT
     FROM PROJECT_DATASTORE,
          APPLICATION_PROJECT,
          SURVEY_3D,
          SAIL_LINE,
          ACQUISITION_3D,
          SEISMIC_LINE,
          SEISMIC_FILE
    WHERE     APPLICATION_PROJECT.PROJECT_DATASTORE_ID = PROJECT_DATASTORE.ID
          AND SURVEY_3D.APPLICATION_PROJECT_ID = APPLICATION_PROJECT.ID
          AND SAIL_LINE.SURVEY_3D_ID = SURVEY_3D.ID
          AND ACQUISITION_3D.SAIL_LINE_ID = SAIL_LINE.ID
          AND 
SEISMIC_LINE.ACQUISITION_3D_ID = ACQUISITION_3D.ID
          AND SEISMIC_FILE.SEISMIC_DATASET_ID =
                 SEISMIC_LINE.SOURCE_DATASET_ID
          AND SEISMIC_FILE.NAME = SAIL_LINE.NAME
          AND SEISMIC_FILE.SEISMIC_FORMAT NOT IN ('SPS')
   


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.