channelmap_codaparms 
Logical Entity Name  channelmap_codaparms 
Default Table Name  channelmap_codaparms 
Definition  Channel response dependent data (used by coda magnitude algorithms) 

channelmap_codaparms 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  
location(PK)    VARCHAR2(2)  NO  Describes the individual sites on an array station, operated by the same network operator  
ondate(PK)    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.)  
cutoff    NUMBER(8, 2)  YES  2-sec averaged absolute value amplitude counts 
gain_corr    NUMBER(6, 3)  YES  Magnitude units correction 
lddate    DATE  YES  Load date. Date and time that the record was created or last modified, in Oracle date datatype 

channelmap_codaparms Primary and Unique Keys 
Key Name  Key Type  Keys 
cm_coda_key  PrimaryKey  net, sta, seedchan, location, ondate 

channelmap_codaparms 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 

channelmap_codaparms Check Constraints 
Check Constraint Name  CheckConstraint