【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供join_nn.sql参考,解决您在join_nn.sql学习中工作中的难题,参考学习。
CREATE TABLE hibernatedb.join_nn (
studentid int(10) NOT NULL,
classid int(10) NOT NULL,
PRIMARY KEY (studentid,classid),
KEY fk1(studentid),
KEY fk2 (classid),
CONSTRAINT fk1 FOREIGN KEY (classid) REFERENCES classmanytomany (classid),
CONSTRAINT fk2 FOREIGN KEY (studentid) REFERENCES studentmanytomany (studentid)
)