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 vote345 views1 answer
Copy data from cell to cell mysql
SQL
0 vote375 views2 answers
Unique key
SQL
1 vote345 views1 answer
Sql server kill all connections
SQL
1 vote350 views1 answer
Is sql fast
SQL
0 vote347 views1 answer
How to tell if i have lactose intolerance
SQL
5 votes334 views1 answer
How to use rank function in sql
SQL
0 vote368 views1 answer
C# execute transact sql
SQL
10 votes349 views1 answer
Oracle dependencies table
SQL
4 votes351 views1 answer
Id increment ms sql server
SQL
33 votes338 views2 answers
Postgres how to add field created at
SQL