| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| 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 |