Upcoming database changes RELEASE 30 November 2021

-ActiveRecord::Schema.define(version: 2021_11_10_125204) do
+ActiveRecord::Schema.define(version: 2021_11_20_224821) do

@@ -752,2 +752,3 @@ create_table "emails", id: :serial, force: :cascade do |t|
t.string "email_type"
+ t.datetime "scheduled_at"
t.index ["emailable_id"], name: "index_emails_on_emailable_id"
@@ -1037,2 +1038,3 @@ create_table "expenses", id: :serial, force: :cascade do |t|
t.bigint "wage_subsidy_payment_schedule_id"
+ t.bigint "wage_subsidy_payment_schedule_template_instalment_id"
t.index ["approver_id"], name: "index_expenses_on_approver_id"
@@ -1594,2 +1596,3 @@ create_table "permissible_breaks", id: :serial, force: :cascade do |t|
t.datetime "updated_at", null: false
+ t.string "type", default: "PermissibleBreak", null: false
t.index ["placement_id"], name: "index_permissible_breaks_on_placement_id"
@@ -1916,2 +1919,14 @@ create_table "query_types", force: :cascade do |t|

+ create_table "query_versions", force: :cascade do |t|
+ t.string "item_type", null: false
+ t.bigint "item_id", null: false
+ t.string "event", null: false
+ t.string "whodunnit"
+ t.json "object"
+ t.json "object_changes"
+ t.bigint "note_id"
+ t.datetime "created_at"
+ t.index ["item_type", "item_id"], name: "index_query_versions_on_item_type_and_item_id"
+ end
+
create_table "quest_engine_pdf_templates", force: :cascade do |t|
@@ -2176,2 +2191,3 @@ create_table "resume_attachments", id: :serial, force: :cascade do |t|
t.string "resume_url"
+ t.string "name"
t.index ["deleted_at"], name: "index_resume_attachments_on_deleted_at"
@@ -2341,2 +2357,3 @@ create_table "short_messages", id: :serial, force: :cascade do |t|
t.integer "reminder_id"
+ t.datetime "scheduled_at"
t.index ["client_id"], name: "index_short_messages_on_client_id"
@@ -2409,2 +2426,3 @@ create_table "smart_forms", id: :uuid, default: -> { "uuid_generate_v4()" }, for
t.boolean "placement_validation", default: false
+ t.boolean "editable", default: false, null: false
t.index ["quest_form_id"], name: "index_smart_forms_on_quest_form_id"
@@ -2959,2 +2977,13 @@ create_table "wage_subsidy_agreements", force: :cascade do |t|

+ create_table "wage_subsidy_payment_portal_invitations", force: :cascade do |t|
+ t.uuid "uuid", default: -> { "uuid_generate_v4()" }, null: false
+ t.bigint "contact_id", null: false
+ t.bigint "expense_id", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.index ["contact_id", "expense_id"], name: "index_invitations_on_contact_id_and_expense_id", unique: true
+ t.index ["contact_id"], name: "index_wage_subsidy_payment_portal_invitations_on_contact_id"
+ t.index ["expense_id"], name: "index_wage_subsidy_payment_portal_invitations_on_expense_id"
+ end
+
create_table "wage_subsidy_payment_schedule_template_instalments", force: :cascade do |t|
@@ -3199,2 +3228,4 @@ create_table "work_for_doles", force: :cascade do |t|
add_foreign_key "wage_subsidy_agreements", "expense_payment_types"
+ add_foreign_key "wage_subsidy_payment_portal_invitations", "contacts"
+ add_foreign_key "wage_subsidy_payment_portal_invitations", "expenses"
add_foreign_key "wage_subsidy_payment_schedule_template_instalments", "document_library_files"

Did you find it helpful? Yes No

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