Datalogger_Module

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

Datalogger_Module Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
data_id |  | NUMERIC(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
board_nb |  | NUMERIC(8, 0) | NO | This attribute denotes the number of boards of a datalogger
module_nb |  | NUMERIC(8, 0) | NO | This attribute represents the module number of a datalogger’s board
serial_nb |  | VARCHAR(80) | YES | This attribute denotes a serial number of a datalogger module
firmware_nb |  | VARCHAR(80) | YES | This attribute describes the firmware number of a datalogger
sensitivity |  | 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 Keys

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

Datalogger_Module Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Datalogger_Board | Identifying | One To Zero or More |  |  |  | data_id, board_nb | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

Datalogger_Module Check Constraints

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