question.py 725 B

12345678910111213141516171819
  1. # -*- coding: utf-8 -*-
  2. from datetime import datetime
  3. from sqlalchemy import Column, Integer, String, Text, DateTime
  4. from backend.database import Base
  5. class Question(Base):
  6. __tablename__ = "questions"
  7. id = Column(Integer, primary_key=True, index=True)
  8. content = Column(Text, nullable=False)
  9. option_a = Column(String(255), nullable=False)
  10. option_b = Column(String(255), nullable=False)
  11. option_c = Column(String(255), nullable=False)
  12. option_d = Column(String(255), nullable=False)
  13. correct_option = Column(String(1), nullable=False)
  14. knowledge_point = Column(String(100), nullable=True)
  15. difficulty = Column(Integer, default=1)
  16. created_at = Column(DateTime, default=datetime.utcnow)