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 |