I have 2 schemas for a health monitoring system. One schema is for the ‘patient’ containing personal information and a patientID. The patientID is the primary key here.
The other schema is for the readings for each patient. The patientID would be the foreign key here.
There are 6 ‘patients’ in total - so each patient should have their own schema of data.
How do I join the 2 schemas together in this way? so the PatientID only shows up once and then this would be linked to their relevant readings.
Essentially, each patient should have their own set of generated data.
Hope this makes sense!