Customers

CustomerIDFirstNameLastNameDateOfBirthEmailAddress
1John DoeDoe2000-01-01johndoe@email.com
2Jane SmithSmith1998-03-27janesmith@email.com

Accounts

AccountNumberBalanceInterestRateOpenDateStatusCustomerID
(→ Customers.CustomerID)
11000.02.5%2021-06-01Active1
22000.01.5%2021-07-01Inactive2

Loans

LoanIDAmountTermRateApprovalDateStatusCustomerID
(→ Customers.CustomerID)
150000.0365.5%2021-06-10Approved1
240000.0244.0%2021-07-05Pending2

EligibilityAndDocuments

ApplicationIDEligibility_CriteriaDocumentation_RequirementsBusiness_Loan_ApplicationLoanID
(→ Loans.LoanID)
1Excellent credit history.Proof of income, tax returns.01
2Good credit history.Bank statements, pay stubs.12

Transactions

TransactionIDDescriptionTypeAmountTimestampAccountNumber
(→ Accounts.AccountNumber)
1Salary depositCredit3000.02021-06-151
2Utility paymentDebit-200.02021-06-201

Employees

EmployeeIDFirstNameLastNameHireDateRoleSalaryBranchID
(→ Branches.BranchID)
1Alice JohnsonJohnson2021-01-01Teller40000.01
2Michael BrownBrown2021-01-15Branch manager50000.01

Branches

BranchIDNameAddressPhoneNumberManagerID
(→ Employees.EmployeeID)
1Main Street Branch1 Main St, Anytown555-123-4567None
2Southside Branch123 South Rd, Anycity555-987-65431