20250715_woori_db_v2

Tables (10)

Untitled (📌 1. 종목 마스터 테이블 (Symbol, 국가, 거래소 등))

    company_profile

    • stock_id — INT — Primary key
    • company_name — VARCHAR(255)
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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,