class AnswerGiven(db.Model):
__tablename__ = 'answergiven'
id = db.Column(db.Integer, primary_key=True)
question_id = db.Column(db.Integer,
db.ForeignKey('question.id'),
nullable=False)
question = db.relationship('Question')
team_id = db.Column(db.Integer, db.ForeignKey('team.id'), nullable=False)
answered_by = db.relationship('Team')
subanswersgiven = db.relationship('SubAnswerGiven')
class Question(db.Model):
__tablename__ = 'question'
id = db.Column(db.Integer, primary_key=True)
questionnumber = db.Column(db.Integer)
person_id = db.Column(db.Integer, db.ForeignKey('person.id'))
createdby = db.relationship('Person')
category_id = db.Column(db.Integer, db.ForeignKey('category.id'))
questioncategory = db.relationship('Category')
type_id = db.Column(db.Integer, db.ForeignKey('type.id'))
questiontype = db.relationship('Type')
question = db.Column(db.String(255))
subanswers = db.relationship('SubAnswer')
active = db.Column(db.Boolean)
def get_question(self):
return self.question
class SubAnswerGiven(db.Model):
""" A answer can consist of multiple lines, this indicates a single line of an answer. """
__tablename__ = 'subanswergiven'
id = db.Column(db.Integer, primary_key=True)
corr_answer_id = db.Column(db.Integer,
db.ForeignKey('subanswer.id'),
nullable=False)
corr_answer = db.relationship('SubAnswer')
read_answer = db.Column(db.String(255))
correct = db.Column(db.Boolean)
confidence = db.Column(db.Float)
person_id = db.Column(db.Integer,
db.ForeignKey('person.id'),
nullable=False)
checkedby = db.relationship('Person')
line_id = db.Column(db.Integer, db.ForeignKey('line.id'), nullable=False)
line = db.relationship('Line')
answergiven_id = db.Column(db.Integer,
db.ForeignKey('answergiven.id'),
nullable=False)
class SubAnswer(db.Model):
""" question can have multiple subquestions, each subquestion has a subanswer """
__tablename__ = 'subanswer'
id = db.Column(db.Integer, primary_key=True)
question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
variants = db.relationship('Variant')