| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| community_org_id | bigint | MUL | YES | 发起社区 |
| title | varchar | — | NO | 需求标题,如“小区团新鲜土鸡蛋” |
| category_id | bigint | — | YES | |
| spec | varchar | — | YES | 规格 |
| target_qty | int | — | YES | 成团数量 |
| joined_qty | int | — | YES | 已参与数量 |
| expect_price | decimal | — | YES | 期望单价 |
| deadline | datetime | — | YES | 截止时间 |
| status | varchar | MUL | YES | OPEN 招募中 / MATCHED 已匹配商家 / CLOSED 已成团 / CANCEL 流单 |
| merchant_id | bigint | — | YES | 接单商户 |
| order_id | bigint | — | YES | 成团后生成订单 |
| creator_id | bigint | — | YES | 发起人 |
| remark | varchar | — | YES | |
| created_at | datetime | — | YES |