|
COMMON TABLES |
|
|
|
Attribute |
Attribute Name |
Description |
Format |
Units |
|
|
|
|
|
Bibliographic Table |
|
|
|
|
cb_id |
reference ID |
An identifier for linking with other tables |
mediumint |
|
cb_auth |
Authors/Editors |
The authors or editors |
text |
|
cb_year |
Publication yr |
The publication year |
text |
|
cb_title |
Title |
The title of the paper or book. |
text |
|
cb_journ |
Journal |
The name of the journal |
text |
|
cb_vol |
Volume |
The journal volume |
text |
|
cb_page |
Pages |
The page numbers |
text |
|
cb_pub |
Publisher |
The name of the publisher (book only) |
text |
|
cb_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Standard Instrument Table |
|
|
|
|
ci_id |
ID |
An identifier for linking with other tables |
mediumint |
|
ci_name |
name |
The name of the instrument |
text |
|
ci_type |
type |
The type of instrument |
text |
|
ci_man |
manufacturer |
The manufacturer of the instrument |
text |
|
ci_mod |
model |
The model of the instrument. |
text |
|
ci_pres |
resolution |
Typical instrumental measuring precision |
xxx.xxx |
units |
ci_units |
measured units |
The units the instrument measures. |
text |
|
ci_sigt |
signal to noise |
An instrument specific signal to noise ratio. |
xxx |
|
ci_desc |
description |
Description of instrument |
varchar(255) |
|
ci_comm |
comments |
Comments on the instrument |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking with the person or group of people who use this instrument. |
mediumint |
|
ci_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Standard Contact Table |
|
|
|
|
cc_id |
ID |
An identifier for linking with other tables |
mediumint |
|
cc_fname |
first name |
First name |
text |
|
cc_lname |
last name |
Last name |
text |
|
cc_obs |
observatory |
The name of the observatory or company |
text |
|
cc_add1 |
address1 |
First line of the address |
text |
|
cc_add2 |
address2 |
Second line of the address |
text |
|
cc_city |
city |
City |
text |
|
cc_stat |
state |
State |
text |
|
cc_coun |
Country |
Country |
text |
|
cc_post |
postal code |
postal code |
text |
|
cc_web |
web address |
web address |
text |
|
cc_email |
email |
email |
text |
|
cc_phon |
phone |
Primary phone number |
text |
|
cc_phon2 |
phone 2 |
Secondary phone number |
text |
|
cc_fax |
fax |
Fax |
text |
|
cc_usrname |
username |
A username for logging into the system (not required for read only access) |
text |
|
cc_pwd |
pwd |
A password for logging into the system (not required for read only access) |
text |
|
cc_regdate |
register date |
The date the information was originally entered |
datetime |
|
cc_comm |
comments |
comments |
text |
|
|
|
|
|
|
Network Table |
|
|
|
|
cn_id |
network id |
An identifier for linking with other tables |
mediumint |
|
cn_name |
network name |
The name of the network |
text |
|
vd_vol_id |
volcano id |
An identifier for linking with the volcano table. |
mediumint |
|
cn_type |
network type |
Network type, e.g., seismic, gravity, diffuse CO2, etc |
text |
|
cn_area |
area |
The volcano and/or area covered by the network. |
varchar(100) |
|
cn_map |
network map |
Observatory map of network |
image |
|
cn_desc |
description |
A description of the network |
varchar(255) |
|
cn_comm |
comments |
Comments about the network |
varchar(255) |
|
cn_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Satellite Table |
|
|
|
|
cs_id |
satellite id |
An identifier for linking with other tables |
mediumint |
|
cs_name |
satellite name |
The name of the satellite |
text |
|
cs_desc |
satellite description |
A description of the satellite |
memo |
|
cs_comm |
comments |
Comments about the satellite |
memo |
|
cs_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
InstrumentStation Relationship Table |
|
Relates multiple instruments at multiple stations; need one for every station table |
|
|
jj_inst_id |
instrumentstation id |
An identifier for linking with other tables |
mediumint |
|
ci_id |
instrument id |
An identifier for linking with the instrument table |
integer |
|
|
station id |
An identifier for linking with the station table |
integer |
|
jj_inst_est |
install date |
The date the instrument was installed at the station |
datetime |
|
ii_inst_dest |
instrument stop date |
The date the instrument ceased operation at the station |
datetime |
|
jj_inst_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
VolcanoNetwork Relationship Table |
|
|
|
|
jj_volnet_id |
volcano-network id |
An identifier for linking with other tables |
mediumint |
|
vd_vol_id |
volcano id |
An identifier for linking with the volcano table. |
mediumint |
|
cn_id |
network id |
An identifier for linking with the network table. |
mediumint |
|
sn_net_id |
seismic network id |
An identifier for linking with the seismic network table. |
mediumint |
|
jj_volnet_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|