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

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

Transactions

TransactionIDAmountDateAndTimeTypeIDFromAccountIdToAccountId
(→ Transaction_Types.TypeID)(→ Accounts.AccountID)(→ Accounts.AccountID)
1500.02024-03-13 14:46:32112
2600.02024-03-13 14:46:32234
3-400.02024-03-13 14:46:32311
4700.02024-03-13 14:46:32435
5800.02024-03-13 14:46:32124