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