config_channel 
Logical Entity Name  config_channel 
Default Table Name  config_channel 
Definition  
Associates NSCL stream codes with programs (used in the sql_chanloader system)
 

config_channel Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
progid(PK)(FK)    NUMERIC(8, 0)  NO  
Keys to CONFIG_CHANNEL table
 
net(PK)    VARCHAR(8)  NO  
Unique network identifier. This character string is the name of a seismic network
 
sta(PK)    VARCHAR(6)  NO  
Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
 
seedchan(PK)    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
 
config    VARCHAR(64)  YES  
Misc note used by config file generation scripts.  Originally intended to identify configs within a program group
 
lddate    DATE  YES  
Load date. Date and time that the record was created or last modified, in Oracle date datatype
 
location(PK)    VARCHAR(2)  NO  
Describes the individual sites on an array station, operated by the same network operator
 

config_channel Keys 
Key Name  Key Type  Keys 
config_chankey01  PrimaryKey  progid, net, sta, seedchan, location 

config_channel Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
program  Identifying  One To Zero or More        progid  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

config_channel Check Constraints 
Check Constraint Name  CheckConstraint