ValueSets and Concept resource

[niquola]

We implemented FHIR terminology by introducing Concept resource, which can be represented in
database as a concept table.
For ValueSets effective expansions - valueset id's can be denormalized into concept as array of ids. This way expansion and lookup will be like:

select * 
  from concept 
  where valueSetIds contains "vs-1" and code in (...)

[niquola]

As well you can join concept table in your complex queries

[niquola]

Shell we discuss naming - spec says table should be named valueset_codes - i prefer Concept table name to be more FHIR-like resource name. The basic structure for this pseudo-resource can be taken from Coding data type.

[niquola]

valueset url and version naming should be normalised by FHIR conventions:

Concept.valueSet.url or Concept.valueSetURL ????

[niquola]

As well same Concept can participate in many valuesets - may be valueset cardinality can be * not 1 to 1