reviews_albums

8 rows where review_id = 12097

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
12624 12624 Blur 21 12097 12624 12624
12625 12625 Blur 21 12097 12625 12625
12626 12626 Blur 21 12097 12626 12626
12627 12627 Blur 21 12097 12627 12627
12628 12628 Blur 21 12097 12628 12628
12629 12629 Blur 21 12097 12629 12629
12630 12630 Blur 21 12097 12630 12630
12631 12631 Blur 21 12097 12631 12631

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