Re: [Gnumed-devel] is this correct?

[Karsten Hilbert]

> in gmclinical , there's a usage of a integer array for fk_vacc_indication
> fk_vacc_indications integer[] not null references vacc_indication(id),
>
> If it's supposed to be many-to-many,
one-to-many

> isn't it better  to have a 
> separate/link reference_table pointing
> to  vaccination and indication rows and drop this field? ( there is one?)
>  It looks non-portable as well.
I agree it was a dumb move to use the array there and it was
my idea to do so. Will fix that ASAP. I do maintain that it is
OK to use an array for the str_array config table as there the
actual *value* IS a list whereas in fk_vacc_indication it is a
collection of foreign keys which cries for a link table.

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