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)