## Clinics

clinic_id | name | address
--- | --- | ---
1 | Healthy Living | 123 Main St
2 | Medical Center | 456 Oak Ave
3 | Family Care | 789 Pine Blvd
4 | Northside Hospital | 101 Elm Rd
5 | Southside Medical | 202 Willow Ln

## Services

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

## Clinics_Services

clinics_services_id | clinic_id | service_id
--- | --- | ---
| (→ Clinics.clinic_id) | (→ Services.service_id)
1 | 1 | 1
2 | 2 | 1
3 | 3 | 1
4 | 4 | 1
5 | 5 | 1
6 | 5 | 5

## Patients

patient_id | first_name | last_name | date_of_birth | phone_number
--- | --- | --- | --- | ---
1 | John | Smith | 1985-05-15 | 555-123-4567
2 | Jane | Doe | 1990-08-20 | 555-987-6543
3 | Michael | Brown | 1988-11-22 | 555-345-7890
4 | Emily | White | 1992-03-01 | 555-135-7902
5 | David | Black | 1986-07-14 | 555-567-8903

## Appointments

appointment_id | patient_id | clinic_id | service_id | appointment_date
--- | --- | --- | --- | ---
| (→ Patients.patient_id) | (→ Clinics.clinic_id) | (→ Services.service_id) |
1 | 1 | 1 | 1 | 2022-01-10 10:00:00
2 | 2 | 2 | 3 | 2022-01-12 14:00:00
3 | 3 | 3 | 5 | 2022-01-14 09:00:00
4 | 4 | 4 | 1 | 2022-01-16 11:00:00
5 | 5 | 5 | 4 | 2022-01-18 15:00:00