question_option_model.py 966 B

123456789101112131415161718192021222324
  1. from sqlalchemy import Column, Integer, String, Boolean, ForeignKey
  2. from .base_model import BaseModel, CreateModel, UpdateModel, DeleteModel
  3. class QuestionOptionModel(BaseModel, CreateModel, UpdateModel, DeleteModel):
  4. """
  5. 题目选项模型
  6. 对应数据库表: question_options
  7. """
  8. __tablename__ = 'question_options'
  9. question_id = Column(Integer,
  10. ForeignKey('questions.id'),
  11. nullable=False,
  12. comment='题目ID')
  13. option_text = Column(String(500), nullable=False, comment='选项内容')
  14. is_correct = Column(Boolean,
  15. nullable=False,
  16. default=False,
  17. comment='是否为正确答案')
  18. order = Column(Integer, nullable=False, comment='选项顺序')
  19. def __repr__(self):
  20. return f"<QuestionOption(id={self.id}, question_id={self.question_id}, option_text={self.option_text})>"