Simplify unconfirmed transaction records and update transaction table