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

1 vote323 views1 answer
Mysql find most common value
SQL
0 vote288 views2 answers
Close external port 3306 with iptables
SQL
2 votes294 views2 answers
Postgresql search all tables for column name
SQL
0 vote307 views1 answer
000webhost database values insert
SQL
12 votes269 views1 answer
How to change the value of a table in sql
SQL
3 votes289 views2 answers
Mysql create timestamp column
SQL
10 votes263 views2 answers
Mysql select timestamp group by day
SQL
0 vote292 views1 answer
Creating a simple notify in postgresql
SQL
0 vote323 views1 answer
Combine 2 columns search query mysql
SQL
0 vote298 views1 answer
Dbms_output sql developer
SQL