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 vote315 views1 answer
Zerar auto increment mysql
SQL
1 vote304 views1 answer
How to truncate a table in databse
SQL
6 votes332 views2 answers
How to copy data in sql
SQL
1 vote322 views1 answer
Sql upsert
SQL
1 vote355 views1 answer
Floor function in sql oracle
SQL
3 votes312 views2 answers
Oracle apex view logs
SQL
3 votes295 views2 answers
Oracle sql truncate table
SQL
0 vote308 views2 answers
Sql server set default value equal to auto increment
SQL
1 vote299 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote298 views1 answer
Mysql update sum same table
SQL