Search

Latest News

Volcanic Activity Report

Random Picture

Common Tables

  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  
         

Last Updated on 1/12/2004
By chris newhall