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 vote272 views1 answer
Sql count matching group by
SQL
2 votes279 views1 answer
Oracle sql merge
SQL
0 vote271 views2 answers
Imageview setimageresource null
SQL
0 vote285 views1 answer
Oracle plsql sleep
SQL
6 votes271 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote265 views1 answer
Mysql update even / odd rows
SQL
0 vote267 views1 answer
Mysql update table from select on another table
SQL
0 vote259 views1 answer
How to create an SQL save method in ruby
SQL
0 vote258 views1 answer
How to find unique key in sql
SQL
1 vote272 views1 answer
Postgresql pass array in function
SQL