progress

2 rows where profile_id = "0e710625"

✎ View and edit SQL

This data as json, CSV (advanced)

Link profile_id tmdb_id media_type position_seconds duration_seconds season episode completed updated_at
0e710625,73586,tv 0e710625 73586 tv 906 3845 5 1 0 1771819944
0e710625,1236153,movie 0e710625 1236153 movie 40 6223     0 1771793409

Advanced export

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

CSV options: 

CREATE TABLE progress (
    profile_id       TEXT NOT NULL REFERENCES profiles(id) ON DELETE CASCADE,
    tmdb_id          INTEGER NOT NULL,
    media_type       TEXT NOT NULL CHECK(media_type IN ('movie','tv')),
    position_seconds INTEGER NOT NULL DEFAULT 0,
    duration_seconds INTEGER,
    season           INTEGER,
    episode          INTEGER,
    completed        INTEGER NOT NULL DEFAULT 0,
    updated_at       INTEGER NOT NULL,
    PRIMARY KEY (profile_id, tmdb_id, media_type)
  );