• 软件的开发步骤,需求分析,开发环境搭建,接口文档 ---苍穹外卖1

    目录

     项目总览

    开发准备

    开发步骤

     角色分工

    软件环境

    项目介绍

    产品原型

    技术选型

    开发环境搭建

    前端:默认已有

    后端

    使用Git版本控制

    数据库环境搭建

    前后端联调

    ​登录功能完善

    导入接口文档

     使用swagger​

    和yapi的区别

    常用注解

     项目总览

    开发准备

    开发步骤

     角色分工

    软件环境

    项目介绍

    产品原型

    展示产品的简单框架,方便后端开发人员理解业务流程,和相关功能的开发.

    技术选型

    开发环境搭建

    前端:默认已有

    后端

    POJO层的类注释:

    使用Git版本控制

    数据库环境搭建

    1. CREATE DATABASE  IF NOT EXISTS `sky_take_out` ;
    2. USE `sky_take_out`;
    3.  
    4. DROP TABLE IF EXISTS `address_book`;
    5. CREATE TABLE `address_book` (
    6.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    7.   `user_id` bigint NOT NULL COMMENT '用户id',
    8.   `consignee` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '收货人',
    9.   `sex` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '性别',
    10.   `phone` varchar(11) COLLATE utf8_bin NOT NULL COMMENT '手机号',
    11.   `province_code` varchar(12) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '省级区划编号',
    12.   `province_name` varchar(32) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '省级名称',
    13.   `city_code` varchar(12) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '市级区划编号',
    14.   `city_name` varchar(32) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '市级名称',
    15.   `district_code` varchar(12) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '区级区划编号',
    16.   `district_name` varchar(32) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '区级名称',
    17.   `detail` varchar(200) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '详细地址',
    18.   `label` varchar(100) CHARACTER SET utf8mb4  DEFAULT NULL COMMENT '标签',
    19.   `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '默认 0 否 1是',
    20.   PRIMARY KEY (`id`)
    21. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='地址簿';
    22.  
    23. DROP TABLE IF EXISTS `category`;
    24. CREATE TABLE `category` (
    25.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    26.   `type` int DEFAULT NULL COMMENT '类型   1 菜品分类 2 套餐分类',
    27.   `name` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '分类名称',
    28.   `sort` int NOT NULL DEFAULT '0' COMMENT '顺序',
    29.   `status` int DEFAULT NULL COMMENT '分类状态 0:禁用，1:启用',
    30.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    31.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    32.   `create_user` bigint DEFAULT NULL COMMENT '创建人',
    33.   `update_user` bigint DEFAULT NULL COMMENT '修改人',
    34.   PRIMARY KEY (`id`),
    35.   UNIQUE KEY `idx_category_name` (`name`)
    36. ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='菜品及套餐分类';
    37.  
    38. INSERT INTO `category` VALUES (11,1,'酒水饮料',10,1,'2022-06-09 22:09:18','2022-06-09 22:09:18',1,1);
    39. INSERT INTO `category` VALUES (12,1,'传统主食',9,1,'2022-06-09 22:09:32','2022-06-09 22:18:53',1,1);
    40. INSERT INTO `category` VALUES (13,2,'人气套餐',12,1,'2022-06-09 22:11:38','2022-06-10 11:04:40',1,1);
    41. INSERT INTO `category` VALUES (15,2,'商务套餐',13,1,'2022-06-09 22:14:10','2022-06-10 11:04:48',1,1);
    42. INSERT INTO `category` VALUES (16,1,'蜀味烤鱼',4,1,'2022-06-09 22:15:37','2022-08-31 14:27:25',1,1);
    43. INSERT INTO `category` VALUES (17,1,'蜀味牛蛙',5,1,'2022-06-09 22:16:14','2022-08-31 14:39:44',1,1);
    44. INSERT INTO `category` VALUES (18,1,'特色蒸菜',6,1,'2022-06-09 22:17:42','2022-06-09 22:17:42',1,1);
    45. INSERT INTO `category` VALUES (19,1,'新鲜时蔬',7,1,'2022-06-09 22:18:12','2022-06-09 22:18:28',1,1);
    46. INSERT INTO `category` VALUES (20,1,'水煮鱼',8,1,'2022-06-09 22:22:29','2022-06-09 22:23:45',1,1);
    47. INSERT INTO `category` VALUES (21,1,'汤类',11,1,'2022-06-10 10:51:47','2022-06-10 10:51:47',1,1);
    48.  
    49. DROP TABLE IF EXISTS `dish`;
    50. CREATE TABLE `dish` (
    51.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    52.   `name` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '菜品名称',
    53.   `category_id` bigint NOT NULL COMMENT '菜品分类id',
    54.   `price` decimal(10,2) DEFAULT NULL COMMENT '菜品价格',
    55.   `image` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '图片',
    56.   `description` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '描述信息',
    57.   `status` int DEFAULT '1' COMMENT '0 停售 1 起售',
    58.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    59.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    60.   `create_user` bigint DEFAULT NULL COMMENT '创建人',
    61.   `update_user` bigint DEFAULT NULL COMMENT '修改人',
    62.   PRIMARY KEY (`id`),
    63.   UNIQUE KEY `idx_dish_name` (`name`)
    64. ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='菜品';
    65.  
    66. INSERT INTO `dish` VALUES (46,'王老吉',11,6.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/41bfcacf-7ad4-4927-8b26-df366553a94c.png','',1,'2022-06-09 22:40:47','2022-06-09 22:40:47',1,1);
    67. INSERT INTO `dish` VALUES (47,'北冰洋',11,4.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/4451d4be-89a2-4939-9c69-3a87151cb979.png','还是小时候的味道',1,'2022-06-10 09:18:49','2022-06-10 09:18:49',1,1);
    68. INSERT INTO `dish` VALUES (48,'雪花啤酒',11,4.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/bf8cbfc1-04d2-40e8-9826-061ee41ab87c.png','',1,'2022-06-10 09:22:54','2022-06-10 09:22:54',1,1);
    69. INSERT INTO `dish` VALUES (49,'米饭',12,2.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/76752350-2121-44d2-b477-10791c23a8ec.png','精选五常大米',1,'2022-06-10 09:30:17','2022-06-10 09:30:17',1,1);
    70. INSERT INTO `dish` VALUES (50,'馒头',12,1.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/475cc599-8661-4899-8f9e-121dd8ef7d02.png','优质面粉',1,'2022-06-10 09:34:28','2022-06-10 09:34:28',1,1);
    71. INSERT INTO `dish` VALUES (51,'老坛酸菜鱼',20,56.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/4a9cefba-6a74-467e-9fde-6e687ea725d7.png','原料：汤，草鱼，酸菜',1,'2022-06-10 09:40:51','2022-06-10 09:40:51',1,1);
    72. INSERT INTO `dish` VALUES (52,'经典酸菜鮰鱼',20,66.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/5260ff39-986c-4a97-8850-2ec8c7583efc.png','原料：酸菜，江团，鮰鱼',1,'2022-06-10 09:46:02','2022-06-10 09:46:02',1,1);
    73. INSERT INTO `dish` VALUES (53,'蜀味水煮草鱼',20,38.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a6953d5a-4c18-4b30-9319-4926ee77261f.png','原料：草鱼，汤',1,'2022-06-10 09:48:37','2022-06-10 09:48:37',1,1);
    74. INSERT INTO `dish` VALUES (54,'清炒小油菜',19,18.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/3613d38e-5614-41c2-90ed-ff175bf50716.png','原料：小油菜',1,'2022-06-10 09:51:46','2022-06-10 09:51:46',1,1);
    75. INSERT INTO `dish` VALUES (55,'蒜蓉娃娃菜',19,18.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/4879ed66-3860-4b28-ba14-306ac025fdec.png','原料：蒜，娃娃菜',1,'2022-06-10 09:53:37','2022-06-10 09:53:37',1,1);
    76. INSERT INTO `dish` VALUES (56,'清炒西兰花',19,18.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/e9ec4ba4-4b22-4fc8-9be0-4946e6aeb937.png','原料：西兰花',1,'2022-06-10 09:55:44','2022-06-10 09:55:44',1,1);
    77. INSERT INTO `dish` VALUES (57,'炝炒圆白菜',19,18.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/22f59feb-0d44-430e-a6cd-6a49f27453ca.png','原料：圆白菜',1,'2022-06-10 09:58:35','2022-06-10 09:58:35',1,1);
    78. INSERT INTO `dish` VALUES (58,'清蒸鲈鱼',18,98.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c18b5c67-3b71-466c-a75a-e63c6449f21c.png','原料：鲈鱼',1,'2022-06-10 10:12:28','2022-06-10 10:12:28',1,1);
    79. INSERT INTO `dish` VALUES (59,'东坡肘子',18,138.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a80a4b8c-c93e-4f43-ac8a-856b0d5cc451.png','原料：猪肘棒',1,'2022-06-10 10:24:03','2022-06-10 10:24:03',1,1);
    80. INSERT INTO `dish` VALUES (60,'梅菜扣肉',18,58.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/6080b118-e30a-4577-aab4-45042e3f88be.png','原料：猪肉，梅菜',1,'2022-06-10 10:26:03','2022-06-10 10:26:03',1,1);
    81. INSERT INTO `dish` VALUES (61,'剁椒鱼头',18,66.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/13da832f-ef2c-484d-8370-5934a1045a06.png','原料：鲢鱼，剁椒',1,'2022-06-10 10:28:54','2022-06-10 10:28:54',1,1);
    82. INSERT INTO `dish` VALUES (62,'金汤酸菜牛蛙',17,88.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7694a5d8-7938-4e9d-8b9e-2075983a2e38.png','原料：鲜活牛蛙，酸菜',1,'2022-06-10 10:33:05','2022-06-10 10:33:05',1,1);
    83. INSERT INTO `dish` VALUES (63,'香锅牛蛙',17,88.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/f5ac8455-4793-450c-97ba-173795c34626.png','配料：鲜活牛蛙，莲藕，青笋',1,'2022-06-10 10:35:40','2022-06-10 10:35:40',1,1);
    84. INSERT INTO `dish` VALUES (64,'馋嘴牛蛙',17,88.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/7a55b845-1f2b-41fa-9486-76d187ee9ee1.png','配料：鲜活牛蛙，丝瓜，黄豆芽',1,'2022-06-10 10:37:52','2022-06-10 10:37:52',1,1);
    85. INSERT INTO `dish` VALUES (65,'草鱼2斤',16,68.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/b544d3ba-a1ae-4d20-a860-81cb5dec9e03.png','原料：草鱼，黄豆芽，莲藕',1,'2022-06-10 10:41:08','2022-06-10 10:41:08',1,1);
    86. INSERT INTO `dish` VALUES (66,'江团鱼2斤',16,119.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/a101a1e9-8f8b-47b2-afa4-1abd47ea0a87.png','配料：江团鱼，黄豆芽，莲藕',1,'2022-06-10 10:42:42','2022-06-10 10:42:42',1,1);
    87. INSERT INTO `dish` VALUES (67,'鮰鱼2斤',16,72.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/8cfcc576-4b66-4a09-ac68-ad5b273c2590.png','原料：鮰鱼，黄豆芽，莲藕',1,'2022-06-10 10:43:56','2022-06-10 10:43:56',1,1);
    88. INSERT INTO `dish` VALUES (68,'鸡蛋汤',21,4.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/c09a0ee8-9d19-428d-81b9-746221824113.png','配料：鸡蛋，紫菜',1,'2022-06-10 10:54:25','2022-06-10 10:54:25',1,1);
    89. INSERT INTO `dish` VALUES (69,'平菇豆腐汤',21,6.00,'https://sky-itcast.oss-cn-beijing.aliyuncs.com/16d0a3d6-2253-4cfc-9b49-bf7bd9eb2ad2.png','配料：豆腐，平菇',1,'2022-06-10 10:55:02','2022-06-10 10:55:02',1,1);
    90.  
    91. DROP TABLE IF EXISTS `dish_flavor`;
    92. CREATE TABLE `dish_flavor` (
    93.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    94.   `dish_id` bigint NOT NULL COMMENT '菜品',
    95.   `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '口味名称',
    96.   `value` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '口味数据list',
    97.   PRIMARY KEY (`id`)
    98. ) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='菜品口味关系表';
    99.  
    100. INSERT INTO `dish_flavor` VALUES (40,10,'甜味','[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
    101. INSERT INTO `dish_flavor` VALUES (41,7,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    102. INSERT INTO `dish_flavor` VALUES (42,7,'温度','[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]');
    103. INSERT INTO `dish_flavor` VALUES (45,6,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    104. INSERT INTO `dish_flavor` VALUES (46,6,'辣度','[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
    105. INSERT INTO `dish_flavor` VALUES (47,5,'辣度','[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
    106. INSERT INTO `dish_flavor` VALUES (48,5,'甜味','[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
    107. INSERT INTO `dish_flavor` VALUES (49,2,'甜味','[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
    108. INSERT INTO `dish_flavor` VALUES (50,4,'甜味','[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
    109. INSERT INTO `dish_flavor` VALUES (51,3,'甜味','[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]');
    110. INSERT INTO `dish_flavor` VALUES (52,3,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    111. INSERT INTO `dish_flavor` VALUES (86,52,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    112. INSERT INTO `dish_flavor` VALUES (87,52,'辣度','[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
    113. INSERT INTO `dish_flavor` VALUES (88,51,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    114. INSERT INTO `dish_flavor` VALUES (89,51,'辣度','[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
    115. INSERT INTO `dish_flavor` VALUES (92,53,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    116. INSERT INTO `dish_flavor` VALUES (93,53,'辣度','[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
    117. INSERT INTO `dish_flavor` VALUES (94,54,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\"]');
    118. INSERT INTO `dish_flavor` VALUES (95,56,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    119. INSERT INTO `dish_flavor` VALUES (96,57,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    120. INSERT INTO `dish_flavor` VALUES (97,60,'忌口','[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]');
    121. INSERT INTO `dish_flavor` VALUES (101,66,'辣度','[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
    122. INSERT INTO `dish_flavor` VALUES (102,67,'辣度','[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
    123. INSERT INTO `dish_flavor` VALUES (103,65,'辣度','[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]');
    124.  
    125. DROP TABLE IF EXISTS `employee`;
    126. CREATE TABLE `employee` (
    127.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    128.   `name` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '姓名',
    129.   `username` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '用户名',
    130.   `password` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '密码',
    131.   `phone` varchar(11) COLLATE utf8_bin NOT NULL COMMENT '手机号',
    132.   `sex` varchar(2) COLLATE utf8_bin NOT NULL COMMENT '性别',
    133.   `id_number` varchar(18) COLLATE utf8_bin NOT NULL COMMENT '身份证号',
    134.   `status` int NOT NULL DEFAULT '1' COMMENT '状态 0:禁用，1:启用',
    135.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    136.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    137.   `create_user` bigint DEFAULT NULL COMMENT '创建人',
    138.   `update_user` bigint DEFAULT NULL COMMENT '修改人',
    139.   PRIMARY KEY (`id`),
    140.   UNIQUE KEY `idx_username` (`username`)
    141. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='员工信息';
    142.  
    143. INSERT INTO `employee` VALUES (1,'管理员','admin','123456','13812312312','1','110101199001010047',1,'2022-02-15 15:51:20','2022-02-17 09:16:20',10,1);
    144.  
    145. DROP TABLE IF EXISTS `order_detail`;
    146. CREATE TABLE `order_detail` (
    147.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    148.   `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '名字',
    149.   `image` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '图片',
    150.   `order_id` bigint NOT NULL COMMENT '订单id',
    151.   `dish_id` bigint DEFAULT NULL COMMENT '菜品id',
    152.   `setmeal_id` bigint DEFAULT NULL COMMENT '套餐id',
    153.   `dish_flavor` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '口味',
    154.   `number` int NOT NULL DEFAULT '1' COMMENT '数量',
    155.   `amount` decimal(10,2) NOT NULL COMMENT '金额',
    156.   PRIMARY KEY (`id`)
    157. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='订单明细表';
    158.  
    159. DROP TABLE IF EXISTS `orders`;
    160. CREATE TABLE `orders` (
    161.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    162.   `number` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '订单号',
    163.   `status` int NOT NULL DEFAULT '1' COMMENT '订单状态 1待付款 2待接单 3已接单 4派送中 5已完成 6已取消 7退款',
    164.   `user_id` bigint NOT NULL COMMENT '下单用户',
    165.   `address_book_id` bigint NOT NULL COMMENT '地址id',
    166.   `order_time` datetime NOT NULL COMMENT '下单时间',
    167.   `checkout_time` datetime DEFAULT NULL COMMENT '结账时间',
    168.   `pay_method` int NOT NULL DEFAULT '1' COMMENT '支付方式 1微信,2支付宝',
    169.   `pay_status` tinyint NOT NULL DEFAULT '0' COMMENT '支付状态 0未支付 1已支付 2退款',
    170.   `amount` decimal(10,2) NOT NULL COMMENT '实收金额',
    171.   `remark` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
    172.   `phone` varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT '手机号',
    173.   `address` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '地址',
    174.   `user_name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '用户名称',
    175.   `consignee` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '收货人',
    176.   `cancel_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '订单取消原因',
    177.   `rejection_reason` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '订单拒绝原因',
    178.   `cancel_time` datetime DEFAULT NULL COMMENT '订单取消时间',
    179.   `estimated_delivery_time` datetime DEFAULT NULL COMMENT '预计送达时间',
    180.   `delivery_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '配送状态  1立即送出  0选择具体时间',
    181.   `delivery_time` datetime DEFAULT NULL COMMENT '送达时间',
    182.   `pack_amount` int DEFAULT NULL COMMENT '打包费',
    183.   `tableware_number` int DEFAULT NULL COMMENT '餐具数量',
    184.   `tableware_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '餐具数量状态  1按餐量提供  0选择具体数量',
    185.   PRIMARY KEY (`id`)
    186. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='订单表';
    187.  
    188. DROP TABLE IF EXISTS `setmeal`;
    189. CREATE TABLE `setmeal` (
    190.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    191.   `category_id` bigint NOT NULL COMMENT '菜品分类id',
    192.   `name` varchar(32) COLLATE utf8_bin NOT NULL COMMENT '套餐名称',
    193.   `price` decimal(10,2) NOT NULL COMMENT '套餐价格',
    194.   `status` int DEFAULT '1' COMMENT '售卖状态 0:停售 1:起售',
    195.   `description` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '描述信息',
    196.   `image` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '图片',
    197.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    198.   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    199.   `create_user` bigint DEFAULT NULL COMMENT '创建人',
    200.   `update_user` bigint DEFAULT NULL COMMENT '修改人',
    201.   PRIMARY KEY (`id`),
    202.   UNIQUE KEY `idx_setmeal_name` (`name`)
    203. ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='套餐';
    204.  
    205. DROP TABLE IF EXISTS `setmeal_dish`;
    206. CREATE TABLE `setmeal_dish` (
    207.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    208.   `setmeal_id` bigint DEFAULT NULL COMMENT '套餐id',
    209.   `dish_id` bigint DEFAULT NULL COMMENT '菜品id',
    210.   `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '菜品名称 （冗余字段）',
    211.   `price` decimal(10,2) DEFAULT NULL COMMENT '菜品单价（冗余字段）',
    212.   `copies` int DEFAULT NULL COMMENT '菜品份数',
    213.   PRIMARY KEY (`id`)
    214. ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='套餐菜品关系';
    215.  
    216. DROP TABLE IF EXISTS `shopping_cart`;
    217. CREATE TABLE `shopping_cart` (
    218.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    219.   `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '商品名称',
    220.   `image` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '图片',
    221.   `user_id` bigint NOT NULL COMMENT '主键',
    222.   `dish_id` bigint DEFAULT NULL COMMENT '菜品id',
    223.   `setmeal_id` bigint DEFAULT NULL COMMENT '套餐id',
    224.   `dish_flavor` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '口味',
    225.   `number` int NOT NULL DEFAULT '1' COMMENT '数量',
    226.   `amount` decimal(10,2) NOT NULL COMMENT '金额',
    227.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    228.   PRIMARY KEY (`id`)
    229. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='购物车';
    230.  
    231. DROP TABLE IF EXISTS `user`;
    232. CREATE TABLE `user` (
    233.   `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    234.   `openid` varchar(45) COLLATE utf8_bin DEFAULT NULL COMMENT '微信用户唯一标识',
    235.   `name` varchar(32) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
    236.   `phone` varchar(11) COLLATE utf8_bin DEFAULT NULL COMMENT '手机号',
    237.   `sex` varchar(2) COLLATE utf8_bin DEFAULT NULL COMMENT '性别',
    238.   `id_number` varchar(18) COLLATE utf8_bin DEFAULT NULL COMMENT '身份证号',
    239.   `avatar` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '头像',
    240.   `create_time` datetime DEFAULT NULL,
    241.   PRIMARY KEY (`id`)
    242. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin COMMENT='用户信息';

    前后端联调

    登录功能完善

    导入接口文档

     使用swagger

    和yapi的区别

    常用注解

  • 相关阅读:
    深入剖析 Python 最常用数据结构：列表(List) & 元组(Tuple)
    高版本Vivado和Linux 4.x内核移植Digilent Driver
    [附源码]java毕业设计学习教学辅助软件平台
    数据结构与算法复习：第三十三弹
    Discrete Optimization课程笔记(1)—Knapsack Problem
    我服了！SpringBoot升级后这服务我一个星期都没跑起来！（上）
    5G NSA添加辅小区问题
    一个 "开箱即用" 个人博客全栈系统项目！vue+node+express+mysql+sequlize+uniapp
    【C++高阶】3.2 vector容器
    Raft共识算法浅谈
  • 原文地址：https://blog.csdn.net/TheresaApocaly/article/details/133099189