餐厅订餐

1、顾客表t_customer

2、饭店表t_restaurant

3、菜单表t_menue

4、订单表头t_order_head

5、订单表t_order

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

-- 代码
/*
Navicat MySQL Data Transfer

Source Server         : ntqn_96
Source Server Version : 50555
Source Host           : localhost:3306
Source Database       : 餐厅订餐

Target Server Type    : MYSQL
Target Server Version : 50555
File Encoding         : 65001

Date: 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', '李某某', '圆融', '江浙菜');