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

Station_Data Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
net(PK)    VARCHAR(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sta(PK)    VARCHAR(6)  NO  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
ondate(PK)    DATE  NO  This attribute denotes the start date 
lat    FLOAT  YES  Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes 
lon    FLOAT  YES  Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian 
elev    FLOAT  YES  Elevation. This attribute is the elevation of a seismic station relative to mean sea level 
staname    VARCHAR(60)  YES  Station name/description. This is the full name of the station whose code-name is in sta 
net_id(FK)    NUMERIC(8, 0)  YES  The abbreviation lookup code from the Generic Abbreviation Dictionary, that refers to the network to which the station belongs 
word_32    NUMERIC(8, 0)  NO  The swap order in which 32-bit quantities are specified in the data headers 
word_16    NUMERIC(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 Keys 
Key Name  Key Type  Keys 
StD00  PrimaryKey  net, sta, ondate 

Station_Data Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
D_Abbreviation  Non-Identifying  Zero or One to Zero or More        net_id  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Channel_Data  Identifying  One To Zero or More          NO 
Station_Comment  Identifying  One To Zero or More          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