video_star
5 rows where v_uid = "v_8bvhg"
This data as json, CSV (advanced)
| Link | v_uid | a_uid |
|---|---|---|
| v_8bvhg,a_26koh | v_8bvhg | Itou Miyuu a_26koh |
| v_8bvhg,a_2t7iv | v_8bvhg | Kuriyama Ema a_2t7iv |
| v_8bvhg,a_6kpxg | v_8bvhg | Mamiya Aya a_6kpxg |
| v_8bvhg,a_cotje | v_8bvhg | Un Mei a_cotje |
| v_8bvhg,a_is2z0 | v_8bvhg | Kirika Yuuri a_is2z0 |
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);