Re: [Gnumed-devel] Medication tweaks

[Jim Busser]

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

> Yes.
> 
>> and -- before even doing this -- one must be willing to delete all cases 
>> where the drug is currently used with a patient (for example Kirk)
> 
> One could just not delete those which are in use.
> 
>> and so, *provided* there is complete certainty that there
>> is no clinical data needed for any patients in the
>> production database (in which Kirk's record might still
>> live),
> 
> This assumption does not help the next time you would want
> to update your list.

How is the proposal to delete those "which are not in use" affected when a drug 
in

        clin.substance_intake

is no longer currently in use, but it *was* previously in use, and lives now in 
the audit table

        log_substance_intake

?? is it maybe safe to remove (from the reference tables) those substances or 
brands which are no longer *currently* in use, on account of the audit system 
extending to more than just clinical records but also including some reference 
tables e.g.

        ref.consumable_substance --> log_consumable_substance

also, what is the source of records which (upon alteration) go into the 
following, or is the following redundant to log_substance_intake

        log_consumed_substance

??

-- Jim