stacorrections 
Logical Entity Name  stacorrections 
Default Table Name  stacorrections 
Definition  Summary information on station corrections 

stacorrections Columns 
ColumnName  Domain  Datatype  NULL  Definition 
net(PK)    VARCHAR2(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sta(PK)    VARCHAR2(6)  NO  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
seedchan(PK)    VARCHAR2(3)  NO  SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 
channel    VARCHAR2(8)  YES  Channel name 
channelsrc    VARCHAR2(8)  YES  Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) 
location(PK)    VARCHAR2(2)  NO  Describes the individual sites on an array station, operated by the same network operator 
auth    VARCHAR2(15)  YES  The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 
corr    DOUBLE PRECISION  YES  This attribute denotes the correction for the magnitude specified in corr_type 
corr_flag    VARCHAR2(1)  YES  This attribute denotes if the magnitude correction is the default value, a value that is still being updated, or a frozen value, which is no longer updated 
corr_type    VARCHAR2(3)  YES  This attribute denotes the magnitude type for which the correction is valid 
ondate(PK)    DATE  NO  This attribute denotes the start date 
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 

stacorrections Primary and Unique Keys 
Key Name  Key Type  Keys 
stacorrectionskey01  PrimaryKey  net, sta, seedchan, location, ondate 

stacorrections Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 

stacorrections Check Constraints 
Check Constraint Name  CheckConstraint 
stacorrectionskey02  corr_type in ('ml','me','mca','mh','md','mw','mb','m0','vel','acc') 
stacorrectionskey03  corr_flag in ('D','C','F')