Tables Used
PATIENT
Patient_ID (PK)
Fname
Lname
Address
Phone_Number
APPOINTMENT
Doctor_ID (PK)
Patient_ID (FK)
Visit_ID
Reason
Date
Time
VISIT
Visit_ID (FK)
Patient_ID (FK)
Doctor_ID (FK)
Type of Visit (Scheduled/unscheduled)
Diagnosis
Treatment
INVOICE
Visit_ID (PK)
TotalAmount
AmountPaid
Balance
PaymentMethod (Insurance or Out of Pocket)
Deductible
DOCTOR
Doctor_ID (PK)
Fname
Lname
Office_ID