-- Iteration 1 Database Schema
-- Objective: Schema changes include adding a new table for constraint bounds, modifying existing tables for better mapping, and updating configuration logic for missing parameters.

CREATE TABLE machine (
  machine_id INTEGER,
  value_points INTEGER
);

CREATE TABLE repair_assignment (
  technician_id INTEGER,
  repair_id INTEGER,
  is_assigned BOOLEAN
);

CREATE TABLE constraint_bounds (
  technician_id INTEGER,
  max_repairs INTEGER
);

