Prevent duplicate Patient (ID) records by DB Unique Constraint

[gunterze]

Prevent duplicate Patient (ID) records by DB Unique Constraint ("pat_id, entity_id, entity_uid, entity_uid_type") on table patient_id and supplementing missing

Attribute	Tag	Supplemented Value
Issuer of Patient ID	(0010,0021)	{>Universal Entity ID} if present, otherwise unknown¹
Issuer of Patient ID Qualifiers Sequence	(0010,0024)
>Universal Entity ID	(0040,0033)	iss:{Issuer of Patient ID}
>Universal Entity ID Type	(0040,0033)	URI

¹ In the case, there is already such Patient ID with Issuer of Patient ID (0010,0021) = unknown, Issuer of Patient ID (0010,0021) will be set to unknown.{n}, with {n} the lowest number starting with 1, which does not match with an already existing Patient ID.