文档
测试

获取未入库未使用的表

GET
http://192.168.1.118:8111/dataDir/getNotUsedTables?dataBaseName=tbuild&ifClassifyFlag=1&pageNumber=1&pageSize=10

请求参数

参数名
类型
描述
必填
dataBaseName
str
库名 例 :tbuild
必填
ifClassifyFlag
int
是否分配 1已分配 0未分配
必填
pageNumber
int
1 当前页数
必填
pageSize
int
10 每页展示条数
必填

说明 / 示例

请求示例 ```json http://192.168.1.118:8111/dataDir/getNotUsedTables?dataBaseName=tbuild&ifClassifyFlag=1&pageNumber=1&pageSize=10 ``` 返回示例 ```json { "status": 200, "data": { "total": 10, "list": [ { "id": 7, "status": 1, "pDirId": 1, "dirCode": "", "dirName": "", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 4, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-05-08 15:59:31", "updateUser": 1, "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 0 }, { "id": 11, "status": 1, "pDirId": 1, "dirCode": "g_bd_firebrigadeinfo", "dirName": "专职消防队信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 8, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 19 }, { "id": 12, "status": 1, "pDirId": 1, "dirCode": "g_bd_fireperson", "dirName": "消防机关人员表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 9, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 21 }, { "id": 13, "status": 1, "pDirId": 1, "dirCode": "g_bd_tallbuildabnormalsys", "dirName": "高层建筑异常信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 10, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 6 }, { "id": 14, "status": 1, "pDirId": 1, "dirCode": "f_bs_waterauditdtl", "dirName": "水源审核信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 11, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 7 }, { "id": 15, "status": 1, "pDirId": 1, "dirCode": "g_bd_firedepart", "dirName": "消防机构组织机构", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 12, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 23 }, { "id": 16, "status": 1, "pDirId": 1, "dirCode": "g_bd_firepersonattach", "dirName": "消防机关人员附件表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 13, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-04-27 14:48:42", "rowCount": 300, "rowCountError": 7, "ifSearch": 1, "columnNum": 6 }, { "id": 5, "status": 1, "pDirId": 1, "dirCode": "", "dirName": "", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 2, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-05-08 15:59:19", "updateUser": 1, "rowCount": 300, "rowCountError": 7, "ifSearch": 0, "columnNum": 0 }, { "id": 8, "status": 1, "pDirId": 1, "dirCode": "f_bs_firesafetycheckresultmaster", "dirName": "消防安全检查结果表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 5, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-05-08 15:15:24", "updateUser": 1, "rowCount": 300, "rowCountError": 7, "ifSearch": 0, "columnNum": 19 }, { "id": 9, "status": 1, "pDirId": 1, "dirCode": "g_bd_waterinfo", "dirName": "水源信息表", "dataBaseName": "tbuild", "dirLevel": 2, "dirDesc": "描述", "dirSort": 6, "createTime": "2021-04-27 14:48:42", "updateTime": "2021-05-08 15:20:41", "updateUser": 1, "rowCount": 300, "rowCountError": 7, "ifSearch": 0, "columnNum": 44 } ], "pageNum": 1, "pageSize": 10, "size": 10, "startRow": 0, "endRow": 9, "pages": 1, "prePage": 0, "nextPage": 0, "isFirstPage": true, "isLastPage": true, "hasPreviousPage": false, "hasNextPage": false, "navigatePages": 8, "navigatepageNums": [ 1 ], "navigateFirstPage": 1, "navigateLastPage": 1 } } ```