Upcoming Database Changes RELEASE 25 AUGUST 2021

-ActiveRecord::Schema.define(version: 2021_08_03_052922) do
+ActiveRecord::Schema.define(version: 2021_08_17_002254) do

@@ -1047,2 +1047,37 @@ create_table "job_match_attribute_generator_results", force: :cascade do |t|

+ create_table "jobseeker_leads", force: :cascade do |t|
+ t.string "first_name"
+ t.string "last_name"
+ t.string "address_line_1"
+ t.string "address_line_2"
+ t.string "address_suburb", null: false
+ t.string "address_state", null: false
+ t.integer "address_postcode", null: false
+ t.date "date_of_birth"
+ t.string "crn"
+ t.string "contact_method"
+ t.string "mobile_phone_number"
+ t.string "email"
+ t.string "office_phone_number"
+ t.string "status"
+ t.datetime "in_progress_at"
+ t.bigint "lead_manager_id"
+ t.bigint "referral_source_id"
+ t.string "sub_source_type"
+ t.bigint "sub_source_id"
+ t.boolean "privacy_policy", default: false, null: false
+ t.boolean "provider_transfer", default: false, null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["lead_manager_id"], name: "index_jobseeker_leads_on_lead_manager_id"
+ t.index ["referral_source_id"], name: "index_jobseeker_leads_on_referral_source_id"
+ t.index ["sub_source_type", "sub_source_id"], name: "index_jobseeker_leads_on_sub_source_type_and_sub_source_id"
+ end
+
+ create_table "jobseeker_leads_service_of_interests", id: false, force: :cascade do |t|
+ t.bigint "jobseeker_lead_id", null: false
+ t.bigint "service_of_interest_id", null: false
+ t.index ["jobseeker_lead_id", "service_of_interest_id"], name: "index_jobseeker_lead_id_service_of_interest_id"
+ end
+
create_table "jobseeker_portal_contact_us_query_types", id: :serial, force: :cascade do |t|
@@ -1635,3 +1670,8 @@ create_table "program_referrals", force: :cascade do |t|
t.bigint "professional_service_staff_id"
+ t.bigint "cancelled_by_id"
+ t.string "cancellation_reason"
+ t.datetime "cancelled_at"
+ t.text "comments"
t.index ["approved_by_id"], name: "index_program_referrals_on_approved_by_id"
+ t.index ["cancelled_by_id"], name: "index_program_referrals_on_cancelled_by_id"
t.index ["created_by_id"], name: "index_program_referrals_on_created_by_id"
@@ -2024,2 +2064,16 @@ create_table "schedules", id: :serial, force: :cascade do |t|

+ create_table "service_descriptions", force: :cascade do |t|
+ t.text "description", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
+ create_table "service_of_interests", force: :cascade do |t|
+ t.string "name"
+ t.boolean "active"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.text "lead_types", default: [], array: true
+ end
+
create_table "settings", id: :serial, force: :cascade do |t|
@@ -2342,2 +2396,5 @@ create_table "supplier_purchase_orders", id: :serial, force: :cascade do |t|
t.string "reject_reason"
+ t.date "pre_reviewed_on"
+ t.text "pre_review_comment"
+ t.integer "pre_reviewer_id"
t.index ["company_id"], name: "index_supplier_purchase_orders_on_company_id"
@@ -2346,2 +2403,3 @@ create_table "supplier_purchase_orders", id: :serial, force: :cascade do |t|
t.index ["expense_payment_type_id"], name: "index_supplier_purchase_orders_on_expense_payment_type_id"
+ t.index ["pre_reviewer_id"], name: "index_supplier_purchase_orders_on_pre_reviewer_id"
t.index ["purchase_order_id"], name: "index_supplier_purchase_orders_on_purchase_order_id"
@@ -2790,2 +2848,4 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "interviews", "vacancies"
+ add_foreign_key "jobseeker_leads", "referral_sources"
+ add_foreign_key "jobseeker_leads", "users", column: "lead_manager_id"
add_foreign_key "jobseeker_portal_privacy_document_consents", "jobseeker_portal_privacy_document_files", column: "privacy_document_file_id"
@@ -2817,2 +2877,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "program_referrals", "users", column: "approved_by_id"
+ add_foreign_key "program_referrals", "users", column: "cancelled_by_id"
add_foreign_key "program_referrals", "users", column: "created_by_id"

Did you find it helpful? Yes No

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