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