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 vote135 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
18 votes126 views3 answers
Mysql current date
SQL
1 vote120 views1 answer
Mysql batch insert
SQL
1 vote151 views1 answer
Add sequence postgres
SQL
0 vote134 views1 answer
Mysql select where field is a value
SQL
0 vote150 views1 answer
Consulta alias con inner join
SQL
3 votes134 views3 answers
Docker create postgresql database
SQL
3 votes155 views2 answers
How to modify rows in SQL Server
SQL
5 votes127 views1 answer
How to check nls format in oracle
SQL
0 vote207 views1 answer
Mysql delete entire row on condition
SQL