6.77.1 Schema Changes

Schema changes between CareRight V6.77 and 6.77.1

New Tables/Views

  • active_storage_blobs
  • active_storage_attachments
  • branding_settings


db/migrate/20211209223057_add_index_line_items.rb

New Columns

TableColumn
health_fundsperson_id - index
guarantor_id - index
is_primary
external_patient_tokens


tyro_terminals


default_tyro_terminal_id

tyro_terminal_target_id


f_associate

mid

use_default_mid


f_line_items

idx_line_items_sort - index





Changed Views

  • v_uninvoiced_admissions - joins health_funds more efficiently
  • v_uninvoiced_medical_admissions - joins health_funds more efficiently

Changed Columns

  • f_setup_acc.sa_gst_abn - increased to 100 char
  • f_associate.ass_gst_abn - increased to 100 char

Deleted Tables

  • None

Deleted Columns