数据库表设计什么时候用怎么用双向关联

Question

我刚学hibernate里面讲了双向关联，我设计了表student 字段id,name,teacherid,teacher表字段id,name,studentid teacherid关联teacher的id，studentid关联student表的id,然后我想插入其中一张表的时候，无法插入数据

报错信息：Cannot add or update a child row: a foreign key constraint fails (upload/student, CONSTRAINT FK_Reference_2 FOREIGN KEY (teacherid) REFERENCES teancher (id))，难道双向关联的表不能存记录

Answer 1

你试试这个数据表看
student 字段id,name
teacher表字段id,name
student_teacher表字段teacherid,studentid, primary key(teacherid, studentid)