| id | name | population |
|---|---|---|
| 1 | USA | 328200000 |
| 2 | Canada | 37600000 |
| 3 | UK | 67100000 |
| 4 | Germany | 83000000 |
| 5 | France | 65200000 |
| id | company_name | address |
|---|---|---|
| 1 | ABC MedTech | 123 Main St, New York, NY |
| 2 | XYZ Biomedicals | 456 Elm St, Chicago, IL |
| 3 | MedPlus Innovations | 789 Oak St, Los Angeles, CA |
| 4 | HealthWave Solutions | 101 Pine St, San Francisco, CA |
| 5 | MediPure Technologies | 111 Spruce St, Boston, MA |
| id | device_name | manufacturing_company_id | country_id |
|---|---|---|---|
| (→ Manufacturing_Company.id) | (→ Country.id) | ||
| 1 | Glucometer | 1 | 1 |
| 2 | EKG Machine | 2 | 2 |
| 3 | Blood Pressure Monitor | 3 | 3 |
| 4 | Insulin Pen | 4 | 4 |
| 5 | Oxygen Concentrator | 5 | 5 |
| id | first_name | last_name | age |
|---|---|---|---|
| 1 | John | Doe | 45 |
| 2 | Jane | Smith | 32 |
| 3 | Alice | Johnson | 28 |
| 4 | Bob | Williams | 55 |
| 5 | Emily | Martin | 23 |
| id | doctor_name | speciality |
|---|---|---|
| 1 | Dr. Johnson | Cardiology |
| 2 | Dr. Brown | Endocrinology |
| 3 | Dr. White | Neurology |
| 4 | Dr. Black | Orthopedics |
| 5 | Dr. Green | Allergy and Immunology |
| prescription_id | patient_id | doctor_id | medical_device_id | quantity | date |
|---|---|---|---|---|---|
| (→ Patient.id) | (→ Doctor.id) | (→ Medical_Device.id) | |||
| 1 | 1 | 1 | 1 | 2 | 2024-02-19 13:15:05 |
| 2 | 2 | 2 | 2 | 3 | 2024-02-19 13:15:05 |
| 3 | 3 | 3 | 3 | 1 | 2024-02-19 13:15:05 |
| 4 | 4 | 4 | 4 | 2 | 2024-02-19 13:15:05 |
| 5 | 5 | 5 | 5 | 1 | 2024-02-19 13:15:05 |