| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| subject_type | varchar | MUL | NO | user/merchant/store/service_provider |
| subject_id | bigint | — | NO | |
| scope_type | varchar | MUL | NO | platform/community/merchant/store/self |
| scope_id | bigint | — | YES | scope 对应 ID,platform 为 0 |
| perms | varchar | — | YES | 逗号分隔的权限码,空=继承上级 |
| lock_flag | tinyint | — | YES | |
| status | tinyint | — | YES | |
| created_at | datetime | — | YES |