Nurses

NurseIDNamePatientIDHoursWorkedExperienceLevel
1Anne Buche2308.5Intermediate
2John Smith3679.0Advanced
3Jane Doe4557.5Beginner

PhysiciansAssistants

PAIDNamePatientIDHoursWorkedSpecialization
1Anne Buche2308.5Cardiology
2John Smith3679.0Gastroenterology
3Jane Doe4557.5Orthopedics

Doctors

DoctorIDNameMedicalLicenseNumberYearsOfPractice
1Dr. Alice JohnsonM12345610
2Dr. Bob BrownB65432115
3Dr. Carol WhiteW7890125

Clinics

ClinicIDAddressPhoneNumberNumberofDoctors
1123 Main St, Anytown555-12343
2456 Elm St, Anothertown555-56785

Departments

DepartmentIDClinicIDDepartmentName
(→ Clinics.ClinicID)
11Family Medicine
22Dermatology

Appointment

AppointmentIDDoctorIDDateReasonForVisit
(→ Doctors.DoctorID)
112022-01-01 10:00:00Routine checkup
222022-01-02 14:00:00Flu shot
332022-01-03 16:00:00Skin rash consultation