Customers

CustomerIDFirstNameLastNameDateOfBirth
1JohnDoe1980-06-15
2JaneSmith1973-08-23

Accounts

AccountNumberCustomerIDAccountTypeOpenDate
(→ Customers.CustomerID)
10011Checking2021-06-01
10021Savings2021-06-01

Transactions

TransactionIDAccountNumberAmountTransactionDate
(→ Accounts.AccountNumber)
11001-2002021-06-01 08:00:00
210011502021-06-01 09:00:00

Fees

FeeIDAccountNumberFeesEffectiveFromEffectiveTo
(→ Accounts.AccountNumber)
1001100122021-06-012022-06-01
100210012.52022-06-012023-06-01

Overdrafts

OverdraftIDAccountNumberLimitAmountInterestRateApprovalDate
(→ Accounts.AccountNumber)
10011001500102021-06-01
10021001800122021-06-01

Loans

LoanIDAccountNumberPrincipalAmountRateOfInterestTenureMonthsStartDateEndDateRepaymentMethod
(→ Accounts.AccountNumber)
1001100110008122021-06-012023-06-01Equal monthly installments
100210018007182021-06-012023-06-01Weekly repayments