[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.
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- [Gnumed-devel] Medication tweaks, Jim Busser, 2011/06/17
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/17
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/17
- Re: [Gnumed-devel] Medication tweaks, Rogerio Luz Coelho, 2011/06/18
- Re: [Gnumed-devel] Medication tweaks, Jim Busser, 2011/06/22
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/22
- Re: [Gnumed-devel] Medication tweaks, Jim Busser, 2011/06/22
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/22
- Re: [Gnumed-devel] Medication tweaks, Jim Busser, 2011/06/20
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/21
- Re: [Gnumed-devel] Medication tweaks, Jim Busser, 2011/06/20
- Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/21
Re: [Gnumed-devel] Medication tweaks, Karsten Hilbert, 2011/06/24