Re: [Gnumed-devel] (FreeDIams) Re: Interactions engine available with Canadian drugs database

[Karsten Hilbert]

> I should keep the link primary key in the Interactions table, because  
> there are many couple of ATC1 ATC2 that link to the same knowledge.

Now that I come to think of it -- no patients ATM -- I start to
see what you mean:



table interaction_knowledge
   pk integer primary key
   xml varchar - you said that would be language independant


table interaction_knowledge_text
   pk
   fk - links to interaction_knowledge.pk
   lang - language of risk and management
   risk varchar
   management varchar

table interaction_by_atc
   pk
   fk - links to interaction_knowledge.pk
   atc1
   atc2

table interaction_by_inn
   pk
   fk - links to interaction_knowledge.pk
   inn1
   inn2

maybe even:

table interaction_by_drug_uid
   pk
   fk - links to interaction_knowledge.pk
   uid1
   uid2

Karsten
-- 
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01