| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| code | varchar | UNI | NO | 权限码, 如 product:audit |
| name | varchar | — | NO | |
| type | varchar | — | YES | API/MENU/BUTTON |
| method | varchar | — | YES | GET/POST/PUT/DELETE, 空=任意 |
| api_path | varchar | — | NO | 接口路径(精确或前缀) |
| is_public | tinyint | — | YES | 1=公开无需登录 |
| sort | int | — | YES | |
| status | tinyint | — | YES |