class Client(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text, unique=True)
forms = db.relationship('Form', backref='client')
def __init__(self, name):
self.name = name
class QuestionGroupTemplate(db.Model):
id = db.Column(db.Integer, primary_key=True)
template = db.Column(db.Text)
version = db.Column(db.Integer, default=0)
def __init__(self, template):
self.template = template
class RetailChain(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.Text)
forms = db.relationship('Form', backref='retail_chain')
def __init__(self, name):
self.name = name
class Question(db.Model):
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.Text)
question_group_id = db.Column(db.Integer,
db.ForeignKey('question_group.id'))
choices = db.relationship('Choice', backref='question')
def __init__(self, text):
self.text = text
class Choice(db.Model):
id = db.Column(db.Integer, primary_key=True)
text = db.Column(db.Text)
question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
choice_template_id = db.Column(db.Integer,
db.ForeignKey('choice_template.id'))
def __init__(self, text):
self.text = text
class QuestionTemplate(db.Model):
id = db.Column(db.Integer, primary_key=True)
template = db.Column(db.Text)
version = db.Column(db.Integer, default=0)
question_group_template_id = db.Column(
db.Integer, db.ForeignKey('question_group_template.id'))
choice_templates = db.relationship('ChoiceTemplate')
def __init__(self, template):
self.template = template
class QuestionGroup(db.Model):
id = db.Column(db.Integer, primary_key=True)
version = db.Column(db.Integer, default=0)
parent_id = db.Column(db.Integer, db.ForeignKey('question_group.id'))
question_group_template_id = db.Column(
db.Integer, db.ForeignKey('question_group_template.id'))
forms = db.relationship('Form', backref='question_group')
def __init__(self):
pass
class Madlib(db.Model):
id = db.Column(db.Integer, primary_key=True)
word = db.Column(db.Text)
word_type = db.Column(db.Text)
version = db.Column(db.Integer, default=0)
client_id = db.Column(db.Integer, db.ForeignKey('client.id'))
question_id = db.Column(db.Integer, db.ForeignKey('question.id'))
def __init__(self, word, word_type):
self.word = word
self.word_type = word_type
class Form(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.Text)
version = db.Column(db.Integer, default=0)
client_id = db.Column(db.Integer, db.ForeignKey('client.id'))
question_group_id = db.Column(db.Integer,
db.ForeignKey('question_group.id'))
retail_chain_id = db.Column(db.Integer, db.ForeignKey('retail_chain.id'))
def __init__(self, title):
self.title = title
