404wefound_2

Tables (6)

Answer

  • answerId — BIGINT
  • questionId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

AnswerComment

  • answerCommentId — BIGINT
  • answerId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

Comment

  • commentId — BIGINT
  • questionId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL

Point

  • pointId — BIGINT
  • userId — BIGINT — NOT NULL
  • point — BIGINT
  • reason — VARCHAR(255)
  • createdAt — DATETIME — NOT NULL

Question

  • questionId — BIGINT
  • userId — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL

User

  • userId — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • grade — VARCHAR(20)
  • point — BIGINT
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME — NOT NULL