-- entity
-- таблица связи датчика со временем измерения и фиксированными параметрами (t1-t4), которые есть у любого устройства поставляющего данные.
CREATE TABLE `measure` (
  `measure_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sensor_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `date_time` datetime NOT NULL DEFAULT '2001-01-01 00:00:00',
  `t1` int(11) NOT NULL DEFAULT '0',
  `t2` int(11) NOT NULL DEFAULT '0',
  `t3` smallint(5) unsigned NOT NULL DEFAULT '0',
  `t4` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`measure_id`),
  KEY `sensor_time` (`sensor_id`,`date_time`)
) ENGINE=MyISAM;

-- attribute
CREATE TABLE `tag` (
  `tag_id` tinyint(3) unsigned NOT NULL,
  `desciption` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `precision` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tag_id`)
) ENGINE=MyISAM;

-- value 
CREATE TABLE `measure_tag` (
  `measure_id` int(11) unsigned NOT NULL DEFAULT '0',
  `tag_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `value` double DEFAULT NULL,
  PRIMARY KEY (`measure_id`,`tag_id`)
) ENGINE=MyISAM;

select measure_id, date_time, t1, t2, t3, t4 from measure WHERE(sensor_id='73' && date_time>='20150128140000' && date_time<='20150202135959') ORDER BY date_time ASC

SELECT tag_id, value FROM measure_tag WHERE measure_id = '305835' AND tag_id IN (1,9)