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

Station_Datalogger_PChannel Columns 
ColumnName  Domain  Datatype  NULL  Definition 
sta(PK)(FK)    VARCHAR2(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)    VARCHAR2(8)  NO  Unique network identifier. This character string is the name of a seismic network 
data_nb(PK)(FK)    NUMBER(8, 0)  NO  This attribute represents the datalogger number 
pchannel_nb(PK)    NUMBER(8, 0)  NO  This attribute denotes a physical channel 
ondate(PK)(FK)    DATE  NO  This attribute denotes the start date 
board_type    VARCHAR2(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    VARCHAR2(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    VARCHAR2(2)  NO  This attribute represents the SEED instrument and orientation 
nb_lchannel    NUMBER(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 Primary and Unique Keys 
Key Name  Key Type  Keys 
StDaP00  PrimaryKey  sta, net, data_nb, pchannel_nb, ondate 

Station_Datalogger_PChannel Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
Station_Datalogger  Identifying  One To Zero or More  Sta_Dat_PCh_Sta_Dat      sta, net, data_nb, ondate  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
Station_Datalogger_LChannel  Identifying  One To Zero or More  Sta_Dat_LCh_Sta_Dat_PCh        NO  NO  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')