Listing 1: create table SENSOR


(
    
   SENSOR_ID                integer not null default autoincrement,
    
   SENSOR_LOCATION     varchar(128),
    
   LONGITUDE                varchar(16),
    
   LATTITUDE                 varchar(16),
    
   primary key (SENSOR_ID)
);
 
create table TEMPERATURE_DATA
(
    
   TEMP_TYPE_CODE   varchar(10)   not null,
    
   SENSOR_ID             integer        not null,
    
   COLLECTION_TIME   timestamp   not null,
    
   TEMPERATURE         float,
    
   HUMIDITY               float,
    
   TEMP_STATUS         varchar(8)
 
    
           check (TEMP_STATUS is null or ( TEMP_STATUS in ('VALID','INVALID') )),
    
   MEASUREMENT_TYPE varchar(1)    	default 'F'
    
           check (MEASUREMENT_TYPE is null or ( MEASUREMENT_TYPE in ('F','C') )),
    
   VAL_1     float,
    
   VAL_2     float,
    
   VAL_3     float,
    
   VAL_4     float,
    
   VAL_5     float,
    
   VAL_6     float,
    
   VAL_7     float,
    
   VAL_8     float,
    
   VAL_9     float,
    
   VAL_10   float,
    
   primary key (TEMP_TYPE_CODE, SENSOR_ID, COLLECTION_TIME)
);
 
create table TEMPERATURE_TYPE
  (
    
TEMP_TYPE_CODE        varchar(10)      not null,
    
TEMP_TYPE_NAME        varchar(10),
    
TEMP_TYPE_DISPLAY   varchar(10),
    
   primary key (TEMP_TYPE_CODE)
  );