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.

Station_Data Summary information on a station

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

lat

float

Latitude

lon

float

Longitude

elev

float

Elevation

staname

char(50)

Station description

net_id

int

Network identifier code

word_32

int

32 bit word order

word_16

int

16 bit word order

ondate

date

Start date

offdate

date

Off date

lddate

date

Load date

Station_Comment Comments for a station

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

ondate

date

Start date

offdate

date

Off date

comment_id

int

Comment code key

comment_level

int

Comment level

lddate

date

Load date

 

Channel_Data Summary information on a channel

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

seedchan

char(3)

SEED channel name

channel

char(3)

Channel name

channelsrc

char(8)

Domain of channel name

location

char(2)

SEED location

inid

int

Instrument identifier

remark

char(30)

Optional comment

unit_signal

int

Units of signal responses

unit_calib

int

Units of calibration input

lat

float

Latitude

lon

float

Longitude

elev

float

Elevation

edepth

float

Emplacement depth

azimuth

float

Azimuth

dip

float

Dip

format_id

int

Data format identifier code

record_length

int

Data record length

samprate

float

Sampling rate

clock_drift

float

Maximum clock drift

flags

char(27)

SEED channel flags

ondate

date

Start date

offdate

date

Off date

lddate

date

Load date

 

Channel_Comment Comments for a channel

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

seedchan

char(3)

SEED channel name

channel

char(3)

Channel name

channelsrc

char(8)

Domain of channel name

location

char(2)

SEED location

ondate

date

Start date

offdate

date

Off date

comment_id

int

Comment code key

comment_level

float

Comment level

lddate

date

Load date

 

Polynomial Data associating a channel with a polynomial

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

seedchan

char(3)

SEED channel name

channel

char(3)

Channel name

channelsrc

char(8)

Domain of channel name

location

char(2)

SEED location

ondate

date

Start date

offdate

date

Off date

stage_seq

int

Stage sequence

pn_key

int

Response (Polynomial) key

unit_in

int

Signal input units

unit_out

int

Signal output units

tf_type

char(1)

Response type

lddate

date

Load date

 

PN Summary information on a response (Polynomial)

Attribute

Type

Description

key

int

Response (coefficients) key

name

char(80)

Response (Coefficients) 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.

lddate

date

Load date

 

PN_Data Coefficients of a polynomial

Attribute

Type

Description

key

int

Response (Coefficients) key

row_key

int

Row key

pn_value

float

Coefficient value

 

Coefficients Data associating a channel with a response

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

seedchan

char(3)

SEED channel name

channel

char(3)

Channel name

channelsrc

char(8)

Domain of channel name

location

char(2)

SEED location

ondate

date

Start date

offdate

date

Off date

stage_seq

int

Stage sequence

dc_key

int

Response (Coefficients) key

unit_in

int

Signal input units

unit_out

int

Signal output units

tf_type

char(1)

Response type

lddate

date

Load date

 

DC Summary information on a response (Coefficients)

Attribute

Type

Description

key

int

Response (coefficients) key

name

char(80)

Response (Coefficients) name

symmetry

char(1)

Symmetry code

storage

char(1)

Storage flag (Half/Full)

lddate

date

Load date

 

DC_Data Coefficients of a response

Attribute

Type

Description

key

int

Response (Coefficients) key

row_key

int

Row key

type

char(1)

Numerator/Denominator

coefficient

float

Numerator/denominator coefficient

error

float

Numerator/denominator error

 

Decimation Data associating a channel with a decimation

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

seedchan

char(3)

SEED channel name

channel

char(3)

Channel name

channelsrc

char(8)

Domain of channel name

location

char(2)

SEED location

ondate

date

Start date

offdate

date

Off date

stage_seq

int

Stage sequence

dm_key

int

Decimation key

lddate

date

Load date

 

DM Summary information on a decimation

Attribute

Type

Description

key

int

Decimation key

name

char(80)

Decimation name

samprate

float

Input sampling rate

factor

int

Decimation factor

offset

int

Decimation offset

delay

float

Estimated delay

correction

float

Correction applied

lddate

date

Load date

 

Poles_Zeros Data associating a channel with poles & zeros

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

seedchan

char(3)

SEED channel name

channel

char(3)

Channel name

channelsrc

char(8)

Domain of channel name

location

char(2)

SEED location

ondate

date

Start date

offdate

date

Off date

stage_seq

int

Stage sequence

pz_key

int

Poles & zeros key

tf_type

char(1)

Transfer function type

unit_in

int

Stage signal input units

unit_out

int

Stage signal output units

AO

float

AO normalization factor (1.0 if none)

AF

float

Normalization frequency

lddate

date

Load date

 

PZ Summary information on a response (Poles & Zeros)

Attribute

Type

Description

key

int

Poles & zeros key

name

char(80)

Poles & zeros name

lddate

date

Load date

 

PZ_Data Poles & zeros of a response

Attribute

Type

Description

key

int

Poles & zeros key

row_key

int

Row key

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

 

Sensitivity Data associating a channel with a sensitivity

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

seedchan

char(3)

SEED channel name

channel

char(3)

Channel name

channelsrc

char(8)

Domain of channel name

location

char(2)

SEED location

ondate

date

Start date

offdate

date

Off date

stage_seq

int

Stage sequence

sensitivity

float

Sensitivity/gain (Sd)

frequency

float

Frequency (Fs)

lddate

date

Load date

 

D_Abbreviation Abbreviation dictionary

Attribute

Type

Description

id

int

Abbreviation lookup code

description

char(70)

Abbreviation description

 

D_Unit Unit dictionary

Attribute

Type

Description

id

int

Unit lookup code

name

char(80)

Unit name

description

char(70)

Unit description

 

D_Comment Comment dictionary

Attribute

Type

Description

id

int

Comment code key

class

char(1)

Comment class code

description

char(70)

Description of comment

unit

int

Units of comment level

 

D_Format Format dictionary

Attribute

Type

Description

id

int

Data format identifier code

ms_id

int

MiniSEED identifier

name

char(80)

descriptive name

family

int

Unit family type

 

D_Format_Data Format data

Attribute

Type

Description

id

int

Data format identifier code

row_id

int

Row identifier

key_d

char(80)

Decoder key

 

Simple_Response Summary information on a simplified response

Attribute

Type

Description

net

char(8)

Network code

sta

char(6)

Station code

seedchan

char(3)

SEED channel name

location

char(2)

SEED location

frequency

float

Frequency (Fs)

damping_constant

float

Damping constant

gain

float

Gain

gain_units

char(20)

Units of gain

ml_corr

float

Correction for local magnitude

ml_flag

char(1)

Flag for state of ml_corr

me_corr

float

Correction for energy magnitude

me_flag

char(1)

Flag for state of me_corr

noise_flag

char(1)

Flag for noise level

ondate

date

Start date

offdate

date

Off date

lddate

date

Load date