Create schema for tables of data

[lmullen]

Since we are close to having our first real finished data, we should think about how exactly the data will be normalized into tables. Here is a start:

1. County vote table (candidate ID, candidate name, election ID, vote, county, state, county ID, district?)
2. District vote table (candidate ID, candidate name, election ID, vote, state, district, district ID)
3. Town vote table (candidate ID, candidate name, election ID, vote, state, district, town, town ID)
4. Candidate table (candidate name, candidate ID, candidate bio)
5. Election table (election ID, office, year, role, etc.). Perhaps a further table with elections with multiple votes.
6. County spatial data (county ID, spatial data)
7. District spatial data (district ID, spatial data)
8. Town spatial data (town ID, spatial data)