I would release an update if I could reproduce the issue and identify the specific bug. Based on your data, unfortunately, it is not yet clear why your database has not been updated. I can give you a SQL query to create the desired wp_money_manager_files, but it is quite possible that something else in your database is also broken.
You need to drop the existing wp_money_manager_files table and create a new one with this query:
create table wp_money_manager_files
(
id bigint unsigned auto_increment
primary key,
account_id bigint unsigned null,
transaction_id bigint unsigned null,
attachment_id bigint unsigned not null,
filename varchar(255) not null,
description text null,
url varchar(255) not null,
created_at timestamp null,
updated_at timestamp null,
constraint wp_money_manager_file_acc_id_foreign
foreign key (account_id) references wp_money_manager_accounts (id)
on delete cascade,
constraint wp_money_manager_file_txn_id_foreign
foreign key (transaction_id) references wp_money_manager_transactions (id)
on delete cascade
);
create index wp_money_manager_file_att_id_index
on wp_money_manager_files (attachment_id);
