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
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
|
--
-- PostgreSQL database dump
--
-- Dumped from database version 14.5 (Ubuntu 14.5-0ubuntu0.22.04.1)
-- Dumped by pg_dump version 14.5 (Ubuntu 14.5-0ubuntu0.22.04.1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: elvia; Type: TABLE; Schema: public; Owner: dennis
--
CREATE TABLE public.elvia (
meteringpointid bigint NOT NULL,
starttime timestamp with time zone NOT NULL,
endtime timestamp with time zone NOT NULL,
value numeric,
unit character varying(10),
production boolean,
inserted timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.elvia OWNER TO dennis;
--
-- Name: elvia_gridtariff; Type: TABLE; Schema: public; Owner: dennis
--
CREATE TABLE public.elvia_gridtariff (
meteringpointid bigint NOT NULL,
starttime timestamp with time zone NOT NULL,
endtime timestamp with time zone NOT NULL,
shorttime character varying(9),
ispublicholiday boolean DEFAULT false NOT NULL,
price numeric,
priceexvat numeric,
inserted timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.elvia_gridtariff OWNER TO dennis;
--
-- Name: entsoe; Type: TABLE; Schema: public; Owner: dennis
--
CREATE TABLE public.entsoe (
starttime timestamp with time zone NOT NULL,
zone character varying(4) NOT NULL,
price numeric NOT NULL,
currency character varying(4) DEFAULT 'EUR'::character varying NOT NULL,
unitmeasure character varying(4) DEFAULT 'MWH'::character varying NOT NULL,
inserted timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.entsoe OWNER TO dennis;
--
-- Name: nbex; Type: TABLE; Schema: public; Owner: dennis
--
CREATE TABLE public.nbex (
startdate date NOT NULL,
base_cur character varying(3) DEFAULT 'EUR'::character varying NOT NULL,
quote_cur character varying(3) DEFAULT 'NOK'::character varying NOT NULL,
rate numeric NOT NULL,
inserted timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.nbex OWNER TO dennis;
--
-- Name: tibber_consumption; Type: TABLE; Schema: public; Owner: dennis
--
CREATE TABLE public.tibber_consumption (
starttime timestamp with time zone NOT NULL,
endtime timestamp with time zone NOT NULL,
consumption numeric NOT NULL,
consumptionunit character varying(10) DEFAULT 'kWh'::character varying,
cost numeric NOT NULL,
unitprice numeric NOT NULL,
unitpricevat numeric NOT NULL,
inserted timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.tibber_consumption OWNER TO dennis;
--
-- Name: tibber_prices; Type: TABLE; Schema: public; Owner: dennis
--
CREATE TABLE public.tibber_prices (
startsat timestamp with time zone NOT NULL,
total numeric NOT NULL,
energy numeric NOT NULL,
tax numeric NOT NULL,
level character varying(16),
inserted timestamp with time zone DEFAULT now() NOT NULL
);
ALTER TABLE public.tibber_prices OWNER TO dennis;
--
-- Name: yr; Type: TABLE; Schema: public; Owner: dennis
--
CREATE TABLE public.yr (
"time" timestamp with time zone NOT NULL,
air_temperature real,
air_pressure_at_sea_level real,
cloud_area_fraction real,
relative_humidity real,
wind_from_direction real,
wind_speed real,
inserted timestamp with time zone DEFAULT now() NOT NULL,
updated timestamp with time zone
);
ALTER TABLE public.yr OWNER TO dennis;
--
-- Name: elvia el_pkey; Type: CONSTRAINT; Schema: public; Owner: dennis
--
ALTER TABLE ONLY public.elvia
ADD CONSTRAINT el_pkey PRIMARY KEY (starttime, endtime);
--
-- Name: elvia_gridtariff elvia_gridtariff_pkey; Type: CONSTRAINT; Schema: public; Owner: dennis
--
ALTER TABLE ONLY public.elvia_gridtariff
ADD CONSTRAINT elvia_gridtariff_pkey PRIMARY KEY (meteringpointid, starttime, endtime);
--
-- Name: entsoe entsoe_pkey; Type: CONSTRAINT; Schema: public; Owner: dennis
--
ALTER TABLE ONLY public.entsoe
ADD CONSTRAINT entsoe_pkey PRIMARY KEY (starttime, zone);
--
-- Name: nbex nbexchange_pkey; Type: CONSTRAINT; Schema: public; Owner: dennis
--
ALTER TABLE ONLY public.nbex
ADD CONSTRAINT nbexchange_pkey PRIMARY KEY (startdate, base_cur, quote_cur);
--
-- Name: tibber_consumption tibber_consumption_pkey; Type: CONSTRAINT; Schema: public; Owner: dennis
--
ALTER TABLE ONLY public.tibber_consumption
ADD CONSTRAINT tibber_consumption_pkey PRIMARY KEY (starttime, endtime);
--
-- Name: tibber_prices tibber_prices_pkey; Type: CONSTRAINT; Schema: public; Owner: dennis
--
ALTER TABLE ONLY public.tibber_prices
ADD CONSTRAINT tibber_prices_pkey PRIMARY KEY (startsat);
--
-- Name: yr yr_pkey; Type: CONSTRAINT; Schema: public; Owner: dennis
--
ALTER TABLE ONLY public.yr
ADD CONSTRAINT yr_pkey PRIMARY KEY ("time");
--
-- PostgreSQL database dump complete
--
|
