admin_id (PK)
username
password_hash
role
contact_info
patient_id (PK)
aadhaar_number
name
contact_number
address
gender
date_of_birth
chronic illness
medical history
allergies
doctor_id (PK)
department_id (FK)
availability_status
daily_appointments
department_id (PK)
department_name
visit_id (PK)
patient_id (FK)
doctor_id (FK)
visit_date_time
status
symptoms
diagnosis
follow_up_date
prescription_id (PK)
visit_id (FK)
medications
instructions
prescription_timestamp
by nini
