TJDB: As a user I should be able to edit the Primary key for a table

[akshaysasidrn]

Is your proposal related to a problem?

The user should be able to update the Primary key for a table.

Describe the solution you'd like

PRD: link
ADR: link
Design: link

• From the edit table drawer user should be able to change the PK checkboxes and save changes to the table.
• Upon clicking save, a modal should open which indicate the PK changes
• On save the success/error message should be shown as a toast

Note: Editing PK can be from single to composite or vice-versa

Constraints to note:

Constraints to note:

• Not-Null: Primary Key Fields by default become NOT NULL
• Uniqueness: Upon data entry, Primary Key Fields have to be checked for uniqueness
• Data Type Compatibility: Primary Key Fields must have compatible data types
• Immutable Data Types: Once set, primary key values can not be edited
• Composite Key Limitation: Data length for composite key will depend upon underlying data length of fields selected to be primary key