| id | firstName | lastName | phoneNumber | |
|---|---|---|---|---|
| 1 | John | Doe | john@example.com | +123456789 |
| 2 | Jane | Smith | jane@example.com | +987654321 |
| id | customerId | accountType | balance |
|---|---|---|---|
| (→ Customers.id) | |||
| 1 | 1 | Checking | 500.0 |
| 2 | 2 | Savings | 1000.0 |
| id | accountId | productType | amount | exitFee | transactionDate |
|---|---|---|---|---|---|
| (→ Accounts.id) | |||||
| 1 | 1 | Stock Purchase | 1000.0 | 0.01 | 2022-01-01 00:00:00 |
| 2 | 2 | Bond Sale | 500.0 | 0.02 | 2022-01-02 00:00:00 |
| id | name | tickerSymbol | description |
|---|---|---|---|
| 1 | Example ETP | EXAMPLE | This is an example of an exchange traded product. |
| 2 | Another ETP | ANOTHER | This is another example of an exchange traded product. |
| id | name | fundCode | netAssetValue |
|---|---|---|---|
| 1 | Example UIT | XFUND | 1000.0 |
| 2 | Another UIT | YFUND | 2000.0 |
| transactionId | etpId | uitId |
|---|---|---|
| (→ Transactions.id) | (→ ExchangeTradedProducts.id) | (→ UnitInvestmentTrusts.id) |
| 1 | 1 | 1 |
| 2 | 2 | 2 |