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 vote153 views1 answer
Psql not found windows
SQL
3 votes201 views1 answer
Sql print all names that start with a given letter
SQL
27 votes224 views3 answers
Mysql show tables in database
SQL
1 vote188 views1 answer
Can not connect to mysql server
SQL
0 vote202 views1 answer
Mysql command line ubuntu
SQL
4 votes298 views2 answers
Convert utc to est sql
SQL
0 vote259 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
5 votes175 views2 answers
Oracle list columns schema
SQL
0 vote221 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
1 vote197 views1 answer
Sometimes i cant edit sql developer
SQL