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)