_bak_clean_20261108_service_verification 字段统计服务核销单(预售/预约预付款与服务费)
精确行数与字段画像 · 估算行数 3 · 主键 id
类型分布
字段可空与键位
| 字段 | 类型 | 键 | 可空 | 注释 |
| 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 | |
相关
返回全景目录