Schema changes between CareRight V6.83 and 6.84
db/migrate/.rb
New Tables/Views
New Columns
- appointments.primary_external_identifier
- calendar_settings.show_cancelled_on_theatre_list
- calendar_settings.online_booking_status_id
- calendar_settings.privacy_policy
- calendar_settings.online_booking_user_id
- current_assessments.submitted_by_patient_id
- appointment_types.online_booking
- export_patient_records.referrals
- export_patient_records.measurements
- f_estimates.extra_code_1
- f_estimates.extra_code_2
- f_estimates.extra_code_3
- f_estimates.extra_code_4
- f_setup_acc.estimate_extra_code_1_enabled
- f_setup_acc.estimate_extra_code_2_enabled
- f_setup_acc.estimate_extra_code_3_enabled
- f_setup_acc.estimate_extra_code_4_enabled
- f_guarantors.primary_external_identifier
- f_guarantors.email
New Indexes
- patient_leave_periods.episode_id
Changed Views
None
Changed Columns/Indexes
- oauth_access_tokens.refresh_token - now unique
Deleted Tables
- recipients
- marketing_appointment_types
Deleted Columns/Indexes
- appointments.the_specialist_appointment_id
- appointments.care_right_appointment_id
Other
- delete FROM settings where settings.var in ('marketing', 'marketing_contacts_label', 'marketing_care_provider_caller_type', 'marketing_default_calendar_view', 'marketing_recipient_label')
- CREATE SEQUENCE mcol_oec_account_reference_seq START WITH 1
