获取表字段
<p><strong>简要描述:</strong></p>
<ul>
<li>获取表字段</li>
</ul>
<p><strong>请求URL:</strong></p>
<ul>
<li><code>http://xx.com/indicator/indicatorbasicconfig/queryTableColumns</code></li>
</ul>
<p><strong>请求方式:</strong></p>
<ul>
<li>get</li>
</ul>
<p><strong>参数:</strong></p>
<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;">tableName</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">string</td>
<td>表名</td>
</tr>
</tbody>
</table>
<p><strong>返回示例</strong></p>
<pre><code> [
{
"columnComment": "主键",
"data_type": "bigint",
"tableName": "arc_alibaba_req_log",
"columnName": "id"
},
{
"columnComment": "用户客户号",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "consumer_no"
},
{
"columnComment": "第三方标识",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "tpp_nid"
},
{
"columnComment": "接口标识",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "business_nid"
},
{
"columnComment": "手拉手订单号",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "order_no"
},
{
"columnComment": "数据地址",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "data_url"
},
{
"columnComment": "获取数据请求",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "data_params"
},
{
"columnComment": "获取数据结果",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "data_result"
},
{
"columnComment": "获取数据异常",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "data_exception"
},
{
"columnComment": "获取数据时间",
"data_type": "datetime",
"tableName": "arc_alibaba_req_log",
"columnName": "data_time"
},
{
"columnComment": "原始数据存储ID",
"data_type": "varchar",
"tableName": "arc_alibaba_req_log",
"columnName": "store_order_no"
},
{
"columnComment": "记录创建时间",
"data_type": "datetime",
"tableName": "arc_alibaba_req_log",
"columnName": "add_time"
}
]</code></pre>
<p><strong>返回参数说明</strong></p>
<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;">tableName</td>
<td style="text-align: left;">string</td>
<td>表名称</td>
</tr>
<tr>
<td style="text-align: left;">columnName</td>
<td style="text-align: left;">string</td>
<td>字段名称</td>
</tr>
<tr>
<td style="text-align: left;">columnComment</td>
<td style="text-align: left;">string</td>
<td>字段描述</td>
</tr>
<tr>
<td style="text-align: left;">data_type</td>
<td style="text-align: left;">string</td>
<td>字段类型</td>
</tr>
<tr>
<td style="text-align: left;">dataType</td>
<td style="text-align: left;">string</td>
<td>字段类型(同data_type)</td>
</tr>
</tbody>
</table>
<p><strong>备注</strong></p>
<ul>
<li>更多返回错误代码请看首页的错误代码描述</li>
</ul>