woori_db_v2

Tables (9)

company_profile

  • stock_id — INT — Primary key
  • company_name — VARCHAR(255) — NOT NULL
  • sector — VARCHAR(100)
  • industry — VARCHAR(100)
  • description — TEXT
  • ceo — VARCHAR(100)
  • ipo_date — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

daily_financial_metrics

  • id — SERIAL — Primary key
  • stock_id — INT — NOT NULL
  • metric_date — DATE — NOT NULL
  • metric_type — VARCHAR(50) — NOT NULL
  • metric_value — FLOAT
  • source — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(stock_id, — metric_date,

daily_prices

  • id — SERIAL — Primary key
  • stock_id — INT — NOT NULL
  • price_date — DATE — NOT NULL
  • closing_price — FLOAT — NOT NULL
  • percent_change — FLOAT
  • net_change — FLOAT
  • market_cap — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(stock_id, — price_date)

dividend_events

  • id — SERIAL — Primary key
  • stock_id — INT — NOT NULL
  • ex_dividend_date — DATE — NOT NULL
  • payment_date — DATE
  • dividend_amount — DECIMAL(10,4)
  • frequency — VARCHAR(20)
  • source — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(stock_id, — ex_dividend_date)

dividend_ttm_metrics

  • id — SERIAL — Primary key
  • stock_id — INT — NOT NULL
  • metric_date — DATE — NOT NULL
  • dividend_yield_ttm — DECIMAL(8,4)
  • payout_ratio_ttm — DECIMAL(8,4)
  • annual_dividend_ttm — DECIMAL(10,4)
  • source — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(stock_id, — metric_date)

financial_metrics

  • id — SERIAL — Primary key
  • stock_id — INT — NOT NULL
  • fiscal_year — INT — NOT NULL
  • fiscal_period — VARCHAR(10) — NOT NULL
  • date — DATE — NOT NULL
  • metric_type — VARCHAR(50) — NOT NULL
  • metric_value — FLOAT
  • source — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(stock_id, — fiscal_year,

outstanding_shares

  • id — SERIAL — Primary key
  • stock_id — INT — NOT NULL
  • record_date — TIMESTAMP — NOT NULL
  • shares_outstanding — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(stock_id, — record_date)

revenue_segments

  • id — SERIAL — Primary key
  • stock_id — INT — NOT NULL
  • date — DATE — NOT NULL
  • fiscal_year — INT — NOT NULL
  • fiscal_period — VARCHAR(10) — NOT NULL
  • segment_name — VARCHAR(100) — NOT NULL
  • segment_revenue — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(stock_id, — date,

stock_list

  • id — SERIAL — Primary key
  • symbol — VARCHAR(20) — NOT NULL
  • country — VARCHAR(3) — NOT NULL
  • exchange — VARCHAR(20) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • UNIQUE(symbol, — country,