In most relational databases a single table isn't enough to hold all the data we need! We usually create a table-per-entity. For example, a social media application might have the following tables:
userspostscommentslikesWe need a table that tracks the transactions between our CashPal users.
Create the transactions table with the following fields:
IntegerIntegerIntegerTextInteger