Appearance
菜单管理
| sys_menu | 菜单表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | |||
| menu_name | varchar(20) | utf8_general_ci | YES | (NULL) | 菜单名称 | |||
| menu_url | varchar(200) | utf8_general_ci | YES | (NULL) | 菜单url | |||
| parent_menu_id | bigint(20) | (NULL) | YES | 0 | 上级菜单id，一级菜单用0表示 | |||
| menu_icon | varchar(50) | utf8_general_ci | YES | (NULL) | 菜单图标 | |||
| is_hidden | tinyint(4) | (NULL) | YES | 2 | 是否隐藏 1是 2否 | |||
| sort | int(11) | (NULL) | YES | (NULL) | 排序 | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 |
| sys_role_menu | 角色菜单关联表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键id | ||
| merchant_no | varchar(20) | utf8_general_ci | YES | (NULL) | 商户号 | |||
| role_id | bigint(20) | (NULL) | YES | (NULL) | 角色id | |||
| menu_id | bigint(20) | (NULL) | YES | (NULL) | 菜单id | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 |
| sys_api | 菜单功能表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | 主键id | ||
| menu_id | bigint(20) | (NULL) | YES | (NULL) | 菜单表主键 | |||
| api_code | varchar(50) | utf8_general_ci | YES | (NULL) | 权限标识 | |||
| api_name | varchar(50) | utf8_general_ci | YES | (NULL) | 权限名称 | |||
| api_function | varchar(200) | utf8_general_ci | YES | (NULL) | 权限描述 | |||
| sort | int(6) | (NULL) | YES | (NULL) | 排序 | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 |
| sys_role_api | 角色功能关联表 |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
| id | bigint(20) | (NULL) | NO | PRI | (NULL) | |||
| merchant_no | varchar(20) | utf8_general_ci | YES | (NULL) | 商户号 | |||
| role_id | bigint(20) | (NULL) | YES | (NULL) | 角色id | |||
| api_id | bigint(20) | (NULL) | YES | (NULL) | 接口id | |||
| creator | bigint(20) | (NULL) | YES | (NULL) | 创建人 | |||
| create_time | datetime | (NULL) | YES | (NULL) | 创建时间 | |||
| updater | bigint(20) | (NULL) | YES | (NULL) | 更新人 | |||
| update_time | datetime | (NULL) | YES | (NULL) | 更新时间 | |||
| del_flag | tinyint(4) | (NULL) | YES | 1 | 删除标记 1未删除 2已删除 |