From 7c21bc6c6d7c43c2014d69043777ce833cf62c4c Mon Sep 17 00:00:00 2001 From: Dennis Eriksen 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