Customers

CustomerIDFirstNameLastNameDateOfBirthEmail
1JohnDoe1980-06-12john.doe@example.com
2JaneSmith1975-03-18jane.smith@example.com

Accounts

AccountNumberBalanceTypeCustomerID
(→ Customers.CustomerID)
11000.0Checking1
25000.0Savings1

Transactions

TransactionIDAmountDateDescriptionFromAccountNumberToAccountNumber
(→ Accounts.AccountNumber)(→ Accounts.AccountNumber)
1500.02021-08-15 10:00:00Transfer to Savings12
2-200.02021-08-15 14:00:00Payment23

Loans

LoanIDPrincipalAmountInterestRateStartDateEndDateCustomerID
(→ Customers.CustomerID)
115000.05.52021-09-012026-08-311
220000.042021-10-012028-09-302

Employees

EmployeeIDFirstNameLastNameHireDatePositionSalary
1AliceJohnson2018-05-01Manager60000.0
2MichaelWilliams2019-10-01Assistant Manager45000.0

FinancialServices

FinancialServiceIDOrganizationServiceTypeCostRealEmployeeID
(→ Employees.EmployeeID)
1ABC GroupCustodial Service1000.01
2XYZ CompanyCustodial Service1200.02
3ABC GroupTrust Administration1500.03
4PQR CorporationTrust Administration1800.04