Datalogger

EntityType | Independent
Logical Table Name | Datalogger
Owner |
Definition | Summary information on a datalogger
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
data_id |  | NUMERIC(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
data_type |  | VARCHAR(80) | YES | This attribute represents a datalogger type
serial_nb |  | VARCHAR(80) | YES | This attribute denotes a serial number of a datalogger
firmware_nb |  | VARCHAR(80) | YES | This attribute describes the firmware number of a datalogger
software |  | VARCHAR(80) | YES | Datalogger’s software (mshear, ushear, ...)
software_nb |  | VARCHAR(80) | YES | Datalogger’s software version number
ondate |  | DATE | NO | This attribute denotes the start date
offdate |  | DATE | YES | This attribute denotes the end date
nb_board |  | NUMERIC(8, 0) | YES | This attribute denotes the number of boards of a datalogger
word_32 |  | NUMERIC(8, 0) | NO | The swap order in which 32-bit quantities are specified in the data headers
word_16 |  | NUMERIC(8, 0) | NO | 16-bit quantity byte swapping order, for the data headers only
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
Da00 | PrimaryKey | data_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Datalogger | Datalogger_Board | Identifying | data_id
Datalogger | Station_Datalogger | Non-Identifying | data_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Datalogger_Board

EntityType | Dependent
Logical Table Name | Datalogger_Board
Owner |
Definition | Board of a datalogger
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
data_id |  | NUMERIC(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
board_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the number of boards of a datalogger
serial_nb |  | VARCHAR(80) | YES | This attribute denotes a serial number of a datalogger board
nb_module |  | NUMERIC(8, 0) | NO | This attribute denotes the number of modules of a datalogger’s board
firmware_nb |  | VARCHAR(80) | YES | This attribute describes the firmware number of a datalogger
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
DaB00 | PrimaryKey | data_id,board_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Datalogger | Datalogger_Board | Identifying | data_id
Station_Digitizer | Datalogger_Board | Non-Specific |
Datalogger_Board | Datalogger_Module | Identifying | data_id,board_nb

Attachments

Name | Datatype | Value Override | Default Value | Description

Datalogger_Module

EntityType | Dependent
Logical Table Name | Datalogger_Module
Owner |
Definition | Module of a datalogger’s board
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
data_id |  | NUMERIC(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
board_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the number of boards of a datalogger
module_nb |  | NUMERIC(8, 0) | NO | This attribute represents the module number of a datalogger’s board
serial_nb |  | VARCHAR(80) | YES | This attribute denotes a serial number of a datalogger module
firmware_nb |  | VARCHAR(80) | YES | This attribute describes the firmware number of a datalogger
sensitivity |  | FLOAT | YES | This attribute denotes the sensitivity (Sd) for a sensor or a digitizer
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
DaM00 | PrimaryKey | data_id,board_nb,module_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Datalogger_Board | Datalogger_Module | Identifying | data_id,board_nb

Attachments

Name | Datatype | Value Override | Default Value | Description

Filamp

EntityType | Independent
Logical Table Name | Filamp
Owner |
Definition | Summary information on a filter-amplifier
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
filamp_id |  | NUMERIC(8, 0) | NO | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
name |  | VARCHAR(80) | YES | This attribute denotes a descriptive name for a filter-amplifier
serial_nb |  | VARCHAR(80) | YES | This attribute denotes a serial number of a filter-amplifier
ondate |  | DATE | NO | This attribute denotes the start date
offdate |  | DATE | YES | This attribute denotes the end date
nb_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the number of physical channels of a datalogger
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
Filamp00 | PrimaryKey | filamp_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filamp | Filamp_PChannel | Identifying | filamp_id
Filamp | Station_Filamp | Non-Identifying | filamp_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Filamp_PChannel

EntityType | Dependent
Logical Table Name | Filamp_PChannel
Owner |
Definition | Physical channel of a filter-amplifier
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
filamp_id |  | NUMERIC(8, 0) | NO | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
pchannel_nb |  | NUMERIC(8, 0) | NO | This attribute denotes a physical channel
gain |  | FLOAT | YES | This attribute denotes the gain
frequency |  | FLOAT | YES | The frequency (fs) at which the value in sensitivity/gain is correct
seqresp_id |  | NUMERIC(8, 0) | YES | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
FiP00 | PrimaryKey | filamp_id,pchannel_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filamp | Filamp_PChannel | Identifying | filamp_id
Response | Filamp_PChannel | Non-Specific |

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter

EntityType | Independent
Logical Table Name | Filter
Owner |
Definition | Summary information on a filter
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
filter_id |  | NUMERIC(8, 0) | NO | Filter identifier. Each filter is assigned a unique integer which identifies it in a database
gain |  | FLOAT | YES | This attribute denotes the gain
frequency |  | FLOAT | YES | The frequency (fs) at which the value in sensitivity/gain is correct
in_sp_rate |  | FLOAT | YES | Sampling rate. This attribute is the input sample rate in samples/second
out_sp_rate |  | FLOAT | YES | Sampling rate. This attribute is the output sample rate in samples/second
offset |  | NUMERIC(8, 0) | YES | 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
delay |  | FLOAT | YES | The estimated pure delay for the filter
correction |  | FLOAT | NO | 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
seqresp_id |  | NUMERIC(8, 0) | YES | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
Fi00 | PrimaryKey | filter_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Response | Filter | Non-Specific |
Filter | Filter_Sequence_Data | Non-Identifying | filter_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter_FIR

EntityType | Independent
Logical Table Name | Filter_FIR
Owner |
Definition | Summary information on a FIR filter
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
fir_id |  | NUMERIC(8, 0) | NO | FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database
name |  | VARCHAR(80) | YES | This attribute denotes a descriptive name for a FIR filter
symmetry |  | VARCHAR(1) | NO | This attribute denotes the eventual symmetry of a response
gain |  | FLOAT | YES | This attribute denotes the gain
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
FFIR00 | PrimaryKey | fir_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filter_FIR | Filter_FIR_Data | Identifying | fir_id
Filter_FIR | Response | Non-Identifying | resp_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter_FIR_Data

EntityType | Dependent
Logical Table Name | Filter_FIR_Data
Owner |
Definition | Coefficients of a FIR filter
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
fir_id |  | NUMERIC(8, 0) | NO | FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database
coeff_nb |  | NUMERIC(8, 0) | NO | The numerator/denominator number
type |  | VARCHAR(1) | NO | This attribute denotes whether a value is associated with a numerator/denominator
coefficient |  | FLOAT | NO | The numerator/denominator coefficient value
error |  | FLOAT | YES | This attributes denotes the numerator/denominator error

Keys

Key Name | Key Type | Keys
FFD00 | PrimaryKey | fir_id,coeff_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filter_FIR | Filter_FIR_Data | Identifying | fir_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter_Sequence

EntityType | Independent
Logical Table Name | Filter_Sequence
Owner |
Definition | Summary information on a sequence of filters
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
seqfil_id |  | NUMERIC(8, 0) | NO | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database
name |  | VARCHAR(32) | NO | This attribute denotes a descriptive name for a chain of filters
nb_filter |  | NUMERIC(8, 0) | NO | This attribute denotes the number of filters of a sequence
gain |  | FLOAT | YES | This attribute denotes the gain
frequency |  | FLOAT | YES | The frequency (fs) at which the value in sensitivity/gain is correct
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
FiS00 | PrimaryKey | seqfil_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filter_Sequence | Filter_Sequence_Data | Identifying | seqfil_id
Filter_Sequence | Station_Datalogger_LChannel | Non-Identifying | seqfil_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter_Sequence_Data

EntityType | Dependent
Logical Table Name | Filter_Sequence_Data
Owner |
Definition | Filter of a sequence
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
seqfil_id |  | NUMERIC(8, 0) | NO | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database
filter_nb |  | NUMERIC(8, 0) | NO | This attribute represents the filter number in a sequence
filter_id |  | NUMERIC(8, 0) | NO | Filter identifier. Each filter is assigned a unique integer which identifies it in a database

Keys

Key Name | Key Type | Keys
FiSeD00 | PrimaryKey | seqfil_id,filter_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filter | Filter_Sequence_Data | Non-Identifying | filter_id
Filter_Sequence | Filter_Sequence_Data | Identifying | seqfil_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Response

EntityType | Independent
Logical Table Name | Response
Owner |
Definition | Summary information on a sequence of responses
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
seqresp_id |  | NUMERIC(8, 0) | NO | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
resp_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the response number of a sequence
resp_type |  | VARCHAR(1) | NO | This attribute denotes the response type
resp_id |  | NUMERIC(8, 0) | NO | Response identifier. Each response is assigned a unique integer which identifies it in a database
unit_in |  | NUMERIC(8, 0) | NO | 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
unit_out |  | NUMERIC(8, 0) | NO | 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
r_type |  | VARCHAR(1) | YES | A single character describing the type of response
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
Re00 | PrimaryKey | seqresp_id,resp_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filter_FIR | Response | Non-Identifying | resp_id
Response_HP | Response | Non-Identifying | resp_id
Response_LP | Response | Non-Identifying | resp_id
Response_PN | Response | Non-Identifying | resp_id
Response_PZ | Response | Non-Specific |
Response | Filamp_PChannel | Non-Specific |
Response | Filter | Non-Specific |
Response | Sensor_Component | Non-Specific |

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_HP

EntityType | Independent
Logical Table Name | Response_HP
Owner |
Definition | Summary information on a high-pass filter
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
hp_id |  | NUMERIC(8, 0) | NO | High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database
filter_type |  | VARCHAR(2) | NO | This attribute denotes the type of a high-pass filter
nb_pole |  | NUMERIC(8, 0) | NO | This attribute denotes the number of poles of a high-pass filter
corner_freq |  | FLOAT | NO | This attribute represents the corner frequency of a high-pass filter
damping_value |  | FLOAT | NO | This attribute represents the fraction of critical damping of a high-pass filter
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
RHP00 | PrimaryKey | hp_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Response_HP | Response | Non-Identifying | resp_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_LP

EntityType | Independent
Logical Table Name | Response_LP
Owner |
Definition | Summary information on a low-pass filter
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
lp_id |  | NUMERIC(8, 0) | NO | Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database
filter_type |  | VARCHAR(2) | YES | This attribute denotes the type of a low-pass filter
nb_pole |  | NUMERIC(8, 0) | YES | This attribute denotes the number of poles of a low-pass filter
corner_freq |  | FLOAT | NO | This attribute represents the corner frequency of a low-pass filter
damping_value |  | FLOAT | NO | This attribute represents the fraction of critical damping of a low-pass filter
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
RLP00 | PrimaryKey | lp_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Response_LP | Response | Non-Identifying | resp_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_PN

EntityType | Independent
Logical Table Name | Response_PN
Owner |
Definition | Summary information on a polynomial
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
pn_id |  | NUMERIC(8, 0) | NO | Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database
name |  | VARCHAR(80) | YES | This attribute denotes a descriptive name for a polynomial
poly_type |  | VARCHAR(1) | NO | This attribute represents the type of polynomial approximation
lower_bound |  | FLOAT | YES | This attribute denotes the polynomial lower bound
upper_bound |  | FLOAT | YES | This attribute denotes the polynomial upper bound
max_error |  | FLOAT | YES | This attribute represents the maximum error of polynomial approximation
nb_coeff |  | NUMERIC(8, 0) | YES | This attribute denotes the number of polynomial coefficients
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
RPN00 | PrimaryKey | pn_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Response_PN | Response_PN_Data | Identifying | pn_id
Response_PN | Response | Non-Identifying | resp_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_PN_Data

EntityType | Dependent
Logical Table Name | Response_PN_Data
Owner |
Definition | Coefficients of a polynomial
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
pn_id |  | NUMERIC(8, 0) | NO | Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database
pn_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the coefficient number of a polynomial
pn_value |  | FLOAT | NO | This attribute denotes the coefficient value of a polynomial

Keys

Key Name | Key Type | Keys
RPND00 | PrimaryKey | pn_id,pn_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Response_PN | Response_PN_Data | Identifying | pn_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_PZ

EntityType | Independent
Logical Table Name | Response_PZ
Owner |
Definition | Summary information on poles & zeros
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
pz_id |  | NUMERIC(8, 0) | NO | Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database
pz_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the pole/zero number of a response
type |  | VARCHAR(1) | NO | This attribute denotes whether a value is associated with a pole/zero
r_value |  | FLOAT | NO | The real portion of a complex pole/zero
r_error |  | FLOAT | YES | The error value for the real portion of a complex pole/zero
i_value |  | FLOAT | NO | The imaginary portion of a complex pole/zero
i_error |  | FLOAT | YES | The error value for the imaginary portion of a complex pole/zero
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
RPZ00 | PrimaryKey | pz_id,pz_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Response_PZ | Response | Non-Specific |

Attachments

Name | Datatype | Value Override | Default Value | Description

Sensor

EntityType | Independent
Logical Table Name | Sensor
Owner |
Definition | Summary information on a sensor
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sensor_id |  | NUMERIC(8, 0) | NO | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
name |  | VARCHAR(80) | YES | This attribute denotes a descriptive name for a sensor
serial_nb |  | VARCHAR(80) | YES | This attribute denotes a serial number of a sensor
ondate |  | DATE | NO | This attribute denotes the start date
offdate |  | DATE | YES | This attribute denotes the end date
nb_component |  | NUMERIC(8, 0) | NO | This attribute denotes the number of components of a sensor
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
Sensor00 | PrimaryKey | sensor_id

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Sensor | Sensor_Component | Identifying | sensor_id
Sensor | Station_Sensor | Non-Identifying | sensor_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Sensor_Component

EntityType | Dependent
Logical Table Name | Sensor_Component
Owner |
Definition | Component of a sensor
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sensor_id |  | NUMERIC(8, 0) | NO | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
component_nb |  | NUMERIC(8, 0) | NO | This attribute represents the component number
channel_comp |  | VARCHAR(2) | YES | Component channel
component_type |  | VARCHAR(1) | YES | This attribute denotes the component type
sensitivity |  | FLOAT | NO | This attribute denotes the sensitivity (Sd) for a sensor or a digitizer
frequency |  | FLOAT | YES | The frequency (fs) at which the value in sensitivity/gain is correct
seqresp_id |  | NUMERIC(8, 0) | YES | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
SeC00 | PrimaryKey | sensor_id,component_nb

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Response | Sensor_Component | Non-Specific |
Sensor | Sensor_Component | Identifying | sensor_id

Attachments

Name | Datatype | Value Override | Default Value | Description

Station

EntityType | Independent
Logical Table Name | Station
Owner |
Definition | Summary information on a station
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
ondate |  | DATE | NO | This attribute denotes the start date
lat |  | FLOAT | YES | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
lon |  | FLOAT | YES | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
elev |  | FLOAT | YES | Elevation. This attribute is the elevation of a seismic station relative to mean sea level
staname |  | VARCHAR(50) | YES | Station name/description. This is the full name of the station whose code-name is in sta
nb_sensor |  | NUMERIC(8, 0) | YES | This attribute denotes the number of sensors of a station
nb_filamp |  | NUMERIC(8, 0) | YES | This attribute denotes the number of filter-amplifiers of a station
nb_digi |  | NUMERIC(8, 0) | NO | This attribute denotes the number of digitizers of a station
nb_data |  | NUMERIC(8, 0) | NO | This attribute denotes the number of dataloggers of a station
datumhor |  | VARCHAR(8) | YES | Datum type for horizontal (latitude and longitude) coordinates
datumver |  | VARCHAR(8) | YES | Datum type for depth or elevation
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
St00 | PrimaryKey | sta,net,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Station | Station_Datalogger | Identifying | sta,net,ondate
Station | Station_Digitizer | Identifying | sta,net,ondate
Station | Station_Filamp | Identifying | sta,net,ondate
Station | Station_Sensor | Identifying | sta,net,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Datalogger

EntityType | Dependent
Logical Table Name | Station_Datalogger
Owner |
Definition | Data associating a station with a datalogger
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
data_nb |  | NUMERIC(8, 0) | NO | This attribute represents the datalogger number
ondate |  | DATE | NO | This attribute denotes the start date
data_id |  | NUMERIC(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
nb_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the number of physical channels of a datalogger
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StDa00 | PrimaryKey | sta,net,data_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Datalogger | Station_Datalogger | Non-Identifying | data_id
Station | Station_Datalogger | Identifying | sta,net,ondate
Station_Datalogger | Station_Datalogger_PChannel | Identifying | sta,net,data_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Datalogger_LChannel

EntityType | Dependent
Logical Table Name | Station_Datalogger_LChannel
Owner |
Definition | Summary information on a channel
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
data_nb |  | NUMERIC(8, 0) | NO | This attribute represents the datalogger number
pchannel_nb |  | NUMERIC(8, 0) | NO | This attribute denotes a physical channel
lchannel_nb |  | NUMERIC(8, 0) | NO | This attribute denotes a logical channel of a datalogger
ondate |  | DATE | NO | This attribute denotes the start date
seqfil_id |  | NUMERIC(8, 0) | YES | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database
seedchan |  | VARCHAR(3) | YES | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
channel |  | VARCHAR(3) | YES | Channel name
channelsrc |  | VARCHAR(8) | YES | Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, ...)
location |  | VARCHAR(2) | YES | Describes the individual sites on an array station, operated by the same network operator
rgain |  | FLOAT | YES | This attribute denotes the gain at the response frequency
rfrequency |  | FLOAT | YES | The frequency (fs) at which the value in rgain is correct
samprate |  | FLOAT | NO | Sampling rate. This attribute is the sample rate in samples/second
clock_drift |  | FLOAT | YES | 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
flags |  | VARCHAR(27) | YES | Channel flags
data_format |  | VARCHAR(80) | NO | This attribute represents the data format
comp_type |  | NUMERIC(8, 0) | NO | Compression type. A lookup key that refers to the Format Dictionary
unit_signal |  | NUMERIC(8, 0) | NO | 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
unit_calib |  | NUMERIC(8, 0) | NO | A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps
block_size |  | NUMERIC(8, 0) | NO | The record length of the data
offdate |  | DATE | YES | This attribute denotes the end date
remark |  | VARCHAR(30) | YES | An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StDaL00 | PrimaryKey | sta,net,data_nb,pchannel_nb,lchannel_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filter_Sequence | Station_Datalogger_LChannel | Non-Identifying | seqfil_id
Station_Datalogger_PChannel | Station_Datalogger_LChannel | Identifying | sta,net,data_nb,pchannel_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Datalogger_PChannel

EntityType | Dependent
Logical Table Name | Station_Datalogger_PChannel
Owner |
Definition | Data associating channels
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
data_nb |  | NUMERIC(8, 0) | NO | This attribute represents the datalogger number
pchannel_nb |  | NUMERIC(8, 0) | NO | This attribute denotes a physical channel
ondate |  | DATE | NO | This attribute denotes the start date
board_type |  | VARCHAR(1) | NO | 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)
channel_type |  | VARCHAR(1) | NO | 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, ...)
seed_io |  | VARCHAR(2) | NO | This attribute represents the SEED instrument and orientation
nb_lchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the number of logical channels of a datalogger
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StDaP00 | PrimaryKey | sta,net,data_nb,pchannel_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Station_Datalogger | Station_Datalogger_PChannel | Identifying | sta,net,data_nb,ondate
Station_Datalogger_PChannel | Station_Datalogger_LChannel | Identifying | sta,net,data_nb,pchannel_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Digitizer

EntityType | Dependent
Logical Table Name | Station_Digitizer
Owner |
Definition | Data associating a station with a digitizer
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
digi_nb |  | NUMERIC(8, 0) | NO | This attribute represents the digitizer number
ondate |  | DATE | NO | This attribute denotes the start date
serial_nb |  | VARCHAR(80) | NO | This attribute denotes a serial number of a datalogger board
nb_pri_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the number of primary physical channels of a digitizer
nb_aux_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the number of auxiliary physical channels of a digitizer
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StDi00 | PrimaryKey | sta,net,digi_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Station | Station_Digitizer | Identifying | sta,net,ondate
Station_Digitizer | Datalogger_Board | Non-Specific |
Station_Digitizer | Station_Digitizer_PChannel | Identifying | sta,net,digi_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Digitizer_PChannel

EntityType | Dependent
Logical Table Name | Station_Digitizer_PChannel
Owner |
Definition | Data associating physical channels
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
digi_nb |  | NUMERIC(8, 0) | NO | This attribute represents the digitizer number
pchannel_nb |  | NUMERIC(8, 0) | NO | This attribute denotes a physical channel
ondate |  | DATE | NO | This attribute denotes the start date
data_nb |  | NUMERIC(8, 0) | NO | This attribute represents the datalogger number
data_pchannel |  | NUMERIC(8, 0) | NO | This attribute represents a datalogger physical channel
digi_type |  | VARCHAR(3) | NO | This attribute represents the digitizer type
digi_polarity |  | VARCHAR(1) | NO | This attribute represents the digitizer polarity
digi_channel |  | NUMERIC(8, 0) | NO | This attribute represents a digitizer module on a board
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StDiP00 | PrimaryKey | sta,net,digi_nb,pchannel_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Station_Digitizer | Station_Digitizer_PChannel | Identifying | sta,net,digi_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Filamp

EntityType | Dependent
Logical Table Name | Station_Filamp
Owner |
Definition | Data associating a station with a filter-amplifier
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
filamp_nb |  | NUMERIC(8, 0) | NO | This attribute represents the filter-amplifier number
ondate |  | DATE | NO | This attribute denotes the start date
filamp_id |  | NUMERIC(8, 0) | NO | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
nb_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the number of physical channels of a datalogger
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StFi00 | PrimaryKey | sta,net,filamp_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Filamp | Station_Filamp | Non-Identifying | filamp_id
Station | Station_Filamp | Identifying | sta,net,ondate
Station_Filamp | Station_Filamp_PChannel | Identifying | sta,net,filamp_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Filamp_PChannel

EntityType | Dependent
Logical Table Name | Station_Filamp_PChannel
Owner |
Definition | Data associating physical channels
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
filamp_nb |  | NUMERIC(8, 0) | NO | This attribute represents the filter-amplifier number
pchannel_nb |  | NUMERIC(8, 0) | NO | This attribute denotes a physical channel
ondate |  | DATE | NO | This attribute denotes the start date
next_hard_type |  | VARCHAR(1) | NO | This attribute denotes the next hardware type
next_hard_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the next hardware number
next_hard_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the next hardware physical channel
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StFiP00 | PrimaryKey | sta,net,filamp_nb,pchannel_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Station_Filamp | Station_Filamp_PChannel | Identifying | sta,net,filamp_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Sensor

EntityType | Dependent
Logical Table Name | Station_Sensor
Owner |
Definition | Data associating a station with a sensor
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
sensor_nb |  | NUMERIC(8, 0) | NO | This attribute represents the sensor number
ondate |  | DATE | NO | This attribute denotes the start date
sensor_id |  | NUMERIC(8, 0) | NO | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
lat |  | FLOAT | YES | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
lon |  | FLOAT | YES | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
elev |  | FLOAT | YES | Elevation. This attribute is the elevation of a seismic station relative to mean sea level
edepth |  | FLOAT | YES | Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev
nb_component |  | NUMERIC(8, 0) | NO | This attribute denotes the number of components of a sensor
datumhor |  | VARCHAR(8) | YES | Datum type for horizontal (latitude and longitude) coordinates
datumver |  | VARCHAR(8) | YES | Datum type for depth or elevation
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StSe00 | PrimaryKey | sta,net,sensor_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Sensor | Station_Sensor | Non-Identifying | sensor_id
Station | Station_Sensor | Identifying | sta,net,ondate
Station_Sensor | Station_Sensor_Component | Identifying | sta,net,sensor_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Sensor_Component

EntityType | Dependent
Logical Table Name | Station_Sensor_Component
Owner |
Definition | Data associating physical channels
Note |

Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
sensor_nb |  | NUMERIC(8, 0) | NO | This attribute represents the sensor number
component_nb |  | NUMERIC(8, 0) | NO | This attribute represents the component number
ondate |  | DATE | NO | This attribute denotes the start date
next_hard_type |  | VARCHAR(1) | NO | This attribute denotes the next hardware type
next_hard_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the next hardware number
next_hard_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the next hardware physical channel
azimuth |  | FLOAT | YES | The azimuth of the instrument from north, clockwise
dip |  | FLOAT | YES | The dip of the instrument, down from horizontal
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys

Key Name | Key Type | Keys
StSeC00 | PrimaryKey | sta,net,sensor_nb,component_nb,ondate

Relationships

Parent Entity | Child Entity | Type | Foreign Keys
Station_Sensor | Station_Sensor_Component | Identifying | sta,net,sensor_nb,ondate

Attachments

Name | Datatype | Value Override | Default Value | Description