제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