video_maker
2 rows where m_uid = "m_jd2m9"
This data as json, CSV (advanced)
| Link | v_uid | m_uid |
|---|---|---|
| v_f3ac1,m_jd2m9 | v_f3ac1 | Alice JAPAN m_jd2m9 |
| v_lf6gg,m_jd2m9 | v_lf6gg | Alice JAPAN m_jd2m9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE video_maker ( v_uid TEXT NOT NULL REFERENCES videos(uid) ON DELETE CASCADE, m_uid TEXT NOT NULL REFERENCES makers(uid) ON DELETE CASCADE, PRIMARY KEY (v_uid, m_uid) ); CREATE INDEX idx_video_maker_m ON video_maker(m_uid);