餐厅订餐

1、顾客表t_customer

2、饭店表t_restaurant

3、菜单表t_menue

4、订单表头t_order_head

5、订单表t_order

6、思维导图，各表之间的关系

-- 代码/*Navicat MySQL Data TransferSource Server         : ntqn_96Source Server Version : 50555Source Host           : localhost:3306Source Database       : 餐厅订餐Target Server Type    : MYSQLTarget Server Version : 50555File Encoding         : 65001Date: 2017-10-22 21:56:06*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for t_customer-- ----------------------------DROP TABLE IF EXISTS `t_customer`;CREATE TABLE `t_customer` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(255) NOT NULL,  `tel` varchar(255) NOT NULL,  `address` varchar(255) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;-- ------------------------------ Records of t_customer-- ----------------------------INSERT INTO `t_customer` VALUES ('1', '张三', '18888888888', '数字大厦');INSERT INTO `t_customer` VALUES ('2', '李四', '18811111111', '聚贤公寓');INSERT INTO `t_customer` VALUES ('3', '刘杰', '18812121212', '数字大厦');INSERT INTO `t_customer` VALUES ('4', '闻鸿', '18813131313', '数字大厦');INSERT INTO `t_customer` VALUES ('5', '姚亚峰', '16611111111', '数字大厦');INSERT INTO `t_customer` VALUES ('6', '李欣荣', '16612121212', '数字大厦');INSERT INTO `t_customer` VALUES ('7', '袁赛荣', '18816161616', '数字大厦');INSERT INTO `t_customer` VALUES ('8', '徐亮', '18818181818', '数字大厦');INSERT INTO `t_customer` VALUES ('9', '张旷怡', '18819191919', '数字大厦');INSERT INTO `t_customer` VALUES ('10', '袁凯华', '18866666666', '数字大厦');-- ------------------------------ Table structure for t_menue-- ----------------------------DROP TABLE IF EXISTS `t_menue`;CREATE TABLE `t_menue` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `restaurant_id` int(11) NOT NULL,  `name` varchar(255) NOT NULL,  `price` decimal(10,2) NOT NULL,  PRIMARY KEY (`id`),  KEY `fk_restaurant_menue` (`restaurant_id`),  CONSTRAINT `fk_restaurant_menue` FOREIGN KEY (`restaurant_id`) REFERENCES `t_restaurant` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;-- ------------------------------ Records of t_menue-- ----------------------------INSERT INTO `t_menue` VALUES ('1', '1', '干锅牛蛙', '58.00');INSERT INTO `t_menue` VALUES ('2', '1', '烤鱼', '88.00');INSERT INTO `t_menue` VALUES ('3', '1', '娃娃菜', '28.00');INSERT INTO `t_menue` VALUES ('4', '1', '酸菜鱼', '48.00');INSERT INTO `t_menue` VALUES ('5', '1', '金手指', '45.00');INSERT INTO `t_menue` VALUES ('6', '3', '香辣鸡腿堡', '18.00');INSERT INTO `t_menue` VALUES ('7', '3', '双层牛肉堡', '18.00');INSERT INTO `t_menue` VALUES ('8', '4', '可乐', '5.00');INSERT INTO `t_menue` VALUES ('9', '4', '甜筒', '3.00');INSERT INTO `t_menue` VALUES ('10', '1', '钵钵鸡', '25.00');-- ------------------------------ Table structure for t_order-- ----------------------------DROP TABLE IF EXISTS `t_order`;CREATE TABLE `t_order` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `order_head_id` int(11) DEFAULT NULL,  `menue_id` int(11) NOT NULL,  `price` decimal(10,2) NOT NULL,  `piece` int(11) NOT NULL,  PRIMARY KEY (`id`),  KEY `fk_menue_list` (`menue_id`),  CONSTRAINT `fk_menue_list` FOREIGN KEY (`menue_id`) REFERENCES `t_menue` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;-- ------------------------------ Records of t_order-- ----------------------------INSERT INTO `t_order` VALUES ('1', '1', '1', '58.00', '1');INSERT INTO `t_order` VALUES ('2', '1', '2', '88.00', '1');INSERT INTO `t_order` VALUES ('3', '1', '3', '28.00', '2');INSERT INTO `t_order` VALUES ('4', '2', '1', '58.00', '1');INSERT INTO `t_order` VALUES ('5', '2', '4', '48.00', '1');INSERT INTO `t_order` VALUES ('6', '2', '5', '45.00', '2');INSERT INTO `t_order` VALUES ('7', '3', '1', '58.00', '1');INSERT INTO `t_order` VALUES ('8', '3', '2', '88.00', '1');INSERT INTO `t_order` VALUES ('9', '3', '3', '28.00', '1');INSERT INTO `t_order` VALUES ('10', '3', '4', '48.00', '2');-- ------------------------------ Table structure for t_order_head-- ----------------------------DROP TABLE IF EXISTS `t_order_head`;CREATE TABLE `t_order_head` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `code` varchar(255) NOT NULL,  `order_time` datetime NOT NULL,  `table_num` varchar(255) NOT NULL,  `customer_num` int(11) NOT NULL,  `server` varchar(255) NOT NULL,  `customer_id` int(11) NOT NULL,  `restaurant_id` int(11) NOT NULL,  PRIMARY KEY (`id`),  KEY `fk_customer_order` (`customer_id`),  KEY `fk_restaurant_order` (`restaurant_id`),  CONSTRAINT `fk_customer_order` FOREIGN KEY (`customer_id`) REFERENCES `t_customer` (`id`),  CONSTRAINT `fk_restaurant_order` FOREIGN KEY (`restaurant_id`) REFERENCES `t_restaurant` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;-- ------------------------------ Records of t_order_head-- ----------------------------INSERT INTO `t_order_head` VALUES ('1', '001', '2017-10-18 16:06:59', 'A1', '3', '张', '1', '1');INSERT INTO `t_order_head` VALUES ('2', '002', '2017-10-18 17:06:59', 'A2', '3', '张', '2', '1');INSERT INTO `t_order_head` VALUES ('3', '003', '2017-10-18 18:06:59', 'A3', '3', '张', '3', '1');INSERT INTO `t_order_head` VALUES ('4', '004', '2017-10-19 19:33:13', 'C1', '2', '张', '1', '2');INSERT INTO `t_order_head` VALUES ('5', '005', '2017-10-19 19:40:13', 'C2', '2', '张', '2', '2');INSERT INTO `t_order_head` VALUES ('6', '006', '2017-10-18 19:45:23', 'C3', '4', '张', '3', '3');INSERT INTO `t_order_head` VALUES ('7', '007', '2017-10-19 19:50:23', 'C4', '3', '张', '4', '3');INSERT INTO `t_order_head` VALUES ('8', '008', '2017-10-19 20:38:49', 'B1', '1', '张', '5', '3');INSERT INTO `t_order_head` VALUES ('9', '009', '2017-10-20 19:38:49', 'B2', '1', '张', '6', '3');INSERT INTO `t_order_head` VALUES ('10', '010', '2017-10-20 19:44:34', 'B3', '2', '张', '7', '4');INSERT INTO `t_order_head` VALUES ('11', '011', '2017-10-20 20:29:42', 'B4', '2', '张', '8', '4');-- ------------------------------ Table structure for t_restaurant-- ----------------------------DROP TABLE IF EXISTS `t_restaurant`;CREATE TABLE `t_restaurant` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(255) NOT NULL,  `tel` varchar(255) NOT NULL,  `owner` varchar(255) NOT NULL,  `address` varchar(255) NOT NULL,  `type` varchar(255) NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;-- ------------------------------ Records of t_restaurant-- ----------------------------INSERT INTO `t_restaurant` VALUES ('1', '外婆家', '18833333333', '张某某', '南大街', '江浙菜');INSERT INTO `t_restaurant` VALUES ('2', '辛香汇', '18844444444', '李某某', '南大街', '川菜');INSERT INTO `t_restaurant` VALUES ('3', '肯德基', '11111111111', '李某某', '圆融', '快餐');INSERT INTO `t_restaurant` VALUES ('4', '麦当劳', '11122222222', '李某某', '中南', '快餐');INSERT INTO `t_restaurant` VALUES ('5', '必胜客', '11133333333', '李某某', '中南', '快餐');INSERT INTO `t_restaurant` VALUES ('6', '金釜山', '11144444444', '李某某', '南大街', '自助');INSERT INTO `t_restaurant` VALUES ('7', '鱼情未了', '11155555555', '李某某', '圆融', '江浙菜');INSERT INTO `t_restaurant` VALUES ('8', '豪味家', '11166666666', '李某某', '南大街', '西餐');INSERT INTO `t_restaurant` VALUES ('9', '麦哲伦', '11177777777', '李某某', '中南', '自助');INSERT INTO `t_restaurant` VALUES ('10', '邵东家', '11188888888', '李某某', '圆融', '江浙菜');