[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-bugs] Possible failure of GNUmed to void duplicate values on
From: |
Busser, Jim |
Subject: |
Re: [Gnumed-bugs] Possible failure of GNUmed to void duplicate values on a key |
Date: |
Thu, 16 May 2013 15:06:16 +0000 |
On 2013-05-16, at 1:25 AM, Karsten Hilbert <address@hidden> wrote:
>> I mis-typed a name, and so ended up creating the same patient twice.
>>
>> My problem is that I would have expected GNUmed to refuse creation of the
>> patient using a duplicate value for
>>
>> Issuer / ID Type / Value
>
> Only *per patient*. Which wasn't the case.
>
> Karsten
How can we achieve a constraint where an identifier that is supposed to be
unique to a person is not assigned to a second person?
Does it require that the table in which
ID type
lives needs to carry a second column
unique-to-person default true (or false - I prefer true)
which then gets used in a constraint?
-- Jim