Station_Datalogger_PChannel 
Logical Entity Name  Station_Datalogger_PChannel 
Default Table Name  Station_Datalogger_PChannel 
Definition  Data associating channels 

Station_Datalogger_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 
data_nb(PK)(FK)    NUMERIC(8, 0)  NO  This attribute represents the datalogger 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 
board_type    VARCHAR(1)  NO  This attribute describes the board type on the datalogger where the physical channel resides. Regular seismic channels are usually on a primary board. Auxiliary channels (internal temperature, external power, …) are usually on an auxiliary board. A value of external is used to represent a digitizer that is not part of the datalogger (for example an embedded digitizer in a digital pressure sensor). A digital board is used to represent truly digital sensors which don’t actually have any digitizing stage from Volts to Counts (for example a rainfall sensor that uses a digital counter) 
channel_type    VARCHAR(1)  NO  This attribute describes the type of the input channel. An input channel is usually classified as physical when the data is digitized (velocity, acceleration, ...). An input channel is defined as synthetic when the data is not derived directly from a sensor (clock frequency, available telemetry buffer channel, clock quality, ...) 
seed_io    VARCHAR(2)  NO  This attribute represents the SEED instrument and orientation 
nb_lchannel    NUMERIC(8, 0)  NO  This attribute denotes the number of logical channels of a datalogger 
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_Datalogger_PChannel Keys 
Key Name  Key Type  Keys 
StDaP00  PrimaryKey  sta, net, data_nb, pchannel_nb, ondate 

Station_Datalogger_PChannel Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Station_Datalogger  Identifying  One To Zero or More        sta, net, data_nb, ondate  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Station_Datalogger_LChannel  Identifying  One To Zero or More          NO 

Station_Datalogger_PChannel Check Constraints 
Check Constraint Name  CheckConstraint 
StDaP01  data_nb >= 1 
StDaP02  nb_lchannel >= 1 
StDaP03  pchannel_nb >= 1 
StDaP04  board_type IN ('P', 'A', 'E', 'D') 
StDaP05  channel_type IN ('P', 'S')