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
|
--
-- 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: 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: 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
--
|
