表名：iotme_product | 字段标识 | 字段类型 |字段长度| 备注| | --- | --- |---|---| | id | int | 10 | 产品ID | | title| varchar | 50| 产品名称 | | description| varchar | 100| 产品描述 | | thumb| varchar | 100| 产品缩略图 (已删除)| | product_key | varchar | 10| 产品KEY | | node_type| tinyint| 1| 接入类型：1-dev2-net | | status| tinyint| 1| 状态：1-启用2-禁用 | | create_time| int| 10| 创建时间 | ``` CREATE TABLE `sys_iotme_product` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品名称', `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品描述', `thumb` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品缩略图', `node_type` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '接入类型：1-dev2-net', `product_key` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '产品KEY', `status` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '状态：1-启用2-禁用', `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品表' ```