reviews_authors

5 rows where author_id = 198

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1044 1044 <em>Wandering</em> 1044 Drew Litowitz 198
1093 1093 <em>All These Years</em> 1093 Drew Litowitz 198
1171 1171 <em>Rhinestones</em> 1171 Drew Litowitz 198
1537 1537 <em>A Color of the Sky</em> 1537 Drew Litowitz 198
2042 2042 <em>Cheater</em> 2042 Drew Litowitz 198

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)
);