temp진우석

테이블 (3)

question_options

  • option_id — BIGINT
  • question_id — BIGINT — NOT NULL
  • option_text — VARCHAR(500) — NOT NULL
  • option_order — INT — NOT NULL

survey_questions

  • question_id — BIGINT
  • survey_id — BIGINT — NOT NULL
  • question_title — VARCHAR(500) — NOT NULL
  • question_type — ENUM('주관식', '객관식(다중선택)'
  • 객관식(단일선택)) — NOT — NOT NULL
  • question_order — INT — NOT NULL
  • is_required — BOOLEAN
  • created_at — TIMESTAMP

surveys

  • survey_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • subtitle — VARCHAR(500)
  • content — TEXT
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_active — BOOLEAN
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP