-- Table: public.end_user

CREATE TABLE public.end_user
(
    id bigint NOT NULL,
    user_email character varying(255) COLLATE pg_catalog."default",
    user_given_name character varying(255) COLLATE pg_catalog."default",
    user_last_name character varying(255) COLLATE pg_catalog."default",
    user_login character varying(255) COLLATE pg_catalog."default",
    user_pref_lang character varying(255) COLLATE pg_catalog."default",
    CONSTRAINT end_user_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.end_user
    OWNER to postgres;


-- Table: public.gatewy

	CREATE TABLE public.gateway
(
    device_id bigint NOT NULL,
	device_externalid bigint NOT NULL,
    counter bigint,
    is_ignored boolean,
    device_lasttimekeepalive timestamp without time zone,
    "timestamp" timestamp without time zone,
    CONSTRAINT gateway_pkey PRIMARY KEY (device_id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.gateway
    OWNER to postgres;


-- Table: public.product

	CREATE TABLE public.product
(
    id bigint NOT NULL,
    CONSTRAINT product_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.product
    OWNER to postgres;

--TABLE public.shelf;

	CREATE TABLE public.shelf
(
    id bigint NOT NULL,
    productbe_id bigint,
    CONSTRAINT shelf_pkey PRIMARY KEY (id),
    CONSTRAINT fk_shelf_productbe_id FOREIGN KEY (productbe_id)
        REFERENCES public.product (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.shelf
    OWNER to postgres;


--TABLE public.sensor;

CREATE TABLE public.sensor
(
    device_id bigint NOT NULL,
	device_externalid bigint NOT NULL,
    is_ignored boolean,
    device_lasttimekeepalive timestamp without time zone,
    shelfbe_id bigint,
    CONSTRAINT sensor_pkey PRIMARY KEY (device_id),
    CONSTRAINT fk_sensor_shelfbe_id FOREIGN KEY (shelfbe_id)
        REFERENCES public.shelf (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.sensor
    OWNER to postgres;




-- Table: public.orderbe_product

	CREATE TABLE public.orderbe
(
    id bigint NOT NULL,
    CONSTRAINT orderbe_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.orderbe
    OWNER to postgres;



-- Table: public.orderbe_product

CREATE TABLE public.orderbe_product
(
    orderbe_id bigint NOT NULL,
    productbes_id bigint NOT NULL,
    CONSTRAINT orderbe_product_pkey PRIMARY KEY (orderbe_id, productbes_id),
    CONSTRAINT fk_orderbe_product_orderbe_id FOREIGN KEY (orderbe_id)
        REFERENCES public.orderbe (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT fk_orderbe_product_productbes_id FOREIGN KEY (productbes_id)
        REFERENCES public.product (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.orderbe_product
    OWNER to postgres;



-- Table: public.product_shelf

CREATE TABLE public.product_shelf
(
    product_id bigint NOT NULL,
    shelfbes_id bigint NOT NULL,
    CONSTRAINT product_shelf_pkey PRIMARY KEY (product_id, shelfbes_id),
    CONSTRAINT fk_product_shelf_product_id FOREIGN KEY (product_id)
        REFERENCES public.product (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT fk_product_shelf_shelfbes_id FOREIGN KEY (shelfbes_id)
        REFERENCES public.shelf (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.product_shelf
    OWNER to postgres;



-- Table: public.shelf_sensor

CREATE TABLE public.shelf_sensor
(
    shelf_id bigint NOT NULL,
    sensors_device_id bigint NOT NULL,
    CONSTRAINT shelf_sensor_pkey PRIMARY KEY (shelf_id, sensors_device_id),
    CONSTRAINT fk_shelf_sensor_sensors_device_id FOREIGN KEY (sensors_device_id)
        REFERENCES public.sensor (device_id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT fk_shelf_sensor_shelf_id FOREIGN KEY (shelf_id)
        REFERENCES public.shelf (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE public.shelf_sensor
    OWNER to postgres;



-- Table: public.v_qt_invocationstats

CREATE TABLE public.v_qt_invocationstats
(
    hostname character varying(255) COLLATE pg_catalog."default" NOT NULL,
    methodname character varying(255) COLLATE pg_catalog."default" NOT NULL,
    id_qt_messinterval bigint NOT NULL,
    averageduration bigint,
    c_exception character varying(255) COLLATE pg_catalog."default",
    lastinvocationtimestamp timestamp without time zone,
    maxduration bigint,
    minduration bigint,
    numberofexceptions bigint,
    numberofinvocations bigint,
    recentduration bigint,
    totalduration bigint,
    CONSTRAINT v_qt_invocationstats_pkey PRIMARY KEY (hostname, methodname, id_qt_messinterval)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.v_qt_invocationstats
    OWNER to postgres;



-- DROP TABLE public.v_qt_messinterval;

CREATE TABLE public.v_qt_messinterval
(
    id bigint NOT NULL,
    interval_end_time timestamp without time zone,
    interval_start_time timestamp without time zone,
    CONSTRAINT v_qt_messinterval_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.v_qt_messinterval
    OWNER to postgres;




-- Table: public.sequence


CREATE TABLE public.sequence
(
    seq_name character varying(50) COLLATE pg_catalog."default" NOT NULL,
    seq_count numeric(38,0),
    CONSTRAINT sequence_pkey PRIMARY KEY (seq_name)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.sequence
    OWNER to postgres