 --
 
 COMMENT ON TABLE "IntervalReadData" IS 'Part of the Reading branch for MECO energy data. --Daniel Zhang (張道博)';
-
-
---
--- Name: MeterData; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 
---
-
-CREATE TABLE "MeterData" (
-    meter_data_id bigint NOT NULL,
-    mac_id character(23) NOT NULL,
-    meter_name character(8) NOT NULL,
-    util_device_id character(8) NOT NULL,
-    created timestamp without time zone
-);
-
-
-ALTER TABLE public."MeterData" OWNER TO sepgroup;
-
---
--- Name: TABLE "MeterData"; Type: COMMENT; Schema: public; Owner: sepgroup
---
-
-COMMENT ON TABLE "MeterData" IS 'Root table for MECO energy data. This table is set to cascade delete so that deletions here are propagated through the MECO energy data branches. --Daniel Zhang (張道博)';
-
-
---
--- Name: COLUMN "MeterData".created; Type: COMMENT; Schema: public; Owner: sepgroup
---
-
-COMMENT ON COLUMN "MeterData".created IS 'timestamp for when data is inserted';
 
 
 --



--
-- Name: IrradianceData_copy_pkey1; Type: CONSTRAINT; Schema: public; Owner: christian; Tablespace: 
--

ALTER TABLE ONLY "IrradianceData_copy"
    ADD CONSTRAINT "IrradianceData_copy_pkey1" PRIMARY KEY (sensor_id, "timestamp");


--
-- Name: KiheiSCADATemperatureHumidity_copy_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; 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: 
--

