CREATE TABLE transactions (
    transaction_id INT AUTO_INCREMENT PRIMARY KEY,
    variable_symbol VARCHAR(50),
    amount DECIMAL(10, 2),
    date DATE,
    status VARCHAR(20)
);

CREATE TABLE errors (
    error_id INT AUTO_INCREMENT PRIMARY KEY,
    transaction_id INT,
    error_message TEXT,
    timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
