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,