-ActiveRecord::Schema.define(version: 2022_07_14_054037) do
+ActiveRecord::Schema.define(version: 2022_07_18_054857) do
@@ -475,2 +475,4 @@ create_table "claims", id: :serial, force: :cascade do |t|
t.bigint "state_last_updated_by_id"
+ t.bigint "approver_id"
+ t.index ["approver_id"], name: "index_claims_on_approver_id"
t.index ["assigned_to_id"], name: "index_claims_on_assigned_to_id"
@@ -739,2 +741,4 @@ create_table "custom_alerts", force: :cascade do |t|
t.string "tag"
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_custom_alerts_on_deleted_at"
t.index ["resource_type"], name: "index_custom_alerts_on_resource_type"
@@ -1087,3 +1091,5 @@ create_table "expense_payment_types", id: :serial, force: :cascade do |t|
t.boolean "second_approval_required", default: false
+ t.datetime "deleted_at"
t.index ["company_id"], name: "index_expense_payment_types_on_company_id"
+ t.index ["deleted_at"], name: "index_expense_payment_types_on_deleted_at"
end
@@ -1223,2 +1229,3 @@ create_table "fortnight_wage_histories", force: :cascade do |t|
t.decimal "gross_income"
+ t.decimal "hours_worked", default: "0.0"
t.index ["fortnight_id"], name: "index_fortnight_wage_histories_on_fortnight_id"
@@ -1276,2 +1283,4 @@ create_table "goals", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_goals_on_deleted_at"
t.index ["goal_type_id"], name: "index_goals_on_goal_type_id"
@@ -1319,3 +1328,5 @@ create_table "internship_agreements", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.bigint "referral_id"
t.index ["jobseeker_id"], name: "index_internship_agreements_on_jobseeker_id"
+ t.index ["referral_id"], name: "index_internship_agreements_on_referral_id"
t.index ["site_id"], name: "index_internship_agreements_on_site_id"
@@ -1651,2 +1662,3 @@ create_table "jobseekers", id: :serial, force: :cascade do |t|
t.string "pronoun"
+ t.bigint "stream_participant_id"
t.index ["deleted_at"], name: "index_jobseekers_on_deleted_at"
@@ -1657,2 +1669,3 @@ create_table "jobseekers", id: :serial, force: :cascade do |t|
t.index ["site_id"], name: "index_jobseekers_on_site_id"
+ t.index ["stream_participant_id"], name: "index_jobseekers_on_stream_participant_id"
t.index ["sub_source_type", "sub_source_id"], name: "index_jobseekers_on_sub_source_type_and_sub_source_id"
@@ -2659,2 +2672,4 @@ create_table "settings", id: :serial, force: :cascade do |t|
t.string "bank_transactions_import_checksum"
+ t.string "pps_schedule_interval_stream_moderate", default: "Fortnightly"
+ t.string "pps_schedule_interval_stream_high", default: "Fortnightly"
end
@@ -3326,3 +3341,5 @@ create_table "wage_subsidy_agreements", force: :cascade do |t|
t.boolean "variable_amount", default: false, null: false
+ t.datetime "deleted_at"
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"
@@ -3426,2 +3443,4 @@ create_table "webhooks", force: :cascade do |t|
t.jsonb "headers", default: {}
+ t.datetime "deleted_at"
+ t.index ["deleted_at"], name: "index_webhooks_on_deleted_at"
end
@@ -3495,2 +3514,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "claims", "sites"
+ add_foreign_key "claims", "users", column: "approver_id"
add_foreign_key "claims", "users", column: "created_by_id"
@@ -3551,2 +3571,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "jobseekers", "jobseeker_leads"
+ add_foreign_key "jobseekers", "stream_participants"
add_foreign_key "jobseekers", "users", column: "period_of_service_overridden_by_id"