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

8 votes161 views1 answer
Insert a select statement into a table
SQL
0 vote131 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
1 vote131 views1 answer
Pl sql create table from another table
SQL
0 vote150 views1 answer
Postgresql select fast check no rows
SQL
2 votes84 views1 answer
Select sid oracle
SQL
8 votes134 views3 answers
Connect python to mysql
SQL
0 vote129 views1 answer
How to count with except in psql
SQL
1 vote143 views2 answers
Mysql between
SQL
1 vote136 views2 answers
Oracle replace
SQL
1 vote135 views1 answer
Check message id sql server
SQL