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 vote275 views1 answer
Mysql create pool
SQL
0 vote261 views1 answer
Oracle select invalid views
SQL
0 vote272 views2 answers
Sql if empty then
SQL
4 votes257 views1 answer
SQL order random
SQL
0 vote264 views1 answer
Sqlserver now
SQL
0 vote290 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
2 votes297 views1 answer
Mysql increment value by 1 in update
SQL
0 vote276 views1 answer
Windows services sql
SQL
0 vote286 views1 answer
Sql tablo sp
SQL
3 votes252 views1 answer
Sql cast to integer
SQL