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