Customers
CustomerID | FirstName | LastName | DateOfBirth | Email |
1 | John | Doe | 1980-06-12 | john.doe@example.com |
2 | Jane | Smith | 1975-03-18 | jane.smith@example.com |
Accounts
AccountNumber | Balance | Type | CustomerID |
| | | (→ Customers.CustomerID) |
1 | 1000.0 | Checking | 1 |
2 | 5000.0 | Savings | 1 |
Transactions
TransactionID | Amount | Date | Description | FromAccountNumber | ToAccountNumber |
| | | | (→ Accounts.AccountNumber) | (→ Accounts.AccountNumber) |
1 | 500.0 | 2021-08-15 10:00:00 | Transfer to Savings | 1 | 2 |
2 | -200.0 | 2021-08-15 14:00:00 | Payment | 2 | 3 |
Loans
LoanID | PrincipalAmount | InterestRate | StartDate | EndDate | CustomerID |
| | | | | (→ Customers.CustomerID) |
1 | 15000.0 | 5.5 | 2021-09-01 | 2026-08-31 | 1 |
2 | 20000.0 | 4 | 2021-10-01 | 2028-09-30 | 2 |
Employees
EmployeeID | FirstName | LastName | HireDate | Position | Salary |
1 | Alice | Johnson | 2018-05-01 | Manager | 60000.0 |
2 | Michael | Williams | 2019-10-01 | Assistant Manager | 45000.0 |
FinancialServices
FinancialServiceID | Organization | ServiceType | CostReal | EmployeeID |
| | | | (→ Employees.EmployeeID) |
1 | ABC Group | Custodial Service | 1000.0 | 1 |
2 | XYZ Company | Custodial Service | 1200.0 | 2 |
3 | ABC Group | Trust Administration | 1500.0 | 3 |
4 | PQR Corporation | Trust Administration | 1800.0 | 4 |