video_star
5 rows where v_uid = "v_c7m1p"
This data as json, CSV (advanced)
| Link | v_uid | a_uid |
|---|---|---|
| v_c7m1p,a_5iwcg | v_c7m1p | Koko Mashiro a_5iwcg |
| v_c7m1p,a_dnxmn | v_c7m1p | Kanon Urara a_dnxmn |
| v_c7m1p,a_ezxg7 | v_c7m1p | Tojo Natsu a_ezxg7 |
| v_c7m1p,a_gwcng | v_c7m1p | Iroha Minami a_gwcng |
| v_c7m1p,a_pr8pi | v_c7m1p | Mio Hinazuru a_pr8pi |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE video_star ( v_uid TEXT NOT NULL REFERENCES videos(uid) ON DELETE CASCADE, a_uid TEXT NOT NULL REFERENCES actresses(uid) ON DELETE CASCADE, PRIMARY KEY (v_uid, a_uid) ); CREATE INDEX idx_video_star_a ON video_star(a_uid);