video_star
9 rows where v_uid = "v_hs603"
This data as json, CSV (advanced)
| Link | v_uid | a_uid |
|---|---|---|
| v_hs603,a_0u1gt | v_hs603 | Fujishiro Momoha a_0u1gt |
| v_hs603,a_1zoax | v_hs603 | Natsuhara Yui a_1zoax |
| v_hs603,a_axfcn | v_hs603 | Kuru Maebi a_axfcn |
| v_hs603,a_bn8lp | v_hs603 | Kaori Momota a_bn8lp |
| v_hs603,a_i1q7w | v_hs603 | Kururugi Aoi a_i1q7w |
| v_hs603,a_i7lbf | v_hs603 | Mio Kimijima a_i7lbf |
| v_hs603,a_jo1q7 | v_hs603 | Hori Mamiko a_jo1q7 |
| v_hs603,a_td4bl | v_hs603 | Mio Ichijō a_td4bl |
| v_hs603,a_yqn0q | v_hs603 | Honjo Hina a_yqn0q |
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);