圖書館管理系統(tǒng)結(jié)構(gòu)圖(文件)
【正文】 r(100) NOT NULL, author varchar(100) NOT NULL, publisher varchar(80) NOT NULL, price float NOT NULL, amount int NOT NULL, total_amount int NOT NULL, 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_
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號-1