<style>
table {
border-collapse: collapse;
border: 1px solid;
border-color: rgb(211, 202, 221);
}
table thead,
table tr {
border-top-width: 1px;
border-top-style: solid;
border-top-color: rgb(211, 202, 221);
}
table {
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: rgb(211, 202, 221);
}
table td,
table th {
padding: 5px 10px;
font-size: 14px;
font-family: Verdana;
color: rgb(95, 74, 121);
}
table tr:nth-child(even) {
background: rgb(223, 216, 232)
}
table tr:nth-child(odd) {
background: #FFF
}
</style>
<h3>终端设备（Device）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td>名称</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td>用户自定义的设备名，如'小明的手机'</td>
</tr>
<tr>
<td>Mac</td>
<td>MAC地址</td>
<td>String</td>
<td>17</td>
<td></td>
<td title="唯一索引">UQ</td>
<td></td>
<td>格式 AA:BB:CC:DD:EE:FF</td>
</tr>
<tr>
<td>IP</td>
<td>IP地址</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td>IPv4/IPv6</td>
</tr>
<tr>
<td>HostName</td>
<td>主机名</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td>DHCP上报的主机名</td>
</tr>
<tr>
<td>Kind</td>
<td>设备种类</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0未知/1手机/2电脑/3平板/4电视/5IoT/6其它</td>
</tr>
<tr>
<td>Vendor</td>
<td>厂商</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td>通过MAC前缀识别的设备厂商</td>
</tr>
<tr>
<td>Icon</td>
<td>图标</td>
<td>String</td>
<td>200</td>
<td></td>
<td></td>
<td></td>
<td>CSS类名或图标URL，如'fa-mobile'</td>
</tr>
<tr>
<td>MemberId</td>
<td>所属成员</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>关联Member表，一人可有多台终端</td>
</tr>
<tr>
<td>GroupId</td>
<td>分组</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>关联DeviceGroup</td>
</tr>
<tr>
<td>Online</td>
<td>在线</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>LastOnline</td>
<td>最后在线</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>OnlineTime</td>
<td>在线时间</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>今日在线秒数</td>
</tr>
<tr>
<td>Traffic</td>
<td>流量</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>今日流量（字节）</td>
</tr>
<tr>
<td>Logins</td>
<td>上线次数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>累计上线次数</td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>拉黑时禁用</td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>首次发现在线</td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>WAN接口（WanInterface）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td>名称</td>
<td>String</td>
<td>20</td>
<td></td>
<td title="唯一索引">UQ</td>
<td></td>
<td>如 eth0, ppp0</td>
</tr>
<tr>
<td>Kind</td>
<td>接入类型</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0DHCP/1PPPoE/2Static</td>
</tr>
<tr>
<td>IP</td>
<td>IPv4地址</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Ip6</td>
<td>IPv6地址</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Gateway</td>
<td>网关</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Netmask</td>
<td>子网掩码</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Weight</td>
<td>权重</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>负载均衡权重，数值越大流量越多</td>
</tr>
<tr>
<td>RouteTable</td>
<td>路由表</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>编号如100/200</td>
</tr>
<tr>
<td>IsDefault</td>
<td>默认路由</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxSpeed</td>
<td>下载速率</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>当前字节/秒</td>
</tr>
<tr>
<td>TxSpeed</td>
<td>上传速率</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>当前字节/秒</td>
</tr>
<tr>
<td>TotalRx</td>
<td>累计下载</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>字节</td>
</tr>
<tr>
<td>TotalTx</td>
<td>累计上传</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>字节</td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>PPPoE账号（PppoeAccount）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td>名称</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td>宽带账号</td>
</tr>
<tr>
<td>Password</td>
<td>密码</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Interface</td>
<td>网口</td>
<td>String</td>
<td>20</td>
<td></td>
<td title="唯一索引">UQ</td>
<td></td>
<td>物理网口如eth0</td>
</tr>
<tr>
<td>ServiceName</td>
<td>服务名</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td>ISP提供，可选</td>
</tr>
<tr>
<td>AutoReconnect</td>
<td>自动重拨</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>断线后自动重连</td>
</tr>
<tr>
<td>ReconnectDelay</td>
<td>重拨间隔</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>秒，默认30</td>
</tr>
<tr>
<td>Connected</td>
<td>已连接</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>PublicIp</td>
<td>公网IP</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td>拨号成功后获取</td>
</tr>
<tr>
<td>ConnectTime</td>
<td>连接时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>最近连接时间</td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>DHCP地址池（DhcpPool）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td>名称</td>
<td>String</td>
<td>45</td>
<td></td>
<td title="唯一索引">UQ</td>
<td></td>
<td>子网地址如192.168.1.0</td>
</tr>
<tr>
<td>Netmask</td>
<td>子网掩码</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td>如255.255.255.0</td>
</tr>
<tr>
<td>RangeStart</td>
<td>起始IP</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>RangeEnd</td>
<td>结束IP</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Gateway</td>
<td>网关</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>LeaseTime</td>
<td>租约时间</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>秒，默认86400</td>
</tr>
<tr>
<td>DnsServers</td>
<td>DNS服务器</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td>逗号分隔</td>
</tr>
<tr>
<td>Interface</td>
<td>绑定接口</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>如eth0</td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>设备分组（DeviceGroup）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td>名称</td>
<td>String</td>
<td>50</td>
<td></td>
<td title="唯一索引">UQ</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Description</td>
<td>描述</td>
<td>String</td>
<td>200</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Icon</td>
<td>图标</td>
<td>String</td>
<td>200</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>ParentId</td>
<td>父级</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0=顶级</td>
</tr>
<tr>
<td>Sort</td>
<td>排序</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>同级内排序</td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>DHCP静态绑定（DhcpBinding）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Mac</td>
<td>MAC地址</td>
<td>String</td>
<td>17</td>
<td></td>
<td title="唯一索引">UQ</td>
<td></td>
<td></td>
</tr>
<tr>
<td>IP</td>
<td>绑定IP</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>HostName</td>
<td>主机名</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>DeviceId</td>
<td>关联设备</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>DNS黑名单（DnsBlacklist）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Domain</td>
<td>域名</td>
<td>String</td>
<td>200</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Kind</td>
<td>匹配方式</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0精确/1通配/2正则/3关键词</td>
</tr>
<tr>
<td>Category</td>
<td>分类</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td>Ad/Tracker/Malware/Adult/Custom</td>
</tr>
<tr>
<td>Source</td>
<td>来源</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>BuiltIn/User</td>
</tr>
<tr>
<td>Hits</td>
<td>命中次数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>LastHit</td>
<td>最后命中</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Sort</td>
<td>排序</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>DNS规则（DnsRule）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Domain</td>
<td>域名</td>
<td>String</td>
<td>200</td>
<td></td>
<td></td>
<td></td>
<td>如example.com或*.example.com</td>
</tr>
<tr>
<td>TargetIp</td>
<td>目标IP</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td>劫持目标或上游DNS服务器IP</td>
</tr>
<tr>
<td>Kind</td>
<td>匹配方式</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0精确/1通配/2正则</td>
</tr>
<tr>
<td>RuleKind</td>
<td>规则类型</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0上游/1劫持/2屏蔽</td>
</tr>
<tr>
<td>Sort</td>
<td>排序</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>越小越优先</td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>防火墙规则（FirewallRule）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Kind</td>
<td>规则类型</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0DNAT/1SNAT/2Filter</td>
</tr>
<tr>
<td>Protocol</td>
<td>协议</td>
<td>String</td>
<td>10</td>
<td></td>
<td></td>
<td></td>
<td>tcp/udp/both</td>
</tr>
<tr>
<td>ExtPort</td>
<td>外部端口</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>IntIp</td>
<td>内网IP</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>IntPort</td>
<td>内网端口</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Interface</td>
<td>绑定接口</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>如eth0</td>
</tr>
<tr>
<td>Sort</td>
<td>排序</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>越小越优先</td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>网络日志（NetworkLog）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int64</td>
<td></td>
<td></td>
<td title="主键">PK</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Action</td>
<td>操作类型</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td>如PppoeConnect/FirewallAdd/DeviceBlock</td>
</tr>
<tr>
<td>Command</td>
<td>执行的命令</td>
<td>String</td>
<td>200</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Arguments</td>
<td>命令参数</td>
<td>String</td>
<td>1000</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>ExitCode</td>
<td>退出码</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0成功</td>
</tr>
<tr>
<td>Stdout</td>
<td>标准输出</td>
<td>String</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Stderr</td>
<td>标准错误</td>
<td>String</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Elapsed</td>
<td>耗时</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>毫秒</td>
</tr>
<tr>
<td>Success</td>
<td>成功</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>配置快照（ConfigSnapshot）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>FileName</td>
<td>文件名</td>
<td>String</td>
<td>200</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>BackupPath</td>
<td>备份路径</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>FileSize</td>
<td>文件大小</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>字节</td>
</tr>
<tr>
<td>SourcePath</td>
<td>源文件路径</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>家庭成员（Member）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>Name</td>
<td>成员姓名</td>
<td>String</td>
<td>50</td>
<td></td>
<td title="唯一索引">UQ</td>
<td></td>
<td>如'张三'，用于设备归属匹配</td>
</tr>
<tr>
<td>DisplayName</td>
<td>显示名</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td>页面展示用昵称，如'爸爸'</td>
</tr>
<tr>
<td>Mobile</td>
<td>手机号</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>可用于推送告警通知</td>
</tr>
<tr>
<td>Email</td>
<td>邮箱</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td>用于发送周报/月报</td>
</tr>
<tr>
<td>Avatar</td>
<td>头像URL</td>
<td>String</td>
<td>200</td>
<td></td>
<td></td>
<td></td>
<td>前端展示用</td>
</tr>
<tr>
<td>Role</td>
<td>角色</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>Parent=家长(可管理)/Child=孩子(受限)/Guest=访客(限时)</td>
</tr>
<tr>
<td>MonthlyQuota</td>
<td>月度流量配额</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>字节，0=不限。超出后触发告警并可限速</td>
</tr>
<tr>
<td>Enable</td>
<td>启用</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateUserId</td>
<td>创建用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateIp</td>
<td>创建地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateUserId</td>
<td>更新用户</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>UpdateIp</td>
<td>更新地址</td>
<td>String</td>
<td>50</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>设备在线快照（DeviceOnline）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int64</td>
<td></td>
<td></td>
<td title="主键">PK</td>
<td>N</td>
<td>雪花ID，保留历史快照</td>
</tr>
<tr>
<td>IP</td>
<td>IP地址</td>
<td>String</td>
<td>45</td>
<td></td>
<td title="唯一索引">UQ</td>
<td></td>
<td>当前活跃IP，IPv4/IPv6。统计时优先从此表按IP查DeviceId</td>
</tr>
<tr>
<td>Mac</td>
<td>MAC地址</td>
<td>String</td>
<td>17</td>
<td></td>
<td></td>
<td></td>
<td>ARP解析得到，是设备唯一标识。映射第一优先级：MAC精确匹配Device表</td>
</tr>
<tr>
<td>HostName</td>
<td>主机名</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td>DHCP/mDNS上报，如'XiaoMing-PC'。用于人工识别设备</td>
</tr>
<tr>
<td>DeviceId</td>
<td>关联设备</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>通过MAC查Device表得到，首次未知=0，后续自动关联</td>
</tr>
<tr>
<td>Interface</td>
<td>所在网口</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>如eth0/br-lan/wlan0。同IP在不同网口=不同设备，用于多网段隔离</td>
</tr>
<tr>
<td>LeaseExpire</td>
<td>DHCP租约过期</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>过期后IP可能被回收分配给其他设备，是IP漂移的预警信号</td>
</tr>
<tr>
<td>PrevMac</td>
<td>前一MAC</td>
<td>String</td>
<td>17</td>
<td></td>
<td></td>
<td></td>
<td>IP漂移时的旧MAC，审计关键：本次MAC≠上次MAC→IP已换设备→触发DeviceHistory事件</td>
</tr>
<tr>
<td>PrevDeviceId</td>
<td>前一设备ID</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>IP漂移时旧设备关联。事后统计可按PrevDeviceId修正历史数据</td>
</tr>
<tr>
<td>MacChangedTime</td>
<td>MAC变更时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>IP漂移发生的精确时刻，用于精确定位漂移窗口</td>
</tr>
<tr>
<td>FirstSeen</td>
<td>首次出现</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>本次会话首次在ARP表中出现的时间，即上线时刻</td>
</tr>
<tr>
<td>LastSeen</td>
<td>最后活跃</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>每分钟更新。LastSeen超过2分钟未更新→设备已下线→触发Offline事件</td>
</tr>
<tr>
<td>OnlineSeconds</td>
<td>本日在线秒数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>每分钟+60，用于快速展示今日在线时长，无需查DeviceHistory</td>
</tr>
<tr>
<td>IsOnline</td>
<td>是否在线</td>
<td>Boolean</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>LastSeen在2分钟以内=True。用于仪表盘实时在线数统计和告警</td>
</tr>
<tr>
<td>RxBytes</td>
<td>本日累计接收字节</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>从iptables计数器累加。异常暴增→大流量下载或视频播放</td>
</tr>
<tr>
<td>TxBytes</td>
<td>本日累计发送字节</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>上行>下行→P2P上传或直播推流，需关注是否异常</td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>UpdateTime</td>
<td>更新时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>每次采集同步时更新</td>
</tr>
</tbody>
</table>
<br></br>
<h3>设备历史（DeviceHistory）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int64</td>
<td></td>
<td></td>
<td title="主键">PK</td>
<td>N</td>
<td>雪花ID，事件自带时间信息</td>
</tr>
<tr>
<td>DeviceId</td>
<td>关联设备</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>事件所属设备</td>
</tr>
<tr>
<td>Mac</td>
<td>MAC地址</td>
<td>String</td>
<td>17</td>
<td></td>
<td></td>
<td></td>
<td>冗余存储，方便设备无关查询</td>
</tr>
<tr>
<td>IP</td>
<td>IP地址</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td>事件发生时的IP，事后审计可据此关联统计表</td>
</tr>
<tr>
<td>Action</td>
<td>事件类型</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>Online=上线/Offline=下线/IpChanged=IP变更/Reconnect=重连/NewDevice=新设备发现。Online事件发生后设备开始产生流量，Offline后停止</td>
</tr>
<tr>
<td>OldIP</td>
<td>旧IP</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td>IpChanged事件时记录变更前的IP，用于追踪设备IP变化轨迹</td>
</tr>
<tr>
<td>HostName</td>
<td>主机名</td>
<td>String</td>
<td>100</td>
<td></td>
<td></td>
<td></td>
<td>事件时的DHCP/mDNS主机名</td>
</tr>
<tr>
<td>Interface</td>
<td>所在网口</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>定位设备连接的物理位置（客厅AP/书房交换机等）</td>
</tr>
<tr>
<td>Duration</td>
<td>在线时长</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>秒。Offline事件时=本次在线总时长，用于计算日均在线时长</td>
</tr>
<tr>
<td>LeaseExpire</td>
<td>租约过期</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>DHCP租约到期时间，离线事件记录最后一次租约</td>
</tr>
<tr>
<td>Time</td>
<td>事件时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>精确的事件发生时刻，是时序分析的基础时间轴</td>
</tr>
<tr>
<td>Remark</td>
<td>备注</td>
<td>String</td>
<td>500</td>
<td></td>
<td></td>
<td></td>
<td>如'租约到期自然下线'、'手动标记离线'、'WiFi信号弱导致断线'</td>
</tr>
</tbody>
</table>
<br></br>
<h3>网口分钟统计（InterfaceStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int64</td>
<td></td>
<td></td>
<td title="主键">PK</td>
<td>N</td>
<td>雪花ID=分钟级时间戳，按天分表自动清理旧数据</td>
</tr>
<tr>
<td>InterfaceName</td>
<td>网口名</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td>如eth0/ppp0/br-lan。关联WanInterface.Name进行多线路分析</td>
</tr>
<tr>
<td>RxBytes</td>
<td>接收字节数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>每秒变化率=下行带宽占用。持续满载→运营商带宽不足或大流量下载，需升级套餐</td>
</tr>
<tr>
<td>RxPackets</td>
<td>接收包数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>配合RxBytes得平均包大小=RxBytes/RxPackets。均值<200字节且包量巨大→疑似DDoS小包攻击或DNS放大</td>
</tr>
<tr>
<td>RxErrors</td>
<td>接收硬件错误</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>CRC校验失败。正常恒为0；持续增长→网线老化/光模块故障/网卡硬件问题，需物理排查</td>
</tr>
<tr>
<td>RxDropped</td>
<td>接收丢包</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>内核缓冲区溢出丢弃。持续增长→CPU来不及处理，需调大ring buffer或升级CPU。用户感知为卡顿/断流</td>
</tr>
<tr>
<td>RxFifo</td>
<td>接收FIFO溢出</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>网卡硬件缓冲区溢出，比RxDropped更底层。增长→PCIe带宽不足或中断合并配置不当</td>
</tr>
<tr>
<td>RxFrame</td>
<td>帧对齐错误</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>主因=双工模式不匹配(一端全双工一端半双工)。增长→检查网口协商速率和双工模式</td>
</tr>
<tr>
<td>RxMulticast</td>
<td>接收组播包</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>家庭场景=IPTV/局域网设备发现(mDNS/SSDP)。异常暴增→组播风暴，需检查IGMP Snooping</td>
</tr>
<tr>
<td>TxBytes</td>
<td>发送字节数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>上行带宽占用。P2P上传或视频推流会显著推高</td>
</tr>
<tr>
<td>TxPackets</td>
<td>发送包数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>小包率偏高→可能是syn flood或扫描行为</td>
</tr>
<tr>
<td>TxErrors</td>
<td>发送硬件错误</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>正常恒为0；增长→网卡驱动bug或DMA故障</td>
</tr>
<tr>
<td>TxDropped</td>
<td>发送丢包</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>发送队列满丢弃=出口拥塞最直接证据。持续增长→带宽不足或QoS队列太小，需限速或升级</td>
</tr>
<tr>
<td>TxFifo</td>
<td>发送FIFO溢出</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>发送方向硬件缓冲区溢出</td>
</tr>
<tr>
<td>TxCarrier</td>
<td>载波丢失计数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>网线物理断开/松动的直接证据。相邻两次差值>0→此刻发生链路断开，是断网告警最快触发条件</td>
</tr>
<tr>
<td>TxColls</td>
<td>发送碰撞次数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>全双工交换机环境恒为0。增长→网口半双工或接入集线器</td>
</tr>
<tr>
<td>StatTime</td>
<td>统计时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>精确到分钟，如2026-07-02 14:30:00</td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>网口小时统计（InterfaceHourStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>InterfaceName</td>
<td>网口名</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>StatHour</td>
<td>统计小时</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>如2026-07-02 14:00:00</td>
</tr>
<tr>
<td>RxBytes</td>
<td>小时接收字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>SUM(InterfaceStat.RxBytes)</td>
</tr>
<tr>
<td>RxPackets</td>
<td>小时接收包合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxBytesMax</td>
<td>分钟接收峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>字节/秒。定位带宽瓶颈精确发生的分钟。峰值接近线路带宽→需扩容或QoS限速</td>
</tr>
<tr>
<td>RxPacketsMax</td>
<td>分钟接收包峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>小包PPS过高→可能DDoS攻击</td>
</tr>
<tr>
<td>RxErrors</td>
<td>接收错误合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>>0→该小时内有硬件异常</td>
</tr>
<tr>
<td>RxDropped</td>
<td>接收丢包合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>>0→该小时内有拥塞</td>
</tr>
<tr>
<td>TxBytes</td>
<td>小时发送字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxPackets</td>
<td>小时发送包合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxBytesMax</td>
<td>分钟发送峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>字节/秒</td>
</tr>
<tr>
<td>TxPacketsMax</td>
<td>分钟发送包峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxErrors</td>
<td>发送错误合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxDropped</td>
<td>发送丢包合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxCarrier</td>
<td>载波丢失次数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>>0→该小时内有物理断网</td>
</tr>
<tr>
<td>RxMulticast</td>
<td>组播包合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>OfflineCount</td>
<td>掉线次数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>该小时内网口down/up次数。>3次→链路不稳定，需检查网线/光模块/对端交换机</td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>网口日统计（InterfaceDayStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>InterfaceName</td>
<td>网口名</td>
<td>String</td>
<td>20</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>StatDay</td>
<td>统计日</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>如2026-07-02</td>
</tr>
<tr>
<td>RxBytes</td>
<td>日接收字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxBytes</td>
<td>日发送字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxBytesMax</td>
<td>小时接收峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>字节/小时。定位每日流量高峰时段</td>
</tr>
<tr>
<td>TxBytesMax</td>
<td>小时发送峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxErrors</td>
<td>日接收错误合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxDropped</td>
<td>日接收丢包合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxErrors</td>
<td>日发送错误合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxDropped</td>
<td>日发送丢包合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxCarrier</td>
<td>日载波丢失次数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>OfflineCount</td>
<td>日掉线次数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>>10次→严重不稳定，需排查链路</td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>设备分钟统计（DeviceStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int64</td>
<td></td>
<td></td>
<td title="主键">PK</td>
<td>N</td>
<td>雪花ID，按天分表</td>
</tr>
<tr>
<td>DeviceId</td>
<td>关联设备</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>映射优先级：1.MAC精确匹配 2.DeviceOnline.IP查DeviceOnline.DeviceId 3.Device.FindByIp取最近</td>
</tr>
<tr>
<td>IP</td>
<td>采集时的IP</td>
<td>String</td>
<td>45</td>
<td></td>
<td></td>
<td></td>
<td>冗余存储，事后若发现映射错误可按IP+时间修正。次要映射键</td>
</tr>
<tr>
<td>RxBytes</td>
<td>本分钟接收字节</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>每分钟差值=该设备下行速率。峰值时刻与视频播放/大文件下载时段重合</td>
</tr>
<tr>
<td>TxBytes</td>
<td>本分钟发送字节</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>上行/下行比例反转→P2P上传或直播推流</td>
</tr>
<tr>
<td>RxPackets</td>
<td>本分钟接收包数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>小包率=RxPackets*512<RxBytes→大包下载正常；反之为小包应用(DNS/游戏/聊天)</td>
</tr>
<tr>
<td>TxPackets</td>
<td>本分钟发送包数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>ConnCount</td>
<td>当前活跃连接数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>来自conntrack。手机正常50-150；>500→P2P/BT下载；>2000→疑似DDoS僵尸或挖矿木马</td>
</tr>
<tr>
<td>NewConnRate</td>
<td>本分钟新建连接数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>正常<100；>300→P2P连接建立；>1000→端口扫描攻击特征，需立即关注</td>
</tr>
<tr>
<td>DnsQueries</td>
<td>DNS查询次数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>来自dnsmasq日志。正常50-200/分钟；>500→域名扫描或DNS隧道</td>
</tr>
<tr>
<td>BlockedCount</td>
<td>防火墙拦截数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>安全策略命中量。持续增长→该设备正在访问黑名单域名/IP，安全风险</td>
</tr>
<tr>
<td>TcpRetrans</td>
<td>TCP重传次数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>来自conntrack统计。重传率>5%→该设备WiFi信号弱或网线质量差，用户体验严重下降</td>
</tr>
<tr>
<td>AvgRtt</td>
<td>平均往返时延</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>毫秒，通过ping/tcping统计。<10ms极佳；>100ms明显延迟；>500ms基本不可用。用于定位WiFi干扰或运营商问题</td>
</tr>
<tr>
<td>StatTime</td>
<td>统计时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>精确到分钟</td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>设备小时统计（DeviceHourStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>DeviceId</td>
<td>关联设备</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>StatHour</td>
<td>统计小时</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>RxBytes</td>
<td>小时接收字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxBytes</td>
<td>小时发送字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxBytesMax</td>
<td>分钟接收峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>字节/分。定位该设备带宽消耗最大的分钟</td>
</tr>
<tr>
<td>TxBytesMax</td>
<td>分钟发送峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>ConnCountMax</td>
<td>最大连接数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>连接数峰值时刻=设备网络活动最密集时刻</td>
</tr>
<tr>
<td>TcpRetrans</td>
<td>TCP重传合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>小时重传>500→该设备WiFi/网线质量严重差</td>
</tr>
<tr>
<td>AvgRttMin</td>
<td>最小时延</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>ms。反映最佳网络状态</td>
</tr>
<tr>
<td>AvgRttMax</td>
<td>最大时延</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>ms。RttMax-RttMin=抖动，>100ms严重影响VoIP/游戏</td>
</tr>
<tr>
<td>BlockedCount</td>
<td>防火墙拦截合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>DnsQueries</td>
<td>DNS查询合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>OfflineCount</td>
<td>掉线次数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>小时掉线>3→设备WiFi信号极差或频繁休眠唤醒</td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>设备日统计（DeviceDayStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>DeviceId</td>
<td>关联设备</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>StatDay</td>
<td>统计日</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>RxBytes</td>
<td>日接收字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>日流量>10GB→大量视频下载，可能超出月度配额</td>
</tr>
<tr>
<td>TxBytes</td>
<td>日发送字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxBytesMax</td>
<td>小时接收峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>定位每日流量高峰时段(通常是晚间19-22点)</td>
</tr>
<tr>
<td>TxBytesMax</td>
<td>小时发送峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TotalConns</td>
<td>日总连接数</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>异常暴增(>10万)→设备可能中病毒发起扫描</td>
</tr>
<tr>
<td>TcpRetrans</td>
<td>TCP重传合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>日重传>1000→设备网络质量长期差，建议检查网线/WiFi信道</td>
</tr>
<tr>
<td>BlockedCount</td>
<td>日防火墙拦截合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>OnlineSeconds</td>
<td>日在线秒数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>反映设备使用时长。异常短(<600秒)→设备可能故障或用户外出</td>
</tr>
<tr>
<td>OfflineCount</td>
<td>日掉线次数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>成员分钟统计（MemberStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int64</td>
<td></td>
<td></td>
<td title="主键">PK</td>
<td>N</td>
<td>雪花ID，按天分表</td>
</tr>
<tr>
<td>MemberId</td>
<td>关联成员</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>汇总该成员所有Device的DeviceStat</td>
</tr>
<tr>
<td>DeviceCount</td>
<td>当前在线设备数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>一人多设备同时在线。突然增加→新设备接入，关注是否未经授权</td>
</tr>
<tr>
<td>RxBytes</td>
<td>所有设备接收字节汇总</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>家庭流量账单依据，可设置月度配额告警</td>
</tr>
<tr>
<td>TxBytes</td>
<td>所有设备发送字节汇总</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxPackets</td>
<td>接收包汇总</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxPackets</td>
<td>发送包汇总</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TotalConns</td>
<td>所有设备总连接数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>异常高→某设备可能在跑P2P或被控</td>
</tr>
<tr>
<td>NewConnRate</td>
<td>每分钟新建连接汇总</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>DnsQueries</td>
<td>DNS查询汇总</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>分析该成员的域名访问模式，异常域名可关联到具体成员</td>
</tr>
<tr>
<td>BlockedCount</td>
<td>防火墙拦截汇总</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>反映该成员的安全风险等级：持续高→可能误入钓鱼/恶意网站</td>
</tr>
<tr>
<td>TcpRetrans</td>
<td>TCP重传汇总</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>重传集中在某成员→该成员WiFi环境差。可推送APP提醒靠近路由器</td>
</tr>
<tr>
<td>AvgRtt</td>
<td>平均时延</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>加权平均，反映该成员整体上网流畅度</td>
</tr>
<tr>
<td>OnlineSeconds</td>
<td>本分钟在线秒数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>0-60。60=全程在线；<60=该分钟有设备断网或休眠</td>
</tr>
<tr>
<td>StatTime</td>
<td>统计时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>成员小时统计（MemberHourStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>MemberId</td>
<td>关联成员</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>StatHour</td>
<td>统计小时</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>DeviceCount</td>
<td>平均在线设备数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxBytes</td>
<td>小时接收字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxBytes</td>
<td>小时发送字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxBytesMax</td>
<td>分钟接收峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>定位该成员带宽消耗最大的时刻</td>
</tr>
<tr>
<td>TxBytesMax</td>
<td>分钟发送峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TotalConns</td>
<td>最大连接数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TcpRetrans</td>
<td>TCP重传合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>AvgRttMin</td>
<td>最小时延</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>AvgRttMax</td>
<td>最大时延</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>抖动=Max-Min>100ms→VoIP/游戏体验差</td>
</tr>
<tr>
<td>BlockedCount</td>
<td>防火墙拦截合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>DnsQueries</td>
<td>DNS查询合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>OnlineSeconds</td>
<td>小时在线秒数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>反映该成员用网时长。异常短→可能外出或断网</td>
</tr>
<tr>
<td>OfflineCount</td>
<td>掉线次数合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
<h3>成员日统计（MemberDayStat）</h3>
<table>
<thead>
<tr>
<th>名称</th>
<th>显示名</th>
<th>类型</th>
<th>长度</th>
<th>精度</th>
<th>主键</th>
<th>允许空</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>Id</td>
<td>编号</td>
<td>Int32</td>
<td></td>
<td></td>
<td title="自增">AI</td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>MemberId</td>
<td>关联成员</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>StatDay</td>
<td>统计日</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td>DeviceCount</td>
<td>当日活跃设备数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>反映该成员有多少设备在使用。突然增加→新设备需关注</td>
</tr>
<tr>
<td>RxBytes</td>
<td>日接收字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxBytes</td>
<td>日发送字节合计</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>RxBytesMax</td>
<td>小时接收峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TxBytesMax</td>
<td>小时发送峰值</td>
<td>Int64</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>TcpRetrans</td>
<td>TCP重传合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>BlockedCount</td>
<td>日防火墙拦截合计</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>OnlineSeconds</td>
<td>日在线秒数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td>异常短→成员今天基本没上网</td>
</tr>
<tr>
<td>OfflineCount</td>
<td>日掉线次数</td>
<td>Int32</td>
<td></td>
<td></td>
<td></td>
<td>N</td>
<td></td>
</tr>
<tr>
<td>CreateTime</td>
<td>创建时间</td>
<td>DateTime</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<br></br>
|