Customers
CustomerID | FirstName | LastName | DateOfBirth | Address |
1 | John | Doe | 1970-01-01 | 123 Main St |
2 | Jane | Smith | 1980-06-15 | 456 Elm St |
Accounts
AccountID | CustomerID | Balance |
| (→ Customers.CustomerID) | |
1 | 1 | 1000.0 |
2 | 2 | 2000.0 |
Deposits
DepositID | AccountID | Amount | TransactionDate |
| (→ Accounts.AccountID) | | |
1 | 1 | 500.0 | 2024-03-08 00:00:42 |
2 | 2 | 1000.0 | 2024-03-08 00:00:42 |
Loans
LoanID | CustomerID | StockMarketOfferings | RaisedCapitalAmount | InterestRate | StartDate | EndDate |
| (→ Customers.CustomerID) | | | | | |
1 | 1 | IPO | 50000000 | 5.0 | None | None |
2 | 2 | IPO | 60000000 | 4.5 | None | None |
3 | 1 | Secondary Offering | 50000000 | 5.5 | None | None |
4 | 2 | Secondary Offering | 60000000 | 4.0 | None | None |