ERD

Tables (18)

holdings

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — Primary key — NOT NULL
  • shares — INT — NOT NULL
  • avg_price — DECIMAL(15, 2) — NOT NULL

price_alerts

  • id — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(50) — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • alert_type — ENUM('above', 'below') — NOT NULL
  • target_price — DECIMAL(15, 2) — NOT NULL
  • is_triggered — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMP — NOT NULL

stock_ai_analyses

  • stock_code — VARCHAR(20) — Primary key — NOT NULL
  • ai_score — TINYINT — NOT NULL
  • ai_grade — ENUM('A+', 'A', 'B+', 'B', 'C')
  • signal — ENUM('buy', 'sell')
  • target_price — DECIMAL(15, 2)
  • summary — TEXT
  • upd_dttm — TIMESTAMP — NOT NULL

stock_ai_reasons

  • id — BIGINT — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • reason_type — ENUM('positive', 'neutral', 'negative') — NOT NULL
  • source_title — VARCHAR(300)
  • source_url — VARCHAR(1000)
  • display_order — INT — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL

stock_ai_report_items

  • id — BIGINT — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • item_type — ENUM('strength', 'risk', 'catalyst') — NOT NULL
  • content — TEXT — NOT NULL
  • display_order — INT — NOT NULL

stock_ai_reports

  • stock_code — VARCHAR(20) — Primary key — NOT NULL
  • overview — TEXT
  • conclusion — TEXT
  • upd_dttm — TIMESTAMP — NOT NULL

stock_dividend_history

  • id — BIGINT — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • year — YEAR — NOT NULL
  • amount — DECIMAL(15, 2)
  • yield — DECIMAL(6, 2)

stock_dividends

  • stock_code — VARCHAR(20) — Primary key — NOT NULL
  • yield — DECIMAL(6, 2)
  • per_share — DECIMAL(15, 2)
  • frequency — VARCHAR(50)
  • payout — DECIMAL(6, 2)
  • last_date — DATE
  • ex_dividend_date — DATE
  • growth_yoy — DECIMAL(6, 2)
  • cagr_3y — DECIMAL(6, 2)
  • consecutive_years — INT
  • coverage — DECIMAL(6, 2)
  • buyback — BIGINT
  • total_return_rate — DECIMAL(6, 2)
  • upd_dttm — TIMESTAMP — NOT NULL

stock_finance_items

  • id — BIGINT — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • section — ENUM('left', 'right') — NOT NULL
  • label — VARCHAR(100) — NOT NULL
  • display_value — VARCHAR(200)
  • raw_value — DECIMAL(20, 4)
  • comment — VARCHAR(500) — ARCHAR(500
  • state — ENUM('positive', 'neutral', 'negative')
  • display_order — INT — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL

stock_forecasts

  • stock_code — VARCHAR(20) — Primary key — NOT NULL
  • forecast_high — DECIMAL(15, 2)
  • forecast_low — DECIMAL(15, 2)
  • forecast_date — DATE
  • upd_dttm — TIMESTAMP — NOT NULL

stock_news

  • id — BIGINT — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • url — VARCHAR(1000)
  • sentiment — ENUM('positive', 'neutral', 'negative') — NOT NULL
  • published_at — DATE
  • reg_dttm — TIMESTAMP — NOT NULL

stock_perf_extras

  • id — BIGINT — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • label — VARCHAR(100) — NOT NULL
  • display_value — VARCHAR(200)
  • raw_value — DECIMAL(20, 4)
  • comment — VARCHAR(500) — ARCHAR(500
  • state — ENUM('positive', 'neutral', 'negative')
  • display_order — INT — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL

stock_performances

  • id — BIGINT — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • period_type — ENUM('quarterly', 'annual') — NOT NULL
  • period — VARCHAR(20) — NOT NULL
  • revenue — DECIMAL(20, 2)
  • operating — DECIMAL(20, 2)
  • op_margin — DECIMAL(6, 2)
  • net — DECIMAL(20, 2)
  • is_up — BOOLEAN — NOT NULL
  • reg_dttm — TIMESTAMP — NOT NULL

stock_price_history

  • stock_code — VARCHAR(20) — Primary key — NOT NULL
  • trade_date — DATE — Primary key — NOT NULL
  • open_price — DECIMAL(15, 2)
  • high_price — DECIMAL(15, 2)
  • low_price — DECIMAL(15, 2)
  • close_price — DECIMAL(15, 2)
  • volume — BIGINT
  • change_pct — DECIMAL(6, 2)
  • reg_dttm — TIMESTAMP — NOT NULL

stocks

  • code — VARCHAR(20) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • market — VARCHAR(20)
  • sector — VARCHAR(100)
  • industry — VARCHAR(100)
  • listed_date — DATE
  • shares — BIGINT
  • ceo — VARCHAR(100)
  • stock_type — ENUM('stock', 'etf') — NOT NULL
  • current_price — DECIMAL(15, 2)
  • change_amount — DECIMAL(15, 2)
  • change_pct — DECIMAL(6, 2)
  • ai_signal — ENUM('buy', 'sell')
  • price_upd_dttm — TIMESTAMP
  • use_yn — CHAR(1) — NOT NULL
  • reg_dttm — TIMESTAMP — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL

subscriptions

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • plan — ENUM('free', 'premium') — NOT NULL
  • started_at — TIMESTAMP
  • expired_at — TIMESTAMP

users

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • email — VARCHAR(200)
  • nickname — VARCHAR(100)
  • profile_img — VARCHAR(500)
  • social_type — VARCHAR(20)
  • social_id — VARCHAR(200)
  • use_yn — CHAR(1) — NOT NULL
  • reg_dttm — TIMESTAMP — NOT NULL
  • upd_dttm — TIMESTAMP — NOT NULL

wish_stock

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • stock_code — VARCHAR(20) — Primary key — NOT NULL
  • sort_order — INT — NOT NULL
  • reg_dttm — TIMESTAMP — NOT NULL