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

Station Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
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 
net(PK)    VARCHAR(8)  NO  Unique network identifier. This character string is the name of a seismic network 
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 
nb_sensor    NUMERIC(8, 0)  YES  This attribute denotes the number of sensors of a station 
nb_filamp    NUMERIC(8, 0)  YES  This attribute denotes the number of filter-amplifiers of a station 
nb_digi    NUMERIC(8, 0)  NO  This attribute denotes the number of digitizers of a station 
nb_data    NUMERIC(8, 0)  NO  This attribute denotes the number of dataloggers of a station 
datumhor    VARCHAR(8)  YES  Datum type for horizontal (latitude and longitude) coordinates 
datumver    VARCHAR(8)  YES  Datum type for depth or elevation 
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 Keys 
Key Name  Key Type  Keys 
St00  PrimaryKey  sta, net, ondate 

Station Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Station_Datalogger  Identifying  One To Zero or More          NO 
Station_Digitizer  Identifying  One To Zero or More          NO 
Station_Filamp  Identifying  One To Zero or More          NO 
Station_Sensor  Identifying  One To Zero or More          NO 

Station Check Constraints 
Check Constraint Name  CheckConstraint 
St01  datumhor IN ('NAD27','WGS84') 
St02  datumver IN ('NAD27','WGS84','AVERAGE') 
St03  elev >= -5000.0 AND elev <= 5000.0 
St04  lat >= -90.0 AND lat <= 90.0 
St05  lon >= -180.0 AND lon <= 180.0 
St06  nb_data >= 0 
St07  nb_digi >= 0 
St08  nb_filamp >= 0 
St09  nb_sensor >= 0