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