Classic_wave

Tables (8)

Book (Untitled)

  • 아이디 (ID) — BIGINT — Primary key — NOT NULL
  • 좋아요 (likes) — BIGINT
  • 작가 (author_name) — VARCHAR(255)
  • 책 이름 (name) — VARCHAR(255)
  • isbn_id — VARCHAR(255)

Member (Untitled4)

  • 아이디 (ID) — BIGINT — Primary key — NOT NULL
  • 로그인 ID (loginId) — VARCHAR(255)
  • 비밀번호 (password) — VARCHAR(255)

Quiz (Untitled6)

  • 아이디 (ID) — BIGINT — Primary key — NOT NULL
  • 퀴즈리스트 ID (quizlist_id) — BIGINT — Foreign key → QuizList.아이디 — NOT NULL
  • 질문 (question) — LONGTEXT
  • 정답 (answer) — INT
  • 보기 (optionList) — JSON
  • 정답 갯수 (correct_count) — INT

QuizHistory (Untitled2)

  • 아이디 (ID) — BIGINT — Primary key — NOT NULL
  • 퀴즈 ID (quiz_id) — BIGINT — Foreign key → Quiz.아이디 — NOT NULL
  • 맴버 ID (member_id) — BIGINT — Foreign key → Member.아이디 — NOT NULL
  • 점수 (score) — INT

QuizList (Untitled7)

  • 아이디 (ID) — BIGINT — Primary key — NOT NULL
  • 책 ID (book_id) — BIGINT — Foreign key → Book.아이디 — NOT NULL

QuizSubmit (Untitled5)

  • 아이디 (ID) — BIGINT — Primary key — NOT NULL
  • 맴버 Id (member_id) — BIGINT — Foreign key → Member.아이디 — NOT NULL
  • 퀴즈리스트 lD (quizlist_id) — BIGINT — Foreign key → QuizList.아이디 — NOT NULL

member_roles (Untitled8)

  • 맴버 ID (member_id) — BIGINT — Foreign key → Member.아이디 — NOT NULL
  • 권한 (roles) — varchar(255)

quiz_option_list (Untitled3)

  • 퀴즈 ID (quiz_id) — BIGINT — Foreign key → Quiz.아이디 — NOT NULL
  • 보기 리스트 (option_list) — JSON