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 |