hongik_grad

Tables (16)

analysis_models

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL — 예: 기본 모델, 성장주 모델
  • description — TEXT — 모델 설명
  • is_default — TINYINT(1) — NOT NULL — 기본 추천 모델 여부
  • is_active — TINYINT(1) — NOT NULL — 활성 여부 (사용자에게 노출)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

analysis_reports

  • id — BIGINT — Primary key — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → stocks.ticker — NOT NULL — FK stocks.ticker
  • model_id — BIGINT — Foreign key → analysis_models.id — NOT NULL — FK analysis_models.id
  • disclosure_id — BIGINT — Foreign key → disclosures.id — FK disclosures.id (정기 분석 등은 null)
  • title — VARCHAR(255) — NOT NULL
  • summary — TEXT — 요약
  • key_findings — JSON — 핵심 발견 배열 "...", "..."
  • metrics — JSON — 주요 지표 {"revenue": ..., "yoy_growth": ...}
  • model_specific_data — JSON — 모델별 확장 필드 (TBD)
  • generated_at — DATETIME — NOT NULL

disclosures

  • id — BIGINT — Primary key — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → stocks.ticker — NOT NULL — FK stocks.ticker
  • dart_filing_id — VARCHAR(50) — NOT NULL — DART 고유 접수번호
  • title — VARCHAR(255) — NOT NULL
  • type — ENUM('report', 'quarterly', 'interim', 'event') — NOT NULL — report=사업보고서, quarterly=분기실적, interim=잠정실적, event=수시공시
  • filed_at — DATETIME — NOT NULL — 공시 접수 시각
  • dart_url — VARCHAR(500) — DART 원문 URL
  • raw_text_storage — VARCHAR(500) — 본문 외부 저장 경로(S3 키 등)
  • created_at — DATETIME — NOT NULL

favorites

  • id — BIGINT — Primary key — NOT NULL
  • folder_id — BIGINT — Foreign key → folders.id — NOT NULL — FK folders.id
  • ticker — VARCHAR(10) — Foreign key → stocks.ticker — NOT NULL — FK stocks.ticker
  • memo — VARCHAR(100) — 자유 메모
  • avg_price — BIGINT — 평균 매수가 (원 단위 정수)
  • added_at — DATETIME — NOT NULL

fcm_tokens

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — FK users.id
  • device_token — VARCHAR(512) — NOT NULL — FCM 디바이스 토큰
  • platform — ENUM('ios', 'android') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

financial_statements

  • id — BIGINT — Primary key — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → stocks.ticker — NOT NULL — FK stocks.ticker
  • period_type — ENUM('quarterly', 'annual') — NOT NULL
  • period — VARCHAR(10) — NOT NULL — 예: 2025Q4 또는 2025
  • revenue — BIGINT — 매출액 (원)
  • cost_of_revenue — BIGINT — 매출원가
  • gross_profit — BIGINT — 매출총이익
  • operating_profit — BIGINT — 영업이익
  • net_income — BIGINT — 순이익
  • total_assets — BIGINT — 총자산
  • total_liabilities — BIGINT — 총부채
  • total_equity — BIGINT — 총자본
  • per — DECIMAL(10, 2) — 주가수익비율
  • pbr — DECIMAL(10, 2) — 주가순자산비율
  • eps — BIGINT — 주당순이익
  • dividend_yield — DECIMAL(5, 2) — 배당수익률(%)
  • data_source — VARCHAR(50) — 데이터 출처
  • updated_at — DATETIME — NOT NULL

folders

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — FK users.id
  • name — VARCHAR(30) — NOT NULL — 폴더 이름
  • color — VARCHAR(7) — NOT NULL — HEX 색상
  • type — ENUM('default', 'custom') — NOT NULL — 회원가입 시 default 폴더 1개 자동 생성
  • display_order — INT — NOT NULL — 표시 순서
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — FK users.id
  • type — ENUM('disclosure_report') — NOT NULL — v3 1종, 확장 시 추가
  • title — VARCHAR(255) — NOT NULL
  • body — TEXT
  • ticker — VARCHAR(10) — Foreign key → stocks.ticker — FK stocks.ticker (관련 종목)
  • report_id — BIGINT — Foreign key → analysis_reports.id — FK analysis_reports.id (딥링크 대상)
  • is_read — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

refresh_tokens

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — FK users.id
  • token_hash — VARCHAR(255) — NOT NULL — Refresh Token의 해시 저장
  • expires_at — DATETIME — NOT NULL — 만료 시각
  • revoked_at — DATETIME — 로그아웃/탈퇴 시 무효화 시각
  • created_at — DATETIME — NOT NULL

report_read_status

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — FK users.id
  • report_id — BIGINT — Foreign key → analysis_reports.id — NOT NULL — FK analysis_reports.id
  • read_at — DATETIME — NOT NULL

search_history

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — FK users.id
  • keyword — VARCHAR(100) — NOT NULL — 검색 키워드
  • searched_at — DATETIME — NOT NULL

stock_news

  • id — BIGINT — Primary key — NOT NULL
  • ticker — VARCHAR(10) — Foreign key → stocks.ticker — NOT NULL — FK stocks.ticker
  • title — VARCHAR(255) — NOT NULL
  • source — VARCHAR(100) — 출처 (예: 한국경제)
  • url — VARCHAR(500) — NOT NULL — 원문 URL
  • thumbnail_url — VARCHAR(500)
  • published_at — DATETIME — NOT NULL — 발행 시각
  • created_at — DATETIME — NOT NULL

stock_view_counts

  • ticker — VARCHAR(10) — Foreign key → stocks.ticker — NOT NULL
  • view_count — BIGINT — NOT NULL
  • updated_at — DATETIME — NOT NULL

stocks

  • ticker — VARCHAR(10) — Primary key — NOT NULL — 종목코드 (예: 005930)
  • name — VARCHAR(100) — NOT NULL — 기업명
  • market — ENUM('KOSPI', 'KOSDAQ') — NOT NULL
  • category — VARCHAR(50) — 카테고리 (반도체/방산/바이오 등)
  • description — TEXT — 기업 소개
  • listed_at — DATE — 상장일
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_stock_models

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — FK users.id
  • ticker — VARCHAR(10) — Foreign key → stocks.ticker — NOT NULL — FK stocks.ticker
  • model_id — BIGINT — Foreign key → analysis_models.id — NOT NULL — FK analysis_models.id
  • applied_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL — PK
  • email — VARCHAR(255) — NOT NULL — 로그인 ID (이메일)
  • password_hash — VARCHAR(255) — NOT NULL — bcrypt 해시
  • nickname — VARCHAR(50) — NOT NULL — 닉네임 (자동생성 가능)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME — 회원 탈퇴 시각 (soft delete)