Netatmo-Weather-MySQL/Dayfile.sql at master · williambargentball/Netatmo-Weather-MySQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
CREATE TABLE `sh1_dayfile` (
	  `LogDate` date NOT NULL,
	  `HighWindGust` decimal(4,1) NOT NULL,
	  `HWindGBear` varchar(3) NOT NULL,
	  `THWindG` varchar(5) NOT NULL,
	  `MinTemp` decimal(5,1) NOT NULL,
	  `TMinTemp` varchar(5) NOT NULL,
	  `MaxTemp` decimal(5,1) NOT NULL,
	  `TMaxTemp` varchar(5) NOT NULL,
	  `MinPress` decimal(6,1) NOT NULL,
	  `TMinPress` varchar(5) NOT NULL,
	  `MaxPress` decimal(6,1) NOT NULL,
	  `TMaxPress` varchar(5) NOT NULL,
	  `MaxRainRate` decimal(4,1) NOT NULL,
	  `TMaxRR` varchar(5) NOT NULL,
	  `TotRainFall` decimal(6,1) NOT NULL,
	  `AvgTemp` decimal(4,1) NOT NULL,
	  `TotWindRun` decimal(5,1) NOT NULL,
	  `HighAvgWSpeed` decimal(3,1) DEFAULT NULL,
	  `THAvgWSpeed` varchar(5) DEFAULT NULL,
	  `LowHum` decimal(4,0) DEFAULT NULL,
	  `TLowHum` varchar(5) DEFAULT NULL,
	  `HighHum` decimal(4,0) DEFAULT NULL,
	  `THighHum` varchar(5) DEFAULT NULL,
	  `TotalEvap` decimal(5,1) DEFAULT NULL,
	  `HoursSun` decimal(3,1) DEFAULT NULL,
	  `HighHeatInd` decimal(4,1) DEFAULT NULL,
	  `THighHeatInd` varchar(5) DEFAULT NULL,
	  `HighAppTemp` decimal(4,1) DEFAULT NULL,
	  `THighAppTemp` varchar(5) DEFAULT NULL,
	  `LowAppTemp` decimal(4,1) DEFAULT NULL,
	  `TLowAppTemp` varchar(5) DEFAULT NULL,
	  `HighHourRain` decimal(4,1) DEFAULT NULL,
	  `THighHourRain` varchar(5) DEFAULT NULL,
	  `LowWindChill` decimal(4,1) DEFAULT NULL,
	  `TLowWindChill` varchar(5) DEFAULT NULL,
	  `HighDewPoint` decimal(4,1) DEFAULT NULL,
	  `THighDewPoint` varchar(5) DEFAULT NULL,
	  `LowDewPoint` decimal(4,1) DEFAULT NULL,
	  `TLowDewPoint` varchar(5) DEFAULT NULL,
	  `DomWindDir` varchar(3) DEFAULT NULL,
	  `HeatDegDays` decimal(4,1) DEFAULT NULL,
	  `CoolDegDays` decimal(4,1) DEFAULT NULL,
	  `HighSolarRad` decimal(5,1) DEFAULT NULL,
	  `THighSolarRad` varchar(5) DEFAULT NULL,
	  `HighUV` decimal(3,1) DEFAULT NULL,
	  `THighUV` varchar(5) DEFAULT NULL,
	  `HWindGBearSym` varchar(3) DEFAULT NULL,
	  `DomWindDirSym` varchar(3) DEFAULT NULL,
	  PRIMARY KEY (`LogDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Dayfile from Cumulus'