404wefound

Tables (6)

answer

  • answer_id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • question_id (question_id2) — BIGINT — Foreign key → question.question_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL

answer_comment

  • answer_comment_id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • answer_id (answer_id2) — BIGINT — Foreign key → answer.answer_id — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at (Field) — TIMESTAMP — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
  • question_id (question_id2) — BIGINT — Foreign key → question.question_id — NOT NULL

points

  • point_id — BIGINT — Primary key — NOT NULL
  • point — BIGINT — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL

question

  • question_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • grade — VARCHAR(255) — NOT NULL
  • point — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL