Missing table inventory

[evz]

Things that we should get:

• District table (I'm guessing this is the district for which the candidate is running)
• County table
• Contact table (This is referred to from the Candidate and PAC tables so I'm guessing it's the contact person)
• Treasurer table (This is referred to from the PAC and Campaign tables so is probably the treasurer that is listed on the filings)
• Political Party table
• Address table
• A mysterious table that I think is probably just called Status. There are several tables which record some kind of status. This ranges from just "status" to "primary election winner status" and "transaction status". I'm not sure if all these values are stored in one table but that's what it seems like. If nothing else, it'd be nice to know what those status IDs refer to.
• Election Season table. (This is referred to from the campaign table and might have information about which election the campaign is active for. This will make it possible to line up races between candidates, etc and make it possible to group things for a given election season)

Things that would be nice to have:

• Division table (perhaps another geography? Not really sure)
• Filing type table (This is referred to from the filing period table and might have info about the kinds of filings that they get)

Other tables that seem to exist but we don't have:

• Regular filing period table (This is referred to from the filing period table. Not sure what it refers to)
• Entity table (This may or may not exist. It seems like this is a unique ID that is unique across PACs, Candidates and Campaigns and allows for joining tables that have info about all three kinds of "entities". It might be cool to see what's in there, though, if they do have that table)