ㅁㄴㅇㄹ

Tables (6)

account

  • idx — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • pw — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

lecture

  • idx — BIGINT — Primary key — NOT NULL
  • owner_idx — BIGINT — Foreign key → account.idx — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • youtube_pl_url — VARCHAR(500) — NOT NULL
  • youtube_pl_id — VARCHAR(100) — NOT NULL
  • video_count — INT — NOT NULL
  • last_synced_at — DATETIME
  • youtube_pl_etag — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

lecture_progress

  • idx — BIGINT — Primary key — NOT NULL
  • account_idx — BIGINT — Foreign key → account.idx — NOT NULL
  • lecture_idx — BIGINT — Foreign key → lecture.idx — NOT NULL
  • video_idx — BIGINT — Foreign key → video.idx — NOT NULL
  • last_position_s — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL

study_group

  • idx — BIGINT — Primary key — NOT NULL
  • owner_idx — BIGINT — Foreign key → account.idx — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • is_public — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

study_group_member

  • idx — BIGINT — Primary key — NOT NULL
  • group_idx — BIGINT — Foreign key → study_group.idx — NOT NULL
  • member_idx — BIGINT — Foreign key → account.idx — NOT NULL
  • created_at — DATETIME — NOT NULL

video

  • idx — BIGINT — Primary key — NOT NULL
  • lecture_idx — BIGINT — Foreign key → lecture.idx — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • youtube_id — VARCHAR(100) — NOT NULL
  • youtube_url — VARCHAR(500) — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • duration_sec — INT
  • position — INT — NOT NULL
  • youtube_item_id — VARCHAR(100)
  • channel_title — VARCHAR(200)
  • published_at — DATETIME
  • is_available — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL