boatvote

Tables (3)

User (Untitled)

  • user_id (유저 아이디) — notnull — Primary key — NOT NULL
  • Field

VoteInfo (Untitled2)

  • vote_id (설문조사 번호) — @GeneratedValue — Primary key — NOT NULL
  • user_id (유저 아이디) — notnull — Foreign key → User.user_id — NOT NULL
  • vote_description (설문조사 설명) — notnull
  • category (카테고리)
  • count (설문대상 인원)
  • duration (설문 기간)
  • age (연령대)
  • gender (성별)
  • Field

VoteQuestion (Untitled3)

  • question_number (질문 번호) — Primary key — NOT NULL
  • vote_id (설문조사 번호) — @GeneratedValue — Foreign key → VoteInfo.vote_id — NOT NULL
  • user_id (유저 아이디) — notnull — Foreign key → VoteInfo.user_id — NOT NULL
  • multiple_short (객관식or주관식)
  • Field