## Benchmark_Indices

id | Name | Market_Segment | Date | Value
--- | --- | --- | --- | ---
1 | Tech Index | Technology | 2022-01-01 | 10000.0
2 | Financial Index | Banking | 2022-01-01 | 9876.54

## Factor_Indices

id | Name | Market_Segment | Date | Value
--- | --- | --- | --- | ---
1 | Valuation Ratio Index | Technology | 2022-01-01 | 3.5
2 | Earnings Growth Index | Healthcare | 2022-01-01 | 15.3

## Customers

id | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john@gmail.com | +123456789
2 | Jane | Smith | jane@gmail.com | +987654321

## Accounts

id | CustomerId | Type | Balance | CreatedAt
--- | --- | --- | --- | ---
| (→ Customers.id) |  |  |
1 | 1 | Checking | 10000.0 | 2024-03-13 18:33:36
2 | 2 | Savings | 5000.0 | 2024-03-13 18:33:36

## Loans

id | CustomerId | Amount | InterestRate | StartDate | EndDate
--- | --- | --- | --- | --- | ---
| (→ Customers.id) |  |  |  |
1 | 1 | 20000.0 | 5.0 | 2024-03-13 18:33:36 | 2023-12-31
2 | 2 | 15000.0 | 4.0 | 2024-03-13 18:33:36 | 2024-12-31

## Transactions

id | FromAccountId | ToAccountId | Amount | Description | TransactionTime
--- | --- | --- | --- | --- | ---
| (→ Accounts.id) | (→ Accounts.id) |  |  |
1 | 1 | 2 | 1000.0 | Transfer to Savings account. | 2024-03-13 18:33:36
2 | 2 | 1 | 500.0 | Payment to Checking account. | 2024-03-13 18:33:36