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