数据表
<ul>
<li>cloud_model_label </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>label_code</td>
<td>varchar (20)</td>
<td>否</td>
<td></td>
<td>标签码</td>
</tr>
<tr>
<td>label_name</td>
<td>varchar (20)</td>
<td>否</td>
<td></td>
<td>标签名称</td>
</tr>
<tr>
<td>cloud_model_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>模型id(云端)</td>
</tr>
</tbody>
</table>
<ul>
<li>cloud_model_shop_manage </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>model_cloud_code</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>模型云code</td>
</tr>
<tr>
<td>name</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>模型名称</td>
</tr>
<tr>
<td>description</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>模型描述</td>
</tr>
<tr>
<td>image_path</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>模型图片地址</td>
</tr>
<tr>
<td>create_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>创建人ID</td>
</tr>
<tr>
<td>update_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>更新人ID</td>
</tr>
<tr>
<td>create_time</td>
<td>varchar (20)</td>
<td>是</td>
<td></td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>varchar (20)</td>
<td>是</td>
<td></td>
<td>更新时间</td>
</tr>
<tr>
<td>deleted</td>
<td>tinyint (1)</td>
<td>否</td>
<td>0</td>
<td>是否删除 1:删除 0:未删除</td>
</tr>
</tbody>
</table>
<ul>
<li>ai_algo </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>label_name</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>标签名称</td>
</tr>
<tr>
<td>label</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>标签</td>
</tr>
<tr>
<td>description</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>描述</td>
</tr>
<tr>
<td>model_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>算法模型ID</td>
</tr>
<tr>
<td>effective_time</td>
<td>varchar (255)</td>
<td>是</td>
<td></td>
<td>生效时间 json</td>
</tr>
<tr>
<td>sampling_frequency</td>
<td>int</td>
<td>是</td>
<td></td>
<td>采样评率 单位/s</td>
</tr>
<tr>
<td>confidence</td>
<td>double (2)</td>
<td>是</td>
<td></td>
<td>置信度</td>
</tr>
<tr>
<td>alarm_save</td>
<td>tinyint (1)</td>
<td>是</td>
<td></td>
<td>告警生成 1:生成 2: 不生成</td>
</tr>
<tr>
<td>event_num</td>
<td>int</td>
<td>是</td>
<td></td>
<td>告警包含事件数 单位:条</td>
</tr>
<tr>
<td>alarm_duration</td>
<td>int</td>
<td>是</td>
<td></td>
<td>告警时长 单位:秒</td>
</tr>
<tr>
<td>wait_duration</td>
<td>int</td>
<td>是</td>
<td></td>
<td>等待处理时长 单位:秒</td>
</tr>
<tr>
<td>state</td>
<td>tinyint (1)</td>
<td>是</td>
<td></td>
<td>状态 1:开启 2:关闭</td>
</tr>
<tr>
<td>create_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>创建人ID</td>
</tr>
<tr>
<td>upate_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>更新人ID</td>
</tr>
<tr>
<td>create_time</td>
<td>varchar (20)</td>
<td>否</td>
<td></td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>varchar (20)</td>
<td>否</td>
<td></td>
<td>更新时间</td>
</tr>
<tr>
<td>deleted</td>
<td>tinyint (1)</td>
<td>否</td>
<td>0</td>
<td>是否删除 1:删除 0:未删除</td>
</tr>
</tbody>
</table>
<ul>
<li>ai_algo_event_result </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>algo_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>算法ID</td>
</tr>
<tr>
<td>device_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>设备ID</td>
</tr>
<tr>
<td>event_image_path</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>事件图片地址</td>
</tr>
<tr>
<td>event_time</td>
<td>varchar (20)</td>
<td>否</td>
<td></td>
<td>事件时间</td>
</tr>
<tr>
<td>deleted</td>
<td>tinyint (1)</td>
<td>否</td>
<td></td>
<td>是否删除 1:删除 0:未删除</td>
</tr>
</tbody>
</table>
<ul>
<li>ai_algo_model </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>algo_name</td>
<td>varchar (20)</td>
<td>否</td>
<td></td>
<td>算法名称</td>
</tr>
<tr>
<td>algo_code</td>
<td>varchar (50)</td>
<td>否</td>
<td></td>
<td>算法码</td>
</tr>
<tr>
<td>image</td>
<td>varchar (255)</td>
<td>是</td>
<td></td>
<td>算法展示图</td>
</tr>
<tr>
<td>expire_date</td>
<td>varchar (50)</td>
<td>是</td>
<td></td>
<td>到期日期</td>
</tr>
<tr>
<td>expire_state</td>
<td>tinyint (1)</td>
<td>否</td>
<td>2</td>
<td>到期状态 1:到期 0:未到期 2:未操作2</td>
</tr>
<tr>
<td>state</td>
<td>tinyint (1)</td>
<td>否</td>
<td>0</td>
<td>状态:1 启用 0 禁用</td>
</tr>
<tr>
<td>description</td>
<td>varchar (255)</td>
<td>是</td>
<td></td>
<td>算法描述</td>
</tr>
<tr>
<td>active_code</td>
<td>varchar (255)</td>
<td>是</td>
<td></td>
<td>激活码</td>
</tr>
<tr>
<td>active_state</td>
<td>tinyint (1)</td>
<td>否</td>
<td>0</td>
<td>激活状态 1:激活 0:未激活</td>
</tr>
<tr>
<td>create_id</td>
<td>int</td>
<td>是</td>
<td></td>
<td>创建人ID</td>
</tr>
<tr>
<td>update_id</td>
<td>int</td>
<td>是</td>
<td></td>
<td>更新人ID</td>
</tr>
<tr>
<td>create_date</td>
<td>varchar (255)</td>
<td>是</td>
<td></td>
<td>创建时间</td>
</tr>
<tr>
<td>update_date</td>
<td>varchar (255)</td>
<td>是</td>
<td></td>
<td>更新时间</td>
</tr>
<tr>
<td>deleted</td>
<td>tinyint (1)</td>
<td>否</td>
<td>0</td>
<td>是否删除 1:已删除 0:未删除</td>
</tr>
<tr>
<td>cloud_code</td>
<td>varchar (255)</td>
<td>是</td>
<td></td>
<td>云模型code</td>
</tr>
</tbody>
</table>
<ul>
<li>ai_cloud_model_shop </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>model_cloud_code</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>模型云code</td>
</tr>
<tr>
<td>name</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>模型名称</td>
</tr>
<tr>
<td>description</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>模型描述</td>
</tr>
<tr>
<td>image_path</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>模型图片地址</td>
</tr>
</tbody>
</table>
<ul>
<li>ai_data_reporting_setting </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>name</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>推送昵称</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>否</td>
<td></td>
<td>推送类型 1:告警 2:事件</td>
</tr>
<tr>
<td>url</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>推送URL</td>
</tr>
<tr>
<td>token</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>token</td>
</tr>
<tr>
<td>request_type</td>
<td>tinyint (1)</td>
<td>否</td>
<td>1</td>
<td>请求类型 1:post 2:get 3:put 4:delete</td>
</tr>
<tr>
<td>encode_type</td>
<td>tinyint (1)</td>
<td>否</td>
<td>1</td>
<td>内容编码 1:json 2:其他</td>
</tr>
<tr>
<td>create_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>创建人ID</td>
</tr>
<tr>
<td>update_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>更新人ID</td>
</tr>
<tr>
<td>create_time</td>
<td>varchar (20)</td>
<td>否</td>
<td></td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>varchar (20)</td>
<td>否</td>
<td></td>
<td>更新时间</td>
</tr>
<tr>
<td>deleted</td>
<td>tinyint (1)</td>
<td>否</td>
<td>0</td>
<td>删除状态 1:删除 0:未删除</td>
</tr>
</tbody>
</table>
<ul>
<li>ai_reporting_device </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>reporting_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>推送配置ID</td>
</tr>
<tr>
<td>algo_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>算法ID</td>
</tr>
</tbody>
</table>
<ul>
<li>ai_reporting_event </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>reporting_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>推送配置ID</td>
</tr>
<tr>
<td>device_id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>设备ID</td>
</tr>
</tbody>
</table>
<ul>
<li>ai_user </li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>允许空</th>
<th>默认</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>否</td>
<td></td>
<td>ID</td>
</tr>
<tr>
<td>user_name</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>登录用户名</td>
</tr>
<tr>
<td>password</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>登录密码</td>
</tr>
<tr>
<td>nick_name</td>
<td>varchar (255)</td>
<td>否</td>
<td></td>
<td>用户昵称</td>
</tr>
<tr>
<td>status</td>
<td>int</td>
<td>否</td>
<td>0</td>
<td>帐号状态(0正常 1停用)</td>
</tr>
<tr>
<td>login_ip</td>
<td>varchar (20)</td>
<td>是</td>
<td></td>
<td>最后登录IP</td>
</tr>
<tr>
<td>login_date</td>
<td>varchar (20)</td>
<td>是</td>
<td></td>
<td>最后登录时间</td>
</tr>
<tr>
<td>pwd_update_date</td>
<td>varchar (20)</td>
<td>是</td>
<td></td>
<td>密码最后更新时间</td>
</tr>
<tr>
<td>remark</td>
<td>varchar (500)</td>
<td>是</td>
<td></td>
<td>备注</td>
</tr>
<tr>
<td>deleted</td>
<td>tinyint (1)</td>
<td>是</td>
<td></td>
<td>删除状态 1:删除 0:未删除</td>
</tr>
</tbody>
</table>