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 = 11713

View and edit SQL

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

id ▼ book_id user_id rating text date_added date_updated read_at started_at
3056273139 The English Patient 11713 rixx 41972609 2 **The English Patient** by *Michael Ondaatje* is a lyrical, slow, pain-ridden book about the trauma and separation and surreal life of people in and after WW2. It's not really my kind of book, but it wasn't an unpleasant read, either. 2019-11-20T13:13:51-08:00 2020-02-23T11:04:57-08:00 2019-11-20  

Advanced export

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

CSV options:

CREATE TABLE [reviews] (
   [id] TEXT PRIMARY KEY,
   [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);