文档
测试

根据表ID获取所有字段

GET
http://192.168.1.118:8111/searchColumnLink/getColumnNameList

接口描述

/searchColumnLink/getColumnNameList 根据表ID获取所有字段 需要查询和不需要

请求参数

参数名
类型
描述
必填
databaseId
int
库id
必填
tableId
int
表Id
必填

响应参数

参数名
类型
描述
必填
msg
string
示例:success
必填
code
int
示例:0
必填
columnInfo
array
数据列表
必填
columnName
string
示例:FAddress
必填
remark
object
示例:null
必填
ifSearch
int
示例:1
必填

说明 / 示例

请求示例 ```json http://192.168.1.118:8111/searchColumnLink/getColumnNameList?databaseId=1&tableId=5 ``` 返回示例 ```json { "msg": "success", "code": 0, "columnInfo": [ { "columnName": "Ftallbuild_Name", "remark": "", "ifSearch": 1 }, { "columnName": "FAddress", "remark": "", "ifSearch": 1 }, { "columnName": "Ftallbuild_UUID", "remark": "", "ifSearch": 0 }, { "columnName": "FSP_name", "remark": "", "ifSearch": 0 }, { "columnName": "Ftallbuild_Code", "remark": "", "ifSearch": 0 }, { "columnName": "Fprovince_Code", "remark": "", "ifSearch": 0 }, { "columnName": "Fcity_Code", "remark": "", "ifSearch": 0 }, { "columnName": "Fcounty_Code", "remark": "", "ifSearch": 0 }, { "columnName": "Fcorps_uuid", "remark": "所在消防总队", "ifSearch": 0 }, { "columnName": "Fcorps_name", "remark": "所在消防总队名称", "ifSearch": 0 }, { "columnName": "Fbranch_uuid", "remark": "所在消防支队", "ifSearch": 0 }, { "columnName": "Fbranch_name", "remark": "所在消防支队", "ifSearch": 0 }, { "columnName": "Ffiredepart_UUID", "remark": "消防机构组织标识(大队)", "ifSearch": 0 }, { "columnName": "Ffiredepart_Name", "remark": "消防机构组织标识(大队)", "ifSearch": 0 }, { "columnName": "Fsquadron_uuid", "remark": "", "ifSearch": 0 }, { "columnName": "Fsquadron_name", "remark": "", "ifSearch": 0 }, { "columnName": "FLevel", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_social", "remark": "", "ifSearch": 0 }, { "columnName": "Fsocial_UUID", "remark": "", "ifSearch": 0 }, { "columnName": "Fsocial_Name", "remark": "", "ifSearch": 0 }, { "columnName": "Flink_Man", "remark": "", "ifSearch": 0 }, { "columnName": "Ftel_No", "remark": "", "ifSearch": 0 }, { "columnName": "FFire_Rating", "remark": "", "ifSearch": 0 }, { "columnName": "Fpower_load", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_Singleproperty", "remark": "", "ifSearch": 0 }, { "columnName": "Fcomplete_Date", "remark": "", "ifSearch": 0 }, { "columnName": "Ftallbuild_height", "remark": "", "ifSearch": 0 }, { "columnName": "Ftallbuild_Area", "remark": "", "ifSearch": 0 }, { "columnName": "Ftallbuild_up_Area", "remark": "", "ifSearch": 0 }, { "columnName": "Ftallbuild_down_Area", "remark": "", "ifSearch": 0 }, { "columnName": "Ftallbuild_Up_floor", "remark": "", "ifSearch": 0 }, { "columnName": "Ftallbuild_down_floor", "remark": "", "ifSearch": 0 }, { "columnName": "Funit", "remark": "", "ifSearch": 0 }, { "columnName": "Fbuild_class", "remark": "", "ifSearch": 0 }, { "columnName": "Fbuild_class_name", "remark": "", "ifSearch": 0 }, { "columnName": "Ffactory_Rating", "remark": "", "ifSearch": 0 }, { "columnName": "Fstore_Rating", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_autofire", "remark": "", "ifSearch": 0 }, { "columnName": "Ffire_Elevator", "remark": "", "ifSearch": 0 }, { "columnName": "MerchantCount", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_maint", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_check", "remark": "", "ifSearch": 0 }, { "columnName": "FFireSafetyCheckIsNomal", "remark": "", "ifSearch": 0 }, { "columnName": "FLongitude", "remark": "", "ifSearch": 0 }, { "columnName": "FLatitude", "remark": "", "ifSearch": 0 }, { "columnName": "FManagerType", "remark": "", "ifSearch": 0 }, { "columnName": "Flogo", "remark": "", "ifSearch": 0 }, { "columnName": "Fprovince_ID", "remark": "", "ifSearch": 0 }, { "columnName": "FDescription", "remark": "", "ifSearch": 0 }, { "columnName": "Fcreator_ID", "remark": "", "ifSearch": 0 }, { "columnName": "Fcreator_Name", "remark": "", "ifSearch": 0 }, { "columnName": "Fcreat_Time", "remark": "", "ifSearch": 0 }, { "columnName": "Flast_Editor_ID", "remark": "", "ifSearch": 0 }, { "columnName": "Flast_Editor_Name", "remark": "", "ifSearch": 0 }, { "columnName": "Flast_Edit_Time", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_tall", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_finish", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_Active", "remark": "", "ifSearch": 0 }, { "columnName": "Fhomefire_UUID", "remark": "", "ifSearch": 0 }, { "columnName": "Fhomefire_name", "remark": "", "ifSearch": 0 }, { "columnName": "Faudit_status", "remark": "", "ifSearch": 0 }, { "columnName": "Faudit_name", "remark": "", "ifSearch": 0 }, { "columnName": "Faudit_time", "remark": "", "ifSearch": 0 }, { "columnName": "Faudit_desc", "remark": "", "ifSearch": 0 }, { "columnName": "Faudit_uuid", "remark": "", "ifSearch": 0 }, { "columnName": "Finput_type", "remark": "", "ifSearch": 0 }, { "columnName": "Fis_secmanager", "remark": "", "ifSearch": 0 }, { "columnName": "Fsecmanager", "remark": "", "ifSearch": 0 }, { "columnName": "Fsecmanager_tel", "remark": "", "ifSearch": 0 }, { "columnName": "err_flag", "remark": "错误标志(0无错误 1有错误)", "ifSearch": 0 } ] } ```