Datalogger_Module

Logical Entity Name | Datalogger_Module
Default Table Name | Datalogger_Module
Definition | Module of a datalogger’s board

Datalogger_Module Columns

ColumnName | Domain | Datatype | NULL | Definition
data_id |  | NUMBER(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
board_nb |  | NUMBER(8, 0) | NO | This attribute denotes the number of boards of a datalogger
module_nb |  | NUMBER(8, 0) | NO | This attribute represents the module number of a datalogger’s board
serial_nb |  | VARCHAR2(80) | YES | This attribute denotes a serial number of a datalogger module
firmware_nb |  | VARCHAR2(80) | YES | This attribute describes the firmware number of a datalogger
sensitivity |  | BINARY_FLOAT | YES | This attribute denotes the sensitivity (Sd) for a sensor or a digitizer
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Datalogger_Module Primary and Unique Keys

Key Name | Key Type | Keys
DaM00 | PrimaryKey | data_id, board_nb, module_nb

Datalogger_Module Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
Datalogger_Board | Identifying | One To Zero or More | Dat_Mod_Dat_Boa |  |  | data_id, board_nb | NO | NO | NO

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred

Datalogger_Module Check Constraints

Check Constraint Name | CheckConstraint
DaM01 | board_nb >= 1
DaM02 | module_nb >= 1