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 vote346 views1 answer
C# sql transaction multiple connections
SQL
0 vote328 views1 answer
Login failed for user sql server
SQL
7 votes311 views3 answers
Select latest entry in sql table
SQL
0 vote289 views1 answer
Heavy table in mysql
SQL
1 vote295 views1 answer
Neo4j display all nodes and relationships
SQL
1 vote338 views1 answer
Nullif postgresql
SQL
0 vote310 views1 answer
Assign value to var in SQL
SQL
0 vote325 views1 answer
Oracle exchange subpartition
SQL
1 vote288 views1 answer
Select statement to print longest name
SQL
7 votes328 views5 answers
Oracle alter table
SQL