CREATE TABLE `monitoringtable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `dateOfMeasurement` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `F0` float NOT NULL,
  `F1` float NOT NULL,
  `F2` float NOT NULL,
  `F3` float NOT NULL,
  `F4` float NOT NULL,
  `F5` float NOT NULL,
  `F6` float NOT NULL,
  `F7` float NOT NULL,
  `F8` float NOT NULL,
  `F9` float NOT NULL,

  PRIMARY KEY (`id`),
) ENGINE=InnoDB;

CREATE TABLE `sensors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sensor_name` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sensor_name_UNIQUE` (`sensor_name`)
) ENGINE=InnoDB  COMMENT='Справочник датчиков';

CREATE TABLE `sensor_placements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `placement_name` varchar(15) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `placement_name_UNIQUE` (`placement_name`)
) ENGINE=InnoDB  COMMENT='Места расположения датчиков\n';

CREATE TABLE `sensor_alias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `placement_id` int(11) NOT NULL COMMENT 'идентификатор местоположения датчика',
  `sensor_id` int(11) NOT NULL COMMENT 'идетификатор датчика',
  `post_id` int(11) NOT NULL COMMENT 'идентификатор поста',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sensor_post_unique` (`sensor_id`,`post_id`),
  KEY `alias_to_post_idx` (`post_id`),
  KEY `alias_to_placement_idx` (`placement_id`),
  KEY `alias_to_sensor_idx` (`sensor_id`),
  CONSTRAINT `alias_to_placement` FOREIGN KEY (`placement_id`) REFERENCES `sensor_placements` (`id`),
  CONSTRAINT `alias_to_post` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`),
  CONSTRAINT `alias_to_sensor` FOREIGN KEY (`sensor_id`) REFERENCES `sensors` (`id`)
) ENGINE=InnoDB  COMMENT='Мапирование датчиков на места';

SELECT *
FROM monitoringtable m
  LEFT JOIN sensor_alias sa ON sa.post_id = m.post_id
  LEFT JOIN sensor_placements sp ON sp.id = sa.placement_id