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;
|
