代码拉取完成，页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : 本地
Source Server Type : MySQL
Source Server Version : 80030
Source Host : localhost:3306
Source Schema : reggie
Target Server Type : MySQL
Target Server Version : 80030
File Encoding : 65001
Date: 17/01/2023 19:23:59
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for address_book
-- ----------------------------
DROP TABLE IF EXISTS `address_book`;
CREATE TABLE `address_book` (
`id` bigint NOT NULL COMMENT '主键',
`user_id` bigint NOT NULL COMMENT '用户id',
`consignee` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '收货人',
`sex` tinyint NOT NULL COMMENT '性别 0 女 1 男',
`phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '手机号',
`province_code` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '省级区划编号',
`province_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '省级名称',
`city_code` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '市级区划编号',
`city_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '市级名称',
`district_code` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '区级区划编号',
`district_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '区级名称',
`detail` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '详细地址',
`label` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '标签',
`is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '默认 0 否 1是',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_user` bigint NOT NULL COMMENT '创建人',
`update_user` bigint NOT NULL COMMENT '修改人',
`is_deleted` int NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '地址管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of address_book
-- ----------------------------
INSERT INTO `address_book` VALUES (1417414526093082626, 1417012167126876162, '小明', 1, '13812345678', NULL, NULL, NULL, NULL, NULL, NULL, '昌平区金燕龙办公楼', '公司', 1, '2021-07-20 17:22:12', '2021-07-20 17:26:33', 1417012167126876162, 1417012167126876162, 0);
INSERT INTO `address_book` VALUES (1417414926166769666, 1417012167126876162, '小李', 1, '13512345678', NULL, NULL, NULL, NULL, NULL, NULL, '测试', '家', 0, '2021-07-20 17:23:47', '2021-07-20 17:23:47', 1417012167126876162, 1417012167126876162, 0);
INSERT INTO `address_book` VALUES (1562721341934358529, 1562498296405762050, '聂家辉', 1, '18875115454', NULL, NULL, NULL, NULL, NULL, NULL, '温州大学', '公司', 1, '2022-08-25 16:39:37', '2022-08-25 16:39:38', 1562498296405762050, 1562498296405762050, 0);
INSERT INTO `address_book` VALUES (1562785204771958786, 1562476453301010434, '聂先生', 1, '18802045416', NULL, NULL, NULL, NULL, NULL, NULL, '温州大学', '学校', 1, '2022-08-25 20:53:23', '2022-08-28 18:19:12', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `address_book` VALUES (1565737386689880065, 1565737241424355329, '凌', 1, '15828712346', NULL, NULL, NULL, NULL, NULL, NULL, '温州大学A区', '公司', 1, '2022-09-03 00:24:18', '2022-09-03 00:24:19', 1565737241424355329, 1565737241424355329, 0);
INSERT INTO `address_book` VALUES (1569501713607614466, 1569501470983905281, 'Dingjun Li', 1, '18512341234', NULL, NULL, NULL, NULL, NULL, NULL, '0xFD52B0B3080D896E611610e6D0a36195d4554E5F', '公司', 0, '2022-09-13 09:42:23', '2022-09-13 09:42:23', 1569501470983905281, 1569501470983905281, 0);
INSERT INTO `address_book` VALUES (1576824849252466690, 1576824700656664577, '1', 1, '17822342323', NULL, NULL, NULL, NULL, NULL, NULL, '1111', '公司', 1, '2022-10-03 14:41:55', '2022-10-03 14:41:57', 1576824700656664577, 1576824700656664577, 0);
INSERT INTO `address_book` VALUES (1577264241850957825, 1576825229428375554, '吴明', 1, '18263739247', NULL, NULL, NULL, NULL, NULL, NULL, '科大讯飞', '公司', 1, '2022-10-04 19:47:54', '2022-10-04 19:47:56', 1576825229428375554, 1576825229428375554, 0);
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` bigint NOT NULL COMMENT '主键',
`type` int NULL DEFAULT NULL COMMENT '类型 1 菜品分类 2 套餐分类',
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '分类名称',
`sort` int NOT NULL DEFAULT 0 COMMENT '顺序',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_user` bigint NOT NULL COMMENT '创建人',
`update_user` bigint NOT NULL COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_category_name`(`name` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '菜品及套餐分类' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (1397844263642378242, 1, '湘菜', 4, '2021-05-27 09:16:58', '2022-08-30 01:01:18', 1, 1);
INSERT INTO `category` VALUES (1397844303408574465, 1, '川菜', 2, '2021-05-27 09:17:07', '2021-06-02 14:27:22', 1, 1);
INSERT INTO `category` VALUES (1397844391040167938, 1, '粤菜', 3, '2021-05-27 09:17:28', '2021-07-09 14:37:13', 1, 1);
INSERT INTO `category` VALUES (1413341197421846529, 1, '饮品', 11, '2021-07-09 11:36:15', '2021-07-09 14:39:15', 1, 1);
INSERT INTO `category` VALUES (1413384954989060097, 1, '主食', 12, '2021-07-09 14:30:07', '2021-07-09 14:39:19', 1, 1);
INSERT INTO `category` VALUES (1413386191767674881, 2, '儿童套餐', 6, '2021-07-09 14:35:02', '2021-07-09 14:39:05', 1, 1);
INSERT INTO `category` VALUES (1559869439295086593, 1, '小孩那桌', 10, '2022-08-17 19:47:10', '2022-08-17 19:47:48', 1559869023027191810, 1559869023027191810);
INSERT INTO `category` VALUES (1559870841425747969, 1, '大人那桌', 9, '2022-08-17 19:52:44', '2022-08-17 19:52:44', 1, 1);
INSERT INTO `category` VALUES (1564297565165490177, 1, '项目说明', 1, '2022-08-30 01:02:57', '2022-08-30 01:02:57', 1, 1);
INSERT INTO `category` VALUES (1578306915291680769, 2, '美女合集', 5, '2022-10-07 16:51:07', '2022-10-07 16:51:07', 1562476453301010434, 1562476453301010434);
-- ----------------------------
-- Table structure for dish
-- ----------------------------
DROP TABLE IF EXISTS `dish`;
CREATE TABLE `dish` (
`id` bigint NOT NULL COMMENT '主键',
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '菜品名称',
`category_id` bigint NOT NULL COMMENT '菜品分类id',
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '菜品价格',
`code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '商品码',
`image` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '图片',
`description` varchar(400) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '描述信息',
`status` int NOT NULL DEFAULT 1 COMMENT '0 停售 1 起售',
`sale_num` int NOT NULL COMMENT '销量',
`sort` int NOT NULL DEFAULT 0 COMMENT '顺序',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_user` bigint NOT NULL COMMENT '创建人',
`update_user` bigint NOT NULL COMMENT '修改人',
`is_deleted` int NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_dish_name`(`name` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '菜品管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of dish
-- ----------------------------
INSERT INTO `dish` VALUES (1397849739276890114, '辣子鸡', 1397844263642378242, 7800.00, '222222222', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', '来自鲜嫩美味的小鸡，值得一尝', 1, 1, 0, '2021-05-27 09:38:43', '2022-08-22 16:27:18', 1, 1, 0);
INSERT INTO `dish` VALUES (1397850140982161409, '毛氏红烧肉', 1397844263642378242, 6800.00, '123412341234', '0a3b3288-3446-4420-bbff-f263d0c02d8e.jpg', '毛氏红烧肉毛氏红烧肉，确定不来一份？', 1, 14, 0, '2021-05-27 09:40:19', '2022-10-21 16:39:59', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1397850392090947585, '组庵鱼翅', 1397844263642378242, 4800.00, '123412341234', '740c79ce-af29-41b8-b78d-5f49c96e38c4.jpg', '组庵鱼翅，看图足以表明好吃程度', 1, 0, 0, '2021-05-27 09:41:19', '2022-08-22 16:27:18', 1, 1, 0);
INSERT INTO `dish` VALUES (1397850851245600769, '霸王别姬', 1397844263642378242, 12800.00, '123412341234', '057dd338-e487-4bbc-a74c-0384c44a9ca3.jpg', '还有什么比霸王别姬更美味的呢？', 1, 0, 0, '2021-05-27 09:43:08', '2022-08-22 16:27:18', 1, 1, 0);
INSERT INTO `dish` VALUES (1397851099502260226, '全家福', 1397844263642378242, 11800.00, '23412341234', 'a53a4e6a-3b83-4044-87f9-9d49b30a8fdc.jpg', '别光吃肉啦，来份全家福吧，让你长寿又美味', 1, 0, 0, '2021-05-27 09:44:08', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397851370462687234, '邵阳猪血丸子', 1397844263642378242, 13800.00, '1246812345678', '2a50628e-7758-4c51-9fbb-d37c61cdacad.jpg', '看，美味不？来嘛来嘛，这才是最爱吖', 1, 0, 0, '2021-05-27 09:45:12', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397851668262465537, '口味蛇', 1397844263642378242, 16800.00, '1234567812345678', '0f4bd884-dc9c-4cf9-b59e-7d5958fec3dd.jpg', '爬行界的扛把子，东兴-口味蛇，让你欲罢不能', 1, 0, 0, '2021-05-27 09:46:23', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397852391150759938, '辣子鸡丁', 1397844303408574465, 8800.00, '2346812468', 'ef2b73f2-75d1-4d3a-beea-22da0e1421bd.jpg', '辣子鸡丁，辣子鸡丁，永远的魂', 1, 0, 0, '2021-05-27 09:49:16', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397853183287013378, '麻辣兔头', 1397844303408574465, 19800.00, '123456787654321', '2a2e9d66-b41d-4645-87bd-95f2cfeed218.jpg', '麻辣兔头的详细制作，麻辣鲜香，色泽红润，回味悠长', 1, 0, 0, '2021-05-27 09:52:24', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397853709101740034, '蒜泥白肉', 1397844303408574465, 9800.00, '1234321234321', 'd2f61d70-ac85-4529-9b74-6d9a2255c6d7.jpg', '多么的有食欲啊', 1, 0, 0, '2021-05-27 09:54:30', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397853890262118402, '鱼香肉丝', 1397844303408574465, 3800.00, '1234212321234', '8dcfda14-5712-4d28-82f7-ae905b3c2308.jpg', '鱼香肉丝简直就是我们童年回忆的一道经典菜，上学的时候点个鱼香肉丝盖饭坐在宿舍床上看着肥皂剧，绝了！现在完美复刻一下上学的时候感觉', 1, 0, 0, '2021-05-27 09:55:13', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397854652581064706, '麻辣水煮鱼', 1397844303408574465, 14800.00, '2345312·345321', '1fdbfbf3-1d86-4b29-a3fc-46345852f2f8.jpg', '鱼片是买的切好的鱼片，放几个虾，增加味道', 1, 0, 0, '2021-05-27 09:58:15', '2022-08-25 20:41:10', 1, 1, 0);
INSERT INTO `dish` VALUES (1397854865672679425, '鱼香炒鸡蛋', 1397844303408574465, 2000.00, '23456431·23456', '0f252364-a561-4e8d-8065-9a6797a6b1d3.jpg', '鱼香菜也是川味的特色。里面没有鱼却鱼香味', 1, 0, 0, '2021-05-27 09:59:06', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397860242057375745, '脆皮烧鹅', 1397844391040167938, 12800.00, '123456786543213456', 'e476f679-5c15-436b-87fa-8c4e9644bf33.jpeg', '“广东烤鸭美而香，却胜烧鹅说古冈（今新会），燕瘦环肥各佳妙，君休偏重便宜坊”，可见烧鹅与烧鸭在粤菜之中已早负盛名。作为广州最普遍和最受欢迎的烧烤肉食，以它的“色泽金红，皮脆肉嫩，味香可口”的特色，在省城各大街小巷的烧卤店随处可见。', 1, 0, 0, '2021-05-27 10:20:27', '2022-08-22 16:27:13', 1, 1, 0);
INSERT INTO `dish` VALUES (1397860578738352129, '白切鸡', 1397844391040167938, 6600.00, '12345678654', '9ec6fc2d-50d2-422e-b954-de87dcd04198.jpeg', '白切鸡是一道色香味俱全的特色传统名肴，又叫白斩鸡，是粤菜系鸡肴中的一种，始于清代的民间。白切鸡通常选用细骨农家鸡与沙姜、蒜茸等食材，慢火煮浸白切鸡皮爽肉滑，清淡鲜美。著名的泮溪酒家白切鸡，曾获商业部优质产品金鼎奖。湛江白切鸡更是驰名粤港澳。粤菜厨坛中，鸡的菜式有200余款之多，而最为人常食不厌的正是白切鸡，深受食家青睐。', 1, 10, 0, '2021-05-27 10:21:48', '2022-10-21 16:39:59', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1397860792492666881, '烤乳猪', 1397844391040167938, 38800.00, '213456432123456', '2e96a7e3-affb-438e-b7c3-e1430df425c9.jpeg', '广式烧乳猪主料是小乳猪，辅料是蒜，调料是五香粉、芝麻酱、八角粉等，本菜品主要通过将食材放入炭火中烧烤而成。烤乳猪是广州最著名的特色菜，并且是“满汉全席”中的主打菜肴之一。烤乳猪也是许多年来广东人祭祖的祭品之一，是家家都少不了的应节之物，用乳猪祭完先人后，亲戚们再聚餐食用。', 1, 9, 0, '2021-05-27 10:22:39', '2022-10-21 16:39:59', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1397860963880316929, '脆皮乳鸽', 1397844391040167938, 10800.00, '1234563212345', '3fabb83a-1c09-4fd9-892b-4ef7457daafa.jpeg', '“脆皮乳鸽”是广东菜中的一道传统名菜，属于粤菜系，具有皮脆肉嫩、色泽红亮、鲜香味美的特点，常吃可使身体强健，清肺顺气。随着菜品制作工艺的不断发展，逐渐形成了熟炸法、生炸法和烤制法三种制作方法。无论那种制作方法，都是在鸽子经过一系列的加工，挂脆皮水后再加工而成，正宗的“脆皮乳鸽皮脆肉嫩、色泽红亮、鲜香味美、香气馥郁。这三种方法的制作过程都不算复杂，但想达到理想的效果并不容易。', 1, 0, 0, '2021-05-27 10:23:19', '2022-08-22 16:27:06', 1, 1, 0);
INSERT INTO `dish` VALUES (1397861683434139649, '清蒸河鲜海鲜', 1397844391040167938, 38800.00, '1234567876543213456', '1405081e-f545-42e1-86a2-f7559ae2e276.jpeg', '新鲜的海鲜，清蒸是最好的处理方式。鲜，体会为什么叫海鲜。清蒸是广州最经典的烹饪手法，过去岭南地区由于峻山大岭阻隔，交通不便，经济发展起步慢，自家打的鱼放在锅里煮了就吃，没有太多的讲究，但却发现这清淡的煮法能使鱼的鲜甜跃然舌尖。', 1, 0, 0, '2021-05-27 10:26:11', '2022-08-22 16:27:06', 1, 1, 0);
INSERT INTO `dish` VALUES (1397862198033297410, '老火靓汤', 1397844391040167938, 49800.00, '123456786532455', '583df4b7-a159-4cfc-9543-4f666120b25f.jpeg', '老火靓汤又称广府汤，是广府人传承数千年的食补养生秘方，慢火煲煮的中华老火靓汤，火候足，时间长，既取药补之效，又取入口之甘甜。 广府老火汤种类繁多，可以用各种汤料和烹调方法，烹制出各种不同口味、不同功效的汤来。', 1, 0, 0, '2021-05-27 10:28:14', '2022-08-22 16:27:06', 1, 1, 0);
INSERT INTO `dish` VALUES (1397862477831122945, '上汤焗龙虾', 1397844391040167938, 108800.00, '1234567865432', '5b8d2da3-3744-4bb3-acdc-329056b8259d.jpeg', '上汤焗龙虾是一道色香味俱全的传统名菜，属于粤菜系。此菜以龙虾为主料，配以高汤制成的一道海鲜美食。本品肉质洁白细嫩，味道鲜美，蛋白质含量高，脂肪含量低，营养丰富。是色香味俱全的传统名菜。', 1, 0, 0, '2021-05-27 10:29:20', '2022-08-22 16:27:06', 1, 1, 0);
INSERT INTO `dish` VALUES (1413342036832100354, '北冰洋', 1413341197421846529, 500.00, '', 'c99e0aab-3cb7-4eaa-80fd-f47d4ffea694.png', '', 1, 0, 0, '2021-07-09 11:39:35', '2022-08-22 16:27:06', 1, 1, 0);
INSERT INTO `dish` VALUES (1413385247889891330, '米饭', 1413384954989060097, 200.00, '', 'ee04a05a-1230-46b6-8ad5-1a95b140fff3.png', '', 1, 4, 0, '2021-07-09 14:31:17', '2022-10-21 16:39:59', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1561629106362834946, '王老吉', 1413341197421846529, 3500.00, '', '2baf07ed-bda2-49df-91f3-a703f8198140.png', '怕上火就喝王老吉', 1, 6, 0, '2022-08-22 16:19:27', '2022-10-21 16:39:59', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1564296152125444098, '美女一号', 1559870841425747969, 124500.00, '', '754ddb4a-4d05-42cd-8884-7aa0c75d0267.jpg', '清纯可爱', 1, 7, 0, '2022-08-30 00:57:21', '2022-10-21 16:39:59', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1564296282002067457, '美女二号', 1559870841425747969, 52000.00, '', '14203701-ab0f-4856-80fb-38a624989435.jpg', '', 1, 13, 0, '2022-08-30 00:57:52', '2022-10-28 22:24:09', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1564296465360261122, '美女三号', 1559870841425747969, 54600.00, '', '962a8778-6846-4296-bc58-169aa333b67e.jpg', '国外小姐姐', 1, 6, 0, '2022-08-30 00:58:35', '2022-10-21 16:39:59', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1564296621379981314, '美女四号', 1559870841425747969, 363600.00, '', 'd96bb4ea-6555-41b0-924e-99dc38019af3.jpg', '', 1, 8, 0, '2022-08-30 00:59:12', '2022-10-21 16:39:59', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1564296751818641409, '温州大学', 1559869439295086593, 235600.00, '', '2b0c8aba-7526-4e89-ad27-d56f92f83bb1.png', '', 1, 0, 0, '2022-08-30 00:59:44', '2022-10-07 16:44:47', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1564299172041101313, '聂家辉开源项目', 1564297565165490177, 848400.00, '', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', '本项目基于springboot框架,mybatisplus持久层框架,NoSQL的redis缓存技术,以及mysql的主从复制优化,sping-cache缓存框架，前端采用nginx反向代理.项目后台管理端:wzunjh.top 项目已在gitee开源,有兴趣可访问:gitee.com/wzunjh/reggie ', 1, 30, 0, '2022-08-30 01:09:21', '2022-10-28 23:23:27', 1, 1562476453301010434, 0);
INSERT INTO `dish` VALUES (1582283843585474561, '文件测试', 1564297565165490177, 808800.00, '', '28adbbc0-9154-4877-be40-21693efcf871.jpg', '文件上传测试', 1, 18, 0, '2022-10-18 16:14:00', '2022-10-22 00:36:13', 1, 1562476453301010434, 0);
-- ----------------------------
-- Table structure for dish_flavor
-- ----------------------------
DROP TABLE IF EXISTS `dish_flavor`;
CREATE TABLE `dish_flavor` (
`id` bigint NOT NULL COMMENT '主键',
`dish_id` bigint NOT NULL COMMENT '菜品',
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '口味名称',
`value` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '口味数据list',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_user` bigint NOT NULL COMMENT '创建人',
`update_user` bigint NOT NULL COMMENT '修改人',
`is_deleted` int NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '菜品口味关系表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of dish_flavor
-- ----------------------------
INSERT INTO `dish_flavor` VALUES (1397849417888346113, 1397849417854791681, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:37:27', '2021-05-27 09:37:27', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397849739297861633, 1397849739276890114, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:38:43', '2021-05-27 09:38:43', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397849739323027458, 1397849739276890114, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:38:43', '2021-05-27 09:38:43', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397849936421761025, 1397849936404983809, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:39:30', '2021-05-27 09:39:30', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397849936438538241, 1397849936404983809, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:39:30', '2021-05-27 09:39:30', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397850141015715841, 1397850140982161409, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:40:19', '2021-05-27 09:40:19', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397850141040881665, 1397850140982161409, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:40:19', '2021-05-27 09:40:19', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397850392120307713, 1397850392090947585, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:41:19', '2021-05-27 09:41:19', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397850392137084929, 1397850392090947585, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:41:19', '2021-05-27 09:41:19', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397850630734262274, 1397850630700707841, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:42:16', '2021-05-27 09:42:16', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397850630755233794, 1397850630700707841, '辣度', '[\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:42:16', '2021-05-27 09:42:16', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397850851274960898, 1397850851245600769, '忌口', '[\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:43:08', '2021-05-27 09:43:08', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397850851283349505, 1397850851245600769, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:43:08', '2021-05-27 09:43:08', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397851099523231745, 1397851099502260226, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:44:08', '2021-05-27 09:44:08', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397851099527426050, 1397851099502260226, '辣度', '[\"不辣\",\"微辣\",\"中辣\"]', '2021-05-27 09:44:08', '2021-05-27 09:44:08', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397851370483658754, 1397851370462687234, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2021-05-27 09:45:12', '2021-05-27 09:45:12', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397851370483658755, 1397851370462687234, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:45:12', '2021-05-27 09:45:12', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397851370483658756, 1397851370462687234, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:45:12', '2021-05-27 09:45:12', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397851668283437058, 1397851668262465537, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2021-05-27 09:46:23', '2021-05-27 09:46:23', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397852391180120065, 1397852391150759938, '忌口', '[\"不要葱\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:49:16', '2021-05-27 09:49:16', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397852391196897281, 1397852391150759938, '辣度', '[\"不辣\",\"微辣\",\"重辣\"]', '2021-05-27 09:49:16', '2021-05-27 09:49:16', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397853183307984898, 1397853183287013378, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:52:24', '2021-05-27 09:52:24', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397853423486414850, 1397853423461249026, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:53:22', '2021-05-27 09:53:22', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397853709126905857, 1397853709101740034, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:54:30', '2021-05-27 09:54:30', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397853890283089922, 1397853890262118402, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:55:13', '2021-05-27 09:55:13', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397854133632413697, 1397854133603053569, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2021-05-27 09:56:11', '2021-05-27 09:56:11', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397854652623007745, 1397854652581064706, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 09:58:15', '2021-05-27 09:58:15', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397854652635590658, 1397854652581064706, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:58:15', '2021-05-27 09:58:15', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397854865735593986, 1397854865672679425, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 09:59:06', '2021-05-27 09:59:06', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397855742303186946, 1397855742273826817, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 10:02:35', '2021-05-27 10:02:35', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397855906497605633, 1397855906468245506, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 10:03:14', '2021-05-27 10:03:14', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397856190573621250, 1397856190540066818, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 10:04:21', '2021-05-27 10:04:21', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397859056709316609, 1397859056684150785, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 10:15:45', '2021-05-27 10:15:45', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397859277837217794, 1397859277812051969, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 10:16:37', '2021-05-27 10:16:37', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397859487502086146, 1397859487476920321, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 10:17:27', '2021-05-27 10:17:27', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397859757061615618, 1397859757036449794, '甜味', '[\"无糖\",\"少糖\",\"半躺\",\"多糖\",\"全糖\"]', '2021-05-27 10:18:32', '2021-05-27 10:18:32', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397860242086735874, 1397860242057375745, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 10:20:27', '2021-05-27 10:20:27', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397860963918065665, 1397860963880316929, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 10:23:19', '2021-05-27 10:23:19', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397861135754506242, 1397861135733534722, '甜味', '[\"无糖\",\"少糖\",\"半躺\",\"多糖\",\"全糖\"]', '2021-05-27 10:24:00', '2021-05-27 10:24:00', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397861370035744769, 1397861370010578945, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-27 10:24:56', '2021-05-27 10:24:56', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397861683459305474, 1397861683434139649, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 10:26:11', '2021-05-27 10:26:11', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397861898467717121, 1397861898438356993, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 10:27:02', '2021-05-27 10:27:02', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397862198054268929, 1397862198033297410, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-27 10:28:14', '2021-05-27 10:28:14', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1397862477835317250, 1397862477831122945, '辣度', '[\"不辣\",\"微辣\",\"中辣\"]', '2021-05-27 10:29:20', '2021-05-27 10:29:20', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398089545865015297, 1398089545676271617, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2021-05-28 01:31:38', '2021-05-28 01:31:38', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398089782323097601, 1398089782285348866, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:32:34', '2021-05-28 01:32:34', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398090003262255106, 1398090003228700673, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-28 01:33:27', '2021-05-28 01:33:27', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398090264554811394, 1398090264517062657, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-28 01:34:29', '2021-05-28 01:34:29', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398090455399837698, 1398090455324340225, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:35:14', '2021-05-28 01:35:14', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398090685449023490, 1398090685419663362, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2021-05-28 01:36:09', '2021-05-28 01:36:09', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398090825358422017, 1398090825329061889, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-28 01:36:43', '2021-05-28 01:36:43', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398091007051476993, 1398091007017922561, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:37:26', '2021-05-28 01:37:26', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398091296164851713, 1398091296131297281, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:38:35', '2021-05-28 01:38:35', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398091546531246081, 1398091546480914433, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2021-05-28 01:39:35', '2021-05-28 01:39:35', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398091729809747969, 1398091729788776450, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:40:18', '2021-05-28 01:40:18', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398091889499484161, 1398091889449152513, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:40:56', '2021-05-28 01:40:56', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398092095179763713, 1398092095142014978, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:41:45', '2021-05-28 01:41:45', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398092283877306370, 1398092283847946241, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:42:30', '2021-05-28 01:42:30', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398094018939236354, 1398094018893099009, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:49:24', '2021-05-28 01:49:24', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1398094391494094850, 1398094391456346113, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2021-05-28 01:50:53', '2021-05-28 01:50:53', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1413389540592263169, 1413384757047271425, '温度', '[\"常温\",\"冷藏\"]', '2021-07-12 09:09:16', '2021-07-12 09:09:16', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1413389684020682754, 1413342036832100354, '温度', '[\"常温\",\"冷藏\"]', '2021-07-09 15:12:18', '2021-07-09 15:12:18', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1559971257681416193, 1559971257668833281, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2022-08-22 16:07:46', '2022-08-22 16:07:46', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1560196283760295938, 1559971257668833281, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]', '2022-08-22 16:07:46', '2022-08-22 16:07:46', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1561272965577535490, 1561272965577535489, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]', '2022-08-22 16:07:54', '2022-08-22 16:07:54', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1561272965577535491, 1561272965577535489, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2022-08-22 16:07:54', '2022-08-22 16:07:54', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1562769815988035587, 1562769815988035586, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]', '2022-08-25 19:52:14', '2022-08-25 19:52:14', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1562786230040252418, 1562786230010892290, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2022-08-25 20:57:27', '2022-08-25 20:57:27', 1, 1, 0);
INSERT INTO `dish_flavor` VALUES (1564296152150609922, 1564296152125444098, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2022-10-07 16:45:27', '2022-10-07 16:45:27', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `dish_flavor` VALUES (1564296152150609923, 1564296152125444098, '辣度', '[\"不辣\",\"微辣\",\"中辣\",\"重辣\"]', '2022-10-07 16:45:27', '2022-10-07 16:45:27', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `dish_flavor` VALUES (1564296282031427585, 1564296282002067457, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2022-10-07 16:45:19', '2022-10-07 16:45:19', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `dish_flavor` VALUES (1564296282031427586, 1564296282002067457, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]', '2022-10-07 16:45:19', '2022-10-07 16:45:19', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `dish_flavor` VALUES (1564296465381232641, 1564296465360261122, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2022-10-07 16:45:11', '2022-10-07 16:45:11', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `dish_flavor` VALUES (1564296621379981315, 1564296621379981314, '温度', '[\"热饮\",\"常温\",\"去冰\",\"少冰\",\"多冰\"]', '2022-10-07 16:45:01', '2022-10-07 16:45:01', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `dish_flavor` VALUES (1564296621379981316, 1564296621379981314, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]', '2022-10-07 16:45:01', '2022-10-07 16:45:01', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `dish_flavor` VALUES (1564296751839612930, 1564296751818641409, '忌口', '[\"不要葱\",\"不要蒜\",\"不要香菜\",\"不要辣\"]', '2022-10-07 16:44:47', '2022-10-07 16:44:47', 1562476453301010434, 1562476453301010434, 0);
INSERT INTO `dish_flavor` VALUES (1582283843585474562, 1582283843585474561, '甜味', '[\"无糖\",\"少糖\",\"半糖\",\"多糖\",\"全糖\"]', '2022-10-18 16:14:00', '2022-10-18 16:14:00', 1, 1, 0);
-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
`id` bigint NOT NULL COMMENT '主键',
`name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '姓名',
`username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '用户名',
`password` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '密码',
`phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '手机号',
`sex` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '性别',
`id_number` varchar(18) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '身份证号',
`status` int NOT NULL DEFAULT 1 COMMENT '状态 0:禁用，1:正常',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_user` bigint NOT NULL COMMENT '创建人',
`update_user` bigint NOT NULL COMMENT '修改人',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_username`(`username` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '员工信息' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES (1, '管理员', 'admin', 'c0dfa77b96882d073294535120aa07ac', '13812312312', '1', '110101199001010047', 1, '2021-05-06 17:20:07', '2021-05-10 02:24:09', 1, 1);
INSERT INTO `employee` VALUES (1559869023027191810, '聂家辉', 'njh', 'c0dfa77b96882d073294535120aa07ac', '18873882688', '1', '245784626266236585', 1, '2022-08-17 19:45:31', '2022-08-17 19:45:31', 1, 1);
INSERT INTO `employee` VALUES (1559869193273991169, '凌浩晨', 'lhc', 'c0dfa77b96882d073294535120aa07ac', '18856561122', '1', '435215875556226', 1, '2022-08-17 19:46:11', '2022-08-25 19:48:18', 1, 1);
-- ----------------------------
-- Table structure for order_detail
-- ----------------------------
DROP TABLE IF EXISTS `order_detail`;
CREATE TABLE `order_detail` (
`id` bigint NOT NULL COMMENT '主键',
`name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '名字',
`image` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '图片',
`order_id` bigint NOT NULL COMMENT '订单id',
`dish_id` bigint NULL DEFAULT NULL COMMENT '菜品id',
`setmeal_id` bigint NULL DEFAULT NULL COMMENT '套餐id',
`dish_flavor` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '口味',
`number` int NOT NULL DEFAULT 1 COMMENT '数量',
`amount` decimal(10, 2) NOT NULL COMMENT '金额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '订单明细表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of order_detail
-- ----------------------------
INSERT INTO `order_detail` VALUES (1562749000156422145, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562749000089313281, 1397849739276890114, NULL, '不要葱,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562749000156422146, '全家福', 'a53a4e6a-3b83-4044-87f9-9d49b30a8fdc.jpg', 1562749000089313281, 1397851099502260226, NULL, '不要葱,微辣', 1, 118.00);
INSERT INTO `order_detail` VALUES (1562749000156422147, '家辉', 'f96a7a30-fc5a-4ed6-9ee6-e3cab8ee07dd.jpg', 1562749000089313281, 1559971257668833281, NULL, '去冰,半糖', 1, 230.00);
INSERT INTO `order_detail` VALUES (1562757943733719041, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562757943666610177, 1397849739276890114, NULL, '不要辣,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562760577693757443, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562760577693757442, 1397849739276890114, NULL, '不要辣,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562760577739894786, '组庵鱼翅', '740c79ce-af29-41b8-b78d-5f49c96e38c4.jpg', 1562760577693757442, 1397850392090947585, NULL, '不辣,微辣', 2, 48.00);
INSERT INTO `order_detail` VALUES (1562760781843116035, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562760781843116034, 1397849739276890114, NULL, '不要葱,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562785228910178306, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562785228843069442, 1397849739276890114, NULL, '不要辣,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562785366537875458, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562785366537875457, 1397849739276890114, NULL, '不要辣,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562815265411665923, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562815265411665922, 1397849739276890114, NULL, '不要蒜,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562815534274940930, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562815534207832066, 1397849739276890114, NULL, '不要辣,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562815534274940931, '组庵鱼翅', '740c79ce-af29-41b8-b78d-5f49c96e38c4.jpg', 1562815534207832066, 1397850392090947585, NULL, '微辣,微辣', 1, 48.00);
INSERT INTO `order_detail` VALUES (1562817440586047489, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562817440518938626, 1397849739276890114, NULL, '不要蒜,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562817553706426370, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562817553706426369, 1397849739276890114, NULL, '不要蒜,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562818924614721538, '邵阳猪血丸子', '2a50628e-7758-4c51-9fbb-d37c61cdacad.jpg', 1562818924614721537, 1397851370462687234, NULL, '多冰,不要辣,微辣', 1, 138.00);
INSERT INTO `order_detail` VALUES (1562818924614721539, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562818924614721537, 1397849739276890114, NULL, '不要蒜,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562819124670439426, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562819124670439425, 1397849739276890114, NULL, '不要辣,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1562819124670439427, '全家福', 'a53a4e6a-3b83-4044-87f9-9d49b30a8fdc.jpg', 1562819124670439425, 1397851099502260226, NULL, '不要辣,微辣', 1, 118.00);
INSERT INTO `order_detail` VALUES (1562819124670439428, '麻辣水煮鱼', '1fdbfbf3-1d86-4b29-a3fc-46345852f2f8.jpg', 1562819124670439425, 1397854652581064706, NULL, '不要蒜,微辣', 1, 148.00);
INSERT INTO `order_detail` VALUES (1562840539373146114, '辣子鸡', 'f966a38e-0780-40be-bb52-5699d13cb3d9.jpg', 1562840539306037250, 1397849739276890114, NULL, '不要香菜,微辣', 1, 78.00);
INSERT INTO `order_detail` VALUES (1564302999251226626, '鱼香炒鸡蛋', '0f252364-a561-4e8d-8065-9a6797a6b1d3.jpg', 1564302999188312066, 1397854865672679425, NULL, '不辣', 1, 20.00);
INSERT INTO `order_detail` VALUES (1576948194790850561, '美女四号', 'd4615106-eae4-4a1c-8ff8-e2fb8a827581.jpg', 1576948194551775233, 1564296621379981314, NULL, '少冰,多糖', 1, 3636.00);
INSERT INTO `order_detail` VALUES (1576948194816016386, '美女三号', '7c46af01-4ab2-4040-9cb1-92dc46f0b1c9.jpg', 1576948194551775233, 1564296465360261122, NULL, '不要香菜', 1, 546.00);
INSERT INTO `order_detail` VALUES (1576948194816016387, '美女二号', '1c6b2110-cf1e-413e-8a3a-42988d09537e.jpg', 1576948194551775233, 1564296282002067457, NULL, '少冰,多糖', 1, 520.00);
INSERT INTO `order_detail` VALUES (1576948194816016388, '美女一号', 'afc5803d-b19c-4b5c-a6de-c74170147bd7.jpg', 1576948194551775233, 1564296152125444098, NULL, '不要蒜,重辣', 1, 1245.00);
INSERT INTO `order_detail` VALUES (1577264272259661825, '鱼香炒鸡蛋', '0f252364-a561-4e8d-8065-9a6797a6b1d3.jpg', 1577264272242884609, 1397854865672679425, NULL, '微辣', 1, 20.00);
INSERT INTO `order_detail` VALUES (1577264272259661826, '白切鸡', '9ec6fc2d-50d2-422e-b954-de87dcd04198.jpeg', 1577264272242884609, 1397860578738352129, NULL, NULL, 1, 66.00);
INSERT INTO `order_detail` VALUES (1577617888229179394, '米饭', 'ee04a05a-1230-46b6-8ad5-1a95b140fff3.png', 1577617888220790786, 1413385247889891330, NULL, NULL, 1, 2.00);
INSERT INTO `order_detail` VALUES (1577617888229179395, '王老吉', '2baf07ed-bda2-49df-91f3-a703f8198140.png', 1577617888220790786, 1561629106362834946, NULL, NULL, 1, 35.00);
INSERT INTO `order_detail` VALUES (1577617888229179396, '温州大学', '46241517-a0ba-40ef-afd6-7b9fba5072e3.png', 1577617888220790786, 1564296751818641409, NULL, '不要香菜', 1, 2356.00);
INSERT INTO `order_detail` VALUES (1578293529857417218, '聂家辉开源项目', '046effbb-c33b-4572-a492-758ae2cd61ac.jpg', 1578293529811279874, 1564299172041101313, NULL, NULL, 1, 8484.00);
INSERT INTO `order_detail` VALUES (1578301235116826626, '麻辣水煮鱼', '1fdbfbf3-1d86-4b29-a3fc-46345852f2f8.jpg', 1578301235095855105, 1397854652581064706, NULL, '不要蒜,中辣', 1, 148.00);
INSERT INTO `order_detail` VALUES (1582987877531279362, '米饭', 'ee04a05a-1230-46b6-8ad5-1a95b140fff3.png', 1582987877518696449, 1413385247889891330, NULL, NULL, 1, 2.00);
INSERT INTO `order_detail` VALUES (1582987877531279363, '美女一号', '754ddb4a-4d05-42cd-8884-7aa0c75d0267.jpg', 1582987877518696449, 1564296152125444098, NULL, '不要香菜,重辣', 1, 1245.00);
INSERT INTO `order_detail` VALUES (1582987964286263298, '文件测试', '28adbbc0-9154-4877-be40-21693efcf871.jpg', 1582987964286263297, 1582283843585474561, NULL, '半糖', 1, 8088.00);
INSERT INTO `order_detail` VALUES (1582988231647977475, '文件测试', '28adbbc0-9154-4877-be40-21693efcf871.jpg', 1582988231647977474, 1582283843585474561, NULL, '多糖', 1, 8088.00);
INSERT INTO `order_detail` VALUES (1582988231647977476, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1582988231647977474, 1564299172041101313, NULL, NULL, 1, 8484.00);
INSERT INTO `order_detail` VALUES (1582988287864233987, '文件测试', '28adbbc0-9154-4877-be40-21693efcf871.jpg', 1582988287864233986, 1582283843585474561, NULL, '多糖', 1, 8088.00);
INSERT INTO `order_detail` VALUES (1582988379224563715, '文件测试', '28adbbc0-9154-4877-be40-21693efcf871.jpg', 1582988379224563714, 1582283843585474561, NULL, '多糖', 1, 8088.00);
INSERT INTO `order_detail` VALUES (1582988447939846147, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1582988447939846146, 1564299172041101313, NULL, NULL, 2, 8484.00);
INSERT INTO `order_detail` VALUES (1582988468135419906, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1582988468135419905, 1564299172041101313, NULL, NULL, 2, 8484.00);
INSERT INTO `order_detail` VALUES (1583290064386539522, '文件测试', '28adbbc0-9154-4877-be40-21693efcf871.jpg', 1583290064323624961, 1582283843585474561, NULL, '多糖', 1, 8088.00);
INSERT INTO `order_detail` VALUES (1583322542163206146, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1583322542096097281, 1564299172041101313, NULL, NULL, 1, 8484.00);
INSERT INTO `order_detail` VALUES (1583323103067480067, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1583323103067480066, 1564299172041101313, NULL, NULL, 1, 8484.00);
INSERT INTO `order_detail` VALUES (1583323564671606785, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1583323564604497922, 1564299172041101313, NULL, NULL, 1, 8484.00);
INSERT INTO `order_detail` VALUES (1583335664907309058, '文件测试', '28adbbc0-9154-4877-be40-21693efcf871.jpg', 1583335664840200193, 1582283843585474561, NULL, '半糖', 1, 8088.00);
INSERT INTO `order_detail` VALUES (1583335664907309059, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1583335664840200193, 1564299172041101313, NULL, NULL, 1, 8484.00);
INSERT INTO `order_detail` VALUES (1583337288987955202, '文件测试', '28adbbc0-9154-4877-be40-21693efcf871.jpg', 1583337288987955201, 1582283843585474561, NULL, '半糖', 2, 8088.00);
INSERT INTO `order_detail` VALUES (1583337288987955203, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1583337288987955201, 1564299172041101313, NULL, NULL, 2, 8484.00);
INSERT INTO `order_detail` VALUES (1583376212129071106, '四位美女', 'db436888-db96-42a9-8506-d83618f17ac6.jpg', 1583376212061962242, NULL, 1578307107768291329, NULL, 1, 1314.00);
INSERT INTO `order_detail` VALUES (1583376955221340162, '爱心儿童套餐A计划', '61d20592-b37f-4d72-a864-07ad5bb8f3bb.jpg', 1583376955154231298, NULL, 1415580119015145474, NULL, 1, 40.00);
INSERT INTO `order_detail` VALUES (1583376955221340163, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1583376955154231298, 1564299172041101313, NULL, NULL, 1, 8484.00);
INSERT INTO `order_detail` VALUES (1583377544189702146, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1583377544055484417, 1564299172041101313, NULL, NULL, 13, 8484.00);
INSERT INTO `order_detail` VALUES (1583377544189702147, '白切鸡', '9ec6fc2d-50d2-422e-b954-de87dcd04198.jpeg', 1583377544055484417, 1397860578738352129, NULL, NULL, 10, 66.00);
INSERT INTO `order_detail` VALUES (1583377544189702148, '烤乳猪', '2e96a7e3-affb-438e-b7c3-e1430df425c9.jpeg', 1583377544055484417, 1397860792492666881, NULL, NULL, 9, 388.00);
INSERT INTO `order_detail` VALUES (1583377544189702149, '爱心儿童套餐A计划', '61d20592-b37f-4d72-a864-07ad5bb8f3bb.jpg', 1583377544055484417, NULL, 1415580119015145474, NULL, 14, 40.00);
INSERT INTO `order_detail` VALUES (1583377544189702150, '四位美女', 'db436888-db96-42a9-8506-d83618f17ac6.jpg', 1583377544055484417, NULL, 1578307107768291329, NULL, 8, 1314.00);
INSERT INTO `order_detail` VALUES (1583377544189702151, '毛氏红烧肉', '0a3b3288-3446-4420-bbff-f263d0c02d8e.jpg', 1583377544055484417, 1397850140982161409, NULL, '不要香菜,中辣', 13, 68.00);
INSERT INTO `order_detail` VALUES (1583377544189702152, '美女二号', '14203701-ab0f-4856-80fb-38a624989435.jpg', 1583377544055484417, 1564296282002067457, NULL, '去冰,半糖', 12, 520.00);
INSERT INTO `order_detail` VALUES (1583377544189702153, '美女一号', '754ddb4a-4d05-42cd-8884-7aa0c75d0267.jpg', 1583377544055484417, 1564296152125444098, NULL, '不要香菜,重辣', 7, 1245.00);
INSERT INTO `order_detail` VALUES (1583377544189702154, '美女三号', '962a8778-6846-4296-bc58-169aa333b67e.jpg', 1583377544055484417, 1564296465360261122, NULL, '不要蒜', 6, 546.00);
INSERT INTO `order_detail` VALUES (1583377544189702155, '美女四号', 'd96bb4ea-6555-41b0-924e-99dc38019af3.jpg', 1583377544055484417, 1564296621379981314, NULL, '常温,少糖', 8, 3636.00);
INSERT INTO `order_detail` VALUES (1583377544189702156, '米饭', 'ee04a05a-1230-46b6-8ad5-1a95b140fff3.png', 1583377544055484417, 1413385247889891330, NULL, NULL, 4, 2.00);
INSERT INTO `order_detail` VALUES (1583377544189702157, '王老吉', '2baf07ed-bda2-49df-91f3-a703f8198140.png', 1583377544055484417, 1561629106362834946, NULL, NULL, 6, 35.00);
INSERT INTO `order_detail` VALUES (1583497391442157570, '文件测试', '28adbbc0-9154-4877-be40-21693efcf871.jpg', 1583497391102418945, 1582283843585474561, NULL, '多糖', 1, 8088.00);
INSERT INTO `order_detail` VALUES (1583497391442157571, '爱心儿童套餐A计划', '61d20592-b37f-4d72-a864-07ad5bb8f3bb.jpg', 1583497391102418945, NULL, 1415580119015145474, NULL, 1, 8848.00);
INSERT INTO `order_detail` VALUES (1586000872851218434, '美女二号', '14203701-ab0f-4856-80fb-38a624989435.jpg', 1586000872784109569, 1564296282002067457, NULL, '去冰,半糖', 1, 520.00);
INSERT INTO `order_detail` VALUES (1586015793684996097, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1586015793617887233, 1564299172041101313, NULL, NULL, 1, 8484.00);
-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
`id` bigint NOT NULL COMMENT '主键',
`number` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '订单号',
`status` int NOT NULL DEFAULT 1 COMMENT '订单状态 1待付款，2待派送，3已派送，4已完成，5已取消',
`user_id` bigint NOT NULL COMMENT '下单用户',
`address_book_id` bigint NOT NULL COMMENT '地址id',
`order_time` datetime NOT NULL COMMENT '下单时间',
`checkout_time` datetime NOT NULL COMMENT '结账时间',
`pay_method` int NOT NULL DEFAULT 1 COMMENT '支付方式 1微信,2支付宝',
`amount` decimal(10, 2) NOT NULL COMMENT '实收金额',
`remark` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '备注',
`phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`user_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
`consignee` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '订单表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (1562749000089313281, '1562749000089313281', 4, 1562476453301010434, 1562717864566898690, '2022-08-25 18:29:31', '2022-08-25 18:29:31', 1, 426.00, '', '17802045415', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562750233210494977, '1562750233210494977', 4, 1562476453301010434, 1562717864566898690, '2022-08-25 18:34:25', '2022-08-25 18:34:25', 1, 1200.00, '', '17802045415', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562757943666610177, '1562757943666610177', 4, 1562476453301010434, 1562717864566898690, '2022-08-25 19:05:03', '2022-08-25 19:05:03', 1, 78.00, '', '17802045415', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562760577693757442, '1562760577693757442', 4, 1562498296405762050, 1562721341934358529, '2022-08-25 19:15:31', '2022-08-25 19:15:31', 1, 174.00, '', '18875115454', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562760781843116034, '1562760781843116034', 4, 1562498296405762050, 1562721341934358529, '2022-08-25 19:16:20', '2022-08-25 19:16:20', 1, 78.00, '', '18875115454', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562785228843069442, '1562785228843069442', 4, 1562476453301010434, 1562785204771958786, '2022-08-25 20:53:28', '2022-08-25 20:53:28', 1, 78.00, '', '18802045416', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562785366537875457, '1562785366537875457', 4, 1562476453301010434, 1562785204771958786, '2022-08-25 20:54:01', '2022-08-25 20:54:01', 1, 78.00, '', '18802045416', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562815265411665922, '1562815265411665922', 4, 1562476453301010434, 1562785204771958786, '2022-08-25 22:52:50', '2022-08-25 22:52:50', 1, 78.00, '', '18802045416', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562817440518938626, '1562817440518938626', 4, 1562476453301010434, 1562785204771958786, '2022-08-25 23:01:28', '2022-08-25 23:01:28', 1, 78.00, '', '18802045416', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562817553706426369, '1562817553706426369', 4, 1562476453301010434, 1562785204771958786, '2022-08-25 23:01:55', '2022-08-25 23:01:55', 1, 78.00, '', '18802045416', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562818924614721537, '1562818924614721537', 4, 1562476453301010434, 1562785204771958786, '2022-08-25 23:07:22', '2022-08-25 23:07:22', 1, 216.00, '', '18802045416', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562819124670439425, '1562819124670439425', 4, 1562476453301010434, 1562785204771958786, '2022-08-25 23:08:10', '2022-08-25 23:08:10', 1, 344.00, '', '18802045416', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1562840539306037250, '1562840539306037250', 4, 1562476453301010434, 1562785204771958786, '2022-08-26 00:33:15', '2022-08-26 00:33:15', 1, 78.00, '', '18802045416', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1564302999188312066, '1564302999188312066', 4, 1562476453301010434, 1562785204771958786, '2022-08-30 01:24:33', '2022-08-30 01:24:33', 1, 20.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1576948194551775233, '1576948194551775233', 4, 1562498296405762050, 1562721341934358529, '2022-10-03 22:52:03', '2022-10-03 22:52:03', 1, 5947.00, '', '18875115454', '温州大学', NULL, '聂家辉');
INSERT INTO `orders` VALUES (1577264272242884609, '1577264272242884609', 4, 1576825229428375554, 1577264241850957825, '2022-10-04 19:48:01', '2022-10-04 19:48:01', 1, 86.00, '', '18263739247', '科大讯飞', NULL, '吴明');
INSERT INTO `orders` VALUES (1577617888220790786, '1577617888220790786', 4, 1562476453301010434, 1562785204771958786, '2022-10-05 19:13:10', '2022-10-05 19:13:10', 1, 2393.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1578301235095855105, '1578301235095855105', 2, 1562476453301010434, 1562785204771958786, '2022-10-07 16:28:33', '2022-10-07 16:28:33', 1, 148.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1582987877518696449, '1582987877518696449', 2, 1562476453301010434, 1562785204771958786, '2022-10-20 14:51:35', '2022-10-20 14:51:35', 1, 1247.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1582987964286263297, '1582987964286263297', 2, 1562476453301010434, 1562785204771958786, '2022-10-20 14:51:56', '2022-10-20 14:51:56', 1, 8088.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1582988231647977474, '1582988231647977474', 2, 1562476453301010434, 1562785204771958786, '2022-10-20 14:53:00', '2022-10-20 14:53:00', 1, 16572.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1582988287864233986, '1582988287864233986', 2, 1562476453301010434, 1562785204771958786, '2022-10-20 14:53:13', '2022-10-20 14:53:13', 1, 8088.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1582988379224563714, '1582988379224563714', 2, 1562476453301010434, 1562785204771958786, '2022-10-20 14:53:35', '2022-10-20 14:53:35', 1, 8088.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1582988447939846146, '1582988447939846146', 2, 1562476453301010434, 1562785204771958786, '2022-10-20 14:53:51', '2022-10-20 14:53:51', 1, 16968.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1582988468135419905, '1582988468135419905', 2, 1562476453301010434, 1562785204771958786, '2022-10-20 14:53:56', '2022-10-20 14:53:56', 1, 16968.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583290064323624961, '1583290064323624961', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 10:52:22', '2022-10-21 10:52:22', 1, 8088.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583322542096097281, '1583322542096097281', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 13:01:25', '2022-10-21 13:01:25', 1, 8484.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583323103067480066, '1583323103067480066', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 13:03:39', '2022-10-21 13:03:39', 1, 8484.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583323564604497922, '1583323564604497922', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 13:05:29', '2022-10-21 13:05:29', 1, 8484.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583335664840200193, '1583335664840200193', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 13:53:34', '2022-10-21 13:53:34', 1, 16572.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583337288987955201, '1583337288987955201', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 14:00:01', '2022-10-21 14:00:01', 1, 33144.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583376212061962242, '1583376212061962242', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 16:34:41', '2022-10-21 16:34:41', 1, 1314.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583376955154231298, '1583376955154231298', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 16:37:39', '2022-10-21 16:37:39', 1, 8524.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583377544055484417, '1583377544055484417', 2, 1562476453301010434, 1562785204771958786, '2022-10-21 16:39:59', '2022-10-21 16:39:59', 1, 173937.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1583497391102418945, '1583497391102418945', 2, 1562476453301010434, 1562785204771958786, '2022-10-22 00:36:13', '2022-10-22 00:36:13', 1, 16936.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1586000872784109569, '1586000872784109569', 2, 1562476453301010434, 1562785204771958786, '2022-10-28 22:24:09', '2022-10-28 22:24:09', 1, 520.00, '', '18802045416', '温州大学', NULL, '聂先生');
INSERT INTO `orders` VALUES (1586015793617887233, '1586015793617887233', 2, 1562476453301010434, 1562785204771958786, '2022-10-28 23:23:27', '2022-10-28 23:23:27', 1, 8484.00, '', '18802045416', '温州大学', NULL, '聂先生');
-- ----------------------------
-- Table structure for setmeal
-- ----------------------------
DROP TABLE IF EXISTS `setmeal`;
CREATE TABLE `setmeal` (
`id` bigint NOT NULL COMMENT '主键',
`category_id` bigint NOT NULL COMMENT '菜品分类id',
`name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '套餐名称',
`price` decimal(10, 2) NOT NULL COMMENT '套餐价格',
`status` int NULL DEFAULT NULL COMMENT '状态 0:停用 1:启用',
`code` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '编码',
`description` varchar(512) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '描述信息',
`image` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '图片',
`sale_num` int NOT NULL,
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_user` bigint NOT NULL COMMENT '创建人',
`update_user` bigint NOT NULL COMMENT '修改人',
`is_deleted` int NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_setmeal_name`(`name` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '套餐' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of setmeal
-- ----------------------------
INSERT INTO `setmeal` VALUES (1415580119015145474, 1413386191767674881, '爱心儿童套餐A计划', 884800.00, 1, '', '', '61d20592-b37f-4d72-a864-07ad5bb8f3bb.jpg', 16, '2021-07-15 15:52:55', '2022-10-22 00:36:13', 1415576781934608386, 1562476453301010434, 0);
INSERT INTO `setmeal` VALUES (1578307107768291329, 1578306915291680769, '四位美女', 1314.00, 1, '', '测试', 'db436888-db96-42a9-8506-d83618f17ac6.jpg', 9, '2022-10-07 16:51:53', '2022-10-21 16:47:08', 1562476453301010434, 1, 0);
-- ----------------------------
-- Table structure for setmeal_dish
-- ----------------------------
DROP TABLE IF EXISTS `setmeal_dish`;
CREATE TABLE `setmeal_dish` (
`id` bigint NOT NULL COMMENT '主键',
`setmeal_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '套餐id ',
`dish_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '菜品id',
`name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '菜品名称 （冗余字段）',
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '菜品原价（冗余字段）',
`copies` int NOT NULL COMMENT '份数',
`sort` int NOT NULL DEFAULT 0 COMMENT '排序',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_user` bigint NOT NULL COMMENT '创建人',
`update_user` bigint NOT NULL COMMENT '修改人',
`is_deleted` int NOT NULL DEFAULT 0 COMMENT '是否删除',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '套餐菜品关系' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of setmeal_dish
-- ----------------------------
INSERT INTO `setmeal_dish` VALUES (1564675567523094530, '1415580119015145474', '1564296751818641409', '温州大学', 235600.00, 1, 0, '2022-08-31 02:05:00', '2022-08-31 02:05:00', 1, 1, 0);
INSERT INTO `setmeal_dish` VALUES (1564675567539871746, '1415580119015145474', '1397850140982161409', '毛氏红烧肉', 6800.00, 1, 0, '2022-08-31 02:05:00', '2022-08-31 02:05:00', 1, 1, 0);
INSERT INTO `setmeal_dish` VALUES (1564675567539871747, '1415580119015145474', '1397850851245600769', '霸王别姬', 12800.00, 1, 0, '2022-08-31 02:05:00', '2022-08-31 02:05:00', 1, 1, 0);
INSERT INTO `setmeal_dish` VALUES (1564675567539871748, '1415580119015145474', '1397849739276890114', '辣子鸡', 7800.00, 1, 0, '2022-08-31 02:05:00', '2022-08-31 02:05:00', 1, 1, 0);
INSERT INTO `setmeal_dish` VALUES (1583379342556262402, '1578307107768291329', '1564296152125444098', '美女一号', 124500.00, 1, 0, '2022-10-21 16:47:08', '2022-10-21 16:47:08', 1, 1, 0);
INSERT INTO `setmeal_dish` VALUES (1583379342556262403, '1578307107768291329', '1564296282002067457', '美女二号', 52000.00, 1, 0, '2022-10-21 16:47:08', '2022-10-21 16:47:08', 1, 1, 0);
INSERT INTO `setmeal_dish` VALUES (1583379342556262404, '1578307107768291329', '1564296465360261122', '美女三号', 54600.00, 1, 0, '2022-10-21 16:47:08', '2022-10-21 16:47:08', 1, 1, 0);
INSERT INTO `setmeal_dish` VALUES (1583379342556262405, '1578307107768291329', '1564296621379981314', '美女四号', 363600.00, 1, 0, '2022-10-21 16:47:08', '2022-10-21 16:47:08', 1, 1, 0);
-- ----------------------------
-- Table structure for shopping_cart
-- ----------------------------
DROP TABLE IF EXISTS `shopping_cart`;
CREATE TABLE `shopping_cart` (
`id` bigint NOT NULL COMMENT '主键',
`name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '名称',
`image` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '图片',
`user_id` bigint NOT NULL COMMENT '主键',
`dish_id` bigint NULL DEFAULT NULL COMMENT '菜品id',
`setmeal_id` bigint NULL DEFAULT NULL COMMENT '套餐id',
`dish_flavor` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '口味',
`number` int NOT NULL DEFAULT 1 COMMENT '数量',
`amount` decimal(10, 2) NOT NULL COMMENT '金额',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '购物车' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of shopping_cart
-- ----------------------------
INSERT INTO `shopping_cart` VALUES (1565737255554965506, '项目说明', '74b6b6ad-f13f-4c23-9b2a-436f37834dda.jpg', 1565737241424355329, 1564299172041101313, NULL, NULL, 1, 8484.00, '2022-09-03 00:23:46');
INSERT INTO `shopping_cart` VALUES (1569501509445672962, '项目说明', '74b6b6ad-f13f-4c23-9b2a-436f37834dda.jpg', 1569501470983905281, 1564299172041101313, NULL, NULL, 1, 8484.00, '2022-09-13 09:41:34');
INSERT INTO `shopping_cart` VALUES (1569501608091508738, '美女集合', '4ed482d7-c94f-44c2-b67e-92d9367eb795.jpg', 1569501470983905281, NULL, 1564296949244530690, NULL, 1, 1314.00, '2022-09-13 09:41:58');
INSERT INTO `shopping_cart` VALUES (1575772661419851777, '毛氏红烧肉', '0a3b3288-3446-4420-bbff-f263d0c02d8e.jpg', 1575772334830370817, 1397850140982161409, NULL, '不要蒜,中辣', 1, 68.00, '2022-09-30 17:00:54');
INSERT INTO `shopping_cart` VALUES (1576824772756750337, '美女四号', 'd4615106-eae4-4a1c-8ff8-e2fb8a827581.jpg', 1576824658696847362, 1564296621379981314, NULL, '多冰,全糖', 1, 3636.00, '2022-10-03 14:41:36');
INSERT INTO `shopping_cart` VALUES (1576824789299085313, '鱼香炒鸡蛋', '0f252364-a561-4e8d-8065-9a6797a6b1d3.jpg', 1576824700656664577, 1397854865672679425, NULL, '不辣', 1, 20.00, '2022-10-03 14:41:40');
INSERT INTO `shopping_cart` VALUES (1586015813993816066, '聂家辉开源项目', '82c8c7fe-93b0-4192-b75d-c033c656feb4.jpg', 1562476453301010434, 1564299172041101313, NULL, NULL, 1, 8484.00, '2022-10-28 23:23:31');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint NOT NULL COMMENT '主键',
`name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '姓名',
`phone` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT '手机号',
`sex` varchar(2) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '性别',
`id_number` varchar(18) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '身份证号',
`avatar` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NULL DEFAULT NULL COMMENT '头像',
`status` int NULL DEFAULT 0 COMMENT '状态 0:禁用，1:正常',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_bin COMMENT = '用户信息' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1562476453301010434, NULL, 'wzunjh@qq.com', NULL, NULL, NULL, 1);
INSERT INTO `user` VALUES (1562498296405762050, NULL, '2787731065@qq.com', NULL, NULL, NULL, 1);
INSERT INTO `user` VALUES (1565737241424355329, NULL, '751033685@qq.com', NULL, NULL, NULL, 1);
INSERT INTO `user` VALUES (1569501470983905281, NULL, '3082747329@qq.com', NULL, NULL, NULL, 1);
INSERT INTO `user` VALUES (1569522641070645250, NULL, '3212638074@qq.com', NULL, NULL, NULL, 1);
INSERT INTO `user` VALUES (1575772334830370817, NULL, '1205905162@qq.com', NULL, NULL, NULL, 1);
INSERT INTO `user` VALUES (1576824658696847362, NULL, '2596482369@qq.com', NULL, NULL, NULL, 1);
INSERT INTO `user` VALUES (1576824700656664577, NULL, '2077227803@qq.com', NULL, NULL, NULL, 1);
INSERT INTO `user` VALUES (1576825229428375554, NULL, '2545302203@qq.com', NULL, NULL, NULL, 1);
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手