Reviews are the m:n mapping table between books and shelves. This means books that are just on your to-read shelf still have a review, connecting the book with your shelf. I don't make the rules.

1 row where book_id = 8909 sorted by date_updated

View and edit SQL

Suggested facets: date_added (date), date_updated (date), read_at (date), started_at (date)

id book_id user_id rating text date_added date_updated ▼ read_at started_at
1249277642 The War of the Worlds 8909 rixx 41972609 4 I see why this is a classic - it has aged reasonably well, and seems to have given birth to many tropes and images we perceive as common ans well-known. I liked reading it, even if it was a bit stuffy. 2015-04-08T06:52:40-07:00 2017-02-01T01:57:35-08:00 2017-02-01T01:57:35-08:00 2017-01-28T00:00:00-08:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [reviews] (
   [book_id] TEXT REFERENCES [books]([id]),
   [user_id] TEXT REFERENCES [users]([id]),
   [rating] TEXT,
   [text] TEXT,
   [date_added] TEXT,
   [date_updated] TEXT
, [read_at] TEXT, [started_at] TEXT);