## Transaction_Types

TypeID | TypeName
--- | ---
1 | Payment
2 | Transfer
3 | Withdrawal
4 | Deposit
5 | Remittance Transfer

## Banks

BankID | Name
--- | ---
1 | ABC Bank
2 | XYZ Bank
3 | PQR Bank
4 | LMN Bank
5 | JKL Bank

## Customers

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

## Accounts

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

## Transactions

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

## Transaction_Details

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