User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 426,425 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,406 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums

medical record maintenance system database

Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,455
Reputation: peter_budo is a jewel in the rough peter_budo is a jewel in the rough peter_budo is a jewel in the rough peter_budo is a jewel in the rough 
Rep Power: 11
Solved Threads: 296
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: medical record maintenance system database

  #5  
Apr 1st, 2008
Well I would consider to be based on 3 tables (4 if you looking for different permissions for stuff like nurse can only search and view records, doctor can search, view, edit and create new record)
Table 1 - patients personal details (unique patient ID, DOB, contact details, basic medical records such weight, height, eyes check, alergies or any disabilities)
Table 2 - regular checks (unique patient ID plus what ever medical procedures taken/given that can work as foreign key for you)
Table 3 - illnessrecord (unique patient ID, illness descriptions, any prescrioptions, possible next check)

This is sort of things you looking for in general, if you want to get deeper in given problem you would have to reaserch on what sort of records instituson is interested to store
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)

If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Reply With Quote  
All times are GMT -4. The time now is 2:16 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC