summaryrefslogtreecommitdiff
path: root/app/tables/workout.py
blob: f3a41eb703c58de5096238c62745b31ff10dc781 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
from app import db, login_manager

# Represents an individual exercise
class Exercise(db.Model)
    __tablename__ = 'exercises'
    id = db.Column(db.Integer, primary_key=True)

# Represents a singular workout
class Workout(db.Model)
    __tablename__ = 'workouts'
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

# Connects workouts to it's exercises
class WorkoutExercise(db.Model)
    __table__ = 'workout_exercises'
    id = db.Column(db.Integer, primary_key=True)
    workout_id = db.Column(db.Integer, db.ForeignKey('workout.id'))
    exercise_id = db.Column(db.Integer, db.ForeignKey('exercise.id'))