Datalogger 
Logical Entity Name  Datalogger 
Default Table Name  Datalogger 
Definition  Summary information on a datalogger 

Datalogger Columns 
ColumnName  Domain  Datatype  NULL  Definition 
data_id(PK)    NUMBER(8, 0)  NO  Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database 
data_type    VARCHAR2(80)  YES  This attribute represents a datalogger type 
serial_nb    VARCHAR2(80)  YES  This attribute denotes a serial number of a datalogger 
firmware_nb    VARCHAR2(80)  YES  This attribute describes the firmware number of a datalogger 
software    VARCHAR2(80)  YES  Datalogger’s software (mshear, ushear, ...) 
software_nb    VARCHAR2(80)  YES  Datalogger’s software version number 
ondate    DATE  NO  This attribute denotes the start date 
offdate    DATE  YES  This attribute denotes the end date 
nb_board    NUMBER(8, 0)  YES  This attribute denotes the number of boards of a datalogger 
word_32    NUMBER(8, 0)  NO  The swap order in which 32-bit quantities are specified in the data headers 
word_16    NUMBER(8, 0)  NO  16-bit quantity byte swapping order, for the data headers only 
lddate    DATE  YES  Load date. Date and time that the record was created or last modified, in Oracle date datatype 

Datalogger Primary and Unique Keys 
Key Name  Key Type  Keys 
Da00  PrimaryKey  data_id 

Datalogger Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
Datalogger_Board  Identifying  One To Zero or More  Dat_Boa_Dat        NO  NO  NO 
Station_Datalogger  Non-Identifying  One To Zero or More  Sta_Dat_Dat        NO  NO  NO 

Datalogger Check Constraints 
Check Constraint Name  CheckConstraint 
Da01  nb_board >= 0