create table ea_t_device_info ( DI_GUID VARCHAR(16) NOT NULL PRIMARY KEY, DI_Code VARCHAR(50) DEFAULT NULL, DI_Device_Type_Id int(11) DEFAULT NULL, DI_Device_Type VARCHAR(50) DEFAULT NULL, DI_Scene_Type_Id int(11) DEFAULT NULL, DI_Scene_Type VARCHAR(50) DEFAULT NULL, DI_Province_Code VARCHAR(50) DEFAULT NULL, DI_Province_Name VARCHAR(50) DEFAULT NULL, DI_City_Code VARCHAR(50) DEFAULT NULL, DI_City_Name VARCHAR(50) DEFAULT NULL, DI_District_Code VARCHAR(50) DEFAULT NULL, DI_District_Name VARCHAR(50) DEFAULT NULL, DI_Town_Code VARCHAR(50) DEFAULT NULL, DI_Town_Name VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8; create table ea_t_hazardous_waste_file ( HW_GUID VARCHAR(16) NOT NULL PRIMARY KEY, CI_GUID VARCHAR(50) DEFAULT NULL, HW_No VARCHAR(50) DEFAULT NULL, HB_Traffic_Unit VARCHAR(50) DEFAULT NULL, HB_Time datetime DEFAULT NULL, HB_Entrust_Amount Double DEFAULT NULL, HB_Own_Amount Double DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8; create table ea_t_hazardous_waste_record ( HR_GUID VARCHAR(16) NOT NULL PRIMARY KEY, CI_GUID VARCHAR(50) DEFAULT NULL, HR_Type VARCHAR(50) DEFAULT NULL, HR_Type_Code VARCHAR(50) DEFAULT NULL, HR_Amount Double DEFAULT NULL, HR_Time datetime DEFAULT NULL, HR_Dispose_Unit VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8; create table ea_t_overall_evaluation ( OE_GUID int(11) PRIMARY KEY, CI_GUID VARCHAR(50) DEFAULT NULL, OE_Score int(11) DEFAULT NULL, OE_Publish_Time datetime DEFAULT NULL, OE_Update_Time datetime DEFAULT NULL, OE_Scene_Type_Id tinyint(2) DEFAULT NULL, OE_Scene_Type VARCHAR(50) DEFAULT NULL, OE_Period VARCHAR(50) DEFAULT NULL, OE_Code_Level tinyint(2) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8; create table ea_t_punishment ( PM_GUID VARCHAR(16) NOT NULL PRIMARY KEY, PM_Name VARCHAR(50) DEFAULT NULL, PM_Time datetime DEFAULT NULL, PM_Reason VARCHAR(50) DEFAULT NULL, PM_Result VARCHAR(50) DEFAULT NULL, PM_Department VARCHAR(50) DEFAULT NULL, PM_Basis VARCHAR(50) DEFAULT NULL, PM_Scene_Id VARCHAR(50) DEFAULT NULL, PM_Extension1 VARCHAR(50) DEFAULT NULL, PM_Extension2 VARCHAR(50) DEFAULT NULL, PM_Extension3 VARCHAR(50) DEFAULT NULL, PM_Remark VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8; create table ea_t_vehicle_base_info ( VB_GUID VARCHAR(16) NOT NULL PRIMARY KEY, VB_Repair_License VARCHAR(50) DEFAULT NULL, VB_Repair_License_Validity VARCHAR(50) DEFAULT NULL, VB_Environment_Manager VARCHAR(50) DEFAULT NULL, VB_Environment_Manager_Tel VARCHAR(50) DEFAULT NULL, VB_Repair_Type VARCHAR(50) DEFAULT NULL, VB_Repair_Level VARCHAR(50) DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8; create table voc_t_hour_value ( VOC_ID int(11) PRIMARY KEY, VOC_Stat_Code VARCHAR(50) DEFAULT NULL, VOC_Create_Time datetime DEFAULT NULL, VOC_Data_Time datetime DEFAULT NULL, VOC_Value Double DEFAULT NULL, VOC_Fan_Electricity_1 Double DEFAULT NULL, VOC_Fan_Electricity_2 Double DEFAULT NULL, VOC_Fan_Electricity_3 Double DEFAULT NULL, VOC_Fan_Electricity_4 Double DEFAULT NULL, VOC_Fan_Electricity_5 Double DEFAULT NULL, VOC_Fan_Electricity_6 Double DEFAULT NULL )ENGINE =INNODB DEFAULT CHARSET= utf8;