ome_orders
订单表,用于存储全渠道订单
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| order_id | 自增主键ID | int(10) unsigned | Y | Y | |
| order_bn | 订单号 | varchar(32) | Y | N | |
| platform_order_bn | 平台订单号 | varchar(32) | N | N | |
| archive | 归档状态,可选值:1(是),0(否) | tinyint(3) unsigned | Y | 0 | N |
| member_id | 会员ID,关联ome_members.member_id | int(10) unsigned | N | N | |
| confirm | 订单确认状态,可选值:Y(是),N(否) | enum('Y','N') | Y | N | N |
| process_status | 订单确认状态,可选值:unconfirmed(未确认),confirmed(已确认),splitting(部分拆分),splited(已拆分完),cancel(取消),remain_cancel(余单撤销),is_retrial(复审订单),is_declare(跨境申报订单) unconfirmed:未确认;confirmed:已确认;splitting:部分拆分;splited:已拆分完;cancel:取消;remain_cancel:余单撤销;is_retrial:复审订单;is_declare:跨境申报订单; | enum('unconfirmed','confirmed','splitting','splited','cancel','remain_cancel','is_retrial','is_declare') | Y | unconfirmed | N |
| splited_num | 拆单数 | mediumint(8) unsigned | N | N | |
| status | 订单状态,可选值:active(活动订单),dead(已作废),finish(已完成) active:活动订单;dead:已作废;finish:已完成; | enum('active','dead','finish') | Y | active | N |
| pay_status | 付款状态,可选值:0(未支付),1(已支付),2(处理中),3(部分付款),4(部分退款),5(全额退款),6(退款申请中),7(退款中),8(支付中) 0:未支付;1:已支付;2:处理中;3:部分付款;4:部分退款;5:全额退款;6:退款申请中;7:退款中;8:支付中; | enum('0','1','2','3','4','5','6','7','8') | Y | 0 | N |
| ship_status | 发货状态,可选值:0(未发货),1(已发货),2(部分发货),3(部分退货),4(已退货) 0:未发货;1:已发货;2:部分发货;3:部分退货;4:已退货; | enum('0','1','2','3','4') | Y | 0 | N |
| is_delivery | 订单是否可发货,可选值:Y(是),N(否) | enum('Y','N') | Y | Y | N |
| shipping | 配送方式 | varchar(100) | N | N | |
| pay_bn | 支付编号 | varchar(255) | N | N | |
| payment | 支付方式 | varchar(100) | N | N | |
| weight | 订单重量,单位:g | decimal(20,3) | N | N | |
| tostr | 订单明细简写,JSON格式保存 | longtext | N | N | |
| itemnum | 订单明细数量 | mediumint(8) unsigned | N | N | |
| createtime | 下单时间 | int(10) unsigned | N | N | |
| download_time | 订单下载时间 | int(10) unsigned | N | N | |
| up_time | 订单回传时间 | int(10) unsigned | N | N | |
| last_modified | 最后更新时间 | int(10) unsigned | N | N | |
| outer_lastmodify | 前端店铺最后更新时间 | int(10) unsigned | N | N | |
| shop_id | 来源店铺 | varchar(32) | N | N | |
| shop_type | 店铺类型 | varchar(50) | N | N | |
| ship_name | 收货人 | varchar(255) | N | N | |
| ship_area | 收货地区 | varchar(255) | N | N | |
| ship_addr | 收货地址 | text | N | N | |
| ship_zip | 收货邮编 | varchar(20) | N | N | |
| ship_tel | 收货人电话 | varchar(200) | N | N | |
| ship_email | 收货人邮箱 | varchar(150) | N | N | |
| ship_time | 要求到货时间 | varchar(50) | N | N | |
| ship_mobile | 收货人手机 | varchar(200) | N | N | |
| consigner_name | 发货人 | varchar(50) | N | N | |
| consigner_area | 发货人地区 | varchar(255) | N | N | |
| consigner_addr | 发货人地址 | varchar(100) | N | N | |
| consigner_zip | 发货人邮编 | varchar(20) | N | N | |
| consigner_email | 发货人e-mail | varchar(150) | N | N | |
| consigner_mobile | 发货人手机 | varchar(50) | N | N | |
| consigner_tel | 发货人电话 | varchar(30) | N | N | |
| delivery_time | 发货时间 | int(10) unsigned | N | N | |
| cost_item | 商品金额 | decimal(20,3) | Y | 0 | N |
| is_tax | 是否开发票 | enum('true','false') | Y | false | N |
| cost_tax | 税金 | decimal(20,3) | Y | 0 | N |
| tax_company | 发票抬头 | varchar(255) | N | N | |
| cost_freight | 配送费用 | decimal(20,3) | Y | 0 | N |
| is_protect | 保价状态,可选值:true(是),false(否) | enum('true','false') | Y | false | N |
| cost_protect | 保价费用 | decimal(20,3) | Y | 0 | N |
| is_cod | 货到付款 | enum('true','false') | Y | false | N |
| refund_money | 价保费用 | decimal(20,3) | Y | 0 | N |
| is_fail | 失败订单 | enum('true','false') | Y | false | N |
| edit_status | 订单编辑状态,可选值:true(是),false(否) | enum('true','false') | Y | false | N |
| cost_payment | 订单支付手续费 | decimal(20,3) | N | N | |
| currency | 货币 | varchar(8) | N | N | |
| cur_rate | 货币汇率 | decimal(10,4) | N | 1.0000 | N |
| score_u | 用户使用积分 | decimal(20,3) | Y | 0 | N |
| score_g | 用户获得积分 | decimal(20,3) | Y | 0 | N |
| discount | 订单折扣 | decimal(20,3) | Y | 0 | N |
| pmt_goods | 订单商品优惠 | decimal(20,3) | Y | 0 | N |
| pmt_order | 订单整单优惠 | decimal(20,3) | Y | 0 | N |
| total_amount | 订单总额 | decimal(20,3) | N | 0 | N |
| final_amount | 订单换算汇率后总额 | decimal(20,3) | Y | 0 | N |
| payed | 订单已支付金额 | decimal(20,3) | N | 0 | N |
| api_version | 接口版本号 | varchar(10) | N | 1.0 | N |
| custom_mark | 客户备注 | longtext | N | N | |
| mark_text | 商家备注 | longtext | N | N | |
| disabled | 是否失效 | enum('true','false') | Y | false | N |
| mark_type | 订单备注图标 | varchar(3) | N | N | |
| tax_no | 发票号 | varchar(50) | N | N | |
| dt_begin | 分派开始时间 | int(10) unsigned | N | N | |
| group_id | 确认组 | mediumint(8) unsigned | N | N | |
| op_id | 确认人 | mediumint(8) unsigned | N | N | |
| dispatch_time | 分派时间 | int(10) unsigned | N | N | |
| order_limit_time | 订单失效时间 | int(10) unsigned | N | N | |
| abnormal | 异常处理状态,可选值:true(是),false(否) | enum('true','false') | N | false | N |
| print_finish | 订单打印完成状态,可选值:true(是),false(否) | enum('true','false') | Y | false | N |
| source | 订单来源,可选值:matrix(矩阵),local(本地),import(导入),after(售后) | varchar(50) | N | matrix | N |
| pause | 订单暂停,可选值:true(是),false(否) | enum('true','false') | N | false | N |
| is_modify | 订单是否修改过商品信息,可选值:true(是),false(否) | enum('true','false') | N | false | N |
| old_amount | 订单原金额 | decimal(20,3) | N | 0 | N |
| order_type | 订单类型,可选值: normal(订单), sale(销售单), presale(预售单), vopczc(_only_pcs), platform(平台发货), offline(线下订单), gift(礼品卡订单), integral(积分订单), exchange(换货单), brush(特殊订单), jitxsc(_only_pcs), zerobuy(0元购),jisuxianhuo(急速现货), pinpaizhifa(品牌直发) normal:订单;sale:销售单;presale:预售订单;vopczc:唯品会仓中仓订单;platform:平台发货;offline:线下订单;gift:礼品卡订单;integral:积分订单;exchange:换货订单;brush:特殊订单;jitxsc:唯品会省仓;zerobuy:0元购;bufa:补发订单;jisuxianhuo:急速现货;pinpaizhifa:品牌直发; | enum('normal','sale','presale','vopczc','platform','offline','gift','integral','exchange','brush','jitxsc','zerobuy','bufa','jisuxianhuo','pinpaizhifa') | N | normal | N |
| order_combine_idx | 合并索引号 | bigint(13) | N | N | |
| order_combine_hash | 合并识别号 | char(32) | N | N | |
| auto_status | 状态标识位 | bigint(20) | N | 0 | N |
| abnormal_status | 异常状态标识位 | bigint(20) | N | 0 | N |
| print_status | 打印状态 | tinyint(4) | Y | 0 | N |
| logi_id | 物流公司ID,关键ome_dly_corp.corp_id | mediumint(8) unsigned | N | N | |
| logi_no | 物流单号 | varchar(50) | N | N | |
| sync | 回写状态,可选值: none(未回写), run(运行中), fail(回写失败), succ(回写成功) none:未回写;run:运行中;fail:回写失败;succ:回写成功; | enum('none','run','fail','succ') | N | none | N |
| paytime | 付款时间 | int(10) unsigned | N | N | |
| modifytime | 最后修改时间 | int(10) unsigned | N | N | |
| is_auto | 是否自动处理,可选值:true(是),false(否) | enum('true','false') | Y | false | N |
| self_delivery | 是否自发货,可选值:true(是),false(否) | enum('true','false') | Y | true | N |
| order_source | 来源渠道 | varchar(50) | N | direct | N |
| relate_order_bn | 关联订单号 | varchar(32) | N | N | |
| createway | 订单生成类型,可选值:matrix(平台获取),local(手工新建),import(批量导入),after(售后自建),yjdf(云交易售后自建) matrix:平台获取;local:手工新建;import:批量导入;after:售后自建;yjdf:云交易售后自建; | enum('matrix','local','import','after','yjdf') | Y | matrix | N |
| sync_fail_type | 回写失败类型,可选值:none(未知错误),shipped(前端已发货),unbind(店铺未绑定),params(参数错误),logistics(物流错误) none:未知错误;shipped:前端已发货;unbind:店铺未绑定;params:参数错误;logistics:物流错误; | enum('none','shipped','unbind','params','logistics') | N | none | N |
| omnichannel | 全渠道订单,可选值:1(是),2(否) | tinyint(1) | N | 2 | N |
| is_service_order | 是否服务订单,可选值:true(是),false(否) | enum('true','false') | N | false | N |
| service_price | 服务费用 | decimal(20,3) | N | 0 | N |
| platform_service_fee | 平台服务费用 | decimal(20,3) | N | 0 | N |
| order_bool_type | 订单种类 | bigint(20) | N | 0 | N |
| end_time | 买家确认收货时间 | int(10) unsigned | N | N | |
| org_id | 运营组织 | mediumint(8) unsigned | N | N | |
| source_status | 平台状态 | varchar(64) | N | N | |
| timing_confirm | 定时审单 | int(10) unsigned | N | 0 | N |
| presale_status | 预售状态,可选值:0(非预售),1(全部预售),2(部分预售) 0:非预售;1:全部预售;2:部分预售; | enum('0','1','2') | N | 0 | N |
| is_assign_store | 是否指定仓发货 | enum('true','false') | N | false | N |
| step_trade_status | 分阶段付款的订单状态 | varchar(90) | N | N | |
| bufa_reason | 补发原因 | varchar(255) | N | N | |
| coupons_name | coupons_name | varchar(255) | N | N | |
| refund_status | 退款状态 | int(11) | N | 0 | N |
| betc_id | 贸易公司ID | int(10) unsigned | N | 0 | N |
| cos_id | 组织架构ID | int(10) unsigned | N | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | order_id | Y | |
| ind_order_bn_shop | order_bn, shop_id | Y | |
| ind_archive | archive | N | |
| ind_pay_status | pay_status, paytime | N | |
| ind_status | status | N | |
| ind_shop_type | shop_type | N | |
| ind_is_cod | is_cod | N | |
| ind_createtime | createtime | N | |
| ind_pay_bn | pay_bn | N | |
| ind_is_auto | is_auto | N | |
| ind_is_tax | is_tax | N | |
| ind_outer_lastmodify | outer_lastmodify | N | |
| ind_pause | pause | N | |
| ind_abnormal | abnormal | N | |
| ind_ship_mobile | ship_mobile | N | |
| ind_ship_tel | ship_tel | N | |
| ind_ship_name | ship_name | N | |
| ind_ship_addr | ship_addr(255) | N | |
| ind_logi_no | logi_no | N | |
| ind_splited_num | splited_num | N | |
| ind_end_time | end_time | N | |
| ind_delivery_time | delivery_time | N | |
| ind_sync | sync | N | |
| ind_order_source | order_source | N | |
| ind_relate_order_bn | relate_order_bn | N | |
| ind_platform_order_bn | platform_order_bn | N | |
| ind_last_modified | last_modified | N | |
| ind_order_type | order_type | N | |
| ind_orgid_shipstatus_isfail_ordertype_status | org_id, ship_status, is_fail, order_type, status | N | |
| idx_ship_isfail_ordertype_status | ship_status, is_fail, order_type, status | N | |
| ind_org_status_isfail_edit_archive | org_id, status, is_fail, edit_status, archive | N | |
| idx_isfail_ordertype_paytime | is_fail, order_type, paytime | N | |
| idx_shopid_isfail_ordertype | shop_id, is_fail, order_type | N | |
| idx_shipstatus_status_logino | ship_status, status, logi_no | N | |
| idx_shipstatus_createway_logino_status | ship_status, createway, logi_no, status | N | |
| idx_shipstatus_status_createway_sync_logino | ship_status, status, createway, sync, logi_no | N | |
| idx_processstatus_status_createtime | process_status, status, createtime | N | |
| idx_total_payed_process_pay_ship_isfail_org | org_id, process_status, total_amount, payed, pay_status, ship_status, is_fail, last_modified | N | |
| idx_disabled_isfail_shipstatus | disabled, is_fail, ship_status | N | |
| idx_orgid_ordertype_isfail_archive_disabled_processstatus | org_id, order_type, is_fail, archive, disabled, process_status | N | |
| ind_betc_id | betc_id | N | |
| ind_cos_id | cos_id | N | |
| idx_c_member_id | member_id | N | |
| idx_c_group_id | group_id | N | |
| idx_c_op_id | op_id | N | |
| idx_c_logi_id | logi_id | N |