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

Station_Digitizer_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 
digi_nb(PK)(FK)    NUMERIC(8, 0)  NO  This attribute represents the digitizer 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 
data_nb    NUMERIC(8, 0)  NO  This attribute represents the datalogger number 
data_pchannel    NUMERIC(8, 0)  NO  This attribute represents a datalogger physical channel 
digi_type    VARCHAR(3)  NO  This attribute represents the digitizer type 
digi_polarity    VARCHAR(1)  NO  This attribute represents the digitizer polarity 
digi_channel    NUMERIC(8, 0)  NO  This attribute represents a digitizer module on a board 
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_Digitizer_PChannel Keys 
Key Name  Key Type  Keys 
StDiP00  PrimaryKey  sta, net, digi_nb, pchannel_nb, ondate 

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

Station_Digitizer_PChannel Check Constraints 
Check Constraint Name  CheckConstraint 
StDiP01  data_nb >= 1 
StDiP02  data_pchannel >= 1 
StDiP03  digi_nb >= 1 
StDiP05  pchannel_nb >= 1