Accounts
accountID | accountNumber | customerName | balance |
1 | 123456 | John Doe | 1000.0 |
2 | 789012 | Jane Smith | 2000.0 |
Transactions
transactionID | accountID | date | description | amount |
| (→ Accounts.accountID) | | | |
1 | 1 | 2021-01-01 | Initial Deposit | 1000.0 |
2 | 1 | 2021-01-15 | Withdrawal | -200.0 |
BalanceSheets
id | accountID | Date | totalAssets | totalLiabilities | equity | netProfitOrLoss |
| (→ Accounts.accountID) | | | | | |
1 | 1 | 2021-01-01 | 1200.0 | 800.0 | 400.0 | 100.0 |
2 | 1 | 2021-01-15 | 1000.0 | 600.0 | 400.0 | 50.0 |
IncomeStatements
id | accountID | Date | revenue | costOfGoodsSold | grossProfit | operatingExpenses | netOperatingIncome | taxes | netIncome |
| (→ Accounts.accountID) | | | | | | | | |
1 | 1 | 2021-01-01 | 1500.0 | 500.0 | 1000.0 | 200.0 | 800.0 | 100.0 | 700.0 |
2 | 1 | 2021-01-15 | 1800.0 | 600.0 | 1200.0 | 250.0 | 950.0 | 100.0 | 850.0 |