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

0 vote150 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote185 views1 answer
SQL get max per id
SQL
17 votes150 views3 answers
Cast in sql server
SQL
0 vote121 views2 answers
Delete the last item in a table sql
SQL
0 vote131 views1 answer
Lister les index d'une table oracle
SQL
0 vote166 views1 answer
Create query in where clasue
SQL
0 vote151 views1 answer
Désinstaller postgresql linux
SQL
3 votes143 views1 answer
Sql multiple column index
SQL
25 votes166 views5 answers
Uninstall mysql ubuntu
SQL
1 vote217 views1 answer
Column with prefix in sql
SQL