-- Create review_calibrations table
CREATE TABLE IF NOT EXISTS review_calibrations (
    id SERIAL PRIMARY KEY,
    review_id INT NOT NULL,
    department VARCHAR(255) NOT NULL,
    country_code VARCHAR(5),
    original_rating DECIMAL(3,2),
    adjusted_rating DECIMAL(3,2),
    status VARCHAR(20) DEFAULT 'pending',
    moderator_id INT,
    approved_at TIMESTAMP,
    isDeleted BOOLEAN NOT NULL DEFAULT FALSE,
    updatedAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);
