My question is regarding database design/architecture, but I'll use a familiar example to explain it.
Suppose there is a database for banking. This database has a table called
Customers which stores
Address, etc.. Now each of these customers can have their own sub-table for
Transactions, with columns like
My question is, what is the efficient way to store this
Transactions table. Should I create a new table in the database, add a field
User ID, and insert transactions of ALL customers in this table. Or should I add a text field
Transactions to the table Customers and store all transactions of each user in JSON format? I'd like to know how this is done in professional industries.