재무제표DB

테이블 (4)

Company (company)

  • Company Code (company_code) — TEXT — 기본 키
  • Name (name) — TEXT
  • Stock Code (stock_code) — TEXT

Company Aliases (company_aliases)

  • Company Code (company_code) — TEXT — 외래 키 → Company.Company Code
  • Alias (alias) — TEXT

DollarExchangeRate (dollar_exchange_rate)

  • Year (year) — Int — 기본 키 — NOT NULL
  • Month (month) — Int — 기본 키 — NOT NULL
  • Currency (currency) — TEXT — 기본 키 — NOT NULL
  • Rate (rate) — REAL

Finance (finance)

  • Report Code (report_code) — TEXT — 기본 키
  • Report Type (report_type) — TEXT — 기본 키 — NOT NULL
  • Company Code (company_code) — TEXT — 외래 키 → Company.Company Code
  • Year (year) — INTEGER
  • Quarter (quarter) — INTEGER
  • Cumulative Month (cumulative_month) — INTEGER
  • Currency (currency) — TEXT
  • Equity (equity) — INTEGER
  • Debt (debt) — INTEGER
  • Sales (sales) — INTEGER
  • Operating profit (operating_profit) — INTEGER
  • Net Profit (net_profit) — INTEGER
  • Cash Equiavalents (cash_equivalents) — INTEGER