NCEDC

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
board_type	char(1)	Board type
channel_type	char(1)	Channel type
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