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

3 votes187 views1 answer
Oracle apex warning message
SQL
0 vote187 views1 answer
Sql drop procedure if exists
SQL
2 votes146 views5 answers
Alter table primary key postgresql
SQL
0 vote223 views1 answer
Mysql limit order by
SQL
4 votes180 views1 answer
Oracle session date format
SQL
2 votes186 views1 answer
Oracle find constraints referencing a table
SQL
1 vote222 views1 answer
Does insert into overwrite sql
SQL
0 vote179 views1 answer
Sql column as header
SQL
2 votes230 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
15 votes186 views5 answers
If null mysql
SQL