I created 2 tables:
- 'accounts' for saving, term deposit, cheque account
- 'loans' for personal loan, home loan, investment loan, and credit
The 'accounts' have 'account transactions'
The 'loans' also have 'loan transaction'.
Is it possible 'accounts' & 'loans' have the same 'transactions' database because fields in both 'account transactions' & 'loan transaction' are the same? If yes, then how do I map the same field, ie, account no. from transactions db to 2 dbs 'accounts' & 'loans'?
Otherwise, I will have 2 separate transactions tables but they have almost the same field name.