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(PK) 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(PK)(FK) NUMERIC(8, 0) NO Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
board_nb(PK) 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(PK)(FK) NUMERIC(8, 0) NO Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
board_nb(PK)(FK) NUMERIC(8, 0) NO This attribute denotes the number of boards of a datalogger
module_nb(PK) 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(PK) 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(PK)(FK) NUMERIC(8, 0) NO Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
pchannel_nb(PK) 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(PK) 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(PK) 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(PK)(FK) NUMERIC(8, 0) NO FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database
coeff_nb(PK) 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(PK) 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(PK)(FK) 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(PK) NUMERIC(8, 0) NO This attribute represents the filter number in a sequence
filter_id(FK) 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(PK) 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(PK) 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(FK) 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(PK) 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(PK) 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(PK) 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(PK)(FK) NUMERIC(8, 0) NO Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database
pn_nb(PK) 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(PK) 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(PK) 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(PK) 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(PK)(FK) NUMERIC(8, 0) NO Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
component_nb(PK) 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(PK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
ondate(PK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
data_nb(PK) NUMERIC(8, 0) NO This attribute represents the datalogger number
ondate(PK)(FK) DATE NO This attribute denotes the start date
data_id(FK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
data_nb(PK)(FK) NUMERIC(8, 0) NO This attribute represents the datalogger number
pchannel_nb(PK)(FK) NUMERIC(8, 0) NO This attribute denotes a physical channel
lchannel_nb(PK) NUMERIC(8, 0) NO This attribute denotes a logical channel of a datalogger
ondate(PK)(FK) DATE NO This attribute denotes the start date
seqfil_id(FK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
data_nb(PK)(FK) NUMERIC(8, 0) NO This attribute represents the datalogger number
pchannel_nb(PK) NUMERIC(8, 0) NO This attribute denotes a physical channel
ondate(PK)(FK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
digi_nb(PK) NUMERIC(8, 0) NO This attribute represents the digitizer number
ondate(PK)(FK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
digi_nb(PK)(FK) NUMERIC(8, 0) NO This attribute represents the digitizer number
pchannel_nb(PK) NUMERIC(8, 0) NO This attribute denotes a physical channel
ondate(PK)(FK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
filamp_nb(PK) NUMERIC(8, 0) NO This attribute represents the filter-amplifier number
ondate(PK)(FK) DATE NO This attribute denotes the start date
filamp_id(FK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
filamp_nb(PK)(FK) NUMERIC(8, 0) NO This attribute represents the filter-amplifier number
pchannel_nb(PK) NUMERIC(8, 0) NO This attribute denotes a physical channel
ondate(PK)(FK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
sensor_nb(PK) NUMERIC(8, 0) NO This attribute represents the sensor number
ondate(PK)(FK) DATE NO This attribute denotes the start date
sensor_id(FK) 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(PK)(FK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net(PK)(FK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
sensor_nb(PK)(FK) NUMERIC(8, 0) NO This attribute represents the sensor number
component_nb(PK) NUMERIC(8, 0) NO This attribute represents the component number
ondate(PK)(FK) 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