On analysing the FreeDIAMS database, we find duplications in the DRUGS table:
SELECT UID, COUNT(*) AS Records FROM DRUGS GROUP BY UID HAVING Records > 1;
UID Records
21045002 2
21998001 2
78665001 2
We also find that the COMPOSITION table has many UIDs duplicated, but unique if
a compound key along with MOLECULE_CODE is used (other than for the above codes
in duplicate in the DRUGS table).
SELECT UID, MOLECULE_CODE, COUNT(*) AS Records FROM COMPOSITION GROUP BY UID,
MOLECULE_CODE HAVING Records > 1;
UID MOL_CODE Records
21045002 852 2
21998001 852 2
78665001 852 2
The current USFDA page is at:
http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm
and the latest Database is at:
dr...@fda Download File (ZIP - 1557KB) Last updated: 10/13/2010
- Ap.Muthu
Attached is the MySQL Schema and Data Dump taken from the FreeDIAMS SQLite
drugs-en_US.db
HTH
Regards,
Ap.Muthu
Hi Dr Antas,
Karibu sana !! (warm wellcome in swahili)
I looked the site and it is really needed. It is really difficult to
program when needs high level of knowledge in drug interactions and thought it
would be available only in commercial software.
Our drug provider and hospitals have requested software that could report
if prescribed drugs or combinations could cause problems.
I looked the software tools they use:
"FreeMedForms and derivatives use :
* C++ language
* Qt4.5 libs
* SQLite / MySQL
* XML / HTML / ECMA Script
* Bash for some scripts
All the code documentation in writtent inside. the code. using the doxygen
language. "
I think our developers should look how to integrate this software with
Care2x. In our east African version we have prescription module using drug
list. But freediams can also be used to prescribe drugs.
Mauri
On 7 Oct 2010 at 16:08, an...@e-healthexpert.org wrote:
> freediams: perform prescriptions and check for pharmaceutical drug
> interactions: http://www.freemedforms.com/en/freediams_doc
>
> JA ------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
