-ActiveRecord::Schema.define(version: 2022_05_04_074655) do
+ActiveRecord::Schema.define(version: 2022_06_07_034505) do
@@ -1262,3 +1262,5 @@ create_table "health_sessions", force: :cascade do |t|
t.integer "available", default: 1
+ t.bigint "repeat_id"
t.index ["program_id"], name: "index_health_sessions_on_program_id"
+ t.index ["repeat_id"], name: "index_health_sessions_on_repeat_id"
t.index ["site_id"], name: "index_health_sessions_on_site_id"
@@ -1983,2 +1985,3 @@ create_table "professional_service_activities", id: :serial, force: :cascade do
t.json "expense_type_properties", default: {}
+ t.string "previous_system_identifier"
t.index ["intervention_provided_by_id"], name: "index_indigenous_mentoring_activities_on_user_id"
@@ -2042,2 +2045,3 @@ create_table "program_referrals", force: :cascade do |t|
t.text "comments"
+ t.string "previous_system_identifier"
t.index ["approved_by_id"], name: "index_program_referrals_on_approved_by_id"
@@ -2083,2 +2087,3 @@ create_table "programs", force: :cascade do |t|
t.integer "number_of_referrals_cap_per_jobseeker"
+ t.string "previous_system_identifier"
t.index ["company_id"], name: "index_programs_on_company_id"
@@ -2146,2 +2151,3 @@ create_table "queries", force: :cascade do |t|
t.text "reasons", default: [], array: true
+ t.bigint "note_id"
t.index ["assigned_to_id"], name: "index_queries_on_assigned_to_id"
@@ -2149,2 +2155,3 @@ create_table "queries", force: :cascade do |t|
t.index ["jobseeker_id"], name: "index_queries_on_jobseeker_id"
+ t.index ["note_id"], name: "index_queries_on_note_id"
t.index ["note_template_id"], name: "index_queries_on_note_template_id"
@@ -2403,2 +2410,3 @@ create_table "referrals", id: :serial, force: :cascade do |t|
t.datetime "marketo_synced_at"
+ t.string "special_vacancy_type_code"
t.index ["created_by_id"], name: "index_referrals_on_created_by_id"
@@ -2453,3 +2461,9 @@ create_table "repeats", id: :serial, force: :cascade do |t|
t.boolean "active", default: true, null: false
+ t.text "type", default: "RepeatReminder", null: false
+ t.date "from"
+ t.date "to"
+ t.date "cursor"
t.index ["active"], name: "index_repeats_on_active"
+ t.index ["cursor"], name: "index_repeats_on_cursor"
+ t.index ["to"], name: "index_repeats_on_to"
end
@@ -2735,2 +2749,8 @@ create_table "smtp_settings", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.string "imap_address"
+ t.integer "imap_port"
+ t.string "imap_user_name"
+ t.string "encrypted_imap_password"
+ t.string "encrypted_imap_password_iv"
+ t.string "imap_email"
end
@@ -3086,2 +3106,3 @@ create_table "users", id: :serial, force: :cascade do |t|
t.boolean "can_add_permissible_break", default: true, null: false
+ t.boolean "can_update_supplier_paid_date", default: false, null: false
t.index ["active"], name: "index_users_on_active"
@@ -3320,2 +3341,3 @@ create_table "wage_subsidy_payment_schedules", force: :cascade do |t|
t.bigint "contact_id"
+ t.string "previous_system_identifier"
t.index ["contact_id"], name: "index_wage_subsidy_payment_schedules_on_contact_id"
@@ -3348,2 +3370,3 @@ create_table "wage_subsidy_requests", force: :cascade do |t|
t.text "cancel_reason"
+ t.string "previous_system_identifier"
t.index "((id)::text) text_pattern_ops", name: "index_wage_subsidy_requests_on_cast_id_as_text"
@@ -3370,2 +3393,23 @@ create_table "webhooks", force: :cascade do |t|
+ create_table "week_wage_histories", force: :cascade do |t|
+ t.bigint "week_id"
+ t.bigint "wage_history_id"
+ t.decimal "gross_income"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["wage_history_id"], name: "index_week_wage_histories_on_wage_history_id"
+ t.index ["week_id"], name: "index_week_wage_histories_on_week_id"
+ end
+
+ create_table "weeks", force: :cascade do |t|
+ t.bigint "placement_id"
+ t.date "start_date", null: false
+ t.date "end_date", null: false
+ t.string "stage", null: false
+ t.boolean "apply_break", default: false, null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["placement_id"], name: "index_weeks_on_placement_id"
+ end
+
create_table "why_chooses", id: :serial, force: :cascade do |t|
@@ -3449,2 +3493,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "health_sessions", "programs"
+ add_foreign_key "health_sessions", "repeats"
add_foreign_key "health_sessions", "sites"
@@ -3505,2 +3550,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "queries", "note_templates"
+ add_foreign_key "queries", "notes"
add_foreign_key "queries", "users", column: "assigned_to_id"