-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for decision variables and constraint bounds, modifying existing tables to fill mapping gaps, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE perpetrator (
  Killed INTEGER,
  Injured INTEGER
);

CREATE TABLE ResourceAllocation (
  location_id INTEGER,
  amount FLOAT
);

CREATE TABLE LocationCosts (
  location_id INTEGER,
  cost FLOAT
);

