文档
测试

根据表名查询字段和注释信息

GET
http://192.168.3.96:8111/dataSearch/getColumnAndDescription?tableCode=g_bd_tallbuildinfo

接口描述

/dataSearch/getColumnAndDescription

请求参数

参数名
类型
描述
必填
tableCode
str
表名 例:g_bd_tallbuildinfo
必填

响应参数

参数名
类型
描述
必填
status
int
示例:200
必填
data
array
数据列表
必填
name
string
示例:Ftallbuild_UUID
必填
title
string
示例:Ftallbuild_UUID
必填

说明 / 示例

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