-ActiveRecord::Schema.define(version: 2021_09_24_045430) do
+ActiveRecord::Schema.define(version: 2021_10_07_002031) do
@@ -153,2 +153,32 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
+ create_table "annual_activity_requirements", force: :cascade do |t|
+ t.bigint "site_id"
+ t.bigint "jobseeker_id"
+ t.integer "activity_id", null: false
+ t.integer "activity_referral_sequence_number", null: false
+ t.boolean "activity_for_own_org", default: false, null: false
+ t.boolean "activity_placement_from_same_org", default: false, null: false
+ t.string "activity_status"
+ t.string "activity_sub_type_code"
+ t.string "activity_type_code"
+ t.date "actual_end_date"
+ t.date "actual_start_date"
+ t.jsonb "additional_ess_data", default: {}, null: false
+ t.string "attendance_type"
+ t.string "exit_reason_code"
+ t.date "expected_end_date"
+ t.date "expected_start_date"
+ t.boolean "has_aar", default: false, null: false
+ t.string "parent_activity_description"
+ t.string "parent_activity_name"
+ t.string "parent_claiming_org_code"
+ t.string "parent_claiming_org_name"
+ t.string "status_code"
+ t.string "type_code"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["jobseeker_id"], name: "index_annual_activity_requirements_on_jobseeker_id"
+ t.index ["site_id"], name: "index_annual_activity_requirements_on_site_id"
+ end
+
create_table "appointments", id: :serial, force: :cascade do |t|
@@ -1095,2 +1125,11 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
+ create_table "jobseeker_action_plans", force: :cascade do |t|
+ t.bigint "jobseeker_id", null: false
+ t.string "overarching_goal"
+ t.string "status", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["jobseeker_id"], name: "index_jobseeker_action_plans_on_jobseeker_id"
+ end
+
create_table "jobseeker_goals", force: :cascade do |t|
@@ -1818,2 +1857,13 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
+ create_table "queries", force: :cascade do |t|
+ t.bigint "created_by_id"
+ t.integer "query_type_id"
+ t.string "priority"
+ t.string "state"
+ t.text "notes"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["created_by_id"], name: "index_queries_on_created_by_id"
+ end
+
create_table "quest_engine_pdf_templates", force: :cascade do |t|
@@ -2048,2 +2098,3 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
t.text "comment"
+ t.bigint "goal_id"
t.index ["completed_by_id"], name: "index_reminders_on_completed_by_id"
@@ -2051,2 +2102,3 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
t.index ["deleted_at"], name: "index_reminders_on_deleted_at"
+ t.index ["goal_id"], name: "index_reminders_on_goal_id"
t.index ["remindable_type", "remindable_id"], name: "index_reminders_on_remindable_type_and_remindable_id"
@@ -2669,2 +2721,3 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
t.boolean "can_manage_employer_campaigns", default: false, null: false
+ t.boolean "can_create_ja_placement", default: false, null: false
t.index ["active"], name: "index_users_on_active"
@@ -2736,4 +2789,4 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
t.json "batch_data"
- t.bigint "occupation_id"
t.bigint "employer_campaign_id"
+ t.bigint "occupation_id"
t.index ["company_id"], name: "index_vacancies_on_company_id"
@@ -2837,2 +2890,3 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
t.string "wage_subsidy_type"
+ t.boolean "variable_amount", default: false, null: false
t.index ["custom_expense_type_id"], name: "index_wage_subsidy_agreements_on_custom_expense_type_id"
@@ -2884,4 +2938,8 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
t.datetime "second_approved_at"
+ t.datetime "ended_at"
+ t.bigint "ended_by_id"
+ t.text "end_reason"
t.index "((id)::text) text_pattern_ops", name: "index_wage_subsidy_requests_on_cast_id_as_text"
t.index ["custom_expense_type_id"], name: "index_wage_subsidy_requests_on_custom_expense_type_id"
+ t.index ["ended_by_id"], name: "index_wage_subsidy_requests_on_ended_by_id"
t.index ["first_approved_by_id"], name: "index_wage_subsidy_requests_on_first_approved_by_id"
@@ -2914,2 +2972,4 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
+ add_foreign_key "annual_activity_requirements", "jobseekers"
+ add_foreign_key "annual_activity_requirements", "sites"
add_foreign_key "caseloads", "sites"
@@ -2948,2 +3008,3 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
add_foreign_key "interviews", "vacancies"
+ add_foreign_key "jobseeker_action_plans", "jobseekers"
add_foreign_key "jobseeker_goals", "goals"
@@ -2991,2 +3052,3 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
add_foreign_key "quest_submission_view_tokens", "quest_submissions"
+ add_foreign_key "reminders", "goals"
add_foreign_key "reminders", "repeats"
@@ -3031,2 +3093,3 @@ ActiveRecord::Schema.define(version: 2021_09_24_045430) do
add_foreign_key "wage_subsidy_requests", "placements"
+ add_foreign_key "wage_subsidy_requests", "users", column: "ended_by_id"
add_foreign_key "wage_subsidy_requests", "users", column: "first_approved_by_id"