Customers

idfirstNamelastNameemailphoneNumber
1JohnDoejohn@example.com+123456789
2JaneSmithjane@example.com+987654321

Accounts

idcustomerIdaccountTypebalance
(→ Customers.id)
11Checking500.0
22Savings1000.0

Transactions

idaccountIdproductTypeamountexitFeetransactionDate
(→ Accounts.id)
11Stock Purchase1000.00.012022-01-01 00:00:00
22Bond Sale500.00.022022-01-02 00:00:00

ExchangeTradedProducts

idnametickerSymboldescription
1Example ETPEXAMPLEThis is an example of an exchange traded product.
2Another ETPANOTHERThis is another example of an exchange traded product.

UnitInvestmentTrusts

idnamefundCodenetAssetValue
1Example UITXFUND1000.0
2Another UITYFUND2000.0

ETPUITransactionLinks

transactionIdetpIduitId
(→ Transactions.id)(→ ExchangeTradedProducts.id)(→ UnitInvestmentTrusts.id)
111
222