资源介绍
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50524
Source Host : localhost:3306
Source Database : bookstore
Target Server Type : MYSQL
Target Server Version : 50524
File Encoding : 65001
Date: 2016-01-06 10:50:08
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `book`
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
`bookid` int(11) NOT NULL,
`catalogid` int(11) NOT NULL,
`bookname` varchar(20) NOT NULL,
`price` int(11) NOT NULL,
`picture` varchar(30) NOT NULL,
PRIMARY KEY (`bookid`),
KEY `FK_Relationship_3` (`catalogid`),
CONSTRAINT `FK_Relationship_3` FOREIGN KEY (`catalogid`) REFERENCES `catalog` (`catalogid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of book
- 上一篇: 数据分析流程案例(电商零售数据分析).ipynb
- 下一篇: 应届生简历模板