Gotcha. Could I double click on this for a sec:
We have:
Table A with columns:
- patient id
- email
- favorite ice cream flavor foreign key
Table B with columns:
- ice cream flavor id
- flavor name
How would you suggest I proceed?
Three options for you (feel free to suggest a 4th!):
1. all in medplum
Table A: FHIR Patient (extended) template in Medplum
Table B: brand new schema (non-standard) in Medplum
Query "what's patient's 1 favorite ice cream flavor name?": I just query Medplum
2. one in Medplum other in RDS-AWS
Table A: FHIR Patient (extended) template in Medplum
Table B: RDS-AWS
Query "what's patient's 1 favorite ice cream flavor name?": I query both AWS-RDS and Medplum and then join
3. source of truth in RDS-AWS with synced sub-duplicate in Medplum
Table A: FHIR Patient (extended) template in Medplum; same in RDS-AWS
Table B: RDS-AWS
Query "what's patient's 1 favorite ice cream flavor name?": I just query RDS-AWS
@Ian Plunkett what's your suggestion here?