## Customers

id | firstName | lastName | email | phoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john@example.com | +123456789
2 | Jane | Smith | jane@example.com | +987654321

## Accounts

id | customerId | accountType | balance
--- | --- | --- | ---
| (→ Customers.id) |  |
1 | 1 | Checking | 500.0
2 | 2 | Savings | 1000.0

## Transactions

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

## ExchangeTradedProducts

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.

## UnitInvestmentTrusts

id | name | fundCode | netAssetValue
--- | --- | --- | ---
1 | Example UIT | XFUND | 1000.0
2 | Another UIT | YFUND | 2000.0

## ETPUITransactionLinks

transactionId | etpId | uitId
--- | --- | ---
(→ Transactions.id) | (→ ExchangeTradedProducts.id) | (→ UnitInvestmentTrusts.id)
1 | 1 | 1
2 | 2 | 2