From 5d74e9e1bb30e65dbd4d0528f7140b7813965841 Mon Sep 17 00:00:00 2001 From: stilbruch Date: Wed, 23 Mar 2022 19:08:05 -0500 Subject: Add basic workout classes --- app/tables/workout.py | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 app/tables/workout.py diff --git a/app/tables/workout.py b/app/tables/workout.py new file mode 100644 index 0000000..f3a41eb --- /dev/null +++ b/app/tables/workout.py @@ -0,0 +1,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')) -- cgit v1.2.3