tb_stdbook.sql

学生管理系统

create table Tb_StdBook_Info(
	Users_ID INTEGER,
	Book_No INTEGER,
	Loan_Date DATETIME,
	Due_Date	DATETIME,
	foreign key (Book_No) references Tb_Book_Info (Book_No),
	foreign key (Users_ID) references Tb_User_Info (Student_ID)
);