| 字段 | 類型 | 默認值 | 注釋 |
|---|---|---|---|
| group_order_id | int(10) unsigned | ||
| *group_order_sn | varchar(32) | 訂單號 | |
| *uid | int(10) unsigned | 用戶 ID | |
| *total_postage | decimal(8,2) unsigned | 0.00 | 郵費 |
| *total_price | decimal(8,2) unsigned | 0.00 | 訂單總額 |
| *total_num | int(10) unsigned | 0 | 商品數 |
| integral | int(8) unsigned | 0 | 使用積分數量 |
| integral_price | decimal(10,2) unsigned | 0.00 | 積分抵扣金額 |
| give_integral | int(8) unsigned | 0 | 贈送積分 |
| *coupon_price | decimal(8,2) unsigned | 0.00 | 優惠金額 |
| *real_name | varchar(32) | 聯系人 | |
| *user_phone | varchar(18) | 聯系電話 | |
| *user_address | varchar(128) | 收貨地址 | |
| *pay_price | decimal(8,2) unsigned | 支付金額 | |
| *pay_postage | decimal(8,2) unsigned | 0.00 | 支付郵費 |
| *cost | decimal(8,2) unsigned | 成本價 | |
| give_coupon_ids | varchar(500) | 贈送優惠券 | |
| *paid | tinyint(3) unsigned | 0 | 是否支付 |
| pay_time | timestamp | NULL | 支付時間 |
| *pay_type | tinyint(1) | 支付方式 0=余額 1=微信 2=小程序 3=h5 | |
| *create_time | timestamp | CURRENT_TIMESTAMP | 創建時間 |
| *is_remind | tinyint(1) unsigned | 0 | 是否提醒 |
| *is_del | tinyint(3) unsigned | 0 | |
| is_combine | tinyint(1) unsigned | 0 | 是否為合并支付 |
| paid) | USING BTREE |
打賞
已打賞￥{{reward_price}}
2242
{{like_count}}
{{collect_count}}
