6. 数据库管理

获取数据库表列表

接口地址

api/database/showTables

请求方式

GET

请求参数

无

响应示例

{
    "code": 200,
    "message": "成功",
    "data": [
        {
            "Name": "department", // 数据库表名
            "Engine": "InnoDB",
            "Version": 10,
            "Row_format": "Compact",
            "Rows": 4, // 数量
            "Avg_row_length": 4096,
            "Data_length": 16384,
            "Max_data_length": 0,
            "Index_length": 0,
            "Data_free": 0,
            "Auto_increment": 5,
            "Create_time": "2020-06-05 00:40:09", // 创建时间
            "Update_time": null, // 更新时间
            "Check_time": null,
            "Collation": "utf8_general_ci",
            "Checksum": null,
            "Create_options": "",
            "Comment": "部门" // 表备注
        }
    ]
}

删除表

接口地址

api/database/deleteTable

请求方式

DELETE

请求参数

响应示例

{
    "code": 200,
    "message": "成功",
    "data": ""
}

获取表详情

接口地址

api/database/getTableDetail

请求方式

GET

请求参数

响应示例

{
    "code": 200,
    "message": "成功",
    "data": [
        {
            "TABLE_CATALOG": "def",
            "TABLE_SCHEMA": "tp5-admin",
            "TABLE_NAME": "user",
            "COLUMN_NAME": "id", // 字段名
            "ORDINAL_POSITION": 1,
            "COLUMN_DEFAULT": null,
            "IS_NULLABLE": "NO",
            "DATA_TYPE": "int",
            "CHARACTER_MAXIMUM_LENGTH": null,
            "CHARACTER_OCTET_LENGTH": null,
            "NUMERIC_PRECISION": 10,
            "NUMERIC_SCALE": 0,
            "DATETIME_PRECISION": null,
            "CHARACTER_SET_NAME": null,
            "COLLATION_NAME": null,
            "COLUMN_TYPE": "int(11) unsigned", // 字段类型
            "COLUMN_KEY": "PRI",
            "EXTRA": "auto_increment",
            "PRIVILEGES": "select,insert,update,references",
            "COLUMN_COMMENT": "" // 字段备注
        }
    ]
}