6.94 Schema Changes

Schema changes between CareRight V6.93 and 6.94

New Tables/Views

  • entitlement_usages
  • entitlement_categories
  • entitlements

New Columns

  • enquiries.archived_at
  • attachments.cloud_storage_key
  • attachments.storage_strategy
  • attachments.byte_size
  • pictures.cloud_storage_key
  • pictures.storage_strategy
  • pictures.byte_size
  • scaled_pictures.cloud_storage_key
  • scaled_pictures.storage_strategy
  • scaled_pictures.byte_size
  • lookup_data_sets.elasticsearch_indexed_at
  • metrics.loinc_code
  • metrics.definition_url
  • metrics.loinc_code_1
  • metrics.loinc_code_2
  • metrics.loinc_code_3
  • metrics.loinc_code_4
  • metric_units.ucum_code
  • metric_units.ucum_description
  • metric_units.ucum_comment
  • metric_units.archived_at
  • appointment_types.enable_assistant

New Indexes

  • None

Changed Views

  • None

Changed Columns/Indexes

  • f_patient_acc.p_acc_ref is now a unique index.

Deleted Tables/Views

  • None

Deleted Columns/Indexes

  • None