reviews_authors

5 rows where author_id = 152

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
492 492 <em>Formentera</em> 492 Austin Brown 152
1152 1152 <em>A Way Forward</em> 1152 Austin Brown 152
1167 1167 <em>Lee “Scratch” Perry’s Guide to the Universe</em> 1167 Austin Brown 152
4545 4545 <em>MihTy</em> 4545 Austin Brown 152
5239 5239 <em>ruiner</em> 5239 Austin Brown 152

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE reviews_authors (
	review_id integer NOT NULL,
	author_id integer NOT NULL,
	FOREIGN KEY(review_id) REFERENCES reviews(id),
	FOREIGN KEY(author_id) REFERENCES authors(id),
	UNIQUE(review_id,author_id)
);