mecchannel

Logical Entity Name | mecchannel
Default Table Name | mecchannel
Definition | Summary information on channels associated with a mechanism

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