streams

6 rows where v_uid = "v_0feup"

This data as json, CSV (advanced)

Suggested facets: kind, addedAt (date), updatedAt (date)

CREATE TABLE streams (
  id         INTEGER PRIMARY KEY,
  v_uid      TEXT NOT NULL REFERENCES videos(uid) ON DELETE CASCADE,
  source     TEXT NOT NULL,
  sourceUrl  TEXT,
  embedUrl   TEXT,
  proxyUrl   TEXT,
  directLink TEXT,
  kind       TEXT NOT NULL DEFAULT 'embed'
               CHECK (kind IN ('embed', 'm3u8', 'mp4', 'webm', 'ts')),
  addedAt    TEXT NOT NULL DEFAULT (datetime('now')),
  updatedAt  TEXT NOT NULL DEFAULT (datetime('now')),

  dedupe TEXT GENERATED ALWAYS AS (
    source || char(10) || coalesce(embedUrl, proxyUrl, directLink, sourceUrl, '')
  ) STORED,
  UNIQUE (v_uid, dedupe)
);
CREATE INDEX idx_streams_video  ON streams(v_uid);
CREATE INDEX idx_streams_source ON streams(source);