/*
Navicat MySQL Data Transfer

Source Server         : lcoal
Source Server Version : 80033
Source Host           : localhost:3306
Source Database       : qianduan_sql

Target Server Type    : MYSQL
Target Server Version : 80033
File Encoding         : 65001

Date: 2023-07-11 11:42:16
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ea_t_device_info
-- ----------------------------
DROP TABLE IF EXISTS `ea_t_device_info`;
CREATE TABLE `ea_t_device_info` (
  `DI_GUID` varchar(16) NOT NULL,
  `DI_Code` varchar(50) DEFAULT NULL,
  `DI_Name` varchar(255) DEFAULT NULL COMMENT '设备名称',
  `DI_Device_Type_Id` int DEFAULT NULL,
  `DI_Device_Type` varchar(50) DEFAULT NULL,
  `DI_Scene_Type_Id` int 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,
  `DI_Supplier` varchar(255) DEFAULT NULL COMMENT '供应商',
  `DI_Online` bit(1) DEFAULT NULL COMMENT '是否在线',
  PRIMARY KEY (`DI_GUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;