Re: [Gnumed-devel] Fwd: Medication tweaks

[Jim Busser]

On 2011-06-21, at 2:06 AM, Karsten Hilbert wrote:

> You might want to consider using staging tables in the
> staging. schema from which you can delete any way you wish,
> the import all your data, then mark in staging. all the data
> that's already in use in the clin./ref. schemas, then import
> from staging. all the non-marked data and update from
> staging. all the marked data. Then dump staging. again.

Presently in the schema

        
http://publicdb.gnumed.de/~ncq/gnumed/schema/gnumed_v15/gnumed-schema.html#ref.schema

there exists

        ref.atc_staging
        ref.loinc_staging

and

        staging.lab_request
        staging.test_result

So

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

        staging.branded_drug
        staging.consumable_substance

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

(which approach I could add to the wiki at

        http://wiki.gnumed.de/bin/view/Gnumed/NamingConventions

maybe renaming the heading "database" to "database and staging" ??


-- Jim