## Financial_Analysts

id | name | experience
--- | --- | ---
1 | John Doe | 3
2 | Jane Smith | 2
3 | Alice Johnson | 10
4 | Bob Brown | 7
5 | Emma Wilson | 6

## Metrics

metric_id | metric_name
--- | ---
1 | Earnings_Per_Share
2 | Revenue
3 | Gross_Profit
4 | Net_Income
5 | Market_Capitalization

## Company

company_id | company_name | location
--- | --- | ---
1 | ABC Corporation | New York
2 | XYZ Inc. | California
3 | LNM Limited | Texas
4 | MNO Enterprises | Florida
5 | PQR Holdings | Illinois

## JobPostings

job_posting_id | title | description | salary | created_at
--- | --- | --- | --- | ---
1 | Financial Analyst | Analyze market trends and make recommendations based on research | 75000.0 | 2024-01-30 19:22:37
2 | Senior Financial Analyst | Lead a team of analysts in providing investment advice | 100000.0 | 2024-01-30 19:22:37
3 | Associate Financial Analyst | Assist senior analysts in preparing reports and forecasts | 60000.0 | 2024-01-30 19:22:37
4 | Financial Modelling Analyst | Develop financial models to assist in decision-making processes | 70000.0 | 2024-01-30 19:22:37
5 | Equity Research Analyst | Conduct analysis on specific industries and companies to provide buy/sell/hold recommendations | 80000.0 | 2024-01-30 19:22:37

## Financial_Analysts_Metrics

financial_analyst_id | metric_id
--- | ---
(→ Financial_Analysts.id) | (→ Metrics.metric_id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 4