CREATE TABLE solar_investment_case_reports (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  project_id INT NOT NULL,
  bill_id INT NULL,
  model VARCHAR(160) NOT NULL,
  payload_hash VARCHAR(64) NOT NULL,
  payload_json LONGTEXT NOT NULL,
  report_json LONGTEXT NOT NULL,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX solar_investment_case_reports_lookup_idx
  ON solar_investment_case_reports (project_id, bill_id, model);

CREATE INDEX solar_investment_case_reports_payload_hash_idx
  ON solar_investment_case_reports (payload_hash);

CREATE INDEX solar_investment_case_reports_created_at_idx
  ON solar_investment_case_reports (created_at);