Customers

CustomerIDCustomerName
1John Doe
2Jane Smith
3Mike Johnson
4Emily Davis
5David Brown

Accounts

AccountNumberCustomerIDBalance
(→ Customers.CustomerID)
111000.0
225000.0
338000.0
442000.0
557000.0

Transactions

TransactionIDAccountNumberAmountTransactionTypeDate
(→ Accounts.AccountNumber)
11100Deposit2021-06-15 10:00:00
21-50Withdrawal2021-06-15 11:00:00
32200Deposit2021-06-15 12:00:00
42-100Withdrawal2021-06-15 13:00:00
53300Deposit2021-06-15 14:00:00

FinancialReports

ReportIDDateFinancialStatementForeignKey
(→ Accounts.AccountNumber)
12010-12-10Balance SheetNone
22011-01-15Balance SheetNone
32010-12-10Income StatementNone
42011-01-15Income StatementNone

BalanceSheets

SheetIDReportIDAssetsLiabilitiesEquity
(→ FinancialReports.ReportID)
11Assets Value 1Liabilities Value 1Equity Value 1
22Assets Value 2Liabilities Value 2Equity Value 2
33Assets Value 3Liabilities Value 3Equity Value 3
44Assets Value 4Liabilities Value 4Equity Value 4

IncomeStatements

StatementIDReportIDRevenueExpensesNetProfit
(→ FinancialReports.ReportID)
11Revenue Value 1Expenses Value 1NetProfit Value 1
22Revenue Value 2Expenses Value 2NetProfit Value 2
33Revenue Value 3Expenses Value 3NetProfit Value 3
44Revenue Value 4Expenses Value 4NetProfit Value 4