| order_id |
int(11) |
NO |
NULL |
订单索引id |
| order_sn |
varchar(50) |
NO |
NULL |
订单编号 |
| pay_sn |
bigint(20) unsigned |
NO |
NULL |
支付单号 |
| store_id |
int(11) unsigned |
NO |
NULL |
卖家店铺id |
| store_name |
varchar(50) |
NO |
NULL |
卖家店铺名称 |
| buyer_id |
int(11) unsigned |
NO |
NULL |
买家id |
| buyer_name |
varchar(50) |
NO |
NULL |
买家姓名 |
| buyer_email |
varchar(80) |
YES |
NULL |
买家电子邮箱 |
| add_time |
int(10) unsigned |
NO |
0 |
订单生成时间 |
| payment_code |
char(10) |
NO |
|
支付方式名称代码 |
| payment_time |
int(10) unsigned |
YES |
0 |
支付(付款)时间 |
| finnshed_time |
int(10) unsigned |
NO |
0 |
订单完成时间 |
| goods_amount |
decimal(10,2) unsigned |
NO |
0.00 |
商品总价格 |
| order_amount |
decimal(10,2) unsigned |
NO |
0.00 |
订单总价格 |
| rcb_amount |
decimal(10,2) unsigned |
NO |
0.00 |
充值卡支付金额 |
| pd_amount |
decimal(10,2) unsigned |
NO |
0.00 |
预存款支付金额 |
| shipping_fee |
decimal(10,2) unsigned |
YES |
0.00 |
运费 |
| evaluation_state |
tinyint(4) |
YES |
0 |
评价状态 0未评价，1已评价，2已过期未评价 |
| order_state |
tinyint(4) |
NO |
10 |
订单状态：0(已取消)10(默认):未付款;20:已付款;30:已发货;40:已收货; |
| refund_state |
tinyint(4) unsigned |
YES |
0 |
退款状态:0是无退款,1是部分退款,2是全部退款 |
| lock_state |
tinyint(4) unsigned |
YES |
0 |
锁定状态:0是正常,大于0是锁定,默认是0 |
| delete_state |
tinyint(4) |
NO |
0 |
删除状态0未删除1放入回收站2彻底删除 |
| refund_amount |
decimal(10,2) |
YES |
0.00 |
退款金额 |
| delay_time |
int(10) unsigned |
YES |
0 |
延迟时间,默认为0 |
| order_from |
tinyint(4) |
NO |
1 |
订单来源1：WEB,2：android、3：iOS、4:h5 5:小程序 6:幼教小程序 7:幼教android 8:幼教IOS |
| shipping_code |
varchar(50) |
YES |
|
物流单号 |
| order_type |
tinyint(4) |
YES |
1 |
订单类型1普通订单(默认),2预定订单,3门店自提订单 |
| trade_no |
varchar(50) |
YES |
NULL |
外部交易订单号 |
| pay_sn1 |
bigint(20) unsigned |
YES |
NULL |
预定订单支付订金时的支付单号 |
| buyer_phone |
bigint(20) unsigned |
NO |
0 |
买家手机 |
| evaluation_again_state |
tinyint(3) unsigned |
NO |
0 |
追加评价状态 0未评价 |
| api_pay_time |
int(10) unsigned |
YES |
0 |
在线支付动作时间,只要向第三方支付平台提交就会更新 |
| chain_id |
int(10) unsigned |
NO |
0 |
自提门店ID |
| chain_code |
mediumint(6) unsigned |
NO |
0 |
门店提货码 |
| rpt_amount |
decimal(10,2) unsigned |
YES |
0.00 |
红包值 |
| stamp |
tinyint(4) |
NO |
1 |
打印状态--1：未打印--2：已打印 |
| seller_message |
varchar(255) |
NO |
|
订单备注 |
| is_pick |
tinyint(1) |
YES |
0 |
是否拣货1是2否 |
| pick_time |
int(11) |
YES |
0 |
拣货时间 |
| ship_fee |
varchar(50) |
YES |
|
运费成本 |
| pick_stamp |
tinyint(2) |
YES |
2 |
拣货打印状态 1是2否 |
| order_finish_time |
int(11) |
YES |
0 |
订单完成时间 |