제9회 부산 ICT융합 해커톤
테이블 (5)
Untitled (user)
- Key (id) — serial — 기본 키 — NOT NULL
- Field (email) — varchar(255)
- Field (password) — varchar(255)
- Field2 (name) — varchar(255)
Untitled (subject)
- Key (id) — serial — 기본 키 — NOT NULL
- Key (user_id) — integer — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — varchar(255)
- Field (text) — text
Untitled (chapter)
- Key (id) — serial — 기본 키 — NOT NULL
- Key (subject_id) — serial — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — varchar(255)
- Field (content) — text
Untitled (problem)
- Key (id) — serial — 기본 키 — NOT NULL
- Key (quiz_id) — integer — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — text
- Field (question) — text
- Field (feedback) — text
- Field2 (solution) — text
- Field (user_answer) — text
- Field (is_correct) — boolean
Untitled (quiz)
- Key (id) — serial — 기본 키 — NOT NULL
- Key (chapter_id) — integer — 외래 키 → Untitled.Key — NOT NULL
- Field (total_count) — integer
- Field (submit_count) — integer
- Field (correct_count) — integer