home / pf

reviews_albums

8 rows where review_id = 9432

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
9836 9836 Start Together 9432 9836 9836
9837 9837 Start Together 9432 9837 9837
9838 9838 Start Together 9432 9838 9838
9839 9839 Start Together 9432 9839 9839
9840 9840 Start Together 9432 9840 9840
9841 9841 Start Together 9432 9841 9841
9842 9842 Start Together 9432 9842 9842
9843 9843 Start Together 9432 9843 9843

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)
);
Powered by Datasette · Queries took 10.271ms