
-- --------------------------------------------------------

--
-- Table structure for table `data_automation`
--

CREATE TABLE `data_automation` (
  `id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted_at` date DEFAULT NULL,
  `role_id` int NOT NULL,
  `data_source` varchar(500) COLLATE utf8mb4_general_ci NOT NULL,
  `data_type` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ticket_type` text COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `data_automation`
--

INSERT INTO `data_automation` (`id`, `created_at`, `deleted_at`, `role_id`, `data_source`, `data_type`, `ticket_type`) VALUES
(8, '2025-08-16 06:41:53', NULL, 13, 'paid_customers', NULL, '[\"618\"]'),
(9, '2025-08-16 06:42:12', NULL, 3347, 'free_users', NULL, '[\"623\",\"626\",\"749\"]'),
(10, '2025-08-16 07:14:47', NULL, 3215, 'assign_tickets', NULL, '[\"Create Ticket\",\"Create Ticket For RM\",\"Affiliate With Us\",\"Customized Version\",\"Deactivate Account\",\"Inquiry Preference\",\"Feedback\",\"Brand Store\",\"Report Bugs\",\"Price Alert\",\"Customized Solution\",\"Helpline\",\"Add Market\",\"Add Product New Process\",\"Add Vessels\",\"Passive Incomes\",\"Career With Us\",\"FAQ\",\"View More Section\",\"Add Company\",\"Newsletter\",\"PPP\",\"Add Product Old Process pp\",\"Get Quotation\"]');
