QuizNews

Tables (4)

news

  • id (pri) — int — Primary key — NOT NULL
  • title (뉴스 제목) — varchar(20)
  • content (뉴스 본문) — varchar(255)
  • source (뉴스 출처) — varchar(20)
  • category (뉴스 카테고리) — int

quize

  • id (pri) — int — Primary key — NOT NULL
  • news_id (fk) — int — Foreign key → news.id — NOT NULL
  • question (퀴즈 질문) — varchar(50)
  • correct_answer (정답) — int
  • wrong_options (오답 리스트) — int

quize_result

  • id (pri) — int — Primary key — NOT NULL
  • quize_id (fk) — int — Foreign key → quize.id — NOT NULL
  • score (점수) — int — NOT NULL
  • completed_at (퀴즈 푼 날짜) — int — NOT NULL

user

  • id (pri) — int — Primary key — NOT NULL
  • user_id — varchar(20) — NOT NULL
  • password — varchar(20) — NOT NULL
  • email — varchar(20) — NOT NULL
  • 사용자 닉네임 (user_name) — varchar(20) — NOT NULL