Schema for tn_federal_archive_public

CREATE TABLE public_contributions ("canon_id", "donor_name", "employer", "occupation", "is_organization", "entity_type", "entity_subtype", "city", "state", "zip", "amount", "date", "is_inkind", "designated_election_phase", "campaign_id", "reporting_period", "party", "election_cycle_year", "candidate_name", "office_name");
CREATE TABLE export_meta (store TEXT, generated_at TEXT, privacy_threshold INTEGER, rows INTEGER);
CREATE INDEX idx_pc_pair ON public_contributions(canon_id, campaign_id);
CREATE INDEX idx_pc_campaign ON public_contributions(campaign_id)