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

Having unique constraint on multiple fields #1212

Open
Gojo-Taqi opened this issue Dec 1, 2023 · 0 comments
Open

Having unique constraint on multiple fields #1212

Gojo-Taqi opened this issue Dec 1, 2023 · 0 comments

Comments

@Gojo-Taqi
Copy link

Motivation

Poshan sathi users who share the same locations, often trade their location to visit beneficiaries on the field. They then end up registering the individual on the device again, creating a duplicate.
The issue is only identified when the supervisors filter out the report for the month and they see there are beneficiaries with the same name and DOB.
The users should not be allowed to register duplicate individuals.

Acceptance Criteria

The current solution provides only having a unique "Name" which is not applicable in this case, as there are multiple beneficiaries with the same name.

Having a unique constraint on name and on DOB or on an other field should solve the issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: New Issues
Development

No branches or pull requests

1 participant