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 vote132 views4 answers
Change schema in sql server
SQL
0 vote120 views1 answer
Array aggre distinct postgres
SQL
0 vote130 views1 answer
Primary key multiple colums
SQL
1 vote145 views1 answer
OSError: mysql_config not found
SQL
4 votes135 views3 answers
Rename table column postgresql
SQL
1 vote126 views1 answer
Oracle create program if no exists
SQL
0 vote133 views1 answer
Mysql set boolean default value
SQL
0 vote117 views1 answer
INSERT INTO table using OpenQuery
SQL
3 votes130 views1 answer
Sql is not like
SQL
0 vote125 views1 answer
How to increase the width of the screen in oracle
SQL