Database tables - madsilva/fswe-project GitHub Wiki

Tables in our database All fields are varchar unless otherwise specified.

candiate

• candidate_id
• firstname
• lastname
• party
• precinct
• election_id
• position
• votes

election

• election_type
• state
• election_id
• start_date
• end_date
• precinct_id

login_data

• username
• password
• firstname
• lastname
• privilege
• reset_token

precinct

• precinct_id
• zip
• state

state_geography

• state
• zip
• country
• city

voter_registration

• username
• address
• city
• state
• zip_code
• date_of_birth
• social_security
• id_number
• approved
• gender
• party
• election_voted_in

security_questions

• pet
• city
• school

ballots

• precinct
• election_id