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 |
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 |
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 |
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 |
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 |
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 |
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 |