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

49 votes245 views6 answers
Install mysql ubuntu
SQL
1 vote149 views1 answer
Oracle update with sequence
SQL
0 vote153 views1 answer
List all indexes postgres
SQL
27 votes183 views5 answers
Mysql set password for user
SQL
14 votes150 views2 answers
Oracle export trigger ddl
SQL
0 vote148 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
-1 vote137 views2 answers
Sql query examples
SQL
0 vote139 views1 answer
Date diff sql
SQL
2 votes169 views1 answer
Coalesce sql
SQL
10 votes182 views6 answers
Mysql set root password
SQL