home / media

video_director

3 rows where d_uid = "d_ta7jp"

This data as json, CSV (advanced)

Link v_uid d_uid
v_1uavh,d_ta7jp v_1uavh Bacon Tanaka d_ta7jp
v_xp55i,d_ta7jp v_xp55i Bacon Tanaka d_ta7jp
v_ynifx,d_ta7jp v_ynifx Bacon Tanaka d_ta7jp

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