SejongClass
Tables (16)
Untitled (checklists)
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- standard_id (curriculum_id) — SERIAL — Foreign key → curriculum_standards.standard_id
- Field (completion_status) — BOOLEAN — NOT NULL
- Field (updated_at) — TIMESTAMP
Untitled (Comments)
- Key (commet_id) — SERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- unit_id — SERIAL — Foreign key → units.unit_id — NOT NULL
- Key (parentId) — Foreign key → Untitled.Key — NOT NULL
- Field (contents)
Untitled (likes)
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- Key (commet_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (visitlogs)
- Key (visitlogs_id) — SERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- Field (updated_at) — TIMESTAMP — NOT NULL
Untitled (notifications)
- Key (notification_id) — Primary key — NOT NULL
- Field (to_unit_URL) — varchar
- Key (commet_id) — SERIAL — Foreign key → Untitled.Key — NOT NULL
- user_id (from_user_id) — UUID — Foreign key → users.user_id — NOT NULL
- user_id (to_user_id) — UUID — Foreign key → users.user_id — NOT NULL
- Field2 (is_checked)
Untitled (payments)
- Key (paymentskey) — Primary key — NOT NULL
- user_id — UUID — Foreign key → user_textbook_enrollments.user_id — NOT NULL
- textbook_id — SERIAL — Foreign key → user_textbook_enrollments.textbook_id — NOT NULL
curriculum_standards (curriculums)
- standard_id (curriculum_id) — SERIAL — Primary key
- code — VARCHAR(20) — NOT NULL
- achievement_text — TEXT — NOT NULL
- sort_order — INTEGER — NOT NULL
- unit_id — SERIAL — Foreign key → units.unit_id
major_chapters (majors)
- major_chapter_id (major_id) — SERIAL — Primary key — NOT NULL
- textbook_id — SERIAL — Foreign key → textbooks.textbook_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- sort_order — INTEGER
- created_at (is_published) — Boolean — NOT NULL
middle_chapters (middles)
- middle_chapter_id (middle_id) — SERIAL — Primary key — NOT NULL
- major_chapter_id (major_id) — SERIAL — Foreign key → major_chapters.major_chapter_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- sort_order — INTEGER
- created_at (is_published) — Boolean — NOT NULL
progress
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- unit_id — SERIAL — Foreign key → units.unit_id — NOT NULL
- completion_status — BOOLEAN — NOT NULL
- updated_at — TIMESTAMP
subjects
- subject_id (subjects_id) — SERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- slug — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- Field (emoji) — VARCHAR(100) — NOT NULL
- sort_order — SMALLINT — NOT NULL
- theme_id (themes_id) — SERIAL — Foreign key → themes.theme_id — NOT NULL
textbooks
- textbook_id — SERIAL — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- slug — VARCHAR(100) — NOT NULL
- price — INTEGER — NOT NULL
- is_published — BOOLEAN — NOT NULL
- sort_order — SMALLINT — NOT NULL
- description (when_opened) — VARCHAR(100) — NOT NULL
- cover_image_url — VARCHAR(500)
- Field (estimated_hours) — SMALLINT
- Field (youtube_video_id) — VARCHAR(20)
- Field (enrolled_students) — SMALLINT — NOT NULL
- Field (average_rating) — SMALLINT — NOT NULL
- subject_id (subjects_id) — SERIAL — Foreign key → subjects.subject_id — NOT NULL
themes
- theme_id (themes_id) — SERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- slug — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- sort_order — SAMLLINT — NOT NULL
- icon_url (class_name) — VARCHAR(200) — NOT NULL
- Field (hover) — VARCHAR(200) — NOT NULL
units
- unit_id — SERIAL — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- youtube_video_id — VARCHAR(20)
- readme_content — VARCHAR(4000)
- Field (readme_json) — Json
- estimated_duration (estimated_seconds) — SMALLINT
- sort_order — INTEGER — NOT NULL
- is_published — BOOLEAN — NOT NULL
- Field (is_free) — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- middle_chapter_id (middle_id) — SERIAL — Foreign key → middle_chapters.middle_chapter_id — NOT NULL
user_textbook_enrollments (enrollments)
- user_id — UUID — Foreign key → users.user_id — NOT NULL
- textbook_id — SERIAL — Foreign key → textbooks.textbook_id — NOT NULL
- payment_status — BOOLEAN — NOT NULL
- progress_rate — SMALLINT — NOT NULL
- review — VARCHAR(500)
- rating — SMALLINT
- enrolled_at (created_at) — TIMESTAMP
- Field (last_study_date) — TIMESTAMP
- access_expires_at (updated_at) — TIMESTAMP
users
- user_id — UUID — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- Field (nickname) — VARCHAR(100) — NOT NULL
- role — Enum — NOT NULL
- profile_image_url (profile_url) — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP