torus-api/migrations/0006_create_sessions.sql

CREATE TABLE sessions (
    id         UUID        PRIMARY KEY DEFAULT gen_uuid_v7(),
    workout    UUID        NOT NULL REFERENCES workouts(id) ON DELETE CASCADE,
    user_id    UUID        NOT NULL REFERENCES users(id) ON DELETE CASCADE,
    created_at TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE TABLE session_exercises (
    id               UUID          PRIMARY KEY DEFAULT gen_uuid_v7(),
    session          UUID          NOT NULL REFERENCES sessions(id) ON DELETE CASCADE,
    exercise         UUID          NOT NULL REFERENCES exercises(id) ON DELETE CASCADE,
    name             TEXT          NOT NULL,
    notes            TEXT,
    exercise_type    exercise_type NOT NULL,
    position         INTEGER       NOT NULL,
    sets             INTEGER,
    reps             INTEGER,
    weight           DOUBLE PRECISION,
    duration_seconds INTEGER,
    distance_meters  DOUBLE PRECISION
);