-- Iteration 2 Database Schema
-- Objective: Incorporated missing data for deaths caused by ships in battles, adjusted schema to include objective coefficients, and updated business configuration logic for scalar parameters and formulas.

CREATE TABLE ship_battle_assignment (
  ship_id INTEGER,
  battle_id INTEGER,
  assignment BOOLEAN
);

CREATE TABLE battle_requirements (
  battle_id INTEGER,
  min_ships INTEGER
);

CREATE TABLE deaths_by_ship_battle (
  ship_id INTEGER,
  battle_id INTEGER,
  deaths INTEGER
);

