Add new columns to table 'resources'

[kapsner]

For performance purposes / faster filtering etc. it would be good to have 3 additional columns available in the 'resources' table, namely:

• Patient-ID:
  • REPLACE(jsonb_path_query(DATA, '$.subject') ->> 'reference', 'Patient/', '') or
  • DATA ->> 'id' (for resource-type = 'Patient')
• Encounter-ID:
  • REPLACE(DATA -> 'encounter' ->> 'reference', 'Encounter/', '') [e.g. for resource-type = 'Condition']
  • DATA ->> 'id' (for resource-type = 'Encounter')
• Encounter-Start-Date
  • to_timestamp(jsonb_path_query(DATA, '$.period') ->> 'start', 'YYYY-MM-DDTHH:MI:SS') [e.g. for resource-type = 'Encounter']