Channel_Comment

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

Channel_Comment 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
comment_id |  | NUMERIC(8, 0) | NO | The comment code key of the associated Comment Description Dictionary
channel |  | VARCHAR(8) | 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.)
offdate |  | DATE | YES | This attribute denotes the end date
comment_level |  | NUMERIC(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 Keys

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

Channel_Comment Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Channel_Data | Identifying | One To Zero or More |  |  |  | net, sta, seedchan, location, ondate | NO
D_Comment | Identifying | One To Zero or More |  |  |  | comment_id | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

Channel_Comment Check Constraints

Check Constraint Name | CheckConstraint