Transaction_Types

TypeIDTypeName
1Payment
2Transfer
3Withdrawal
4Deposit
5Remittance Transfer

Banks

BankIDName
1ABC Bank
2XYZ Bank
3PQR Bank
4LMN Bank
5JKL Bank

Customers

CustomerIDFirstNameLastNameDateOfBirthPhoneNumberEmailAddressBankID
(→ Banks.BankID)
1JohnDoe1980-01-011234567890john@example.com1
2JaneSmith1990-02-020987654321jane@example.com2
3AliceJohnson1995-03-035551234567alice@example.com3
4BobWilliams2000-04-045555555555bob@example.com4
5CharlieMiller2005-05-055555555555charlie@example.com5

Accounts

AccountIDNumberOpenDateBalanceCustomerID
(→ Customers.CustomerID)
112345678902021-01-011000.01
298765432102021-02-022000.02
354321098762021-03-033000.03
465432178902021-04-044000.04
578901234562021-05-055000.05

Transactions

TransactionIDDateAndTimeAmountDescriptionTypeIDFromAccountIdToAccountId
(→ Transaction_Types.TypeID)(→ Accounts.AccountID)(→ Accounts.AccountID)
12024-03-13 14:46:32500.0Payment112
22024-03-13 14:46:32600.0Remittance Transfer234
32024-03-13 14:46:32-400.0Withdrawal311
42024-03-13 14:46:32700.0Deposit435
52024-03-13 14:46:32800.0Payment124

Transaction_Details

DetailsIDTransactionIDAdditionalInfo
(→ Transactions.TransactionID)
11Additional info for transaction 1
22Additional info for transaction 2
33Additional info for transaction 3
44Additional info for transaction 4
55Additional info for transaction 5