sets

2 rows where exercise_id = 42

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ session_id exercise_id set_number weight_kg reps assist_reps notes
41 2 2 Push-ups (bonus) 42 1 BW 9   Bonus burnout set
42 2 2 Push-ups (bonus) 42 2 BW 7   Bonus burnout set

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE sets (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    session_id INTEGER NOT NULL REFERENCES sessions(id),
    exercise_id INTEGER NOT NULL REFERENCES exercises(id),
    set_number INTEGER NOT NULL,
    weight_kg TEXT,
    reps INTEGER,
    assist_reps INTEGER,
    notes TEXT
);