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