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

10 votes147 views4 answers
Else if mysql
SQL
0 vote117 views2 answers
Postgresql display subquery as json
SQL
12 votes131 views4 answers
Mysql get date difference in hours
SQL
0 vote169 views1 answer
Wordpress sql find and replace
SQL
-1 vote148 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote177 views1 answer
Prisma transaction
SQL
4 votes138 views2 answers
Oracle default date format
SQL
0 vote135 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote175 views2 answers
How to install psql in ubuntu
SQL
0 vote154 views1 answer
Sql server create constraint
SQL