Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TJDB: As a user I want to be able to add unique constraint on column to ensure uniquness of data #9043

Closed
akshaysasidrn opened this issue Mar 8, 2024 · 0 comments

Comments

@akshaysasidrn
Copy link
Collaborator

Is your proposal related to a problem?

There is no means for a user to ensure data uniqueness within a column

Describe the solution you'd like

PRD: link
Design: link

This constraint can be added to a particular column. This constraint makes sure that all values are unique in this column.
It has to be updated in:

  • Create table
  • Edit table
  • Create column
  • Edit column

Note:

  1. A unique column can accept NULL values unless an explicitly NULL constraint is added
  2. For PKs, this constraint cannot be removed, turning off toggle is disabled

image
image

@akshaysasidrn akshaysasidrn added this to the Database 1.1 milestone Mar 8, 2024
@akshaysasidrn akshaysasidrn changed the title As a user I want to be able to add unique constraint on column to ensure uniquness of data TJDB: As a user I want to be able to add unique constraint on column to ensure uniquness of data Mar 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants