AccountTypes

IDTypeName
1Checking
2Savings
3Money Market
4CD
5IRA

Banks

IDNameHeadQuarters
1Bank ANew York
2Bank BLondon
3Bank CParis
4Bank DTokyo
5Bank ELos Angeles

Customers

IDFirstNameLastNameDateOfBirthEmail
1JohnDoe1976-05-15john.doe@example.com
2JaneSmith1980-08-20jane.smith@example.com
3PeterBlack1992-12-01peter.black@example.com
4AliceWhite1985-03-17alice.white@example.com
5TomGreen1995-07-05tom.green@example.com

BankAccounts

AccountNumberCustomerIDOpenDateCurrentBalance
(→ Customers.ID)
183429321412021-06-01 10:00:0010000.0
283429321422021-07-01 10:00:0020000.0
383429321432021-08-01 10:00:0030000.0
483429321442021-09-01 10:00:0040000.0
583429321452021-10-01 10:00:0050000.0

Loans

LoanIDAccountNumberAmountStartDateEndDateMonthlyInterestRateAnnualPercentageRateForeignKeyAccountNumber
(→ BankAccounts.AccountNumber)
11834293214100002021-06-01 10:00:002026-06-01 10:00:000.050.061834293214
22834293214150002021-07-01 10:00:002027-07-01 10:00:000.050.062834293214
33834293214200002021-08-01 10:00:002028-08-01 10:00:000.050.063834293214
44834293214250002021-09-01 10:00:002029-09-01 10:00:000.050.064834293214
55834293214300002021-10-01 10:00:002030-10-01 10:00:000.050.065834293214

Terms

TermIdDescriptionMonthlyInterestRateAnnualPercentageRateOtherValueAccountTypeIDLOAN_ID
(→ AccountTypes.ID)(→ Loans.LoanID)
1Monthly Interest Rate0.050.06None11
2Monthly Interest Rate0.050.06None22
3Annual Percentage Rate0.050.06None11
4Annual Percentage Rate0.050.06None22
5Some other value0.050.06somevalue33
6Another term0.040.05None44