Upcoming database changes RELEASE 17 July 2024

-ActiveRecord::Schema[7.0].define(version: 2024_07_01_075958) do
+ActiveRecord::Schema[7.0].define(version: 2024_07_12_005038) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -453,6 +453,7 @@
     t.bigint "fortnight_id"
     t.index ["fortnight_id"], name: "index_breaks_on_fortnight_id"
     t.index ["placement_id"], name: "index_breaks_on_placement_id"
+    t.index ["start_date"], name: "index_breaks_on_start_date"
   end

   create_table "caseloads", id: :serial, force: :cascade do |t|
@@ -922,6 +923,15 @@
     t.index ["employment_fund"], name: "index_custom_expense_types_on_employment_fund"
   end

+  create_table "decision_interruption_reasons", force: :cascade do |t|
+    t.text "name", null: false
+    t.datetime "deleted_at"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.index ["deleted_at"], name: "index_decision_interruption_reasons_on_deleted_at"
+    t.index ["name"], name: "index_decision_interruption_reasons_on_name"
+  end
+
   create_table "des_placements", id: :serial, force: :cascade do |t|
     t.date "phase_start_date"
     t.date "placement_verification_date"
@@ -1716,7 +1726,6 @@
     t.bigint "stream_participant_id", null: false
     t.string "case_number", null: false
     t.string "status", null: false
-    t.string "interruption_reason"
     t.date "interruption_date"
     t.date "start_date", null: false
     t.date "end_date", null: false
@@ -1730,7 +1739,10 @@
     t.boolean "gp_approved", default: false
     t.boolean "final_report_approved", default: false
     t.bigint "managed_by_id"
+    t.bigint "decision_interruption_reason_id"
+    t.string "interruption_reason"
     t.index ["case_number"], name: "index_jobseeker_decisions_on_case_number"
+    t.index ["decision_interruption_reason_id"], name: "index_jobseeker_decisions_on_decision_interruption_reason_id"
     t.index ["managed_by_id"], name: "index_jobseeker_decisions_on_managed_by_id"
     t.index ["site_id"], name: "index_jobseeker_decisions_on_site_id"
     t.index ["stream_participant_id"], name: "index_jobseeker_decisions_on_stream_participant_id"
@@ -3319,6 +3331,13 @@
     t.index ["name"], name: "index_roles_on_name", unique: true
   end

+  create_table "roles_superset_dashboards", id: false, force: :cascade do |t|
+    t.bigint "role_id", null: false
+    t.bigint "superset_dashboard_id", null: false
+    t.index ["role_id", "superset_dashboard_id"], name: "index_roles_superset_dashboards_role_id_superset_dashboard_id"
+    t.index ["superset_dashboard_id", "role_id"], name: "index_roles_superset_dashboards_superset_dashboard_id_role_id"
+  end
+
   create_table "roles_users", id: false, force: :cascade do |t|
     t.bigint "role_id", null: false
     t.bigint "user_id", null: false
@@ -4048,6 +4067,8 @@
     t.boolean "can_manage_calendar_templates", default: false, null: false
     t.boolean "can_edit_suppliers", default: false
     t.boolean "can_contact_jr_support", default: false
+    t.boolean "can_delete_ancillary_records", default: false
+    t.string "scim_uid"
     t.index ["active"], name: "index_users_on_active"
     t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true
     t.index ["delegate_id"], name: "index_users_on_delegate_id"
@@ -4058,6 +4079,7 @@
     t.index ["invitations_count"], name: "index_users_on_invitations_count"
     t.index ["invited_by_id"], name: "index_users_on_invited_by_id"
     t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
+    t.index ["scim_uid"], name: "index_users_on_scim_uid", unique: true
     t.index ["site_id"], name: "index_users_on_site_id"
   end

@@ -4504,6 +4526,7 @@
   add_foreign_key "job_search_outcomes", "jobseekers"
   add_foreign_key "job_search_outcomes", "sites"
   add_foreign_key "jobseeker_action_plans", "jobseekers"
+  add_foreign_key "jobseeker_decisions", "decision_interruption_reasons"
   add_foreign_key "jobseeker_decisions", "sites"
   add_foreign_key "jobseeker_decisions", "stream_participants"
   add_foreign_key "jobseeker_decisions", "users", column: "managed_by_id"
(END)