video_category
10 rows where c_uid = "c_dj6wh"
This data as json, CSV (advanced)
| Link | v_uid | c_uid |
|---|---|---|
| v_4ywak,c_dj6wh | v_4ywak | POV c_dj6wh |
| v_6feds,c_dj6wh | v_6feds | POV c_dj6wh |
| v_b539f,c_dj6wh | v_b539f | POV c_dj6wh |
| v_c7nvo,c_dj6wh | v_c7nvo | POV c_dj6wh |
| v_egcan,c_dj6wh | v_egcan | POV c_dj6wh |
| v_h3g4t,c_dj6wh | v_h3g4t | POV c_dj6wh |
| v_i0zf8,c_dj6wh | v_i0zf8 | POV c_dj6wh |
| v_l128r,c_dj6wh | v_l128r | POV c_dj6wh |
| v_pau28,c_dj6wh | v_pau28 | POV c_dj6wh |
| v_r9w9c,c_dj6wh | v_r9w9c | POV c_dj6wh |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE video_category ( v_uid TEXT NOT NULL REFERENCES videos(uid) ON DELETE CASCADE, c_uid TEXT NOT NULL REFERENCES categories(uid) ON DELETE CASCADE, PRIMARY KEY (v_uid, c_uid) ); CREATE INDEX idx_video_category_c ON video_category(c_uid);