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 |