Upcoming database changes RELEASE 29 February 2024

-ActiveRecord::Schema[7.0].define(version: 2024_02_12_044522) do
+ActiveRecord::Schema[7.0].define(version: 2024_02_22_045721) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -210,6 +210,20 @@
     t.index ["site_id"], name: "index_annual_activity_requirements_on_site_id"
   end
 
+  create_table "api_requests", force: :cascade do |t|
+    t.string "ip_address", null: false
+    t.string "http_method", null: false
+    t.string "http_status"
+    t.string "path", null: false
+    t.text "params"
+    t.text "request_body"
+    t.string "request_type"
+    t.bigint "access_token_id", null: false
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+    t.index ["access_token_id"], name: "index_api_requests_on_access_token_id"
+  end
+
   create_table "appointments", id: :serial, force: :cascade do |t|
     t.integer "stream_participant_id", null: false
     t.integer "consultant_id"
@@ -1546,6 +1560,8 @@
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
     t.boolean "attendance_required", default: false
+    t.boolean "copy", default: false
+    t.bigint "origin_template_id"
     t.index ["name"], name: "index_individual_development_schedule_templates_on_name", unique: true
   end
 
@@ -1677,6 +1693,7 @@
     t.text "comment"
     t.integer "participation_rate"
     t.boolean "extension"
+    t.index ["case_number"], name: "index_jobseeker_decisions_on_case_number"
     t.index ["stream_participant_id"], name: "index_jobseeker_decisions_on_stream_participant_id"
   end
 
@@ -1988,6 +2005,7 @@
     t.index ["ess_identifier"], name: "index_jobseekers_on_ess_identifier"
     t.index ["jobseeker_lead_id"], name: "index_jobseekers_on_jobseeker_lead_id"
     t.index ["period_of_service_overridden_by_id"], name: "index_jobseekers_on_period_of_service_overridden_by_id"
+    t.index ["programme"], name: "index_jobseekers_on_programme"
     t.index ["referring_company_id"], name: "index_jobseekers_on_referring_company_id"
     t.index ["site_id"], name: "index_jobseekers_on_site_id"
     t.index ["stream_participant_id"], name: "index_jobseekers_on_stream_participant_id"
@@ -2323,7 +2341,6 @@
   end
 
   create_table "peppol_invoices", force: :cascade do |t|
-    t.string "invoice_number", null: false
     t.string "order_number", null: false
     t.bigint "jobseeker_id", null: false
     t.date "period_start_date", null: false
@@ -2338,6 +2355,7 @@
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
     t.string "invoice_type"
+    t.bigint "invoice_number", default: -> { "nextval('peppol_invoice_number_seq'::regclass)" }, null: false
     t.index ["invoice_number"], name: "index_peppol_invoices_on_invoice_number", unique: true
     t.index ["jobseeker_id"], name: "index_peppol_invoices_on_jobseeker_id"
   end
@@ -2367,8 +2385,10 @@
     t.uuid "tickstar_transaction_id"
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
+    t.index ["case_number"], name: "index_peppol_orders_on_case_number"
     t.index ["jobseeker_id"], name: "index_peppol_orders_on_jobseeker_id"
     t.index ["order_number", "jobseeker_id"], name: "index_peppol_orders_on_order_number_and_jobseeker_id", unique: true
+    t.index ["order_number"], name: "index_peppol_orders_on_order_number"
   end
 
   create_table "peppol_periodic_reports", force: :cascade do |t|
@@ -3363,6 +3383,8 @@
     t.datetime "received_at", precision: nil, null: false
     t.datetime "created_at", precision: nil, null: false
     t.datetime "updated_at", precision: nil, null: false
+    t.string "reply_id"
+    t.index ["reply_id"], name: "index_short_message_replies_on_reply_id", unique: true
     t.index ["short_message_id"], name: "index_short_message_replies_on_short_message_id"
   end
 
@@ -3380,6 +3402,7 @@
     t.date "follow_up_date"
     t.integer "reminder_id"
     t.datetime "scheduled_at", precision: nil
+    t.uuid "uuid"
     t.index ["client_id"], name: "index_short_messages_on_client_id"
     t.index ["recipient_id"], name: "index_short_messages_on_recipient_id"
     t.index ["recipient_type"], name: "index_short_messages_on_recipient_type"
@@ -3640,6 +3663,7 @@
     t.string "ss_dashboard_title"
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
+    t.boolean "enabled", default: true, null: false
   end