Devoot

Tables (19)

admin

  • id — INT — Primary key — NOT NULL
  • userId — BIGINT — NOT NULL
  • createdAt — DATE — NOT NULL

bookmark

  • id — BIGINT — Primary key — NOT NULL
  • lectureId — BIGINT — NOT NULL
  • nextId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • status — TINYINT — NOT NULL
  • INDEX — `idx_userId`
  • INDEX — `idx_lectureId`
  • INDEX — `idx_nextId`

bookmarkLog

  • id — BIGINT — Primary key — NOT NULL
  • bookmarkId — BIGINT — NOT NULL
  • lectureId — BIGINT — NOT NULL
  • beforeStatus — TINYINT
  • afterStatus — TINYINT
  • INDEX — `idx_lecture_id`

category

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(20) — NOT NULL

errorLog

  • id — INT — Primary key — NOT NULL
  • content — VARCHAR(1000)
  • createdAt — TIMESTAMP — NOT NULL

follow

  • id — BIGINT — Primary key — NOT NULL
  • followerId — BIGINT — NOT NULL
  • followedId — BIGINT
  • allowed — BOOLEAN
  • INDEX — `idx_follower_id`
  • INDEX — `idx_followed_id`

lecture

  • id — BIGINT — Primary key — NOT NULL
  • category — VARCHAR(32) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • lecturer — VARCHAR(100)
  • imageUrl — VARCHAR(2083)
  • originalPrice — INT — NOT NULL
  • currentPrice — INT — NOT NULL
  • curriculum — JSON
  • sourceUrl — VARCHAR(2083)
  • sourceName — VARCHAR(20)
  • tags — VARCHAR(100)
  • reviewCnt — INT — NOT NULL
  • ratingSum — FLOAT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updatedAt — TIMESTAMP — NOT NULL
  • hash — VARCHAR(100)
  • INDEX — `idx_category_id`
  • INDEX — `idx_hash`

lectureCreaterequest

  • id — INT — Primary key — NOT NULL
  • sourceUrl — VARCHAR(2083)
  • createdAt — TIMESTAMP — NOT NULL
  • INDEX — `idx_source_url`

lectureReport

  • id — INT — Primary key — NOT NULL
  • userId — BIGINT — NOT NULL
  • lectureId — BIGINT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • INDEX — `idx_lecture_id`

lectureReview

  • id — BIGINT — Primary key — NOT NULL
  • lectureId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • rating — FLOAT(2,1) — NOT NULL
  • content — VARCHAR(500)
  • createdAt — TIMESTAMP — NOT NULL
  • INDEX — `idx_userId`
  • INDEX — `idx_lectureId`

lectureReviewReport

  • id — INT — Primary key — NOT NULL
  • userId — BIGINT — NOT NULL
  • lectureReviewId — BIGINT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • INDEX — `idx_lecture_review_id`

lectureUpdateRequest

  • id — INT — Primary key — NOT NULL
  • lectureId — BIGINT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL

notification

  • id — BIGINT — Primary key — NOT NULL
  • toUserId — BIGINT — NOT NULL
  • fromUserId — BIGINT — NOT NULL
  • followId — BIGINT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • hasRead — BOOLEAN
  • INDEX — `idx_to_user_id`
  • INDEX — `idx_follow_id`
  • INDEX — `idx_from_user_id`

tag

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(20)

timelineLog

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • entityType — VARCHAR(20) — NOT NULL
  • INDEX — `idx_user_created`

todo

  • id — BIGINT — Primary key — NOT NULL
  • userId — BIGINT — NOT NULL
  • lectureId — BIGINT — NOT NULL
  • date — DATE
  • lectureName — VARCHAR(100) — NOT NULL
  • subLectureName — VARCHAR(150) — NOT NULL
  • sourceUrl — VARCHAR(2083)
  • finished — BOOLEAN
  • nextId — BIGINT
  • INDEX — `idx_user_id`
  • INDEX — `idx_lecture_id`
  • INDEX — `idx_next_id`

todoContribution

  • id — BIGINT — Primary key — NOT NULL
  • userId — bigint — NOT NULL
  • cnt — tinyint
  • date — DATE
  • INDEX — `idx_user_id`

todoLog

  • id — BIGINT — Primary key — NOT NULL
  • todoId — BIGINT — NOT NULL
  • INDEX — `idx_todo_id`

user

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • profileId — VARCHAR(15)
  • nickname — VARCHAR(18)
  • links — JSON
  • isPublic — BOOLEAN
  • imageUrl — VARCHAR(200)
  • uid — VARCHAR(128)
  • tags — VARCHAR(100)
  • createdAt — TIMESTAMP — NOT NULL
  • isBlocked — BOOLEAN
  • INDEX — `idx_profileid`
  • INDEX — `idx_nickname`