MySQL8.0-外键约束

1、创建订单表（ordes）

订单表（orders）
orders(id,customerId,saleId,orderDate,notes)
orders表数据

订单ID	客户ID	销售员ID	订单日期	备注
10001	1	3	2015-05-15
10002	2	2	2015-05-16
10003	3	2	2015-05-16
10004	2	4	2015-05-19

说明：设置id为主键；为customerId字段设置外键约束，参照客户表（customer）的id字段（不执行任何操作）；为saleId字段设置外键约束。

-- 订单表（orders）
CREATE TABLE orders(
	id INT UNSIGNED NOT NULL COMMENT '订单ID',
	customerId INT UNSIGNED NOT NULL COMMENT'客户ID',
	saleId INT UNSIGNED NOT NULL COMMENT'单价',
	orderDate date COMMENT'订单日期',
	notes VARCHAR(50) COMMENT'备注',
	PRIMARY KEY(id),
	FOREIGN KEY(customerId) REFERENCES customer(id),
	FOREIGN KEY(saleId) REFERENCES seller(id)
)ENGINE=INNODB DEFAULT charset=utf8mb4;
INSERT orders(id,customerId,saleId,orderDate,notes)
VALUE('10001','1','3','2015-05-15',''),
('10002','2','2','2015-05-16',''),
('10003','3','2','2015-05-16',''),
('10004','2','4','2015-05-19','');

2、创建订单明细表（orderDetail）

orderDetail(id,orderId,productId,quantity,totalMoney)
orderDetail表数据

ID	订单ID	商品ID	订货数量	订货总额
1	10001	3	227	6492.2
2	10001	6	335	670
3	10001	10	248	520.8
4	10002	1	172	3096
5	10002	3	220	6292
6	10003	1	115	2070
7	10003	7	280	3864
8	10004	2	113	6949.5
9	10004	7	339	4678.2
10	10004	10	325	682.5

说明：设置id为主键；为productId字段设置外键约束。

-- 订单明细表 （orderdetail）
CREATE TABLE orderDetail(
	id INT UNSIGNED NOT NULL auto_increment COMMENT 'ID',
	orderId CHAR(10) COMMENT'订单ID',
	productId INT UNSIGNED COMMENT'商品ID',
	quantity CHAR(5) COMMENT'订货数量',
	totalMoney VARCHAR(9) COMMENT'单价',
	PRIMARY KEY(id),
	FOREIGN KEY(productId) REFERENCES product(id)
)ENGINE=INNODB DEFAULT charset=utf8mb4;
INSERT orderDetail(orderId,productId,quantity,totalMoney)
VALUE ('10001','3','227','6492.2'),
('10001','6','335','670'),
('10001','10','248','520.8'),
('10002','1','172','3096'),
('10002','3','220','6292'),
('10003','1','115','2070'),
('10003','7','280','3864'),
('10004','2','113','6949.5'),
('10004','7','339','4678.2'),
('10004','10','325','682.5');