Crossnote
Tables (16)
Answer
- answerId — BIGINT
- questionId — BIGINT
- answererId — BIGINT
- content — TEXT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
BalanceGame
- gameId — BIGINT
- categoryId — BIGINT
- gameTitle — VARCHAR(255)
- questionText — VARCHAR(255)
- optionA — VARCHAR(255)
- optionB — VARCHAR(255)
- createdAt — TIMESTAMP
BalanceGameVote
- voteId — BIGINT
- gameId — BIGINT
- userId — BIGINT
- selectedOption — VARCHAR(255)
- createdAt — TIMESTAMP
Category
- categoryId — BIGINT
- name — VARCHAR(255)
- parentCategoryId — BIGINT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
Column
- columnId — BIGINT
- columnAuthorId — BIGINT
- categoryId — BIGINT
- title — VARCHAR(255)
- content — TEXT
- imageUrl — VARCHAR(255)
- likeCount — INT
- commentCount — INT
- scrapCount — INT
- isBestColumn — BOOLEAN
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
ColumnComment
- commentId — BIGINT
- columnId — BIGINT
- columnCommenterId — BIGINT
- content — TEXT
- parentCommentId — BIGINT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
Curation
- curationId — BIGINT
- categoryId — BIGINT
- crossCategoryId — BIGINT
- curationType — VARCHAR(255)
- sourceUrl — VARCHAR(255)
- imageUrl — VARCHAR(255)
- createdAt — TIMESTAMP
Follow
- followId — BIGINT
- followerId — BIGINT
- followingId — BIGINT
- createdAt — TIMESTAMP
KnowledgeReport
- reportId — BIGINT
- userId — BIGINT
- categoryId — BIGINT
- score — INT
- updatedAt — TIMESTAMP
Like
- likeId — BIGINT
- userId — BIGINT
- targetType — VARCHAR(255)
- targetId — BIGINT
- createdAt — TIMESTAMP
Notification
- notificationId — BIGINT
- recipientId — BIGINT
- actorId — BIGINT
- notificationType — VARCHAR(255)
- targetType — VARCHAR(255)
- targetId — BIGINT
- content — VARCHAR(255)
- isRead — BOOLEAN
- createdAt — TIMESTAMP
Question
- questionId — BIGINT
- questionerId — BIGINT
- title — VARCHAR(255)
- content — TEXT
- likeCount — INT
- isTodayQna — BOOLEAN
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
QuestionCategory
- questionCategoryId — BIGINT
- questionId — BIGINT
- categoryId — BIGINT
- createdAt — TIMESTAMP
Scrap
- scrapId — BIGINT
- userId — BIGINT
- targetType — VARCHAR(255)
- targetId — BIGINT
- createdAt — TIMESTAMP
User
- userId — BIGINT
- email — VARCHAR(255)
- password — VARCHAR(255)
- name — VARCHAR(255)
- birthDate — DATE
- profileImageUrl — VARCHAR(255)
- loginType — VARCHAR(255)
- curationLevel — INT
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
UserCategoryPreference
- preferenceId — BIGINT
- userId — BIGINT
- categoryId — BIGINT
- preferenceType — VARCHAR(255)
- createdAt — TIMESTAMP