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