Upcoming database changes RELEASE 10 October 2023

--- a/db/schema.rb
+++ b/db/schema.rb
@@ -1536,6 +1536,25 @@
     t.index ["name"], name: "index_individual_development_schedule_templates_on_name", unique: true
   end

+  create_table "individual_development_schedules", force: :cascade do |t|
+    t.integer "stream_participant_id", null: false
+    t.integer "jobseeker_id", null: false
+    t.integer "created_by_id", null: false
+    t.integer "individual_development_schedule_template_id"
+    t.datetime "starts_at"
+    t.datetime "ends_at"
+    t.text "title"
+    t.text "description"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.string "location"
+    t.boolean "is_remote", default: false
+    t.boolean "is_onsite", default: false
+    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 ["stream_participant_id"], name: "index_individual_development_schedules_on_stream_participant_id"
+  end
+
   create_table "internship_agreements", force: :cascade do |t|
     t.bigint "jobseeker_id", null: false
     t.bigint "site_id", null: false
@@ -1919,6 +1938,10 @@
     t.string "pronoun"
     t.bigint "stream_participant_id"
     t.boolean "confidential", default: false, null: false
+    t.string "residential_address_county"
+    t.string "residential_address_city"
+    t.string "postal_address_county"
+    t.string "postal_address_city"
     t.index ["deleted_at"], name: "index_jobseekers_on_deleted_at"
     t.index ["ess_identifier"], name: "index_jobseekers_on_ess_identifier"
     t.index ["jobseeker_lead_id"], name: "index_jobseekers_on_jobseeker_lead_id"
@@ -2067,6 +2090,9 @@
     t.string "resource_type"
     t.datetime "created_at"
     t.datetime "updated_at"
+    t.string "country_code", default: "AU"
+    t.string "county"
+    t.string "city"
     t.index ["address_line_1", "address_line_2", "suburb", "postcode"], name: "locations_address_suburb_postcode"
   end

@@ -3155,6 +3181,7 @@
     t.integer "company_leads_auto_close_days", default: 30
     t.string "time_zone", default: "Australia/Sydney"
     t.string "locale", default: "en"
+    t.string "country_code", default: "AU"
   end

   create_table "short_message_replies", id: :serial, force: :cascade do |t|
(END)

Did you find it helpful? Yes No

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