TJDB: As a user I should be able to edit/delete foreign key on a table

[akshaysasidrn]

Is your proposal related to a problem?

The user should be able to edit/delete foreign keys on a table post its creation

Describe the solution you'd like

PRD: link
ADR: link
Design: link

• Changes in FK should be shown in a confirmation modal
• Deletion of foreign key should be shown with a confirmation modal

Constraints to note:

• Referential integrity: foreign key must reference an existing primary key value in another table or be nullable
• Matching data types: foreign key and the referenced primary key must have matching or compatible data types
• Deletion and Update rules: Set rules to avoid or allow orphaned rows in target table