Customers

CustomerIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+123456789
2JaneSmithjane.smith@example.com+987654321
3AliceBrownalice.brown@example.com+135792468
4BobWhitebob.white@example.com+142583690
5CharlieBlackcharlie.black@example.com+153278941

Accounts

AccountIDBankAccountNumberCustomerIDBalance
(→ Customers.CustomerID)
1123456711000.0
298765432122000.0
313579246833000.0
414258369044000.0
515327894155000.0

Payments

PaymentIDAmountDescriptionDateAccountID
(→ Accounts.AccountID)
1500.0Salary payment2022-01-01 00:00:001
2600.0Rent payment2022-01-02 00:00:001
3700.0Utilities bill2022-01-03 00:00:002
4800.0Groceries2022-01-04 00:00:002
5900.0Shopping2022-01-05 00:00:003

Remittances

RemittanceIDReferenceNumberSenderAccountIDReceiverAccountIDAmountCurrencyDateStatus
(→ Accounts.AccountID)(→ Accounts.AccountID)
1REF123141000.0USD2022-01-06 00:00:00Completed
2REF456251200.0EUR2022-01-07 00:00:00Pending
3REF789311300.0GBP2022-01-08 00:00:00In Progress
4REF1234421400.0CAD2022-01-09 00:00:00Failed
5REF4567531500.0AUD2022-01-10 00:00:00Successful