Station_Data

Logical Entity Name | Station_Data
Default Table Name | Station_Data
Definition | Summary information on a station

Station_Data Columns

ColumnName | Domain | Datatype | NULL | Definition
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
ondate |  | DATE | NO | This attribute denotes the start date
lat |  | BINARY_FLOAT | YES | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
lon |  | BINARY_FLOAT | YES | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
elev |  | BINARY_FLOAT | YES | Elevation. This attribute is the elevation of a seismic station relative to mean sea level
staname |  | VARCHAR2(60) | YES | Station name/description. This is the full name of the station whose code-name is in sta
net_id |  | NUMBER(8, 0) | YES | The abbreviation lookup code from the Generic Abbreviation Dictionary, that refers to the network to which the station belongs
word_32 |  | NUMBER(8, 0) | NO | The swap order in which 32-bit quantities are specified in the data headers
word_16 |  | NUMBER(8, 0) | NO | 16-bit quantity byte swapping order, for the data headers only
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Station_Data Primary and Unique Keys

Key Name | Key Type | Keys
StD00 | PrimaryKey | net, sta, ondate

Station_Data Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
D_Abbreviation | Non-Identifying | Zero or One to Zero or More | Sta_Dat_D_Abb |  |  | net_id | NO | NO | NO

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred
Channel_Data | Identifying | One To Zero or More | Cha_Dat_Sta_Dat |  |  |  | NO | NO | NO
Station_Comment | Identifying | One To Zero or More | Sta_Com_Sta_Dat |  |  |  | NO | NO | NO

Station_Data Check Constraints

Check Constraint Name | CheckConstraint
StD02 | lat >= -90.0 AND lat <= 90.0
StD03 | lon >= -180.0 AND lon <= 180.0