• admin_id (PK)

• username

• password_hash

• role ('admin')

• contact_info

Patient

• patient_id (PK)

• aadhaar_number

• name

• contact_number

• address

• gender

• date_of_birth

• chronic illness

• medical history

• allergies

• doctor_id (PK)

• username

• password_hash

• name

• department_id (FK)

• availability_status

• daily_appointments

• department_id (PK)

• department_name

Visit / Appointment Record

• visit_id (PK)

• patient_id (FK)

• doctor_id (FK)

• department_id (FK)

• visit_date_time

• status

• symptoms

• diagnosis

• follow_up_date

• prescription_id (PK)

• visit_id (FK)

• medications

• instructions

• prescription_timestamp