数据表

<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>