reviews_albums

9 rows where review_id = 12887

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
13459 13459 The Smiths Complete 12887 13459 13459
13460 13460 The Smiths Complete 12887 13460 13460
13461 13461 The Smiths Complete 12887 13461 13461
13462 13462 The Smiths Complete 12887 13462 13462
13463 13463 The Smiths Complete 12887 13463 13463
13464 13464 The Smiths Complete 12887 13464 13464
13465 13465 The Smiths Complete 12887 13465 13465
13466 13466 The Smiths Complete 12887 13466 13466
13467 13467 The Smiths Complete 12887 13467 13467

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);