Web Based Patient Health Information Database Design

Web Based Patient Health Information Database Design

This article will serve as a guide in the development of patient health information system. The said project is a web based project using PHP, MySQL and Bootstrap. This article also includes the list of software used in the development of the project and as well as the related literature.

Web Based Patient Health Information List of Database Table
Web Based Patient Health Information List of Database Table

Database Design/Model/Schema or the Table Structure and Definition

Manage Physicians Information

tblphysician(physician_id, name, address, contact, medical_background, license_number, validity_date, encoded_by)

Manage List of Specializations

tblspecialization (specialization_id, specialization_name, description, encoded_by)

Physician Specilization

tblphysicianspecialization (id, physician_id, specialization_id, encoded_by)

Manage Cases or Diseases

tbldisease(disease_id, disease_name, description, encoded_by)

Manage Medicine Information

tblmedicine (medicine_id, medicine_name, description, encoded_by)

Medicine of Diseases Table

tblmedicinefordisease (id, medicine_id, disease_id, physician_id)

Manage Users

tblusers (user_id, username, password, name, address, contact, designation)

Manage Patients Info

tblpatient (patient_id, name, address, contact, gender, birthdate, encoded_by)

Transaction or Consultation

tblconsultation (consultation_id, patient_id, date_recorded, encoded_by)

Consultation Details

tblconsultationdetails (consultation_details_id, consultation_id, complaints, diagnosis, treatment, medicine_id, physician_id)

Web Based Patient Health Information Database Table Relationship
Web Based Patient Health Information Database Table Relationship

Report Module of the System:

List of Diseases (no. of occurrence recorded per month and can be filter by year) with Graph or Chart

Patient History Report (list of health record of the patient)

Daily, Weekly, Monthly, Yearly Log Report (List of patients being accommodated)

Number of Patients Accommodated (by physician and by Specializations)

Related Literature


Fetched from COLLEGE OF COMPUTER STUDIES (CSS) the “University of Cebu Lapu-Lapu and Mandaue Clinic Information System with SMS” is to help the clinic staff and the management to lessen their burden in monitoring the transactions, enhancing the ways of managing the patient’s record, convenient and fast distribution of patient’s schedules, accurate tracking of information. It also make the students being updated of their schedules that University of Cebu City clinic and the Mandaue Clinic is currently using the manual storing of the patient’s records which take a lot of time in retrieving the information that they needed. They encountered many problems on their existing system.

Source: https://ccs-lm.uc.edu..ph/mod/data/view.phpd=1$advanced


The Clinic Information System with SMS in University of Lapu-Lapu and Mandaue Clinic features mostly like our system except the SMS feature. Our system carries managing the records of the patients and accurate storing and tracking of information. We also have the inventory of medicines and the scheduling for the school Psycisian and Doctor.

Web Based Patient Health Information Database Design
Web Based Patient Health Information Database Design

Software Requirements

  • Operating System – Windows 7
  • UWAMP: is a Wamp Server with Apache MySQL PHP and SQLite. It is provided with a management interface which lets you start or stop the server with one click. UwAmp allows real time Apache and MySQL process CPU monitoring. It can manage Apache Virtual host and Alias. You can enable/disable PHP extension and Apache module from UwAmp manager. UwAmp can be run from a USB stick (cnet.com).
  • Bootstrap: is a powerful front-end framework for faster and easier web development. It includes HTML and CSS based design templates for common user interface components like Typography, Forms, Buttons, Tables, Navigations, Dropdowns, Alerts, Modals, Tabs, Accordion, Carousel and many other as well as optional JavaScript extensions. Bootstrap also gives ability to create responsive layout with much less efforts.  Using it comes with free set of tools for creating flexible and responsive web layouts as well as common interface components. The Bootstrap data APIs can create advanced interface components like Scroll spy and type heads without writing a single line of JavaScript (tutorialrepublic.com).
  • phpMyadmin: is a tool written in PHP to handle the administration of MySQL over the web. Databases must be created in cPanel, but phpMyAdmin can drop databases, create/drop/alter tables/delete/edit/add fields, execute any SQL statement, manage keys on fields, and export data into various formats. The phpMyAdmin program is handy for performing maintenance operations on tables, backing up information, and editing things directly in the event that your scripts are not working. Occasionally, in the Support Forums, someone will post a SQL query of some benefit or other that can be run using phpMyAdmin. Although many of the same tasks can be performed on the MySQL command line, doing so is not an option for many people (flexihost.co).
  • PHP: is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML. PHP code is executed on the server, generating HTML which is then sent to the client. The client would receive the results of running that script, but would not know what the underlying code was (php.net).
  • Cascading Stylesheet (CSS): is a Web page derived from multiple sources with a defined order of precedence where the definitions of any style element conflict. The Cascading Style Sheet is implemented in the latest versions of the Netscape and Microsoft Web browsers, specifies the possible style sheets or statements that may determine how a given element is presented in a Web page. CSS gives more control over the appearance of a web page to the page creator than to the browser designer or the viewer (techtarget.com).
  • Hypertext Mark-up Language (HTML): is the set of mark-upsymbols or codes inserted in a file intended for display on a World Wide Web browser The mark-up tells the web browser how to display a web page’s words and images for the user. Each individual mark-up code is referred to as an element. Some elements come in pairs that indicate when some display effect is to begin and when it is to end. HTML is a formal recommendation by the World Wide Web Consortium and is generally adhered to by the major browser features differently and provides non-standard extensions (techtarget.com).




, , , , , , , , , , , , , , , , , , , , ,

Post navigation