Voting Service

Tables (5)

Candidate (Untitled6)

  • candidateId (candidated_id) — Bigint — Primary key — NOT NULL
  • cname — varchar(255)
  • part — varchar(255)
  • count — int

CandidateVote (Untitled3)

  • cvId (cv_id) — Bigint — Primary key — NOT NULL
  • userId (user_id) — Bigint — Foreign key → User.userId — NOT NULL
  • cname — varchar(255)

DemoVote (Untitled2)

  • dvId (dv_id) — Bigint — Primary key — NOT NULL
  • userId (user_id) — Bigint — Foreign key → User.userId — NOT NULL
  • tname — varchar(255)

Team (Untitled4)

  • teamId (team_id) — Bigint — Primary key — NOT NULL
  • tname — varcher(255)
  • count — int

User (Untitled)

  • userId (user_id) — Bigint — Primary key — NOT NULL
  • loginId (login_id) — varchar(255)
  • password — varchar(255)
  • email — varchar(255)
  • name — varchar(255)
  • team — varchar(255)
  • part — varchar(255)
  • isDemoVoted (is_demo_voted) — Enum
  • isCandiVoted (is_candi_voted) — Enum