ceosBEFE

Tables (5)

Candidate (파트장후보)

  • LeaderId (기본키) — int — Primary key — NOT NULL
  • name (이름) — varchar(20)
  • part (파트) — varchar(20)
  • vote_cnt (득표수) — int

Candidate_Vote (파트장투표)

  • leaderVoteId (기본키) — int — Primary key — NOT NULL
  • user_name (사용자 이름) — varchar(20)
  • candidate_id (후보기본키) — int — Foreign key → Candidate.LeaderId — NOT NULL
  • user_id (사용자 기본키) — int — Foreign key → User.userId — NOT NULL

Team (팀후보)

  • id (기본키) — int — Primary key — NOT NULL
  • team (팀이름) — varchar(20)
  • vote_cnt (투표횟수) — int

Team_Vote (팀투표)

  • id (기본키) — int — Primary key — NOT NULL
  • user_name (사용자 이름)
  • team_id (팀 기본키) — int — Foreign key → Team.id — NOT NULL
  • user_id (사용자 기본키) — int — Foreign key → User.userId — NOT NULL

User

  • userId (기본키) — int — Primary key — NOT NULL
  • ID (아이디) — varchar(20)
  • password (비밀번호) — varchar(20)
  • email (이메일) — varchar(20)
  • part (파트) — varchar(20)
  • name (이름) — varchar(20)
  • team (팀) — varchar(20)