产品表 t_product

<ul> <li>产品表</li> </ul> <p><table border="0" cellpadding="0" cellspacing="0" width="712" style="border-collapse: collapse;width:536pt"><colgroup><col width="69" style="width:52pt"> <col width="103" style="mso-width-source:userset;mso-width-alt:3306;width:78pt"> <col width="265" style="mso-width-source:userset;mso-width-alt:8490;width:199pt"> <col width="125" style="mso-width-source:userset;mso-width-alt:3989;width:94pt"> <col width="81" style="mso-width-source:userset;mso-width-alt:2581;width:61pt"> <col width="69" style="width:52pt"></colgroup><tbody><tr height="19" style="height:14.0pt"><td height="19" class="xl65" width="69" style="height:14.0pt;width:52pt">序号</td><td class="xl65" width="103" style="width:78pt">字段名称</td><td class="xl65" width="265" style="width:199pt">注释</td><td class="xl65" width="125" style="width:94pt">必填</td><td class="xl65" width="81" style="width:61pt">数据类型</td><td class="xl65" width="69" style="width:52pt">主键唯一</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">1</td><td class="xl66">product_id</td><td class="xl66">id</td><td class="xl66">是</td><td class="xl66">int</td><td class="xl66">是</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">2</td><td class="xl66">product_mark</td><td class="xl66">产品标识</td><td class="xl66">是</td><td class="xl66" colspan="2" style="mso-ignore:colspan">varchar(255)</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">3</td><td class="xl66">password</td><td class="xl66">密码</td><td class="xl66">是</td><td class="xl66">varchar(64)</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">4</td><td class="xl66">salt</td><td class="xl66">盐值</td><td class="xl66">是</td><td class="xl66">varchar(8)</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">5</td><td class="xl66">device_name</td><td class="xl66">设备名称</td><td class="xl66">是</td><td class="xl66">varchar(64)</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">6</td><td class="xl66">start_time</td><td class="xl66">启动时间</td><td class="xl66">是</td><td class="xl66">datetime</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">7</td><td class="xl66">last_close_time</td><td class="xl66">上次关闭时间</td><td class="xl66">是</td><td class="xl66">datetime</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">8</td><td class="xl66">power</td><td class="xl66">电量</td><td class="xl66">否</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">9</td><td class="xl66">temperature</td><td class="xl66">温度</td><td class="xl66">否</td><td class="xl66">double(5,1)</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">10</td><td class="xl66">humidity</td><td class="xl66">湿度</td><td class="xl66">否</td><td class="xl66" colspan="2" style="mso-ignore:colspan">double(10,1)</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">11</td><td class="xl66">status</td><td class="xl66">状态;0：关闭 1：开启</td><td class="xl66">是</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">12</td><td class="xl66">admin_id</td><td class="xl66">管理员id</td><td class="xl66">是</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">13</td><td class="xl66">group_id</td><td class="xl66">分组ID</td><td class="xl66">否</td><td class="xl66">int</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">14</td><td class="xl66">update_time</td><td class="xl66">更新时间</td><td class="xl66">是</td><td class="xl66">timestamp</td><td class="xl66">　</td></tr><tr height="19" style="height:14.0pt"><td height="19" class="xl66" align="right" style="height:14.0pt">15</td><td class="xl66">create_time</td><td class="xl66">创建时间</td><td class="xl66">是</td><td class="xl66">timestamp</td><td class="xl66">　</td></tr></tbody></table></p>