-- Iteration 1 Database Schema
-- Objective: Schema adjustments include creating new tables for editor qualifications and workload limits, modifying existing tables to improve mapping adequacy, and updating configuration logic for scalar parameters and formulas.

CREATE TABLE journal_committee (
  Editor_ID INTEGER,
  Journal_ID INTEGER
);

CREATE TABLE editor_qualifications (
  Editor_ID INTEGER,
  Theme STRING
);

