main16

Tables (9)

Copy Of vote (report)

  • vote_id — bigint — Primary key — NOT NULL — PK
  • user_id — bigint — NOT NULL — FK
  • answer_id — bigint — NOT NULL — FK
  • question_id — bigint — NOT NULL — FK
  • amount (likeCnt) — int — -1, 1
  • created_at — datetime
  • updated_at — datetime
  • question_id (article_id) — bigint — Foreign key → question.question_id — NOT NULL — PK

answer

  • answer_id — bigint — Primary key — NOT NULL — PK
  • user_id — bigint — NOT NULL — FK
  • question_id — bigint — NOT NULL — FK
  • content — text
  • created_at — datetime
  • updated_at — datetime

comment

  • comment_id — bigint — Primary key — NOT NULL — PK
  • author_id — bigint — NOT NULL — FK
  • answer_id — bigint — NOT NULL — FK
  • question_id — bigint — NOT NULL — FK
  • content — text
  • createdAt — datetime
  • updatedAt — datetime

question (article)

  • question_id (article_id) — bigint — Primary key — NOT NULL — PK
  • author_id — bigint — NOT NULL — FK
  • title — varchar
  • content — text
  • clicks (views) — bigint
  • created_at — datetime
  • updated_at — datetime

question_tag

  • question_tag_id — bigint — Primary key — NOT NULL — PK
  • question_id — bigint — NOT NULL — FK, UNI
  • tag_id — bigint — NOT NULL — FK, UNI
  • created_at — datetime
  • updated_at — datetime

reputation

  • reputation_id — bigint — Primary key — NOT NULL — PK
  • user_id — bigint — NOT NULL — FK
  • vote_id — bigint — NOT NULL — FK
  • amount — int

tag

  • tag_id — bigint — Primary key — NOT NULL — PK
  • name — varchar — UNI
  • created_at — datetime
  • updated_at — datetime

user

  • user_id — bigint — Primary key — NOT NULL — PK
  • email — varchar — UNI
  • password — varchar
  • nickName — varchar
  • created_at — datetime
  • updated_at — datetime

vote

  • vote_id — bigint — Primary key — NOT NULL — PK
  • user_id — bigint — NOT NULL — FK
  • answer_id — bigint — NOT NULL — FK
  • question_id — bigint — NOT NULL — FK
  • amount (likeCnt) — int — -1, 1
  • created_at — datetime
  • updated_at — datetime
  • question_id (article_id) — bigint — Foreign key → question.question_id — NOT NULL — PK