data_id
Base Table Datalogger
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_type
Base Table Datalogger
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute represents a datalogger type
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


serial_nb
Base Table Datalogger
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a serial number of a datalogger
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


firmware_nb
Base Table Datalogger
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute describes the firmware number of a datalogger
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


software
Base Table Datalogger
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition Datalogger’s software (mshear, ushear, ...)
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


software_nb
Base Table Datalogger
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition Datalogger’s software version number
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Datalogger
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Datalogger
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_board
Base Table Datalogger
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition This attribute denotes the number of boards of a datalogger

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


word_32
Base Table Datalogger
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition The swap order in which 32-bit quantities are specified in the data headers

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


word_16
Base Table Datalogger
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition 16-bit quantity byte swapping order, for the data headers only

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Datalogger
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_id
Base Table Datalogger_Board
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


board_nb
Base Table Datalogger_Board
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of boards of a datalogger

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


serial_nb
Base Table Datalogger_Board
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a serial number of a datalogger board
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_module
Base Table Datalogger_Board
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of modules of a datalogger’s board

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


firmware_nb
Base Table Datalogger_Board
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute describes the firmware number of a datalogger
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Datalogger_Board
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_id
Base Table Datalogger_Module
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


board_nb
Base Table Datalogger_Module
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of boards of a datalogger

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


module_nb
Base Table Datalogger_Module
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the module number of a datalogger’s board

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


serial_nb
Base Table Datalogger_Module
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a serial number of a datalogger module
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


firmware_nb
Base Table Datalogger_Module
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute describes the firmware number of a datalogger
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sensitivity
Base Table Datalogger_Module
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute denotes the sensitivity (Sd) for a sensor or a digitizer

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Datalogger_Module
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filamp_id
Base Table Filamp
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Table Filamp
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a descriptive name for a filter-amplifier
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


serial_nb
Base Table Filamp
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a serial number of a filter-amplifier
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Filamp
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Filamp
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_pchannel
Base Table Filamp
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of physical channels of a datalogger

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Filamp
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filamp_id
Base Table Filamp_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pchannel_nb
Base Table Filamp_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes a physical channel

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


gain
Base Table Filamp_PChannel
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute denotes the gain

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


frequency
Base Table Filamp_PChannel
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The frequency (fs) at which the value in sensitivity/gain is correct

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seqresp_id
Base Table Filamp_PChannel
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Filamp_PChannel
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filter_id
Base Table Filter
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Filter identifier. Each filter is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


gain
Base Table Filter
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute denotes the gain

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


frequency
Base Table Filter
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The frequency (fs) at which the value in sensitivity/gain is correct

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


in_sp_rate
Base Table Filter
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Sampling rate. This attribute is the input sample rate in samples/second

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


out_sp_rate
Base Table Filter
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Sampling rate. This attribute is the output sample rate in samples/second

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offset
Base Table Filter
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


delay
Base Table Filter
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The estimated pure delay for the filter

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


correction
Base Table Filter
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion. This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seqresp_id
Base Table Filter
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Filter
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


fir_id
Base Table Filter_FIR
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Table Filter_FIR
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a descriptive name for a FIR filter
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


symmetry
Base Table Filter_FIR
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute denotes the eventual symmetry of a response
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


gain
Base Table Filter_FIR
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute denotes the gain

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Filter_FIR
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


fir_id
Base Table Filter_FIR_Data
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


coeff_nb
Base Table Filter_FIR_Data
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition The numerator/denominator number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


type
Base Table Filter_FIR_Data
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute denotes whether a value is associated with a numerator/denominator
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


coefficient
Base Table Filter_FIR_Data
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition The numerator/denominator coefficient value

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


error
Base Table Filter_FIR_Data
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attributes denotes the numerator/denominator error

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seqfil_id
Base Table Filter_Sequence
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Table Filter_Sequence
Datatype VARCHAR2(32)
Nullable NO
Domain
Definition This attribute denotes a descriptive name for a chain of filters
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_filter
Base Table Filter_Sequence
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of filters of a sequence

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


gain
Base Table Filter_Sequence
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute denotes the gain

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


frequency
Base Table Filter_Sequence
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The frequency (fs) at which the value in sensitivity/gain is correct

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Filter_Sequence
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seqfil_id
Base Table Filter_Sequence_Data
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filter_nb
Base Table Filter_Sequence_Data
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the filter number in a sequence

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filter_id
Base Table Filter_Sequence_Data
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Filter identifier. Each filter is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seqresp_id
Base Table Response
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


resp_nb
Base Table Response
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the response number of a sequence

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


resp_type
Base Table Response
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute denotes the response type
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


resp_id
Base Table Response
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Response identifier. Each response is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_in
Base Table Response
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_out
Base Table Response
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


r_type
Base Table Response
Datatype VARCHAR2(1)
Nullable YES
Domain
Definition A single character describing the type of response
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Response
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


hp_id
Base Table Response_HP
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filter_type
Base Table Response_HP
Datatype VARCHAR2(2)
Nullable NO
Domain
Definition This attribute denotes the type of a high-pass filter
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_pole
Base Table Response_HP
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of poles of a high-pass filter

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


corner_freq
Base Table Response_HP
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition This attribute represents the corner frequency of a high-pass filter

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


damping_value
Base Table Response_HP
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition This attribute represents the fraction of critical damping of a high-pass filter

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Response_HP
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lp_id
Base Table Response_LP
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filter_type
Base Table Response_LP
Datatype VARCHAR2(2)
Nullable YES
Domain
Definition This attribute denotes the type of a low-pass filter
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_pole
Base Table Response_LP
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition This attribute denotes the number of poles of a low-pass filter

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


corner_freq
Base Table Response_LP
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition This attribute represents the corner frequency of a low-pass filter

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


damping_value
Base Table Response_LP
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition This attribute represents the fraction of critical damping of a low-pass filter

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Response_LP
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pn_id
Base Table Response_PN
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Table Response_PN
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a descriptive name for a polynomial
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


poly_type
Base Table Response_PN
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute represents the type of polynomial approximation
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lower_bound
Base Table Response_PN
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute denotes the polynomial lower bound

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


upper_bound
Base Table Response_PN
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute denotes the polynomial upper bound

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


max_error
Base Table Response_PN
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute represents the maximum error of polynomial approximation

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_coeff
Base Table Response_PN
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition This attribute denotes the number of polynomial coefficients

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Response_PN
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pn_id
Base Table Response_PN_Data
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pn_nb
Base Table Response_PN_Data
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the coefficient number of a polynomial

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pn_value
Base Table Response_PN_Data
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition This attribute denotes the coefficient value of a polynomial

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pz_id
Base Table Response_PZ
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pz_nb
Base Table Response_PZ
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the pole/zero number of a response

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


type
Base Table Response_PZ
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute denotes whether a value is associated with a pole/zero
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


r_value
Base Table Response_PZ
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition The real portion of a complex pole/zero

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


r_error
Base Table Response_PZ
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The error value for the real portion of a complex pole/zero

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


i_value
Base Table Response_PZ
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition The imaginary portion of a complex pole/zero

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


i_error
Base Table Response_PZ
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The error value for the imaginary portion of a complex pole/zero

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Response_PZ
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sensor_id
Base Table Sensor
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Table Sensor
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a descriptive name for a sensor
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


serial_nb
Base Table Sensor
Datatype VARCHAR2(80)
Nullable YES
Domain
Definition This attribute denotes a serial number of a sensor
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Sensor
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Sensor
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_component
Base Table Sensor
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of components of a sensor

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Sensor
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sensor_id
Base Table Sensor_Component
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


component_nb
Base Table Sensor_Component
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the component number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel_comp
Base Table Sensor_Component
Datatype VARCHAR2(2)
Nullable YES
Domain
Definition Component channel
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


component_type
Base Table Sensor_Component
Datatype VARCHAR2(1)
Nullable YES
Domain
Definition This attribute denotes the component type
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sensitivity
Base Table Sensor_Component
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition This attribute denotes the sensitivity (Sd) for a sensor or a digitizer

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


frequency
Base Table Sensor_Component
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The frequency (fs) at which the value in sensitivity/gain is correct

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seqresp_id
Base Table Sensor_Component
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Sensor_Component
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lat
Base Table Station
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lon
Base Table Station
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


elev
Base Table Station
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Elevation. This attribute is the elevation of a seismic station relative to mean sea level

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


staname
Base Table Station
Datatype VARCHAR2(50)
Nullable YES
Domain
Definition Station name/description. This is the full name of the station whose code-name is in sta
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_sensor
Base Table Station
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition This attribute denotes the number of sensors of a station

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_filamp
Base Table Station
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition This attribute denotes the number of filter-amplifiers of a station

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_digi
Base Table Station
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of digitizers of a station

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_data
Base Table Station
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of dataloggers of a station

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


datumhor
Base Table Station
Datatype VARCHAR2(8)
Nullable YES
Domain
Definition Datum type for horizontal (latitude and longitude) coordinates
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


datumver
Base Table Station
Datatype VARCHAR2(8)
Nullable YES
Domain
Definition Datum type for depth or elevation
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Datalogger
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Datalogger
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_nb
Base Table Station_Datalogger
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the datalogger number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Datalogger
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_id
Base Table Station_Datalogger
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_pchannel
Base Table Station_Datalogger
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of physical channels of a datalogger

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Datalogger
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Datalogger
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_nb
Base Table Station_Datalogger_LChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the datalogger number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pchannel_nb
Base Table Station_Datalogger_LChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes a physical channel

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lchannel_nb
Base Table Station_Datalogger_LChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes a logical channel of a datalogger

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Datalogger_LChannel
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seqfil_id
Base Table Station_Datalogger_LChannel
Datatype NUMBER(8, 0)
Nullable YES
Domain
Definition Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(3)
Nullable YES
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(3)
Nullable YES
Domain
Definition Channel name
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(8)
Nullable YES
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, ...)
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(2)
Nullable YES
Domain
Definition Describes the individual sites on an array station, operated by the same network operator
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


rgain
Base Table Station_Datalogger_LChannel
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition This attribute denotes the gain at the response frequency

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


rfrequency
Base Table Station_Datalogger_LChannel
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The frequency (fs) at which the value in rgain is correct

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


samprate
Base Table Station_Datalogger_LChannel
Datatype DOUBLE PRECISION
Nullable NO
Domain
Definition Sampling rate. This attribute is the sample rate in samples/second

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


clock_drift
Base Table Station_Datalogger_LChannel
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


flags
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(27)
Nullable YES
Domain
Definition Channel flags
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_format
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(80)
Nullable NO
Domain
Definition This attribute represents the data format
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


comp_type
Base Table Station_Datalogger_LChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Compression type. A lookup key that refers to the Format Dictionary

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_signal
Base Table Station_Datalogger_LChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_calib
Base Table Station_Datalogger_LChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


block_size
Base Table Station_Datalogger_LChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition The record length of the data

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Datalogger_LChannel
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


remark
Base Table Station_Datalogger_LChannel
Datatype VARCHAR2(30)
Nullable YES
Domain
Definition An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Datalogger_LChannel
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Datalogger_PChannel
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Datalogger_PChannel
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_nb
Base Table Station_Datalogger_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the datalogger number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pchannel_nb
Base Table Station_Datalogger_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes a physical channel

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Datalogger_PChannel
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


board_type
Base Table Station_Datalogger_PChannel
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute describes the board type on the datalogger where the physical channel resides. Regular seismic channels are usually on a primary board. Auxiliary channels (internal temperature, external power, …) are usually on an auxiliary board. A value of external is used to represent a digitizer that is not part of the datalogger (for example an embedded digitizer in a digital pressure sensor). A digital board is used to represent truly digital sensors which don’t actually have any digitizing stage from Volts to Counts (for example a rainfall sensor that uses a digital counter)
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel_type
Base Table Station_Datalogger_PChannel
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute describes the type of the input channel. An input channel is usually classified as physical when the data is digitized (velocity, acceleration, ...). An input channel is defined as synthetic when the data is not derived directly from a sensor (clock frequency, available telemetry buffer channel, clock quality, ...)
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seed_io
Base Table Station_Datalogger_PChannel
Datatype VARCHAR2(2)
Nullable NO
Domain
Definition This attribute represents the SEED instrument and orientation
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_lchannel
Base Table Station_Datalogger_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of logical channels of a datalogger

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Datalogger_PChannel
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Datalogger_PChannel
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Digitizer
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Digitizer
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


digi_nb
Base Table Station_Digitizer
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the digitizer number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Digitizer
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


serial_nb
Base Table Station_Digitizer
Datatype VARCHAR2(80)
Nullable NO
Domain
Definition This attribute denotes a serial number of a datalogger board
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_pri_pchannel
Base Table Station_Digitizer
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of primary physical channels of a digitizer

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_aux_pchannel
Base Table Station_Digitizer
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of auxiliary physical channels of a digitizer

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Digitizer
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Digitizer
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Digitizer_PChannel
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Digitizer_PChannel
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


digi_nb
Base Table Station_Digitizer_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the digitizer number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pchannel_nb
Base Table Station_Digitizer_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes a physical channel

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Digitizer_PChannel
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_nb
Base Table Station_Digitizer_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the datalogger number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


data_pchannel
Base Table Station_Digitizer_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents a datalogger physical channel

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


digi_type
Base Table Station_Digitizer_PChannel
Datatype VARCHAR2(3)
Nullable NO
Domain
Definition This attribute represents the digitizer type
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


digi_polarity
Base Table Station_Digitizer_PChannel
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute represents the digitizer polarity
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


digi_channel
Base Table Station_Digitizer_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents a digitizer module on a board

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Digitizer_PChannel
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Digitizer_PChannel
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Filamp
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Filamp
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filamp_nb
Base Table Station_Filamp
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the filter-amplifier number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Filamp
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filamp_id
Base Table Station_Filamp
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_pchannel
Base Table Station_Filamp
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of physical channels of a datalogger

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Filamp
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Filamp
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Filamp_PChannel
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Filamp_PChannel
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


filamp_nb
Base Table Station_Filamp_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the filter-amplifier number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pchannel_nb
Base Table Station_Filamp_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes a physical channel

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Filamp_PChannel
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


next_hard_type
Base Table Station_Filamp_PChannel
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute denotes the next hardware type
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


next_hard_nb
Base Table Station_Filamp_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the next hardware number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


next_hard_pchannel
Base Table Station_Filamp_PChannel
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the next hardware physical channel

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Filamp_PChannel
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Filamp_PChannel
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Sensor
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Sensor
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sensor_nb
Base Table Station_Sensor
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the sensor number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Sensor
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sensor_id
Base Table Station_Sensor
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lat
Base Table Station_Sensor
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lon
Base Table Station_Sensor
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


elev
Base Table Station_Sensor
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Elevation. This attribute is the elevation of a seismic station relative to mean sea level

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


edepth
Base Table Station_Sensor
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


nb_component
Base Table Station_Sensor
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the number of components of a sensor

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


datumhor
Base Table Station_Sensor
Datatype VARCHAR2(8)
Nullable YES
Domain
Definition Datum type for horizontal (latitude and longitude) coordinates
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


datumver
Base Table Station_Sensor
Datatype VARCHAR2(8)
Nullable YES
Domain
Definition Datum type for depth or elevation
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Sensor
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Sensor
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Table Station_Sensor_Component
Datatype VARCHAR2(6)
Nullable NO
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Table Station_Sensor_Component
Datatype VARCHAR2(8)
Nullable NO
Domain
Definition Unique network identifier. This character string is the name of a seismic network
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sensor_nb
Base Table Station_Sensor_Component
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the sensor number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


component_nb
Base Table Station_Sensor_Component
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute represents the component number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Table Station_Sensor_Component
Datatype DATE
Nullable NO
Domain
Definition This attribute denotes the start date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


next_hard_type
Base Table Station_Sensor_Component
Datatype VARCHAR2(1)
Nullable NO
Domain
Definition This attribute denotes the next hardware type
Character Set BYTE

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


next_hard_nb
Base Table Station_Sensor_Component
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the next hardware number

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


next_hard_pchannel
Base Table Station_Sensor_Component
Datatype NUMBER(8, 0)
Nullable NO
Domain
Definition This attribute denotes the next hardware physical channel

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


azimuth
Base Table Station_Sensor_Component
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The azimuth of the instrument from north, clockwise

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


dip
Base Table Station_Sensor_Component
Datatype DOUBLE PRECISION
Nullable YES
Domain
Definition The dip of the instrument, down from horizontal

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Table Station_Sensor_Component
Datatype DATE
Nullable YES
Domain
Definition This attribute denotes the end date

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Table Station_Sensor_Component
Datatype DATE
Nullable YES
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description