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

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
2508279929 Mind of My Mind 116254 rixx 41972609 3 I liked **Mind of My Mind** by *Octavia Butler* – to me it was the most interesting part of the **Patternmaster** series so far. It explores how, within our society as it exists today, the Patternist community came to exist, and soon dominated life everywhere. It's exactly the bit of backstory I was missing. That said, I didn't feel particularly attached to any of the characters. I think this was due to the rushed feeling – by skipping large intervals of time, we get told about important character and group developments, instead of being shown, which is unfortunate: with more space and exploration, this would have made an outstanding book. 2018-08-26T13:36:55-07:00 2020-02-23T12:15:25-08:00 2018-10-06  

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