订单系统

/*
Navicat MySQL Data Transfer

Source Server : mysql
Source Server Version : 50557
Source Host : localhost:3306
Source Database : order_system

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

Date: 2017-10-22 16:24:01
*/

SET FOREIGN_KEY_CHECKS=0;

---

– Table structure for client

---

DROP TABLE IF EXISTS client;
CREATE TABLE client (
id int(2) NOT NULL AUTO_INCREMENT,
name varchar(50) NOT NULL,
age int(10) NOT NULL,
profession varchar(20) DEFAULT NULL,
PRIMARY KEY (id),
KEY id (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of client

---

INSERT INTO client VALUES (‘1’, ‘张三’, ‘21’, ‘学生’);
INSERT INTO client VALUES (‘2’, ‘李四’, ‘23’, ‘护士’);
INSERT INTO client VALUES (‘3’, ‘王二’, ‘18’, ‘待业青年’);
INSERT INTO client VALUES (‘4’, ‘小聪’, ‘20’, ‘工程师’);
INSERT INTO client VALUES (‘5’, ‘小灰’, ‘23’, ‘厨师’);
INSERT INTO client VALUES (‘6’, ‘阿涛’, ‘24’, ‘学生’);
INSERT INTO client VALUES (‘7’, ‘刘么么’, ‘30’, null);
INSERT INTO client VALUES (‘8’, ‘小江’, ‘45’, ‘老师’);
INSERT INTO client VALUES (‘9’, ‘赵六’, ‘60’, null);
INSERT INTO client VALUES (‘10’, ‘诸葛宇春’, ‘80’, null);

---

– Table structure for client_restaurant

---

DROP TABLE IF EXISTS client_restaurant;
CREATE TABLE client_restaurant (
id int(2) NOT NULL AUTO_INCREMENT,
client_id int(2) DEFAULT NULL,
restaurant_id int(2) DEFAULT NULL,
PRIMARY KEY (id),
KEY FK_CL_RE_01 (client_id),
KEY FK_CL_RE_02 (restaurant_id),
CONSTRAINT FK_CL_RE_02 FOREIGN KEY (restaurant_id) REFERENCES restaurant (id),
CONSTRAINT FK_CL_RE_01 FOREIGN KEY (client_id) REFERENCES client (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of client_restaurant

---

INSERT INTO client_restaurant VALUES (‘1’, ‘1’, ‘1’);
INSERT INTO client_restaurant VALUES (‘2’, ‘2’, ‘10’);
INSERT INTO client_restaurant VALUES (‘3’, ‘3’, ‘1’);
INSERT INTO client_restaurant VALUES (‘4’, ‘5’, ‘5’);
INSERT INTO client_restaurant VALUES (‘5’, ‘4’, ‘6’);
INSERT INTO client_restaurant VALUES (‘6’, ‘6’, ‘3’);
INSERT INTO client_restaurant VALUES (‘7’, ‘7’, ‘2’);
INSERT INTO client_restaurant VALUES (‘8’, ‘8’, ‘10’);
INSERT INTO client_restaurant VALUES (‘9’, ‘10’, ‘2’);
INSERT INTO client_restaurant VALUES (‘10’, ‘9’, ‘10’);

---

– Table structure for details

---

DROP TABLE IF EXISTS details;
CREATE TABLE details (
id int(2) NOT NULL AUTO_INCREMENT,
order_number int(20) NOT NULL,
order_time datetime NOT NULL,
client_restaurant_id int(2) NOT NULL,
dish_id int(2) NOT NULL,
dish_acount int(10) NOT NULL,
PRIMARY KEY (id),
KEY FK_OR_01 (dish_id) USING BTREE,
KEY FK_DE_02 (client_restaurant_id),
CONSTRAINT FK_DE_01 FOREIGN KEY (dish_id) REFERENCES dish (id),
CONSTRAINT FK_DE_02 FOREIGN KEY (client_restaurant_id) REFERENCES client_restaurant (id)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

---

– Records of details

---

INSERT INTO details VALUES (‘1’, ‘1’, ‘2017-10-01 12:08:10’, ‘1’, ‘2’, ‘2’);
INSERT INTO details VALUES (‘2’, ‘2’, ‘2017-10-02 12:09:57’, ‘1’, ‘3’, ‘2’);
INSERT INTO details VALUES (‘3’, ‘3’, ‘2017-10-03 11:10:43’, ‘3’, ‘1’, ‘1’);
INSERT INTO details VALUES (‘4’, ‘1’, ‘2017-10-04 11:14:45’, ‘2’, ‘6’, ‘1’);
INSERT INTO details VALUES (‘5’, ‘1’, ‘2017-10-04 11:14:45’, ‘9’, ‘6’, ‘1’);
INSERT INTO details VALUES (‘6’, ‘2’, ‘2017-10-05 11:16:28’, ‘9’, ‘5’, ‘2’);
INSERT INTO details VALUES (‘7’, ‘1’, ‘2017-10-06 11:17:33’, ‘4’, ‘10’, ‘1’);
INSERT INTO details VALUES (‘8’, ‘1’, ‘2017-10-06 11:17:33’, ‘4’, ‘9’, ‘1’);
INSERT INTO details VALUES (‘9’, ‘1’, ‘2017-10-07 11:18:40’, ‘8’, ‘14’, ‘1’);
INSERT INTO details VALUES (‘10’, ‘1’, ‘2017-10-07 10:18:40’, ‘8’, ‘15’, ‘1’);
INSERT INTO details VALUES (‘11’, ‘1’, ‘2017-10-07 11:18:40’, ‘8’, ‘11’, ‘1’);
INSERT INTO details VALUES (‘12’, ‘2’, ‘2017-10-08 10:21:11’, ‘10’, ‘12’, ‘1’);
INSERT INTO details VALUES (‘13’, ‘2’, ‘2017-10-08 10:21:11’, ‘10’, ‘14’, ‘1’);

---

– Table structure for dish

---

DROP TABLE IF EXISTS dish;
CREATE TABLE dish (
id int(2) NOT NULL AUTO_INCREMENT,
dish_name varchar(20) NOT NULL,
price decimal(20,2) NOT NULL,
category varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

---

– Records of dish

---

INSERT INTO dish VALUES (‘1’, ‘香辣鸡腿堡’, ‘12.50’, ‘汉堡’);
INSERT INTO dish VALUES (‘2’, ‘劲脆鸡腿堡’, ‘12.50’, ‘汉堡’);
INSERT INTO dish VALUES (‘3’, ‘新奥尔良烤鸡腿堡’, ‘13.50’, ‘汉堡’);
INSERT INTO dish VALUES (‘4’, ‘深海鳕鱼堡’, ‘11.00’, ‘汉堡’);
INSERT INTO dish VALUES (‘5’, ‘小馄饨’, ‘8.00’, ‘主食’);
INSERT INTO dish VALUES (‘6’, ‘炒饭’, ‘12.00’, ‘主食’);
INSERT INTO dish VALUES (‘7’, ‘摩卡咖啡’, ‘30.00’, ‘饮料’);
INSERT INTO dish VALUES (‘8’, ‘美式咖啡’, ‘25.00’, ‘饮料’);
INSERT INTO dish VALUES (‘9’, ‘海鲜大狂欢披萨’, ‘79.00’, ‘主食’);
INSERT INTO dish VALUES (‘10’, ‘香烤劲牛披萨’, ‘66.00’, ‘主食’);
INSERT INTO dish VALUES (‘11’, ‘宫爆鸡丁’, ‘16.88’, ‘中餐’);
INSERT INTO dish VALUES (‘12’, ‘鱼香肉丝’, ‘28.88’, ‘中餐’);
INSERT INTO dish VALUES (‘13’, ‘皇堡’, ‘19.00’, ‘汉堡’);
INSERT INTO dish VALUES (‘14’, ‘酸辣土豆丝’, ‘18.00’, ‘中餐’);
INSERT INTO dish VALUES (‘15’, ‘酸菜鱼’, ‘58.00’, ‘中餐’);
INSERT INTO dish VALUES (‘16’, ‘德克萨斯烟熏牛堡’, ‘39.00’, ‘汉堡’);
INSERT INTO dish VALUES (‘17’, ‘可乐’, ‘11.00’, ‘饮料’);
INSERT INTO dish VALUES (‘18’, ‘果汁’, ‘11.00’, ‘饮料’);

---

– Table structure for restaurant

---

DROP TABLE IF EXISTS restaurant;
CREATE TABLE restaurant (
id int(2) NOT NULL AUTO_INCREMENT,
restaurant_name varchar(20) NOT NULL,
category varchar(20) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

---

– Records of restaurant

---

INSERT INTO restaurant VALUES (‘1’, ‘肯德基’, ‘快餐’);
INSERT INTO restaurant VALUES (‘2’, ‘沙县’, ‘小吃’);
INSERT INTO restaurant VALUES (‘3’, ‘星巴克’, ‘下午茶’);
INSERT INTO restaurant VALUES (‘4’, ‘麦当劳’, ‘快餐’);
INSERT INTO restaurant VALUES (‘5’, ‘必胜客’, ‘西餐’);
INSERT INTO restaurant VALUES (‘6’, ‘汉堡王’, ‘快餐’);
INSERT INTO restaurant VALUES (‘7’, ‘吉祥馄饨’, ‘小吃’);
INSERT INTO restaurant VALUES (‘8’, ‘杨国福’, ‘麻辣烫’);
INSERT INTO restaurant VALUES (‘9’, ‘张亮’, ‘麻辣烫’);
INSERT INTO restaurant VALUES (‘10’, ‘八大碗’, ‘中餐’);

---

– Table structure for restaurant_dish

---

DROP TABLE IF EXISTS restaurant_dish;
CREATE TABLE restaurant_dish (
id int(2) NOT NULL AUTO_INCREMENT,
restaurant_id int(2) DEFAULT NULL,
dish_id int(2) DEFAULT NULL,
PRIMARY KEY (id),
KEY FK_RE_DI_01 (restaurant_id),
KEY FK_RE_DI_02 (dish_id),
CONSTRAINT FK_RE_DI_02 FOREIGN KEY (dish_id) REFERENCES dish (id),
CONSTRAINT FK_RE_DI_01 FOREIGN KEY (restaurant_id) REFERENCES restaurant (id)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

---

– Records of restaurant_dish

---

INSERT INTO restaurant_dish VALUES (‘1’, ‘1’, ‘1’);
INSERT INTO restaurant_dish VALUES (‘2’, ‘1’, ‘2’);
INSERT INTO restaurant_dish VALUES (‘3’, ‘1’, ‘3’);
INSERT INTO restaurant_dish VALUES (‘4’, ‘1’, ‘4’);
INSERT INTO restaurant_dish VALUES (‘5’, ‘2’, ‘5’);
INSERT INTO restaurant_dish VALUES (‘6’, ‘2’, ‘6’);
INSERT INTO restaurant_dish VALUES (‘7’, ‘3’, ‘7’);
INSERT INTO restaurant_dish VALUES (‘8’, ‘3’, ‘8’);
INSERT INTO restaurant_dish VALUES (‘9’, ‘5’, ‘9’);
INSERT INTO restaurant_dish VALUES (‘10’, ‘5’, ‘10’);
INSERT INTO restaurant_dish VALUES (‘11’, ‘10’, ‘11’);
INSERT INTO restaurant_dish VALUES (‘12’, ‘10’, ‘12’);
INSERT INTO restaurant_dish VALUES (‘13’, ‘6’, ‘13’);
INSERT INTO restaurant_dish VALUES (‘14’, ‘10’, ‘14’);
INSERT INTO restaurant_dish VALUES (‘15’, ‘10’, ‘15’);
INSERT INTO restaurant_dish VALUES (‘16’, ‘6’, ‘16’);
INSERT INTO restaurant_dish VALUES (‘17’, ‘6’, ‘17’);
INSERT INTO restaurant_dish VALUES (‘18’, ‘6’, ‘18’);