Station_Comment 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
ondate		DATE	NO	This attribute denotes the start date
comment_id		NUMBER(8, 0)	NO	The comment code key of the associated Comment Description Dictionary
offdate		DATE	YES	This attribute denotes the end date
comment_level		NUMBER(8, 0)	YES	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

Station_Comment Primary and Unique Keys

Key Name	Key Type	Keys
StC00	PrimaryKey	net, sta, ondate, comment_id

Station_Comment Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable
D_Comment	Identifying	One To Zero or More	Sta_Com_D_Com			comment_id	NO	NO
Station_Data	Identifying	One To Zero or More	Sta_Com_Sta_Dat			net, sta, ondate	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Station_Comment Check Constraints

Check Constraint Name

CheckConstraint