Database structure
This chapter defines the physical structure of each table, as it exists within the DBMS data dictionary. The name of the relation appears in bold print at the top left and a description of the table at the top right. Bold attributes represent primary keys, italic attributes represent foreign keys, and underlined attributes stand for CSS attributes.
Response Summary information on a sequence of responses |
||
Attribute |
Type |
Description |
seqresp_id |
int |
Sequence of responses identifier |
resp_nb |
int |
Response number |
resp_type |
char(1) |
Response type |
resp_id |
int |
Response identifier |
unit_in |
int |
Signal input units |
unit_out |
int |
Signal output units |
r_type |
char(1) |
SEED response type |
lddate |
date |
Load date |
Response_HP Summary information on a high-pass filter |
||
Attribute |
Type |
Description |
hp_id |
int |
Filter identifier |
filter_type |
char(2) |
Filter type |
nb_pole |
int |
Number of poles |
corner_freq |
float |
Corner frequency of filter |
damping_value |
float |
Fraction of critical damping |
lddate |
date |
Load date |
Response_LP Summary information on a low-pass filter |
||
Attribute |
Type |
Description |
lp_id |
int |
Filter identifier |
filter_type |
char(2) |
Filter type |
nb_pole |
int |
Number of poles |
corner_freq |
float |
Corner frequency of filter |
damping_value |
float |
Fraction of critical damping |
lddate |
date |
Load date |
Response_PZ Summary information on poles & zeros |
||
Attribute |
Type |
Description |
pz_id |
int |
Poles & zeros identifier |
pz_nb |
int |
Pole/zero number |
type |
char(1) |
Pole/Zero |
r_value |
float |
Real pole/zero |
r_error |
float |
Real pole/zero error |
i_value |
float |
Imaginary pole/zero |
i_error |
float |
Imaginary pole/zero error |
lddate |
date |
Load date |
Response_PN Summary information on a polynomial |
||
Attribute |
Type |
Description |
pn_id |
int |
Polynomial identifier |
name |
char(80) |
Polynomial name |
poly_type |
char(1) |
Type of polynomial approximation |
lower_bound |
float |
Polynomial lower bound |
upper_bound |
float |
Polynomial upper bound |
max_error |
float |
Maximum error of polynomial approx. |
nb_coeff |
int |
Number of polynomial coefficients |
lddate |
date |
Load date |
Response_PN_Data Coefficients of a polynomial |
||
Attribute |
Type |
Description |
pn_id |
int |
Polynomial identifier |
pn_nb |
int |
Coefficient number |
pn_value |
float |
Coefficient value |
Sensor Summary information on a sensor |
||
Attribute |
Type |
Description |
sensor_id |
int |
Sensor identifier |
name |
char(80) |
Sensor name |
serial_nb |
char(80) |
Sensor serial number |
ondate |
date |
Start date |
offdate |
date |
Off date |
nb_component |
int |
Number of components |
lddate |
date |
Load date |
Sensor_Component Component of a sensor |
||
Attribute |
Type |
Description |
sensor_id |
int |
Sensor identifier |
component_nb |
int |
Component number |
channel_comp |
char(2) |
Channel |
component_type |
char(1) |
Type |
sensitivity |
float |
Sensitivity |
frequency |
float |
Frequency |
seqresp_id |
int |
Sequence of responses identifier |
lddate |
date |
Load date |
Filamp Summary information on a filter-amplifier |
||
Attribute |
Type |
Description |
filamp_id |
int |
Filter-amplifier identifier |
name |
char(80) |
Filter-amplifier name |
serial_nb |
char(80) |
Filter-amplifier serial number |
ondate |
date |
Start date |
offdate |
date |
Off date |
nb_pchannel |
int |
Number of physical channels |
lddate |
date |
Load date |
Filamp_PChannel Physical channel of a filter-amplifier |
||
Attribute |
Type |
Description |
filamp_id |
int |
Filter-amplifier identifier |
pchannel_nb |
int |
Physical channel number |
gain |
float |
Gain |
frequency |
float |
Calibration frequency |
seqresp_id |
int |
Sequence of responses identifier |
lddate |
date |
Load date |
Datalogger Summary information on a datalogger |
||
Attribute |
Type |
Description |
data_id |
int |
Datalogger identifier |
data_type |
char(80) |
Datalogger type |
serial_nb |
char(80) |
Datalogger serial number |
firmware_nb |
char(80) |
Datalogger firmware number |
software |
char(80) |
Software (ushear, mshear, …) |
software_nb |
char(80) |
Software version number |
ondate |
date |
Start date |
offdate |
date |
Off date |
nb_board |
int |
Number of boards |
word_32 |
int |
32 bit word order |
word_16 |
int |
16 bit word order |
lddate |
date |
Load date |
Datalogger_Board Board of a datalogger |
||
Attribute |
Type |
Description |
data_id |
int |
Datalogger identifier |
board_nb |
int |
Board number |
serial_nb |
char(80) |
Board serial number |
nb_module |
int |
Number of modules |
lddate |
date |
Load date |
Datalogger_Module Module of a datalogger’s board |
||
Attribute |
Type |
Description |
data_id |
int |
Datalogger identifier |
board_nb |
int |
Board number |
module_nb |
int |
Module number |
serial_nb |
char(80) |
Module serial number |
sensitivity |
float |
Sensitivity |
lddate |
date |
Load date |
Filter_FIR Summary information on a FIR filter |
||
Attribute |
Type |
Description |
fir_id |
int |
FIR filter identifier |
name |
char(80) |
Filter name |
symmetry |
char(1) |
Filter symmetry |
gain |
float |
Filter gain |
lddate |
date |
Load date |
Filter_FIR_Data Coefficients of a FIR filter |
||
Attribute |
Type |
Description |
fir_id |
int |
FIR filter identifier |
coeff_nb |
int |
Numerator/denominator number |
type |
char(1) |
Numerator/Denominator |
coefficient |
float |
Numerator/denominator coefficient |
error |
float |
Numerator/denominator error |
Filter Summary information on a filter |
||
Attribute |
Type |
Description |
filter_id |
int |
Filter identifier |
gain |
float |
Filter gain |
frequency |
float |
Frequency for filter gain |
in_sp_rate |
float |
Input sample rate |
out_sp_rate |
float |
Output sample rate |
offset |
int |
Decimation offset |
delay |
float |
Estimated delay |
correction |
float |
Correction applied |
seqresp_id |
int |
Sequence of responses identifier |
lddate |
date |
Load date |
Filter_Sequence Summary information on a sequence of filters |
||
Attribute |
Type |
Description |
seqfil_id |
int |
Sequence of filters identifier |
name |
char(32) |
Sequence of filters name |
nb_filter |
int |
Number of filters |
gain |
float |
Overall gain |
frequency |
float |
Frequency |
lddate |
date |
Load date |
Filter_Sequence_Data Filter of a sequence |
||
Attribute |
Type |
Description |
seqfil_id |
int |
Sequence of filters identifier |
filter_nb |
int |
Filter number |
filter_id |
int |
Filter identifier |
Station Summary information on a station |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
lat |
float |
Latitude |
lon |
float |
Longitude |
elev |
float |
Elevation |
staname |
char(50) |
Station description |
nb_sensor |
int |
Number of sensors |
nb_filamp |
int |
Number of filter-amplifiers |
nb_digi |
int |
Number of digitizers |
nb_data |
int |
Number of dataloggers |
datumhor |
char(8) |
Datum type for latitude and longitude |
datumver |
char(8) |
Datum type for vertical |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Sensor Data associating a station with a sensor |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
sensor_nb |
int |
Sensor number |
sensor_id |
int |
Sensor identifier |
lat |
float |
Latitude |
lon |
float |
Longitude |
elev |
float |
Elevation |
edepth |
float |
Emplacement depth |
nb_component |
int |
Number of components |
datumhor |
char(8) |
Datum type for latitude and longitude |
datumver |
char(8) |
Datum type for vertical |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Sensor_Component Data associating physical channels |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
sensor_nb |
int |
Sensor number |
component_nb |
int |
Component number |
next_hard_type |
char(1) |
Next hardware type |
next_hard_nb |
int |
Next hardware number |
next_hard_pchannel |
int |
Next hardware physical channel |
azimuth |
float |
Azimuth |
dip |
float |
Dip |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Filamp Data associating a station with a filter-amplifier |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
filamp_nb |
int |
Filter-amplifier number |
filamp_id |
int |
Filter-amplifier identifier |
nb_pchannel |
int |
Number of physical channels |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Filamp_PChannel Data associating physical channels |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
filamp_nb |
int |
Filter-amplifier number |
pchannel_nb |
int |
Physical channel number |
next_hard_type |
char(1) |
Next hardware type |
next_hard_nb |
int |
Next hardware number |
next_hard_pchannel |
int |
Next hardware physical channel |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Digitizer Data associating a station with a digitizer |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
digi_nb |
int |
Digitizer number |
serial_nb |
char(80) |
Digitizer serial number |
nb_pri_pchannel |
int |
Number of primary physical channels |
nb_aux_pchannel |
int |
Number of auxiliary physical channels |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Digitizer_PChannel Data associating physical channels |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
digi_nb |
int |
Digitizer number |
pchannel_nb |
int |
Physical channel number |
data_nb |
int |
Datalogger number |
data_pchannel |
int |
Datalogger physical channel |
digi_type |
char(3) |
Digitizer type |
digi_polarity |
char(1) |
Digitizer polarity |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Datalogger Data associating a station with a datalogger |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
data_nb |
int |
Datalogger number |
data_id |
int |
Datalogger identifier |
nb_pchannel |
int |
Number of physical channels |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Datalogger_PChannel Data associating channels |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
data_nb |
int |
Datalogger number |
pchannel_nb |
int |
Physical channel number |
seed_io |
char(2) |
SEED instrument and orientation |
nb_lchannel |
int |
Number of logical channels |
ondate |
date |
Start date |
offdate |
date |
Off date |
lddate |
date |
Load date |
Station_Datalogger_LChannel Summary information on a channel |
||
Attribute |
Type |
Description |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
data_nb |
int |
Datalogger number |
pchannel_nb |
int |
Physical channel number |
lchannel_nb |
char(2) |
Logical channel number |
seqfil_id |
int |
Sequence of filters identifier |
seedchan |
char(3) |
SEED channel name |
channel |
char(3) |
Channel name |
channelsrc |
char(8) |
Domain of channel name |
location |
char(2) |
SEED location |
rgain |
float |
Gain at the response frequency |
rfrequency |
float |
Frequency for response |
samprate |
float |
Sampling rate |
clock_drift |
float |
Maximum clock drift |
flags |
char(27) |
SEED channel flags |
data_format |
char(80) |
Data format |
comp_type |
int |
Compression type |
unit_signal |
int |
Units of signal responses |
unit_calib |
int |
Units of calibration |
block_size |
int |
Block size |
ondate |
date |
Start date |
offdate |
date |
Off date |
remark |
char(30) |
Optional comment |
lddate |
date |
Load date |