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 vote330 views1 answer
Postgresql get diff between two dates in Months
SQL
18 votes336 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote333 views1 answer
Oracle activate program
SQL
10 votes386 views4 answers
Join multiple tables in sql
SQL
10 votes319 views2 answers
Sql merge statement
SQL
4 votes321 views1 answer
Restart for pg_hba.conf file
SQL
1 vote331 views1 answer
Mysql select for update ejemplo
SQL
0 vote336 views1 answer
Open postgresql.conf in centos
SQL
0 vote337 views1 answer
Bidirectional outer join sql
SQL
0 vote325 views1 answer
Php select data from mysql database without column name
SQL