Benchmark_Indices

idNameMarket_SegmentDateValue
1Tech IndexTechnology2022-01-0110000.0
2Financial IndexBanking2022-01-019876.54

Factor_Indices

idNameMarket_SegmentDateValue
1Valuation Ratio IndexTechnology2022-01-013.5
2Earnings Growth IndexHealthcare2022-01-0115.3

Customers

idFirstNameLastNameEmailPhoneNumber
1JohnDoejohn@gmail.com+123456789
2JaneSmithjane@gmail.com+987654321

Accounts

idCustomerIdTypeBalanceCreatedAt
(→ Customers.id)
11Checking10000.02024-03-13 18:33:36
22Savings5000.02024-03-13 18:33:36

Loans

idCustomerIdAmountInterestRateStartDateEndDate
(→ Customers.id)
1120000.05.02024-03-13 18:33:362023-12-31
2215000.04.02024-03-13 18:33:362024-12-31

Transactions

idFromAccountIdToAccountIdAmountDescriptionTransactionTime
(→ Accounts.id)(→ Accounts.id)
1121000.0Transfer to Savings account.2024-03-13 18:33:36
221500.0Payment to Checking account.2024-03-13 18:33:36