数据库开发综合案例 - 图书管理系统设计

#请在此添加实现代码 ########## Begin ########## #在library_db库中创建bookrack表 use library_db; CREATE TABLE `bookrack` ( `bookrackId` int(11) NOT NULL, `roomId` int(11) NOT NULL, PRIMARY KEY (`bookrackId`) USING BTREE, INDEX `FK_bookrack_roomId`(`roomId`) USING BTREE, CONSTRAINT `FK_bookrack_bookrackId` FOREIGN KEY (`bookrackId`) REFERENCES `books` (`bookrackId`) , CONSTRAINT `FK_bookrack_roomId` FOREIGN KEY (`roomId`) REFERENCES `books` (`roomId`) ); #在library_db库中创建borrow表 CREATE TABLE `borrow` ( `borrowBookId` int(11) NOT NULL, `bookId` int(11) NOT NULL, `borrowDate` datetime NOT NULL, `returnDate` datetime NOT NULL, PRIMARY KEY (`borrowBookId`) USING BTREE, KEY `FK_borrow_borrowBookId` (`borrowBookId`), KEY `FK_borrow_bookId` (`bookId`), CONSTRAINT `FK_borrow_borrowBookId` FOREIGN KEY (`borrowBookId`) REFERENCES `reader` (`borrowBookId`), CONSTRAINT `FK_borrow_bookId` FOREIGN KEY (`bookId`) REFERENCES `books` (`bookId`) ); ########## End ##########