tb_stdbook.sql

来自「学生管理系统」· SQL 代码 · 共 8 行

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)
);