DB Schema

CREATE TABLE "campaign_summary" (
  "campaign_id" INTEGER, 
  "summary_value" INTEGER, 
  "summary_level" TEXT, 
  "summary_type" TEXT
);

CREATE TABLE "campaign_info" (
  "campaign_id" INTEGER, 
  "election_year" INTEGER, 
  "election_cycle" TEXT, 
  "candidate_id" INTEGER, 
  "candidate_position" TEXT, 
  "candidate_party" TEXT
);

CREATE TABLE "candidate_info" (
  "candidate_id" INTEGER, 
  "candidate_name" TEXT
);