신한은행 해커톤

테이블 (13)

AI_Report

  • report_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • report_type — ENUM('주간', '시즌') — NOT NULL
  • season — VARCHAR(20)
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • generated_at — TIMESTAMP

Community_Briefing

  • briefing_id — BIGINT
  • card_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

Economic_Event_Card

  • card_id — BIGINT
  • issue_date — DATE — NOT NULL — 발행 주차
  • title — VARCHAR(255) — NOT NULL
  • summary — TEXT — NOT NULL
  • topic — VARCHAR(50) — 통화정책, 물가 등 토픽 분류

Portfolio

  • portfolio_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • season — VARCHAR(20) — NOT NULL — 예: 2025-1학기
  • total_asset_value — DECIMAL(20, 2) — NOT NULL — 총 평가 자산
  • total_profit_loss — DECIMAL(20, 2) — NOT NULL — 총 평가 손익
  • change_count — INT — NOT NULL — 시즌 내 포트폴리오 변경 횟수
  • updated_at — TIMESTAMP

Portfolio_Product

  • portfolio_id — BIGINT — 기본 키 — NOT NULL
  • product_id — INT — 기본 키 — NOT NULL
  • allocation_percentage — DECIMAL(5, 2) — NOT NULL — 자산 배분 비율
  • invested_amount — DECIMAL(20, 2) — NOT NULL — 투자 원금
  • current_value — DECIMAL(20, 2) — NOT NULL — 현재 평가금액

Product

  • product_id — INT
  • product_name — VARCHAR(100) — NOT NULL
  • product_type — ENUM('예금', '적금', '펀드') — NOT NULL — 상품 종류 (안정형/변동형)
  • base_rate — DECIMAL(5, 3) — 기본 금리/수익률
  • description — TEXT

Quiz

  • quiz_id — BIGINT
  • briefing_id — BIGINT — NOT NULL
  • question — TEXT — NOT NULL
  • options — JSON — 객관식 보기 (JSON 배열)
  • correct_answer — VARCHAR(255) — NOT NULL

Quiz_Attempt

  • attempt_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • quiz_id — BIGINT — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • attempted_at — TIMESTAMP

Ranking

  • ranking_id — BIGINT
  • season — VARCHAR(20) — NOT NULL
  • ranking_type — ENUM('개인', '학과', '대학') — NOT NULL
  • target_id — VARCHAR(100) — NOT NULL — user_id, department_name, university_name 등
  • target_name — VARCHAR(100) — NOT NULL
  • rank_value — INT — NOT NULL
  • score — DECIMAL(20, 4) — NOT NULL
  • updated_at — TIMESTAMP

Reward

  • reward_id — INT
  • reward_name — VARCHAR(100) — NOT NULL
  • reward_type — ENUM('땡겨요쿠폰', '마이신한포인트', '우대금리쿠폰') — NOT NULL
  • description — TEXT

Transaction_History

  • transaction_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • transaction_type — VARCHAR(50) — NOT NULL — 포인트전환, 실계좌연동보너스, 상품매수, 상품매도 등
  • amount — DECIMAL(20, 2) — NOT NULL
  • description — VARCHAR(255)
  • transaction_date — TIMESTAMP

User_Reward

  • user_reward_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • reward_id — INT — NOT NULL
  • granted_at — TIMESTAMP
  • is_used — BOOLEAN — NOT NULL

Users

  • user_id — BIGINT
  • user_name — VARCHAR(50) — NOT NULL
  • university_name — VARCHAR(100) — NOT NULL
  • department_name — VARCHAR(100) — NOT NULL
  • virtual_fund_balance — DECIMAL(20, 2) — NOT NULL
  • point_balance — INT — NOT NULL
  • is_real_account_linked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP