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

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
1627907727 A Wizard Alone 116560 rixx 41972609 4 This one was again much better, and illustrates a lot of the reasons I enjoy this series. I love how Duane deals with autism here, in many ways. I love how she takes care to take it seriously, and doesn't paint it as a defect. Kit has difficulty connecting with it because of his preconceived ideas about how autism works. <br />I also like that we see how we see Nita's grieving in a really realistic way, without pity or anything. 2016-05-03T09:10:55-07:00 2016-05-14T01:06:25-07:00 2016-05-12T00:00:00-07:00 2016-05-11T00:00:00-07: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);