CustomerID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +1234567890 |
2 | Jane | Smith | jane.smith@example.com | +0987654321 |
AccountID | CustomerID | AccountType | Balance |
---|---|---|---|
(→ Customers.CustomerID) | |||
1 | 1 | Checking | 500.0 |
2 | 2 | Savings | 1000.0 |
LoanID | CustomerID | Amount | InterestRate | TermYears |
---|---|---|---|---|
(→ Customers.CustomerID) | ||||
1 | 1 | 15000.0 | 6.0 | 5 |
2 | 2 | 10000.0 | 5.5 | 3 |
DepositID | AccountID | Amount | Date |
---|---|---|---|
(→ Accounts.AccountID) | |||
1 | 1 | 500.0 | 2024-02-19 14:31:33 |
2 | 2 | 1000.0 | 2024-02-19 14:31:33 |
TransactionID | AccountID | Type | Amount | Date |
---|---|---|---|---|
(→ Accounts.AccountID) | ||||
1 | 1 | Deposit | 500.0 | 2024-02-19 14:31:33 |
2 | 2 | Withdrawal | 200.0 | 2024-02-19 14:31:33 |
BankName | HeadquarterLocation | FoundedYear | TotalAssets | NumberOfBranches | WebsiteURL |
---|---|---|---|---|---|
Example Bank | New York | 2000 | 1000000.0 | 50 | https://www.examplebank.com/ |
BranchID | BankName | BranchName | Address | City | State | ZipCode |
---|---|---|---|---|---|---|
(→ Bank.BankName) | ||||||
1 | Example Bank | Main Branch | 123 Main St | New York | NY | 10001 |
2 | Example Bank | East Side Branch | 456 East Ave | New York | NY | 10010 |
ProductID | BankName | ProductName | Description | AnnualInterestRate | MinimumDepositAmount | MaximumDepositAmount | BranchName |
---|---|---|---|---|---|---|---|
(→ Bank.BankName) | (→ Branch.BranchID) | ||||||
1 | Example Bank | High-Yield Savings | A high interest rate savings account with no monthly fees. | 1.0 | 1000.0 | None | 1 |
2 | Example Bank | CD Special | Certificate of deposit offering a fixed annual percentage yield. | 2.5 | 1000.0 | 1000000.0 | 2 |