-ActiveRecord::Schema.define(version: 2021_12_07_053734) do
+ActiveRecord::Schema.define(version: 2022_01_05_052333) do
@@ -302,2 +302,3 @@ create_table "breaks", id: :serial, force: :cascade do |t|
t.string "type", default: "PermissibleBreak", null: false
+ t.string "reason"
t.index ["placement_id"], name: "index_breaks_on_placement_id"
@@ -662,2 +663,12 @@ create_table "cortex_rails_surveys", id: :serial, force: :cascade do |t|
+ create_table "custom_alerts", force: :cascade do |t|
+ t.string "name"
+ t.string "types", default: [], array: true
+ t.string "roles", default: [], array: true
+ t.bigint "saved_search_id"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["saved_search_id"], name: "index_custom_alerts_on_saved_search_id"
+ end
+
create_table "custom_expense_types", id: :serial, force: :cascade do |t|
@@ -949,3 +960,5 @@ create_table "expense_credit_cards", id: :serial, force: :cascade do |t|
t.datetime "deleted_at"
+ t.bigint "user_id"
t.index ["deleted_at"], name: "index_expense_credit_cards_on_deleted_at"
+ t.index ["user_id"], name: "index_expense_credit_cards_on_user_id"
end
@@ -1150,2 +1163,21 @@ create_table "imported_documents", id: :serial, force: :cascade do |t|
+ create_table "internship_agreements", force: :cascade do |t|
+ t.bigint "jobseeker_id", null: false
+ t.bigint "site_id", null: false
+ t.string "ess_identifier", null: false
+ t.string "referral_ess_identifier", null: false
+ t.date "approval_date"
+ t.date "end_date"
+ t.string "end_reason"
+ t.integer "hours_per_fortnight"
+ t.string "result_code"
+ t.date "result_date"
+ t.date "start_date"
+ t.string "status"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["jobseeker_id"], name: "index_internship_agreements_on_jobseeker_id"
+ t.index ["site_id"], name: "index_internship_agreements_on_site_id"
+ end
+
create_table "intervention_detail_templates", id: :serial, force: :cascade do |t|
@@ -1184,2 +1216,19 @@ create_table "job_end_reasons", id: :serial, force: :cascade do |t|
+ create_table "job_search_outcomes", force: :cascade do |t|
+ t.bigint "jobseeker_id", null: false
+ t.bigint "site_id", null: false
+ t.integer "assessment_days_outstanding"
+ t.string "assessment_outcome"
+ t.string "assessment_reason_code"
+ t.date "end_date"
+ t.integer "number_required"
+ t.integer "number_completed"
+ t.date "start_date"
+ t.date "submitted_on"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["jobseeker_id"], name: "index_job_search_outcomes_on_jobseeker_id"
+ t.index ["site_id"], name: "index_job_search_outcomes_on_site_id"
+ end
+
create_table "jobseeker_action_plans", force: :cascade do |t|
@@ -1451,2 +1500,6 @@ create_table "jobseekers", id: :serial, force: :cascade do |t|
t.bigint "sub_source_id"
+ t.date "overridden_period_of_service_started_on"
+ t.text "period_of_service_override_reason"
+ t.datetime "period_of_service_overridden_at"
+ t.bigint "period_of_service_overridden_by_id"
t.index ["deleted_at"], name: "index_jobseekers_on_deleted_at"
@@ -1454,2 +1507,3 @@ create_table "jobseekers", id: :serial, force: :cascade do |t|
t.index ["jobseeker_lead_id"], name: "index_jobseekers_on_jobseeker_lead_id"
+ t.index ["period_of_service_overridden_by_id"], name: "index_jobseekers_on_period_of_service_overridden_by_id"
t.index ["referring_company_id"], name: "index_jobseekers_on_referring_company_id"
@@ -1554,2 +1608,10 @@ create_table "marketo_access_tokens", force: :cascade do |t|
+ create_table "marketo_field_maps", force: :cascade do |t|
+ t.string "job_ready_field", null: false
+ t.string "marketo_field", null: false
+ t.string "entity_type", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "note_templates", id: :serial, force: :cascade do |t|
@@ -2409,2 +2471,6 @@ create_table "settings", id: :serial, force: :cascade do |t|
t.boolean "action_plan_status_workflow", default: false, null: false
+ t.string "pps_schedule_interval_des_dms", default: "Weekly"
+ t.string "pps_schedule_interval_des_ess", default: "Weekly"
+ t.string "support_week_starting_day", default: "sunday"
+ t.integer "wage_subsidy_payment_portal_session_timeout_in_seconds"
end
@@ -2868,2 +2934,3 @@ create_table "users", id: :serial, force: :cascade do |t|
t.boolean "can_manage_queries", default: false
+ t.boolean "can_override_period_of_service", default: false
t.index ["active"], name: "index_users_on_active"
@@ -3205,2 +3272,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "cortex_rails_organisations", "cortex_rails_api_configs", column: "api_config_id"
+ add_foreign_key "custom_alerts", "saved_searches"
add_foreign_key "emails", "reminders"
@@ -3212,2 +3280,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "expense_approvals", "expenses"
+ add_foreign_key "expense_credit_cards", "users"
add_foreign_key "expense_imports", "expense_exports"
@@ -3224,4 +3293,8 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "imported_documents", "batches"
+ add_foreign_key "internship_agreements", "jobseekers"
+ add_foreign_key "internship_agreements", "sites"
add_foreign_key "interviews", "jobseekers"
add_foreign_key "interviews", "vacancies"
+ add_foreign_key "job_search_outcomes", "jobseekers"
+ add_foreign_key "job_search_outcomes", "sites"
add_foreign_key "jobseeker_action_plans", "jobseekers"
@@ -3240,2 +3313,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "jobseekers", "jobseeker_leads"
+ add_foreign_key "jobseekers", "users", column: "period_of_service_overridden_by_id"
add_foreign_key "lead_sub_sources", "referral_sources"