video_director
4 rows where d_uid = "d_ikn7g"
This data as json, CSV (advanced)
| Link | v_uid | d_uid |
|---|---|---|
| v_s40pc,d_ikn7g | v_s40pc | ケンタブリトニー d_ikn7g |
| v_scdpe,d_ikn7g | v_scdpe | ケンタブリトニー d_ikn7g |
| v_syd0a,d_ikn7g | v_syd0a | ケンタブリトニー d_ikn7g |
| v_v8p52,d_ikn7g | v_v8p52 | ケンタブリトニー d_ikn7g |
Advanced export
JSON shape: default, array, newline-delimited, object
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);