-- Iteration 1 Database Schema
-- Objective: Schema changes include creating tables for decision variables and author-paper associations, and updating configuration logic for session constraints.

CREATE TABLE Papers (
  paper_id INTEGER,
  title STRING
);

CREATE TABLE Authors (
  author_id INTEGER,
  name STRING
);

CREATE TABLE AuthorPaperAssociations (
  author_id INTEGER,
  paper_id INTEGER
);

CREATE TABLE Sessions (
  session_id INTEGER,
  paper_id INTEGER
);

