search

JoeyAlvarez / Vote

0 stars 0 forks source link

Add in Users! #4

Open JoeyAlvarez opened 2 weeks ago

JoeyAlvarez commented 2 weeks ago

Create a users table (may be able to reuse voters???). It should have a user_id, name, email(optional),rec_by(who created the user by id),rec_dt(default to getdate()).

Add a rec_by to the Vote table. Add a rec_by to the ballots table, and a voter to the ballots table (if it doesn't exist).

Antnknee commented 2 weeks ago

I was able to create user table with the given parameters. When edits were made to Vote table I was unable to change it due to table having to be dropped and then recreated.