Re: [Gnumed-devel] Fwd: Medication tweaks

[Karsten Hilbert]

On Tue, Jun 21, 2011 at 08:33:22PM -0700, Jim Busser wrote:

> 1) is it suggested any additional drug pack staging tables should become 
> (e.g.)
> 
>       staging.branded_drug
>       staging.consumable_substance

Yes, although it is entirely up to the data pack which
staging tables to use.

Data packs are free to create staging tables as they see fit.

Once a pattern emerges (like, drug data packs always create
staging.substance, staging.brand and always move that into
ref.branded_substance, etc) that pattern can be built into
GNUmed itself.

> 2) for the purpose of improved maintainability, can scripts / bootstrappers 
> which currently use
> 
>       ref.atc_staging
>       ref.loinc_staging
> 
> be migrated with the next db upgrade to
> 
>       drop ref.atc_staging
>       drop ref.loinc_staging
> 
> and from them on, create and use
> 
>       staging.atc
>       staging.loinc

That will be done when/by whom the next ATC/LOINC data pack
is developed.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346