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 vote209 views10 answers
John the ripper mysql
SQL
0 vote233 views1 answer
Sql commands in android
SQL
2 votes174 views1 answer
Oracle index size calculation
SQL
11 votes195 views1 answer
Sql insert multiple rows from select
SQL
6 votes193 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote170 views2 answers
Add new column after in sql
SQL
5 votes315 views2 answers
Mysql date greater than 30 days
SQL
0 vote185 views1 answer
Not equal to blank in mysql
SQL
0 vote204 views1 answer
Stratified sampling sql
SQL
7 votes178 views2 answers
Mysql db size
SQL