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 vote209 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote285 views1 answer
Dockerfile example for Django
SQL
7 votes194 views1 answer
Mysql remote connection command line
SQL
0 vote204 views1 answer
Insert or update sql firebird
SQL
6 votes192 views1 answer
What is where clause in sql
SQL
0 vote179 views1 answer
Sql remove last x char
SQL
0 vote176 views1 answer
Metada in sql
SQL
0 vote199 views1 answer
Postgres sequence name
SQL
0 vote193 views1 answer
T sql return on letters only
SQL
5 votes193 views1 answer
Oracle nls session
SQL