Customers

CustomerIDFirstNameLastNameDateOfBirth
1JohnDoe1986-03-10
2JaneSmith1991-05-25

Accounts

AccountNumberCustomerIDAccountTypeOpenDate
(→ Customers.CustomerID)
11Checking2021-06-15
22Savings2021-07-01

SavingsAccounts

AccountNumberInterestRateMinimumBalance
(→ Accounts.AccountNumber)
10.1500
20.051000

CheckingAccounts

AccountNumberMonthly_Maintenance_FeeOverdraft_Charges
(→ Accounts.AccountNumber)
1530
24.525

Loans

LoanIDAccountNumberPrincipalAmountAnnualInterestRateRepaymentTermYears
(→ Accounts.AccountNumber)
11200000.055
22150000.043

Transactions

TransactionIDAccountNumberAmountTransactionDate
(→ Accounts.AccountNumber)
1115002024-02-19 14:39:46
21-5002024-02-19 14:39:46