home / media

video_category

18 rows where c_uid = "c_l1paj"

This data as json, CSV (advanced)

Link v_uid c_uid
v_2ef04,c_l1paj v_2ef04 Office Lady c_l1paj
v_45ro5,c_l1paj v_45ro5 Office Lady c_l1paj
v_4x4vs,c_l1paj v_4x4vs Office Lady c_l1paj
v_8ugd7,c_l1paj v_8ugd7 Office Lady c_l1paj
v_d1mjs,c_l1paj v_d1mjs Office Lady c_l1paj
v_dc6qd,c_l1paj v_dc6qd Office Lady c_l1paj
v_dmom8,c_l1paj v_dmom8 Office Lady c_l1paj
v_ejw32,c_l1paj v_ejw32 Office Lady c_l1paj
v_fh8ly,c_l1paj v_fh8ly Office Lady c_l1paj
v_hkmrs,c_l1paj v_hkmrs Office Lady c_l1paj
v_imq2d,c_l1paj v_imq2d Office Lady c_l1paj
v_l128r,c_l1paj v_l128r Office Lady c_l1paj
v_lx349,c_l1paj v_lx349 Office Lady c_l1paj
v_p8lc5,c_l1paj v_p8lc5 Office Lady c_l1paj
v_qz1lf,c_l1paj v_qz1lf Office Lady c_l1paj
v_r9w9c,c_l1paj v_r9w9c Office Lady c_l1paj
v_us0rh,c_l1paj v_us0rh Office Lady c_l1paj
v_zup3h,c_l1paj v_zup3h Office Lady c_l1paj

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 3.283ms