test
Tables (8)
company_overview
- company_id — INT
- company_name — VARCHAR(255)
- industry_id — INT
- founded_year — INT
- headquarters — VARCHAR(255)
financial_facts
- fact_id — INT
- company_id — INT
- year_id — INT
- revenue — DECIMAL
- expenses — DECIMAL
- net_profit — DECIMAL
industry_dimension
- industry_id — INT
- industry_name — VARCHAR(255)
personnel_dimension
- personnel_id — INT
- personnel_name — VARCHAR(255)
- role — VARCHAR(255)
- start_date — DATE
personnel_facts
- fact_id — INT
- company_id — INT
- year_id — INT
- personnel_id — INT
- position — VARCHAR(255)
shareholder_dimension
- shareholder_id — INT
- shareholder_name — VARCHAR(255)
- shareholder_type — VARCHAR(255)
shareholder_facts
- fact_id — INT
- company_id — INT
- year_id — INT
- shareholder_id — INT
- ownership_percentage — DECIMAL
time_dimension
- year_id — INT
- year — INT
- quarter — INT
- month — INT