Upcoming database changes RELEASE 22 September 2021

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

@@ -745,2 +745,9 @@ create_table "employment_properties", id: :serial, force: :cascade do |t|

+ create_table "employment_property_option_quest_submissions", force: :cascade do |t|
+ t.bigint "employment_property_option_id", null: false
+ t.uuid "quest_submission_id", null: false
+ t.index ["employment_property_option_id"], name: "idx_employment_property_option_quest_submissions_on_option"
+ t.index ["quest_submission_id"], name: "idx_employment_property_option_quest_submissions_on_submission"
+ end
+
create_table "employment_property_options", force: :cascade do |t|
@@ -754,8 +761,2 @@ create_table "employment_property_options", force: :cascade do |t|

- create_table "employment_property_options_job_match_attribute_generator_resul", id: false, force: :cascade do |t|
- t.bigint "employment_property_option_id", null: false
- t.bigint "job_match_attribute_generator_result_id", null: false
- t.index ["job_match_attribute_generator_result_id", "employment_property_option_id"], name: "jma_generator_results_on_employment_property_options"
- end
-
create_table "employment_property_options_jobseekers", id: false, force: :cascade do |t|
@@ -967,2 +968,3 @@ create_table "expenses", id: :serial, force: :cascade do |t|
t.bigint "voucher_id"
+ t.bigint "wage_subsidy_payment_schedule_id"
t.index ["approver_id"], name: "index_expenses_on_approver_id"
@@ -979,2 +981,3 @@ create_table "expenses", id: :serial, force: :cascade do |t|
t.index ["voucher_id"], name: "index_expenses_on_voucher_id"
+ t.index ["wage_subsidy_payment_schedule_id"], name: "index_expenses_on_wage_subsidy_payment_schedule_id"
end
@@ -1006,2 +1009,20 @@ create_table "filter_bar_configurations", id: :serial, force: :cascade do |t|

+ create_table "goal_types", force: :cascade do |t|
+ t.string "name", null: false
+ t.boolean "default", default: false
+ t.boolean "active", default: true
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
+ create_table "goals", force: :cascade do |t|
+ t.string "code"
+ t.bigint "goal_type_id", null: false
+ t.string "name", null: false
+ t.boolean "active"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["goal_type_id"], name: "index_goals_on_goal_type_id"
+ end
+
create_table "imported_documents", id: :serial, force: :cascade do |t|
@@ -1048,14 +1069,2 @@ create_table "job_end_reasons", id: :serial, force: :cascade do |t|

- create_table "job_match_attribute_generator_results", force: :cascade do |t|
- t.bigint "jobseeker_id", null: false
- t.bigint "smart_form_id", null: false
- t.uuid "quest_submission_id", null: false
- t.datetime "removed_at"
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
- t.index ["jobseeker_id"], name: "index_job_match_attribute_generator_results_on_jobseeker_id"
- t.index ["quest_submission_id"], name: "jma_generator_results_on_quest_submission_id"
- t.index ["smart_form_id"], name: "index_job_match_attribute_generator_results_on_smart_form_id"
- end
-
create_table "jobseeker_leads", force: :cascade do |t|
@@ -1296,6 +1305,12 @@ create_table "jobseekers", id: :serial, force: :cascade do |t|
t.boolean "unsubscribed_from_bulk_emails", default: false
+ t.bigint "jobseeker_lead_id"
+ t.string "contact_method"
+ t.string "sub_source_type"
+ t.bigint "sub_source_id"
t.index ["deleted_at"], name: "index_jobseekers_on_deleted_at"
t.index ["ess_identifier"], name: "index_jobseekers_on_ess_identifier"
+ t.index ["jobseeker_lead_id"], name: "index_jobseekers_on_jobseeker_lead_id"
t.index ["referring_company_id"], name: "index_jobseekers_on_referring_company_id"
t.index ["site_id"], name: "index_jobseekers_on_site_id"
+ t.index ["sub_source_type", "sub_source_id"], name: "index_jobseekers_on_sub_source_type_and_sub_source_id"
end
@@ -1677,2 +1692,3 @@ create_table "program_referral_types", force: :cascade do |t|
t.bigint "expense_payment_type_id"
+ t.boolean "expense_gst_applied", default: false
t.index ["custom_expense_type_id"], name: "index_program_referral_types_on_custom_expense_type_id"
@@ -2672,4 +2688,6 @@ create_table "vacancies", id: :serial, force: :cascade do |t|
t.bigint "occupation_id"
+ t.bigint "employer_campaign_id"
t.index ["company_id"], name: "index_vacancies_on_company_id"
t.index ["contact_id"], name: "index_vacancies_on_contact_id"
+ t.index ["employer_campaign_id"], name: "index_vacancies_on_employer_campaign_id"
t.index ["job_ess_identifier"], name: "index_vacancies_on_job_ess_identifier", unique: true
@@ -2762,3 +2780,2 @@ create_table "wage_subsidy_agreements", force: :cascade do |t|
t.bigint "custom_expense_type_id"
- t.uuid "quest_form_id", null: false
t.string "name", null: false
@@ -2769,2 +2786,4 @@ create_table "wage_subsidy_agreements", force: :cascade do |t|
t.bigint "expense_payment_type_id"
+ t.string "wage_subsidy_type"
+ t.uuid "smart_form_id"
t.index ["custom_expense_type_id"], name: "index_wage_subsidy_agreements_on_custom_expense_type_id"
@@ -2772,3 +2791,3 @@ create_table "wage_subsidy_agreements", force: :cascade do |t|
t.index ["name"], name: "index_wage_subsidy_agreements_on_name", unique: true
- t.index ["quest_form_id"], name: "index_wage_subsidy_agreements_on_quest_form_id"
+ t.index ["smart_form_id"], name: "index_wage_subsidy_agreements_on_smart_form_id"
end
@@ -2872,3 +2891,5 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "expenses", "vouchers"
+ add_foreign_key "expenses", "wage_subsidy_payment_schedules"
add_foreign_key "filter_bar_configurations", "users"
+ add_foreign_key "goals", "goal_types"
add_foreign_key "imported_documents", "batches"
@@ -2885,2 +2906,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "jobseekers", "companies", column: "referring_company_id"
+ add_foreign_key "jobseekers", "jobseeker_leads"
add_foreign_key "lead_sub_sources", "referral_sources"
@@ -2939,2 +2961,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "vacancies", "contacts"
+ add_foreign_key "vacancies", "employer_campaigns"
add_foreign_key "vacancies", "licence_requirements"

Did you find it helpful? Yes No

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