Reading Log

schema.sql 16 lines

CREATE TABLE books (
  book_id INTEGER PRIMARY KEY,
  title TEXT NOT NULL,
  author TEXT NOT NULL,
  isbn TEXT NOT NULL DEFAULT '',
  isbn13 TEXT NOT NULL DEFAULT '',
  my_rating INTEGER NOT NULL DEFAULT 0 CHECK (my_rating BETWEEN 0 AND 5),
  average_rating REAL NOT NULL DEFAULT 0 CHECK (average_rating BETWEEN 0 AND 5),
  number_of_pages INTEGER CHECK (number_of_pages >= 0),
  date_read TEXT NOT NULL DEFAULT '',
  date_added TEXT NOT NULL DEFAULT '',
  bookshelves TEXT NOT NULL DEFAULT '',
  exclusive_shelf TEXT NOT NULL DEFAULT 'to-read' CHECK (exclusive_shelf IN ('to-read', 'currently-reading', 'read')),
  my_review TEXT NOT NULL DEFAULT '',
  read_count INTEGER NOT NULL DEFAULT 0 CHECK (read_count >= 0)
);