| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| org_id | bigint | MUL | NO | |
| subject_type | varchar | MUL | NO | user 账号 / store 门店 / merchant 商户 / device 设备 |
| subject_id | bigint | — | NO | |
| role | varchar | — | YES | owner 发起人 / partner 联营 / member 成员 / consumer 顾客 |
| lock_flag | tinyint | — | YES | 1=锁定,不可自助更换社区 |
| push_scope | varchar | — | YES | 选品/联盟/同业/服务 推送范围 |
| ai_power | tinyint | — | YES | AI 赋能开关 |
| bind_at | datetime | — | YES | |
| status | tinyint | — | YES |