## Customers

CustomerID | FirstName | LastName | DateOfBirth | EmailAddress
--- | --- | --- | --- | ---
1 | John Doe | Doe | 2000-01-01 | johndoe@email.com
2 | Jane Smith | Smith | 1998-03-27 | janesmith@email.com

## Accounts

AccountNumber | Balance | InterestRate | OpenDate | Status | CustomerID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Customers.CustomerID)
1 | 1000.0 | 2.5% | 2021-06-01 | Active | 1
2 | 2000.0 | 1.5% | 2021-07-01 | Inactive | 2

## Loans

LoanID | Amount | Term | Rate | ApprovalDate | Status | CustomerID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Customers.CustomerID)
1 | 50000.0 | 36 | 5.5% | 2021-06-10 | Approved | 1
2 | 40000.0 | 24 | 4.0% | 2021-07-05 | Pending | 2

## EligibilityAndDocuments

ApplicationID | Eligibility_Criteria | Documentation_Requirements | Business_Loan_Application | LoanID
--- | --- | --- | --- | ---
|  |  |  | (→ Loans.LoanID)
1 | Excellent credit history. | Proof of income, tax returns. | 0 | 1
2 | Good credit history. | Bank statements, pay stubs. | 1 | 2

## Transactions

TransactionID | Description | Type | Amount | Timestamp | AccountNumber
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Accounts.AccountNumber)
1 | Salary deposit | Credit | 3000.0 | 2021-06-15 | 1
2 | Utility payment | Debit | -200.0 | 2021-06-20 | 1

## Employees

EmployeeID | FirstName | LastName | HireDate | Role | Salary | BranchID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Branches.BranchID)
1 | Alice Johnson | Johnson | 2021-01-01 | Teller | 40000.0 | 1
2 | Michael Brown | Brown | 2021-01-15 | Branch manager | 50000.0 | 1

## Branches

BranchID | Name | Address | PhoneNumber | ManagerID
--- | --- | --- | --- | ---
|  |  |  | (→ Employees.EmployeeID)
1 | Main Street Branch | 1 Main St, Anytown | 555-123-4567 | None
2 | Southside Branch | 123 South Rd, Anycity | 555-987-6543 | 1