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

12 votes177 views1 answer
Create column sql server
SQL
0 vote181 views1 answer
Mysql grant access to one database
SQL
3 votes174 views2 answers
Having in mysql
SQL
20 votes177 views2 answers
Counting in sql
SQL
-1 vote216 views1 answer
Mysql faster insert
SQL
0 vote181 views1 answer
Restore backup mysql .gz
SQL
36 votes183 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote204 views2 answers
Faster mysql imports
SQL
0 vote185 views1 answer
Alter table add check constraint oracle
SQL
0 vote171 views1 answer
Show create table in postgresql
SQL