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