퀴즈릭스
테이블 (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