Hospital Managment System Casestudy

TODOs

• Create users DB
• Create patients DB
  • Create Patient Screen
  • Update Patient Screen
  • Delete Patient Screen
  • Search Patient Screen
  • View Patients Screen
  • Patient Billing Screen
• login page (basic)
• added authentication
• cookies
• UI Enhancement
  • Home Page
  • Login Page
  • Navbar
  • About-us / Services / motto page (optional)
• create medicines DB
  • Get patient Details Screen
  • Issue Medicines Screen
• create diagnostics DB
  • Get patient Details Screen
  • Diagnostics Screen

Login Credentials:

Username: reuser1
Password: tcs_user1

Database Schemas

• patients Table

          col name    | type    | remarks
          -------------------------------------------
          ws_ssn      | INTEGER | UNIQUE values only
    	ws_pat_id   | INTEGER | PRIMARY KEY, AUTOINCREMENT
    	ws_pat_name | TEXT    | NOT NULL
    	ws_adrs     | TEXT    | NOT NULL
    	ws_age      | INTEGER | NOT NULL
    	ws_doj      | TEXT    | NOT NULL
    	ws_rtype    | TEXT    |   - 
    	ws_status   | INTEGER | DEFAULT value 1
  

• users Table

       col name     | type    | remarks
       --------------------------------------
       id           | TEXT    | PRIMARY KEY
       name         | TEXT    | NOT NULL
       password     | TEXT    | NOT NULL, SHA256 encrypted
       type         | TEXT    | NOT NULL