-ActiveRecord::Schema.define(version: 2021_06_07_235457) do
+ActiveRecord::Schema.define(version: 2021_06_29_010657) do
@@ -363,2 +363,3 @@ create_table "claims", id: :serial, force: :cascade do |t|
t.date "forecast_date"
+ t.bigint "state_last_updated_by_id"
t.index ["assigned_to_id"], name: "index_claims_on_assigned_to_id"
@@ -373,2 +374,3 @@ create_table "claims", id: :serial, force: :cascade do |t|
t.index ["state"], name: "index_claims_on_state"
+ t.index ["state_last_updated_by_id"], name: "index_claims_on_state_last_updated_by_id"
t.index ["status"], name: "index_claims_on_status"
@@ -487,2 +489,24 @@ create_table "companies_wage_subsidy_agreements", id: false, force: :cascade do
+ create_table "company_leads", force: :cascade do |t|
+ t.bigint "lead_manager_id"
+ t.bigint "site_id", null: false
+ t.string "status"
+ t.string "name", null: false
+ t.string "abn_name"
+ t.string "abn"
+ t.string "address_line_1"
+ t.string "address_line_2"
+ t.string "address_line_3"
+ t.string "address_suburb", null: false
+ t.string "address_state", null: false
+ t.string "address_postcode", null: false
+ t.datetime "in_progress_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.string "reason_for_holding"
+ t.string "reason_for_closing"
+ t.index ["lead_manager_id"], name: "index_company_leads_on_lead_manager_id"
+ t.index ["site_id"], name: "index_company_leads_on_site_id"
+ end
create_table "company_types", force: :cascade do |t|
@@ -1190,2 +1214,11 @@ create_table "jobseekers", id: :serial, force: :cascade do |t|
+ create_table "lead_sub_sources", force: :cascade do |t|
+ t.string "name", null: false
+ t.bigint "referral_source_id"
+ t.boolean "active", default: false, null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["referral_source_id"], name: "index_lead_sub_sources_on_referral_source_id"
+ end
create_table "letters_letter_heads", id: :serial, force: :cascade do |t|
@@ -1510,4 +1543,6 @@ create_table "professional_service_activities", id: :serial, force: :cascade do
t.integer "template_id"
+ t.bigint "program_referral_id"
t.index ["intervention_provided_by_id"], name: "index_indigenous_mentoring_activities_on_user_id"
t.index ["jobseeker_id"], name: "index_professional_service_activities_on_jobseeker_id"
+ t.index ["program_referral_id"], name: "index_professional_service_activities_on_program_referral_id"
end
@@ -1551,2 +1586,4 @@ create_table "program_referrals", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.bigint "created_by_id"
+ t.bigint "justification_template_id"
t.bigint "rejected_by_id"
@@ -1556,4 +1593,3 @@ create_table "program_referrals", force: :cascade do |t|
t.datetime "approved_at"
- t.bigint "justification_template_id"
- t.bigint "created_by_id"
+ t.bigint "professional_service_staff_id"
t.index ["approved_by_id"], name: "index_program_referrals_on_approved_by_id"
@@ -1562,2 +1598,3 @@ create_table "program_referrals", force: :cascade do |t|
t.index ["justification_template_id"], name: "index_program_referrals_on_justification_template_id"
+ t.index ["professional_service_staff_id"], name: "index_program_referrals_on_professional_service_staff_id"
t.index ["program_id"], name: "index_program_referrals_on_program_id"
@@ -1651,2 +1688,9 @@ create_table "quest_fields", id: :serial, force: :cascade do |t|
+ create_table "quest_fields_smart_forms", id: false, force: :cascade do |t|
+ t.bigint "quest_field_id", null: false
+ t.uuid "smart_form_id", null: false
+ t.index ["quest_field_id"], name: "index_quest_fields_smart_forms_on_quest_field_id"
+ t.index ["smart_form_id"], name: "index_quest_fields_smart_forms_on_smart_form_id"
+ end
create_table "quest_form_versions", id: :serial, force: :cascade do |t|
@@ -1778,2 +1822,4 @@ create_table "referral_sources", id: :serial, force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.boolean "active", default: true, null: false
+ t.string "lead_sub_source_type", default: "optional"
end
@@ -2548,2 +2594,16 @@ create_table "voucher_types", force: :cascade do |t|
+ create_table "vouchers", force: :cascade do |t|
+ t.bigint "site_float_id", null: false
+ t.string "barcode", null: false
+ t.string "url"
+ t.string "status"
+ t.datetime "received_at"
+ t.datetime "issued_at"
+ t.datetime "missing_at"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["barcode"], name: "index_vouchers_on_barcode", unique: true
+ t.index ["site_float_id"], name: "index_vouchers_on_site_float_id"
+ end
create_table "wage_histories", id: :serial, force: :cascade do |t|
@@ -2661,2 +2721,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "claims", "users", column: "created_by_id"
+ add_foreign_key "claims", "users", column: "state_last_updated_by_id"
add_foreign_key "claims_weekly_snapshots", "sites"
@@ -2665,2 +2726,4 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "companies", "users", column: "recruitment_coordinator_id"
+ add_foreign_key "company_leads", "sites"
+ add_foreign_key "company_leads", "users", column: "lead_manager_id"
add_foreign_key "contacts", "users", column: "created_by_id"
@@ -2687,2 +2750,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "jobseekers", "companies", column: "referring_company_id"
+ add_foreign_key "lead_sub_sources", "referral_sources"
add_foreign_key "line_items", "expenses"
@@ -2699,2 +2763,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "pps_records", "placements"
+ add_foreign_key "professional_service_activities", "program_referrals"
add_foreign_key "professional_service_staff", "users"
@@ -2711,2 +2776,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "programs", "smart_forms"
+ add_foreign_key "quest_fields_smart_forms", "smart_forms"
add_foreign_key "quest_submission_view_tokens", "quest_submissions"
@@ -2739,2 +2805,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "vacancy_checklist_items", "vacancies"
+ add_foreign_key "vouchers", "site_floats"
add_foreign_key "wage_subsidy_agreements", "custom_expense_types"