Database Tables
tables | SQL syntax
Table names are in Uppercase and fields are listed below the table names. This is a relational database, therefore fields from one table can be related to fields in one or many tables.
| GDV_NETWORK | Network Information |
|---|---|
| Network_Code | |
| Network_Abbreviation | |
| Network_Full_Name | |
| GDV_STATION | Station Information |
|---|---|
| Network_Code | |
| Station_Code | |
| Station_Start_Date_Time | |
| Station_End_Date_Time | |
| Station_Latitude | |
| Station_Longitude | |
| Station_Elevation | |
| Station_Site | |
| GDV_CHANNEL | Channel Information |
|---|---|
| Network_Code | |
| Station_Code | |
| Channel_Code | |
| Location_Code | |
| Channel_Start_Date_Time | |
| Channel_End_Date_Time | |
| Channel_Maximum_Drift | |
| Channel_Sampling_Rate | |
| Channel_Flags | |
| Channel_Latitude | |
| Channel_Longitude | |
| Channel_Elevation | |
| Channel_Depth | |
| Channel_Azimuth | |
| Channel_Dip | |
| Channel_Sensor_Type | |
| Channel_Site | |
| GDV_CHANNEL_SUMMARY | Waveform/Channel Information |
|---|---|
| Network_Code | |
| Station_Code | |
| Channel_Code | |
| Location_Code | |
| Earliest_Waveform | |
| Latest_Waveform | |
| GDV_WAVEFORM | Waveform Information |
|---|---|
| Network_Code | |
| Station_Code | |
| Channel_Code | |
| Location_Code | |
| Waveform_Start_Date_Time | |
| Waveform_End_Date_Time | |
| GDV_STATION_COMMENT | Station Comment Information |
|---|---|
| Network_Code | |
| Station_Code | |
| Station_C_Start_Date_Time | |
| Station_C_End_Date_Time | |
| Station_Comment_Text | |
| GDV_CHANNEL_COMMENT | Channel Comment Information |
|---|---|
| Network_Code | |
| Station_Code | |
| Channel_Code | |
| Location_Code | |
| Channel_C_Start_Date_Time | |
| Channel_C_End_Date_Time | |
| Channel_Comment_Text | |