퀴즈릭스

테이블 (9)

Untitled (keyword)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar — NOT NULL — unique

Untitled (course)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (category_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (description) — text — NOT NULL — markdown
  • Field (price) — int — NOT NULL
  • Field (is_free) — boolean — NOT NULL
  • Field (thumbnail_url) — varchar — NOT NULL
  • Field (view_count) — int — NOT NULL
  • Field (lecture_count) — int — NOT NULL
  • Field (workbook_count) — int — NOT NULL
  • Field (recommendation_count) — int — NOT NULL
  • Field (created_dt) — date — NOT NULL
  • Field (updated_dt) — date — NOT NULL
  • Field (deleted_dt) — date

Untitled (course_keyword)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (course_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — unique constraint (course_id, keyword_id)
  • Key (keyword_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (order) — int — NOT NULL

Untitled (workbook)

  • Key (id) — bigint — 기본 키 — NOT NULL

Untitled (course_material)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (course_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (workbook_id) — bigint — 외래 키 → Untitled.Key — unique constraint (couse_id, workbook_id)
  • Key (lecture_id) — bigint — 외래 키 → Untitled.Key — unique constraint (couse_id, lecture_id)
  • Field (order) — int — NOT NULL
  • Field (created_dt) — date — NOT NULL
  • Field (updated_dt) — date — NOT NULL

Untitled (lecture)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (description)
  • Field (lecture_url)

Untitled (category)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (parent_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varchar — NOT NULL — unique constraint (parent_id, name)
  • Field (course_count) — int — NOT NULL

Untitled (user)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (username) — varchar — NOT NULL
  • Field (email) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • Field (register_dt) — date — NOT NULL

Untitled (course_recommendation)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — unique constraint (user_id, course_id)
  • Key (course_id) — bigint — 외래 키 → Untitled.Key — NOT NULL