Reason for missing constraints users tables

Hello,

I have noticed missing unique constraint on uuid column for the users table. Want to confirm if it is a design decision or it just got missed.

We are working on syncing different openmrs instances on database level depending on uuid. Curious if there’s any reason behind the design.

Latest version i checked was 2.1.4.

We just missed it.

2 Likes