home / pf

reviews_albums

5 rows where review_id = 7703

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
7998 7998 Origami 7703 7998 7998
7999 7999 Origami 7703 7999 7999
8000 8000 Origami 7703 8000 8000
8001 8001 Origami 7703 8001 8001
8002 8002 Origami 7703 8002 8002

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