Take the 2-minute tour ×   I have separate tables for Loan,
Purchase & Sales transactions. Each tables rows are joined to
their respective customer rows by:  customer.id [serial] =
loan.foreign_id [integer]; = purchase.foreign_id [integer]; =
sale.foreign_id [integer];  I would like to consolidate the
three tables into one table called "transaction", where a column
"transaction.trx_type" [char(1)] {L=Loan, P=Purchase, S=Sale}
identifies the transaction type. Is this a good idea or is it
better to keep them in separate tables? Storage space is not a
concern, I think it would be easier programming & user=wise to
have all types of transactions under one table.  share|improve
this question add comment  3 Answers  up vote 2 down vote
accepted  It´s a good solution. You can also create three views
so that basic access doesn´t change.  By the way: This is a
typical approach to solve the object relational impedance
mismatch.  You can normally generalise Loan, Purchase and Sale
into something like: MoneyTransaction. T