CREATE TABLE IF NOT EXISTS `book`(
`bid` VARCHAR(128) PRIMARY KEY COMMENT'图书编号',
`bName` VARCHAR(128) COMMENT'图书书名' NOT NULL,
`author` VARCHAR(128) COMMENT'作者姓名',
`pubComp` VARCHAR(128) COMMENT'出版社',
`pubDate` DATE COMMENT'出版日期',
`bCount` INT COMMENT'现存数量',
`price` FLOAT COMMENT'单价'
);
CREATE TABLE IF NOT EXISTS `reader`(
`rid` VARCHAR(128) PRIMARY KEY COMMENT'读者编号',
`rName` VARCHAR(128) COMMENT'读者姓名' NOT NULL,
`lendNum` INT COMMENT'已借书数量',
`rAddress` VARCHAR(128) COMMENT'联系地址'
);
CREATE TABLE IF NOT EXISTS `borrow`(
`rid` VARCHAR(128) COMMENT'读者编号',
`nif` VARCHAR(128) COMMENT'图书编号',
`lendDate` datetime NOT NULL DEFAULT NOW(),
`willDate` DATE COMMENT'应归还日期',
`returnDate` DATE COMMENT'实际归还日期',
PRIMARY KEY (`rid`,`nif`,`lendDate`)
);
CREATE TABLE IF NOT EXISTS `penalty`(
`rid` VARCHAR(128) COMMENT'读者编号',
`nif` VARCHAR(128) COMMENT'图书编号',
`pDate` DATE COMMENT'罚款日期',
`pType` INT COMMENT'罚款类型',
`amount` FLOAT COMMENT'罚款金额',
PRIMARY KEY(`rid`,`nif`,`pDate`),
CONSTRAINT `fk_type` FOREIGN KEY (`pType`) REFERENCES `type` (`pNo`)
);
CREATE TABLE IF NOT EXISTS `type`(
`pNo` INT COMMENT'类型编号' PRIMARY KEY,
`pType` VARCHAR(128) COMMENT'罚款类型'
);
第1章 课后作业
最新推荐文章于 2021-02-25 18:33:05 发布