Upcoming database changes RELEASE 14 February 2024

-ActiveRecord::Schema[7.0].define(version: 2024_01_09_082402) do
+ActiveRecord::Schema[7.0].define(version: 2024_02_05_234413) do
   # These are extensions that must be enabled in order to support this database
@@ -1547,2 +1547,3 @@
     t.datetime "updated_at", null: false
+    t.boolean "attendance_required", default: false
     t.index ["name"], name: "index_individual_development_schedule_templates_on_name", unique: true
@@ -1560,10 +1561,14 @@
     t.datetime "updated_at", null: false
-    t.string "location"
     t.boolean "is_remote", default: false
     t.boolean "is_onsite", default: false
-    t.integer "assigned_to_id"
     t.integer "repeat_id"
-    t.string "event"
+    t.integer "assigned_to_id"
+    t.boolean "attendance_required", default: false
+    t.string "attendance_status", default: "none"
+    t.integer "schedule_location_id"
+    t.integer "schedule_event_id"
     t.index ["individual_development_schedule_template_id"], name: "idst_id_idx"
     t.index ["jobseeker_id"], name: "index_individual_development_schedules_on_jobseeker_id"
+    t.index ["schedule_event_id"], name: "index_individual_development_schedules_on_schedule_event_id"
+    t.index ["schedule_location_id"], name: "index_individual_development_schedules_on_schedule_location_id"
     t.index ["stream_participant_id"], name: "index_individual_development_schedules_on_stream_participant_id"
@@ -1662,3 +1667,3 @@
     t.bigint "stream_participant_id", null: false
-    t.integer "case_number", null: false
+    t.string "case_number", null: false
     t.string "status", null: false
@@ -1671,2 +1676,5 @@
     t.datetime "updated_at", null: false
+    t.text "comment"
+    t.integer "participation_rate"
+    t.boolean "extension"
     t.index ["stream_participant_id"], name: "index_jobseeker_decisions_on_stream_participant_id"
@@ -1748,2 +1756,8 @@

+  create_table "jobseeker_portal_document_types", force: :cascade do |t|
+    t.string "document_type", null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end

create_table "jobseeker_portal_links", id: :serial, force: :cascade do |t|
@@ -2322,5 +2336,6 @@
     t.integer "original_peppol_invoice_id"
-    t.uuid "tickstart_transaction_id"
+    t.uuid "tickstar_transaction_id"
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
+    t.string "invoice_type"
     t.index ["invoice_number"], name: "index_peppol_invoices_on_invoice_number", unique: true
@@ -2351,3 +2366,3 @@
     t.string "currency_code", null: false
-    t.uuid "tickstart_transaction_id"
+    t.uuid "tickstar_transaction_id"
     t.datetime "created_at", null: false
@@ -2711,2 +2726,10 @@

+  create_table "public_holidays", force: :cascade do |t|
+    t.date "date", null: false
+    t.string "country", null: false
+    t.string "name", null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end
+
   create_table "purchase_orders", id: :serial, force: :cascade do |t|
@@ -3220,2 +3243,3 @@
     t.datetime "updated_at", null: false
+    t.string "color"
     t.index ["name"], name: "index_schedule_locations_on_name", unique: true
@@ -3695,2 +3719,10 @@

+  create_table "tickstar_access_tokens", force: :cascade do |t|
+    t.string "access_token"
+    t.string "refresh_token"
+    t.datetime "expires_at"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end
+
   create_table "time_frames", force: :cascade do |t|
@@ -3801,3 +3833,3 @@
     t.datetime "locked_at", precision: nil
-    t.boolean "can_view_confidential_notes", default: false, null: false
+    t.boolean "can_view_and_mark_confidential_jobseekers", default: false, null: false
     t.string "expense_approval_level"
@@ -3836,4 +3868,2 @@
     t.boolean "can_update_tracking_behaviour", default: false, null: false
-    t.boolean "can_access_employers", default: true, null: false
-    t.boolean "can_access_contacts", default: true, null: false
     t.boolean "restrict_site_communication", default: false, null: false
@@ -3873,3 +3903,3 @@
     t.boolean "ess_subs_admin", default: false, null: false
-    t.boolean "can_import_jobseekers", default: false, null: false
+    t.boolean "can_create_and_import_jobseekers", default: false, null: false
     t.boolean "can_access_ai_copilot", default: false, null: false
@@ -3878,2 +3908,5 @@
     t.boolean "can_manage_wage_subsidy_requests", default: false, null: false
+    t.boolean "can_bulk_update_jobseeker_status", default: false, null: false
+    t.boolean "can_create_sta2_placement", default: false
+    t.string "personal_number"
     t.index ["active"], name: "index_users_on_active"
@@ -3887,2 +3920,3 @@
     t.index ["invited_by_id"], name: "index_users_on_invited_by_id"
+    t.index ["personal_number"], name: "index_users_on_personal_number", unique: true
     t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
end