表名： iotme_product_model | 字段标识 | 字段类型 |字段长度| 备注| | --- | --- |---|---| | id | int | 10 | ID | | product_key | varchar | 10| 产品KEY | | dev_type| varchar| 10| 设备类型 | | title| varchar| 50| 类型名称 | | identifier| varchar| 50| 标识符| | field_type| varchar| 20| 字段类型：int,varchar,tinyint,float| | decimal_digits| tinyint| 2| 小数位数| | length| tinyint| 2| 数据长度| | default_value| varchar| 10| 默认值| | unit| varchar| 10| 单位| | description| varchar| 100| 描述| | create_time| int| 10| 创建时间 | ``` CREATE TABLE `sys_iotme_product_model` ( `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 '类型名称', `identifier` varchar(50) NOT NULL DEFAULT '' COMMENT '标识符', `field_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '字段类型：int,varchar,tinyint,float', `decimal_digits` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '小数位数', `length` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '数据长度', `default_value` varchar(10) DEFAULT '' COMMENT '默认值', `unit` varchar(10) DEFAULT '' COMMENT '单位', `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品模型表' ```