Station_Filamp_PChannel 
Logical Entity Name  Station_Filamp_PChannel 
Default Table Name  Station_Filamp_PChannel 
Definition  Data associating physical channels 

Station_Filamp_PChannel 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 
filamp_nb(PK)(FK)    NUMERIC(8, 0)  NO  This attribute represents the filter-amplifier number 
pchannel_nb(PK)    NUMERIC(8, 0)  NO  This attribute denotes a physical channel 
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 
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_Filamp_PChannel Keys 
Key Name  Key Type  Keys 
StFiP00  PrimaryKey  sta, net, filamp_nb, pchannel_nb, ondate 

Station_Filamp_PChannel Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Station_Filamp  Identifying  One To Zero or More        sta, net, filamp_nb, ondate  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

Station_Filamp_PChannel Check Constraints 
Check Constraint Name  CheckConstraint 
StFiP01  filamp_nb >= 1 
StFiP02  next_hard_nb >= 1 
StFiP03  next_hard_pchannel >= 1 
StFiP04  next_hard_type IN ('F','D') 
StFiP05  pchannel_nb >= 1