book-ranker

Tables (4)

book

  • id — INT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • publisher — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL

book_rank

  • id — INT — Primary key — NOT NULL
  • book_rank — INT — NOT NULL
  • date_added — DATE — NOT NULL
  • book_id — INT — Foreign key → book.id — NOT NULL

contribute

  • id — INT — Primary key — NOT NULL
  • book_role — VARCHAR(255) — NOT NULL
  • person_id — INT — Foreign key → person.id — NOT NULL
  • book_id — INT — Foreign key → book.id — NOT NULL

person

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL