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