reviews_albums
6 rows where review_id = 12082
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | album_id |
|---|---|---|---|
| 12603 | 12603 | A Dot in Time 12082 | 12603 12603 |
| 12604 | 12604 | A Dot in Time 12082 | 12604 12604 |
| 12605 | 12605 | A Dot in Time 12082 | 12605 12605 |
| 12606 | 12606 | A Dot in Time 12082 | 12606 12606 |
| 12607 | 12607 | A Dot in Time 12082 | 12607 12607 |
| 12608 | 12608 | A Dot in Time 12082 | 12608 12608 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE reviews_albums ( review_id integer NOT NULL, album_id integer NOT NULL, FOREIGN KEY(review_id) REFERENCES reviews(id), FOREIGN KEY(album_id) REFERENCES albums(id), UNIQUE(review_id, album_id) );