home / pf

reviews_albums

7 rows where review_id = 7577

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
7851 7851 It Came From N.Y.C. 7577 7851 7851
7852 7852 It Came From N.Y.C. 7577 7852 7852
7853 7853 It Came From N.Y.C. 7577 7853 7853
7854 7854 It Came From N.Y.C. 7577 7854 7854
7855 7855 It Came From N.Y.C. 7577 7855 7855
7856 7856 It Came From N.Y.C. 7577 7856 7856
7857 7857 It Came From N.Y.C. 7577 7857 7857

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 9.706ms