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.

Waveform Summary information on a waveform

Attribute

Type

Description

wfid

int

Waveform identifier

net

char(8)

Network code

sta

char(6)

Station code

auth

char(15)

Source/originator

subsource

char(8)

Subsystem source

channel

char(3)

Channel name

channelsrc

char(8)

Domain of channel name

seedchan

char(3)

SEED channel name

location

char(2)

SEED location

archive

char(8)

Location of seismogram archive

datetime_on

float

Start time

datetime_off

float

End time

samprate

float

Sampling rate (samples/sec)

wavetype

char(1)

Type of waveform (cont., triggered, …)

fileid

int

Filename identifier

foff

int

Pointer to simple data

nbytes

int

Number of bytes of data portion in trace

traceoff

int

Pointer to the beginning of the trace

tracelen

int

Length in bytes of the entire trace

status

char(1)

Status (Empty, Temp, Archive)

wave_fmt

int

Waveform format type

format_id

int

Format of data (Steim-1, …)

wordorder

int

Word order

recordsize

int

Record size for data

locevid

char(12)

Local event identifier

lddate

date

Load date

AssocWaE Data associating waveforms with events

Attribute

Type

Description

wfid

int

Waveform identifier

evid

int

Event identifier

datetime_on

float

Start time of waveform association

datetime_off

float

End time of waveform association

lddate

date

Load date

 

Filename Summary information on a waveform filenames

Attribute

Type

Description

fileid

int

Filename identifier

dfile

char(32)

Data file

datetime_on

float

Start time

datetime_off

float

End time

nbytes

int

File size

lddate

date

Load date