# codeGen **Repository Path**: duzhenwen/code-gen ## Basic Information - **Project Name**: codeGen - **Description**: swww - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 1 - **Forks**: 0 - **Created**: 2021-04-29 - **Last Updated**: 2021-07-16 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README ### 采用技术 基于java的模板引擎velocity【vəˈlɒsəti】 #### swagger页面访问地址 http://localhost:8098/swagger-ui.html ### 接口 http://localhost:8098/api/generate ### 参数 ``` { "DbName": "bookclud", "Ip": "localhost", "Password": "861153", "User": "root", "artifact": "demo", "group": "com.adu" } ``` ### 规则 1.类名首字母大写 2.将数据库表明中下划线_删除，原下划线后第一个字母大写，转换为驼峰格式 3.支持单表全表字段的增删改查 4.service层接口与实现类同在service目录下，实现类在service/impl目录下 ``` { "DbName": "bookclud", "Ip": "localhost", "Password": "861153", "User": "root", "artifact": "demo", "group": "com.adu", "tableRules":[ { "tableName": "sys_permission", "tableComment": "", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_permission", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "auto_increment", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "auto_increment", "table_NAME": "sys_permission", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_permission", "COLUMN_NAME": "name", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(255)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "权限名", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "权限名", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_permission", "column_NAME": "name", "data_TYPE": "varchar", "column_TYPE": "varchar(255)", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_permission", "COLUMN_NAME": "role_id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "角色id", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "角色id", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_permission", "column_NAME": "role_id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "sys_user_role", "tableComment": "", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user_role", "COLUMN_NAME": "create_time", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user_role", "column_NAME": "create_time", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user_role", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "auto_increment", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "auto_increment", "table_NAME": "sys_user_role", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user_role", "COLUMN_NAME": "role_id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "角色id", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "角色id", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user_role", "column_NAME": "role_id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user_role", "COLUMN_NAME": "update_time", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user_role", "column_NAME": "update_time", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user_role", "COLUMN_NAME": "user_id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "用户id", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "用户id", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user_role", "column_NAME": "user_id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "sys_user", "tableComment": "用户表", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "address", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(100)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "地址", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "地址", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "address", "data_TYPE": "varchar", "column_TYPE": "varchar(100)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "avatar", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(100)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "头像地址", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "头像地址", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "avatar", "data_TYPE": "varchar", "column_TYPE": "varchar(100)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "career", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(30)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "职业", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "职业", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "career", "data_TYPE": "varchar", "column_TYPE": "varchar(30)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "createTime", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(0)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "创建时间", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "创建时间", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "createTime", "data_TYPE": "varchar", "column_TYPE": "varchar(0)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "email", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(50)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "邮箱", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "邮箱", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "email", "data_TYPE": "varchar", "column_TYPE": "varchar(50)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "auto_increment", "COLUMN_COMMENT": "", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "auto_increment", "table_NAME": "sys_user", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "idCard", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "char", "COLUMN_TYPE": "char(18)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "身份证", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "身份证", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "idCard", "data_TYPE": "char", "column_TYPE": "char(18)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "nickname", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(255)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "昵称", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "昵称", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "nickname", "data_TYPE": "varchar", "column_TYPE": "varchar(255)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "phone", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "联系电话", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "联系电话", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "phone", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "reg_ip", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "注册ip", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "注册ip", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "reg_ip", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "sex", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "性别，0：女，1：男", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "性别，0：女，1：男", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "sex", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "status", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int(10) unsigned zerofill", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "状态，0：正常，1：删除", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "状态，0：正常，1：删除", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "status", "data_TYPE": "int", "column_TYPE": "int(10) unsigned zerofill", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "updateTime", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(0)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "更新时间", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "更新时间", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "updateTime", "data_TYPE": "varchar", "column_TYPE": "varchar(0)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_user", "COLUMN_NAME": "username", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(50)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "用户名", "TABLE_COMMENT": "用户表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "用户名", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_user", "column_NAME": "username", "data_TYPE": "varchar", "column_TYPE": "varchar(50)", "column_KEY": "", "table_COMMENT": "用户表", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "book_tag", "tableComment": "", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "book_tag", "COLUMN_NAME": "bookId", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "书本id", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "书本id", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book_tag", "column_NAME": "bookId", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book_tag", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "book_tag", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book_tag", "COLUMN_NAME": "tagId", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "标签id", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "标签id", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book_tag", "column_NAME": "tagId", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "book", "tableComment": "资源表", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "author", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(60)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "作者", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "作者", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "author", "data_TYPE": "varchar", "column_TYPE": "varchar(60)", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "coverPhoto", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(100)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "封面图片", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "封面图片", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "coverPhoto", "data_TYPE": "varchar", "column_TYPE": "varchar(100)", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "createTime", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "创建时间", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "创建时间", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "createTime", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "delete", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int(10) unsigned zerofill", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "是否删除，0：否，1：是", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "是否删除，0：否，1：是", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "delete", "data_TYPE": "int", "column_TYPE": "int(10) unsigned zerofill", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "hot", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int(10) unsigned zerofill", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "是否热点，0：否，1：是", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "是否热点，0：否，1：是", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "hot", "data_TYPE": "int", "column_TYPE": "int(10) unsigned zerofill", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "auto_increment", "COLUMN_COMMENT": "", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "auto_increment", "table_NAME": "book", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "name", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(100)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "name", "data_TYPE": "varchar", "column_TYPE": "varchar(100)", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "pageNum", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "页数", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "页数", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "pageNum", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "path", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(200)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "文件路径", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "文件路径", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "path", "data_TYPE": "varchar", "column_TYPE": "varchar(200)", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "remark", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(250)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "简介", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "简介", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "remark", "data_TYPE": "varchar", "column_TYPE": "varchar(250)", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "size", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "资源大小", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "资源大小", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "size", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "sort", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int(10) unsigned zerofill", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "排序", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "排序", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "sort", "data_TYPE": "int", "column_TYPE": "int(10) unsigned zerofill", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "updateTime", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "更新时间", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "更新时间", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "updateTime", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "book", "COLUMN_NAME": "visitNum", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int(10) unsigned zerofill", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "访问量", "TABLE_COMMENT": "资源表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "访问量", "is_NULLABLE": "YES", "extra": "", "table_NAME": "book", "column_NAME": "visitNum", "data_TYPE": "int", "column_TYPE": "int(10) unsigned zerofill", "column_KEY": "", "table_COMMENT": "资源表", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "tag", "tableComment": "标签信息表", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "tag", "COLUMN_NAME": "createTime", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "创建时间", "TABLE_COMMENT": "标签信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "创建时间", "is_NULLABLE": "YES", "extra": "", "table_NAME": "tag", "column_NAME": "createTime", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "标签信息表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "tag", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "标签信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "tag", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "标签信息表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "tag", "COLUMN_NAME": "name", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "标签名", "TABLE_COMMENT": "标签信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "标签名", "is_NULLABLE": "YES", "extra": "", "table_NAME": "tag", "column_NAME": "name", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "标签信息表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "tag", "COLUMN_NAME": "updateTime", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "更新时间", "TABLE_COMMENT": "标签信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "更新时间", "is_NULLABLE": "YES", "extra": "", "table_NAME": "tag", "column_NAME": "updateTime", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "标签信息表", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "dept", "tableComment": "", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "dept", "COLUMN_NAME": "code", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(255)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "YES", "extra": "", "table_NAME": "dept", "column_NAME": "code", "data_TYPE": "varchar", "column_TYPE": "varchar(255)", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "dept", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "auto_increment", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "auto_increment", "table_NAME": "dept", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "dept", "COLUMN_NAME": "name", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(255)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "dept", "column_NAME": "name", "data_TYPE": "varchar", "column_TYPE": "varchar(255)", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "undo_log", "tableComment": "", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "branch_id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "bigint", "COLUMN_TYPE": "bigint", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "undo_log", "column_NAME": "branch_id", "data_TYPE": "bigint", "column_TYPE": "bigint", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "context", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(255)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "YES", "extra": "", "table_NAME": "undo_log", "column_NAME": "context", "data_TYPE": "varchar", "column_TYPE": "varchar(255)", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "ext", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(100)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "YES", "extra": "", "table_NAME": "undo_log", "column_NAME": "ext", "data_TYPE": "varchar", "column_TYPE": "varchar(100)", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "bigint", "COLUMN_TYPE": "bigint", "COLUMN_KEY": "PRI", "EXTRA": "auto_increment", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "auto_increment", "table_NAME": "undo_log", "column_NAME": "id", "data_TYPE": "bigint", "column_TYPE": "bigint", "column_KEY": "PRI", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "log_created", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "datetime", "COLUMN_TYPE": "datetime", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "undo_log", "column_NAME": "log_created", "data_TYPE": "datetime", "column_TYPE": "datetime", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "log_modified", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "datetime", "COLUMN_TYPE": "datetime", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "undo_log", "column_NAME": "log_modified", "data_TYPE": "datetime", "column_TYPE": "datetime", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "log_status", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "undo_log", "column_NAME": "log_status", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "rollback_info", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "longblob", "COLUMN_TYPE": "longblob", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "undo_log", "column_NAME": "rollback_info", "data_TYPE": "longblob", "column_TYPE": "longblob", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "undo_log", "COLUMN_NAME": "xid", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(100)", "COLUMN_KEY": "MUL", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "", "table_NAME": "undo_log", "column_NAME": "xid", "data_TYPE": "varchar", "column_TYPE": "varchar(100)", "column_KEY": "MUL", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "good", "tableComment": "", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "good", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "auto_increment", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "auto_increment", "table_NAME": "good", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "good", "COLUMN_NAME": "name", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(255)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "YES", "extra": "", "table_NAME": "good", "column_NAME": "name", "data_TYPE": "varchar", "column_TYPE": "varchar(255)", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "good", "COLUMN_NAME": "num", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "", "TABLE_COMMENT": "", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "YES", "extra": "", "table_NAME": "good", "column_NAME": "num", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "", "table_COMMENT": "", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 }, { "tableName": "sys_role", "tableComment": "角色信息表", "dbinfo": [ { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_role", "COLUMN_NAME": "createTime", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "创建时间", "TABLE_COMMENT": "角色信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "创建时间", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_role", "column_NAME": "createTime", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "角色信息表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_role", "COLUMN_NAME": "delete", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "int", "COLUMN_TYPE": "int(10) unsigned zerofill", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "是否删除，0：否，1：是", "TABLE_COMMENT": "角色信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "是否删除，0：否，1：是", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_role", "column_NAME": "delete", "data_TYPE": "int", "column_TYPE": "int(10) unsigned zerofill", "column_KEY": "", "table_COMMENT": "角色信息表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_role", "COLUMN_NAME": "description", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(255)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "描述", "TABLE_COMMENT": "角色信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "描述", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_role", "column_NAME": "description", "data_TYPE": "varchar", "column_TYPE": "varchar(255)", "column_KEY": "", "table_COMMENT": "角色信息表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_role", "COLUMN_NAME": "id", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "NO", "DATA_TYPE": "int", "COLUMN_TYPE": "int", "COLUMN_KEY": "PRI", "EXTRA": "auto_increment", "COLUMN_COMMENT": "", "TABLE_COMMENT": "角色信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "", "is_NULLABLE": "NO", "extra": "auto_increment", "table_NAME": "sys_role", "column_NAME": "id", "data_TYPE": "int", "column_TYPE": "int", "column_KEY": "PRI", "table_COMMENT": "角色信息表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_role", "COLUMN_NAME": "name", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "角色名", "TABLE_COMMENT": "角色信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "角色名", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_role", "column_NAME": "name", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "角色信息表", "ordinal_POSITION": null, "table_SCHEMA": null }, { "TABLE_SCHEMA": null, "TABLE_NAME": "sys_role", "COLUMN_NAME": "updateTime", "ORDINAL_POSITION": null, "COLUMN_DEFAULT": null, "IS_NULLABLE": "YES", "DATA_TYPE": "varchar", "COLUMN_TYPE": "varchar(20)", "COLUMN_KEY": "", "EXTRA": "", "COLUMN_COMMENT": "更新时间", "TABLE_COMMENT": "角色信息表", "select": 0, "delete": 0, "update": 0, "insert": 0, "column_DEFAULT": null, "column_COMMENT": "更新时间", "is_NULLABLE": "YES", "extra": "", "table_NAME": "sys_role", "column_NAME": "updateTime", "data_TYPE": "varchar", "column_TYPE": "varchar(20)", "column_KEY": "", "table_COMMENT": "角色信息表", "ordinal_POSITION": null, "table_SCHEMA": null } ], "show": 0, "select": 0, "delete": 0, "update": 0, "insert": 0 } ] } ```