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 vote138 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
1 vote130 views1 answer
Regular expression in sql server
SQL
7 votes135 views1 answer
Sql management studio display line numbers
SQL
1 vote127 views1 answer
Reutrn string after character sql
SQL
1 vote156 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote129 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
1 vote121 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote137 views1 answer
Compare two tables to find unmatched records
SQL
0 vote91 views1 answer
Deleted table in sql trigger
SQL
0 vote133 views1 answer
2020 new year
SQL