CREATE TABLE  `subscriptions_overview` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `subscription_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subscription_session_id` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cf_subscription_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_currency` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_recurring_amount` decimal(10,2) DEFAULT NULL,
  `plan_interval_type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_intervals` int(11) DEFAULT NULL,
  `plan_max_cycles` int(11) DEFAULT NULL,
  `plan_max_amount` decimal(10,2) DEFAULT NULL,
  `customer_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `authorization_reference` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `authorization_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `authorization_amount` decimal(10,2) DEFAULT NULL,
  `authorization_amount_refund` tinyint(1) DEFAULT NULL,
  `authorization_time` datetime DEFAULT NULL,
  `payment_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_group` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subscription_first_charge_time` datetime DEFAULT NULL,
  `next_schedule_date` datetime DEFAULT NULL,
  `subscription_expiry_time` datetime DEFAULT NULL,
  `psp_note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_id` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `loan_no` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rd_connected` tinyint(1) NOT NULL DEFAULT '0',
  `rd_number` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_id` (`subscription_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;