[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: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-bugs] Possible failure of GNUmed to void duplicate values on a key |
Date: |
Thu, 16 May 2013 18:29:09 +0200 (CEST) |
> 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?
That can be achieved by making the constraint unique to the whole table
rather than to the patient column within. IOW by leaving out the fk_identity
from the constraint. Then, no identifier can be assigned to several
patients.
Karsten