qeustion

Tables (3)

answer_results

  • id — int(11) — Primary key — NOT NULL
  • question_id — int(11) — Foreign key → questions.id — NOT NULL
  • answer_id — int(11) — Foreign key → answers.id
  • respondent_id — int(11)
  • answered_at — timestamp
  • answer_type — enum('multiple_choice','text') — NOT NULL
  • answer_text — text

answers

  • id — int(11) — Primary key — NOT NULL
  • question_id — int(11) — Foreign key → questions.id — NOT NULL
  • answer_text — text — NOT NULL
  • created_at — timestamp

questions

  • id — int(11) — Primary key — NOT NULL — 질문 아이디
  • question_text — text — NOT NULL — 질문 문항
  • created_at — timestamp — 생성일