home / media

video_director

3 rows where d_uid = "d_mg5bp"

This data as json, CSV (advanced)

Link v_uid d_uid
v_4rqh4,d_mg5bp v_4rqh4 Kitorune Kawaguchi d_mg5bp
v_n62mm,d_mg5bp v_n62mm Kitorune Kawaguchi d_mg5bp
v_wgl47,d_mg5bp v_wgl47 Kitorune Kawaguchi d_mg5bp

Advanced export

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

CSV options:

CREATE TABLE video_director (
  v_uid TEXT NOT NULL REFERENCES videos(uid)    ON DELETE CASCADE,
  d_uid TEXT NOT NULL REFERENCES directors(uid) ON DELETE CASCADE,
  PRIMARY KEY (v_uid, d_uid)
);
CREATE INDEX idx_video_director_d ON video_director(d_uid);
Powered by Datasette · Queries took 2.159ms