mecchannel Columns

ColumnName	Domain	Datatype	NULL	Definition
mecdataid		NUMBER(15, 0)	NO	Mechanisn data identifier
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
seedchan		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		VARCHAR2(2)	NO	Describes the individual sites on an array station, operated by the same network operator

mecchannel Primary and Unique Keys

Key Name	Key Type	Keys
MecChannel_PK	PrimaryKey	mecdataid, net, sta, seedchan, location

mecchannel Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
mecdata	Identifying	One To Zero or More	MecChannel_FK01			mecdataid	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

mecchannel Check Constraints

Check Constraint Name	CheckConstraint
MecD01	mecdataid > 0