Upcoming database changes RELEASE 5 October 2021

-ActiveRecord::Schema.define(version: 2021_09_13_221640) do
+ActiveRecord::Schema.define(version: 2021_09_24_045430) do

@@ -182,2 +182,3 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
t.json "batch_data"
+ t.index ["ess_identifier"], name: "index_appointments_on_ess_identifier"
t.index ["stream_participant_id"], name: "index_appointments_on_stream_participant_id"
@@ -414,2 +415,11 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do

+ create_table "communication_preferences", force: :cascade do |t|
+ t.integer "order_number", null: false
+ t.string "resource_type", null: false
+ t.string "contact_method", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["resource_type"], name: "index_communication_preferences_on_resource_type"
+ end
+
create_table "companies", id: :serial, force: :cascade do |t|
@@ -478,2 +488,3 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
t.index ["entity_type"], name: "index_companies_on_entity_type"
+ t.index ["ess_identifier"], name: "index_companies_on_ess_identifier"
t.index ["parent_id"], name: "index_companies_on_parent_id"
@@ -1009,2 +1020,17 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do

+ create_table "goal_actions", force: :cascade do |t|
+ t.string "name"
+ t.integer "due_period"
+ t.string "period_type"
+ t.boolean "jobseeker_to_action"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.text "tags", default: [], array: true
+ end
+
+ create_table "goal_actions_goals", id: false, force: :cascade do |t|
+ t.bigint "goal_action_id", null: false
+ t.bigint "goal_id", null: false
+ end
+
create_table "goal_types", force: :cascade do |t|
@@ -1069,2 +1095,15 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do

+ create_table "jobseeker_goals", force: :cascade do |t|
+ t.bigint "jobseeker_id", null: false
+ t.bigint "goal_id", null: false
+ t.bigint "created_by_id"
+ t.datetime "completed_at"
+ t.string "status", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["created_by_id"], name: "index_jobseeker_goals_on_created_by_id"
+ t.index ["goal_id"], name: "index_jobseeker_goals_on_goal_id"
+ t.index ["jobseeker_id"], name: "index_jobseeker_goals_on_jobseeker_id"
+ end
+
create_table "jobseeker_leads", force: :cascade do |t|
@@ -2009,2 +2048,3 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
t.text "comment"
+ t.index ["completed_by_id"], name: "index_reminders_on_completed_by_id"
t.index ["created_by_id"], name: "index_reminders_on_created_by_id"
@@ -2168,2 +2208,9 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
t.string "default_email_signature_logo"
+ t.boolean "use_jobseeker_communication_preferences", default: false, null: false
+ t.boolean "use_organisation_communication_preferences", default: false, null: false
+ t.string "communication_policy_active_days", default: [], array: true
+ t.time "communication_policy_start_time"
+ t.time "communication_policy_end_time"
+ t.boolean "communication_policy_active", default: false, null: false
+ t.boolean "action_plan_status_workflow", default: false, null: false
end
@@ -2215,2 +2262,4 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
t.datetime "updated_at", null: false
+ t.bigint "custom_expense_type_id"
+ t.index ["custom_expense_type_id"], name: "index_site_floats_on_custom_expense_type_id"
t.index ["site_id"], name: "index_site_floats_on_site_id"
@@ -2786,4 +2835,4 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
t.bigint "expense_payment_type_id"
- t.string "wage_subsidy_type"
t.uuid "smart_form_id"
+ t.string "wage_subsidy_type"
t.index ["custom_expense_type_id"], name: "index_wage_subsidy_agreements_on_custom_expense_type_id"
@@ -2812,2 +2861,4 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
t.datetime "updated_at", null: false
+ t.bigint "contact_id"
+ t.index ["contact_id"], name: "index_wage_subsidy_payment_schedules_on_contact_id"
t.index ["wage_subsidy_payment_schedule_template_id"], name: "index_ws_payment_schedules_on_ws_payment_schedule_template_id"
@@ -2897,2 +2948,5 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
add_foreign_key "interviews", "vacancies"
+ add_foreign_key "jobseeker_goals", "goals"
+ add_foreign_key "jobseeker_goals", "jobseekers"
+ add_foreign_key "jobseeker_goals", "users", column: "created_by_id"
add_foreign_key "jobseeker_leads", "referral_sources"
@@ -2945,2 +2999,3 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
add_foreign_key "site_floats", "companies", column: "supplier_id"
+ add_foreign_key "site_floats", "custom_expense_types"
add_foreign_key "site_floats", "sites"
@@ -2970,2 +3025,3 @@ ActiveRecord::Schema.define(version: 2021_09_13_221640) do
add_foreign_key "wage_subsidy_payment_schedule_templates", "wage_subsidy_agreements"
+ add_foreign_key "wage_subsidy_payment_schedules", "contacts"
add_foreign_key "wage_subsidy_payment_schedules", "wage_subsidy_payment_schedule_templates"