신한은행 해커톤
테이블 (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