-- Iteration 1 Database Schema
-- Objective: Schema changes include creating new tables for missing optimization data, modifying existing tables to fill mapping gaps, and moving certain parameters to configuration logic for better management.

CREATE TABLE TV_series (
  Viewers_m INTEGER,
  Air_Time INTEGER,
  Content_Type STRING,
  Demographic_Target INTEGER,
  selected BOOLEAN
);

CREATE TABLE Channel (
  Total_Available_Time INTEGER,
  Content_Capacity INTEGER
);

