表名：iotme_device_type | 字段标识 | 字段类型 |字段长度| 备注| | --- | --- |---|---| | id | int | 10 | ID | | product_key | varchar | 10| 产品KEY | | dev_type| varchar| 10| 设备类型 | | title| varchar| 50| 类型标题 | | table_name| varchar| 50| 所属数据表名| | create_time| int| 10| 创建时间 | ``` CREATE TABLE `sys_iotme_device_type` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `product_key` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品KEY', `dev_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '设备类型', `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '类型标题', `table_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '所属数据表名', `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备类型表' ```