-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