Upcoming database changes RELEASE 08 May 2024

-ActiveRecord::Schema[7.0].define(version: 2024_04_19_072529) do
+ActiveRecord::Schema[7.0].define(version: 2024_04_29_072206) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -206,9 +206,9 @@
     t.string "type_code"
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
+    t.string "progress_payment_status"
     t.bigint "progress_payment_id"
     t.text "justification"
-    t.string "progress_payment_status"
     t.index ["jobseeker_id"], name: "index_annual_activity_requirements_on_jobseeker_id"
     t.index ["progress_payment_id"], name: "index_annual_activity_requirements_on_progress_payment_id"
     t.index ["site_id"], name: "index_annual_activity_requirements_on_site_id"
@@ -890,6 +890,13 @@
     t.index ["resource_type"], name: "index_custom_alerts_on_resource_type"
   end
 
+  create_table "custom_alerts_roles", id: false, force: :cascade do |t|
+    t.bigint "custom_alert_id", null: false
+    t.bigint "role_id", null: false
+    t.index ["custom_alert_id", "role_id"], name: "index_custom_alerts_roles_on_custom_alert_id_and_role_id"
+    t.index ["role_id", "custom_alert_id"], name: "index_custom_alerts_roles_on_role_id_and_custom_alert_id"
+  end
+
   create_table "custom_expense_types", id: :serial, force: :cascade do |t|
     t.string "code", null: false
     t.string "description", null: false
@@ -960,12 +967,21 @@
     t.index ["user_id"], name: "index_document_library_files_on_user_id"
   end
 
+  create_table "elcapitan_feature_groups", force: :cascade do |t|
+    t.string "name"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.index ["name"], name: "index_elcapitan_feature_groups_on_name", unique: true
+  end
+
   create_table "elcapitan_tenant_configurations", id: :serial, force: :cascade do |t|
     t.text "name", null: false
     t.text "value", null: false
     t.datetime "created_at", precision: nil
     t.datetime "updated_at", precision: nil
     t.text "description"
+    t.bigint "elcapitan_feature_group_id"
+    t.index ["elcapitan_feature_group_id"], name: "index_tenant_config_on_feature_group_id"
     t.index ["name"], name: "index_elcapitan_tenant_configurations_on_name", unique: true
   end
 
@@ -2507,6 +2523,8 @@
     t.string "basic_rate_name"
     t.integer "basic_rate_base"
     t.date "dhs_cycle_date"
+    t.string "organisation_name"
+    t.string "organisation_number"
     t.index ["additional_ess_data"], name: "index_placements_on_additional_ess_data", using: :gin
     t.index ["centrelink_outcome_started_on"], name: "index_placements_on_centrelink_outcome_started_on"
     t.index ["completion_expected_updated_by_id"], name: "index_placements_on_completion_expected_updated_by_id"
@@ -4422,6 +4440,7 @@
   add_foreign_key "company_leads", "users", column: "lead_manager_id"
   add_foreign_key "contacts", "users", column: "created_by_id"
   add_foreign_key "cortex_rails_organisations", "cortex_rails_api_configs", column: "api_config_id"
+  add_foreign_key "elcapitan_tenant_configurations", "elcapitan_feature_groups"
   add_foreign_key "email_events", "emails"
   add_foreign_key "emails", "reminders"
   add_foreign_key "employer_campaigns", "companies"