-- Iteration 1 Database Schema
-- Objective: Schema changes include creating a new table for diversity scores and updating business configuration logic for constraints. These changes address the OR expert's mapping gaps and missing requirements.

CREATE TABLE photos (
  id INTEGER,
  diversity_score FLOAT
);

CREATE TABLE photo_diversity_scores (
  photo_id INTEGER,
  diversity_score FLOAT
);

