pre

Tables (7)

Answer (답변)

  • Key (answer_id) — bigint — Primary key — NOT NULL
  • Key (question_id) — bigint — Foreign key → Question.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Member.Key — NOT NULL
  • Field (content) — String
  • Field3 (created_at) — date
  • Field4 (modified_at) — date

Answer_Comment (답변_댓글)

  • Key (answer_comment_id) — bigint — Primary key — NOT NULL
  • Key (answer_id) — bigint — Foreign key → Answer.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Member.Key — NOT NULL
  • Field (comment) — String
  • Field2 (created_at) — date
  • Field2 (modified_at) — date

Member (멤버)

  • Key (member_id) — bigint — Primary key — NOT NULL
  • Field (member_name) — String
  • Field2 (email) — String
  • Field (password) — String
  • Field (created_at) — date
  • Field2 (modified_at) — date

Question (질문)

  • Key (question_id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Member.Key — NOT NULL
  • Field (title) — String
  • Field2 (content) — String
  • Field (created_at) — date
  • Field (modified_at) — date

Question_Comment (질문_댓글)

  • Key (question_comment_id) — bigint — Primary key — NOT NULL
  • Key (question_id) — bigint — Foreign key → Question.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Member.Key — NOT NULL
  • Field (comment) — String
  • Field (created_at) — date
  • Field (modified_at) — date

Question_Tag (질문_태그)

  • Key (question_tag_id) — bigint — Primary key — NOT NULL
  • Key (question_id) — bigint — Foreign key → Question.Key — NOT NULL
  • Key (tag_id) — bigint — Foreign key → Tag.Key — NOT NULL

Tag (태그)

  • Key (tag_id) — bigint — Primary key — NOT NULL
  • Field (category) — String