Unique Constraint in Couchdb

Question

Is there any way to apply unique constraint in couchdb?

Suppose I have a document which have some fields like email, emp_id, phone_number that needs to be unique throughout the document. I could not find any way. Anyone knows how to achieve this?

Any answer/suggestion would be appreciated.

Possible duplicate of [Couchdb - how to set a field containing unique key](https://stackoverflow.com/questions/21531624/couchdb-how-to-set-a-field-containing-unique-key) — Jonathan Hall, Apr 24 '18 at 12:10

score 1 · Answer 1 · answered Apr 24 '18 at 12:10

1

The only unique constraint in CouchDB is on the document ID. If you can put the unique components of your data in the document ID, then you have a uniqueness constraint.

answered Apr 24 '18 at 12:10

Jonathan Hall

75,165
16
143
189

@Filmzy, how can I put multiple components in documentID? – Akshay Sood Apr 24 '18 at 12:30
That's up to you. Your id can be any valid string. Something like "123-456" would be the obvious way to include ids 123 and 456. – Jonathan Hall Apr 24 '18 at 12:37

score 1 · Accepted Answer · answered Jul 17 '18 at 16:57

1

after a lot of searching, I found that If you want to add a unique constraint to only one parameter you can set it as id. But If there are multiple parameter that needs to be unique, then this is not possible in couchdb

answered Jul 17 '18 at 16:57

Debut Infotech

472
5
17

Unique Constraint in Couchdb

2 Answers2

Linked