| TypeID | TypeName |
|---|---|
| 1 | Payment |
| 2 | Transfer |
| 3 | Withdrawal |
| 4 | Deposit |
| 5 | Remittance Transfer |
| BankID | Name |
|---|---|
| 1 | ABC Bank |
| 2 | XYZ Bank |
| 3 | PQR Bank |
| 4 | LMN Bank |
| 5 | JKL Bank |
| CustomerID | FirstName | LastName | DateOfBirth | PhoneNumber | EmailAddress | BankID |
|---|---|---|---|---|---|---|
| (→ Banks.BankID) | ||||||
| 1 | John | Doe | 1980-01-01 | 1234567890 | john@example.com | 1 |
| 2 | Jane | Smith | 1990-02-02 | 0987654321 | jane@example.com | 2 |
| 3 | Alice | Johnson | 1995-03-03 | 5551234567 | alice@example.com | 3 |
| 4 | Bob | Williams | 2000-04-04 | 5555555555 | bob@example.com | 4 |
| 5 | Charlie | Miller | 2005-05-05 | 5555555555 | charlie@example.com | 5 |
| AccountID | Number | OpenDate | Balance | CustomerID |
|---|---|---|---|---|
| (→ Customers.CustomerID) | ||||
| 1 | 1234567890 | 2021-01-01 | 1000.0 | 1 |
| 2 | 9876543210 | 2021-02-02 | 2000.0 | 2 |
| 3 | 5432109876 | 2021-03-03 | 3000.0 | 3 |
| 4 | 6543217890 | 2021-04-04 | 4000.0 | 4 |
| 5 | 7890123456 | 2021-05-05 | 5000.0 | 5 |
| TransactionID | DateAndTime | Amount | Description | TypeID | FromAccountId | ToAccountId |
|---|---|---|---|---|---|---|
| (→ Transaction_Types.TypeID) | (→ Accounts.AccountID) | (→ Accounts.AccountID) | ||||
| 1 | 2024-03-13 14:46:32 | 500.0 | Payment | 1 | 1 | 2 |
| 2 | 2024-03-13 14:46:32 | 600.0 | Remittance Transfer | 2 | 3 | 4 |
| 3 | 2024-03-13 14:46:32 | -400.0 | Withdrawal | 3 | 1 | 1 |
| 4 | 2024-03-13 14:46:32 | 700.0 | Deposit | 4 | 3 | 5 |
| 5 | 2024-03-13 14:46:32 | 800.0 | Payment | 1 | 2 | 4 |
| DetailsID | TransactionID | AdditionalInfo |
|---|---|---|
| (→ Transactions.TransactionID) | ||
| 1 | 1 | Additional info for transaction 1 |
| 2 | 2 | Additional info for transaction 2 |
| 3 | 3 | Additional info for transaction 3 |
| 4 | 4 | Additional info for transaction 4 |
| 5 | 5 | Additional info for transaction 5 |