PrestackOverflow

Tables (6)

answer

  • answer_id — BIGING — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → question.question_id — NOT NULL
  • member_id — BiGINT — Foreign key → member.member_id — NOT NULL
  • content — VARCHAR

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • answer_id — BIGING — Foreign key → answer.answer_id — NOT NULL
  • content — VARCHAR

like

  • answer_id — BIGING — Foreign key → answer.answer_id — NOT NULL
  • member_id — BiGINT — Foreign key → member.member_id — NOT NULL

member

  • member_id — BiGINT — Primary key — NOT NULL
  • username — VARCHAR
  • password — VARCHAR

question

  • question_id — BIGINT — Primary key — NOT NULL
  • member_id — BiGINT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR
  • content — VARCHAR

tag

  • tag_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → question.question_id — NOT NULL
  • tag_name — VARCHAR