数据库sql语言.sql

来自「模拟图书馆管理系统 实现了各种图书馆管理功能」· SQL 代码 · 共 37 行

读者信息
create table Reader(
 id char(10) primary key,
 password char(20),
 name char(20),
 sex char(4),
 department char(20),
 birth_year int,
 birth_month int,
 Email char(30)
)

书籍信息
create table Book(
id char(30) primary key,
name char(30),
sort char(20),
author char(20),
publish char(30),
introduction char(1000),
price float,
cover image 
)

借阅信息
create table borrow(
 readerId char(10),
 bookId char(30),
 borrowTime char(30),
 primary key(readerId,bookId),
 foreign key(readerId)references Reader(id),
 foreign key(bookId) references Book(id)
)

create unique index readerIndex on reader(id)
create unique index bookIndex on book(id)
create unique index borrowIndex on borrow(readerId,bookId)