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