CREATE TABLE TAB_Consumer (ConID INT NOT NULL AUTO_INCREMENT,ConDoorplate text, ConName text, HeatTypeID INT NOT NULL, ControllerID INT NOT NULL, HeatSize DOUBLE, ConMemo text, PRIMARY KEY ('ConID'), CONSTRAINT 'FK_HeatTypeID'FOREIGN KEY ('HeatTypeID') REFERENCES 'TAB_HeatType'('HeatTypeID'), CONSTRAINT 'FK_ControllerID' FOREIGN KEY ('ControllerID') REFERENCES 'TAB_Controller'('ControllerID')) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;