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