class Customer_Questionaire_Questions(db.Model):
__tablename__ = "customer_questionaire_questions"
questionaire_questions = db.relationship(Questionaire_Questions)
person = db.relationship(Person)
id = db.Column(db.Integer(), primary_key=True)
question_id = db.Column(db.Integer(),
db.ForeignKey('questionaire_questions.id'),
nullable=False)
customer_id = db.Column(db.Integer(),
db.ForeignKey('person.id'),
nullable=False)
def __init__(self, question_id, customer_id):
self.question_id = question_id
self.customer_id = customer_id
def __repr__(self):
return f"Customer Questions {self.id}"
class Child_Questionaire_Questions(db.Model):
__tablename__ = "child_questionaire_questions"
questionaire_questions = db.relationship(Questionaire_Questions)
child = db.relationship(Child)
id = db.Column(db.Integer(), primary_key=True)
question_id = db.Column(db.Integer(),
db.ForeignKey('questionaire_questions.id'),
nullable=False)
child_id = db.Column(db.Integer(),
db.ForeignKey('child.id'),
nullable=False)
def __init__(self, question_id, child_id):
self.question_id = question_id
self.child_id = child_id
def __repr__(self):
return f"Child Questions {self.id}"
class Payments(db.Model):
__tablename__ = "payments"
person = db.relationship(Person)
lesson = db.relationship(Lesson)
class_program = db.relationship(Class_Program)
id = db.Column(db.Integer(), primary_key=True)
payee_id = db.Column(db.Integer(),
db.ForeignKey('person.id'),
nullable=False)
lesson_id = db.Column(db.Integer(),
db.ForeignKey('lesson.id'),
nullable=True)
class_program_id = db.Column(db.Integer(),
db.ForeignKey('class_program.id'),
nullable=True)
payment_value = db.Column(db.Float())
payment_name = db.Column(db.String(80))
payment_type = db.Column(db.String(80))
payment_date = db.Column(db.DateTime(),
nullable=False,
default=datetime.utcnow)
includes_gst = db.Column(db.Boolean())
payment_description = db.Column(db.String(255))
def __init__(self, payee_id, lesson_id, class_program_id, payment_value,
payment_name, payment_type, payment_date, includes_gst,
payment_description):
self.payee_id = payee_id
self.lesson_id = lesson_id
self.class_program_id = class_program_id
self.payment_value = payment_value
self.payment_name = payment_name
self.payment_type = payment_type
self.payment_date = payment_date
self.includes_gst = includes_gst
self.payment_description = payment_description
def __repr__(self):
return f"Payment Name: {self.payment_name} -- Payment Value: {self.payment_value} -- Payment Date: {self.payment_date}"
class Questionaire_Questions(db.Model):
__tablename__ = "questionaire_questions"
questionaire = db.relationship(Questionaire)
id = db.Column(db.Integer(), primary_key=True)
questionaire_id = db.Column(db.Integer(),
db.ForeignKey('questionaire.id'),
nullable=False)
question = db.Column(db.String(120))
response = db.Column(db.String(50))
def __init__(self, questionaire_id, question, response):
self.questionaire_id = questionaire_id
self.question = question
self.response = response
def __repr__(self):
return f"Questionaire Questions {self.question}"
class Class_List(db.Model):
__tablename__ = "class_list"
person = db.relationship(Person)
id = db.Column(db.Integer(), primary_key=True)
participant_id = db.Column(db.Integer(),
db.ForeignKey('person.id'),
nullable=False)
lesson_id = db.Column(db.Integer(),
db.ForeignKey('lesson.id'),
nullable=False)
def __init__(self, participant_id, lesson_id):
self.participant_id = participant_id
self.lesson_id = lesson_id
def __repr__(self):
return f"Lesson Id: {self.lesson_id} -- Participant Id: {self.participant_id}"
class Curriculum_Item(db.Model):
__tablename__ = "curriculum_item"
Curriculum = db.relationship(Curriculum)
id = db.Column(db.Integer(), primary_key=True)
curriculum_id = db.Column(db.Integer(),
db.ForeignKey('curriculum.id'),
nullable=False)
subject = db.Column(db.String(80))
term = db.Column(db.Integer())
topic = db.Column(db.String(400))
learnt_skill = db.Column(db.String(400))
concepts = db.Column(db.String(400))
activity = db.Column(db.String(400))
resources = db.Column(db.String(400))
sample_to_collect = db.Column(db.String(400))
information_recorded = db.Column(db.String(400))
notes = db.Column(db.String(400))
def __init__(self, curriculum_id, subject, term, topic, learnt_skill,
concepts, activity, resources, sample_to_colect,
information_recorded, notes):
self.curriculum_id = curriculum_id
self.subject = subject
self.term = term
self.topic = topic
self.learnt_skill = learnt_skill
self.concepts = concepts
self.activity = activity
self.resources = resources
self.sample_to_collect = sample_to_colect
self.information_recorded = information_recorded
self.notes = notes
def __repr__(self):
return f"Curriculum Item: {self.id}"
######################################
class Child(db.Model):
__tablename__ = "child"
person = db.relationship(Person)
id = db.Column(db.Integer(), primary_key=True)
parent_id = db.Column(db.Integer(),
db.ForeignKey('person.id'),
nullable=False)
first_name = db.Column(db.String(80))
last_name = db.Column(db.String(80), nullable=False)
date_of_birth = db.Column(db.DateTime(), nullable=False)
notes = db.Column(db.String(255))
def __init__(self, parent_id, first_name, last_name, date_of_birth, notes):
self.parent_id = parent_id
self.first_name = first_name
self.last_name = last_name
self.date_of_birth = date_of_birth
self.notes = notes
def __repr__(self):
return f"First Name: {self.first_name} -- Last Name: {self.last_name}"
class Class_Program(db.Model):
__tablename__ = "class_program"
lesson = db.relationship(Lesson)
id = db.Column(db.Integer(), primary_key=True)
lesson_id = db.Column(db.Integer(),
db.ForeignKey('lesson.id'),
nullable=False)
program_name = db.Column(db.String(80))
program_cost = db.Column(db.Float())
program_discount = db.Column(db.Float())
program_description = db.Column(db.String(255))
def __init__(self, program_name, lesson_id, program_cost, program_discount,
program_description):
self.program_name = program_name
self.lesson_id = lesson_id
self.program_cost = program_cost
self.program_discount = program_discount
self.program_description = program_description
def __repr__(self):
return f"Program Name {self.program_name}"