prescription_id string pk

patient_id string fk

doctor_id string fk

symptoms string

diagnosis string

medication string

test_records string

extra_instructions string

followup_date date

admin_id string pk

username string

password_hash string

role string

contact_info string

patient

mobile_number string (linked with SMS)

name string

contact_number string

address string

gender string

date_of_birth date

patient_id string pk

doctor_id string pk

username string

password_hash string

name string

department_id string

availability_status string

available_days string

daily_appointments string

department_id string pk

department_name string

visit_id string pk

patient_id string

doctor_id string

department_id string

visit_date_time timestamp

status string

symptoms string

diagnosis string

follow_up_date date

prescription_id string

medications string

instructions string

prescription_timestamp timestamp

prescription

prescription_id string pk

patient_id string fk

doctor_id string fk

symptoms string

diagnosis string

medication string

test_records string

extra_instructions string

followup_date date