Customers

CustomerIDFirstNameLastName
1JohnDoe
2JaneSmith
3MichaelBrown
4EmilyWhite
5DavidBlack

Accounts

AccountNumberCustomerIDBalance
(→ Customers.CustomerID)
111000.0
22800.0
33900.0
44700.0
55600.0

Transactions

TransactionIDAccountNumberTransactionTypeAmountDate
(→ Accounts.AccountNumber)
11Subscription_Payments150.02024-01-30 18:53:44
21Transfer200.02024-01-30 18:53:44
32Subscription_Payments130.02024-01-30 18:53:44
42Transfer180.02024-01-30 18:53:44
53Subscription_Payments140.02024-01-30 18:53:44
63Transfer220.02024-01-30 18:53:44
74Subscription_Payments120.02024-01-30 18:53:44
84Transfer190.02024-01-30 18:53:44
95Subscription_Payments110.02024-01-30 18:53:44
105Transfer170.02024-01-30 18:53:44

Bank_Statements

StatementIDAccountNumberStartDateEndDateTotalAmount
(→ Accounts.AccountNumber)
112021-01-012021-01-31250.0
222021-02-012021-02-28260.0
332021-03-012021-03-31270.0
442021-04-012021-04-30280.0
552021-05-012021-05-31290.0

Bank_Statements_Transactions

StatementTransactionIDStatementIDTransactionID
(→ Bank_Statements.StatementID)(→ Transactions.TransactionID)
111
212
323
424
535
636
747
848
959
10510
1121
1231
1341
1451