| id | firstName | lastName | birthDate |
|---|---|---|---|
| 1 | John | Smith | 1970-01-01 |
| 2 | Jane | Doe | 1980-02-02 |
| id | name | location |
|---|---|---|
| 1 | MedTech Inc. | New York, USA |
| 2 | Health Innovations Ltd. | London, UK |
| id | deviceName | description | price |
|---|---|---|---|
| 1 | Glucose Monitor | Monitors blood glucose levels | 99.99 |
| 2 | Heart Rate Sensor | Measures heart rate | 69.99 |
| scientistId | companyId | medicalDeviceId | startDate | endDate |
|---|---|---|---|---|
| (→ Scientists.id) | (→ Companies.id) | (→ MedicalDevices.id) | ||
| 1 | 1 | 1 | 2021-01-01 | 2021-12-31 |
| 2 | 2 | 2 | 2020-01-01 | 2020-12-31 |
| patientId | firstName | lastName | dateOfBirth | gender |
|---|---|---|---|---|
| 1 | Michael | Johnson | 1990-01-01 | M |
| 2 | Emily | Williams | 1995-02-02 | F |
| appointmentId | doctorId | patientId | date |
|---|---|---|---|
| (→ Doctors.id) | (→ Patients.patientId) | ||
| 1 | 1 | 1 | 2022-01-01 10:00:00 |
| 2 | 2 | 2 | 2022-02-02 14:00:00 |
| doctorId | firstName | lastName | specialty |
|---|---|---|---|
| 1 | Dr. Alice | Brown | Cardiology |
| 2 | Dr. Charles | Green | Neurology |