Upcoming database changes RELEASE 25th September 2024

-ActiveRecord::Schema[7.0].define(version: 2024_09_09_121212) do
+ActiveRecord::Schema[7.0].define(version: 2024_09_23_045031) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -1271,8 +1271,10 @@
     t.string "type"
     t.text "tags", default: [], array: true
     t.integer "group_event_schedule_id"
+    t.uuid "quest_form_id"
     t.index ["event_calendar_id"], name: "idst_id_idx"
     t.index ["jobseeker_id"], name: "index_event_calendar_schedules_on_jobseeker_id"
+    t.index ["quest_form_id"], name: "index_event_calendar_schedules_on_quest_form_id"
     t.index ["schedule_event_id"], name: "index_event_calendar_schedules_on_schedule_event_id"
     t.index ["schedule_location_id"], name: "index_event_calendar_schedules_on_schedule_location_id"
     t.index ["stream_participant_id"], name: "index_event_calendar_schedules_on_stream_participant_id"
@@ -1774,7 +1776,7 @@
     t.string "attendance_status", default: "none"
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
-    t.index ["event_calendar_schedule_id"], name: "index_jobseeker_group_event_schedules_on_schedule_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"
   end
 
@@ -2994,6 +2996,13 @@
     t.index ["deleted_at"], name: "index_quest_forms_on_deleted_at"
   end
 
+  create_table "quest_forms_group_event_schedules", id: false, force: :cascade do |t|
+    t.integer "group_event_schedule_id"
+    t.uuid "quest_form_id"
+    t.index ["group_event_schedule_id"], name: "idx_group_event_schedule_id"
+    t.index ["quest_form_id"], name: "idx_quest_form_id"
+  end
+
   create_table "quest_forms_smart_forms", id: false, force: :cascade do |t|
     t.uuid "quest_form_id", null: false
     t.uuid "smart_form_id", null: false
@@ -4531,6 +4540,7 @@
   add_foreign_key "ess_wage_subsidy_agreements", "users", column: "created_by_id"
   add_foreign_key "ess_wage_subsidy_agreements", "users", column: "ended_by_id"
   add_foreign_key "event_calendar_schedules", "event_calendars"
+  add_foreign_key "event_calendar_schedules", "quest_forms"
   add_foreign_key "expense_approvals", "expenses"
   add_foreign_key "expense_credit_cards", "users"
   add_foreign_key "expense_imports", "expense_exports"
@@ -4627,6 +4637,8 @@
   add_foreign_key "queries", "users", column: "created_by_id"
   add_foreign_key "query_types", "note_templates", column: "default_note_template_id"
   add_foreign_key "quest_fields_smart_forms", "smart_forms"
+  add_foreign_key "quest_forms_group_event_schedules", "event_calendar_schedules", column: "group_event_schedule_id"
+  add_foreign_key "quest_forms_group_event_schedules", "quest_forms"
   add_foreign_key "quest_submission_view_tokens", "quest_submissions"
   add_foreign_key "rate_reductions", "jobseekers"
   add_foreign_key "rate_reductions", "placements"