| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| verify_no | varchar | UNI | NO | 核销码 |
| order_no | varchar | YES | ||
| user_id | bigint | MUL | NO | |
| service_id | bigint | YES | ||
| store_id | bigint | YES | ||
| prepay_amount | decimal | YES | 预付款 | |
| service_fee | decimal | YES | 服务费 | |
| total_amount | decimal | YES | ||
| biz_type | varchar | YES | PRESALE 预售 / BOOKING 预约 | |
| status | varchar | MUL | YES | PENDING 待核销 / VERIFIED 已核销 / REFUNDED 已退款 |
| verified_at | datetime | YES | ||
| verifier_id | bigint | YES | ||
| remark | varchar | YES | ||
| created_at | datetime | YES |