+----------------------------+-----------------------+------+-----+---------+----------------+
| Field                      | Type                  | Null | Key | Default | Extra          |
+----------------------------+-----------------------+------+-----+---------+----------------+
| met_office_id              | int(11)               | NO   | PRI | NULL    | auto_increment |
| observation_datetime_utc   | datetime              | NO   |     | NULL    |                |
| observation_datetime_local | datetime              | NO   |     | NULL    |                |
| observation_datetime       | datetime              | NO   |     | NULL    |                |
| station_id                 | char(4)               | NO   | MUL | NULL    |                |
| station_name               | char(25)              | YES  |     | NULL    |                |
| temp_c                     | decimal(4,2)          | YES  |     | NULL    |                |
| dewpoint_c                 | decimal(4,2)          | YES  |     | NULL    |                |
| humidity_rh                | decimal(5,2) unsigned | YES  |     | NULL    |                |
| wind_dir_compass           | char(3)               | YES  |     | NULL    |                |
| wind_speed_mph             | decimal(5,2) unsigned | YES  |     | NULL    |                |
| wind_gust_mph              | decimal(5,2) unsigned | YES  |     | NULL    |                |
| visibility_metres          | mediumint(8) unsigned | YES  |     | NULL    |                |
| pressure_hpa               | decimal(6,2) unsigned | YES  |     | NULL    |                |
| pressure_tendency          | char(1)               | YES  |     | NULL    |                |
| weather_type               | char(2)               | YES  |     | NULL    |                |
+----------------------------+-----------------------+------+-----+---------+----------------+