數(shù)據(jù)庫(kù)課程設(shè)計(jì)報(bào)告--圖書(shū)館管理系統(tǒng)(參考版)
2025-01-21 21:54本頁(yè)面
【正文】 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
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1