| mecchannel |
| Logical Entity Name | mecchannel |
| Default Table Name | mecchannel |
| Definition | Summary information on channels associated with a mechanism |
| mecchannel Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| mecdataid |
NUMERIC(15, 0) | NO | Mechanisn data identifier | |
| 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 |
| mecchannel Keys |
| Key Name | Key Type | Keys |
| MecChannel_PK | PrimaryKey | mecdataid, net, sta, seedchan, location |
| mecchannel Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| mecdata | Identifying | One To Zero or More | mecdataid | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| mecchannel Check Constraints |
| Check Constraint Name | CheckConstraint |
| MecD01 | mecdataid > 0 |