home / media

video_category

6 rows where c_uid = "c_qhkw2"

This data as json, CSV (advanced)

Link v_uid c_uid
v_206bx,c_qhkw2 v_206bx Chubby c_qhkw2
v_foth6,c_qhkw2 v_foth6 Chubby c_qhkw2
v_gwwbq,c_qhkw2 v_gwwbq Chubby c_qhkw2
v_ixw89,c_qhkw2 v_ixw89 Chubby c_qhkw2
v_y2cmn,c_qhkw2 v_y2cmn Chubby c_qhkw2
v_y98gv,c_qhkw2 v_y98gv Chubby c_qhkw2

Advanced export

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

CSV options:

CREATE TABLE video_category (
  v_uid TEXT NOT NULL REFERENCES videos(uid)     ON DELETE CASCADE,
  c_uid TEXT NOT NULL REFERENCES categories(uid) ON DELETE CASCADE,
  PRIMARY KEY (v_uid, c_uid)
);
CREATE INDEX idx_video_category_c ON video_category(c_uid);
Powered by Datasette · Queries took 2.295ms