[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] (FreeDIams) Re: Interactions engine available with Ca
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] (FreeDIams) Re: Interactions engine available with Canadian drugs database |
Date: |
Sun, 25 Jul 2010 15:02:25 +0200 |
> 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