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

5 votes312 views5 answers
Sqlite install python
SQL
1 vote294 views1 answer
Psql client write to bash variable
SQL
0 vote287 views2 answers
Sql drop view if exists
SQL
0 vote276 views2 answers
Sqlite
SQL
1 vote317 views1 answer
Mysql connect bash
SQL
12 votes313 views2 answers
Insert multiple rows from another table sql
SQL
5 votes294 views3 answers
Oracle list columns in schema
SQL
0 vote297 views1 answer
Sql character index
SQL
1 vote294 views1 answer
Set autoincrement to 0
SQL
0 vote289 views1 answer
Sql drop default
SQL