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