survey
Tables (6)
Answer (응답 상세)
- answer_id — INT — Primary key — NOT NULL
- question_id — INT — Foreign key → Question.question_id — NOT NULL
- answer_text
- choice_id — INT — Foreign key → Choice.choice_id — NOT NULL
- response_id — INT — Foreign key → Response.response_id — NOT NULL
Choice (선택지)
- choice_id — INT — Primary key — NOT NULL
- choice_text — VARCHAR(100)
- question_id — INT — Foreign key → Question.question_id — NOT NULL
Question (질문)
- question_id — INT — Primary key — NOT NULL
- survey_id — INT — Foreign key → Survey.survey_id — NOT NULL
- question_text — VARCHAR(100)
- question_type — VARCHAR(20)
Response (응답)
- response_id — INT — Primary key — NOT NULL
- response_date — TIMESTAMP
- survey_id — INT — Foreign key → Survey.survey_id — NOT NULL
- user_id — INT — Foreign key → Survey.user_id — NOT NULL
Survey (설문조사)
- survey_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- title — VARCHAR(20)
- description — VARCHAR(100)
- created_date — TIMESTAMP
- expiration_date — TIMESTAMP
User (사용자)
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(20)
- email — VARCHAR(100)
- roler (role) — VARCHAR(20)
- registration_date — TIMESTAMP