Gotcha. Could I double click on this for a sec: W...
# dev
o
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?
162 Views