# -*- coding: utf-8 -*-
"""学生学习档案：基础学习画像信息"""
from datetime import datetime
from sqlalchemy import Column, Integer, String, DateTime, ForeignKey

from backend.database import Base


class StudentProfile(Base):
    __tablename__ = "student_profiles"

    id = Column(Integer, primary_key=True, index=True)
    user_id = Column(Integer, ForeignKey("users.id"), nullable=False, index=True)

    # 当前学习进度 / 阶段
    current_topic = Column(String(80), nullable=True)  # 如“物质构成-原子和分子”
    learning_stage = Column(String(50), nullable=True)  # 如“初二下·化学上册”

    # 累计学习行为统计
    total_study_time = Column(Integer, default=0)  # 单位：分钟
    total_questions_answered = Column(Integer, default=0)

    last_active_at = Column(DateTime, nullable=True)
    created_at = Column(DateTime, default=datetime.utcnow)