TJDB: As a user I should be able to create primary key on table creation

[akshaysasidrn]

Is your proposal related to a problem?

• The user is unable to change the data type of ID field
• The user is unable to add a custom Primary Key (single and composite)

Describe the solution you'd like

PRD: link
ADR: link

Changes:

• New interface for Table schema (repositioning and pinning of columns are skipped)
• Primary key column is always created with Id for column name of type serial on create table drawer open
• Primary key selection from single to composite is done with checkboxes
• Primary key selection will enable not null constraint for the specific column
• New icon for primary key

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