Patients

Patients$\_$ID Patient$\_$Name Patient$\_$Gender Patient$\_$Age Patient$\_$PNum Patient$\_$Email Insurance$\_$ID $($FK$)$

Doctors

Doctors$\_$ID Doctor$\_$Name Doctor$\_$Speci Doctor$\_$PNum Doctor$\_$Email

Medical Facility

Facility$\_$ID Facility$\_$Name Facility$\_$Location Facility$\_$PNum Doctor$\_$ID $($FK$)$

Payment

Payment ID Payment$\_$Method Appoin$\_$Date Appoin$\_$Cost Patient$\_$ID $($FK$)$

$($FK$)($FK$)$

Appointment

Appoin$\_$ID Appoin$\_$Time Appoin$\_$Date Appoin$\_$Cost Appoin$\_$Type Patient$\_$ID Doctor$\_$ID Facility$\_$ID

$(FK),(FK),(FK)$

Insurance

Insurance$\_$ID Insurance$\_$Name Insurance$\_$Type