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