zqm_sgroup_stat_tol
- 统计概览总表
| 字段 | 类型 | 允许空 | 默认 | 注释 |
|---|---|---|---|---|
| tol_id | int(11) unsigned | NO | NULL | 无 |
| member_total | varchar(20) | YES | 0 | 会员总数 |
| member_extend_total | varchar(20) | YES | 0 | 学籍总数 |
| order_totals | varchar(20) | YES | 0 | 有效订单数 |
| goods_amount | varchar(20) | YES | 0 | 总交易金额码洋 |
| discount_amount | varchar(20) | YES | 0 | 总金额 |
| account_amount | varchar(20) | YES | 0 | 线上总金额 |
| online_order_num | varchar(20) | YES | 0 | 线下总金额 |
| online_goods_amount | varchar(20) | YES | 0 | 免费金额 |
| online_discount_amount | int(10) | YES | 0 | 店铺id |
| offline_order_num | int(11) | YES | 0 | 更新时间 |
| offline_goods_amount | tinyint(1) | YES | 0 | 无 |
| offline_discount_amount | varchar(255) | YES | 0 | 无 |
| free_order_num | int(11) | YES | 0 | 无 |
| free_goods_amount | varchar(255) | YES | 0 | 无 |
| free_goods_num | int(11) | YES | 0 | 无 |
| refund_num | int(11) | YES | 0 | 无 |
| error_refund_num | int(11) | YES | 0 | 无 |
| tatol_market_amount | varchar(255) | YES | 0 | 无 |
| error_refund_market | varchar(255) | YES | 0 | 无 |
| free_refund_market | varchar(255) | YES | 0 | 无 |
| refund_amount | varchar(255) | YES | 0 | 无 |
| error_refund_price | varchar(200) | YES | 0 | 无 |
| refund_goods_num | int(11) | YES | 0 | 无 |
| error_refund_goods_num | int(11) | YES | 0 | 无 |
| free_refund_goods_num | int(11) | YES | 0 | 无 |
| min_payment_time | int(11) | YES | 0 | 无 |
| max_time | int(11) | YES | 0 | 无 |
| update_time | int(11) | YES | 0 | 无 |
| store_id | int(11) | YES | 0 | 无 |
| order_class | tinyint(1) | YES | NULL | 无 |