-- Iteration 1 Database Schema
-- Objective: Schema changes include adding tables for missing data requirements and updating configuration logic for scalar parameters and formulas.

CREATE TABLE song (
  f_id INTEGER,
  rating FLOAT,
  file_size INTEGER
);

CREATE TABLE song_file_data (
  song_id INTEGER,
  resolution INTEGER
);

