Connecting 2 schemas

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!

This tutorial from Mockaroo may help you with this topic:

1 Like

The referenced video is unavailable. This video shows how to generate datasets related by a foreign key using Mockaroo: