Can we create additional unique index in OpenSpecimen? We need to maintain unique samples within the 3 CPs in addition to having unique samples within a CP.
Ex.
CP1, CP2, CP3 - Sample#1 does not exist in CP1, CP2, CP3.
Sample#1 added to CP1 → now exists in CP1
Sample#1 added to CP2 → not allowed
Sample#1 added to CP3 → not allowed
CP4 - Sample#1 added to CP4 → allowed
- Sample#1 added to CP4 → not allowed
CP5 - Sample#1 added to CP5 → allowed
- Sample#1 added to CP4 → not allowed
Thanks,
Tina