书店销售管理子系统数据库设计(7)

bookpubdate datetime, bookindate datetime , isborrowed varchar (2) ,

foreign key (bookstyleno) references book_style (bookstyleno), )

3.1.4借书证表建立

create table system_readers ( readerid varchar(9)primary key, readername varchar(9)not null , readersex varchar(2) not null, readertype varchar(10), regdate datetime )

3.1.5借书记录表建立 create table borrow_record

( bookid varchar(20) primary key, readerid varchar(9), borrowdate datetime,

foreign key (bookid) references system_books(bookid), foreign key (readerid) references system_readers(readerid), )

3.1.6还书记录表建立 create table return_record

( bookid varchar(20) primary key, readerid varchar(9), returndate datetime,

foreign key (bookid) references system_books(bookid), foreign key (readerid) references system_readers(readerid) )

3.1.7罚款单表建立*/

create table reader_fee

( readerid varchar(9)not null,

readername varchar(9)not null , bookid varchar(20) primary key,