Front end support for manually creating foreign key constraints

[seancolsen]

Goal

• Allow users to create foreign key constraints through the Table Constraints dialog.

Limitations

• Multi-column FK constraints will not be supported yet. We may add support for that at some point in the future (discussion) but we'll let the need arise organically. During the spec process, it was somewhat unclear when/if we'd support adding multi-column FK constraints, so there are some aspects of the specs which still communicate intent to support it. You can disregard that when implementing this ticket. For example, the video and prototype show a checkbox group to select the constraint columns. That should be a radio group instead so that the user can only select one.

Specs

• In the Foreign Key Constraints Spec, see:
  • the video for Scenario 1
  • the notes for Scenario 1b

Notes

• The specs are somewhat out-of-date with the most current design for the table constraints dialog. We should follow the patterns set within the work to close Frontend work for adding multi-column unique constraints #531.

See also

• Add "Link Table" dialog #947

Status

• Blocked by Modify constraints API to support creating foreign key constraints #942