CREATE TABLE IF NOT EXISTS `caller_data` (
    `id` BIGINT AUTO_INCREMENT PRIMARY KEY,
    `call_id` VARCHAR(100) DEFAULT NULL,
    `caller_phone` VARCHAR(20) DEFAULT NULL,
    `caller_name` VARCHAR(100) DEFAULT NULL,
    `caller_email` VARCHAR(255) DEFAULT NULL,
    `building_query` VARCHAR(255) DEFAULT NULL,
    `answers` JSON DEFAULT NULL,
    `notes` TEXT DEFAULT NULL,
    `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX `idx_call_id` (`call_id`),
    INDEX `idx_caller_phone` (`caller_phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
