Upcoming database changes RELEASE 14 March 2023

-ActiveRecord::Schema.define(version: 2023_02_15_025320) do
+ActiveRecord::Schema.define(version: 2023_03_01_034120) do

   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
@@ -361,6 +361,28 @@
     t.index ["status"], name: "index_batches_on_status"
   end

+  create_table "better_proposal_templates", force: :cascade do |t|
+    t.string "template_identifier", null: false
+    t.string "template_name"
+    t.boolean "active", default: false, null: false
+    t.boolean "external_deleted", default: false, null: false
+    t.index ["active"], name: "index_better_proposal_templates_on_active"
+    t.index ["template_identifier"], name: "index_better_proposal_templates_on_template_identifier", unique: true
+  end
+
+  create_table "better_proposals", force: :cascade do |t|
+    t.bigint "better_proposal_template_id", null: false
+    t.bigint "contact_id", null: false
+    t.bigint "company_id", null: false
+    t.bigint "created_by_id"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["better_proposal_template_id"], name: "index_better_proposals_on_better_proposal_template_id"
+    t.index ["company_id"], name: "index_better_proposals_on_company_id"
+    t.index ["contact_id"], name: "index_better_proposals_on_contact_id"
+    t.index ["created_by_id"], name: "index_better_proposals_on_created_by_id"
+  end
+
   create_table "break_reasons", force: :cascade do |t|
     t.string "name", null: false
     t.string "break_type", null: false
@@ -772,8 +794,10 @@
     t.string "tag"
     t.string "priority", default: "business_as_usual"
     t.datetime "deleted_at"
+    t.boolean "pin_status", default: false
     t.index ["priority"], name: "index_custom_alerts_on_priority"
     t.index ["deleted_at"], name: "index_custom_alerts_on_deleted_at"
+    t.index ["pin_status"], name: "index_custom_alerts_on_pin_status"
     t.index ["resource_type"], name: "index_custom_alerts_on_resource_type"
   end

@@ -932,6 +956,17 @@
     t.index ["company_id"], name: "index_employer_campaigns_on_company_id"
   end

+  create_table "employer_kpis", force: :cascade do |t|
+    t.bigint "company_id"
+    t.bigint "kpi_id"
+    t.string "actual", null: false
+    t.datetime "deleted_at"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["company_id"], name: "index_employer_kpis_on_company_id"
+    t.index ["kpi_id"], name: "index_employer_kpis_on_kpi_id"
+  end
+
   create_table "employer_statuses", force: :cascade do |t|
     t.string "name"
     t.datetime "deleted_at"
@@ -1469,6 +1504,7 @@
     t.text "result_comments"
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
+    t.text "tags", default: [], array: true
     t.index ["jobseeker_id"], name: "index_interviews_on_jobseeker_id"
     t.index ["vacancy_id"], name: "index_interviews_on_vacancy_id"
   end
@@ -1698,6 +1734,7 @@
     t.text "result_comments"
     t.integer "rejection_reason_id"
     t.datetime "marketo_synced_at"
+    t.string "engaged"
     t.index ["jobseeker_id"], name: "index_jobseeker_suggestions_on_jobseeker_id"
     t.index ["rejection_reason_id"], name: "index_jobseeker_suggestions_on_rejection_reason_id"
     t.index ["suggested_by_id"], name: "index_jobseeker_suggestions_on_suggested_by_id"
@@ -2857,6 +2894,7 @@
     t.string "pps_schedule_interval_stream_high", default: "Fortnightly"
     t.boolean "can_email_action_plan", default: false, null: false
     t.boolean "allied_health_activity_mandatory_delivery_mode", default: false, null: false
+    t.text "jobseeker_suggestion_sms_engagement_body"
   end

   create_table "short_message_replies", id: :serial, force: :cascade do |t|
@@ -3741,6 +3779,7 @@
   add_foreign_key "appointments", "health_sessions"
   add_foreign_key "appointments", "program_referrals"
   add_foreign_key "appointments", "users", column: "cancelled_by_id"
+  add_foreign_key "better_proposals", "users", column: "created_by_id"
   add_foreign_key "caseloads", "sites"
   add_foreign_key "claims", "expenses"
   add_foreign_key "claims", "jobseekers"
@@ -3763,6 +3802,8 @@
   add_foreign_key "email_events", "emails"
   add_foreign_key "emails", "reminders"
   add_foreign_key "employer_campaigns", "companies"
+  add_foreign_key "employer_kpis", "companies"
+  add_foreign_key "employer_kpis", "kpis"
   add_foreign_key "employment_hours", "jobseekers"
   add_foreign_key "employment_hours", "placements"
   add_foreign_key "employment_hours", "sites"
end