| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| store_id | bigint | MUL | NO | |
| merchant_id | bigint | YES | ||
| user_id | bigint | MUL | NO | |
| org_id | bigint | MUL | YES | 归属社区 |
| source | varchar | YES | scan 扫码 / invite 邀请 / order 首单 / manual 手工 | |
| lock_flag | tinyint | YES | 1=该店为该用户归属门店,不可被其他门店抢 | |
| first_order_at | datetime | YES | ||
| last_order_at | datetime | YES | ||
| order_count | int | YES | ||
| total_amount | decimal | YES | ||
| status | tinyint | YES | ||
| created_at | datetime | YES |