订单- ER

1 : 1

distribution_oms_order_pay_detail订单支付详情

1:1

order_item

idorder_iditem_iditem_typeitem_nametotal_quantityrefund_quantityexchange_quantityorigin_amountactual_amounttotal_amountextrais_validcreate_timeupdate_time

order_refund(退款订单)

iduser_idorder_snsourcepay_amountuser_nameuser_phonerefund_amountrefund_timerefund_statuscreate_timecreate_byupdate_timeupdate_by

tickout_delivery_order（外卖配送订单表）

+ operation1(params):returnType- operation2(params)- operation3()

1:n

shipping_order(发货信息表)

idorder_id 订单IDuser_id 用户IDmerchant_id 商户IDorder_sn 订单号source 来源shipping_sn 发货单号shipping_status 发货状态shipping_time 发货时间pay_time 支付时间receive_name 收件人receive_phone 联系方式receive_address 收货地址receive_countext 收货备注express_no 快递单号express_company 快递公司express_price 快递费is_validcreate_timeupdate_time

order(订单表)

idorder_sn 订单号user_idmerchant_iduser_nameuser_phoneorigin_amount 原价 actual_amount 实际金额refund_amount 退款金额order_brokerage 佣金order_typeorder_statuspay_statuspay_timeinvoice_status 开票状态evaluation_status 评价状态expect_timecity_codeis_validcreate_timeupdate_time

order_refund_item(退款订单详情)

idorder_refund_idproduct_namesku_nameorigin_amount 原价sale_amount 售卖价purchase_amount 拿货金额quantity 数量create_timeupdate_time

verify_order_itme(核验订单详情表)

idorder_item_id 订单详情IDverify_order_id 发货信息IDspu_name 商品名称sku_name 规格名称origin_amount 原价sale_amount 售卖价purchase_amount 拿货金额total_quantity 数量is_validcreate_timeupdate_time

shipping_order_item（发货信息详情表）

idorder_item_id 订单详情IDshipping_order_id 发货信息IDspu_name 商品名称sku_name 规格名称origin_amount 原价sale_amount 售卖价purchase_price 拿货价total_quantity 数量is_validcreate_timeupdate_time

distribution_oms_order_detail订单详情

idorder_iduser_ipsharer_user_iduser_group_idagent_user_idagent_group_idagent_head_user_idsupply_feeplatform_feeagent_feeagent_head_feeuser_latuser_lnguser_groupuser_agentuser_invitersharer_user_nick_nameagent_user_nick_nameagent_head_user_nick_namevalidcreate_timeupdate_time

tickout_delivery_order_item（外卖配送订单详情表）

verify_order（核验订单表）

idorder_iduser_idmerchant_id 商户IDsku_id 商品IDverify_code 核验码short_code 短码verify_merchant 核验商户verify_store 核验门店verify_user 核验用户verify_status 核验状态verify_time 核验时间is_validcreate_timeupdate_time来源

distribution_oms_order_coupon订单优惠详情