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

2 votes222 views3 answers
Sql delete duplicate
SQL
0 vote236 views2 answers
SQL Server Standard
SQL
1 vote268 views1 answer
Psql connect
SQL
0 vote184 views1 answer
Insert thai language sql server
SQL
1 vote306 views1 answer
Sql server delete top 1000
SQL
0 vote229 views1 answer
Microsoft word insert sql code
SQL
1 vote215 views1 answer
Sqlserver create table from select
SQL
9 votes260 views3 answers
Postgres make sql dump
SQL
0 vote246 views1 answer
Sqlalchemy sequence postgresql
SQL
23 votes215 views3 answers
Sql where contains part of string
SQL