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 vote224 views1 answer
Plpgsql if statement
SQL
11 votes252 views2 answers
Docker create postgres db
SQL
0 vote214 views1 answer
Sql new line output
SQL
0 vote194 views1 answer
Allow external access to mysql
SQL
1 vote207 views2 answers
Sql where keyword
SQL
0 vote189 views1 answer
Changer un mot de passe mysql
SQL
0 vote209 views1 answer
Cube oracle
SQL
0 vote208 views1 answer
Mysql custom sort order
SQL
0 vote230 views1 answer
How to check oracle index table
SQL
0 vote200 views1 answer
Recursive query herarchical data sql server
SQL