Re: [Gnumed-devel] Medication tweaks

[Karsten Hilbert]

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.

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