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 votes164 views1 answer
Database backup in mysql server recovery
SQL
7 votes129 views1 answer
Forge server hosting
SQL
0 vote187 views1 answer
Modificar tipo de dato sql server
SQL
0 vote145 views1 answer
Select the date 30 days less that the todays date sql request
SQL
1 vote153 views2 answers
Insert sqlite
SQL
0 vote197 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote156 views1 answer
Drop column from table if exist on live server mysql
SQL
1 vote141 views1 answer
What is in condition in sql
SQL
0 vote143 views1 answer
C# check if mysql query modified rows
SQL
1 vote231 views1 answer
Mysql monthname
SQL