數(shù)據(jù)庫課程設計報告--圖書館管理系統(tǒng)(參考版)
2025-03-26 08:46本頁面
【正文】 create table book_style( bookstyleno varchar(30) primary key, bookstyle varchar(30))create table system_books( bookid varchar(20) primary key, bookname varchar(30) Not null, bookstyleno varchar(30) Not null, bookauthor varchar(30), bookpub varchar(30) , bookpubdate datetime, bookindate datetime , isborrowed varchar (2) ,foreign key (bookstyleno) references book_style (bookstyleno),)create table system_readers ( readerid varchar(9)primary key, readername varchar(9)not null , readersex varchar(2) not null, readertype varchar(10), regdate datetime)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),)create table return_record( bookid varchar(20) primary
范文總結相關推薦
鄂ICP備17016276號-1