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

6 votes336 views5 answers
Get current date sql
SQL
31 votes341 views3 answers
Sql count(*)
SQL
3 votes365 views1 answer
Postgres add not null to existing column
SQL
0 vote347 views1 answer
Group by sql not ordering issues
SQL
6 votes294 views2 answers
Generate c# class from sql server table
SQL
2 votes343 views1 answer
No data found oracle
SQL
0 vote350 views1 answer
Big table in mysql
SQL
0 vote371 views1 answer
Normalization in database
SQL
0 vote347 views1 answer
Import big data to mysql
SQL
0 vote335 views1 answer
Call function in query sql server
SQL