| Station_Datalogger |
| Logical Entity Name | Station_Datalogger |
| Default Table Name | Station_Datalogger |
| Definition | Data associating a station with a datalogger |
| Station_Datalogger 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 | |
| data_nb |
NUMERIC(8, 0) | NO | This attribute represents the datalogger number | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| data_id |
NUMERIC(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database | |
| nb_pchannel | NUMERIC(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 Keys |
| Key Name | Key Type | Keys |
| StDa00 | PrimaryKey | sta, net, data_nb, ondate |
| Station_Datalogger Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Datalogger | Non-Identifying | One To Zero or More | data_id | NO | |||
| Station | Identifying | One To Zero or More | sta, net, ondate | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| Station_Datalogger_PChannel | Identifying | One To Zero or More | NO |
| Station_Datalogger Check Constraints |
| Check Constraint Name | CheckConstraint |
| StDa01 | data_nb >= 1 |
| StDa02 | nb_pchannel >= 0 |