CREATE TABLE IF NOT EXISTS notification_log (
    id INT AUTO_INCREMENT PRIMARY KEY,
    appointment_id INT NOT NULL,
    phone VARCHAR(20) NOT NULL,
    notification_type VARCHAR(20) NOT NULL,
    sent_at DATETIME NOT NULL,
    success TINYINT(1) DEFAULT 1
);
