home / media

video_category

4 rows where v_uid = "v_ha3wr"

This data as json, CSV (advanced)

Link v_uid c_uid
v_ha3wr,c_34i8d v_ha3wr Cheating Wife c_34i8d
v_ha3wr,c_qjwgm v_ha3wr Adultery c_qjwgm
v_ha3wr,c_s5lxs v_ha3wr Married Woman c_s5lxs
v_ha3wr,c_x9jyw v_ha3wr Drama c_x9jyw

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.563ms