-ActiveRecord::Schema.define(version: 2022_07_18_054857) do
+ActiveRecord::Schema.define(version: 2022_08_02_055146) do
# These are extensions that must be enabled in order to support this database
enable_extension "citext"
@@ -1272,6 +1272,8 @@
t.boolean "active", default: true
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_goal_types_on_deleted_at"
end
create_table "goals", force: :cascade do |t|
@@ -1391,6 +1393,7 @@
t.datetime "updated_at", null: false
t.datetime "approved_at"
t.text "jobseeker_comments"
+ t.string "previous_system_identifier"
t.index ["jobseeker_id"], name: "index_jobseeker_action_plans_on_jobseeker_id"
end
@@ -1930,6 +1933,7 @@
t.integer "basic_rate_upper"
t.string "basic_rate_name"
t.integer "basic_rate_base"
+ t.date "dhs_cycle_date"
t.index ["additional_ess_data"], name: "index_placements_on_additional_ess_data", using: :gin
t.index ["centrelink_outcome_started_on"], name: "index_placements_on_centrelink_outcome_started_on"
t.index ["completion_expected_updated_by_id"], name: "index_placements_on_completion_expected_updated_by_id"
@@ -2203,6 +2207,8 @@
t.text "types", default: [], array: true
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_query_reasons_on_deleted_at"
end
create_table "query_types", force: :cascade do |t|
@@ -2752,6 +2758,8 @@
t.string "email"
t.string "finance_code"
t.string "outlet_id"
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_sites_on_deleted_at"
t.index ["ess_identifier"], name: "index_sites_on_ess_identifier", unique: true
t.index ["location_id"], name: "index_sites_on_location_id"
t.index ["second_level_site_grouping_id"], name: "index_sites_on_second_level_site_grouping_id"
@@ -3153,6 +3161,12 @@
t.boolean "can_add_permissible_break", default: true, null: false
t.boolean "can_update_supplier_paid_date", default: false, null: false
t.boolean "can_create_wfa_placement", default: false, null: false
+ t.boolean "mfa_enabled", default: false
+ t.string "encrypted_otp_secret"
+ t.string "encrypted_otp_secret_iv"
+ t.string "encrypted_otp_secret_salt"
+ t.integer "consumed_timestep"
+ t.boolean "otp_required_for_login"
t.index ["active"], name: "index_users_on_active"
t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true
t.index ["delegate_id"], name: "index_users_on_delegate_id"
@@ -3340,6 +3354,7 @@
t.string "wage_subsidy_type"
t.boolean "variable_amount", default: false, null: false
t.datetime "deleted_at"
+ t.string "previous_system_identifier"
t.index ["custom_expense_type_id"], name: "index_wage_subsidy_agreements_on_custom_expense_type_id"
t.index ["deleted_at"], name: "index_wage_subsidy_agreements_on_deleted_at"
t.index ["expense_payment_type_id"], name: "index_wage_subsidy_agreements_on_expense_payment_type_id"
@@ -3366,6 +3381,7 @@
t.bigint "document_library_file_id"
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
+ t.string "previous_system_identifier"
t.index ["document_library_file_id"], name: "index_ws_ps_template_installment_on_document_library_file_id"
t.index ["wage_subsidy_payment_schedule_template_id"], name: "index_ws_ps_template_installment_on_ws_ps_template_id"
end
@@ -3378,6 +3394,7 @@
t.boolean "active", default: true, null: false
t.datetime "created_at", null: false
t.datetime "updated_at", null: false
+ t.string "previous_system_identifier"
t.index ["name"], name: "index_wage_subsidy_payment_schedule_templates_on_name", unique: true
t.index ["wage_subsidy_agreement_id"], name: "index_ws_payment_schedule_templates_on_ws_agreement_id"
end