adding grid tariff from elvia

1 files changed, 26 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
index 89d8e77..e1ac14c 100644
--- a/schema.sql
+++ b/schema.sql
@@ -38,6 +38,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
 --
 
@@ -130,6 +148,14 @@ ALTER TABLE ONLY public.elvia
 
 
 --
+-- 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
 --