Upcoming database changes RELEASE 23 October 2024

-ActiveRecord::Schema[7.0].define(version: 2024_09_25_085013) do
+ActiveRecord::Schema[7.0].define(version: 2024_10_15_141414) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -1776,8 +1776,12 @@
     t.string "attendance_status", default: "none"
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
+    t.bigint "email_id"
+    t.uuid "quest_submission_id"
+    t.index ["email_id"], name: "index_jobseeker_group_events_on_email_id"
     t.index ["event_calendar_schedule_id"], name: "index_jobseeker_group_events_on_schedule_id"
     t.index ["jobseeker_id"], name: "index_jobseeker_group_events_on_jobseeker_id"
+    t.index ["quest_submission_id"], name: "idx_jobseeker_group_events_quest_submissions_on_submission"
   end
 
   create_table "jobseeker_leads", force: :cascade do |t|
@@ -4105,6 +4109,7 @@
     t.boolean "can_contact_jr_support", default: false
     t.boolean "can_delete_ancillary_records", default: false
     t.string "scim_uid"
+    t.string "otp_secret"
     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"
@@ -4572,6 +4577,7 @@
   add_foreign_key "jobseeker_goals", "goals"
   add_foreign_key "jobseeker_goals", "jobseekers"
   add_foreign_key "jobseeker_goals", "users", column: "created_by_id"
+  add_foreign_key "jobseeker_group_events", "emails"
   add_foreign_key "jobseeker_group_events", "jobseekers"
   add_foreign_key "jobseeker_leads", "lead_stages"
   add_foreign_key "jobseeker_leads", "lead_sub_stages"