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 |