圖書館管理系統(tǒng)結(jié)構(gòu)圖-文庫吧資料
2024-08-24 01:23本頁面
【正文】 add_date datetime NOT NULL) 創(chuàng)建borrowbook表 CREATE TABLE borrowbook( reader_id int CONSTRAINT FK_borrowbook_reader FOREIGN KEY REFERENCES reader(reader_id), book_id int CONSTRAINT FK_borrowbook_Book FOREIGN KEY REFERENCES Book(book_id), borrpw_date datetime NOT NULL, revertible_date datetime NOT NULL, CONSTRAINT [PK_sno_CNO] PRIMARY KEY (book_id,reader_id) ) 創(chuàng)建reader表 CREATE TABLE reader( reader_id int IDENTITY(1,1) CONSTRAINT [PK_reader] PRIMARY KEY CLUSTERED , student_id varchar(50) NOT NULL, reader_name varchar(50) NOT NULL, age int NOT NULL, academy varchar(30) NOT NULL, department varchar(50) NOT NULL, register da
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號-1