27

Tables (7)

Answer (answer)

  • Id (answer_id) — BIGINT — Primary key — NOT NULL
  • Id (question_id) — BIGINT — Foreign key → Question.Id — NOT NULL — FK
  • Id (member_id) — BIGINT — Foreign key → Member.Id — NOT NULL — FK
  • 본문 (content) — VARCHAR(5000) — NOT NULL
  • 생성일자 (created_at) — DATETIME — NOT NULL
  • 수정일자 (modified_at) — DATETIME — NOT NULL

Comment (comment)

  • Id (comment_id) — BIGINT — Primary key — NOT NULL
  • Id (member_id) — BIGINT — Foreign key → Member.Id — NOT NULL — FK
  • Id (question_id) — BIGINT — Foreign key → Question.Id — NOT NULL — FK
  • 본문 (content) — VARCHAR(1000) — NOT NULL
  • 생성일자 (created_at) — DATETIME — NOT NULL
  • 수정일자 (modified_at) — DATETIME — NOT NULL

Member (member)

  • Id (member_id) — BIGINT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(255) — NOT NULL
  • 닉네임 (nickname) — VARCHAR(255) — NOT NULL
  • 비밀번호 (password) — VARCHAR(255) — NOT NULL
  • 생성일자 (created_at) — DATETIME — NOT NULL
  • 수정일자 (modified_at) — DATETIME — NOT NULL
  • 자기소개_제목 (bio_title) — VARCHAR(255)
  • 자기소개_내용 (bio_content) — VARCHAR(1000)
  • 지역 (location) — VARCHAR(255)

Question (question)

  • Id (question_id) — BIGINT — Primary key — NOT NULL
  • Id (member_id) — BIGINT — Foreign key → Member.Id — NOT NULL — FK
  • 제목 (title) — VARCHAR(255) — NOT NULL
  • 본문 (content) — VARCHAR(5000) — NOT NULL
  • 생성일자 (created_at) — DATETIME — NOT NULL
  • 수정일자 (modified_at) — DATETIME — NOT NULL
  • 조회수 (views) — INT(8) — NOT NULL
  • 투표수 (vote_score) — INT(4) — NOT NULL

Question_Tag (question_tag)

  • Id (question_tag_id) — BIGINT — Primary key — NOT NULL
  • Id (question_id) — BIGINT — Foreign key → Question.Id — NOT NULL — FK
  • Id (tag_id) — BIGINT — Foreign key → Tag.Id — NOT NULL — FK

Tag (tag)

  • Id (tag_id) — BIGINT — Primary key — NOT NULL
  • 태그명 (tag_name) — VARCHAR(50) — NOT NULL
  • 태그 설명 (tag_description) — VARCHAR(500)

Vote (vote)

  • Id (vote_id) — BIGINT — Primary key — NOT NULL
  • Id (question_id) — BIGINT — Foreign key → Question.Id — NOT NULL — FK
  • Id (member_id) — BIGINT — Foreign key → Member.Id — NOT NULL — FK
  • 투표 타입 (vote_status) — VARCHAR(50)