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

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
1627907656 So You Want to Be a Wizard 116563 rixx 41972609 4 I really loved this book - it reminded me of Harry Potter, naturally, but better written and better thought-out. Magic actually has a system, people have motivations and actions have actual consequences.<br /><br />Nita and Kit are the most adorable protagonists, and very much to be taken seriously. Both human side-characters like Nita's sister Dairine and parents, and the Advisory wizards seem very real, none too perfect. Even the Lone Power is not completely evil.<br /><br />Duane also has a way with words that made me swoon and/or feel frission on several occasions. This is definitely a book to re-read and I'm now diving into the remainder of the series. 2016-05-03T09:10:51-07:00 2016-05-08T11:44:31-07:00 2016-05-05T00:00:00-07:00  

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