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 |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
data_nb |  | NUMBER(8, 0) | NO | This attribute represents the datalogger number
pchannel_nb |  | NUMBER(8, 0) | NO | This attribute denotes a physical channel
ondate |  | 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')