商城数据字典 v 1.0
  • 项目分享
  • 返回首页
目录
  • 系统管理
    • 商城设置
    • 消息模版相关数据字典
      • ims_yz_message_template 消息模版设置表
      • ims_yz_template_message 模版消息表(无用)
      • ims_yz_template_message_record 模版消息记录表(无用)
      • ims_yz_template_message_default 默认消息模版表
    • 操作员&角色管理
      • yz_role
      • yz_user_role
      • yz_permission
      • yz_operation_log
    • yz_setting(商城设置)
    • 财务数据字典
    • 消息通知
      • ims_yz_message_template
      • ims_yz_mini_app_template_message
      • ims_yz_template_message_default
  • 会员
    • yz_member_level(会员等级)
    • yz_member_group(会员分组)
    • yz_member_cart(会员购物车)
    • yz_member_history(会员足迹)
    • yz_member_favorite(会员收藏)
    • yz_member_address(收货地址【框架表】)
    • yz_member_unique(微信开放平台统一unionid表)
    • yz_member_app_wechat(微信app登录用户表)
    • yz_member_wechat(扫码登录用户表)
    • yz_member_mini_app(小程序用户表)
    • yz_member_qq(QQ登录用户表)
    • yz_member(会员子表)
    • yz_member_relatione(会员关系表)
    • yz_sms_send_limit(发送短信限制表)
    • yz_member_bank_card 银行卡信息
    • yz_member_children (会员下线表)
    • yz_member_coupon (会员优惠券)
    • yz_member_del_log (会员删除记录表)
    • yz_member_favorite(商品收藏表)
    • yz_member_group (会员所属组)
    • yz_member_history()
    • yz_member_income(收入)
    • yz_member_lower_count(会员下线人数统计)
    • yz_member_lower_order (会员下线订单统计)
    • yz_member_order_operation(会员订单操作)
    • yz_member_parent (会员上线表)
    • yz_member_record(会员记录表)
    • yz_member_relation (会员关系表)
    • yz_member_alipay (支付宝登录用户表)
    • mc_members(会员主表)
    • yz_wechat_qrcode_fans(PC端扫码登录用户表)
    • yz_member_certified(实名认证记录表)
  • 订单
    • yz_order_goods (订单商品表)
    • yz_order (订单表)
    • yz_order_address(订单收货地址表)
    • yz_order_pay(订单支付记录表)
    • yz_order_pay_order(订单与支付记录关联表)
    • yz_order_refund(订单退换货记录表)
    • yz_order_express(订单快递信息表)
    • yz_order_setting(订单设置表)
    • yz_order_status(订单状态表)
    • yz_order_remark(订单备注表)
    • yz_order_expediting_delivery
  • 商品
    • ims_yz_goods_spec_item(商品规格项表)
    • ims_yz_goods_spec(商品规格表)
    • ims_yz_goods_option(商品规格选项表)
    • ims_yz_goods_param(商品参数[属性]表)
    • ims_yz_goods_category(商品分类关联表)
    • ims_yz_goods(商品基本信息)
    • ims_yz_brand(商品品牌)
    • ims_yz_category(商品分类)
    • ims_yz_comment(评论)
    • ims_yz_goods_sale(商品营销)
    • ims_yz_goods_notices(商品消息通知关联表)
    • ims_yz_address(地址 省份、城市)
    • ims_yz_street(地址 街道)
    • ims_yz_goods_share(商品分享关注关联表)
    • ims_yz_goods_privilege(商品权限关联表)
    • ims_yz_goods_discount(商品折扣关联表)
    • ims_yz_goods_dispatch(商品配送运费关联表)
    • ims_yz_dispatch(商品配送模板)
    • ims_yz_goods_video(商品首页视频附表)
    • ims_yz_search_filtering(商品标签表)
    • ims_yz_goods_filtering(商品标签关联表)
    • ims_yz_goods_coupon(商品优惠券)
    • ims_yz_goods_return_address(退货地址设置)
  • 插件
    • 分润类
      • 微店插件
        • ims_yz_goods_micro
        • ims_yz_micro_shop
        • ims_yz_micro_shop_bonus_log
        • ims_yz_micro_shop_carousel
        • ims_yz_micro_shop_goods
        • ims_yz_micro_shop_level
        • ims_yz_micro_shop_withdraw
      • 招商插件
        • ims_yz_merchant
        • ims_yz_merchant_apply
        • ims_yz_merchant_black
        • ims_yz_merchant_bonus_log
        • ims_yz_merchant_goods
        • ims_yz_merchant_level
        • ims_yz_merchant_log
        • ims_yz_merchant_staff_level
      • 股东分红插件
        • ims_yz_shareholder_dividend
        • ims_yz_shareholder_dividend_exception
      • 经销商管理插件
        • ims_yz_goods_team_dividend
        • ims_yz_team_dividend
        • ims_yz_team_dividend_agency
        • ims_yz_team_dividend_code
        • ims_yz_team_dividend_level
        • ims_yz_team_dividend_level_upgrade
      • 分销插件数据字典
        • ims_yz_commission_edit_log 分销设置修改记录
        • ims_yz_commission_manage 分销管理奖表
        • ims_yz_commission_order 分销订单表
        • ims_yz_commission_log 分销商升级记录表
        • ims_yz_commission_order_goods 分销订单商品表
        • ims_yz_goods_commission 分销商品设置表
        • ims_yz_agents 推广员表
        • ims_yz_agent_level 分销等级表
      • 区域分红
        • yz_goods_area_dividend
        • yz_area_dividend_agent
        • yz_area_dividend
      • 团队奖励插件
        • yz_team_rewards_member
        • yz_team_rewards_level
        • yz_team_level_task
        • yz_team_member_tasks
        • yz_team_rewards_order
        • yz_team_rewards_goods
      • ozy
        • yz_ozy_member
        • yz_ozy_level
        • yz_ozy_award_record
        • yz_ozy_goods_set
        • yz_ozy_user_upgrade_record
        • yz_love_order_frozen_record
        • yz_love_ozy_thaw_record
      • 分销活动
        • yz_commission_activity
        • yz_commission_activity_member
      • 加权分红
    • 行业类
      • 租赁
        • yz_lease_toy_goods
        • yz_lease_toy_return_address
        • yz_lease_toy_level_rights
        • yz_lease_toy_member
        • yz_lease_toy_order_goods
        • yz_plugin_lease_order
        • yz_plugin_lease_member_cart
        • yz_lease_toy_term_set
        • yz_lease_toy_order_return_address
        • yz_lease_toy_return_express
        • yz_lease_toy_rights_log
      • 门店收银台插件
        • ims_yz_store
        • ims_yz_store_advertisement
        • ims_yz_store_apply
        • ims_yz_store_auto_log
        • ims_yz_store_boss
        • ims_yz_store_boss_order
        • ims_yz_store_boss_stores
        • ims_yz_store_carousel
        • ims_yz_store_cashier_give_coupon
        • ims_yz_store_cashier_give_reward
        • ims_yz_store_category
        • ims_yz_store_dispatch
        • ims_yz_store_goods
        • ims_yz_store_goods_category
        • ims_yz_store_setting
        • ims_yz_store_settlement_log
        • ims_yz_store_share_chain
        • ims_yz_store_verification_clerk
        • ims_yz_plugin_store_member_cart
        • ims_yz_plugin_store_order
        • ims_yz_plugin_store_self_delivery
        • ims_yz_plugin_store_store_delivery
        • ims_yz_plugin_cashier_order
        • ims_yz_cashier_goods
      • 供应商插件
        • ims_yz_supplier
        • ims_yz_supplier_adv
        • ims_yz_supplier_dispatch
        • ims_yz_supplier_goods
        • ims_yz_supplier_order
        • ims_yz_supplier_slide
        • ims_yz_supplier_withdraw
      • 会务活动
        • ims_yz_conference_activity(会务活动表)
        • ims_yz_conference_enrol (会务活动报名数据表)
      • 视频点播
        • yz_video_slide
        • yz_video_lecturer
        • yz_video_lecturer_reward_log
        • yz_video_reward_log
        • yz_video_course_goods
        • yz_video_course_chapter
        • yz_video_historical
        • yz_video_member_course
      • 微社区
        • yz_micro_communities_stick
        • yz_micro_communities_category
        • yz_micro_communities_stick_images
        • yz_micro_communities_stick_comments
        • yz_micro_communities_stick_reward
        • yz_micro_communities_stick_praise
        • yz_micro_communities_stick_follow
        • yz_micro_communities_set
        • yz_micro_communities_stick_browse
        • yz_micro_communities_search_log
        • mc_member添加字段
        • yz_micro_communities_category_reward
      • 语音商品
        • yz_voice_goods_commodity
        • yz_voice_goods_permission_record
      • 宠物医院
        • yz_pet_member
        • yz_pets
        • yz_pet_balance_record
        • yz_pet_integral_record
        • yz_pet_appointment
        • yz_pet_register
        • 修改现有的yz_balance表和yz_point_log表
        • yz_pet_supplement_log
      • 拍卖
        • yz_auction_goods
        • yz_auction_auctioneer
        • yz_auction_area_agent
        • yz_auction_legalize_record
        • yz_auction_rotation
        • yz_auction_collection
        • yz_auction_browse
        • yz_auction_prepayment
      • 洗车
        • yz_wash_machine
        • yz_wash_field
        • yz_wash_investor
        • yz_wash_orders
        • yz_wash_logs
        • yz_wash_machine_investors
        • yz_wash_statistics
        • yz_wash_token
        • yz_wash_machine_car
        • yz_wash_machine_status
        • yz_wash_investor_bonus
        • yz_wash_field_bonus
      • 供需信息
        • 金融服务申请
        • 举报申请
        • 采购信息
        • 供应信息
      • 安装服务
        • yz_assemble_worker_apply
        • yz_assemble_worker
        • yz_assemble_district_worker
        • yz_assemble_goods
        • yz_assemble_order
        • yz_assemble_order_wages
        • yz_assemble_order_bonus
        • yz_assemble_order_appointment
        • yz_assemble_order_distribution
      • 门店车场
        • yz_kart
        • yz_kart_accepts
        • yz_kart_likes
        • yz_kart_match
        • yz_kart_match_user
        • yz_kart_match_user_detail
        • yz_kart_pass_line
        • ims_yz_kart_poster
        • ims_yz_kart_ranking_day
        • ims_yz_kart_ranking_list
        • ims_yz_kart_ranking_month
        • ims_yz_kart_ranking_week
        • ims_yz_kart_ranking_year
        • ims_yz_kart_statistic
        • ims_yz_kart_store
        • ims_yz_kart_store_screen
        • ims_yz_kart_store_screen_to_type
        • ims_yz_kart_to_type
        • ims_yz_kart_type
        • ims_yz_kart_type_ranking_day
        • ims_yz_kart_type_ranking_list
        • ims_yz_kart_type_ranking_month
        • ims_yz_kart_type_ranking_week
        • ims_yz_kart_type_ranking_year
        • ims_yz_kart_user
    • 营销类
      • 爱心值数据字典
        • ims_yz_love(爱心值表)
        • ims_yz_love_activation(爱心值激活表)
        • ims_yz_love_goods(爱心值商品表)
        • ims_yz_love_member(爱心值会员表)
        • ims_yz_love_order(爱心值订单表)
        • ims_yz_love_order_goods(爱心值订单货物表
        • ims_yz_love_recharge(爱心值充值表)
        • ims_yz_love_return_log(爱心值返现记录表)
        • ims_yz_love_timing_log(爱心值定时日志表)
        • ims_yz_love_timing_queue(爱心值定时队列表)
        • ims_yz_love_trading(爱心值交易表)
        • 表名:ims_yz_love_transfer(爱心值调动表)
      • 文章营销数据字典
        • ims_site_article(站点文章表)
        • ims_site_article_comment(文章评述表)
        • ims_yz_plugin_article(文章管理表)
        • ims_yz_plugin_article_category(文章分类表)
        • ims_yz_plugin_article_log(文章日志表)
        • ims_yz_plugin_article_report(文章报道表)
        • ims_yz_plugin_article_share(文章份额表)
      • 等级返现数据字典
        • ims_yz_agent_level(代理等级表)
        • ims_yz_area_store_member_level(门店会员等级表)
        • ims_yz_goods_level_returns(商品等级返现表)
        • ims_yz_lease_toy_level_rights(租赁权限等级表)
        • ims_yz_level_return(等级返现表)
        • ims_yz_level_return_goods(商品等级返现表)
        • ims_yz_member_level(会员等级表)
        • ims_yz_merchant_level(分销商等级表)
      • 打卡数据字典
        • ims_yz_clock_continuity(连续打卡表)
        • ims_yz_clock_pay_log(打卡支付记录表)
        • ims_yz_clock_queue(打卡队列表)
        • ims_yz_clock_reward_log(打卡奖励记录表)
        • ims_yz_clock_rule(打卡规则表)
      • 经销商奖励数据字典
        • ims_yz_team_return_log 经销商奖励记录
      • 满额赠送插件
        • ims_yz_full_return_queue
        • ims_yz_full_return_log
        • ims_yz_full_return_consume_log
        • ims_yz_full_return_consume_detailed_log
        • ims_yz_full_return_deduct_log
        • ims_yz_full_return_total_change_log
      • 消费赠送插件
        • ims_yz_consume_return_queue
        • ims_yz_consume_return_log
      • 签到
        • ims_yz_clock_continuity(签到表)
        • ims_yz_clock_pay_log(签到支付表)
        • ims_yz_clock_queue(签到队列表)
        • ims_yz_clock_reward_log(签到奖励记录表)
        • ims_yz_clock_rule(签到规则表)
      • 消费返现数据字典
        • ims_yz_consume_return_log(消费返现记录表)
        • ims_yz_consume_return_queue(消费队列返现表)
        • ims_yz_full_return_consume_log(全收益消费日志表)
      • 共享链数据字典
        • yz_share_chain_mlevel (共享链会员表)
        • yz_share_chain_goods(共享链商品表)
        • yz_share_chain_award_log (共享链奖励表)
        • yz_share_chain_lucky_log (抽奖记录表)
        • yz_share_chain_operation_log (操作记录表)
        • yz_share_chain_queue_by_cashier (共享链收银台权益表)
        • yz_share_chain_queue_by_goods (商品权益表)
        • yz_share_chain_queue_by_store (门店权益表)
        • yz_share_chain_diy_return (随机返设置表)
        • yz_share_chain_diy_log (随机返记录表)
      • 拼团活动数据字典
        • yz_fight_groups(拼团活动表)
        • yz_fight_groups_level(活动层级表)
        • yz_fight_groups_team(团队表)
        • yz_fight_groups_team_member(团员表)
        • yz_fight_groups_option(活动规格表)
        • yz_fight_groups_option_level(规格层级表)
      • 文章付费
        • yz_article_pay_money
        • yz_article_pay_record
      • 优惠券二维码
        • yz_coupon_qr_generate
        • yz_coupon_qr_record
      • 每日红包
        • yz_red_packet_goods
        • yz_red_packet_logs
        • yz_red_packet_quota_logs
        • yz_red_packet_quota_management
        • yz_red_packet_receive_logs
      • 营销小助手
        • yz_promotion_assistant
      • integral 消费积分
        • yz_integral_withdraw
        • yz_integral_transfer
        • yz_integral_records
        • yz_integral_recharge
        • yz_integral_member
        • yz_integral_goods
        • yz_integral_deduction_return_record
      • 共享奖
        • yz_share_award_line_up
        • yz_share_award_line_up_delete
        • yz_share_award_down_income
        • yz_share_award_up_income
      • 管理奖
        • yz_manage_award_records
      • 积分活动
        • ims_yz_point_activity
        • yz_point_activity_receive_log
        • yz_point_activity_award_log
        • yz_goods_point_activity
      • 冻结币
        • yz_froze_recharge
        • yz_froze_process
        • yz_froze_member
        • yz_froze_withdraw
        • yz_froze_log
      • 华侨币
        • yz_coin_member
        • yz_coin
        • yz_coin_goods
        • yz_coin_transfer
        • yz_coin_withdraw
        • yz_coin_activation
        • yz_coin_order
        • yz_coin_order_goods
      • 爱心值交易
        • yz_love_trade_set
      • 层链积分
        • yz_layer_chain_goods
        • yz_layer_chain_recharge_records
        • yz_layer_chain_recharge_detail
      • 问卷功能
        • yz_questionnaire
        • yz_questionnaire_programme
        • yz_questionnaire_programme_reward
        • yz_questionnaire_record
        • yz_questionnaire_choice
      • 分享券数据字典
        • yz_share_coupon_records
      • 拼单
        • 拼单会员
        • 拼单分红
        • 拼单分类
        • 拼单等级
        • 拼单项目
        • 拼单项目分类
        • 拼单订单
      • 区域代理查询数据字典
        • yz_enquiry_tags
        • yz_tag_area
        • yz_tag_street
      • 区域业绩奖励
        • yz_regional_rewards
        • yz_regional_reward_quota
        • yz_regional_reward_record
        • yz_regional_goods
        • yz_agency_virtual_performance
        • yz_regional_quota_change_logs
        • yz_regional_reward_logs
      • 订单飘窗
        • yz_broadcast_config
      • 消费红包(consume-red-packet)
        • yz_consume_red_packet_pond
        • yz_consume_red_packet_pond_source
        • yz_consume_red_packet_pond_receive
      • 销售报表数据字典
        • yz_sales_pool
        • yz_sales_pool_record
        • yz_sales_report_goods
        • yz_sales_report_bonus
        • yz_sales_report_banners
      • 社群接龙数据字典
        • yz_cr_activity
        • yz_cr_goods
        • yz_cr_order
        • yz_cr_order_goods
        • yz_cr_poster
        • yz_cr_reward_log
      • 自购省
        • yz_sbd_goods
        • yz_sbd_order
      • 转发宝
        • yz_forwarding_treasure
        • yz_forwarding_treasure_coupon
        • yz_forwarding_treasure_image
        • yz_forwarding_treasure_member
        • yz_forwarding_treasure_log
      • 拓客卡
        • yz_development_card_goods
        • yz_development_card_once
        • yz_development_card_many
        • yz_member_development_card
        • yz_member_development_card_once
        • yz_member_development_card_many
        • yz_development_write_off_logs
      • 升级码
        • yz_upgrade_codes
        • yz_upgrade_codes_detail
        • yz_upgrade_codes_goods
        • yz_member_upgrade_codes
        • yz_member_upgrade_codes_detail
        • yz_member_upgrade_codes_change
        • yz_member_upgrade_codes_logs
        • yz_upgrade_codes_keys
      • 等级限购
        • yz_limit_purchases_goods
      • 分享奖数据字典
        • yz_member_share_goods
        • yz_member_share_reward_logs
      • 直接推荐奖
        • yz_recommend_reward_levels
        • yz_recommend_reward_level_goods
        • yz_recommend_reward_members
        • yz_recommend_reward_records
        • yz_recommend_reward_records_change
    • 工具类
      • 店铺装修
        • yz_designer
        • yz_designer_menu
        • yz_designer_top_menu
        • yz_designer_view_set
        • yz_member_designer
      • 打印机插件
        • ims_yz_printer
        • ims_yz_print_template
        • ims_yz_print_setting
      • 帮助中心
        • ims_yz_help_center_content
      • app设置
        • ims_yz_app_message(app设置->消息设置表)
        • ims_yz_app_message_log(app设置->消息记录表)
      • 自定义表单
        • ims_yz_diyform_data(自定义表单->表单数据表)
        • ims_yz_diyform_type(自定义表单->表单类型表)
      • 快递助手
        • yz_exhelper_order(快递订单表)
        • yz_exhelper_express(快递单模型表)
        • yz_exhelper_goods
        • yz_exhelper_print
        • yz_exhelper_sys
        • yz_exhelper_senduser(发件人信息表)
        • yz_exhelper_panel(电子面单模板表)
      • 公众号
        • yz_wechat_menu 公众号菜单表
        • yz_wechat_rule 公众号规则表
        • yz_wechat_rule_keyword 公众号规则关键字
        • yz_wechat_basic_reply 公众号关键字的文字回复
        • yz_wechat_image_reply 公众号关键字的回复图片
        • yz_wechat_music_reply 关键字回复音乐
        • yz_wechat_news_reply 关键字回复图文
        • ims_yz_wechat_userapi_reply
        • yz_wechat_video_reply 关键字回复视频
        • ims_yz_wechat_voice_reply 关键字回复语音
        • yz_wechat_attachment 公众号素材
        • yz_wechat_core_attachment
      • 导入会员
        • yz_import_member_records会员导入记录表
        • yz_import_member_detail会员导入记录详情表
        • yz_import_level_records会员等级导入记录表
        • yz_import_level_detail会员等级导入详情表
        • yz_import_group_records会员分组导入记录表
        • yz_import_group_detail会员分组导入详情表
        • ims_yz_import_subsidiary_records分公司导入记录
        • ims_yz_import_subsidiary_detail分公司导入详情
        • ims_yz_import_dealer_records经销商导入记录
        • ims_yz_import_dealer_detail经销商导入详情
      • 会员同步升级
        • 升级条件
        • 插件同步升级记录
      • 注册区域
        • yz_order_location
        • yz_member_location
      • PC端微信扫码登录
        • yz_wechat_qrcode_login_config
      • 批量设置同步
        • yz_synchronous_config
    • 区块链
      • 数字资产化
        • 表名
          • yz_asset_digitization_price_change_records
          • yz_asset_individual_businesses
          • yz_asset_category
          • yz_asset_notice
          • yz_asset
          • yz_asset_slide
          • yz_asset_assess
          • yz_asset_finance
          • yz_asset_industry
          • yz_asset_company
          • yz_asset_government
          • yz_asset_private_non_enterprises
          • yz_asset_public_institution
          • yz_asset_social_group
          • yz_asset_register_address
          • yz_asset_property
          • yz_asset_digitization
          • yz_asset_member
          • yz_asset_member_statistics
          • yz_asset_digitization_increase_records
          • yz_asset_goods
          • yz_asset_digitization_setting
          • yz_asset_transfer_records
          • yz_asset_dispense_records
          • yz_asset_subscription_goods
          • yz_asset_sell_records
          • yz_asset_member_change_records
          • yz_asset_bonus_pool_records
          • yz_asset_member_bonus_statistics
          • yz_asset_member_bonus_records
    • 门店配送规则
      • ims_yz_store_geo_fence
    • 支付
      • 汇聚支付分账
        • 分账支付记录
        • 分账详情记录
  • 新框架
    • ims_yz_admin_users(用户表)
    • ims_yz_users_profile(用户信息表)
    • ims_yz_system_setting(系统设置表)
    • ims_yz_core_attachment(上传文件存储表)
    • ims_yz_app_user(公众号管理员角色)
    • ims_yz_uniacid_app(公众平台表)
  • 财务
    • 余额充值记录
    • 余额充值活动
    • 余额转让记录
    • 余额明细记录
    • 余额转化爱心值
    • 收入明细记录
    • 会员提现记录
    • 积分充值记录
    • 积分明细记录
    • 积分队列记录
    • 积分队列明细
    • Excel充值记录
    • Excel充值明细
    • yz_bind_mobile_award_point
  • 统计
    • ims_yz_member_lower_count
    • ims_yz_member_lower_order
    • ims_yz_distribution_order
    • ims_yz_order_statistics
    • ims_yz_phone_attribution
    • ims_yz_order_income_count

本文档使用 SmartWiki 发布

宠物医院

项目分享