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 vote191 views2 answers
Oracle create synonym
SQL
0 vote169 views1 answer
Function sum(text) does not exist postgres
SQL
2 votes167 views1 answer
No data found oracle
SQL
0 vote168 views1 answer
Close sql query vb.net
SQL
-1 vote169 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote181 views1 answer
Select tables with name like mysql
SQL
1 vote186 views1 answer
Mysql text to decimal
SQL
-1 vote177 views1 answer
Spring boot mysql connection properties
SQL
2 votes214 views3 answers
How to replace null values in sql
SQL
0 vote188 views3 answers
Delete in SQL SERVER
SQL