|
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 |
|