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 vote347 views1 answer
Mysqlcli how to load external sql file
SQL
4 votes328 views1 answer
Postgresql show current database
SQL
1 vote353 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
1 vote329 views1 answer
Crontab every month
SQL
3 votes342 views2 answers
Mysql create timestamp column
SQL
0 vote346 views1 answer
Oracle db get table sizes
SQL
1 vote363 views1 answer
How to fetch alternate records from two tables
SQL
4 votes370 views1 answer
Data types in sql
SQL
0 vote369 views1 answer
Table user postgres
SQL
0 vote333 views1 answer
Oracle list index on table
SQL