| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| session_no | varchar | UNI | NO | |
| device_id | bigint | MUL | NO | 设备 pos_device.id |
| store_id | bigint | MUL | NO | 门店 store.id |
| cashier_id | bigint | — | NO | 收银员 user.id |
| cashier_name | varchar | — | YES | |
| opening_cash | decimal | — | YES | 备用金 |
| closing_cash | decimal | — | YES | 结班实收 |
| sale_amount | decimal | — | YES | 本班销售额 |
| order_count | int | — | YES | 本班单数 |
| status | varchar | — | YES | OPEN/CLOSED |
| opened_at | datetime | — | YES | |
| closed_at | datetime | — | YES |