Upcoming database changes RELEASE 23 April 2024

-ActiveRecord::Schema[7.0].define(version: 2024_04_02_092837) do
+ActiveRecord::Schema[7.0].define(version: 2024_04_19_072529) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -183,7 +183,7 @@
   create_table "annual_activity_requirements", force: :cascade do |t|
     t.bigint "site_id"
     t.bigint "jobseeker_id"
-    t.integer "activity_id", null: false
+    t.string "activity_id", null: false
     t.integer "activity_referral_sequence_number", null: false
     t.boolean "activity_for_own_org", default: false, null: false
     t.boolean "activity_placement_from_same_org", default: false, null: false
@@ -206,7 +206,11 @@
     t.string "type_code"
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
+    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"
   end

@@ -877,7 +881,6 @@
     t.string "search_title"
     t.string "filters"
     t.string "resource_type"
-    t.string "tag"
     t.datetime "deleted_at", precision: nil
     t.string "priority", default: "business_as_usual"
     t.boolean "pin_status", default: false
@@ -2720,6 +2723,32 @@
     t.index ["smart_form_id"], name: "index_programs_on_smart_form_id"
   end

+  create_table "progress_payment_eligibility_settings", force: :cascade do |t|
+    t.string "activity_type_code", null: false
+    t.string "activity_type_description"
+    t.string "activity_sub_type_code"
+    t.string "activity_sub_type_description"
+    t.boolean "eligible", default: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.index ["activity_type_code", "activity_sub_type_code"], name: "index_progress_payment_eligibility_settings_type", unique: true
+  end
+
+  create_table "progress_payments", force: :cascade do |t|
+    t.bigint "jobseeker_id", null: false
+    t.date "start_date", null: false
+    t.string "status", default: "no_progress"
+    t.string "likelihood", default: "low"
+    t.bigint "claim_id"
+    t.date "service_commenced_on", null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.bigint "submitted_by_id"
+    t.index ["claim_id"], name: "index_progress_payments_on_claim_id"
+    t.index ["jobseeker_id"], name: "index_progress_payments_on_jobseeker_id"
+    t.index ["submitted_by_id"], name: "index_progress_payments_on_submitted_by_id"
+  end
+
   create_table "provider_ratings", id: :serial, force: :cascade do |t|
     t.integer "jobseeker_id", null: false
     t.integer "value"
@@ -3411,6 +3440,9 @@
     t.string "locale", default: "en"
     t.string "country_code", default: "AU"
     t.text "default_email_signature"
+    t.string "calendar_policy_active_days", default: [], array: true
+    t.time "calendar_policy_start_time"
+    t.time "calendar_policy_end_time"
   end

   create_table "short_message_replies", id: :serial, force: :cascade do |t|
@@ -3675,8 +3707,10 @@
     t.string "programme"
     t.jsonb "additional_ess_data", default: {}, null: false
     t.bigint "customer_coordinator_id"
+    t.bigint "current_decision_id"
     t.index ["additional_ess_data"], name: "index_stream_participants_on_additional_ess_data", using: :gin
     t.index ["commenced_on"], name: "index_stream_participants_on_commenced_on"
+    t.index ["current_decision_id"], name: "index_stream_participants_on_current_decision_id"
     t.index ["customer_coordinator_id"], name: "index_stream_participants_on_customer_coordinator_id"
     t.index ["deleted_at"], name: "index_stream_participants_on_deleted_at"
     t.index ["jobseeker_id"], name: "index_stream_participants_on_jobseeker_id"
@@ -4484,6 +4518,7 @@
   add_foreign_key "programs", "program_referral_types"
   add_foreign_key "programs", "sites"
   add_foreign_key "programs", "smart_forms"
+  add_foreign_key "progress_payments", "jobseekers"
   add_foreign_key "provider_tags", "jobseekers"
   add_foreign_key "provider_tags", "provider_tag_categories"
   add_foreign_key "provider_tags", "provider_tag_descriptions"
(END)