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 |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
ondate |  | 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