From 7c21bc6c6d7c43c2014d69043777ce833cf62c4c Mon Sep 17 00:00:00 2001
From: Dennis Eriksen <d@ennis.no>
Date: Tue, 4 Oct 2022 07:27:38 +0200
Subject: adding grid tariff from elvia

---
 schema.sql | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 89d8e77..e1ac14c 100644
--- a/schema.sql
+++ b/schema.sql
@@ -37,6 +37,24 @@ CREATE TABLE public.elvia (
 
 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
 --
@@ -129,6 +147,14 @@ 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
 --
-- 
cgit v1.2.3

