CREATE TABLE executive_summary_reports (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  project_id INT NOT NULL,
  bill_id INT NOT NULL,
  effective_tariff_schedule_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 executive_summary_reports_lookup_idx
  ON executive_summary_reports (project_id, bill_id, effective_tariff_schedule_id, model);

CREATE INDEX executive_summary_reports_payload_hash_idx
  ON executive_summary_reports (payload_hash);

CREATE INDEX executive_summary_reports_created_at_idx
  ON executive_summary_reports (created_at);