Re: what design to split bank transactions into more detail? (in budget database)

[Peter Brawley]

> add new detailed transactions to BANK_TRANSACTIONS for the detail, with a new column “REPLACED”

Very likely a mistake. Read about normalisation and parent-child tables. A master or parent transaction row would have as many detail rows in a child table as required to track all details the system wishes to track.

> have a separate table for BUSINESS_TRANSACTIONS

Probably not. Usually better: have a transaction_type table and each master transaction gets assigned a known type.

Please go no further till you've studied and mastered normalisation.