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

CREATE TABLE ResourceAllocation (
  institution_id INTEGER,
  allocation FLOAT
);

CREATE TABLE protein (
  sequence_identity_coefficient FLOAT
);

CREATE TABLE building (
  building_capacity INTEGER
);

