Channel_Comment 
Logical Entity Name  Channel_Comment 
Default Table Name  Channel_Comment 
Definition  Comments for a channel 

Channel_Comment Columns 
ColumnName  Domain  Datatype  NULL  Definition 
net(PK)(FK)    VARCHAR2(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sta(PK)(FK)    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)(FK)    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)(FK)    VARCHAR2(2)  NO  Describes the individual sites on an array station, operated by the same network operator 
ondate(PK)(FK)    DATE  NO  This attribute denotes the start date 
comment_id(PK)(FK)    NUMBER(8, 0)  NO  The comment code key of the associated Comment Description Dictionary 
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.) 
offdate    DATE  YES  This attribute denotes the end date 
comment_level    NUMBER(8, 0)  NO  The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel 
lddate    DATE  YES  Load date. Date and time that the record was created or last modified, in Oracle date datatype 

Channel_Comment Primary and Unique Keys 
Key Name  Key Type  Keys 
ChC00  PrimaryKey  net, sta, seedchan, location, ondate, comment_id 

Channel_Comment Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Channel_Data  Identifying  One To Zero or More  Cha_Com_Cha_Dat      net, sta, seedchan, location, ondate  NO  NO 
D_Comment  Identifying  One To Zero or More  Cha_Com_D_Com      comment_id  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 

Channel_Comment Check Constraints 
Check Constraint Name  CheckConstraint