class Activity(db.Model):
""" Activity- id, name and intensity required """
id = db.Column(db.String(128), primary_key=True)
name = db.Column(db.String(128), nullable=False)
intensity = db.Column(db.Integer, nullable=False)
# Description max size 8K for simplicity reasons
description = db.Column(db.String(8 * 1024), nullable=True)
persons = relationship("ActivityRecord", cascade="all, delete-orphan")
class MealPortion(db.Model):
meal_id = db.Column(db.String(128),
ForeignKey('meal.id'),
primary_key=True)
portion_id = db.Column(db.String(128),
ForeignKey('portion.id'),
primary_key=True)
weight_per_serving = db.Column(db.Float, nullable=False)
class Portion(db.Model):
id = db.Column(db.String(128), primary_key=True)
name = db.Column(db.String(128), nullable=False)
calories = db.Column(db.Float, nullable=False)
density = db.Column(db.Float, nullable=True)
alcohol = db.Column(db.Float, nullable=True, default=0)
carbohydrate = db.Column(db.Float, nullable=True, default=0)
protein = db.Column(db.Float, nullable=True, default=0)
fat = db.Column(db.Float, nullable=True, default=0)
class Meal(db.Model):
""" id, name and servings required """
id = db.Column(db.String(128), primary_key=True)
name = db.Column(db.String(128), nullable=False)
servings = db.Column(db.Float, nullable=False)
# Description max size 8K for simplicity reasons
description = db.Column(db.String(8 * 1024), nullable=True)
meal_records = relationship("MealRecord", cascade="all, delete-orphan")
portions = relationship("MealPortion", cascade="all, delete-orphan")
class MealRecord(db.Model):
""" MealRecord- All columns required """
person_id = db.Column(db.String(128),
ForeignKey('person.id'),
primary_key=True)
meal_id = db.Column(db.String(128),
ForeignKey('meal.id'),
primary_key=True)
person = relationship(Person,
backref=backref("meals",
cascade="all, delete-orphan"))
meal = relationship(Meal, backref=backref("mealrecords"))
amount = db.Column(db.Float, nullable=False)
timestamp = db.Column(db.DateTime, primary_key=True)
class ActivityRecord(db.Model):
""" ActivityRecord- All columns required """
person_id = db.Column(db.String(128),
ForeignKey('person.id'),
primary_key=True)
activity_id = db.Column(db.String(128),
ForeignKey('activity.id'),
primary_key=True)
person = relationship(Person,
backref=backref("activities",
cascade="all, delete-orphan"))
activity = relationship(Activity, backref=backref("activityrecords"))
duration = db.Column(db.Integer, nullable=False)
timestamp = db.Column(db.DateTime, primary_key=True)
class Person(db.Model):
""" Person- All columns required """
id = db.Column(db.String(128), primary_key=True)