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(PK)(FK)    VARCHAR(6)  NO  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
net(PK)(FK)    VARCHAR(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sensor_nb(PK)(FK)    NUMERIC(8, 0)  NO  This attribute represents the sensor number 
component_nb(PK)    NUMERIC(8, 0)  NO  This attribute represents the component number 
ondate(PK)(FK)    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