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 |
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 |
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 |
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 |
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 |