channelmap_ampparms

Logical Entity Name | channelmap_ampparms
Default Table Name | channelmap_ampparms
Definition |
    Channel clipping count values (used by magnitude algorithms)

channelmap_ampparms 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
seedchan |  | 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
location |  | VARCHAR2(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
offdate |  | DATE | NO |
    This attribute denotes the end date
channel |  | VARCHAR2(3) | 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.)
clip |  | NUMBER(14, 2) | YES |
    Sample counts at which signal clips
lddate |  | DATE | YES |
    Load date. Date and time that the record was created or last modified, in Oracle date datatype

channelmap_ampparms Primary and Unique Keys

Key Name | Key Type | Keys
cm_amp_key | PrimaryKey | net, sta, seedchan, location, ondate

channelmap_ampparms Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

channelmap_ampparms Check Constraints

Check Constraint Name | CheckConstraint