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 vote167 views1 answer
Change table to innodb mysql
SQL
7 votes185 views2 answers
Sql remove duplicates based on column
SQL
0 vote150 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote154 views1 answer
QUERY JPQL
SQL
0 vote172 views1 answer
Postgresql port 5432 not open
SQL
17 votes201 views6 answers
MySQL ORDER BY
SQL
0 vote181 views1 answer
Permission denied postgres \copy csv command line
SQL
1 vote160 views1 answer
Sql padd let with zeros
SQL
15 votes160 views2 answers
Sql order by multiple columns
SQL
0 vote178 views1 answer
Space not removing from column in sql
SQL