seb pre-project

Tables (3)

Answer (answer)

  • id (answer_id) — Primary key — NOT NULL
  • id (question_id) — Foreign key → Question.id — NOT NULL
  • id (member_id) — Foreign key → Member.id — NOT NULL
  • 본문 (content)
  • 작성일자 (created_at)

Member (member)

  • id (member_id) — Primary key — NOT NULL
  • 이메일 (email)
  • 이름 (name)
  • 비밀번호 (password)
  • 가입날짜 (created_at)

Question (question)

  • id (question_id) — Primary key — NOT NULL
  • id (member_id2) — Foreign key → Member.id — NOT NULL
  • 제목 (title)
  • 본문 (content)
  • 작성일자 (created_at)
  • 수정일자 (modified_at)