初作餐厅系统
来源:互联网 发布:ps淘宝详情页尺寸 编辑:程序博客网 时间:2024/04/28 00:29
订单配送明细
/*
Navicat MySQL Data TransferSource Server : 127.0.0.1_3306
Source Server Version : 50557
Source Host : 127.0.0.1:3306
Source Database : mysql
Target Server Type : MYSQL
Target Server Version : 50557
File Encoding : 65001
Date: 2017-10-20 17:30:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for courier_20
-- ----------------------------
DROP TABLE IF EXISTS `courier_20`;
CREATE TABLE `courier_20` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_code` varchar(255) DEFAULT NULL,
`courier` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK_01` (`courier`),
CONSTRAINT `FK_01` FOREIGN KEY (`courier`) REFERENCES `person_name20` (`name_code`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of courier_20
-- ----------------------------
INSERT INTO `courier_20` VALUES ('1', 'S1', 'K1');
INSERT INTO `courier_20` VALUES ('2', 'S2', 'K2');
INSERT INTO `courier_20` VALUES ('3', 'S3', 'K3');
INSERT INTO `courier_20` VALUES ('4', 'S4', 'K2');
INSERT INTO `courier_20` VALUES ('5', 'S5', 'K4');
INSERT INTO `courier_20` VALUES ('6', 'S6', 'K5');
INSERT INTO `courier_20` VALUES ('7', 'S7', 'K5');
INSERT INTO `courier_20` VALUES ('8', 'S8', 'K2');
INSERT INTO `courier_20` VALUES ('9', 'S9', 'K3');
INSERT INTO `courier_20` VALUES ('10', 'S10', 'K1');
INSERT INTO `courier_20` VALUES ('11', 'S11', 'K2');
INSERT INTO `courier_20` VALUES ('12', 'S12', 'K1');
INSERT INTO `courier_20` VALUES ('13', 'S13', 'K4');
菜单
/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1_3306
Source Server Version : 50557
Source Host : 127.0.0.1:3306
Source Database : mysql
Target Server Type : MYSQL
Target Server Version : 50557
File Encoding : 65001
Date: 2017-10-20 17:31:06
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for food_20
-- ----------------------------
DROP TABLE IF EXISTS `food_20`;
CREATE TABLE `food_20` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`food_code` varchar(255) DEFAULT NULL,
`food_list` varchar(255) DEFAULT NULL,
`unit_price` decimal(10,2) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `food_code` (`food_code`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of food_20
-- ----------------------------
INSERT INTO `food_20` VALUES ('1', 'F1', '土豆肉丝', '15.00');
INSERT INTO `food_20` VALUES ('2', 'F2', '酸菜鱼', '30.00');
INSERT INTO `food_20` VALUES ('3', 'F3', '红烧排骨', '25.00');
INSERT INTO `food_20` VALUES ('4', 'F4', '鱼香肉丝', '18.00');
INSERT INTO `food_20` VALUES ('5', 'F5', '土豆牛肉', '25.00');
INSERT INTO `food_20` VALUES ('6', 'F6', '干锅牛蛙', '30.00');
INSERT INTO `food_20` VALUES ('7', 'F7', '涮羊肉', '60.00');
INSERT INTO `food_20` VALUES ('8', 'F8', '红烧肉', '15.00');
INSERT INTO `food_20` VALUES ('9', 'F9', '麻辣香锅', '20.00');
INSERT INTO `food_20` VALUES ('10', 'F10', '韭菜鸡蛋', '15.00');
INSERT INTO `food_20` VALUES ('11', 'F11', '香辣鸡丁', '20.00');
INSERT INTO `food_20` VALUES ('12', 'F12', '辣子鸡', '25.00');
INSERT INTO `food_20` VALUES ('13', 'F13', '老鸭酸菜汤', '20.00');
订单出处
/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1_3306
Source Server Version : 50557
Source Host : 127.0.0.1:3306
Source Database : mysql
Target Server Type : MYSQL
Target Server Version : 50557
File Encoding : 65001
Date: 2017-10-20 17:31:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for order_20
-- ----------------------------
DROP TABLE IF EXISTS `order_20`;
CREATE TABLE `order_20` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`restaurant_code` varchar(255) DEFAULT NULL,
`order_code` varchar(255) DEFAULT NULL,
`eat_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `order_code` (`order_code`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_20
-- ----------------------------
INSERT INTO `order_20` VALUES ('1', '01', 'S1', '2017-10-24 02:20:29');
INSERT INTO `order_20` VALUES ('2', '01', 'S2', '2010-02-20 12:21:03');
INSERT INTO `order_20` VALUES ('3', '01', 'S3', '2017-10-29 12:21:21');
INSERT INTO `order_20` VALUES ('4', '01', 'S4', '2017-05-28 12:21:36');
INSERT INTO `order_20` VALUES ('5', '02', 'S5', '2017-10-29 12:21:48');
INSERT INTO `order_20` VALUES ('6', '02', 'S6', '2011-03-16 06:21:57');
INSERT INTO `order_20` VALUES ('7', '02', 'S7', '2008-11-20 12:22:15');
INSERT INTO `order_20` VALUES ('8', '02', 'S8', '2012-08-20 12:22:30');
INSERT INTO `order_20` VALUES ('9', '03', 'S9', '2017-10-22 12:22:49');
INSERT INTO `order_20` VALUES ('10', '03', 'S10', '2015-11-01 12:22:58');
INSERT INTO `order_20` VALUES ('11', '03', 'S11', '2017-10-05 15:15:09');
INSERT INTO `order_20` VALUES ('12', '03', 'S12', '2017-10-02 15:15:27');
订单明细
/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1_3306
Source Server Version : 50557
Source Host : 127.0.0.1:3306
Source Database : mysql
Target Server Type : MYSQL
Target Server Version : 50557
File Encoding : 65001
Date: 2017-10-20 17:31:12
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for order_20
-- ----------------------------
DROP TABLE IF EXISTS `order_20`;
CREATE TABLE `order_20` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`restaurant_code` varchar(255) DEFAULT NULL,
`order_code` varchar(255) DEFAULT NULL,
`eat_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `order_code` (`order_code`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order_20
-- ----------------------------
INSERT INTO `order_20` VALUES ('1', '01', 'S1', '2017-10-24 02:20:29');
INSERT INTO `order_20` VALUES ('2', '01', 'S2', '2010-02-20 12:21:03');
INSERT INTO `order_20` VALUES ('3', '01', 'S3', '2017-10-29 12:21:21');
INSERT INTO `order_20` VALUES ('4', '01', 'S4', '2017-05-28 12:21:36');
INSERT INTO `order_20` VALUES ('5', '02', 'S5', '2017-10-29 12:21:48');
INSERT INTO `order_20` VALUES ('6', '02', 'S6', '2011-03-16 06:21:57');
INSERT INTO `order_20` VALUES ('7', '02', 'S7', '2008-11-20 12:22:15');
INSERT INTO `order_20` VALUES ('8', '02', 'S8', '2012-08-20 12:22:30');
INSERT INTO `order_20` VALUES ('9', '03', 'S9', '2017-10-22 12:22:49');
INSERT INTO `order_20` VALUES ('10', '03', 'S10', '2015-11-01 12:22:58');
INSERT INTO `order_20` VALUES ('11', '03', 'S11', '2017-10-05 15:15:09');
INSERT INTO `order_20` VALUES ('12', '03', 'S12', '2017-10-02 15:15:27');
送单员名单
/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1_3306
Source Server Version : 50557
Source Host : 127.0.0.1:3306
Source Database : mysql
Target Server Type : MYSQL
Target Server Version : 50557
File Encoding : 65001
Date: 2017-10-20 17:31:24
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for person_name20
-- ----------------------------
DROP TABLE IF EXISTS `person_name20`;
CREATE TABLE `person_name20` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name_code` varchar(255) DEFAULT NULL,
`courier_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name_code` (`name_code`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of person_name20
-- ----------------------------
INSERT INTO `person_name20` VALUES ('1', 'K1', '张三');
INSERT INTO `person_name20` VALUES ('2', 'K2', '李四');
INSERT INTO `person_name20` VALUES ('3', 'K3', '王五');
INSERT INTO `person_name20` VALUES ('4', 'K4', '吴大');
INSERT INTO `person_name20` VALUES ('5', 'K5 ', '赵六');
餐厅名单
/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1_3306
Source Server Version : 50557
Source Host : 127.0.0.1:3306
Source Database : mysql
Target Server Type : MYSQL
Target Server Version : 50557
File Encoding : 65001
Date: 2017-10-20 17:31:24
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for person_name20
-- ----------------------------
DROP TABLE IF EXISTS `person_name20`;
CREATE TABLE `person_name20` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name_code` varchar(255) DEFAULT NULL,
`courier_name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `name_code` (`name_code`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of person_name20
-- ----------------------------
INSERT INTO `person_name20` VALUES ('1', 'K1', '张三');
INSERT INTO `person_name20` VALUES ('2', 'K2', '李四');
INSERT INTO `person_name20` VALUES ('3', 'K3', '王五');
INSERT INTO `person_name20` VALUES ('4', 'K4', '吴大');
INSERT INTO `person_name20` VALUES ('5', 'K5 ', '赵六');
- 初作餐厅系统
- 力克餐厅管理系统 下载
- 餐厅
- 写个餐厅发票生成系统
- C#餐厅管理系统1--ER图
- C#餐厅管理系统3--MAIN窗口
- C#餐厅管理系统6--呼叫管理员!
- QQ餐厅与系统性能模型
- 餐厅管理系统(C++实践)
- Quickorder,自由的餐厅POS系统
- 餐厅点餐系统 --OC设计
- 2015年9月 javaweb餐厅系统
- C#餐厅管理系统2--数据连接及登录
- C#餐厅管理系统4--增删改查!
- C#餐厅管理系统5--餐桌和职员
- 微信点餐外卖系统,让餐厅变得更智慧
- 用于快餐行业的自动化餐厅系统构想
- 重作系统了
- ubuntu16.04安装maven
- JS显式类型转换和隐式类型转换
- C++函数名称的修饰规则
- 报名 | “阳奉阴违”的半监督学习算法
- Qt个性化系统托盘的实现(电脑管家)
- 初作餐厅系统
- 我自己的贝塞尔
- Lucene笔记总结(理论篇)
- 喂,你是在学习还是在逃避?
- 第十二篇:Android GET请求获取网络数据以及POST数据(使用HttpURLConnection)
- 在Linux下打开eclipse的文件出现闪退的解决情况
- Javacv使用ffmpeg实现音视频同步播放
- WEB那点事 -- (一)CGI 是什么玩意
- preg(正则)