-- Table: public.measurements

-- DROP TABLE IF EXISTS public.measurements;

CREATE TABLE IF NOT EXISTS public.measurements
(
    device_id integer NOT NULL,
    device_name text COLLATE pg_catalog."default",
    measurement_time timestamp with time zone NOT NULL,
    resolution_minutes integer,
    site_id integer,
    site_name text COLLATE pg_catalog."default",
    current_a real,
    voltage_v real,
    power_w real,
    power_factor real,
    energy_wh real,
    CONSTRAINT measurements_pkey PRIMARY KEY (device_id, measurement_time),
    CONSTRAINT fk_mes_dev FOREIGN KEY (device_id)
        REFERENCES public.sensorsdev (codice) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
        NOT VALID
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.measurements
    OWNER to postgres;

-- Table: public.monthmergedstorage

-- DROP TABLE IF EXISTS public.monthmergedstorage;

CREATE TABLE IF NOT EXISTS public.monthmergedstorage
(
    month character varying(2) COLLATE pg_catalog."default" NOT NULL,
    year character varying(4) COLLATE pg_catalog."default" NOT NULL,
    power_kw real,
    energy_kwh real,
    tm bigint,
    CONSTRAINT monthmergedstorage_pkey PRIMARY KEY (month, year)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.monthmergedstorage
    OWNER to postgres;

-- Table: public.sensorsdev

-- DROP TABLE IF EXISTS public.sensorsdev;

CREATE TABLE IF NOT EXISTS public.sensorsdev
(
    codice integer NOT NULL,
    descrizio character varying(45) COLLATE pg_catalog."default",
    codgrp integer,
    CONSTRAINT sensorsdev_pkey PRIMARY KEY (codice),
    CONSTRAINT fk_grp_dev FOREIGN KEY (codgrp)
        REFERENCES public.sensorsgrp (codice) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
        NOT VALID
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.sensorsdev
    OWNER to postgres;


-- Table: public.sensorsgrp

-- DROP TABLE IF EXISTS public.sensorsgrp;

CREATE TABLE IF NOT EXISTS public.sensorsgrp
(
    codice integer NOT NULL,
    descrizio character varying(45) COLLATE pg_catalog."default",
    CONSTRAINT sensorsgrp_pkey PRIMARY KEY (codice)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.sensorsgrp
    OWNER to postgres;