前言:有两个表order和item,数据库模型如下:
sql:
/*
Navicat MySQL Data Transfer
Source Server : lalala
Source Server Version : 50720
Source Host : localhost:3306
Source Database : test
Target Server Type : MYSQL
Target Server Version : 50720
File Encoding : 65001
Date: 2018-07-05 17:10:13
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for item
-- ----------------------------
DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
`id` int(11) NOT NULL,
`content` varchar(255) DEFAULT NULL,
`order_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fk_item_order_01` (`order_id`),
CONSTRAINT `fk_item_order_01` FOREIGN KEY (`order_id`) REFERENCES `order`