[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] Medication tweaks

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Medication tweaks
Date: Wed, 22 Jun 2011 14:48:01 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

On Tue, Jun 21, 2011 at 08:47:14PM -0700, Jim Busser wrote:

> >> 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

That does not matter. Such drugs can be deleted.

> is it maybe safe to remove (from the reference tables)

It is not about "safe to remove" but "(technically)
impossible to remove".

> 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

Those already exist.

> 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

That's an old table from when we still had
ref.consumed_substance. It holds old audit data.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]