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 vote163 views1 answer
Sqlite display headers on columns
SQL
0 vote126 views1 answer
Get who is hired in february in sql
SQL
2 votes103 views1 answer
Sql to char function with date
SQL
1 vote127 views1 answer
Set statiscis on in ssms
SQL
2 votes114 views2 answers
Enable foreign key checks postgres
SQL
7 votes136 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote118 views1 answer
What is SQL data store?
SQL
1 vote128 views1 answer
Mysql limit results to 10
SQL
0 vote133 views1 answer
Generate random & unique mysql string
SQL
11 votes135 views4 answers
Reset identity column values in sql server
SQL