Clinics

clinic_idnameaddress
1Healthy Living123 Main St
2Medical Center456 Oak Ave
3Family Care789 Pine Blvd
4Northside Hospital101 Elm Rd
5Southside Medical202 Willow Ln

Services

service_idservice_name
1Vaccination
2Physical Examination
3Dental Checkup
4Laboratory Tests
5X-ray Imaging

Clinics_Services

clinics_services_idclinic_idservice_id
(→ Clinics.clinic_id)(→ Services.service_id)
111
221
331
441
551
655

Patients

patient_idfirst_namelast_namedate_of_birthphone_number
1JohnSmith1985-05-15555-123-4567
2JaneDoe1990-08-20555-987-6543
3MichaelBrown1988-11-22555-345-7890
4EmilyWhite1992-03-01555-135-7902
5DavidBlack1986-07-14555-567-8903

Appointments

appointment_idpatient_idclinic_idservice_idappointment_date
(→ Patients.patient_id)(→ Clinics.clinic_id)(→ Services.service_id)
11112022-01-10 10:00:00
22232022-01-12 14:00:00
33352022-01-14 09:00:00
44412022-01-16 11:00:00
55542022-01-18 15:00:00