E_manager/schema.sql at main · Pyroil/E_manager · 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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
-- E_manager.db schema
-- Alleen de tabelstructuur, geen historische data.
-- Uitvoeren met: sqlite3 E_manager.db < schema.sql

CREATE TABLE IF NOT EXISTS "PVmanager" (
	"date"	TEXT,
	"time"	TEXT,
	"limit"	INTEGER,
	"new_limit"	INTEGER,
	"production"	REAL,
	"block_solar"	INTEGER,
	"export"	REAL
);

CREATE TABLE IF NOT EXISTS "WPmanager" (
	"date"	TEXT,
	"time"	TEXT,
	"setpoint"	REAL,
	"new_setpoint"	REAL,
	"WPpower"	REAL,
	"export"	REAL
);

CREATE TABLE IF NOT EXISTS "LPmanager" (
	"date"	TEXT,
	"time"	TEXT,
	"amp"	REAL,
	"new_amp"	REAL,
	"export"	REAL,
	"laadpower"	REAL
);

CREATE TABLE IF NOT EXISTS "HourlyMeter" (
	"hour"	TEXT,
	"verbruik1"	REAL,
	"verbruik2"	REAL,
	"levering1"	REAL,
	"levering2"	REAL,
	"prijsverbruik"	REAL,
	"prijslevering"	REAL,
	"verbruik"	REAL,
	"levering"	REAL,
	"kosten"	REAL,
	"verbruik_24"	REAL,
	"levering_24"	REAL,
	"kosten_24"	REAL
);

CREATE TABLE IF NOT EXISTS "LoadBalance" (
	"datum"	TEXT,
	"tijd"	TEXT,
	"actA_L1"	INTEGER,
	"actA_L2"	INTEGER,
	"actA_L3"	INTEGER,
	"actP+_L1"	REAL,
	"actP+_L2"	REAL,
	"actP+_L3"	REAL,
	"actP-_L1"	REAL,
	"actP-_L2"	REAL,
	"actP-_L3"	REAL,
	"actV_L1"	REAL,
	"actV_L2"	REAL,
	"actV_L3"	REAL,
	"calA_L1"	REAL,
	"calA_L2"	REAL,
	"calA_L3"	REAL
);

CREATE TABLE IF NOT EXISTS "kaleprijs_1" (
	"datum"	TEXT,
	"00"	REAL,
	"01"	REAL,
	"02"	REAL,
	"03"	REAL,
	"04"	REAL,
	"05"	REAL,
	"06"	REAL,
	"07"	REAL,
	"08"	REAL,
	"09"	REAL,
	"10"	REAL,
	"11"	REAL,
	"12"	REAL,
	"13"	REAL,
	"14"	REAL,
	"15"	REAL,
	"16"	REAL,
	"17"	REAL,
	"18"	REAL,
	"19"	REAL,
	"20"	REAL,
	"21"	REAL,
	"22"	REAL,
	"23"	REAL
);