     solarpump_kw double precision,
     upload_date timestamp(6) without time zone,
     microwave_kw double precision,
-    acplus_kw double precision
+    acplus_kw double precision,
+    dryer_usage_kw double precision,
+    garage_ac_kw double precision,
+    garage_ac_usage_kw double precision,
+    large_ac_kw double precision,
+    large_ac_usage_kw double precision,
+    oven_kw double precision,
+    oven_usage_kw double precision,
+    range_kw double precision,
+    range_usage_kw double precision,
+    refrigerator_kw double precision,
+    refrigerator_usage_kw double precision,
+    rest_of_house_usage_kw double precision,
+    clotheswasher_usage_kw double precision
 );
 
 

--

ALTER TABLE ONLY "EgaugeEnergyAutoload"
    ADD CONSTRAINT "EgaugeEnergyAutoload_pkey" PRIMARY KEY (house_id, datetime);


--

--

CREATE TABLE "EgaugeEnergyAutoload" (
    egauge_id integer NOT NULL,
    datetime timestamp(6) without time zone NOT NULL,
    use_kw double precision,
    gen_kw double precision,
