Re: [Gnumed-devel] clarification of multiplicity of links

[Karsten Hilbert]

> clin_narrative    has only one  lnk_code2narrative 
No. Many rows in lnk_code2narr can point to the same
clin_narrative row. But they must be fulfill
    unique(fk_narrative, code, coding_system)
eg. it doesn't make sense to attach one and the same code
from a given coding system to one particular narrative row.

> vaccination  has only one lnk_vacc2vacc_def
Yes. One vaccination can only be meant to stand for one
particular scheduled vaccination. Eventually, this table might
go away.

> clin_root_item has only one lnk_type2item
No. Many item types can be linked to a particular item row. But
only once per item row. It doesn't make sense to say "this
narrative is Hx" twice for the same narrative (row).

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346