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