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