-- Iteration 2 Database Schema
-- Objective: Incorporated Sales_journal data into the schema for objective coefficient mapping and updated business configuration logic for scalar parameters.

CREATE TABLE journal_committee (
  Editor_ID INTEGER,
  Journal_ID INTEGER
);

CREATE TABLE editor_qualifications (
  Editor_ID INTEGER,
  Theme STRING
);

CREATE TABLE journal_sales (
  Journal_ID INTEGER,
  Sales FLOAT
);

