| 12345678910111213141516171819202122232425 |
- # -*- 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)
|
