 
 
 ALTER TABLE public."IrradianceData" OWNER TO sepgroup;
-
---
--- Name: IrradianceData_copy; Type: TABLE; Schema: public; Owner: christian; Tablespace: 
---
-
-CREATE TABLE "IrradianceData_copy" (
-    sensor_id integer NOT NULL,
-    irradiance_w_per_m2 double precision,
-    "timestamp" timestamp(6) without time zone NOT NULL
-);
-
-
-ALTER TABLE public."IrradianceData_copy" OWNER TO christian;
 
 --
 -- Name: IrradianceSensorInfo; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 

ALTER TABLE public."EgaugeInfo" OWNER TO eileen;

--
-- Name: Event; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 
--

CREATE TABLE "Event" (
    event_name character varying,
    event_time timestamp without time zone,
    event_text character varying,
    event_data_id bigint,
    event_id bigint NOT NULL
);


ALTER TABLE public."Event" OWNER TO sepgroup;

--
-- Name: EventData; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 
--

CREATE TABLE "EventData" (
    end_time timestamp without time zone,
    number_events smallint,
    start_time timestamp without time zone,
    meter_data_id bigint,
    event_data_id bigint NOT NULL
);


ALTER TABLE public."EventData" OWNER TO sepgroup;

--
-- Name: IrradianceData; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 
--




--
-- Name: mac_address_idx; Type: INDEX; Schema: public; Owner: sepgroup; Tablespace: 
--

CREATE INDEX mac_address_idx ON "MeterLocationHistory" USING btree (mac_address);


--
-- Name: meter_data_id_idx; Type: INDEX; Schema: public; Owner: sepgroup; Tablespace: 
--

