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

 

Home