| 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 |