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 vote197 views1 answer
Oracle compile schema
SQL
1 vote165 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote193 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
1 vote171 views1 answer
Mysql history command
SQL
0 vote156 views1 answer
Create date sql
SQL
5 votes222 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote207 views1 answer
Oracle list user locked
SQL
1 vote172 views1 answer
MySQL AND Operator
SQL
2 votes157 views1 answer
Ifnull postgres
SQL
0 vote164 views1 answer
Case insensitive sql
SQL