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 vote362 views1 answer
Date 3 months from today sql
SQL
0 vote314 views1 answer
Call function in query sql server
SQL
1 vote315 views6 answers
In sql
SQL
0 vote313 views1 answer
Add plugins to mysql workbench
SQL
3 votes340 views5 answers
Foreign keys
SQL
0 vote349 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote352 views1 answer
Login failed for user sql server
SQL
51 votes696 views6 answers
Installing mysql on ubuntu
SQL
0 vote324 views1 answer
Mysql select where field is a value
SQL
17 votes315 views6 answers
Mysql import sql file
SQL