home / pf

reviews_albums

6 rows where review_id = 10037

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id album_id
10475 10475 Catalog 10037 10475 10475
10476 10476 Catalog 10037 10476 10476
10477 10477 Catalog 10037 10477 10477
10478 10478 Catalog 10037 10478 10478
10479 10479 Catalog 10037 10479 10479
10480 10480 Catalog 10037 10480 10480

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.551ms