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`