Ensure non-key columns are nullable or auto-generated error (reoccurance)

[qa-wolf]

Steps to reproduce:

1. Log into budibase
2. Create a new app
3. Create a table for the app
4. Connect to MySQL
5. Bring in your tables from MySQL
6. Go to define relationships
7. When inputted the following information into the table observe "Ensure non-key columns are nullable or auto-generated error"

• Many rows in departments
• Too many rows in employees
• Through: dept_emp
• Foreign Key (departments): dept_no
• Foreign Key (employees): emp_no
  Expected: Able to define relationships successfully.
  Actual: Unable to define relationships and receive "Ensure non-key columns are nullable or auto-generated error"
  Video (https://www.loom.com/share/ef773b799b12455c950928f89ccd2a77?sid=e9cfaa09-dcfe-4a79-8182-3dd5b95b02a9)

[linear]

BUDI-8999 Ensure non-key columns are nullable or auto-generated error (reoccurance)

[mike12345567]

Closing as dupe of: #15270