Datalogger_Board

Logical Entity Name | Datalogger_Board
Default Table Name | Datalogger_Board
Definition | Board of a datalogger

Datalogger_Board 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
serial_nb |  | VARCHAR2(80) | YES | This attribute denotes a serial number of a datalogger board
nb_module |  | NUMBER(8, 0) | NO | This attribute denotes the number of modules of a datalogger’s board
firmware_nb |  | VARCHAR2(80) | YES | This attribute describes the firmware number of a datalogger
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Datalogger_Board Primary and Unique Keys

Key Name | Key Type | Keys
DaB00 | PrimaryKey | data_id, board_nb

Datalogger_Board Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
Datalogger | Identifying | One To Zero or More | Dat_Boa_Dat |  |  | data_id | NO | NO | NO

Child Relationships:

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

Datalogger_Board Check Constraints

Check Constraint Name | CheckConstraint
DaB01 | board_nb >= 1
DaB02 | nb_module >= 0