-- Iteration 1 Database Schema
-- Objective: Schema adjustments include creating new tables for constraint bounds, modifying existing tables to improve mapping adequacy, and updating business configuration logic for scalar parameters and formulas.

CREATE TABLE Projects (
  ProjectID INTEGER,
  Hours FLOAT
);

CREATE TABLE AssignedTo (
  ScientistID INTEGER,
  ProjectID INTEGER,
  binary_column BOOLEAN
);

CREATE TABLE ConstraintBounds (
  ConstraintType STRING,
  MinAssignments INTEGER
);

