Schema changes between CareRight V6.85 and 6.86
New Tables/Views
- checklists
- checklist_instances
New Columns
- program_categories.checklist_id
- admission_categories.checklist_id
- admissions.checklist_instance_id
- admissions.ignore_in_stat_reporting
- program_enrolments.checklist_instance_id
- users.encrypted_otp_secret
- users.encrypted_otp_secret_iv
users.encrypted_otp_secret_salt
users.consumed_timestep
users.otp_required_for_login
users.otp_backup_codes
appointment_types.booking_fee
f_transaction.stripe_payment_id
receipts.stripe_payment_id
refunds.stripe_refund_status
refunds.stripe_refund_id
addresses.gnaf_identifier
addresses.human_readable_full_address
New Indexes
- None
Changed Views
None
Changed Columns/Indexes
- f_associate.item105_not_normal_after_care renamed to item_not_normal_after_care
Deleted Tables
- None
Deleted Columns/Indexes
- None
