Mysql error 1215

I'm guessing that Clients.Case_Number and/or Staff.Emp_ID are not exactly the same data type as Clients_has_Staff.Clients_Case_Number and Clients_has_Staff.Staff_Emp_ID.

Perhaps the columns in the parent tables are INT UNSIGNED?

They need to be exactly the same data type in both tables.

Mysql error 1215

When you are trying to reference a key on parent table which is not a candidate key (either a primary key or a unique key) you may get the error code: 1215 cannot add foreign key constraint. ... It does not necessarily to be a primary key. MySQL requires index on corresponding referenced key, so you need a unique key

Similar codes

2 votes59 views1 answer
Sql select min value from multiple columns
SQL
15 votes109 views2 answers
How to drop database name in postgresql
SQL
14 votes110 views4 answers
Sql compiler
SQL
4 votes98 views1 answer
Psql get sequences
SQL
0 vote105 views3 answers
Find below average salary in sql
SQL
1 vote107 views1 answer
Sample in sql
SQL
0 vote106 views1 answer
Search mysql database for column
SQL
0 vote108 views1 answer
Postgresql custom order by
SQL
2 votes109 views1 answer
Find all triggers in database
SQL
1 vote96 views1 answer
Oracle lock user
SQL