新建任务时获取schema资产成员信息
<p>[TOC]</p>
<h5>简要描述</h5>
<ul>
<li>新建任务时,获取schema类型资产组成员的详细信息</li>
</ul>
<h5>请求URL</h5>
<ul>
<li><code>/api/v1/database/asset-group/schema-member-detail</code>
<h5>请求方式</h5></li>
<li><code>GET</code></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;">Long</td>
<td>资产组id</td>
</tr>
</tbody>
</table>
<h5>返回示例</h5>
<pre><code> {
"status": 200,
"msg": "ok",
"data": [
{
"schemaName": "aaa",
"tableMetaDatas": [
{
"tableName": "encrypt_check_results1",
"schemaName": null,
"columnNames": [
"id",
"ip",
"port",
"schemaName",
"modelName",
"tableName"
]
},
{
"tableName": "host1",
"schemaName": null,
"columnNames": [
"id",
"ip",
"port",
"dbType",
"dbName",
"tableName"
]
},
{
"tableName": "member1",
"schemaName": null,
"columnNames": [
"userid",
"username",
"password",
"email",
"groupid"
]
}
]
},
{
"schemaName": "test1",
"tableMetaDatas": [
{
"tableName": "baiwan",
"schemaName": null,
"columnNames": [
"姓名",
"详细地址",
"所在省份",
"手机号",
"身份证号",
"出生年月",
"邮箱"
]
},
{
"tableName": "baseline_check_results",
"schemaName": null,
"columnNames": [
"baselineId",
"taskId",
"code",
"currentValue"
]
},
{
"tableName": "host",
"schemaName": null,
"columnNames": [
"id",
"ip"
"updated_at",
"task_id"
]
},
{
"tableName": "host_bak",
"schemaName": null,
"columnNames": [
"id",
"ip",
"port",
"dbType",
"task_id"
]
},
{
"tableName": "member1",
"schemaName": null,
"columnNames": [
"userid",
"username",
"password",
"email"
]
},
{
"tableName": "member2",
"schemaName": null,
"columnNames": [
"Nickname",
"Name",
"Phone",
"Mobile"
]
},
{
"tableName": "t_zation_rules",
"schemaName": null,
"columnNames": [
"id",
"rule_name",
"type_id",
"rule_desc",
"type_name",
"time1"
]
},
{
"tableName": "test_able",
"schemaName": null,
"columnNames": [
"id",
"name",
"email",
"gender",
"age"
]
},
{
"tableName": "test_able_bak",
"schemaName": null,
"columnNames": [
"id",
"name",
"email",
"gender",
"age"
]
}
]
}
]
}</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;">status</td>
<td style="text-align: left;">int</td>
<td>请求返回状态，500：失败；200：成功</td>
</tr>
<tr>
<td style="text-align: left;">msg</td>
<td style="text-align: left;">string</td>
<td>请求返回消息，"ok"：成功；其他：失败消息</td>
</tr>
<tr>
<td style="text-align: left;">schemaName</td>
<td style="text-align: left;">String</td>
<td>模式(库)名</td>
</tr>
<tr>
<td style="text-align: left;">tableMetaDatas</td>
<td style="text-align: left;">对象数组</td>
<td>封装了表数据</td>
</tr>
<tr>
<td style="text-align: left;">tabeName</td>
<td style="text-align: left;">string</td>
<td>表名</td>
</tr>
<tr>
<td style="text-align: left;">columnNames</td>
<td style="text-align: left;">string数组</td>
<td>列名数组</td>
</tr>
</tbody>
</table>
<h5>备注</h5>
<ul>
<li>更多返回错误代码请看首页的错误代码描述</li>
</ul>