消费明细记录表
| 字段 | 类型 | 空 | 默认 | 注释 |
|---|---|---|---|---|
| id | int(10) unsigned | NO | ||
| uniacid | int(11) | NO | 0 | |
| uid | int(11) | NO | 0 | 会员ID |
| order_id | int(11) | NO | 0 | 订单ID |
| order_sn | varchar(60) | NO | 订单号 | |
| price | decimal(10,2) | NO | 0.00 | 实付金额 |
| old_consume_total | decimal(10,2) | NO | 0.00 | 消费记录总额 |
| rules | text | YES | 设置规则 | |
| created_at | int(11) | YES | ||
| updated_at | int(11) | YES | ||
| deleted_at | int(11) | YES | ||
| old_consume_surplus | decimal(10,2) | YES | 剩余消费记录总额 |