圖書(shū)館管理系統(tǒng)結(jié)構(gòu)圖-資料下載頁(yè)
2025-08-11 01:23本頁(yè)面
【正文】 ertible_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 datetime NOT NULL, summary varchar(300) NULL)創(chuàng)建Lossbook表 CREATE TABLE Lossbook( book_id int CONSTRAINT FK_Lossbook_Book FOREIGN KEY REFERENCES Book(book_id), reader_id int CONSTRAINT [FK_Lossbook_reader] FOREIGN KEY REFERENCES reader(reader_id), loss_date datetime NOT NULL) 謝謝欣賞?。 ?
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號(hào)-1