-ActiveRecord::Schema.define(version: 2022_01_31_011833) do
+ActiveRecord::Schema.define(version: 2022_02_09_193027) do
@@ -849,2 +849,3 @@ create_table "employment_hours", force: :cascade do |t|
t.index ["jobseeker_id"], name: "index_employment_hours_on_jobseeker_id"
+ t.index ["outcome_type"], name: "index_employment_hours_on_outcome_type"
t.index ["placement_id"], name: "index_employment_hours_on_placement_id"
@@ -1102,3 +1103,5 @@ create_table "expenses", id: :serial, force: :cascade do |t|
t.decimal "refunded_amount"
+ t.bigint "bank_transaction_id"
t.index ["approver_id"], name: "index_expenses_on_approver_id"
+ t.index ["bank_transaction_id"], name: "index_expenses_on_bank_transaction_id"
t.index ["expense_payment_type_id"], name: "index_expenses_on_expense_payment_type_id"
@@ -1175,2 +1178,16 @@ create_table "goals", force: :cascade do |t|
+ create_table "health_sessions", force: :cascade do |t|
+ t.bigint "site_id"
+ t.bigint "program_id"
+ t.integer "created_by_id"
+ t.datetime "starts_at", null: false
+ t.datetime "ends_at", null: false
+ t.integer "capacity", default: 1
+ t.string "status"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["program_id"], name: "index_health_sessions_on_program_id"
+ t.index ["site_id"], name: "index_health_sessions_on_site_id"
+ end
+
create_table "imported_documents", id: :serial, force: :cascade do |t|
@@ -1788,2 +1805,7 @@ create_table "placements", id: :serial, force: :cascade do |t|
t.integer "activity_sequence_number"
+ t.integer "basic_rate_lower"
+ t.integer "basic_rate_mid"
+ t.integer "basic_rate_upper"
+ t.string "basic_rate_circumstance"
+ t.integer "basic_rate_base"
t.index ["additional_ess_data"], name: "index_placements_on_additional_ess_data", using: :gin
@@ -2956,2 +2978,3 @@ create_table "users", id: :serial, force: :cascade do |t|
t.boolean "can_override_period_of_service", default: false
+ t.boolean "can_reconcile_bank_transaction", default: false
t.index ["active"], name: "index_users_on_active"
@@ -3303,2 +3326,3 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "expense_payment_types", "companies"
+ add_foreign_key "expenses", "bank_transactions"
add_foreign_key "expenses", "expense_credit_cards"
@@ -3312,2 +3336,4 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "goals", "goal_types"
+ add_foreign_key "health_sessions", "programs"
+ add_foreign_key "health_sessions", "sites"
add_foreign_key "imported_documents", "batches"