1 files changed, 128 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..6b20b52
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,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
+--
+