torus-api/sql/exercises.sql

CREATE TYPE exercise_type AS ENUM ('WeightedReps', 'BodyweightReps', 'Cardio', 'TimedCardio');

CREATE TABLE exercises (
    id            UUID          PRIMARY KEY DEFAULT gen_uuid_v7(),
    workout       UUID          NOT NULL REFERENCES workouts(id) ON DELETE CASCADE,
    name          TEXT          NOT NULL,
    notes         TEXT,
    exercise_type exercise_type NOT NULL,
    position      INTEGER       NOT NULL
);