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.
Event Summary information on an event |
||
Attribute |
Type |
Description |
evid |
int |
Event identifier |
prefor |
int |
Preferred origin |
prefmag |
int |
Preferred magnitude |
prefmec |
int |
Preferred mechanism |
commid |
int |
Comment identifier |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
etype |
char(7) |
Event type |
selectflag |
int |
"Definitive" definition of the event |
version |
int |
Event version number |
lddate |
date |
Load date |
Significant_Event Summary information on a significant event |
||
Attribute |
Type |
Description |
evid |
int |
Event identifier |
evname |
char(80) |
Event name |
remarks |
char(2) |
Event indications (felt, damage, ...) |
nfelt |
int |
Number of felt reports |
mmi |
int |
Maximum MM intensity |
pga |
float |
Peak acceleration |
lddate |
date |
Load date |
Origin Data on event location |
||
Attribute |
Type |
Description |
orid |
int |
Origin identifier |
evid |
int |
Event identifier |
prefmag |
int |
Preferred magnitude |
prefmec |
int |
Preferred mechanism |
commid |
int |
Comment identifier |
bogusflag |
int |
Bogus origin flag |
datetime |
float |
Origin date |
lat |
float |
Estimated latitude |
lon |
float |
Estimated longitude |
depth |
float |
Estimated depth |
type |
char(2) |
Type of location |
algorithm |
char(15) |
Location algorithm used |
algo_assoc |
char(80) |
Associator algorithm used |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
datumhor |
char(8) |
Datum type for latitude & longitude |
datumver |
char(8) |
Datum type for vertical |
gap |
float |
Maximum azimuthal gap of stations |
distance |
float |
Distance to nearest station |
wrms |
float |
Standard error of observations |
stime |
float |
Origin time error |
erhor |
float |
Horizontal error |
sdep |
float |
Depth error |
erlat |
float |
Error in latitude |
erlon |
float |
Error in longitude |
totalarr |
int |
Total number of arrivals |
totalamp |
int |
Total number of amplitude readings |
ndef |
int |
Number of locating phases |
nbs |
int |
Number of S readings |
nbfm |
int |
Number of P first motions |
locevid |
char(12) |
Local event identifier |
quality |
float |
Quality of solution |
fdepth |
char |
Fixed depth |
fepi |
char |
Fixed epicenter |
ftime |
char |
Fixed time |
vmodelid |
int |
Velocity model identifier |
cmodelid |
int |
Crustal model identifier |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |
Origin_Error Error data on event location |
||
Attribute |
Type |
Description |
orid |
int |
Origin identifier |
sxx |
float |
Covariance matrix element |
syy |
float |
Covariance matrix element |
szz |
float |
Covariance matrix element |
stt |
float |
Covariance matrix element |
sxy |
float |
Covariance matrix element |
sxz |
float |
Covariance matrix element |
syz |
float |
Covariance matrix element |
stx |
float |
Covariance matrix element |
sty |
float |
Covariance matrix element |
stz |
float |
Covariance matrix element |
azismall |
float |
Azimuth of smallest principal error |
dipsmall |
float |
Dip of smallest principal error |
magsmall |
float |
Magnitude of smallest principal error |
aziinter |
float |
Azimuth of intermediate principal error |
dipinter |
float |
Dip of intermediate principal error |
maginter |
float |
Magnitude of intermediate principal error |
azilarge |
float |
Azimuth of largest principal error |
diplarge |
float |
Dip of largest principal error |
maglarge |
float |
Magnitude of largest principal error |
lddate |
date |
Load date |
Netmag Summary information on a magnitude |
||
Attribute |
Type |
Description |
magid |
int |
Magnitude identifier |
orid |
int |
Origin identifier |
commid |
int |
Comment identifier |
magnitude |
float |
Magnitude |
magtype |
char(6) |
Magnitude type |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
magalgo |
char(15) |
Magnitude algorithm |
nsta |
int |
Number of stations used |
uncertainty |
float |
Magnitude uncertainty |
gap |
float |
Maximum azimuthal gap of stations |
distance |
float |
Minimum distance of stations |
quality |
float |
Subjective quality |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |
Arrival Summary information on a seismic arrival |
||
Attribute |
Type |
Description |
arid |
int |
Arrival identifier |
commid |
int |
Comment identifier |
datetime |
float |
Pick date |
sta |
char(6) |
Station code |
net |
char(8) |
Network identifier |
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 |
iphase |
char(8) |
Reported phase |
qual |
char |
Signal onset quality |
clockqual |
char |
Clock quality |
clockcorr |
int |
Clock correction |
ccset |
char |
Clock correction set |
fm |
char(2) |
First motion |
ema |
float |
Emergence angle |
azimuth |
float |
Observed azimuth |
slow |
float |
Observed slowness |
deltim |
float |
Delta time |
delinc |
float |
Error in angle |
delaz |
float |
Delta azimuth |
delslo |
float |
Delta slowness |
quality |
float |
Quality |
snr |
float |
Signal to noise ratio |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |
AssocArO Data associating arrivals with origins |
||
Attribute |
Type |
Description |
orid |
int |
Origin identifier |
arid |
int |
Arrival identifier |
commid |
int |
Comment identifier |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
iphase |
char(8) |
Associated phase |
importance |
float |
Importance of phase |
delta |
float |
Station to event distance |
seaz |
float |
Station to event azimuth |
in_wgt |
float |
Input weight |
wgt |
float |
Output weight |
timeres |
float |
Time residual |
azres |
float |
Azimuth residual |
emares |
float |
Incidence angle residual |
slores |
float |
Slowness residual |
vmodelid |
int |
Velocity model identifier |
scorr |
float |
Station correction in seconds |
sdelay |
float |
Station delay |
rflag |
char |
Human/automatic/finalized observation |
ccset |
char |
Clock correction set |
lddate |
date |
Load date |
Amp Summary information on an amplitude reading |
||
Attribute |
Type |
Description |
ampid |
int |
Amplitude identifier |
commid |
int |
Comment identifier |
datetime |
float |
Amplitude date |
sta |
char(6) |
Station code |
net |
char(8) |
Network identifier |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
channel |
char(3) |
Channel name |
channelsrc |
char(8) |
Source of channel name |
seedchan |
char(3) |
SEED channel name |
location |
char(2) |
SEED location |
iphase |
char(8) |
Reported phase |
amplitude |
float |
Amplitude |
amptype |
char(8) |
Amplitude type |
units |
char(4) |
Units of amplitude |
ampmeas |
char |
Amplitude measure |
eramp |
float |
Error in amplitude |
flagamp |
char(4) |
Flag to indicate whether amplitude is over P packet,S packet,entire waveform. |
per |
float |
Period |
snr |
float |
Signal to noise ratio |
tau |
float |
Coda duration (F-P time) |
quality |
float |
Subjective quality |
rflag |
char |
Human/automatic/finalized observation |
cflag |
char(2) |
Clip flag |
wstart |
float |
Start of time window |
duration |
float |
Duration of amplitude reading |
lddate |
date |
Load date |
AssocAmO Data associating amplitudes with origins |
||
Attribute |
Type |
Description |
orid |
int |
Origin identifier |
ampid |
int |
Amplitude identifier |
commid |
int |
Comment identifier |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
delta |
float |
Station to event distance |
seaz |
float |
Station to event azimuth |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |
AssocAmM Data associating amplitudes with magnitudes |
||
Attribute |
Type |
Description |
magid |
int |
Magnitude identifier |
ampid |
int |
Amplitude identifier |
commid |
int |
Comment identifier |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
weight |
float |
Magnitude weight |
in_wgt |
float |
Input weight |
mag |
float |
Magnitude for this station reading |
magres |
float |
Magnitude residual |
magcorr |
float |
Magnitude correction for this station |
importance |
float |
Importance of amplitude |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |
Remark Comments |
||
Attribute |
Type |
Description |
commid |
int |
Comment identifier |
lineno |
int |
Comment line number |
remark |
char(80) |
Free format comment |
lddate |
date |
Load date |
Mec Summary information on a moment tensor |
||
Attribute |
Type |
Description |
mecid |
int |
Mechanism identifier |
oridin |
int |
Origin identifier (input) |
oridout |
int |
Origin identifier (output) |
magid |
int |
Mw magnitude identifier |
commid |
int |
Comment identifier |
mechtype |
char(2) |
Mechanism/moment type |
mecalgo |
char(15) |
Mechanism algorithm |
scalar |
float |
Scalar moment |
erscalar |
float |
Error in scalar moment |
tft |
char(8) |
Time function type |
tfd |
float |
Time function duration |
mxx |
float |
m_xx |
myy |
float |
m_yy |
mzz |
float |
m_zz |
mxy |
float |
m_xy |
mxz |
float |
m_xz |
myz |
float |
m_yz |
smxx |
float |
Uncertainty in m_xx |
smyy |
float |
Uncertainty in m_yy |
smzz |
float |
Uncertainty in m_zz |
smxy |
float |
Uncertainty in m_xy |
smxz |
float |
Uncertainty in m_xz |
smyz |
float |
Uncertainty in m_yz |
srcduration |
float |
Source half-duration |
auth |
char(15) |
Source/origin |
subsource |
char(8) |
Subsystem source |
strike1 |
int |
Strike 1 of best double couple |
dip1 |
int |
Dip 1 of best double couple |
rake1 |
int |
Rake 1 of best double couple |
strike2 |
int |
Strike 2 of best double couple |
dip2 |
int |
Dip 2 of best double couple |
rake2 |
int |
Rake 2 of best double couple |
unstrike1 |
float |
Uncertainty in strike 1 |
undip1 |
float |
Uncertainty in dip 1 |
unrake1 |
float |
Uncertainty in rake 1 |
unstrike2 |
float |
Uncertainty in strike 2 |
undip2 |
float |
Uncertainty in dip 2 |
unrake2 |
float |
Uncertainty in rake 2 |
eigenp |
float |
Eigen pressure |
plungep |
int |
Plunge pressure |
strikep |
int |
Strike pressure |
eigenn |
float |
Eigen null |
plungen |
int |
Plunge null |
striken |
int |
Strike null |
eigent |
float |
Eigen tension |
plunget |
int |
Plunge tension |
striket |
int |
Strike tension |
nsta |
int |
Number of stations used in solution |
pvr |
int |
Percent variance reduction |
quality |
float |
Quality |
pdc |
int |
Percent double couple |
pclvd |
int |
Percent compensated linear vector dipole |
piso |
int |
Percent isotropic |
datetime |
float |
Date solution created |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |
Coda Summary information on a coda |
||
Attribute |
Type |
Description |
coid |
int |
Coda identifier |
commid |
int |
Comment identifier |
sta |
char(6) |
Station code |
net |
char(8) |
Network code |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
channel |
char(3) |
Channel name |
channelsrc |
char(8) |
Source of channel name |
seedchan |
char(3) |
SEED channel name |
location |
char(2) |
SEED location |
codatype |
char(3) |
Coda type |
afix |
float |
Nominal coda amplitude |
afree |
float |
Free amplitude |
qfix |
float |
Fixed coda decay constant |
qfree |
float |
Free decay |
tau |
float |
Coda duration (F-P time) |
nsample |
int |
Number of code sample windows |
rms |
float |
Residual of mean squares for coda fit |
durtype |
char(3) |
Duration type |
iphase |
char(8) |
Reported phase |
eramp |
float |
Error in amplitude |
units |
char(4) |
Units of amplitude |
time1 |
int |
Time for pair 1 |
amp1 |
int |
Amplitude for pair 1 |
time2 |
int |
Time for pair 2 |
amp2 |
int |
Amplitude for pair 2 |
time3 |
int |
Time for pair 3 |
amp3 |
int |
Amplitude for pair 3 |
time4 |
int |
Time for pair 4 |
amp4 |
int |
Amplitude for pair 4 |
time5 |
int |
Time for pair 5 |
amp5 |
int |
Amplitude for pair 5 |
time6 |
int |
Time for pair 6 |
amp6 |
int |
Amplitude for pair 6 |
quality |
float |
Subjective quality |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |
AssocCoM Data associating codas with magnitudes |
||
Attribute |
Type |
Description |
magid |
int |
Magnitude identifier |
coid |
int |
Coda identifier |
commid |
int |
Comment identifier |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
weight |
float |
Magnitude weight |
in_wgt |
float |
Input weight |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |
AssocCoO Data associating codas with origins |
||
Attribute |
Type |
Description |
orid |
int |
Origin identifier |
coid |
int |
Coda identifier |
commid |
int |
Comment identifier |
auth |
char(15) |
Source/originator |
subsource |
char(8) |
Subsystem source |
rflag |
char |
Human/automatic/finalized observation |
lddate |
date |
Load date |