Sql Mysql Cannot Add Foreign Key Constraint Stack Overflow

Phpmyadmin Mysql Add Foreign Key Constraint Stack Overflow If we want to use the dept id column of the department table as a foreign key for the emp dept id column of emp, then the dept id of department table should atleast be a key if not a primary key. It appears you are putting the foreign key on the wrong table. the column personid on the jobs table should reference the personid on the employee table. if you are assigning persons to jobs, then your original foreign key should be on jobid. this would require adding the jobid to the employees table and removing the personid from the jobs table.

Sql Mysql Cannot Add Foreign Key Constraint Stack Overflow

Sql Server Sql Foreign Key Constraint Stack Overflow

Mysql Cannot Add Foreign Key Constraint Error Stack Overflow

Sql Mysql Error 1215 Cannot Add Foreign Key Constraint