'Foreign key incorrectly formed MySQL workbench

I am using MySQL workbench. I have made sure that the foreign key in my parent and child table are defined in the same terms: BIGINIT(20) UNIQUE, and yet I am still getting the 1005 error that says that the child table cannot be created because my foreign key constraint is incorrectly formed. I can't see what I am doing wrong this is a screenshot of my workbench.

Defining my child table and on the left, properties of the primary key column in parent table:
Defining my child table and on the left, properties of the primary key column in parent table

mysqlforeign-keys


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions