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

15 votes172 views4 answers
Create table if not exists sql
SQL
4 votes171 views2 answers
Oracle default date format
SQL
0 vote175 views1 answer
How to select a row in sql
SQL
0 vote195 views1 answer
Ubuntu connect to mssql database
SQL
0 vote164 views1 answer
Sql roll up rows into columns
SQL
6 votes215 views3 answers
Mysql remove user privileges
SQL
4 votes122 views1 answer
And or sql order of operations
SQL
1 vote174 views1 answer
Search for tables with name postgresql
SQL
0 vote189 views1 answer
Datagrip exec
SQL
0 vote174 views1 answer
How to find all children of a record with only parent ID in sql
SQL