## Country

id | name | population
--- | --- | ---
1 | USA | 328200000
2 | Canada | 37600000
3 | UK | 67100000
4 | Germany | 83000000
5 | France | 65200000

## Manufacturing_Company

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

## Medical_Device

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

## Patient

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

## Doctor

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

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