 
 COMMENT ON TABLE "EgaugeEnergyAutoload" IS 'Data that is autoload by the MSG eGauge Service. @author Daniel Zhang (張道博)';
 
+
+--
+-- Name: EgaugeInfo; Type: TABLE; Schema: public; Owner: eileen; Tablespace: 
+--
+
+CREATE TABLE "EgaugeInfo" (
+    svc_pt_id character varying,
+    address character varying,
+    egauge character varying
+);
+
+
+ALTER TABLE public."EgaugeInfo" OWNER TO eileen;
 
 --
 -- Name: Event; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 

    rest_of_house_usage_kw double precision,
    solarpump_kw double precision,
    stove_kw double precision,
    upload_date timestamp(6) without time zone
);





--
-- Name: EgaugeInfo; Type: ACL; Schema: public; Owner: eileen
--

REVOKE ALL ON TABLE "EgaugeInfo" FROM PUBLIC;
REVOKE ALL ON TABLE "EgaugeInfo" FROM eileen;
GRANT ALL ON TABLE "EgaugeInfo" TO eileen;
GRANT ALL ON TABLE "EgaugeInfo" TO sepgroup;
GRANT SELECT ON TABLE "EgaugeInfo" TO sepgroupreadonly;


--
-- Name: Event; Type: ACL; Schema: public; Owner: sepgroup
--

