well-api/postgress.sql
2025-12-13 12:21:31 -08:00

5809 lines
189 KiB
SQL

pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump: detail: hypertable
pg_dump: hint: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.
pg_dump: hint: Consider using a full dump instead of a --data-only dump to avoid this problem.
pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump: detail: chunk
pg_dump: hint: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.
pg_dump: hint: Consider using a full dump instead of a --data-only dump to avoid this problem.
pg_dump: warning: there are circular foreign-key constraints on this table:
pg_dump: detail: continuous_agg
pg_dump: hint: You might not be able to restore the dump without using --disable-triggers or temporarily dropping the constraints.
pg_dump: hint: Consider using a full dump instead of a --data-only dump to avoid this problem.
--
-- PostgreSQL database dump
--
\restrict nEgDhKD6B4nWaKSvB1ltprY3sHDNBEhrNLwMHP5zWu9gM4hHDn5zuiRnbZjRlH7
-- Dumped from database version 16.10 (Ubuntu 16.10-0ubuntu0.24.04.1)
-- Dumped by pg_dump version 16.10 (Ubuntu 16.10-0ubuntu0.24.04.1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
--
-- Name: timescaledb; Type: EXTENSION; Schema: -; Owner: -
--
CREATE EXTENSION IF NOT EXISTS timescaledb WITH SCHEMA public;
--
-- Name: EXTENSION timescaledb; Type: COMMENT; Schema: -; Owner:
--
COMMENT ON EXTENSION timescaledb IS 'Enables scalable inserts and complex queries for time-series data (Apache 2 Edition)';
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: radar_readings; Type: TABLE; Schema: public; Owner: well_app
--
CREATE TABLE public.radar_readings (
"time" timestamp with time zone NOT NULL,
device_id integer,
absent double precision,
moving double precision,
stationary double precision,
"both" double precision,
m0 double precision,
m1 double precision,
m2 double precision,
m3 double precision,
m4 double precision,
m5 double precision,
m6 double precision,
m7 double precision,
m8 double precision,
s0 double precision,
s1 double precision,
s2 double precision,
s3 double precision,
s4 double precision,
s5 double precision,
s6 double precision,
s7 double precision,
s8 double precision
);
ALTER TABLE public.radar_readings OWNER TO well_app;
--
-- Name: _hyper_3_101_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_101_chunk (
CONSTRAINT constraint_101 CHECK ((("time" >= '2025-08-20 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-08-27 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_101_chunk OWNER TO well_app;
--
-- Name: _hyper_3_103_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_103_chunk (
CONSTRAINT constraint_103 CHECK ((("time" >= '2025-08-27 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-09-03 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_103_chunk OWNER TO well_app;
--
-- Name: _hyper_3_105_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_105_chunk (
CONSTRAINT constraint_105 CHECK ((("time" >= '2025-09-03 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-09-10 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_105_chunk OWNER TO well_app;
--
-- Name: _hyper_3_107_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_107_chunk (
CONSTRAINT constraint_107 CHECK ((("time" >= '2025-09-10 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-09-17 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_107_chunk OWNER TO well_app;
--
-- Name: _hyper_3_109_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_109_chunk (
CONSTRAINT constraint_109 CHECK ((("time" >= '2025-09-17 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-09-24 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_109_chunk OWNER TO well_app;
--
-- Name: _hyper_3_10_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_10_chunk (
CONSTRAINT constraint_10 CHECK ((("time" >= '2024-09-25 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-02 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_10_chunk OWNER TO well_app;
--
-- Name: _hyper_3_111_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_111_chunk (
CONSTRAINT constraint_111 CHECK ((("time" >= '2025-09-24 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-01 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_111_chunk OWNER TO well_app;
--
-- Name: _hyper_3_113_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_113_chunk (
CONSTRAINT constraint_113 CHECK ((("time" >= '2025-10-01 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-08 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_113_chunk OWNER TO well_app;
--
-- Name: _hyper_3_114_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_114_chunk (
CONSTRAINT constraint_114 CHECK ((("time" >= '2025-10-08 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-15 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_114_chunk OWNER TO well_app;
--
-- Name: _hyper_3_117_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_117_chunk (
CONSTRAINT constraint_117 CHECK ((("time" >= '2025-10-15 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-22 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_117_chunk OWNER TO well_app;
--
-- Name: _hyper_3_119_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_119_chunk (
CONSTRAINT constraint_119 CHECK ((("time" >= '2025-10-22 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-29 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_119_chunk OWNER TO well_app;
--
-- Name: _hyper_3_11_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_11_chunk (
CONSTRAINT constraint_11 CHECK ((("time" >= '2024-10-02 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-09 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_11_chunk OWNER TO well_app;
--
-- Name: _hyper_3_121_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_121_chunk (
CONSTRAINT constraint_121 CHECK ((("time" >= '2025-10-29 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-11-05 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_121_chunk OWNER TO well_app;
--
-- Name: _hyper_3_123_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_123_chunk (
CONSTRAINT constraint_123 CHECK ((("time" >= '2025-11-05 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-11-12 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_123_chunk OWNER TO well_app;
--
-- Name: _hyper_3_125_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_125_chunk (
CONSTRAINT constraint_125 CHECK ((("time" >= '2025-11-12 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-11-19 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_125_chunk OWNER TO well_app;
--
-- Name: _hyper_3_127_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_127_chunk (
CONSTRAINT constraint_127 CHECK ((("time" >= '2025-11-19 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-11-26 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_127_chunk OWNER TO well_app;
--
-- Name: _hyper_3_12_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_12_chunk (
CONSTRAINT constraint_12 CHECK ((("time" >= '2024-10-09 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-16 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_12_chunk OWNER TO well_app;
--
-- Name: _hyper_3_13_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_13_chunk (
CONSTRAINT constraint_13 CHECK ((("time" >= '2024-10-16 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-23 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_13_chunk OWNER TO well_app;
--
-- Name: _hyper_3_14_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_14_chunk (
CONSTRAINT constraint_14 CHECK ((("time" >= '2024-10-23 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-30 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_14_chunk OWNER TO well_app;
--
-- Name: _hyper_3_15_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_15_chunk (
CONSTRAINT constraint_15 CHECK ((("time" >= '2024-10-30 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-11-06 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_15_chunk OWNER TO well_app;
--
-- Name: _hyper_3_16_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_16_chunk (
CONSTRAINT constraint_16 CHECK ((("time" >= '2024-11-06 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-11-13 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_16_chunk OWNER TO well_app;
--
-- Name: _hyper_3_17_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_17_chunk (
CONSTRAINT constraint_17 CHECK ((("time" >= '2025-01-08 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-15 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_17_chunk OWNER TO well_app;
--
-- Name: _hyper_3_18_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_18_chunk (
CONSTRAINT constraint_18 CHECK ((("time" >= '2025-01-15 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-22 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_18_chunk OWNER TO well_app;
--
-- Name: _hyper_3_19_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_19_chunk (
CONSTRAINT constraint_19 CHECK ((("time" >= '2025-01-22 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-29 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_19_chunk OWNER TO well_app;
--
-- Name: _hyper_3_1_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_1_chunk (
CONSTRAINT constraint_1 CHECK ((("time" >= '2024-11-13 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-11-20 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_1_chunk OWNER TO well_app;
--
-- Name: _hyper_3_20_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_20_chunk (
CONSTRAINT constraint_20 CHECK ((("time" >= '2025-01-29 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-02-05 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_20_chunk OWNER TO well_app;
--
-- Name: _hyper_3_21_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_21_chunk (
CONSTRAINT constraint_21 CHECK ((("time" >= '2025-02-05 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-02-12 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_21_chunk OWNER TO well_app;
--
-- Name: _hyper_3_22_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_22_chunk (
CONSTRAINT constraint_22 CHECK ((("time" >= '2025-02-12 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-02-19 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_22_chunk OWNER TO well_app;
--
-- Name: _hyper_3_2_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_2_chunk (
CONSTRAINT constraint_2 CHECK ((("time" >= '2024-11-20 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-11-27 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_2_chunk OWNER TO well_app;
--
-- Name: _hyper_3_3_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_3_chunk (
CONSTRAINT constraint_3 CHECK ((("time" >= '2024-11-27 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-12-04 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_3_chunk OWNER TO well_app;
--
-- Name: _hyper_3_45_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_45_chunk (
CONSTRAINT constraint_45 CHECK ((("time" >= '2025-02-19 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-02-26 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_45_chunk OWNER TO well_app;
--
-- Name: _hyper_3_48_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_48_chunk (
CONSTRAINT constraint_48 CHECK ((("time" >= '2025-02-26 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-03-05 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_48_chunk OWNER TO well_app;
--
-- Name: _hyper_3_49_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_49_chunk (
CONSTRAINT constraint_49 CHECK ((("time" >= '2025-03-05 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-03-12 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_49_chunk OWNER TO well_app;
--
-- Name: _hyper_3_4_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_4_chunk (
CONSTRAINT constraint_4 CHECK ((("time" >= '2024-12-04 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-12-11 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_4_chunk OWNER TO well_app;
--
-- Name: _hyper_3_52_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_52_chunk (
CONSTRAINT constraint_52 CHECK ((("time" >= '2025-03-12 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-03-19 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_52_chunk OWNER TO well_app;
--
-- Name: _hyper_3_53_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_53_chunk (
CONSTRAINT constraint_53 CHECK ((("time" >= '2025-03-19 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-03-26 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_53_chunk OWNER TO well_app;
--
-- Name: _hyper_3_55_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_55_chunk (
CONSTRAINT constraint_55 CHECK ((("time" >= '2025-03-26 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-02 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_55_chunk OWNER TO well_app;
--
-- Name: _hyper_3_57_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_57_chunk (
CONSTRAINT constraint_57 CHECK ((("time" >= '2025-04-02 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-09 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_57_chunk OWNER TO well_app;
--
-- Name: _hyper_3_59_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_59_chunk (
CONSTRAINT constraint_59 CHECK ((("time" >= '2025-04-09 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-16 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_59_chunk OWNER TO well_app;
--
-- Name: _hyper_3_5_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_5_chunk (
CONSTRAINT constraint_5 CHECK ((("time" >= '2024-12-11 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-12-18 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_5_chunk OWNER TO well_app;
--
-- Name: _hyper_3_61_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_61_chunk (
CONSTRAINT constraint_61 CHECK ((("time" >= '2025-04-16 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-23 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_61_chunk OWNER TO well_app;
--
-- Name: _hyper_3_63_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_63_chunk (
CONSTRAINT constraint_63 CHECK ((("time" >= '2025-04-23 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-30 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_63_chunk OWNER TO well_app;
--
-- Name: _hyper_3_65_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_65_chunk (
CONSTRAINT constraint_65 CHECK ((("time" >= '2025-04-30 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-05-07 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_65_chunk OWNER TO well_app;
--
-- Name: _hyper_3_68_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_68_chunk (
CONSTRAINT constraint_68 CHECK ((("time" >= '2025-05-07 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-05-14 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_68_chunk OWNER TO well_app;
--
-- Name: _hyper_3_6_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_6_chunk (
CONSTRAINT constraint_6 CHECK ((("time" >= '2024-12-18 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-12-25 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_6_chunk OWNER TO well_app;
--
-- Name: _hyper_3_70_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_70_chunk (
CONSTRAINT constraint_70 CHECK ((("time" >= '2025-05-14 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-05-21 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_70_chunk OWNER TO well_app;
--
-- Name: _hyper_3_72_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_72_chunk (
CONSTRAINT constraint_72 CHECK ((("time" >= '2025-05-21 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-05-28 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_72_chunk OWNER TO well_app;
--
-- Name: _hyper_3_74_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_74_chunk (
CONSTRAINT constraint_74 CHECK ((("time" >= '2025-05-28 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-06-04 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_74_chunk OWNER TO well_app;
--
-- Name: _hyper_3_75_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_75_chunk (
CONSTRAINT constraint_75 CHECK ((("time" >= '2025-06-04 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-06-11 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_75_chunk OWNER TO well_app;
--
-- Name: _hyper_3_77_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_77_chunk (
CONSTRAINT constraint_77 CHECK ((("time" >= '2025-06-11 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-06-18 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_77_chunk OWNER TO well_app;
--
-- Name: _hyper_3_79_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_79_chunk (
CONSTRAINT constraint_79 CHECK ((("time" >= '2025-06-18 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-06-25 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_79_chunk OWNER TO well_app;
--
-- Name: _hyper_3_7_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_7_chunk (
CONSTRAINT constraint_7 CHECK ((("time" >= '2024-12-25 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-01 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_7_chunk OWNER TO well_app;
--
-- Name: _hyper_3_82_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_82_chunk (
CONSTRAINT constraint_82 CHECK ((("time" >= '2025-06-25 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-02 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_82_chunk OWNER TO well_app;
--
-- Name: _hyper_3_84_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_84_chunk (
CONSTRAINT constraint_84 CHECK ((("time" >= '2025-07-02 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-09 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_84_chunk OWNER TO well_app;
--
-- Name: _hyper_3_85_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_85_chunk (
CONSTRAINT constraint_85 CHECK ((("time" >= '2025-07-09 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-16 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_85_chunk OWNER TO well_app;
--
-- Name: _hyper_3_88_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_88_chunk (
CONSTRAINT constraint_88 CHECK ((("time" >= '2025-07-16 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-23 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_88_chunk OWNER TO well_app;
--
-- Name: _hyper_3_8_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_8_chunk (
CONSTRAINT constraint_8 CHECK ((("time" >= '2025-01-01 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-08 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_8_chunk OWNER TO well_app;
--
-- Name: _hyper_3_90_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_90_chunk (
CONSTRAINT constraint_90 CHECK ((("time" >= '2025-07-23 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-30 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_90_chunk OWNER TO well_app;
--
-- Name: _hyper_3_95_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_95_chunk (
CONSTRAINT constraint_95 CHECK ((("time" >= '2025-07-30 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-08-06 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_95_chunk OWNER TO well_app;
--
-- Name: _hyper_3_97_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_97_chunk (
CONSTRAINT constraint_97 CHECK ((("time" >= '2025-08-06 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-08-13 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_97_chunk OWNER TO well_app;
--
-- Name: _hyper_3_99_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_99_chunk (
CONSTRAINT constraint_99 CHECK ((("time" >= '2025-08-13 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-08-20 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_99_chunk OWNER TO well_app;
--
-- Name: _hyper_3_9_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_3_9_chunk (
CONSTRAINT constraint_9 CHECK ((("time" >= '1969-12-31 16:00:00-08'::timestamp with time zone) AND ("time" < '1970-01-07 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.radar_readings);
ALTER TABLE _timescaledb_internal._hyper_3_9_chunk OWNER TO well_app;
--
-- Name: sensor_readings; Type: TABLE; Schema: public; Owner: well_app
--
CREATE TABLE public.sensor_readings (
"time" timestamp with time zone NOT NULL,
device_id integer NOT NULL,
temperature double precision,
humidity double precision,
pressure double precision,
light double precision,
s0 double precision,
s1 double precision,
s2 double precision,
s3 double precision,
s4 double precision,
s5 double precision,
s6 double precision,
s7 double precision,
s8 double precision,
s9 double precision,
mtype smallint DEFAULT 0
);
ALTER TABLE public.sensor_readings OWNER TO well_app;
--
-- Name: _hyper_4_100_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_100_chunk (
CONSTRAINT constraint_100 CHECK ((("time" >= '2025-08-20 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-08-27 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_100_chunk OWNER TO well_app;
--
-- Name: _hyper_4_102_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_102_chunk (
CONSTRAINT constraint_102 CHECK ((("time" >= '2025-08-27 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-09-03 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_102_chunk OWNER TO well_app;
--
-- Name: _hyper_4_104_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_104_chunk (
CONSTRAINT constraint_104 CHECK ((("time" >= '2025-09-03 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-09-10 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_104_chunk OWNER TO well_app;
--
-- Name: _hyper_4_106_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_106_chunk (
CONSTRAINT constraint_106 CHECK ((("time" >= '2025-09-10 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-09-17 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_106_chunk OWNER TO well_app;
--
-- Name: _hyper_4_108_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_108_chunk (
CONSTRAINT constraint_108 CHECK ((("time" >= '2025-09-17 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-09-24 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_108_chunk OWNER TO well_app;
--
-- Name: _hyper_4_110_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_110_chunk (
CONSTRAINT constraint_110 CHECK ((("time" >= '2025-09-24 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-01 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_110_chunk OWNER TO well_app;
--
-- Name: _hyper_4_112_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_112_chunk (
CONSTRAINT constraint_112 CHECK ((("time" >= '2025-10-01 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-08 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_112_chunk OWNER TO well_app;
--
-- Name: _hyper_4_115_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_115_chunk (
CONSTRAINT constraint_115 CHECK ((("time" >= '2025-10-08 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-15 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_115_chunk OWNER TO well_app;
--
-- Name: _hyper_4_116_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_116_chunk (
CONSTRAINT constraint_116 CHECK ((("time" >= '2025-10-15 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-22 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_116_chunk OWNER TO well_app;
--
-- Name: _hyper_4_118_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_118_chunk (
CONSTRAINT constraint_118 CHECK ((("time" >= '2025-10-22 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-10-29 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_118_chunk OWNER TO well_app;
--
-- Name: _hyper_4_120_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_120_chunk (
CONSTRAINT constraint_120 CHECK ((("time" >= '2025-10-29 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-11-05 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_120_chunk OWNER TO well_app;
--
-- Name: _hyper_4_122_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_122_chunk (
CONSTRAINT constraint_122 CHECK ((("time" >= '2025-11-05 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-11-12 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_122_chunk OWNER TO well_app;
--
-- Name: _hyper_4_124_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_124_chunk (
CONSTRAINT constraint_124 CHECK ((("time" >= '2025-11-12 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-11-19 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_124_chunk OWNER TO well_app;
--
-- Name: _hyper_4_126_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_126_chunk (
CONSTRAINT constraint_126 CHECK ((("time" >= '2025-11-19 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-11-26 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_126_chunk OWNER TO well_app;
--
-- Name: _hyper_4_23_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_23_chunk (
CONSTRAINT constraint_23 CHECK ((("time" >= '1969-12-31 16:00:00-08'::timestamp with time zone) AND ("time" < '1970-01-07 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_23_chunk OWNER TO well_app;
--
-- Name: _hyper_4_24_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_24_chunk (
CONSTRAINT constraint_24 CHECK ((("time" >= '2024-09-25 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-02 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_24_chunk OWNER TO well_app;
--
-- Name: _hyper_4_25_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_25_chunk (
CONSTRAINT constraint_25 CHECK ((("time" >= '2024-10-02 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-09 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_25_chunk OWNER TO well_app;
--
-- Name: _hyper_4_26_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_26_chunk (
CONSTRAINT constraint_26 CHECK ((("time" >= '2024-10-09 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-16 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_26_chunk OWNER TO well_app;
--
-- Name: _hyper_4_27_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_27_chunk (
CONSTRAINT constraint_27 CHECK ((("time" >= '2024-10-16 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-23 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_27_chunk OWNER TO well_app;
--
-- Name: _hyper_4_28_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_28_chunk (
CONSTRAINT constraint_28 CHECK ((("time" >= '2024-10-23 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-10-30 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_28_chunk OWNER TO well_app;
--
-- Name: _hyper_4_29_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_29_chunk (
CONSTRAINT constraint_29 CHECK ((("time" >= '2024-10-30 17:00:00-07'::timestamp with time zone) AND ("time" < '2024-11-06 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_29_chunk OWNER TO well_app;
--
-- Name: _hyper_4_30_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_30_chunk (
CONSTRAINT constraint_30 CHECK ((("time" >= '2024-11-06 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-11-13 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_30_chunk OWNER TO well_app;
--
-- Name: _hyper_4_31_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_31_chunk (
CONSTRAINT constraint_31 CHECK ((("time" >= '2024-11-13 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-11-20 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_31_chunk OWNER TO well_app;
--
-- Name: _hyper_4_32_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_32_chunk (
CONSTRAINT constraint_32 CHECK ((("time" >= '2024-11-20 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-11-27 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_32_chunk OWNER TO well_app;
--
-- Name: _hyper_4_33_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_33_chunk (
CONSTRAINT constraint_33 CHECK ((("time" >= '2024-11-27 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-12-04 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_33_chunk OWNER TO well_app;
--
-- Name: _hyper_4_34_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_34_chunk (
CONSTRAINT constraint_34 CHECK ((("time" >= '2024-12-04 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-12-11 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_34_chunk OWNER TO well_app;
--
-- Name: _hyper_4_35_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_35_chunk (
CONSTRAINT constraint_35 CHECK ((("time" >= '2024-12-11 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-12-18 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_35_chunk OWNER TO well_app;
--
-- Name: _hyper_4_36_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_36_chunk (
CONSTRAINT constraint_36 CHECK ((("time" >= '2024-12-18 16:00:00-08'::timestamp with time zone) AND ("time" < '2024-12-25 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_36_chunk OWNER TO well_app;
--
-- Name: _hyper_4_37_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_37_chunk (
CONSTRAINT constraint_37 CHECK ((("time" >= '2024-12-25 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-01 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_37_chunk OWNER TO well_app;
--
-- Name: _hyper_4_38_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_38_chunk (
CONSTRAINT constraint_38 CHECK ((("time" >= '2025-01-01 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-08 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_38_chunk OWNER TO well_app;
--
-- Name: _hyper_4_39_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_39_chunk (
CONSTRAINT constraint_39 CHECK ((("time" >= '2025-01-08 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-15 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_39_chunk OWNER TO well_app;
--
-- Name: _hyper_4_40_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_40_chunk (
CONSTRAINT constraint_40 CHECK ((("time" >= '2025-01-15 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-22 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_40_chunk OWNER TO well_app;
--
-- Name: _hyper_4_41_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_41_chunk (
CONSTRAINT constraint_41 CHECK ((("time" >= '2025-01-22 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-01-29 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_41_chunk OWNER TO well_app;
--
-- Name: _hyper_4_42_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_42_chunk (
CONSTRAINT constraint_42 CHECK ((("time" >= '2025-01-29 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-02-05 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_42_chunk OWNER TO well_app;
--
-- Name: _hyper_4_43_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_43_chunk (
CONSTRAINT constraint_43 CHECK ((("time" >= '2025-02-05 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-02-12 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_43_chunk OWNER TO well_app;
--
-- Name: _hyper_4_44_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_44_chunk (
CONSTRAINT constraint_44 CHECK ((("time" >= '2025-02-12 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-02-19 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_44_chunk OWNER TO well_app;
--
-- Name: _hyper_4_46_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_46_chunk (
CONSTRAINT constraint_46 CHECK ((("time" >= '2025-02-19 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-02-26 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_46_chunk OWNER TO well_app;
--
-- Name: _hyper_4_47_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_47_chunk (
CONSTRAINT constraint_47 CHECK ((("time" >= '2025-02-26 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-03-05 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_47_chunk OWNER TO well_app;
--
-- Name: _hyper_4_50_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_50_chunk (
CONSTRAINT constraint_50 CHECK ((("time" >= '2025-03-05 16:00:00-08'::timestamp with time zone) AND ("time" < '2025-03-12 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_50_chunk OWNER TO well_app;
--
-- Name: _hyper_4_51_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_51_chunk (
CONSTRAINT constraint_51 CHECK ((("time" >= '2025-03-12 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-03-19 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_51_chunk OWNER TO well_app;
--
-- Name: _hyper_4_54_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_54_chunk (
CONSTRAINT constraint_54 CHECK ((("time" >= '2025-03-19 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-03-26 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_54_chunk OWNER TO well_app;
--
-- Name: _hyper_4_56_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_56_chunk (
CONSTRAINT constraint_56 CHECK ((("time" >= '2025-03-26 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-02 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_56_chunk OWNER TO well_app;
--
-- Name: _hyper_4_58_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_58_chunk (
CONSTRAINT constraint_58 CHECK ((("time" >= '2025-04-02 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-09 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_58_chunk OWNER TO well_app;
--
-- Name: _hyper_4_60_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_60_chunk (
CONSTRAINT constraint_60 CHECK ((("time" >= '2025-04-09 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-16 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_60_chunk OWNER TO well_app;
--
-- Name: _hyper_4_62_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_62_chunk (
CONSTRAINT constraint_62 CHECK ((("time" >= '2025-04-16 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-23 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_62_chunk OWNER TO well_app;
--
-- Name: _hyper_4_64_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_64_chunk (
CONSTRAINT constraint_64 CHECK ((("time" >= '2025-04-23 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-04-30 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_64_chunk OWNER TO well_app;
--
-- Name: _hyper_4_66_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_66_chunk (
CONSTRAINT constraint_66 CHECK ((("time" >= '2025-04-30 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-05-07 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_66_chunk OWNER TO well_app;
--
-- Name: _hyper_4_67_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_67_chunk (
CONSTRAINT constraint_67 CHECK ((("time" >= '2025-05-07 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-05-14 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_67_chunk OWNER TO well_app;
--
-- Name: _hyper_4_69_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_69_chunk (
CONSTRAINT constraint_69 CHECK ((("time" >= '2025-05-14 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-05-21 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_69_chunk OWNER TO well_app;
--
-- Name: _hyper_4_71_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_71_chunk (
CONSTRAINT constraint_71 CHECK ((("time" >= '2025-05-21 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-05-28 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_71_chunk OWNER TO well_app;
--
-- Name: _hyper_4_73_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_73_chunk (
CONSTRAINT constraint_73 CHECK ((("time" >= '2025-05-28 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-06-04 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_73_chunk OWNER TO well_app;
--
-- Name: _hyper_4_76_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_76_chunk (
CONSTRAINT constraint_76 CHECK ((("time" >= '2025-06-04 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-06-11 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_76_chunk OWNER TO well_app;
--
-- Name: _hyper_4_78_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_78_chunk (
CONSTRAINT constraint_78 CHECK ((("time" >= '2025-06-11 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-06-18 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_78_chunk OWNER TO well_app;
--
-- Name: _hyper_4_80_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_80_chunk (
CONSTRAINT constraint_80 CHECK ((("time" >= '2025-06-18 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-06-25 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_80_chunk OWNER TO well_app;
--
-- Name: _hyper_4_81_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_81_chunk (
CONSTRAINT constraint_81 CHECK ((("time" >= '2025-06-25 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-02 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_81_chunk OWNER TO well_app;
--
-- Name: _hyper_4_83_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_83_chunk (
CONSTRAINT constraint_83 CHECK ((("time" >= '2025-07-02 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-09 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_83_chunk OWNER TO well_app;
--
-- Name: _hyper_4_86_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_86_chunk (
CONSTRAINT constraint_86 CHECK ((("time" >= '2025-07-09 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-16 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_86_chunk OWNER TO well_app;
--
-- Name: _hyper_4_87_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_87_chunk (
CONSTRAINT constraint_87 CHECK ((("time" >= '2025-07-16 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-23 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_87_chunk OWNER TO well_app;
--
-- Name: _hyper_4_89_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_89_chunk (
CONSTRAINT constraint_89 CHECK ((("time" >= '2025-07-23 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-07-30 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_89_chunk OWNER TO well_app;
--
-- Name: _hyper_4_91_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_91_chunk (
CONSTRAINT constraint_91 CHECK ((("time" >= '1970-01-07 16:00:00-08'::timestamp with time zone) AND ("time" < '1970-01-14 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_91_chunk OWNER TO well_app;
--
-- Name: _hyper_4_92_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_92_chunk (
CONSTRAINT constraint_92 CHECK ((("time" >= '1970-09-02 17:00:00-07'::timestamp with time zone) AND ("time" < '1970-09-09 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_92_chunk OWNER TO well_app;
--
-- Name: _hyper_4_93_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_93_chunk (
CONSTRAINT constraint_93 CHECK ((("time" >= '2023-03-01 16:00:00-08'::timestamp with time zone) AND ("time" < '2023-03-08 16:00:00-08'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_93_chunk OWNER TO well_app;
--
-- Name: _hyper_4_94_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_94_chunk (
CONSTRAINT constraint_94 CHECK ((("time" >= '2025-07-30 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-08-06 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_94_chunk OWNER TO well_app;
--
-- Name: _hyper_4_96_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_96_chunk (
CONSTRAINT constraint_96 CHECK ((("time" >= '2025-08-06 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-08-13 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_96_chunk OWNER TO well_app;
--
-- Name: _hyper_4_98_chunk; Type: TABLE; Schema: _timescaledb_internal; Owner: well_app
--
CREATE TABLE _timescaledb_internal._hyper_4_98_chunk (
CONSTRAINT constraint_98 CHECK ((("time" >= '2025-08-13 17:00:00-07'::timestamp with time zone) AND ("time" < '2025-08-20 17:00:00-07'::timestamp with time zone)))
)
INHERITS (public.sensor_readings);
ALTER TABLE _timescaledb_internal._hyper_4_98_chunk OWNER TO well_app;
--
-- Name: alarms_voice; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.alarms_voice (
index integer NOT NULL,
"time" timestamp with time zone,
call_session_id text,
initiated text,
answered text,
playback_started text,
playback_ended text,
hangup text
);
ALTER TABLE public.alarms_voice OWNER TO postgres;
--
-- Name: arti_reports; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.arti_reports (
index integer NOT NULL,
content_raw text
);
ALTER TABLE public.arti_reports OWNER TO postgres;
--
-- Name: arti_reports_index_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
ALTER TABLE public.arti_reports ALTER COLUMN index ADD GENERATED ALWAYS AS IDENTITY (
SEQUENCE NAME public.arti_reports_index_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: azureq_2_rabbit_instances; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.azureq_2_rabbit_instances (
instance_id text NOT NULL,
last_heartbeat timestamp with time zone,
status text,
container_id text
);
ALTER TABLE public.azureq_2_rabbit_instances OWNER TO postgres;
--
-- Name: deployment_details; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.deployment_details (
deployment_id integer NOT NULL,
beneficiary_id integer,
caretaker_id integer,
owner_id integer,
installer_id integer,
devices text,
address_street text,
address_city text,
address_zip text,
address_state text,
address_country text,
wifis text,
lat real,
lng real,
gps_age integer,
note text,
floor_plan text,
overlapps text
);
ALTER TABLE public.deployment_details OWNER TO postgres;
--
-- Name: TABLE deployment_details; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON TABLE public.deployment_details IS 'secret!';
--
-- Name: deployment_history_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.deployment_history_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.deployment_history_id_seq OWNER TO postgres;
--
-- Name: deployment_history; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.deployment_history (
id integer DEFAULT nextval('public.deployment_history_id_seq'::regclass) NOT NULL,
deployment_id integer,
"time" real,
proximity text
);
ALTER TABLE public.deployment_history OWNER TO postgres;
--
-- Name: deployments; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.deployments (
deployment_id integer NOT NULL,
time_edit real,
user_edit integer,
time_zone_s text,
persons integer,
gender integer,
race integer,
born integer,
pets integer,
context text,
alarm_details text
);
ALTER TABLE public.deployments OWNER TO postgres;
--
-- Name: deployments_deployment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
ALTER TABLE public.deployments ALTER COLUMN deployment_id ADD GENERATED ALWAYS AS IDENTITY (
SEQUENCE NAME public.deployments_deployment_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: device_first_seen; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.device_first_seen (
device_id integer NOT NULL,
first_seen_at timestamp with time zone NOT NULL
);
ALTER TABLE public.device_first_seen OWNER TO postgres;
--
-- Name: devices; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.devices (
device_id integer NOT NULL,
device_mac text NOT NULL,
well_id integer,
description text,
location integer,
close_to text,
radar_threshold text,
fw_version text,
hw_version text,
ble_scan_period integer,
ble_scan_duration integer,
temperature_calib text,
humidity_calib text,
reporting_period_s integer,
reboot_time real,
led_schema text,
alert_details text,
other text,
group_id integer
);
ALTER TABLE public.devices OWNER TO postgres;
--
-- Name: COLUMN devices.description; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON COLUMN public.devices.description IS 'User-defined name for the specific location of the device on a job site (e.g., Kitchen Under Sink).';
--
-- Name: devices_device_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.devices_device_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.devices_device_id_seq OWNER TO postgres;
--
-- Name: devices_device_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.devices_device_id_seq OWNED BY public.devices.device_id;
--
-- Name: devices_last_reads; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.devices_last_reads (
device_id integer NOT NULL,
temperature text,
humidity text,
light text,
pressure_blip text,
radar text,
smell text,
last_ssids text,
last_btles text
);
ALTER TABLE public.devices_last_reads OWNER TO postgres;
--
-- Name: disclaimers; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.disclaimers (
id integer NOT NULL,
first_name text,
last_name text,
user_name text,
email text,
devices text,
date timestamp with time zone,
policy_version text
);
ALTER TABLE public.disclaimers OWNER TO postgres;
--
-- Name: disclaimers_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
ALTER TABLE public.disclaimers ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
SEQUENCE NAME public.disclaimers_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: format_contexts; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.format_contexts (
index integer NOT NULL,
voice_query text,
context text
);
ALTER TABLE public.format_contexts OWNER TO postgres;
--
-- Name: format_contexts_index_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.format_contexts_index_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.format_contexts_index_seq OWNER TO postgres;
--
-- Name: format_contexts_index_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.format_contexts_index_seq OWNED BY public.format_contexts.index;
--
-- Name: jobs; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.jobs (
job_id integer NOT NULL,
customer_name text,
mitigation_person_id integer,
key_person_name text,
key_person_mobile text,
key_person_email text,
address_street text,
address_city text,
address_zip text,
address_state text,
address_country text,
lat real,
lng real,
date_from timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
date_to timestamp with time zone,
job_status text DEFAULT 'Active'::text NOT NULL,
devices text,
alerts_config jsonb,
created_at timestamp with time zone DEFAULT CURRENT_TIMESTAMP,
user_edit integer
);
ALTER TABLE public.jobs OWNER TO postgres;
--
-- Name: TABLE jobs; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON TABLE public.jobs IS 'Stores job information for the WellDrySense water damage mitigation product.';
--
-- Name: COLUMN jobs.customer_name; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON COLUMN public.jobs.customer_name IS 'The name of the client for whom the job is being done.';
--
-- Name: COLUMN jobs.mitigation_person_id; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON COLUMN public.jobs.mitigation_person_id IS 'The user (from person_details) responsible for the job.';
--
-- Name: COLUMN jobs.key_person_name; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON COLUMN public.jobs.key_person_name IS 'The name of the primary contact person at the client site.';
--
-- Name: COLUMN jobs.date_to; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON COLUMN public.jobs.date_to IS 'The date the job was stopped or archived.';
--
-- Name: COLUMN jobs.job_status; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON COLUMN public.jobs.job_status IS 'Lifecycle status of the job: Active, Stopped, Archived.';
--
-- Name: COLUMN jobs.devices; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON COLUMN public.jobs.devices IS 'A JSON array of device MAC addresses assigned to this job.';
--
-- Name: COLUMN jobs.alerts_config; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON COLUMN public.jobs.alerts_config IS 'JSON object storing alert thresholds, e.g., {"temp_abs_high": 30, "hum_rel_above": 15}.';
--
-- Name: jobs_job_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.jobs_job_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.jobs_job_id_seq OWNER TO postgres;
--
-- Name: jobs_job_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.jobs_job_id_seq OWNED BY public.jobs.job_id;
--
-- Name: mobile_clients; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.mobile_clients (
mqtt_id text NOT NULL,
user_name text,
user_id integer,
last_message_time bigint,
last_message text
);
ALTER TABLE public.mobile_clients OWNER TO postgres;
--
-- Name: mobile_clients_messages; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.mobile_clients_messages (
id integer NOT NULL,
"time" bigint,
mqtt_id text,
message text,
function text
);
ALTER TABLE public.mobile_clients_messages OWNER TO postgres;
--
-- Name: mobile_clients_messages_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.mobile_clients_messages_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.mobile_clients_messages_id_seq OWNER TO postgres;
--
-- Name: mobile_clients_messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.mobile_clients_messages_id_seq OWNED BY public.mobile_clients_messages.id;
--
-- Name: node_reds; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.node_reds (
user_name text NOT NULL,
port integer,
status integer,
pid integer,
flow text,
last_activity integer,
time_on integer
);
ALTER TABLE public.node_reds OWNER TO postgres;
--
-- Name: node_reds_usage; Type: TABLE; Schema: public; Owner: well_app
--
CREATE TABLE public.node_reds_usage (
index integer NOT NULL,
user_name text,
port integer,
pid integer,
time_on integer,
time_off integer
);
ALTER TABLE public.node_reds_usage OWNER TO well_app;
--
-- Name: node_reds_usage_index_seq; Type: SEQUENCE; Schema: public; Owner: well_app
--
CREATE SEQUENCE public.node_reds_usage_index_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.node_reds_usage_index_seq OWNER TO well_app;
--
-- Name: node_reds_usage_index_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: well_app
--
ALTER SEQUENCE public.node_reds_usage_index_seq OWNED BY public.node_reds_usage.index;
--
-- Name: person_details; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.person_details (
user_id integer NOT NULL,
role_ids text,
access_to_deployments text,
email text,
user_name text,
first_name text,
last_name text,
address_street text,
address_city text,
address_zip text,
address_state text,
address_country text,
time_edit real,
user_edit integer,
phone_number text,
picture text,
key text
);
ALTER TABLE public.person_details OWNER TO postgres;
--
-- Name: TABLE person_details; Type: COMMENT; Schema: public; Owner: postgres
--
COMMENT ON TABLE public.person_details IS 'secret!';
--
-- Name: person_details_person_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
ALTER TABLE public.person_details ALTER COLUMN user_id ADD GENERATED ALWAYS AS IDENTITY (
SEQUENCE NAME public.person_details_person_id_seq
START WITH 34
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1
);
--
-- Name: queue_muncher_instances; Type: TABLE; Schema: public; Owner: well_app
--
CREATE TABLE public.queue_muncher_instances (
instance_id character varying NOT NULL,
last_heartbeat timestamp without time zone,
status character varying,
container_id character varying
);
ALTER TABLE public.queue_muncher_instances OWNER TO well_app;
--
-- Name: race; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.race (
race_id integer NOT NULL,
race_name text,
race_description text
);
ALTER TABLE public.race OWNER TO postgres;
--
-- Name: roles; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.roles (
role_id integer NOT NULL,
role_name text,
role_description text
);
ALTER TABLE public.roles OWNER TO postgres;
--
-- Name: telnyx_events; Type: TABLE; Schema: public; Owner: well_app
--
CREATE TABLE public.telnyx_events (
id integer NOT NULL,
"time" integer,
report text
);
ALTER TABLE public.telnyx_events OWNER TO well_app;
--
-- Name: temp_radar_readings; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.temp_radar_readings (
"time" timestamp with time zone,
device_id integer,
absent double precision,
moving double precision,
stationary double precision,
"both" double precision,
m0 double precision,
m1 double precision,
m2 double precision,
m3 double precision,
m4 double precision,
m5 double precision,
m6 double precision,
m7 double precision,
m8 double precision,
s0 double precision,
s1 double precision,
s2 double precision,
s3 double precision,
s4 double precision,
s5 double precision,
s6 double precision,
s7 double precision,
s8 double precision
);
ALTER TABLE public.temp_radar_readings OWNER TO postgres;
--
-- Name: temp_sensor_readings; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.temp_sensor_readings (
"time" timestamp with time zone,
device_id integer,
temperature double precision,
humidity double precision,
pressure double precision,
light double precision,
s0 double precision,
s1 double precision,
s2 double precision,
s3 double precision,
s4 double precision,
s5 double precision,
s6 double precision,
s7 double precision,
s8 double precision,
s9 double precision
);
ALTER TABLE public.temp_sensor_readings OWNER TO postgres;
--
-- Name: user_tokens; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.user_tokens (
id integer NOT NULL,
username character varying(255) NOT NULL,
token_id character varying(36) NOT NULL,
expires_at timestamp without time zone NOT NULL,
created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
revoked boolean DEFAULT false
);
ALTER TABLE public.user_tokens OWNER TO postgres;
--
-- Name: user_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.user_tokens_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.user_tokens_id_seq OWNER TO postgres;
--
-- Name: user_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.user_tokens_id_seq OWNED BY public.user_tokens.id;
--
-- Name: user_topics; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.user_topics (
id integer NOT NULL,
user_name character varying(255) NOT NULL,
topic character varying(255) NOT NULL,
permission character varying(2) NOT NULL,
created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
updated_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);
ALTER TABLE public.user_topics OWNER TO postgres;
--
-- Name: user_topics_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.user_topics_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.user_topics_id_seq OWNER TO postgres;
--
-- Name: user_topics_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.user_topics_id_seq OWNED BY public.user_topics.id;
--
-- Name: voice_contexts; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.voice_contexts (
index integer NOT NULL,
voice_query text,
context text
);
ALTER TABLE public.voice_contexts OWNER TO postgres;
--
-- Name: voice_contexts_index_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
CREATE SEQUENCE public.voice_contexts_index_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.voice_contexts_index_seq OWNER TO postgres;
--
-- Name: voice_contexts_index_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
ALTER SEQUENCE public.voice_contexts_index_seq OWNED BY public.voice_contexts.index;
--
-- Name: _hyper_4_100_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_100_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_102_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_102_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_104_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_104_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_106_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_106_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_108_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_108_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_110_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_110_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_112_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_112_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_115_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_115_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_116_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_116_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_118_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_118_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_120_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_120_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_122_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_122_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_124_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_124_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_126_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_126_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_23_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_23_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_24_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_24_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_25_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_25_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_26_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_26_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_27_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_27_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_28_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_28_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_29_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_29_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_30_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_30_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_31_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_31_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_32_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_32_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_33_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_33_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_34_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_34_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_35_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_35_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_36_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_36_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_37_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_37_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_38_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_38_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_39_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_39_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_40_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_40_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_41_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_41_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_42_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_42_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_43_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_43_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_44_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_44_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_46_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_46_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_47_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_47_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_50_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_50_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_51_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_51_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_54_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_54_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_56_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_56_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_58_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_58_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_60_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_60_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_62_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_62_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_64_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_64_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_66_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_66_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_67_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_67_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_69_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_69_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_71_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_71_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_73_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_73_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_76_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_76_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_78_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_78_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_80_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_80_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_81_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_81_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_83_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_83_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_86_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_86_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_87_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_87_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_89_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_89_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_91_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_91_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_92_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_92_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_93_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_93_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_94_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_94_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_96_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_96_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: _hyper_4_98_chunk mtype; Type: DEFAULT; Schema: _timescaledb_internal; Owner: well_app
--
ALTER TABLE ONLY _timescaledb_internal._hyper_4_98_chunk ALTER COLUMN mtype SET DEFAULT 0;
--
-- Name: devices device_id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.devices ALTER COLUMN device_id SET DEFAULT nextval('public.devices_device_id_seq'::regclass);
--
-- Name: format_contexts index; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.format_contexts ALTER COLUMN index SET DEFAULT nextval('public.format_contexts_index_seq'::regclass);
--
-- Name: jobs job_id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.jobs ALTER COLUMN job_id SET DEFAULT nextval('public.jobs_job_id_seq'::regclass);
--
-- Name: mobile_clients_messages id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.mobile_clients_messages ALTER COLUMN id SET DEFAULT nextval('public.mobile_clients_messages_id_seq'::regclass);
--
-- Name: node_reds_usage index; Type: DEFAULT; Schema: public; Owner: well_app
--
ALTER TABLE ONLY public.node_reds_usage ALTER COLUMN index SET DEFAULT nextval('public.node_reds_usage_index_seq'::regclass);
--
-- Name: user_tokens id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_tokens ALTER COLUMN id SET DEFAULT nextval('public.user_tokens_id_seq'::regclass);
--
-- Name: user_topics id; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_topics ALTER COLUMN id SET DEFAULT nextval('public.user_topics_id_seq'::regclass);
--
-- Name: voice_contexts index; Type: DEFAULT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.voice_contexts ALTER COLUMN index SET DEFAULT nextval('public.voice_contexts_index_seq'::regclass);
--
-- Name: alarms_voice alarms_voice_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.alarms_voice
ADD CONSTRAINT alarms_voice_pkey PRIMARY KEY (index);
--
-- Name: arti_reports arti_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.arti_reports
ADD CONSTRAINT arti_reports_pkey PRIMARY KEY (index);
--
-- Name: azureq_2_rabbit_instances azureq_2_rabbit_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.azureq_2_rabbit_instances
ADD CONSTRAINT azureq_2_rabbit_instances_pkey PRIMARY KEY (instance_id);
--
-- Name: deployment_details deployment_details_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.deployment_details
ADD CONSTRAINT deployment_details_pkey PRIMARY KEY (deployment_id);
--
-- Name: deployment_history deployment_history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.deployment_history
ADD CONSTRAINT deployment_history_pkey PRIMARY KEY (id);
--
-- Name: deployments deployments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.deployments
ADD CONSTRAINT deployments_pkey PRIMARY KEY (deployment_id);
--
-- Name: device_first_seen device_first_seen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.device_first_seen
ADD CONSTRAINT device_first_seen_pkey PRIMARY KEY (device_id);
--
-- Name: devices_last_reads devices_last_reads_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.devices_last_reads
ADD CONSTRAINT devices_last_reads_pkey PRIMARY KEY (device_id);
--
-- Name: devices devices_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.devices
ADD CONSTRAINT devices_pkey PRIMARY KEY (device_id);
--
-- Name: devices devices_well_mac_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.devices
ADD CONSTRAINT devices_well_mac_unique UNIQUE (well_id, device_mac);
--
-- Name: disclaimers disclaimers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.disclaimers
ADD CONSTRAINT disclaimers_pkey PRIMARY KEY (id);
--
-- Name: format_contexts format_contexts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.format_contexts
ADD CONSTRAINT format_contexts_pkey PRIMARY KEY (index);
--
-- Name: telnyx_events id; Type: CONSTRAINT; Schema: public; Owner: well_app
--
ALTER TABLE ONLY public.telnyx_events
ADD CONSTRAINT id PRIMARY KEY (id);
--
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.jobs
ADD CONSTRAINT jobs_pkey PRIMARY KEY (job_id);
--
-- Name: mobile_clients_messages mobile_clients_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.mobile_clients_messages
ADD CONSTRAINT mobile_clients_messages_pkey PRIMARY KEY (id);
--
-- Name: mobile_clients mobile_clients_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.mobile_clients
ADD CONSTRAINT mobile_clients_pkey PRIMARY KEY (mqtt_id);
--
-- Name: node_reds node-reds_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.node_reds
ADD CONSTRAINT "node-reds_pkey" PRIMARY KEY (user_name);
--
-- Name: node_reds_usage node_reds_usage_pkey; Type: CONSTRAINT; Schema: public; Owner: well_app
--
ALTER TABLE ONLY public.node_reds_usage
ADD CONSTRAINT node_reds_usage_pkey PRIMARY KEY (index);
--
-- Name: person_details person_details_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.person_details
ADD CONSTRAINT person_details_pkey PRIMARY KEY (user_id);
--
-- Name: queue_muncher_instances queue_muncher_instances_pkey; Type: CONSTRAINT; Schema: public; Owner: well_app
--
ALTER TABLE ONLY public.queue_muncher_instances
ADD CONSTRAINT queue_muncher_instances_pkey PRIMARY KEY (instance_id);
--
-- Name: race race_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.race
ADD CONSTRAINT race_pkey PRIMARY KEY (race_id);
--
-- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.roles
ADD CONSTRAINT roles_pkey PRIMARY KEY (role_id);
--
-- Name: user_tokens unique_token_id; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_tokens
ADD CONSTRAINT unique_token_id UNIQUE (token_id);
--
-- Name: user_topics unique_user_topic; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_topics
ADD CONSTRAINT unique_user_topic UNIQUE (user_name, topic);
--
-- Name: user_tokens user_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_tokens
ADD CONSTRAINT user_tokens_pkey PRIMARY KEY (id);
--
-- Name: user_topics user_topics_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.user_topics
ADD CONSTRAINT user_topics_pkey PRIMARY KEY (id);
--
-- Name: voice_contexts voice_contexts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.voice_contexts
ADD CONSTRAINT voice_contexts_pkey PRIMARY KEY (index);
--
-- Name: _hyper_3_101_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_101_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_101_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_101_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_101_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_101_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_103_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_103_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_103_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_103_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_103_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_103_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_105_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_105_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_105_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_105_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_105_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_105_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_107_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_107_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_107_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_107_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_107_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_107_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_109_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_109_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_109_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_109_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_109_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_109_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_10_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_10_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_10_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_10_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_10_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_10_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_111_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_111_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_111_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_111_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_111_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_111_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_113_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_113_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_113_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_113_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_113_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_113_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_114_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_114_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_114_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_114_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_114_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_114_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_117_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_117_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_117_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_117_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_117_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_117_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_119_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_119_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_119_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_119_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_119_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_119_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_11_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_11_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_11_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_11_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_11_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_11_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_121_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_121_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_121_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_121_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_121_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_121_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_123_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_123_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_123_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_123_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_123_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_123_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_125_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_125_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_125_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_125_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_125_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_125_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_127_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_127_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_127_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_127_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_127_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_127_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_12_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_12_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_12_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_12_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_12_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_12_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_13_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_13_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_13_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_13_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_13_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_13_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_14_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_14_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_14_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_14_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_14_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_14_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_15_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_15_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_15_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_15_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_15_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_15_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_16_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_16_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_16_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_16_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_16_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_16_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_17_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_17_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_17_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_17_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_17_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_17_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_18_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_18_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_18_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_18_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_18_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_18_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_19_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_19_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_19_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_19_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_19_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_19_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_1_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_1_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_1_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_1_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_1_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_1_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_20_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_20_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_20_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_20_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_20_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_20_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_21_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_21_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_21_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_21_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_21_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_21_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_22_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_22_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_22_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_22_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_22_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_22_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_2_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_2_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_2_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_2_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_2_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_2_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_3_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_3_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_3_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_3_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_3_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_3_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_45_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_45_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_45_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_45_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_45_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_45_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_48_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_48_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_48_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_48_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_48_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_48_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_49_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_49_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_49_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_49_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_49_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_49_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_4_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_4_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_4_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_4_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_4_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_4_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_52_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_52_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_52_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_52_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_52_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_52_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_53_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_53_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_53_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_53_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_53_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_53_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_55_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_55_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_55_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_55_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_55_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_55_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_57_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_57_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_57_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_57_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_57_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_57_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_59_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_59_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_59_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_59_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_59_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_59_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_5_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_5_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_5_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_5_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_5_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_5_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_61_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_61_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_61_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_61_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_61_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_61_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_63_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_63_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_63_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_63_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_63_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_63_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_65_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_65_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_65_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_65_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_65_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_65_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_68_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_68_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_68_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_68_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_68_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_68_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_6_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_6_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_6_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_6_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_6_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_6_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_70_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_70_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_70_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_70_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_70_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_70_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_72_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_72_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_72_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_72_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_72_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_72_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_74_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_74_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_74_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_74_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_74_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_74_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_75_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_75_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_75_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_75_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_75_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_75_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_77_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_77_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_77_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_77_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_77_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_77_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_79_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_79_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_79_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_79_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_79_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_79_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_7_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_7_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_7_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_7_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_7_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_7_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_82_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_82_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_82_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_82_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_82_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_82_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_84_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_84_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_84_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_84_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_84_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_84_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_85_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_85_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_85_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_85_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_85_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_85_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_88_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_88_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_88_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_88_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_88_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_88_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_8_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_8_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_8_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_8_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_8_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_8_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_90_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_90_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_90_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_90_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_90_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_90_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_95_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_95_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_95_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_95_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_95_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_95_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_97_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_97_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_97_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_97_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_97_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_97_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_99_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_99_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_99_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_99_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_99_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_99_chunk USING btree ("time" DESC);
--
-- Name: _hyper_3_9_chunk_idx_unified_radar_device_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_9_chunk_idx_unified_radar_device_utc ON _timescaledb_internal._hyper_3_9_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_3_9_chunk_unified_radar_readings_time_idx_utc; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_3_9_chunk_unified_radar_readings_time_idx_utc ON _timescaledb_internal._hyper_3_9_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_100_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_100_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_100_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_100_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_100_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_100_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_102_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_102_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_102_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_102_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_102_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_102_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_104_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_104_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_104_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_104_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_104_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_104_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_106_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_106_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_106_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_106_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_106_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_106_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_108_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_108_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_108_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_108_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_108_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_108_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_110_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_110_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_110_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_110_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_110_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_110_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_112_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_112_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_112_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_112_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_112_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_112_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_115_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_115_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_115_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_115_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_115_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_115_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_116_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_116_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_116_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_116_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_116_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_116_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_118_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_118_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_118_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_118_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_118_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_118_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_120_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_120_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_120_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_120_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_120_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_120_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_122_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_122_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_122_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_122_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_122_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_122_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_124_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_124_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_124_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_124_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_124_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_124_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_126_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_126_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_126_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_126_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_126_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_126_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_23_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_23_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_23_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_23_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_23_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_23_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_24_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_24_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_24_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_24_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_24_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_24_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_25_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_25_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_25_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_25_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_25_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_25_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_26_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_26_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_26_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_26_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_26_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_26_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_27_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_27_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_27_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_27_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_27_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_27_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_28_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_28_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_28_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_28_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_28_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_28_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_29_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_29_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_29_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_29_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_29_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_29_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_30_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_30_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_30_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_30_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_30_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_30_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_31_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_31_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_31_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_31_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_31_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_31_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_32_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_32_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_32_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_32_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_32_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_32_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_33_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_33_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_33_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_33_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_33_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_33_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_34_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_34_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_34_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_34_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_34_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_34_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_35_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_35_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_35_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_35_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_35_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_35_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_36_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_36_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_36_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_36_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_36_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_36_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_37_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_37_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_37_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_37_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_37_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_37_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_38_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_38_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_38_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_38_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_38_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_38_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_39_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_39_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_39_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_39_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_39_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_39_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_40_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_40_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_40_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_40_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_40_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_40_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_41_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_41_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_41_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_41_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_41_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_41_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_42_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_42_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_42_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_42_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_42_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_42_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_43_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_43_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_43_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_43_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_43_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_43_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_44_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_44_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_44_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_44_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_44_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_44_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_46_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_46_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_46_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_46_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_46_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_46_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_47_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_47_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_47_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_47_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_47_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_47_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_50_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_50_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_50_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_50_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_50_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_50_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_51_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_51_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_51_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_51_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_51_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_51_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_54_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_54_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_54_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_54_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_54_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_54_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_56_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_56_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_56_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_56_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_56_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_56_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_58_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_58_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_58_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_58_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_58_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_58_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_60_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_60_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_60_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_60_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_60_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_60_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_62_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_62_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_62_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_62_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_62_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_62_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_64_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_64_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_64_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_64_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_64_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_64_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_66_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_66_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_66_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_66_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_66_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_66_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_67_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_67_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_67_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_67_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_67_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_67_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_69_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_69_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_69_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_69_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_69_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_69_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_71_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_71_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_71_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_71_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_71_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_71_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_73_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_73_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_73_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_73_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_73_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_73_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_76_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_76_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_76_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_76_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_76_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_76_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_78_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_78_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_78_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_78_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_78_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_78_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_80_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_80_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_80_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_80_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_80_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_80_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_81_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_81_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_81_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_81_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_81_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_81_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_83_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_83_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_83_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_83_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_83_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_83_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_86_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_86_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_86_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_86_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_86_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_86_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_87_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_87_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_87_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_87_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_87_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_87_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_89_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_89_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_89_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_89_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_89_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_89_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_91_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_91_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_91_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_91_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_91_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_91_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_92_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_92_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_92_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_92_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_92_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_92_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_93_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_93_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_93_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_93_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_93_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_93_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_94_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_94_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_94_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_94_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_94_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_94_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_96_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_96_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_96_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_96_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_96_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_96_chunk USING btree ("time" DESC);
--
-- Name: _hyper_4_98_chunk_idx_unified_sensor_device; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_98_chunk_idx_unified_sensor_device ON _timescaledb_internal._hyper_4_98_chunk USING btree (device_id, "time" DESC);
--
-- Name: _hyper_4_98_chunk_unified_sensor_readings_time_idx; Type: INDEX; Schema: _timescaledb_internal; Owner: well_app
--
CREATE INDEX _hyper_4_98_chunk_unified_sensor_readings_time_idx ON _timescaledb_internal._hyper_4_98_chunk USING btree ("time" DESC);
--
-- Name: idx_jobs_job_status; Type: INDEX; Schema: public; Owner: postgres
--
CREATE INDEX idx_jobs_job_status ON public.jobs USING btree (job_status);
--
-- Name: idx_unified_radar_device_utc; Type: INDEX; Schema: public; Owner: well_app
--
CREATE INDEX idx_unified_radar_device_utc ON public.radar_readings USING btree (device_id, "time" DESC);
--
-- Name: idx_unified_sensor_device; Type: INDEX; Schema: public; Owner: well_app
--
CREATE INDEX idx_unified_sensor_device ON public.sensor_readings USING btree (device_id, "time" DESC);
--
-- Name: idx_user_tokens_token_id; Type: INDEX; Schema: public; Owner: postgres
--
CREATE INDEX idx_user_tokens_token_id ON public.user_tokens USING btree (token_id);
--
-- Name: idx_user_tokens_username; Type: INDEX; Schema: public; Owner: postgres
--
CREATE INDEX idx_user_tokens_username ON public.user_tokens USING btree (username);
--
-- Name: idx_user_topics_username; Type: INDEX; Schema: public; Owner: postgres
--
CREATE INDEX idx_user_topics_username ON public.user_topics USING btree (user_name);
--
-- Name: unified_radar_readings_time_idx_utc; Type: INDEX; Schema: public; Owner: well_app
--
CREATE INDEX unified_radar_readings_time_idx_utc ON public.radar_readings USING btree ("time" DESC);
--
-- Name: unified_sensor_readings_time_idx; Type: INDEX; Schema: public; Owner: well_app
--
CREATE INDEX unified_sensor_readings_time_idx ON public.sensor_readings USING btree ("time" DESC);
--
-- Name: radar_readings ts_insert_blocker; Type: TRIGGER; Schema: public; Owner: well_app
--
CREATE TRIGGER ts_insert_blocker BEFORE INSERT ON public.radar_readings FOR EACH ROW EXECUTE FUNCTION _timescaledb_functions.insert_blocker();
--
-- Name: sensor_readings ts_insert_blocker; Type: TRIGGER; Schema: public; Owner: well_app
--
CREATE TRIGGER ts_insert_blocker BEFORE INSERT ON public.sensor_readings FOR EACH ROW EXECUTE FUNCTION _timescaledb_functions.insert_blocker();
--
-- Name: jobs jobs_mitigation_person_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.jobs
ADD CONSTRAINT jobs_mitigation_person_id_fkey FOREIGN KEY (mitigation_person_id) REFERENCES public.person_details(user_id);
--
-- Name: jobs jobs_user_edit_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY public.jobs
ADD CONSTRAINT jobs_user_edit_fkey FOREIGN KEY (user_edit) REFERENCES public.person_details(user_id);
--
-- Name: FUNCTION add_compression_policy(hypertable regclass, compress_after "any", if_not_exists boolean, schedule_interval interval, initial_start timestamp with time zone, timezone text, compress_created_before interval, hypercore_use_access_method boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.add_compression_policy(hypertable regclass, compress_after "any", if_not_exists boolean, schedule_interval interval, initial_start timestamp with time zone, timezone text, compress_created_before interval, hypercore_use_access_method boolean) TO well_app;
--
-- Name: FUNCTION add_continuous_aggregate_policy(continuous_aggregate regclass, start_offset "any", end_offset "any", schedule_interval interval, if_not_exists boolean, initial_start timestamp with time zone, timezone text, include_tiered_data boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.add_continuous_aggregate_policy(continuous_aggregate regclass, start_offset "any", end_offset "any", schedule_interval interval, if_not_exists boolean, initial_start timestamp with time zone, timezone text, include_tiered_data boolean) TO well_app;
--
-- Name: FUNCTION add_dimension(hypertable regclass, dimension _timescaledb_internal.dimension_info, if_not_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.add_dimension(hypertable regclass, dimension _timescaledb_internal.dimension_info, if_not_exists boolean) TO well_app;
--
-- Name: FUNCTION add_dimension(hypertable regclass, column_name name, number_partitions integer, chunk_time_interval anyelement, partitioning_func regproc, if_not_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.add_dimension(hypertable regclass, column_name name, number_partitions integer, chunk_time_interval anyelement, partitioning_func regproc, if_not_exists boolean) TO well_app;
--
-- Name: FUNCTION add_job(proc regproc, schedule_interval interval, config jsonb, initial_start timestamp with time zone, scheduled boolean, check_config regproc, fixed_schedule boolean, timezone text); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.add_job(proc regproc, schedule_interval interval, config jsonb, initial_start timestamp with time zone, scheduled boolean, check_config regproc, fixed_schedule boolean, timezone text) TO well_app;
--
-- Name: FUNCTION add_reorder_policy(hypertable regclass, index_name name, if_not_exists boolean, initial_start timestamp with time zone, timezone text); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.add_reorder_policy(hypertable regclass, index_name name, if_not_exists boolean, initial_start timestamp with time zone, timezone text) TO well_app;
--
-- Name: FUNCTION add_retention_policy(relation regclass, drop_after "any", if_not_exists boolean, schedule_interval interval, initial_start timestamp with time zone, timezone text, drop_created_before interval); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.add_retention_policy(relation regclass, drop_after "any", if_not_exists boolean, schedule_interval interval, initial_start timestamp with time zone, timezone text, drop_created_before interval) TO well_app;
--
-- Name: FUNCTION alter_job(job_id integer, schedule_interval interval, max_runtime interval, max_retries integer, retry_period interval, scheduled boolean, config jsonb, next_start timestamp with time zone, if_exists boolean, check_config regproc, fixed_schedule boolean, initial_start timestamp with time zone, timezone text); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.alter_job(job_id integer, schedule_interval interval, max_runtime interval, max_retries integer, retry_period interval, scheduled boolean, config jsonb, next_start timestamp with time zone, if_exists boolean, check_config regproc, fixed_schedule boolean, initial_start timestamp with time zone, timezone text) TO well_app;
--
-- Name: FUNCTION approximate_row_count(relation regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.approximate_row_count(relation regclass) TO well_app;
--
-- Name: FUNCTION attach_tablespace(tablespace name, hypertable regclass, if_not_attached boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.attach_tablespace(tablespace name, hypertable regclass, if_not_attached boolean) TO well_app;
--
-- Name: FUNCTION by_hash(column_name name, number_partitions integer, partition_func regproc); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.by_hash(column_name name, number_partitions integer, partition_func regproc) TO well_app;
--
-- Name: FUNCTION by_range(column_name name, partition_interval anyelement, partition_func regproc); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.by_range(column_name name, partition_interval anyelement, partition_func regproc) TO well_app;
--
-- Name: FUNCTION chunk_columnstore_stats(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.chunk_columnstore_stats(hypertable regclass) TO well_app;
--
-- Name: FUNCTION chunk_compression_stats(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.chunk_compression_stats(hypertable regclass) TO well_app;
--
-- Name: FUNCTION chunks_detailed_size(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.chunks_detailed_size(hypertable regclass) TO well_app;
--
-- Name: FUNCTION compress_chunk(uncompressed_chunk regclass, if_not_compressed boolean, recompress boolean, hypercore_use_access_method boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.compress_chunk(uncompressed_chunk regclass, if_not_compressed boolean, recompress boolean, hypercore_use_access_method boolean) TO well_app;
--
-- Name: FUNCTION create_hypertable(relation regclass, dimension _timescaledb_internal.dimension_info, create_default_indexes boolean, if_not_exists boolean, migrate_data boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.create_hypertable(relation regclass, dimension _timescaledb_internal.dimension_info, create_default_indexes boolean, if_not_exists boolean, migrate_data boolean) TO well_app;
--
-- Name: FUNCTION create_hypertable(relation regclass, time_column_name name, partitioning_column name, number_partitions integer, associated_schema_name name, associated_table_prefix name, chunk_time_interval anyelement, create_default_indexes boolean, if_not_exists boolean, partitioning_func regproc, migrate_data boolean, chunk_target_size text, chunk_sizing_func regproc, time_partitioning_func regproc); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.create_hypertable(relation regclass, time_column_name name, partitioning_column name, number_partitions integer, associated_schema_name name, associated_table_prefix name, chunk_time_interval anyelement, create_default_indexes boolean, if_not_exists boolean, partitioning_func regproc, migrate_data boolean, chunk_target_size text, chunk_sizing_func regproc, time_partitioning_func regproc) TO well_app;
--
-- Name: FUNCTION decompress_chunk(uncompressed_chunk regclass, if_compressed boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.decompress_chunk(uncompressed_chunk regclass, if_compressed boolean) TO well_app;
--
-- Name: FUNCTION delete_job(job_id integer); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.delete_job(job_id integer) TO well_app;
--
-- Name: FUNCTION detach_tablespace(tablespace name, hypertable regclass, if_attached boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.detach_tablespace(tablespace name, hypertable regclass, if_attached boolean) TO well_app;
--
-- Name: FUNCTION detach_tablespaces(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.detach_tablespaces(hypertable regclass) TO well_app;
--
-- Name: FUNCTION disable_chunk_skipping(hypertable regclass, column_name name, if_not_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.disable_chunk_skipping(hypertable regclass, column_name name, if_not_exists boolean) TO well_app;
--
-- Name: FUNCTION drop_chunks(relation regclass, older_than "any", newer_than "any", "verbose" boolean, created_before "any", created_after "any"); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.drop_chunks(relation regclass, older_than "any", newer_than "any", "verbose" boolean, created_before "any", created_after "any") TO well_app;
--
-- Name: FUNCTION enable_chunk_skipping(hypertable regclass, column_name name, if_not_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.enable_chunk_skipping(hypertable regclass, column_name name, if_not_exists boolean) TO well_app;
--
-- Name: FUNCTION hypertable_approximate_detailed_size(relation regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.hypertable_approximate_detailed_size(relation regclass) TO well_app;
--
-- Name: FUNCTION hypertable_approximate_size(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.hypertable_approximate_size(hypertable regclass) TO well_app;
--
-- Name: FUNCTION hypertable_columnstore_stats(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.hypertable_columnstore_stats(hypertable regclass) TO well_app;
--
-- Name: FUNCTION hypertable_compression_stats(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.hypertable_compression_stats(hypertable regclass) TO well_app;
--
-- Name: FUNCTION hypertable_detailed_size(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.hypertable_detailed_size(hypertable regclass) TO well_app;
--
-- Name: FUNCTION hypertable_index_size(index_name regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.hypertable_index_size(index_name regclass) TO well_app;
--
-- Name: FUNCTION hypertable_size(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.hypertable_size(hypertable regclass) TO well_app;
--
-- Name: FUNCTION interpolate(value real, prev record, next record); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.interpolate(value real, prev record, next record) TO well_app;
--
-- Name: FUNCTION interpolate(value double precision, prev record, next record); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.interpolate(value double precision, prev record, next record) TO well_app;
--
-- Name: FUNCTION interpolate(value smallint, prev record, next record); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.interpolate(value smallint, prev record, next record) TO well_app;
--
-- Name: FUNCTION interpolate(value integer, prev record, next record); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.interpolate(value integer, prev record, next record) TO well_app;
--
-- Name: FUNCTION interpolate(value bigint, prev record, next record); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.interpolate(value bigint, prev record, next record) TO well_app;
--
-- Name: FUNCTION locf(value anyelement, prev anyelement, treat_null_as_missing boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.locf(value anyelement, prev anyelement, treat_null_as_missing boolean) TO well_app;
--
-- Name: FUNCTION move_chunk(chunk regclass, destination_tablespace name, index_destination_tablespace name, reorder_index regclass, "verbose" boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.move_chunk(chunk regclass, destination_tablespace name, index_destination_tablespace name, reorder_index regclass, "verbose" boolean) TO well_app;
--
-- Name: FUNCTION remove_compression_policy(hypertable regclass, if_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.remove_compression_policy(hypertable regclass, if_exists boolean) TO well_app;
--
-- Name: FUNCTION remove_continuous_aggregate_policy(continuous_aggregate regclass, if_not_exists boolean, if_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.remove_continuous_aggregate_policy(continuous_aggregate regclass, if_not_exists boolean, if_exists boolean) TO well_app;
--
-- Name: FUNCTION remove_reorder_policy(hypertable regclass, if_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.remove_reorder_policy(hypertable regclass, if_exists boolean) TO well_app;
--
-- Name: FUNCTION remove_retention_policy(relation regclass, if_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.remove_retention_policy(relation regclass, if_exists boolean) TO well_app;
--
-- Name: FUNCTION reorder_chunk(chunk regclass, index regclass, "verbose" boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.reorder_chunk(chunk regclass, index regclass, "verbose" boolean) TO well_app;
--
-- Name: FUNCTION set_adaptive_chunking(hypertable regclass, chunk_target_size text, INOUT chunk_sizing_func regproc, OUT chunk_target_size bigint); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.set_adaptive_chunking(hypertable regclass, chunk_target_size text, INOUT chunk_sizing_func regproc, OUT chunk_target_size bigint) TO well_app;
--
-- Name: FUNCTION set_chunk_time_interval(hypertable regclass, chunk_time_interval anyelement, dimension_name name); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.set_chunk_time_interval(hypertable regclass, chunk_time_interval anyelement, dimension_name name) TO well_app;
--
-- Name: FUNCTION set_integer_now_func(hypertable regclass, integer_now_func regproc, replace_if_exists boolean); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.set_integer_now_func(hypertable regclass, integer_now_func regproc, replace_if_exists boolean) TO well_app;
--
-- Name: FUNCTION set_number_partitions(hypertable regclass, number_partitions integer, dimension_name name); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.set_number_partitions(hypertable regclass, number_partitions integer, dimension_name name) TO well_app;
--
-- Name: FUNCTION set_partitioning_interval(hypertable regclass, partition_interval anyelement, dimension_name name); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.set_partitioning_interval(hypertable regclass, partition_interval anyelement, dimension_name name) TO well_app;
--
-- Name: FUNCTION show_chunks(relation regclass, older_than "any", newer_than "any", created_before "any", created_after "any"); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.show_chunks(relation regclass, older_than "any", newer_than "any", created_before "any", created_after "any") TO well_app;
--
-- Name: FUNCTION show_tablespaces(hypertable regclass); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.show_tablespaces(hypertable regclass) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width smallint, ts smallint); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width smallint, ts smallint) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width integer, ts integer); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width integer, ts integer) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width bigint, ts bigint); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width bigint, ts bigint) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts date); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts date) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts timestamp without time zone); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts timestamp without time zone) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts timestamp with time zone); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts timestamp with time zone) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width smallint, ts smallint, "offset" smallint); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width smallint, ts smallint, "offset" smallint) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width integer, ts integer, "offset" integer); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width integer, ts integer, "offset" integer) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width bigint, ts bigint, "offset" bigint); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width bigint, ts bigint, "offset" bigint) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts date, origin date); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts date, origin date) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts date, "offset" interval); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts date, "offset" interval) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts timestamp without time zone, "offset" interval); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts timestamp without time zone, "offset" interval) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts timestamp without time zone, origin timestamp without time zone); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts timestamp without time zone, origin timestamp without time zone) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts timestamp with time zone, "offset" interval); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts timestamp with time zone, "offset" interval) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts timestamp with time zone, origin timestamp with time zone); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts timestamp with time zone, origin timestamp with time zone) TO well_app;
--
-- Name: FUNCTION time_bucket(bucket_width interval, ts timestamp with time zone, timezone text, origin timestamp with time zone, "offset" interval); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket(bucket_width interval, ts timestamp with time zone, timezone text, origin timestamp with time zone, "offset" interval) TO well_app;
--
-- Name: FUNCTION time_bucket_gapfill(bucket_width smallint, ts smallint, start smallint, finish smallint); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket_gapfill(bucket_width smallint, ts smallint, start smallint, finish smallint) TO well_app;
--
-- Name: FUNCTION time_bucket_gapfill(bucket_width integer, ts integer, start integer, finish integer); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket_gapfill(bucket_width integer, ts integer, start integer, finish integer) TO well_app;
--
-- Name: FUNCTION time_bucket_gapfill(bucket_width bigint, ts bigint, start bigint, finish bigint); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket_gapfill(bucket_width bigint, ts bigint, start bigint, finish bigint) TO well_app;
--
-- Name: FUNCTION time_bucket_gapfill(bucket_width interval, ts date, start date, finish date); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket_gapfill(bucket_width interval, ts date, start date, finish date) TO well_app;
--
-- Name: FUNCTION time_bucket_gapfill(bucket_width interval, ts timestamp without time zone, start timestamp without time zone, finish timestamp without time zone); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket_gapfill(bucket_width interval, ts timestamp without time zone, start timestamp without time zone, finish timestamp without time zone) TO well_app;
--
-- Name: FUNCTION time_bucket_gapfill(bucket_width interval, ts timestamp with time zone, start timestamp with time zone, finish timestamp with time zone); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket_gapfill(bucket_width interval, ts timestamp with time zone, start timestamp with time zone, finish timestamp with time zone) TO well_app;
--
-- Name: FUNCTION time_bucket_gapfill(bucket_width interval, ts timestamp with time zone, timezone text, start timestamp with time zone, finish timestamp with time zone); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.time_bucket_gapfill(bucket_width interval, ts timestamp with time zone, timezone text, start timestamp with time zone, finish timestamp with time zone) TO well_app;
--
-- Name: FUNCTION timescaledb_post_restore(); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.timescaledb_post_restore() TO well_app;
--
-- Name: FUNCTION timescaledb_pre_restore(); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.timescaledb_pre_restore() TO well_app;
--
-- Name: FUNCTION first(anyelement, "any"); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.first(anyelement, "any") TO well_app;
--
-- Name: FUNCTION histogram(double precision, double precision, double precision, integer); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.histogram(double precision, double precision, double precision, integer) TO well_app;
--
-- Name: FUNCTION last(anyelement, "any"); Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON FUNCTION public.last(anyelement, "any") TO well_app;
--
-- Name: TABLE alarms_voice; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.alarms_voice TO well_app;
--
-- Name: TABLE arti_reports; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.arti_reports TO well_app;
--
-- Name: SEQUENCE arti_reports_index_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,USAGE ON SEQUENCE public.arti_reports_index_seq TO well_app;
--
-- Name: TABLE azureq_2_rabbit_instances; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.azureq_2_rabbit_instances TO well_app;
--
-- Name: TABLE deployment_details; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.deployment_details TO well_app;
--
-- Name: SEQUENCE deployment_history_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,USAGE ON SEQUENCE public.deployment_history_id_seq TO well_app;
--
-- Name: TABLE deployment_history; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.deployment_history TO well_app;
--
-- Name: TABLE deployments; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.deployments TO well_app;
--
-- Name: SEQUENCE deployments_deployment_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON SEQUENCE public.deployments_deployment_id_seq TO well_app;
--
-- Name: TABLE device_first_seen; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.device_first_seen TO well_app;
--
-- Name: TABLE devices; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.devices TO well_app;
--
-- Name: SEQUENCE devices_device_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON SEQUENCE public.devices_device_id_seq TO well_app;
--
-- Name: TABLE devices_last_reads; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.devices_last_reads TO well_app;
--
-- Name: TABLE disclaimers; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.disclaimers TO well_app;
--
-- Name: SEQUENCE disclaimers_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,USAGE ON SEQUENCE public.disclaimers_id_seq TO well_app;
--
-- Name: SEQUENCE format_contexts_index_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,USAGE ON SEQUENCE public.format_contexts_index_seq TO well_app;
--
-- Name: TABLE jobs; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.jobs TO well_app;
--
-- Name: SEQUENCE jobs_job_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,USAGE ON SEQUENCE public.jobs_job_id_seq TO well_app;
--
-- Name: TABLE mobile_clients; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.mobile_clients TO well_app;
--
-- Name: TABLE mobile_clients_messages; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.mobile_clients_messages TO well_app;
--
-- Name: SEQUENCE mobile_clients_messages_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON SEQUENCE public.mobile_clients_messages_id_seq TO well_app;
--
-- Name: TABLE node_reds; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE public.node_reds TO well_app;
--
-- Name: TABLE person_details; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.person_details TO well_app;
--
-- Name: SEQUENCE person_details_person_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON SEQUENCE public.person_details_person_id_seq TO well_app;
--
-- Name: TABLE race; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.race TO well_app;
--
-- Name: TABLE roles; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.roles TO well_app;
--
-- Name: TABLE user_tokens; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.user_tokens TO well_app;
--
-- Name: SEQUENCE user_tokens_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON SEQUENCE public.user_tokens_id_seq TO well_app;
--
-- Name: TABLE user_topics; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON TABLE public.user_topics TO well_app;
--
-- Name: SEQUENCE user_topics_id_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT ALL ON SEQUENCE public.user_topics_id_seq TO well_app;
--
-- Name: SEQUENCE voice_contexts_index_seq; Type: ACL; Schema: public; Owner: postgres
--
GRANT SELECT,USAGE ON SEQUENCE public.voice_contexts_index_seq TO well_app;
--
-- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: public; Owner: postgres
--
ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA public GRANT SELECT,USAGE ON SEQUENCES TO well_app;
--
-- PostgreSQL database dump complete
--
\unrestrict nEgDhKD6B4nWaKSvB1ltprY3sHDNBEhrNLwMHP5zWu9gM4hHDn5zuiRnbZjRlH7