Schema

users

Column	Type
user_id	int
user_email	varchar(255)
user_name	varchar(255)
user_password	varchar(255)

user_election_mapping

Column	Type
user_id	int
election_id	int
voted	bit

elections

Column	Type
election_id	int
election_name	varchar(255)
election_startdate	datetime
election_enddate	datetime
election_description	varchar(8192)

candidates

Column	Type
election_id	int
candidate_id	int
candidate_name	varchar(255)
candidate_description	varchar(255)
candidate_photo	binary
candidate_rank	int

votes

Column	Type
election_id	int
user_id	int
candidate_id	int
rank	int