OpenGallery
Tables (6)
Applicants (답변 목록)
- id (Key) — Primary key — NOT NULL
- survey_id (설문지id) — Foreign key → Survey.id — NOT NULL
- user_id (유저id) — Foreign key → User.id — NOT NULL
- created_at (Field4)
- updated_at (Field5)
Question (설문 문항)
- id (Key) — Primary key — NOT NULL
- survey_id (Key2) — Foreign key → Survey.id — NOT NULL
- question_text (질문)
- title (질문명)
- description (설명)
- Field5
- Field6
Reply (선택)
- id (Key) — Primary key — NOT NULL
- survey_id (Key22) — Foreign key → Question.survey_id — NOT NULL
- question_id (Key2) — Foreign key → Question.id — NOT NULL
- number (선택지 번호)
- value (선택지 값)
Results (결과)
- id (Key) — Primary key — NOT NULL
- survey_id (Key22) — Foreign key → Reply.survey_id — NOT NULL
- question_id (Key23) — Foreign key → Reply.question_id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
Survey (설문지 테이블)
- id (설문지id) — Primary key — NOT NULL
- title (제목)
- author (설문 생성자)
- description (설명)
- created_at (생성일)
- updated_at (수정일)
User (유저)
- id (Key) — Primary key — NOT NULL
- email (Field)
- nickname (Field2)
- pw (Field3)
- created_at (Field4)
- updated_at (Field5)