stacorrections

Logical Entity Name | stacorrections
Default Table Name | stacorrections
Definition |

stacorrections Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
seedchan |  | VARCHAR(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
location |  | VARCHAR(2) | NO | Describes the individual sites on an array station, operated by the same network operator
ondate |  | DATE | NO | This attribute denotes the start date
channel |  | VARCHAR(3) | YES | Channel name
channelsrc |  | VARCHAR(8) | YES | Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)
auth |  | VARCHAR(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 |  | FLOAT | YES | This attribute denotes the correction for the magnitude specified in corr_type
corr_flag |  | VARCHAR(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 |  | VARCHAR(3) | YES | This attribute denotes the magnitude type for which the correction is valid
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 Relationships

Parent Entity | Child Entity | Type | Foreign Keys

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')