404wefound_3

Tables (8)

answer_comments

  • answer_comment_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • answer_id — BIGINT — Foreign key → answers.answer_id
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

answer_liked_users

  • answer_id — BIGINT — Foreign key → answers.answer_id
  • user_id (liked_users) — BIGINT — Foreign key → users.user_id

answers

  • answer_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • question_id — BIGINT — Foreign key → questions.question_id
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

comments

  • comment_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • question_id — BIGINT — Foreign key → questions.question_id
  • content — TEXT — NOT NULL
  • create_at — DATETIME

points

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

premium_questions

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

questions

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

users

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