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 vote216 views1 answer
Mysql command line ubuntu
SQL
0 vote218 views1 answer
This week mysql
SQL
0 vote202 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote221 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote238 views1 answer
Postgresql stored procedure update table values
SQL
32 votes246 views6 answers
Rename column mysql
SQL
0 vote219 views1 answer
Sql server user permissions and roles
SQL
1 vote217 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
2 votes245 views1 answer
Oracle Column Names of a table
SQL
0 vote330 views5 answers
Right join
SQL