烘焙预约小程序 - 数据库ER图

erDiagram %% 模块A：用户点单 goods_type ||--o{ goods_type : "自关联parentId" goods_type ||--o{ goods_info : "1:N typeId" goods_info ||--o{ goods_spec : "1:N goodsId" goods_info ||--o{ goods_comment : "1:N goodsId" goods_info ||--o{ order_goods : "1:N goodsId" user_info ||--o{ goods_comment : "1:N userId" %% 模块B：外卖配送 user_info ||--o{ order_info : "1:N userId" shop_info ||--o{ order_info : "1:N shopId" order_info ||--o{ order_goods : "1:N orderId" order_info ||--o| market_coupon_user : "1:1 orderId" %% 模块C：预约 user_info ||--o{ bake_reservation : "1:N userId" shop_info ||--o{ bake_reservation : "1:N shopId" shop_info ||--o{ bake_shop_delivery_tip : "1:N shopId" %% 公共模块 user_info ||--o{ user_address : "1:N userId" user_info ||--o{ user_wx : "1:N userId" user_info ||--o{ user_vip : "1:1 userId" user_info ||--o{ market_coupon_user : "1:N userId" market_coupon_info ||--o{ market_coupon_user : "1:N couponId" user_info ||--o{ cs_session : "1:N userId" cs_session ||--o{ cs_msg : "1:N sessionId" user_info ||--o{ app_feedback : "1:N userId" user_info ||--o{ app_complain : "1:N userId" %% 用户相关表 user_info { bigint id PK string unionId UK string nickName string phone string avatarUrl int vipLevel int points } user_address { bigint id PK bigint userId FK string name string phone string province string city string area string address string detail tinyint isDefault } user_wx { bigint id PK bigint userId FK string openId UK string sessionKey } user_vip { bigint id PK bigint userId FK int level datetime expireTime } %% 门店相关表 shop_info { bigint id PK string name string contactName string phone string address float latitude float longitude tinyint status bigint adminUserId FK string deliveryTip } info_banner { bigint id PK string title string picUrl string linkUrl tinyint type int sort tinyint status } %% 商品相关表 goods_type { bigint id PK bigint shopId FK bigint parentId FK string name string pic int sort } goods_info { bigint id PK bigint shopId FK bigint typeId FK string name string description decimal price int stock int sales string pic text pics } goods_spec { bigint id PK bigint goodsId FK string name tinyint type json values } goods_comment { bigint id PK bigint userId FK bigint goodsId FK bigint orderId FK string content text pics tinyint star } %% 订单相关表 order_info { bigint id PK string orderNo UK bigint userId FK bigint shopId FK tinyint type "0自取1外卖2堂食" string takeNo "取餐号AWD前缀" string seatNo "座位号堂食可选" tinyint status decimal totalPrice decimal payPrice decimal deliveryFee json address string remark bigint couponUserId FK datetime payTime datetime finishTime } order_goods { bigint id PK bigint orderId FK bigint goodsId FK string goodsName decimal price int num string specIds string specNames string pic } %% 预约相关表（新增） bake_reservation { bigint id PK bigint userId FK bigint shopId FK tinyint type string contactName string phone date reserveDate string reserveTime json address string voucherPic string remark tinyint status } bake_shop_delivery_tip { bigint id PK bigint shopId FK string tip int minPrice int maxDistance } %% 营销相关表 market_coupon_info { bigint id PK string name tinyint type decimal value decimal minAmount int validDays int total int received int limitPerUser tinyint status } market_coupon_user { bigint id PK bigint userId FK bigint couponId FK bigint orderId FK tinyint status datetime useTime datetime expireTime } %% 客服相关表 cs_session { bigint id PK bigint userId FK string lastMsg int unreadCount datetime lastTime } cs_msg { bigint id PK bigint sessionId FK tinyint type string content tinyint isRead tinyint fromAdmin } %% 应用相关表 app_feedback { bigint id PK bigint userId FK string content text pics tinyint status string reply } app_complain { bigint id PK bigint userId FK bigint orderId FK string content text pics tinyint status string reply } app_version { bigint id PK string version string platform string content tinyint forceUpdate } app_goods { bigint id PK string name decimal price text goodsIds string pic }

erDiagram %% 预约模块核心关系 user_info ||--o{ bake_reservation : "1:N userId" shop_info ||--o{ bake_reservation : "1:N shopId" shop_info ||--o{ bake_shop_delivery_tip : "1:N shopId" user_info { bigint id PK string unionId UK string nickName string phone string avatarUrl } shop_info { bigint id PK string name string address float latitude float longitude bigint adminUserId FK string deliveryTip } bake_reservation { bigint id PK bigint userId FK bigint shopId FK tinyint type string contactName string phone date reserveDate string reserveTime json address string voucherPic string remark tinyint status } bake_shop_delivery_tip { bigint id PK bigint shopId FK string tip int minPrice int maxDistance }