vibe-coding-cn/yshop/database.canvas

{
	"nodes":[
		{"id":"title","type":"text","text":"# YShop Drink 数据库设计\n\nMySQL 数据库表结构概览","x":-200,"y":-400,"width":400,"height":80,"color":"1"},
		{"id":"core-user","type":"text","text":"## 用户相关\n\n| 表名 | 说明 |\n|------|------|\n| `yshop_user` | 会员用户 |\n| `yshop_user_address` | 收货地址 |\n| `yshop_user_bill` | 用户账单 |\n| `yshop_user_bank` | 银行卡 |\n| `yshop_vip_card` | VIP卡 |\n| `yshop_recharge` | 充值记录 |","x":-650,"y":-260,"width":280,"height":240,"color":"4"},
		{"id":"core-product","type":"text","text":"## 商品相关\n\n| 表名 | 说明 |\n|------|------|\n| `yshop_store_product` | 商品信息 |\n| `yshop_store_product_category` | 商品分类 |\n| `yshop_store_product_attr` | 商品规格 |\n| `yshop_store_product_attr_value` | 规格值 |\n| `yshop_store_product_attr_result` | SKU |\n| `yshop_store_product_brand` | 品牌 |\n| `yshop_store_product_rule` | 规格模板 |\n| `yshop_store_product_relation` | 商品关联 |\n| `yshop_store_product_reply` | 商品评价 |","x":-320,"y":-260,"width":320,"height":300,"color":"3"},
		{"id":"core-order","type":"text","text":"## 订单相关\n\n| 表名 | 说明 |\n|------|------|\n| `yshop_store_order` | 订单主表 |\n| `yshop_store_order_cart_info` | 订单商品 |\n| `yshop_store_order_status` | 订单状态 |\n| `yshop_store_order_invoice` | 订单发票 |\n| `yshop_store_cart` | 购物车 |\n| `yshop_store_cart_share` | 购物车分享 |\n| `yshop_order_number` | 订单号生成 |","x":40,"y":-260,"width":300,"height":260,"color":"3"},
		{"id":"core-shop","type":"text","text":"## 门店相关\n\n| 表名 | 说明 |\n|------|------|\n| `yshop_store_shop` | 门店信息 |\n| `yshop_store_user` | 门店员工 |\n| `yshop_store_revenue` | 门店流水 |\n| `yshop_store_withdrawal` | 门店提现 |\n| `yshop_shop_desk` | 桌号 |\n| `yshop_shop_desk_category` | 桌号分类 |\n| `yshop_shop_ads` | 门店广告 |","x":380,"y":-260,"width":280,"height":260,"color":"5"},
		{"id":"marketing","type":"text","text":"## 营销相关\n\n| 表名 | 说明 |\n|------|------|\n| `yshop_coupon` | 优惠券 |\n| `yshop_coupon_user` | 用户优惠券 |\n| `yshop_shop_due_label` | 到期标签 |\n| `yshop_shop_due_rule` | 到期规则 |","x":-650,"y":80,"width":280,"height":200,"color":"4"},
		{"id":"score","type":"text","text":"## 积分相关\n\n| 表名 | 说明 |\n|------|------|\n| `yshop_score_product` | 积分商品 |\n| `yshop_score_product_category` | 积分商品分类 |\n| `yshop_score_order` | 积分订单 |\n| `yshop_score_ads` | 积分广告 |","x":-320,"y":80,"width":280,"height":200,"color":"4"},
		{"id":"wechat","type":"text","text":"## 微信相关\n\n| 表名 | 说明 |\n|------|------|\n| `mp_account` | 公众号配置 |\n| `mp_menu` | 公众号菜单 |\n| `mp_auto_reply` | 自动回复 |\n| `mp_material` | 素材管理 |\n| `mp_user` | 粉丝 |\n| `mp_tag` | 标签 |\n| `mp_message` | 消息 |\n| `yshop_wechat_template` | 模板消息 |","x":0,"y":80,"width":280,"height":280,"color":"4"},
		{"id":"system","type":"text","text":"## 系统相关\n\n| 表名 | 说明 |\n|------|------|\n| `system_users` | 管理员 |\n| `system_role` | 角色 |\n| `system_menu` | 菜单 |\n| `system_dept` | 部门 |\n| `system_dict_*` | 字典 |\n| `system_login_log` | 登录日志 |\n| `system_operate_log` | 操作日志 |","x":320,"y":80,"width":280,"height":240,"color":"2"},
		{"id":"infra","type":"text","text":"## 基础设施\n\n| 表名 | 说明 |\n|------|------|\n| `infra_file` | 文件记录 |\n| `infra_file_config` | 存储配置 |\n| `infra_config` | 系统配置 |\n| `infra_job` | 定时任务 |\n| `infra_codegen_*` | 代码生成 |\n| `infra_api_*_log` | API日志 |","x":-650,"y":340,"width":280,"height":220,"color":"2"},
		{"id":"other","type":"text","text":"## 其他\n\n| 表名 | 说明 |\n|------|------|\n| `yshop_material` | 素材库 |\n| `yshop_material_group` | 素材分组 |\n| `yshop_qrcode` | 二维码 |\n| `yshop_express` | 快递配置 |\n| `yshop_web_print` | 云打印机 |\n| `yshop_web_print_config` | 打印配置 |\n| `yshop_service` | 服务 |\n| `merchant_details` | 商户详情 |\n| `QRTZ_*` | Quartz调度 |","x":-320,"y":340,"width":280,"height":560,"color":"2"},
		{"id":"er-note","type":"text","text":"## 核心关系\n\n```\nyshop_user (1) ─── (*) yshop_store_order\n     │                      │\n     │                      ├── yshop_store_order_cart_info\n     │                      └── yshop_store_order_status\n     │\n     ├── yshop_user_address\n     ├── yshop_user_bill  \n     └── yshop_coupon_user\n\nyshop_store_product ─── yshop_store_product_attr_value (SKU)\n         │\n         └── yshop_store_product_category\n\nyshop_store_shop (门店) ─── yshop_shop_desk (桌号)\n         │\n         └── yshop_store_order\n```","x":0,"y":400,"width":400,"height":640,"color":"1"}
	],
	"edges":[
		{"id":"edge-user-order","fromNode":"core-user","fromSide":"right","toNode":"core-order","toSide":"left","label":"下单"},
		{"id":"edge-product-order","fromNode":"core-product","fromSide":"right","toNode":"core-order","toSide":"left"},
		{"id":"edge-shop-order","fromNode":"core-shop","fromSide":"bottom","toNode":"core-order","toSide":"right","label":"门店订单"},
		{"id":"edge-user-coupon","fromNode":"core-user","fromSide":"bottom","toNode":"marketing","toSide":"top","label":"领券"},
		{"id":"edge-user-score","fromNode":"core-user","fromSide":"bottom","toNode":"score","toSide":"top","label":"积分"}
	]
}