Hello
I have below Supplier data model

How can i prevent entering a duplicate value?
In the portal, it is designed to add, edit delete but it allows to enter duplicate data

I'm not sure how unique constraint works here but I added an Indexes unique constraint but it doesn't work. Please advice

Below is the values on index column, unique is also ticked

Thanks in advance