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 vote195 views1 answer
Lost connection to mysql
SQL
0 vote227 views1 answer
Foreign key type uniqu mysql
SQL
10 votes230 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote195 views1 answer
Set column in all row mysql
SQL
3 votes303 views1 answer
Postgresql today - 1 year
SQL
2 votes249 views2 answers
How to add not null constraint in sql
SQL
0 vote196 views1 answer
How to start my sql server on mac
SQL
0 vote276 views1 answer
Liquibase update row
SQL
0 vote224 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote212 views2 answers
Change database postgres
SQL