Add basic workout classes

1 files changed, 19 insertions, 0 deletions

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'))