Upcoming database changes RELEASE 09 May 2023

-ActiveRecord::Schema.define(version: 2023_04_20_151651) do
+ActiveRecord::Schema.define(version: 2023_05_03_045745) do

@@ -296,2 +296,3 @@ create_table "attachments", id: :serial, force: :cascade do |t|
     t.datetime "marketo_synced_at"
+    t.datetime "confirmed_at"
     t.index ["attachable_id"], name: "index_attachments_on_attachable_id"
@@ -1438,2 +1439,3 @@ create_table "goal_actions", force: :cascade do |t|
     t.text "tags", default: [], array: true
+    t.boolean "allow_due_date", default: true, null: false
   end
@@ -1608,4 +1610,4 @@ create_table "jobseeker_leads", force: :cascade do |t|
     t.string "address_line_2"
-    t.string "address_suburb", null: false
-    t.string "address_state", null: false
+    t.string "address_suburb"
+    t.string "address_state"
     t.integer "address_postcode", null: false
@@ -1635,2 +1637,6 @@ create_table "jobseeker_leads", force: :cascade do |t|
     t.datetime "created_by"
+    t.datetime "marketo_synced_at"
+    t.string "marketo_lead_id"
+    t.boolean "unsubscribed_from_bulk_emails", default: false
+    t.boolean "unsubscribed_from_bulk_sms", default: false
     t.index ["created_by_id"], name: "index_jobseeker_leads_on_created_by_id"
@@ -1903,2 +1909,8 @@ create_table "kpis", force: :cascade do |t|

+  create_table "kpis_objectives", id: false, force: :cascade do |t|
+    t.bigint "objective_id", null: false
+    t.bigint "kpi_id", null: false
+    t.index ["objective_id", "kpi_id"], name: "index_kpis_objectives_on_objective_id_and_kpi_id", unique: true
+  end
+
   create_table "lead_stages", force: :cascade do |t|
@@ -2121,2 +2133,11 @@ create_table "notes", id: :serial, force: :cascade do |t|

+  create_table "objectives", force: :cascade do |t|
+    t.string "name", null: false
+    t.boolean "active", default: true, null: false
+    t.datetime "deleted_at"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["deleted_at"], name: "index_objectives_on_deleted_at"
+  end
+
   create_table "occupations", force: :cascade do |t|
@@ -3546,2 +3567,3 @@ create_table "users", id: :serial, force: :cascade do |t|
     t.boolean "can_send_sms", default: true, null: false
+    t.boolean "ess_subs_admin", default: false, null: false
     t.index ["active"], name: "index_users_on_active"
+  end