Upcoming database changes RELEASE 12 April 2023

-ActiveRecord::Schema.define(version: 2023_03_22_040344) do
+ActiveRecord::Schema.define(version: 2023_04_01_014214) do

@@ -702,3 +702,7 @@
     t.datetime "converted_at"
+    t.bigint "lead_stage_id"
+    t.bigint "lead_sub_stage_id"
     t.index ["lead_manager_id"], name: "index_company_leads_on_lead_manager_id"
+    t.index ["lead_stage_id"], name: "index_company_leads_on_lead_stage_id"
+    t.index ["lead_sub_stage_id"], name: "index_company_leads_on_lead_sub_stage_id"
     t.index ["referral_source_id"], name: "index_company_leads_on_referral_source_id"
@@ -813,4 +817,4 @@
     t.string "tag"
-    t.string "priority", default: "business_as_usual"
     t.datetime "deleted_at"
+    t.string "priority", default: "business_as_usual"
     t.boolean "pin_status", default: false
@@ -1615,3 +1619,7 @@
     t.datetime "updated_at", null: false
+    t.bigint "lead_stage_id"
+    t.bigint "lead_sub_stage_id"
     t.index ["lead_manager_id"], name: "index_jobseeker_leads_on_lead_manager_id"
+    t.index ["lead_stage_id"], name: "index_jobseeker_leads_on_lead_stage_id"
+    t.index ["lead_sub_stage_id"], name: "index_jobseeker_leads_on_lead_sub_stage_id"
     t.index ["referral_source_id"], name: "index_jobseeker_leads_on_referral_source_id"
@@ -1859,2 +1867,13 @@

+  create_table "kanban_colour_types", force: :cascade do |t|
+    t.string "status"
+    t.string "colour"
+    t.integer "from"
+    t.integer "to"
+    t.string "kind"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["kind"], name: "index_kanban_colour_types_on_kind"
+  end
+
   create_table "kpis", force: :cascade do |t|
@@ -2025,2 +2044,3 @@
     t.datetime "updated_at", precision: 6, null: false
+    t.string "status", default: "incomplete"
     t.index ["company_id"], name: "index_meetings_on_company_id"
@@ -2336,2 +2356,3 @@
     t.boolean "expense_gst_applied", default: false
+    t.boolean "no_expense"
     t.index ["custom_expense_type_id"], name: "index_program_referral_types_on_custom_expense_type_id"
@@ -3895,2 +3916,4 @@
   add_foreign_key "companies", "users", column: "recruitment_coordinator_id"
+  add_foreign_key "company_leads", "lead_stages"
+  add_foreign_key "company_leads", "lead_sub_stages"
   add_foreign_key "company_leads", "referral_sources"
@@ -3941,2 +3964,4 @@
   add_foreign_key "jobseeker_goals", "users", column: "created_by_id"
+  add_foreign_key "jobseeker_leads", "lead_stages"
+  add_foreign_key "jobseeker_leads", "lead_sub_stages"
   add_foreign_key "jobseeker_leads", "referral_sources"
end

Did you find it helpful? Yes No

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