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 = 18170143 sorted by text

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
2464108114 An Astronaut's Guide to Life on Earth 18170143 rixx 41972609 5 This book is just nice reading in every regard. You'll learn something about space. You'll learn about NASA and interntional space agency relations. You'll learn about Chris Hadfield's life on earth and in space. It's a peculiar mix of his life story (or rather work story), and the more fundamental approaches that he learned on the way, and that allowed him to get where he got. There are lots of calls for humility, and preparedness, and perseverance, and empathy and helping others bear their loads. And at the same time, the book is completely light-hearted, and made me smile on a regular basis. It made my day better, and maybe it will help make me better, too. 2018-07-20T12:31:38-07:00 2018-08-26T13:52:12-07:00 2018-08-26  

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