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