-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for impact coefficients, costs, and resource usage, and updating business configuration logic for budget and total resources.

CREATE TABLE impact_coefficients (
  interaction_id INTEGER,
  coefficient FLOAT
);

CREATE TABLE interaction_costs (
  interaction_id INTEGER,
  cost FLOAT
);

CREATE TABLE resource_usage (
  interaction_id INTEGER,
  resources FLOAT
);

CREATE TABLE medicine_enzyme_interaction (
  interaction_id INTEGER,
  selected BOOLEAN
);

