表名查字段

GET/api/gen/dbColumn

请求参数

Query 参数

tableName

string

表名称

可选

示例值:

la_article_category

示例代码

返回响应

成功(200)

HTTP 状态码: 200

内容格式: JSONapplication/json

code

integer

必需

msg

string

必需

data

array [object {3}]

必需

columnName

string

必需

columnComment

string

必需

columnType

string

必需

{
  "code": 200,
  "msg": "成功",
  "data": [
    {
      "columnName": "id",
      "columnComment": "主键",
      "columnType": "int(10) unsigned"
    },
    {
      "columnName": "name",
      "columnComment": "名称",
      "columnType": "varchar(60)"
    },
    {
      "columnName": "sort",
      "columnComment": "排序",
      "columnType": "smallint(5) unsigned"
    },
    {
      "columnName": "is_show",
      "columnComment": "是否显示: 0=否, 1=是",
      "columnType": "tinyint(1) unsigned"
    },
    {
      "columnName": "is_delete",
      "columnComment": "是否删除: 0=否, 1=是",
      "columnType": "tinyint(1) unsigned"
    },
    {
      "columnName": "create_time",
      "columnComment": "创建时间",
      "columnType": "int(10) unsigned"
    },
    {
      "columnName": "update_time",
      "columnComment": "更新时间",
      "columnType": "int(10) unsigned"
    },
    {
      "columnName": "delete_time",
      "columnComment": "删除时间",
      "columnType": "int(10) unsigned"
    }
  ]
}

最后修改时间： 2 年前