survey
Tables (7)
Servey (설문)
- servey_idx (PRIMARY KEY) — Primary key — NOT NULL
- user_idx (PRIMARY KEY2) — 작성자 — Foreign key → fusion_user.user_idx — NOT NULL
- servey_name (Field4)
- servey_host (Field5) — 주최
- start_at (Field)
- last_at (Field2)
- winning_at (Field3)
Servey_result (결과)
- question_content (PRIMARY KEY) — Foreign key → question.question_idx — NOT NULL
- question_title_idx (PRIMARY KEY2) — Foreign key → question.question_title_idx — NOT NULL
- user_idx (Field)
common_question (공통문항)
- question_idx (PRIMARY KEY) — Primary key — NOT NULL
- content (Field)
- rank (Field2)
fusion_user (사용자)
- user_idx (PRIMARY KEY) — Primary key — NOT NULL
question (문항)
- question_idx (PRIMARY KEY) — Primary key — NOT NULL
- question_title_idx (PRIMARY KEY2) — Foreign key → question_title.question_title_idx — NOT NULL
- content (Field)
- rank (Field2)
question_title (제목)
- question_title_idx (PRIMARY KEY) — Primary key — NOT NULL
- servey_idx (PRIMARY KEY2) — Foreign key → Servey.servey_idx — NOT NULL
- servey_high_idx (Field8)
- title (Field)
- category (Field2)
- select_count (Field3)
- essential_flag (Field4)
- common_flag (Field5)
- subjective_flag (Field6)
success_result (Untitled)
- user_idx (PRIMARY KEY) — Foreign key → fusion_user.user_idx — NOT NULL
- servey_idx (PRIMARY KEY2) — Foreign key → Servey.servey_idx — NOT NULL
- created_at (DATE)
- updated_at (Field)