My current data design scheme has three tables (Funding, Payments, Charges) to handle financial data of different types. Each has a primary key, two foreign keys, date, amount and an additional field or three.

I was going to make a change to all three tables when the obvious question hit me: Would I be better served to collapse all three into a single table?

Any opinions to offer questions to explore on this?

Chris.