CREATE TABLE IF NOT EXISTS translations (
    id SERIAL PRIMARY KEY,
    source_text TEXT NOT NULL,
    translated_text TEXT NOT NULL,
    raw_output TEXT,
    model_name VARCHAR(100) NOT NULL,
    prompt TEXT NOT NULL,
    prompt_id INT,
    created_at TIMESTAMP NOT NULL DEFAULT NOW()
);