Re: [Gnumed-devel] clin_medication

[Karsten Hilbert]

> Maybe we can use something like a local and permanent cache
> of all drugs one or more doctor is using. I.e. we don't store
> the details of the prescribed drug in clin_medication. Instead
> something like a "minimal defining drug data set" is stored in
> some other table, caching them for further use.
Brilliant ! We did discuss this before as a local in-house
often-used intermediate drug list but it never occurred to me
that that might also solve the issues with clin_medication.
This is quite in line with a shinobi tactics of turning a
weakness into a strengths, eg. we are turning redundancy into
a virtue. (hint, hint: miniproject: write a check the [yet to
be written] external integrity check demon to look for stale
drug database links on cache entries).

Here's a request for submissions on what the intermediate drug
data tables, eg. the "minimal drug dataset", must look like ...

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