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 |