Upcoming database changes RELEASE 10 August 2021

-ActiveRecord::Schema.define(version: 2021_07_12_022608) do
+ActiveRecord::Schema.define(version: 2021_08_03_052922) do

@@ -839,2 +839,7 @@ create_table "expense_credit_cards", id: :serial, force: :cascade do |t|

+ create_table "expense_dual_line_limits", force: :cascade do |t|
+ t.string "programme", null: false
+ t.integer "limit"
+ end

create_table "expense_exports", id: :serial, force: :cascade do |t|


@@ -946,2 +951,5 @@ create_table "expenses", id: :serial, force: :cascade do |t|
t.bigint "professional_service_activity_id"
+ t.integer "pre_approver_id"
+ t.date "pre_approved_on"
+ t.bigint "voucher_id"
t.index ["approver_id"], name: "index_expenses_on_approver_id"


@@ -951,2 +959,3 @@ create_table "expenses", id: :serial, force: :cascade do |t|
t.index ["jobseeker_id"], name: "index_expenses_on_jobseeker_id"
+ t.index ["pre_approver_id"], name: "index_expenses_on_pre_approver_id"
t.index ["professional_service_activity_id"], name: "index_expenses_on_professional_service_activity_id"


@@ -956,2 +965,3 @@ create_table "expenses", id: :serial, force: :cascade do |t|
t.index ["updated_by_id"], name: "index_expenses_on_updated_by_id"
+ t.index ["voucher_id"], name: "index_expenses_on_voucher_id"
end


@@ -1574,2 +1584,3 @@ create_table "professional_service_activities", id: :serial, force: :cascade do
t.bigint "program_referral_id"
+ t.json "expense_type_properties", default: {}
t.index ["intervention_provided_by_id"], name: "index_indigenous_mentoring_activities_on_user_id"


@@ -1616,4 +1627,2 @@ create_table "program_referrals", force: :cascade do |t|
t.datetime "updated_at", null: false
- t.bigint "created_by_id"
- t.bigint "justification_template_id"
t.bigint "rejected_by_id"


@@ -1623,2 +1632,4 @@ create_table "program_referrals", force: :cascade do |t|
t.datetime "approved_at"
+ t.bigint "justification_template_id"
+ t.bigint "created_by_id"
t.bigint "professional_service_staff_id"


@@ -1880,2 +1891,3 @@ create_table "referrals", id: :serial, force: :cascade do |t|
t.json "batch_data"
+ t.date "anchor_date"
t.index ["created_by_id"], name: "index_referrals_on_created_by_id"


@@ -2508,2 +2520,3 @@ create_table "users", id: :serial, force: :cascade do |t|
t.boolean "can_manage_organisation_leads", default: false, null: false
+ t.boolean "can_manage_customer_leads", default: false, null: false
t.index ["active"], name: "index_users_on_active"


@@ -2772,2 +2785,3 @@ create_table "widget_configurations", id: :serial, force: :cascade do |t|
add_foreign_key "expenses", "supplier_purchase_orders"
+ add_foreign_key "expenses", "vouchers"
add_foreign_key "filter_bar_configurations", "users"

Did you find it helpful? Yes No

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