video_category

7 rows where v_uid = "v_6we8j"

This data as json, CSV (advanced)

Link v_uid c_uid
v_6we8j,c_0951h v_6we8j Hi-Def c_0951h
v_6we8j,c_0tc2g v_6we8j Variety c_0tc2g
v_6we8j,c_392vm v_6we8j 4K c_392vm
v_6we8j,c_t7oku v_6we8j Horror c_t7oku
v_6we8j,c_uagh4 v_6we8j Featured Actress c_uagh4
v_6we8j,c_v09bi v_6we8j Serious c_v09bi
v_6we8j,c_x9jyw v_6we8j 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);