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