[Feature]: Support composite foreign keys when editing table definition in the UI #4100

Describe the new feature

Hello,

SQLite supports composite foreign keys if the destination table's columns form a composite key or have a uniqueness constraint applied.

When creating a table through the UI, I'm surprised that I can't set up this relationship, and can only choose single columns when creating a foreign key, especially when I can pick multiple columns from my source table.

It would be nice to support this in the UI, and to not be misleading when editing an existing composite foreign key relationship in the UI.

My screenshots use version 3.13.1 on Windows.

Thanks.

Does this feature exist in another product or project? Please provide a link

No response

Do you have a screenshot? Please add screenshots to help explain your idea.

Creating a Parent table (all fine here):

Creating a Child table and attempting to add a composite foreign key, but you can only pick one column:

Editing a Child table that was created with a composite foreign key through SQL, where it gets in a muddle on editing: