progress

0 rows where profile_id = "eb64543e"

✎ View and edit SQL

This data as json

0 records

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