图书管理系统数据库设计

图书管理系统

ER图

#
# Structure for table "author"
#

DROP TABLE IF EXISTS `author`;
CREATE TABLE `author` (
  `name` varchar(10) NOT NULL DEFAULT '',
  `workplace` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "author"
#

INSERT INTO `author` VALUES ('书雁','北京'),('仁毅','上海'),('向南','武汉'),('含巧','天津'),('奥然','重庆'),('如冬','大连'),('寒云','盐城'),('山彤','南京'),('张爱玲','北京'),('思乐','北京'),('李娜','北京'),('潇晗','上海');

#
# Structure for table "librarian"
#

DROP TABLE IF EXISTS `librarian`;
CREATE TABLE `librarian` (
  `nameUser` varchar(10) NOT NULL DEFAULT '',
  `password` varchar(10) NOT NULL DEFAULT 'root'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for table "librarian"
#

INSERT INTO `librarian` VALUES ('root','root'),('wangyp','123456');

#
# Structure for table "publisher"