Station_Datalogger

Logical Entity Name | Station_Datalogger
Default Table Name | Station_Datalogger
Definition | Data associating a station with a datalogger

Station_Datalogger 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
ondate |  | DATE | NO | This attribute denotes the start date
data_id |  | NUMBER(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
nb_pchannel |  | NUMBER(8, 0) | NO | This attribute denotes the number of physical 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 Primary and Unique Keys

Key Name | Key Type | Keys
StDa00 | PrimaryKey | sta, net, data_nb, ondate

Station_Datalogger Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
Datalogger | Non-Identifying | One To Zero or More | Sta_Dat_Dat |  |  | data_id | NO | NO | NO
Station | Identifying | One To Zero or More | Sta_Dat_Sta |  |  | sta, net, ondate | NO | NO | NO

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred
Station_Datalogger_PChannel | Identifying | One To Zero or More | Sta_Dat_PCh_Sta_Dat |  |  |  | NO | NO | NO

Station_Datalogger Check Constraints

Check Constraint Name | CheckConstraint
StDa01 | data_nb >= 1
StDa02 | nb_pchannel >= 0