gnumed-devel
[Top][All Lists]
Advanced

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

Re: [Gnumed-devel] Medication viewing


From: Karsten Hilbert
Subject: Re: [Gnumed-devel] Medication viewing
Date: Sun, 25 Oct 2009 12:26:48 +0100

> > We support that by means of an intake_is_approved_of in
> > clin.substance_intake (btw, the schema docs are online now).
> 
> re schema...
> 
> I notice within clin.clin_medication a column drug_db but no other  
> table to which this relates...

Never mind that table ;-)   It is outdated.

The relevant tables are:

> clin.substance_intake
>  The substances a patient is actually currently taking.

This is the table holding the actual medication records.

> clin.consumed_substance
>  Substances currently or previously actually being consumed by patients

This table holds the *substances* (Metoprolol, tobacco, Phenprocoumon,
alcohol ...) patients are taking. I am still thinking of folding this
into substance_intake itself.

> clin.active_substance
>  (Active) substances (consumables) a patient may be taking.

This table normalizes active ingredients of brands (for which there
is no definite table yet).

We are so far lacking a table to link together "substances being taken"
into combinations such that such combinations can be documented regardless
of brand.

Karsten
-- 
Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 -
sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser




reply via email to

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