Upcoming database changes RELEASE 18 MAY 2021

-ActiveRecord::Schema.define(version: 2021_04_29_014205) do
+ActiveRecord::Schema.define(version: 2021_05_11_041616) do

@@ -181,2 +181,3 @@ create_table "appointments", id: :serial, force: :cascade do |t|
t.date "next_appointment_date"
+ t.json "batch_data"
t.index ["stream_participant_id"], name: "index_appointments_on_stream_participant_id"
@@ -2130,3 +2131,2 @@ create_table "supplier_purchase_orders", id: :serial, force: :cascade do |t|
t.integer "created_by_id"
- t.integer "approver_id"
t.string "status", default: "pending", null: false
@@ -2460,3 +2460,5 @@ create_table "wage_subsidy_agreements", force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.bigint "expense_payment_type_id"
t.index ["custom_expense_type_id"], name: "index_wage_subsidy_agreements_on_custom_expense_type_id"
+ t.index ["expense_payment_type_id"], name: "index_wage_subsidy_agreements_on_expense_payment_type_id"
t.index ["name"], name: "index_wage_subsidy_agreements_on_name", unique: true
@@ -2480,5 +2482,5 @@ create_table "wage_subsidy_requests", force: :cascade do |t|
t.text "rejection_reason"
- t.index "((id)::text) text_pattern_ops", name: "index_wage_subsidy_requests_on_cast_id_as_text"
t.bigint "second_approved_by_id"
t.datetime "second_approved_at"
+ t.index "((id)::text) text_pattern_ops", name: "index_wage_subsidy_requests_on_cast_id_as_text"
t.index ["custom_expense_type_id"], name: "index_wage_subsidy_requests_on_custom_expense_type_id"
@@ -2579,2 +2581,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "wage_subsidy_agreements", "custom_expense_types"
+ add_foreign_key "wage_subsidy_agreements", "expense_payment_types"
add_foreign_key "wage_subsidy_requests", "custom_expense_types"

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.