Upcoming database changes RELEASE 05 June 2024

-ActiveRecord::Schema[7.0].define(version: 2024_05_14_182401) do
+ActiveRecord::Schema[7.0].define(version: 2024_06_03_091936) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
   enable_extension "hstore"
@@ -210,7 +210,11 @@
     t.string "progress_payment_status"
     t.bigint "progress_payment_id"
     t.text "justification"
+    t.bigint "created_by_id"
+    t.bigint "placement_id"
+    t.index ["created_by_id"], name: "index_annual_activity_requirements_on_created_by_id"
     t.index ["jobseeker_id"], name: "index_annual_activity_requirements_on_jobseeker_id"
+    t.index ["placement_id"], name: "index_annual_activity_requirements_on_placement_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
@@ -4421,7 +4425,9 @@
 
   add_foreign_key "abn_verifications", "companies"
   add_foreign_key "annual_activity_requirements", "jobseekers"
+  add_foreign_key "annual_activity_requirements", "placements"
   add_foreign_key "annual_activity_requirements", "sites"
+  add_foreign_key "annual_activity_requirements", "users", column: "created_by_id"
   add_foreign_key "appointments", "health_sessions"
   add_foreign_key "appointments", "program_referrals"
   add_foreign_key "appointments", "users", column: "cancelled_by_id"

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.