ss

Tables (6)

Book

  • id — BIGINT — Primary key
  • isbnId — VARCHAR(255) — NOT NULL
  • authorName — VARCHAR(255)
  • name — VARCHAR(255)
  • likes — BIGINT

Likes

  • id — BIGINT — Primary key
  • member_id — BIGINT
  • book_id — BIGINT

Quiz

  • id — BIGINT
  • question — LONGTEXT
  • optionList — JSON — NOT NULL
  • answer — INT
  • comment — LONGTEXT — ONGTEX
  • quizList_id — BIGINT
  • submitCount — INT
  • correctCount — INT

QuizList

  • id — BIGINT
  • book_id — BIGINT

QuizSubmit

  • id — BIGINT
  • member_id — BIGINT
  • quizList_id — BIGINT
  • submitAnswerList — JSON — NOT NULL
  • score — DOUBLE

Scene

  • id — BIGINT
  • book_id — BIGINT
  • photoId — VARCHAR(255)
  • description — VARCHAR(255)
  • plotSummary — LONGTEXT