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