Hi Muthu, In fact, that is strange. Such databases are great when they are holding these data and it could be used in different ways.
But let us look on it... I will give Mauri some instructions how he can look for that data and give us some feedback if we can use it. Thanks again for that really interesting link. Robert Am Samstag, den 16.10.2010, 10:15 +0530 schrieb Ap.Muthu: > Attached is the revised (record duplications removed) MySQL schema and > data for the FreeDIAMS SQLite database: drugs-en_US.db > > - Ap.Muthu > > 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 -- -------------------------------------------- MEROTECH IT Engineering Robert Meggle St.-Mang-Str. 8 87616 Marktoberdorf Germany Tel: +49(0)8342 - 8956729 Fax: +49(0)8342 - 8956730 mailto:meg...@merotech.de ------------------------------------------------------------------------------ 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
