[Gnumed-devel] recording allergy details

[Karsten Hilbert]

I am trying to attach the allergies field in the top pane to
the backend. For that I need a table to pull the data from.
For that, in turn, we need a table recording allergy details.
Allergies is one of the known concepts so we need not resort
to a generic table.

Clinically, am I missing something import if we have the
following fields:

 substance
  - the thing the patient reacted to
  - not necessarily the allergenic ingredient
  - say "Vomex Ratiopharm"

 allergene
  - the exact substance that cause the allergy if
    known
  - possibly just one of many ingredients

 description
  - free text description of reaction

 certainty (better name needed)
  - definate/likely

 reaction type
  - allergy/sensitivity

 first observed
  - if available

 code
  - if applicable
  - ATC for penicilin
  - NULL for cat's hair

And of course the usual suspects such as recorded-when,
recorded-by-whom, id, id_identity, etc.

If no code is recorded or applicable a string matching search
can be done against substance and allergene.

Comments please.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346