{"table_name":"aichat_appointments","full_table_name":"wp_aichat_appointments","description":"Stores aichat appointments data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_aichat_appointments` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `booking_code` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `customer_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `customer_email` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `customer_phone` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `service` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `staff` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `appointment_date` date NOT NULL,\\n  `start_time` time NOT NULL,\\n  `end_time` time NOT NULL,\\n  `timezone` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'Europe/Madrid',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `notes` text COLLATE utf8mb4_unicode_520_ci,\\n  `source` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT 'chat',\\n  `bot_slug` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `session_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `external_id` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `external_source` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `reminder_sent` tinyint(1) DEFAULT '0',\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `booking_code` (`booking_code`),\\n  KEY `appointment_date` (`appointment_date`),\\n  KEY `status` (`status`),\\n  KEY `customer_email` (`customer_email`),\\n  KEY `external_id` (`external_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"axiachat-ai","name":"AxiaChat AI – Free AI Chatbot (Answers Customers Automatically)","active_installs":2000,"version":"4.1.10","wp_org_url":"https://wordpress.org/plugins/axiachat-ai/"}}