Cozle

Tables (5)

Untitled (사용자)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (email) — VARCHAR(255)
  • Field2 (password) — VARCHAR(255)
  • Field3 (nickname) — VARCHAR(255)
  • Field4 (tier) — INT
  • Field (exp) — INT
  • Field2 (coin) — INT
  • Field3 (created_at) — DATETIME
  • Field (updated_at) — DATETIME

Untitled (퀴즈)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (content_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — VARCHAR(255)
  • Field (question) — TEXT
  • Field2 (quiz_type) — INT
  • Field3 (difficulty) — INT
  • Field4 (created_at) — DATETIME
  • Field (updated_at) — DATETIME

Untitled (퀴즈 옵션)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (quiz_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (option_text) — TEXT
  • Field2 (is_correct) — BOOLEAN

Untitled (학습 콘텐츠)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (title) — VARCHAR(255)
  • Field2 (body) — TEXT
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME

Untitled (퀴즈 제출)

  • Key — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (quiz_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (answer) — TEXT
  • Field2 (is_correct) — BOOLEAN
  • Field (earned_exp) — INT
  • Field (earned_coin) — INT
  • Field (created_at) — DATETIME
  • Field (updated_at) — DATETIME