CustomerID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +123456789 |
2 | Jane | Smith | jane.smith@example.com | +987654321 |
3 | Alice | Brown | alice.brown@example.com | +135792468 |
4 | Bob | White | bob.white@example.com | +142583690 |
5 | Charlie | Black | charlie.black@example.com | +153278941 |
AccountID | BankAccountNumber | CustomerID | Balance |
---|---|---|---|
(→ Customers.CustomerID) | |||
1 | 1234567 | 1 | 1000.0 |
2 | 987654321 | 2 | 2000.0 |
3 | 135792468 | 3 | 3000.0 |
4 | 142583690 | 4 | 4000.0 |
5 | 153278941 | 5 | 5000.0 |
PaymentID | Amount | Description | Date | AccountID |
---|---|---|---|---|
(→ Accounts.AccountID) | ||||
1 | 500.0 | Salary payment | 2022-01-01 00:00:00 | 1 |
2 | 600.0 | Rent payment | 2022-01-02 00:00:00 | 1 |
3 | 700.0 | Utilities bill | 2022-01-03 00:00:00 | 2 |
4 | 800.0 | Groceries | 2022-01-04 00:00:00 | 2 |
5 | 900.0 | Shopping | 2022-01-05 00:00:00 | 3 |
RemittanceID | ReferenceNumber | SenderAccountID | ReceiverAccountID | Amount | Currency | Date | Status |
---|---|---|---|---|---|---|---|
(→ Accounts.AccountID) | (→ Accounts.AccountID) | ||||||
1 | REF123 | 1 | 4 | 1000.0 | USD | 2022-01-06 00:00:00 | Completed |
2 | REF456 | 2 | 5 | 1200.0 | EUR | 2022-01-07 00:00:00 | Pending |
3 | REF789 | 3 | 1 | 1300.0 | GBP | 2022-01-08 00:00:00 | In Progress |
4 | REF1234 | 4 | 2 | 1400.0 | CAD | 2022-01-09 00:00:00 | Failed |
5 | REF4567 | 5 | 3 | 1500.0 | AUD | 2022-01-10 00:00:00 | Successful |