Seismic_DS_2D_N_Stat


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

General Information

[Next]
Name Seismic_DS_2D_N_Stat
Entity Type ObjectView
Description PSS 2013.1 Seismic_DS_2D_N_Stat DOV
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
_ Yes
NUMBER(2)
DATASET_NAME STRING255 NA
_ No
VARCHAR2(255)
DATASTORE_NAME STRING255 NA
_ No
VARCHAR2(255)
DATA_MAXIMUM NUMBER2 NA
_ No
NUMBER(2)
DATA_MEAN NUMBER2 NA
_ No
NUMBER(2)
DATA_MINIMUM NUMBER2 NA
_ No
NUMBER(2)
DATA_STD_DEVIATION NUMBER2 NA
_ No
NUMBER(2)
EXISTENCE_KIND STRING64 NA
_ Yes
VARCHAR2(64)
GENERATION_DATE DATE NA
_ No
DATE
GUID STRING128 NA
_ No
VARCHAR2(128)
HISTOGRAM_DATA BLOB NA
_ No
BLOB
HISTOGRAM_END_TIME NUMBER2 Short_Time
ms
_ No
NUMBER(2)
HISTOGRAM_MAXIMUM NUMBER2 NA
_ No
NUMBER(2)
HISTOGRAM_SAMPLE_INTERVAL NUMBER2 Short_Time
ms
_ No
NUMBER(2)
HISTOGRAM_SIZE NUMBER2 NA
_ No
NUMBER(2)
HISTOGRAM_START_TIME NUMBER2 Short_Time
ms
_ No
NUMBER(2)
ID NUMBER2 NA
_ Yes
NUMBER(2)
INSERT_DATE DATE NA
_ No
DATE
INSERT_USER STRING64 NA
_ No
VARCHAR2(64)
LINE_NAME STRING255 NA
_ No
VARCHAR2(255)
PRODUCED_BY STRING64 NA
_ No
VARCHAR2(64)
PROJECT_DATASTORE_ID NUMBER2 NA
_ Yes
NUMBER(2)
PROJECT_NAME STRING255 NA
_ No
VARCHAR2(255)
SDAT_LABEL NUMBER2 NA
_ No
NUMBER(2)
SEISMIC_DATASET_ID NUMBER2 NA
_ Yes
NUMBER(2)
SEISMIC_LINE_ID NUMBER2 NA
_ Yes
NUMBER(2)
SURVEY_2D_ID NUMBER2 NA
_ Yes
NUMBER(2)
SURVEY_NAME STRING255 NA
_ No
VARCHAR2(255)
TRACE_PERCENTAGE NUMBER2 NA
_ No
NUMBER(2)
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 Seismic_DS_2D_N_Stat(INSERT_DATE, INSERT_USER, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, EXISTENCE_KIND, GUID, VERSION, ID, DATA_MAXIMUM, DATA_MEAN, DATA_MINIMUM, DATA_STD_DEVIATION, GENERATION_DATE, HISTOGRAM_DATA, HISTOGRAM_END_TIME, HISTOGRAM_MAXIMUM, HISTOGRAM_SAMPLE_INTERVAL, HISTOGRAM_SIZE, HISTOGRAM_START_TIME, TRACE_PERCENTAGE, SEISMIC_DATASET_ID, SEISMIC_LINE_ID, SURVEY_2D_ID, APPLICATION_PROJECT_ID, PROJECT_DATASTORE_ID, DATASET_NAME, LINE_NAME, SURVEY_NAME, PROJECT_NAME, DATASTORE_NAME) AS SELECT DATASET_STATISTICS.INSERT_DATE,
    DATASET_STATISTICS.INSERT_USER,
    DATASET_STATISTICS.PRODUCED_BY,
    DATASET_STATISTICS.SDAT_LABEL,
    DATASET_STATISTICS.UPDATE_DATE,
    DATASET_STATISTICS.UPDATE_USER,
    DATASET_STATISTICS.EXISTENCE_KIND,
    DATASET_STATISTICS.GUID,
    DATASET_STATISTICS.VERSION,
    DATASET_STATISTICS.ID,
    DATASET_STATISTICS.DATA_MAXIMUM,
    DATASET_STATISTICS.DATA_MEAN,
    DATASET_STATISTICS.DATA_MINIMUM,
   
 DATASET_STATISTICS.DATA_STD_DEVIATION,
    DATASET_STATISTICS.GENERATION_DATE,
    DATASET_STATISTICS.HISTOGRAM_DATA,
    DATASET_STATISTICS.HISTOGRAM_END_TIME,
    DATASET_STATISTICS.HISTOGRAM_MAXIMUM,
    DATASET_STATISTICS.HISTOGRAM_SAMPLE_INTERVAL,
    DATASET_STATISTICS.HISTOGRAM_SIZE,
    DATASET_STATISTICS.HISTOGRAM_START_TIME,
    DATASET_STATISTICS.TRACE_PERCENTAGE,
    DATASET_STATISTICS.SEISMIC_DATASET_ID,
    Seismic_Dataset_2D_N.SEISMIC_LINE_ID,
    Seismic_Dataset_2D_N.SURVEY_2D_ID,
    Seismic_Dataset_2D_N.APPLICATION_PROJECT_ID,
    Seismic_Dataset_2D_N.PROJECT_DATASTORE_ID,
    Seismic_Dataset_2D_N.NAME,
    Seismic_Dataset_2D_N.LINE_NAME,
    Seismic_Dataset_2D_N.SURVEY_NAME,
    Seismic_Dataset_2D_N.PROJECT_NAME,
    Seismic_Dataset_2D_N.DATASTORE_NAME
  FROM DATASET_STATISTICS,
    Seismic_Dataset_2D_N
  WHERE Seismic_Dataset_2D_N.ID = DATASET_STATISTICS.SEISMIC_DATASET_ID
   


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

Copyright © 2018 Schlumberger. All rights reserved.