## Doctors

id | name | specialty | hospital_id
--- | --- | --- | ---
|  |  | (→ Hospitals.id)
1 | Dr. John Smith | Cardiology | 1
2 | Dr. Jane Doe | General Practice | 2
3 | Dr. Mike Johnson | Orthopedics | 3
4 | Dr. Sarah Brown | Pediatrics | 4
5 | Dr. Emily Davis | Neurology | 5

## Hospitals

id | name | city | neighborhood | phone_number
--- | --- | --- | --- | ---
1 | St. Mary's Hospital | New York City | Midtown | +1-212-500-1111
2 | Mount Sinai Medical Center | Miami | Downtown | +1-305-555-2222
3 | Memorial Hermann Hospital | Houston | Medical Center | +1-713-244-6000
4 | Cleveland Clinic | Cleveland | Gates Mills Boulevard | +1-216-444-1000
5 | Mayo Clinic | Rochester | First Street SW | +1-507-538-0000

## InsurancePlans

id | plan_name | premium | coverage_details | provider_id
--- | --- | --- | --- | ---
|  |  |  | (→ Providers.id)
1 | Basic Plan | 100 | Covers essential medical services | 1
2 | Standard Plan | 200 | Includes preventive care and routine checkups | 2
3 | Deluxe Plan | 300 | Comprehensive coverage with no out-of-pocket costs | 3
4 | Ultimate Plan | 400 | Most extensive coverage available | 4
5 | VIP Plan | 500 | Exclusive benefits and concierge service | 5

## Patients

id | first_name | last_name | birthdate | insurance_plan_id
--- | --- | --- | --- | ---
|  |  |  | (→ InsurancePlans.id)
1 | John | Doe | 1980-01-01 | 1
2 | Jane | Smith | 1985-02-02 | 2
3 | Emily | Brown | 1990-03-03 | 3
4 | Mike | Johnson | 1995-04-04 | 4
5 | Sarah | Davis | 2000-05-05 | 5

## Prescriptions

id | patient_id | doctor_id | medication | dosage | quantity | refillable | prescription_date
--- | --- | --- | --- | --- | --- | --- | ---
| (→ Patients.id) | (→ Doctors.id) |  |  |  |  |
1 | 1 | 1 | Lisinopril | 5mg | 30 | 1 | 2021-01-01 10:00:00
2 | 2 | 2 | Metformin | 500mg | 30 | 0 | 2021-02-01 11:00:00
3 | 3 | 3 | Codeine | 60mg | 30 | 1 | 2021-03-01 12:00:00
4 | 4 | 4 | Albuterol | 9mg | 30 | 1 | 2021-04-01 13:00:00
5 | 5 | 5 | Azathioprine | 50mg | 30 | 0 | 2021-05-01 14:00:00