FHIR / sql-on-fhir-v2

This project provides the source for the SQL on FHIR v2.0 Implementation Guide
https://build.fhir.org/ig/FHIR/sql-on-fhir-v2/
MIT License
105 stars 29 forks source link

Reference - general discussion #19

Closed niquola closed 1 year ago

niquola commented 1 year ago

Almost everybody agrees that refs should be pre-parsed into some kind of id/resourceType for easier joins. The question is in detail:

Starting proposal is

resourceType: Encounter
patient:
  reference 'Patient/pt-1'
resourceType: Encounter
patient:
  reference: .....
  type: Patient
  id: pt-1
niquola commented 1 year ago
patient:
     @id: 'pt1'
     type: 'Patient'
niquola commented 1 year ago

If we use type and id we clash with id, but json is still valid FHIR and this is a good property! Can we estimate how often id is used in references?