Station_Sensor_Component

Logical Entity Name | Station_Sensor_Component
Default Table Name | Station_Sensor_Component
Definition | Data associating physical channels

Station_Sensor_Component Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
sensor_nb |  | NUMERIC(8, 0) | NO | This attribute represents the sensor number
component_nb |  | NUMERIC(8, 0) | NO | This attribute represents the component number
ondate |  | DATE | NO | This attribute denotes the start date
next_hard_type |  | VARCHAR(1) | NO | This attribute denotes the next hardware type
next_hard_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the next hardware number
next_hard_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the next hardware physical channel
azimuth |  | FLOAT | YES | The azimuth of the instrument from north, clockwise
dip |  | FLOAT | YES | The dip of the instrument, down from horizontal
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Station_Sensor_Component Keys

Key Name | Key Type | Keys
StSeC00 | PrimaryKey | sta, net, sensor_nb, component_nb, ondate

Station_Sensor_Component Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Station_Sensor | Identifying | One To Zero or More |  |  |  | sta, net, sensor_nb, ondate | NO

Child Relationships:

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

Station_Sensor_Component Check Constraints

Check Constraint Name | CheckConstraint
StSeC01 | azimuth >= 0.0 AND azimuth <= 360.0
StSeC02 | component_nb >= 1
StSec03 | dip >= -90.0 AND dip <= 90.0
StSec04 | next_hard_nb >= 1
StSec05 | next_hard_pchannel >= 1
StSec06 | next_hard_type IN ('F','D')
StSec07 | sensor_nb >= 1