Schema changes between CareRight V7.8.0 and CareRight V7.9.3
New Tables
- external_person_tokens - Data is migrated from ExternalPatientToken.
New Columns
- episodes.pcoc_episode_id
- episodes.separation_primary_phase_type
- pcoc_episodes.preferred_place_of_death
- pcoc_phases.leave_days
- statutory_report_instances.preview
- icd_diseases.unaccept_dx
- icd_diseases.rare_use_flag
- icd_diseases.morph_code
- icd_diseases.dcid
New Indexes
- program_attendances.program_session_id
- program_attendances.patient_id
- program_attendances.deleted
- program_enrolments.program_schedule_id
- program_enrolments.patient_id
- program_provider_attendances.program_session_id
- program_provider_attendances.provider_id
- program_schedules.program_category_id
- program_schedules.archived_at
- program_sessions.program_schedule_id
- program_sessions.session_date
- program_waitlists.program_category_id
- program_waitlists.patient_id
- program_waitlists.status
- cases.room_id
- cases.provider_id
- auditable_actions(actor_type actor_id)
Changed Columns
- auditable_actions.actor_type
- auditable_actions.actor_id
Deleted Tables
None
Deleted Columns
- episodes.diagnosis_cluster_identifier
Other
Removal of diagnosis_cluster_identifier from episodes moves data:
update a set
diagnosis_cluster_identifier = b.diagnosis_cluster_identifier
from episode_diagnoses a
join episodes b on a.episode_id = b.id
where b.diagnosis_cluster_identifier is not null and b.diagnosis_cluster_identifier <>''