字段的访问历史记录
<h5>简要描述</h5>
<ul>
<li>字段的访问历史记录</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><code>http://xx.com/visitLog/getVisitLogDetailByColumn</code></li>
</ul>
<h5>请求方式</h5>
<ul>
<li>POST </li>
</ul>
<h5>参数</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">必选</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">currentPage</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>第几页</td>
</tr>
<tr>
<td style="text-align: left;">pageSize</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>每页几条</td>
</tr>
<tr>
<td style="text-align: left;">conditions</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>查询条件,嵌套一层json。conditions:{"proxyServerId":"226","columnsInSql":"ghca31.t_base_user.tid"}</td>
</tr>
</tbody>
</table>
<h5>返回示例</h5>
<pre><code>{
"total": 2,
"flag": true,
"data": [
{
"id": null,
"dbUser": null,
"accessDate": "2021-10-10 18:24:07",
"firstAccessDate": null,
"number": 0,
"proxyIp": null,
"proxyPort": null,
"status": "ERROR",
"accessSqlType": "SELECT",
"accessClient": "navicat",
"accessIp": "192.168.2.223",
"accessMac": "18-CC-18-8A-E5-B2",
"impactAction": "错误",
"tableNamesFamily": null,
"tableNum": 0,
"accessOsUser": null,
"columnsInSql": "ghca31.t_base_user.tid",
"proxyServerId": null
},
{
"id": null,
"dbUser": null,
"accessDate": "2021-10-10 18:16:51",
"firstAccessDate": null,
"number": 0,
"proxyIp": null,
"proxyPort": null,
"status": "SUCCESS",
"accessSqlType": "SELECT",
"accessClient": "navicat",
"accessIp": "192.168.2.223",
"accessMac": "18-CC-18-8A-E5-B2",
"impactAction": "错误",
"tableNamesFamily": null,
"tableNum": 0,
"accessOsUser": null,
"columnsInSql": "ghca31.t_base_user.tid",
"proxyServerId": null
}
]
}</code></pre>
<h5>返回参数说明</h5>
<table>
<thead>
<tr>
<th style="text-align: left;">参数名</th>
<th style="text-align: left;">类型</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">flag</td>
<td style="text-align: left;">boolean</td>
<td>状态</td>
</tr>
<tr>
<td style="text-align: left;">total</td>
<td style="text-align: left;">int</td>
<td>数据总条数</td>
</tr>
<tr>
<td style="text-align: left;">columnsInSql</td>
<td style="text-align: left;">string</td>
<td>字段名</td>
</tr>
<tr>
<td style="text-align: left;">accessDate</td>
<td style="text-align: left;">string</td>
<td>访问时间</td>
</tr>
<tr>
<td style="text-align: left;">accessSqlType</td>
<td style="text-align: left;">string</td>
<td>语句类型</td>
</tr>
<tr>
<td style="text-align: left;">accessClient</td>
<td style="text-align: left;">string</td>
<td>访问工具</td>
</tr>
<tr>
<td style="text-align: left;">accessIp</td>
<td style="text-align: left;">string</td>
<td>访问者IP</td>
</tr>
<tr>
<td style="text-align: left;">accessMac</td>
<td style="text-align: left;">string</td>
<td>访问者MAC</td>
</tr>
<tr>
<td style="text-align: left;">impactAction</td>
<td style="text-align: left;">string</td>
<td>响应动作</td>
</tr>
<tr>
<td style="text-align: left;">status</td>
<td style="text-align: left;">string</td>
<td>执行状态</td>
</tr>
</tbody>
</table>
<h5>备注</h5>
<ul>
<li>更多返回错误代码请看首页的错误代码描述</li>
</ul>