Schema changes between CareRight V6.95.6 and 6.96
db/migrate/20240307004540_add_online_booking_after_payment_status_id_to_calendar_settings.rb
New Tables/Views
- external_files
New Columns
- calendar_settings.online_booking_after_payment_status_id
New Indexes
- None
Changed Views
None
Changed Columns/Indexes
- None
Deleted Tables/Views
- None
Deleted Columns/Indexes
- None
Schema changes between CareRight 6.96 and 6.96.10
New tables
- medicare_era_links
Other
Medicare data migrated from a singular to one to many relationship:
update a set medicare_online_request_id = m.medicare_online_request_id
from medicare_era_reports a
join (select * from (
select a.id, b.medicare_online_request_id, ROW_NUMBER() OVER (partition BY b.medicare_era_report_id order by b.id) AS rn
from medicare_era_reports a
join medicare_era_links b on a.id = b.medicare_era_report_id
) x where x.rn = 1) m on a.id = m.id
