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 vote358 views1 answer
Copy Table from SQL to CSV
SQL
0 vote357 views1 answer
Codeigniter 3 get best-selling products
SQL
17 votes381 views6 answers
What is cursor in sql server with example
SQL
7 votes359 views6 answers
Group_concat mysql
SQL
6 votes371 views2 answers
Non relational database
SQL
5 votes334 views1 answer
Mysql select greater than yesterday
SQL
7 votes407 views1 answer
Oracle pagination query rownum
SQL
0 vote352 views1 answer
Postgres data location
SQL
0 vote357 views1 answer
Oracle INTERVAL DAY to second to number
SQL
18 votes383 views3 answers
Mysql add column default value
SQL