(舍)获取资产组下的库表字段信息
<p>[TOC]</p>
<h5>简要描述</h5>
<ul>
<li>获取资产组下的库表字段信息接口————使用资产组模块的查库表字段信息接口</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><code>/api/v1/dynamic-job/all-dbs-tables-columns</code></li>
</ul>
<h5>请求方式</h5>
<ul>
<li>GET </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;">assetId</td>
<td style="text-align: left;">是</td>
<td style="text-align: left;">integer</td>
<td>资产组id</td>
</tr>
</tbody>
</table>
<h5>返回示例</h5>
<pre><code> {
"status": 200,
"msg": "OK",
"data": [
{
"dbName": "capital",
"tables": [
{
"tableName": "student",
"fields": [
"id",
"name",
"phone",
"address",
"department_number",
"identity_card_number",
"age"
]
},
{
"tableName": "department",
"fields": [
"id",
"name",
"department_number",
"desec"
]
},
{
"tableName": "course",
"fields": [
"id",
"name",
"credit",
"desec"
]
},
{
"tableName": "student_course",
"fields": [
"student_id",
"course_id",
"id",
"grade"
]
},
{
"tableName": "person_info",
"fields": [
"id",
"name",
"phone",
"address",
"id_card_number",
"salary",
"age",
"birthday",
"created_time",
"income"
]
},
{
"tableName": "tab",
"fields": [
"ss"
]
},
{
"tableName": "sssss",
"fields": [
"aa"
]
}
]
},
{
"dbName": "schema01",
"tables": [
{
"tableName": "test02",
"fields": [
"id",
"email",
"address"
]
},
{
"tableName": "member3",
"fields": [
"会员账号",
"真实姓名",
"银行",
"银行卡号",
"实际出款",
"支行地址",
"订单备注",
"取现总额",
"手续费",
"提款前余额",
"方式",
"订单号",
"状态",
"申请时间",
"操作时间"
]
},
{
"tableName": "truncate",
"fields": [
"bb"
]
}
]
}
]
}
</code></pre>