Schema for tn_state_public

CREATE TABLE public_contributions ("canon_id", "donor_name", "employer", "occupation", "is_organization", "city", "state", "zip", "amount", "date", "is_inkind", "designated_election_phase", "campaign_id", "reporting_period", "party", "election_cycle_year", "candidate_name", "office_name");
CREATE INDEX idx_pc_pair ON public_contributions(canon_id, campaign_id);
CREATE INDEX idx_pc_campaign ON public_contributions(campaign_id);
CREATE TABLE "expenditures" ("candidate", "office", "party", "status", "payee", "payee_city", "payee_state", "purpose", "amount", "date");
CREATE TABLE "loans" ("candidate", "office", "party", "status", "lender", "amount", "date_received", "outstanding_balance", "amount_repaid", "is_self_loan");
CREATE TABLE "candidate_summaries" ("candidate", "office", "party", "status", "total_contributions", "total_refunds", "monetary_raised", "inkind_received", "total_self_contributions", "total_loans", "total_unitemized", "total_expenditures", "total_unitemized_spent", "total_spent", "cash_on_hand", "contributor_count", "filing_count", "is_incumbent");
CREATE TABLE export_meta (store TEXT, generated_at TEXT, privacy_threshold INTEGER, rows INTEGER)