微擎以及微擎模块常用数据库字典
ims_core_paylog支付记录表
plid type 支付类型 wechat 微信支付， delivery 货到付款 cash 现金支付 uniacid openid 有些模块是 openid 有些模块是 uid tid 收银台中显示的订单号，订单号是以SH20181114102928682293开头 fee 收银台中显示需要支付的金额,只能大于 0 status 状态 0 不成功 1 成功 module 调用模块，如ewei_shopv2 tag 支付流水号等信息 acid is_usecard 是否储值卡 card_type 卡类型 card_id 卡编码 card_fee 卡金额 encrypt_code uniontid
ims_mc_mapping_fans 粉丝关系映射表
fanid 粉丝id 主键 acid uniacid 关联的公众号 uid 用户id对应ims_mc_members fakeid fakeidtimes storeid 店铺ID firststoreid 第一店铺ID openid 公众号中对用户的唯一识别标识 nickname 昵称 groupid salt hidefakeid hideopenid follow firstfollowtime followtime unfollowtime tag 标签 updatetime 下载时间 unionid
人人商城
ims_ewei_shop_order订单表
id uniacid openid agentid 代理ID ordersn 订单号 SH 正常订单 RC 充值订单 DH 兑换订单 ordersn2 改价次数 限制99以内，支付订单号时会增加 GJ + 此号 price 应收款 订单金额(含运费) oldprice 原订单金额（含运费） changeprice 订单改价金额 goodsprice 商品金额 discountprice 会员折扣 status 状态 -1取消状态（交易关闭），0普通状态（没付款: 待付款 ; 付了款: 待发货），1 买家已付款（待发货），2 卖家已发货（待收货），3 成功（可评价: 等待评价 ; 不可评价 : 交易完成）4 退款申请 paytype 支付类型 1为余额支付 2在线支付 3 货到付款 11 后台付款 21 微信支付 22 支付宝支付 23 银联支付 transid 微信支付单号 remark 买家备注 addressid 地址ID dispatchprice 运费 olddispatchprice 原运费 changedispatchprice 运费改价 dispatchid 配送方式ID createtime 建立时间 dispatchtype 0 商家配送 1 自提 carrier 自提联系人信息 refundstate 退款状态 0 没有退款 1 退款 2 换货 refundid 退款申请ID 退款申请处理后清0 refundtime 退款时间退款申请后 >0 即为已退款订单 iscomment 评价状态 status 3,4 后允许评价 0 可评价 1 可追加评价 2 已评价 creditadd 积分赠送 deleted 删除 userdeleted 用户删除 finishtime 交易完成时间 paytime 支付时间 expresscom 快递公司 expresssn 快递单号 express 快递 sendtime 发送时间 fetchtime 打包时间？ cash 现付 货到付款？ canceltime 取消时间 cancelpaytime 取消支付时间 isverify 核销 verified 确认使用核销 verifyopenid 核销人 verifycode 核销码 verifytime 核销时间 verifystoreid 核销门店 deductcredit2 余额抵扣 deductenough 满额优惠 deductprice 积分抵扣 isvirtual 是虚拟物品 virtual 虚拟物品id virtual_info 虚拟物品信息 virtual_str 虚拟物品字串 address 地址 sysdeleted 系统删除 couponid 优惠券ID couponprice 优惠券价格 diyformdata 自定义表单数据 diyformfields 自定义表单字段 diyformid 自定义表单ID storeid 自提门店ID printstate 快递单打印状态 0 未 >0 多次 printstate2 发货单打印状态 0 未 >0 多次 address_send 发货人地址信息 refundstate v2 退款状态 closereason v2 订单取消原因 remarksaler v2 卖家备注 remarkclose v2 订单关闭备注 remarksend v2 取消发货备注 ismr v2 是否流量充值 isdiscountprice v2 折扣价 isvirtualsend v2 自动发货 virtualsend_info v2 自动发货信息 verifytype v2 线下核销类型 0 按订单核销 1 按次核销 2 按消费码核销 verifyinfo v2 线下核销信息 如核销时间，核销人等 verifycodes v2 消费码集合 invoicename v2 发货单名字 ismerch v2 是否商户 merchid v2 商户ID parentid v2 父订单ID isparent v2 是父订单 merchshow v2 商户显示 isabonus v2 参与分红 merchdeductenough v2 商户满减 couponmerchid v2 商户优惠券 merchapply v2 商户申请 isborrow v2 借用支付 borrowopenid v2 借用支付openid merchisdiscountprice v2 商户折扣价格 coupongoodprice v2 优惠商品价格 buyagainprice v2 复购价格 ispackage v2 是否套餐 packageid v2 套餐ID taskdiscountprice v2 任务折扣价 seckilldiscountprice v2 秒杀折扣价 verifyendtime v2 验证时间 willcancelmessage v2 取消订单信息 sendtype v2 发货类型 0 按订单发货 1< 分包发货 （多个快递单号） istrade v2 0 普通 1 门店预约订单 *erp_ordernumber ERP里的订单号 *erp_status ERP处理状态，0 未处理 1 已录入ERP 2 已结算 *staffid 员工ID *costprice 成本价 *otherprice 其他成本 如快递费，退换货费 *refundprice 退款金额 *isexporttaskid 导出任务id *county 县域信息 *countysn 县域订单编号 *ispartrefund 是否部分退货
ims_ewei_shop_sysset人人商城的设置表
id 顺序ID unicaid 唯一公号ID sets 设置 plugin 插件名 sec 证书入库
ims_super_pay_order 超级会员卡支付订单表
openid 创建者openid money 金额 status 0未支付 1已支付 staff_id 收款人 ordersn 订单编号 cardmoney paymoney discountmoney 优惠金额 paystatus 支付方式1会员卡2微信3微信+会员卡 paysn 支付订单返回的编号 ps 下单备注 coupon_id 优惠券id coupon_money 优惠券金额
ims_mc_credits_record 积分日志表
id uid uniacid credittype 积分类型 credit1积分 credit2余额 num 变化值 小数点后两位 operator 操作员 0 系统 createtime 建立时间 remark 备注信息 module 模块 clerk_id 店员ID store_id 消费门店ID ims_super_card_config 超级会员卡配置表
ims_ewei_shop_sysset中中sets字段关于分销的设置become成为分销商的条件 1申请 2按消费次数 3消费金额 4购买商品
become_order 0为付款后 1为完成后
a:4:{s:10:"commission";a:57:{s:5:"level";s:1:"3";s:7:"selfbuy";s:1:"1";s:6:"cansee";s:1:"0";s:8:"seetitle";s:0:"";s:12:"become_child";s:1:"0";s:9:"hideicode";s:1:"0";s:6:"become";s:1:"0";s:17:"become_ordercount";s:0:"";s:17:"become_moneycount";s:0:"";s:12:"become_check";s:1:"0";s:12:"become_order";s:1:"0";s:13:"open_protocol";s:1:"0";s:10:"become_reg";s:1:"0";s:17:"no_commission_url";s:0:"";s:8:"withdraw";s:1:"1";s:14:"commissiontype";s:1:"0";s:14:"withdrawcharge";s:0:"";s:13:"withdrawbegin";d:0;s:11:"withdrawend";d:0;s:10:"settledays";s:0:"";s:8:"levelurl";s:0:"";s:9:"leveltype";s:1:"0";s:11:"qrcodeshare";s:1:"0";s:9:"codeShare";s:1:"1";s:15:"openorderdetail";s:1:"0";s:14:"openorderbuyer";s:1:"0";s:13:"closed_qrcode";s:1:"0";s:6:"qrcode";s:1:"0";s:12:"qrcode_title";s:0:"";s:14:"qrcode_content";s:0:"";s:13:"qrcode_remark";s:0:"";s:15:"register_bottom";s:1:"0";s:22:"register_bottom_title1";s:0:"";s:24:"register_bottom_content1";s:0:"";s:22:"register_bottom_title2";s:0:"";s:24:"register_bottom_content2";s:0:"";s:22:"register_bottom_title3";s:0:"";s:24:"register_bottom_content3";s:0:"";s:22:"register_bottom_remark";s:0:"";s:23:"register_bottom_content";s:0:"";s:11:"closemyshop";s:1:"0";s:12:"select_goods";s:1:"0";s:5:"style";s:7:"default";s:5:"regbg";s:0:"";s:10:"applytitle";s:0:"";s:12:"applycontent";s:0:"";s:10:"cashcredit";i:0;s:10:"cashweixin";i:0;s:9:"cashother";i:0;s:10:"cashalipay";i:0;s:8:"cashcard";i:0;s:14:"become_goodsid";i:0;s:5:"texts";a:26:{s:5:"agent";s:9:"分销商";s:4:"shop";s:6:"小店";s:6:"myshop";s:12:"我的小店";s:6:"center";s:12:"分销中心";s:6:"become";s:15:"成为分销商";s:8:"withdraw";s:6:"提现";s:10:"commission";s:6:"佣金";s:11:"commission1";s:12:"分销佣金";s:16:"commission_total";s:12:"累计佣金";s:13:"commission_ok";s:15:"可提现佣金";s:16:"commission_apply";s:15:"已申请佣金";s:16:"commission_check";s:15:"待打款佣金";s:15:"commission_lock";s:15:"未结算佣金";s:15:"commission_wait";s:15:"待收货佣金";s:15:"commission_fail";s:12:"无效佣金";s:14:"commission_pay";s:18:"成功提现佣金";s:17:"commission_charge";s:21:"扣除提现手续费";s:17:"commission_detail";s:12:"佣金明细";s:5:"order";s:12:"分销订单";s:4:"down";s:6:"下线";s:6:"mydown";s:12:"我的下线";s:2:"c1";s:6:"一级";s:2:"c2";s:6:"二级";s:2:"c3";s:6:"三级";s:4:"yuan";s:3:"元";s:5:"icode";s:9:"邀请码";}s:9:"levelname";s:12:"默认等级";s:11:"commission1";s:2:"30";s:11:"commission2";s:2:"20";s:11:"commission3";s:2:"10";}s:8:"dividend";a:33:{s:4:"init";i:1;s:4:"open";i:1;s:5:"ratio";d:4;s:9:"condition";i:0;s:8:"downline";s:0:"";s:18:"commissiondownline";s:1:"5";s:16:"total_commission";s:0:"";s:15:"cash_commission";s:0:"";s:8:"withdraw";s:1:"1";s:14:"withdrawcharge";s:0:"";s:13:"withdrawbegin";d:0;s:11:"withdrawend";d:0;s:10:"settledays";s:0:"";s:10:"membershow";s:1:"1";s:14:"commissionshow";s:1:"0";s:15:"register_bottom";s:1:"0";s:22:"register_bottom_title1";s:0:"";s:24:"register_bottom_content1";s:0:"";s:22:"register_bottom_title2";s:0:"";s:24:"register_bottom_content2";s:0:"";s:23:"register_bottom_content";s:0:"";s:5:"regbg";s:0:"";s:10:"applytitle";s:0:"";s:12:"applycontent";s:0:"";s:10:"cashcredit";i:0;s:10:"cashweixin";i:0;s:9:"cashother";i:0;s:10:"cashalipay";i:0;s:8:"cashcard";i:0;s:5:"texts";a:18:{s:5:"agent";s:6:"队长";s:6:"center";s:12:"分红中心";s:6:"become";s:12:"成为队长";s:8:"withdraw";s:6:"提现";s:8:"dividend";s:6:"分红";s:9:"dividend1";s:12:"团队分红";s:14:"dividend_total";s:12:"累计分红";s:11:"dividend_ok";s:15:"可提现分红";s:14:"dividend_apply";s:15:"已申请分红";s:14:"dividend_check";s:15:"待打款分红";s:13:"dividend_lock";s:15:"未结算分红";s:13:"dividend_wait";s:15:"待收货分红";s:13:"dividend_fail";s:12:"无效分红";s:12:"dividend_pay";s:18:"成功提现分红";s:15:"dividend_charge";s:21:"扣除提现手续费";s:15:"dividend_detail";s:12:"分红明细";s:5:"order";s:12:"团队订单";s:4:"yuan";s:3:"元";}s:5:"check";i:0;s:13:"open_protocol";d:1;s:14:"open_protocols";s:1:"1";}s:6:"abonus";a:32:{s:4:"open";s:1:"1";s:7:"selfbuy";s:1:"0";s:6:"become";s:1:"1";s:13:"open_protocol";s:1:"1";s:9:"noregdesc";s:24:"复旦复华打工皇帝";s:9:"moneytype";s:1:"0";s:10:"settledays";s:0:"";s:9:"paycharge";s:0:"";s:8:"paybegin";s:0:"";s:6:"payend";s:0:"";s:8:"levelurl";s:0:"";s:9:"leveltype";s:1:"0";s:16:"openmembercenter";s:1:"0";s:21:"closecommissioncenter";s:1:"0";s:10:"centerdesc";s:0:"";s:15:"register_bottom";s:1:"0";s:22:"register_bottom_title1";s:0:"";s:24:"register_bottom_content1";s:0:"";s:22:"register_bottom_title2";s:0:"";s:24:"register_bottom_content2";s:0:"";s:22:"register_bottom_remark";s:0:"";s:23:"register_bottom_content";s:0:"";s:5:"style";s:7:"default";s:5:"regbg";s:0:"";s:10:"applytitle";s:0:"";s:12:"applycontent";s:0:"";s:13:"withdrawbegin";d:0;s:11:"withdrawend";d:0;s:14:"become_goodsid";i:0;s:5:"texts";a:10:{s:6:"aagent";s:12:"区域代理";s:6:"center";s:18:"区域代理中心";s:6:"become";s:18:"成为区域代理";s:5:"bonus";s:6:"分红";s:11:"bonus_total";s:12:"累计分红";s:10:"bonus_lock";s:15:"待结算分红";s:10:"bonus_wait";s:12:"预计分红";s:9:"bonus_pay";s:15:"已结算分红";s:12:"bonus_detail";s:12:"分红明细";s:12:"bonus_charge";s:21:"扣除提现手续费";}s:10:"agentcount";s:0:"";s:14:"withdrawcharge";d:0;}s:8:"globonus";a:38:{s:4:"open";s:1:"1";s:7:"selfbuy";s:1:"1";s:6:"become";s:1:"1";s:17:"become_ordercount";s:0:"";s:17:"become_moneycount";s:0:"";s:12:"become_check";s:1:"0";s:12:"become_order";s:1:"0";s:13:"open_protocol";s:1:"0";s:9:"noregdesc";s:0:"";s:9:"moneytype";s:1:"0";s:9:"bonusrate";s:0:"";s:10:"settledays";s:0:"";s:9:"paycharge";s:0:"";s:8:"paybegin";s:0:"";s:6:"payend";s:0:"";s:8:"levelurl";s:0:"";s:9:"leveltype";s:1:"0";s:16:"openmembercenter";s:1:"1";s:21:"closecommissioncenter";s:1:"0";s:10:"centerdesc";s:0:"";s:15:"register_bottom";s:1:"0";s:22:"register_bottom_title1";s:0:"";s:24:"register_bottom_content1";s:0:"";s:22:"register_bottom_title2";s:0:"";s:24:"register_bottom_content2";s:0:"";s:22:"register_bottom_remark";s:0:"";s:23:"register_bottom_content";s:0:"";s:5:"style";s:7:"default";s:5:"regbg";s:0:"";s:10:"applytitle";s:0:"";s:12:"applycontent";s:0:"";s:13:"withdrawbegin";d:0;s:11:"withdrawend";d:0;s:14:"become_goodsid";i:0;s:5:"texts";a:10:{s:7:"partner";s:6:"股东";s:6:"center";s:12:"股东中心";s:6:"become";s:12:"成为股东";s:5:"bonus";s:6:"分红";s:11:"bonus_total";s:12:"累计分红";s:10:"bonus_lock";s:15:"待结算分红";s:10:"bonus_wait";s:12:"预计分红";s:9:"bonus_pay";s:15:"已结算分红";s:12:"bonus_detail";s:12:"分红明细";s:12:"bonus_charge";s:21:"扣除提现手续费";}s:9:"levelname";s:12:"默认等级";s:5:"bonus";s:2:"10";s:7:"paytype";s:1:"1";}}