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 vote194 views1 answer
Mariadb LOAD DATA INFILE
SQL
6 votes198 views1 answer
SQL insert all columns
SQL
1 vote222 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote212 views1 answer
Is not numeric sql
SQL
2 votes164 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote221 views2 answers
Mysql switch case
SQL
0 vote200 views1 answer
Bigquery declare
SQL
0 vote247 views1 answer
How to subquey to do not load in live database in
SQL
0 vote220 views1 answer
Sql update subtract value
SQL
0 vote192 views1 answer
Backup a table in sql
SQL