재무제표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