CustomerID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | John | Doe | john@gmail.com | 123456789 |
2 | Jane | Smith | jane@gmail.com | 098765432 |
3 | Alice | Brown | alice@gmail.com | 555555555 |
4 | Bob | White | bob@gmail.com | 222222222 |
5 | Charlie | Black | charlie@gmail.com | 333333333 |
AccountID | CustomerID | Balance |
---|---|---|
(→ Customers.CustomerID) | ||
1 | 1 | 5000.0 |
2 | 2 | 10000.0 |
3 | 3 | 20000.0 |
4 | 4 | 30000.0 |
5 | 5 | 40000.0 |
InvestmentID | AccountID | StructuredFinanceVehicleType | PriceID | Quantity |
---|---|---|---|---|
(→ Accounts.AccountID) | (→ Pricings.PriceID) | |||
1 | 1 | Collateralized Debt Obligation | 1 | 100 |
2 | 2 | Collateralized Debt Obligation | 2 | 150 |
3 | 3 | Collateralized Mortgage Obligation | 3 | 100 |
4 | 4 | Collateralized Mortgage Obligation | 4 | 150 |
5 | 5 | Equity Fund | 5 | 200 |
PriceID | Price |
---|---|
1 | 1000.0 |
2 | 1200.0 |
3 | 1000.0 |
4 | 1200.0 |
5 | 1500.0 |