CREATE TABLE `es_reward_codes_redemption_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `es_reward_code_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `transactionable_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transactionable_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `es_reward_codes_redemption_history_user_id_foreign` (`user_id`),
  KEY `es_reward_codes_redemption_history_es_reward_code_id_foreign` (`es_reward_code_id`),
  KEY `transactionable_index` (`transactionable_type`,`transactionable_id`),
  CONSTRAINT `es_reward_codes_redemption_history_es_reward_code_id_foreign` FOREIGN KEY (`es_reward_code_id`) REFERENCES `es_reward_codes` (`id`),
  CONSTRAINT `es_reward_codes_redemption_history_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `es_reward_codes_redemption_history`
--


--
-- Table structure for table `event_tag_categories`
--

CREATE TABLE `event_tag_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_tag_categories_business_account_id_index` (`business_account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_tag_categories`
--

INSERT INTO `event_tag_categories` VALUES (1,1,'Digital Engagement',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(2,1,'In-Store Engagement',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(3,1,'Conversion Interest',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(4,1,'Conversion',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26');

--
-- Table structure for table `event_tag_type_slugs`
--

CREATE TABLE `event_tag_type_slugs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_tag_type_slugs_slug(20)_index` (`slug`(20))
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_tag_type_slugs`
--

INSERT INTO `event_tag_type_slugs` VALUES (1,'site_visit','Visit to Site',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(2,'social_follow','Social Media Following',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(3,'registration','Register Gamification',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(4,'in_games_action','In-Game Actions',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(5,'take_a_picture','Upload Photo (snap a photo)',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(6,'voucher_download','Voucher Download',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(7,'upload_receipt','Upload Receipt',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(8,'voucher_redemption','Voucher Redemption',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(9,'store_qr_pin_input','Scan QR/Input Pin Code',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(10,'ecom_promo_code','Ecommerce Promo Code',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(11,'app_install','App Install',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(12,'receipt_approved','Receipt Approved',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(13,'app_install_approved','App Install Approved',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(14,'social_follow_approved','Social Media Following Approved',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(15,'take_a_picture_approved','Upload Photo (snap a photo) Approved',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(16,'daily_checkin','Daily Check-in',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(17,'referral','New Referral',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26'),(18,'game_session_state_updated','Game Session State Updated',NULL,'2026-04-07 06:36:26','2026-04-07 06:36:26');

--
-- Table structure for table `event_tag_types`
--

CREATE TABLE `event_tag_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `event_tag_category_id` bigint unsigned NOT NULL,
  `event_tag_type_slug_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_tag_unique_index` (`business_account_id`,`event_tag_type_slug_id`,`event_tag_category_id`),
  KEY `event_tag_types_event_tag_category_id_index` (`event_tag_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_tag_types`
--

INSERT INTO `event_tag_types` VALUES (1,1,1,1,'Visit to Site',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(2,1,1,2,'Social Media Following',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(3,1,1,3,'Register Gamification',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(4,1,1,4,'In-Game Actions',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(5,1,2,9,'Scan QR/Input Pin Code',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(6,1,2,5,'Upload Photo (snap a photo)',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(7,1,3,6,'Voucher Download',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(8,1,4,7,'Upload Receipt',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(9,1,4,8,'Voucher Redemption',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(10,1,4,9,'Scan QR/Input Pin Code',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(11,1,4,10,'Ecommerce Promo Code',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(12,1,4,11,'App Install',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(13,1,4,12,'Receipt Approved',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(14,1,4,13,'App Install Approved',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(15,1,4,14,'Social Media Following Approved',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(16,1,4,15,'Upload Photo (snap a photo) Approved',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26'),(17,1,4,18,'Game Session State Updated',NULL,'active','2026-04-07 06:36:26','2026-04-07 06:36:26');

--
-- Table structure for table `exclusive_reward_redemptions`
--

CREATE TABLE `exclusive_reward_redemptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `series_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `point_required` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exclusive_reward_redemptions_series_id(15)_index` (`series_id`(15))
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exclusive_reward_redemptions`
--

INSERT INTO `exclusive_reward_redemptions` VALUES (1,'1AUse-042026-1','0','','2026-04-24 05:48:41','2026-04-24 05:48:41');

--
-- Table structure for table `external_apis`
--

CREATE TABLE `external_apis` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `api_group_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_group_slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `headers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `external_apis`
--

INSERT INTO `external_apis` VALUES (1,'whatsapp','default','sendMessage','POST','https://wa-username.growthdesk.dev/api/v1/workflow','{\"Authorization\":\"Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIzIiwianRpIjoiYjIzODMyOTNhZTE1YTM1MWIxNjk5MzBjYjMzMjdjYTM1YTRhMTg4ODIyOGI3N2Y5NTU2OTM0MmIzOWZjODUxNDE5OTllMDI0MmY4N2MxOWMiLCJpYXQiOjE3Nzg1NTg1MjUuMDA1OTk5MDg4Mjg3MzUzNTE1NjI1LCJuYmYiOjE3Nzg1NTg1MjUuMDA2MDA0MDk1MDc3NTE0NjQ4NDM3NSwiZXhwIjoxODEwMDk0NTI0Ljk5MjI3ODA5OTA2MDA1ODU5Mzc1LCJzdWIiOiI0MyIsInNjb3BlcyI6WyJvYXV0aCJdfQ.gH6MWIp1-1HD_Z0b1n9WfL2fclEkBinlHps9VLCnG7K7R602P0Wzq_ByP0cQm5YwSL45uaIQv36uO-Rsavqq6NzRD7Jw_xgIxGpgzCTFD_hOr-jyvNkziTfNsxKF_AaB1SJzi2wmGPlVla6QQCyrAPQiNurtpc7GUSYibKelSkDaVfBzoeehlQomFuuJrztZ-YS8DrH28-xK34iOPXvw3ri95TPlTJz7C1_tMYzBHtT3SZfxu7dSw13a1aGqChq7Rc2UR-4pAMX0HDNrveolykPfnlqOY-7Y656sMC9Z5JNPnY0HFq0rXQ0C9c3as_g2TqazFYeEjrViR3f0VaLp1quhiSD3UxmkyJVc-_X95ZhZ1hmN3uS7vYk0_IyXPewWZI1sAicOhzxVMj0hfoq85lR0g365YSJuapxuX-N7tDXE4ZxiLLJsGR1RLbflKVJOOey3djg-NtKz9llyjMqR3jQrmGRCrtf77rdXPvRPa9OxglkecErZmPz4y7yJL4NbxafMUF0AbgwqKNfdX40t-O6YJi53hM02NsJdLdSiGNc-K_E2xkusNGXt0s88PNbrhMr-bwzoUcvpPo9jR3QvQH9PFOtEEZntAytXyQUvChottMhmDH83Bijb4VaR5hwNcb8-02TOMFAzRKSoiNyAHrslyIP6UQKY6VBNm5Q5GSE\"}','active','2026-05-12 03:47:35','2026-05-12 03:47:35');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--

INSERT INTO `failed_jobs` VALUES (1,'cf9bbaab-a1a8-4268-a6ed-af935840ecdc','database','default','{\"uuid\":\"cf9bbaab-a1a8-4268-a6ed-af935840ecdc\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:34;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 11:43:46\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 03:43:48'),(2,'643e3834-3656-4fe8-9eac-8919a07dc76f','database','default','{\"uuid\":\"643e3834-3656-4fe8-9eac-8919a07dc76f\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:35;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 12:06:28\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 04:06:30'),(3,'dc6032a4-3c5d-494e-9c3c-fd1ffd57e022','database','default','{\"uuid\":\"dc6032a4-3c5d-494e-9c3c-fd1ffd57e022\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:36;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 12:23:05\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 04:23:08'),(4,'ee06c550-55a6-4d05-be8a-1b1d65ba74f8','database','default','{\"uuid\":\"ee06c550-55a6-4d05-be8a-1b1d65ba74f8\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:37;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 13:15:54\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 05:15:54'),(5,'4131ab7d-3b35-44de-8abf-59f4cf695a4c','database','default','{\"uuid\":\"4131ab7d-3b35-44de-8abf-59f4cf695a4c\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:38;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 13:31:48\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 05:31:49'),(6,'75ca8074-3450-4e0c-ad8b-e93610cec33e','database','default','{\"uuid\":\"75ca8074-3450-4e0c-ad8b-e93610cec33e\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:39;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 13:47:26\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 05:47:27'),(7,'710c46e9-cb9f-44ab-8701-4da7fd4538fc','database','default','{\"uuid\":\"710c46e9-cb9f-44ab-8701-4da7fd4538fc\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:40;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 13:50:15\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 05:50:16'),(8,'5bcd69ae-8ec2-4d78-b4e0-295091d3069d','database','default','{\"uuid\":\"5bcd69ae-8ec2-4d78-b4e0-295091d3069d\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:41;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 16:23:19\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 08:23:21'),(9,'46c88407-d930-4577-b46f-fb3c984e1fc4','database','default','{\"uuid\":\"46c88407-d930-4577-b46f-fb3c984e1fc4\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:46;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-12 16:29:55\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-12 08:29:56'),(10,'7bfe796c-97fc-47bc-b0cc-1bd5a458989b','database','default','{\"uuid\":\"7bfe796c-97fc-47bc-b0cc-1bd5a458989b\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:11;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:48;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-13 13:54:44\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-13 05:54:44'),(11,'b254f2f2-7f10-4a54-99b7-d8f0001fc50a','database','default','{\"uuid\":\"b254f2f2-7f10-4a54-99b7-d8f0001fc50a\",\"displayName\":\"App\\\\Listeners\\\\BonusModuleListener\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Events\\\\CallQueuedListener\",\"command\":\"O:36:\\\"Illuminate\\\\Events\\\\CallQueuedListener\\\":19:{s:5:\\\"class\\\";s:33:\\\"App\\\\Listeners\\\\BonusModuleListener\\\";s:6:\\\"method\\\";s:21:\\\"approvalStatusUpdated\\\";s:4:\\\"data\\\";a:1:{i:0;O:47:\\\"App\\\\Events\\\\CustomEvent\\\\ApprovalStatusWasUpdated\\\":14:{s:10:\\\"isApproved\\\";b:1;s:16:\\\"eventTagTypeSlug\\\";s:16:\\\"receipt_approved\\\";s:4:\\\"user\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:8:\\\"App\\\\User\\\";s:2:\\\"id\\\";i:8;s:9:\\\"relations\\\";a:2:{i:0;s:15:\\\"businessAccount\\\";i:1;s:11:\\\"userSummary\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"mainModel\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":4:{s:5:\\\"class\\\";s:46:\\\"App\\\\Models\\\\UserInteraction\\\\UserDailyChallenges\\\";s:2:\\\"id\\\";i:50;s:9:\\\"relations\\\";a:14:{i:0;s:7:\\\"receipt\\\";i:1;s:12:\\\"receipt.user\\\";i:2;s:28:\\\"receipt.user.businessAccount\\\";i:3;s:30:\\\"receipt.receiptEntryOcrSummary\\\";i:4;s:26:\\\"receipt.userDailyChallenge\\\";i:5;s:31:\\\"receipt.userDailyChallenge.user\\\";i:6;s:42:\\\"receipt.userDailyChallenge.daily_challenge\\\";i:7;s:15:\\\"daily_challenge\\\";i:8;s:31:\\\"daily_challenge.businessAccount\\\";i:9;s:4:\\\"user\\\";i:10;s:20:\\\"user.businessAccount\\\";i:11;s:16:\\\"user.userSummary\\\";i:12;s:14:\\\"pivotChallenge\\\";i:13;s:13:\\\"challengeable\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";}s:9:\\\"arguments\\\";a:0:{}s:9:\\\"timestamp\\\";s:19:\\\"2026-05-13 17:09:25\\\";s:12:\\\"beforeUpdate\\\";N;s:11:\\\"afterUpdate\\\";N;s:14:\\\"wasSoftDeleted\\\";b:0;s:14:\\\"wasHardDeleted\\\";b:0;s:12:\\\"\\u0000*\\u0000modelPath\\\";N;s:11:\\\"\\u0000*\\u0000modelKey\\\";N;s:12:\\\"revisionType\\\";N;s:6:\\\"socket\\\";N;}}s:5:\\\"tries\\\";N;s:13:\\\"maxExceptions\\\";N;s:7:\\\"backoff\\\";N;s:10:\\\"retryUntil\\\";N;s:7:\\\"timeout\\\";N;s:17:\\\"shouldBeEncrypted\\\";b:0;s:3:\\\"job\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}}\"}}','Error: Call to a member function getQuery() on null in /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:702\nStack trace:\n#0 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(662): Illuminate\\Database\\Eloquent\\Builder->getRelation(\'userDailyChalle...\')\n#1 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'userDailyChalle...\', Object(Closure))\n#2 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(610): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#3 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(195): Illuminate\\Database\\Eloquent\\Builder->get(Array)\n#4 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(160): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()\n#5 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(673): Illuminate\\Database\\Eloquent\\Relations\\Relation->getEager()\n#6 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(642): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelation(Array, \'receipt\', Object(Closure))\n#7 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(597): Illuminate\\Database\\Eloquent\\Builder->eagerLoadRelations(Array)\n#8 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(102): Illuminate\\Database\\Eloquent\\Model->load(Array)\n#9 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesAndRestoresModelIdentifiers.php(57): App\\Events\\Event->restoreModel(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#10 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/app/Traits/JobSerializesNullableModels.php(17): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#11 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/SerializesModels.php(122): App\\Events\\Event->getRestoredPropertyValue(Object(Illuminate\\Contracts\\Database\\ModelIdentifier))\n#12 [internal function]: App\\Events\\Event->__unserialize(Array)\n#13 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(97): unserialize(\'O:36:\"Illuminat...\')\n#14 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(60): Illuminate\\Queue\\CallQueuedHandler->getCommand(Array)\n#15 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(98): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#16 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(428): Illuminate\\Queue\\Jobs\\Job->fire()\n#17 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(378): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#18 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(172): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#19 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(117): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#20 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(101): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#21 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#22 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#23 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#24 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Bootstrap\\DomainBasedApplication), Array, Object(Closure))\n#25 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Container/Container.php(653): Illuminate\\Container\\BoundMethod::call(Object(Bootstrap\\DomainBasedApplication), Array, Array, NULL)\n#26 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call(Array)\n#27 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Command/Command.php(298): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#28 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#29 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#30 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(301): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#31 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/symfony/console/Application.php(171): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#32 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Console/Application.php(94): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#33 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#34 /home/growthdeskuser/public_html/wa-username-testing/enterprise-solutions/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#35 {main}','2026-05-13 09:09:26');

--
-- Table structure for table `form_feedback_datas`
--

CREATE TABLE `form_feedback_datas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filed_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `form_feedback_datas`
--


--
-- Table structure for table `game_session_states`
--

CREATE TABLE `game_session_states` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `session_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `is_qr_code_challenge_completed` tinyint NOT NULL DEFAULT '0',
  `is_game_completed` tinyint NOT NULL DEFAULT '0',
  `is_points_provisioned` tinyint NOT NULL DEFAULT '0',
  `game_completed_at` datetime DEFAULT NULL,
  `game_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `game_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `points` int DEFAULT NULL,
  `redeem_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `voucher_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `game_session_states_session_id_index` (`session_id`),
  KEY `game_session_states_user_id_index` (`user_id`),
  KEY `game_session_states_game_completed_at_index` (`game_completed_at`),
  CONSTRAINT `game_session_states_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `game_session_states`
--


--
-- Table structure for table `generic_taggables`
--

CREATE TABLE `generic_taggables` (
  `generic_tags_id` bigint unsigned NOT NULL,
  `generic_taggable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `generic_taggable_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `unique_set_index` (`generic_tags_id`,`generic_taggable_type`,`generic_taggable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `generic_taggables`
--


--
-- Table structure for table `generic_tags`
--

CREATE TABLE `generic_tags` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `generic_tags_business_account_id_index` (`business_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `generic_tags`
--


--
-- Table structure for table `hypermart_feedback_forms`
--

CREATE TABLE `hypermart_feedback_forms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_category` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `form_product` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hypermart_feedback_forms`
--


--
-- Table structure for table `import_merchant_and_product_logs`
--

CREATE TABLE `import_merchant_and_product_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `file_path` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `import_merchant_and_product_logs_user_id_index` (`user_id`),
  CONSTRAINT `import_merchant_and_product_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `import_merchant_and_product_logs`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `ltm_translations`
--

CREATE TABLE `ltm_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` int NOT NULL DEFAULT '0',
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `group` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1211 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `ltm_translations`
--



--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'gamification',
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL,
  `auth` tinyint(1) NOT NULL DEFAULT '1',
  `new_tab` tinyint(1) NOT NULL DEFAULT '1',
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `popup` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--


--
-- Table structure for table `merchants`
--

CREATE TABLE `merchants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` int unsigned NOT NULL,
  `company_name` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_logo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `mobile_country_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `merchants_status(6)_slug(10)_index` (`status`(6),`slug`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `merchants`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=485 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_07_22_100559_create_reminders_tables',1),(4,'2019_07_24_084448_create_permission_tables',1),(5,'2019_07_24_084747_create_vouchers_tables',1),(6,'2019_07_24_085150_create_user_business_tables',1),(7,'2019_08_07_065756_create_system_tables',1),(8,'2019_08_14_102937_update_business_account_table',1),(9,'2019_08_15_083927_create_voucher_series_details',1),(10,'2019_08_19_141833_update_voucher_redeem_code_table',1),(11,'2019_08_20_111635_create_hypermart_data_table',1),(12,'2019_08_22_034511_create_business_details_table',2),(13,'2019_08_22_044327_custom_conversions',2),(14,'2019_08_23_081609_update_voucher_table',2),(15,'2019_08_27_024050_create_business_account_domains_table',2),(16,'2019_08_27_063150_create_sms_blast_tables',2),(17,'2019_08_27_171856_update_business_asset_voucher_table',2),(18,'2019_08_28_151823_create_campaign_business_assets_relation_table',2),(19,'2019_08_28_183842_update_reminder_table',2),(20,'2019_09_11_104032_update_voucher_series_table',2),(21,'2019_10_22_133421_create_voucher_redeem_codes_backup_table',2),(22,'2019_10_29_151026_create_creative_templates_tables',2),(23,'2019_11_01_103157_update_voucher_series_column_use_count_table',2),(24,'2019_11_06_154754_create_voucher_series_import_tables',2),(25,'2019_11_11_183058_update_voucher_series_table_unique_redeem_count_columns',2),(26,'2019_11_12_112835_update_voucher_series_update_columns_order',2),(27,'2019_11_12_114708_create_voucher_send_queues_table',2),(28,'2019_11_13_195914_update_tags_table_add_column_identifier',2),(29,'2019_11_14_121412_create_banner_settings_table',2),(30,'2019_11_14_121518_create_widget_settings_table',2),(31,'2019_11_14_154334_create_form_feedback_datas_table',2),(32,'2019_11_14_195219_create_product_categories_table',2),(33,'2019_11_15_084236_create_hypermart_feedback_form_table',2),(34,'2019_11_15_121947_create_product_categories_voucher_series_relationship',2),(35,'2019_11_18_114541_create_user_logs_table',2),(36,'2019_11_18_180035_update_voucher_series_table_add_mendatory_columns',2),(37,'2019_11_19_120107_create_newsletters_table',2),(38,'2019_11_21_181252_create_user_log_stats_table',2),(39,'2019_11_22_161055_create_voucher_stats_table',2),(40,'2019_12_10_235713_update_voucher_stats_table_add_column_value',2),(41,'2020_06_04_000007_add_column_code_in_voucher_series_asset_relation',2),(42,'2020_06_08_013559_add_column_redemption_method_voucher_series_imports_table',2),(43,'2020_06_08_153458_add_use_by_date_option_column_in_voucher_series_table',2),(44,'2020_06_09_221226_add_generated_password_column_in_voucher_send_queues_table',2),(45,'2020_06_09_231907_add_last_login_column_in_users_table',2),(46,'2020_06_10_011611_add_type_column_in_business_assets_table',2),(47,'2020_06_10_170159_add_password_changed_column_in_user_table',2),(48,'2020_06_19_145145_add_column_user_id_in_vouchers_table',2),(49,'2020_07_23_074752_create_voucher_series_stats_table',2),(50,'2020_07_27_053742_add_max_usable_voucher_column_in_voucher_series_table',2),(51,'2020_10_20_030824_add_google2fa_secret_column_in_user_table',2),(52,'2020_11_25_102008_add_color_store_logo_in_business_assets_table',2),(53,'2020_11_29_235237_create_receipts_table',2),(54,'2020_11_30_002409_create_modules_table',2),(55,'2020_11_30_235200_create_stores_table',2),(56,'2020_12_01_232838_create_voucher_redeem_code_groups_table',2),(57,'2020_12_15_212039_create_tracking_events_table',2),(58,'2020_12_16_015537_add_column_redeem_code_in_business_assets_table',2),(59,'2020_12_16_122638_create_voucher_agreements_table',2),(60,'2020_12_17_194233_add_promotion_code_display_method_colomn_in_business_assets_table',2),(61,'2020_12_17_195934_create_category_group_items_table',2),(62,'2020_12_17_195938_create_category_groups_table',2),(63,'2020_12_17_200049_create_category_group_settings_table',2),(64,'2020_12_20_000000_add_api_column',3),(65,'2021_03_31_005918_create_sso_token_table',3),(66,'2021_03_30_154131_create_user_details_table',4),(67,'2016_06_01_000001_create_oauth_auth_codes_table',5),(68,'2016_06_01_000002_create_oauth_access_tokens_table',5),(69,'2016_06_01_000003_create_oauth_refresh_tokens_table',5),(70,'2016_06_01_000004_create_oauth_clients_table',5),(71,'2016_06_01_000005_create_oauth_personal_access_clients_table',5),(72,'2021_06_30_115700_create_transactions_table',5),(73,'2021_07_01_133652_add_promotion_mechanic_column_in_voucher_series_table',5),(74,'2021_07_02_032100_add_promotion_mechanic_column_in_voucher_series_asset_relations_table',5),(75,'2021_07_19_012728_create_dsc_users_table',6),(76,'2021_07_19_012820_create_dsc_rewards_pos_table',7),(77,'2021_07_19_012828_create_dsc_merchants_table',6),(78,'2021_07_19_012839_create_dsc_logs_table',8),(79,'2021_07_19_012847_create_dsc_locations_table',6),(80,'2021_07_19_012856_create_dsc_grids_table',9),(81,'2021_07_19_012922_create_dsc_entries_table',6),(82,'2021_07_19_012935_create_dsc_api_accesses_table',10),(83,'2021_07_21_004510_create_dsc_reward_items_table',10),(84,'2021_07_21_004757_create_dsc_reward_redemption_logs_table',10),(85,'2021_07_21_022748_create_dsc_reward_groups_table',10),(86,'2021_07_21_134227_create_user_addresses_table',11),(87,'2021_07_22_152426_create_address_states_table',12),(88,'2021_07_27_015132_create_notification_templates_table',13),(90,'2021_07_27_163441_create_notification_logs_table',14),(93,'2021_09_16_173813_add_receipt_uid_to_ocr_samples',15),(94,'2021_09_17_104217_add_merchant_sid_to_ocr_samples',16),(95,'2021_09_23_100340_create_user_device_agents_table',17),(96,'2021_09_23_100442_add_user_device_agent_id_field_to_dsc_entries',17),(148,'2021_10_07_145958_create_plant_user_summary_progress_table',18),(149,'2021_10_07_151700_create_notifications_table',18),(150,'2021_10_07_152158_create_plant_token_transactions_table',18),(151,'2021_10_07_152939_create_plant_supplement_transactions_table',18),(152,'2021_10_07_154201_create_plant_supplements_table',18),(153,'2021_10_08_093934_create_plant_user_plants_table',18),(154,'2021_10_08_094701_create_plant_summary_user_plant_progress_table',18),(155,'2021_10_08_094936_create_plant_growth_token_transactions_table',18),(156,'2021_10_08_095537_create_daily_challenges_table',18),(157,'2021_10_08_095614_create_user_daily_challenges_table',18),(158,'2021_10_08_095625_create_user_question_headers_table',18),(159,'2021_10_08_095638_create_user_question_details_table',18),(160,'2021_10_08_095650_create_questions_table',18),(161,'2021_10_08_095658_create_question_choices_table',18),(162,'2021_10_08_095722_create_daily_core_a_rs_table',18),(163,'2021_10_08_095731_create_user_daily_core_a_rs_table',18),(164,'2021_10_12_113615_create_daily_check_ins_table',18),(165,'2021_10_14_164455_add_cta_action_to_notification_templates',19),(166,'2021_10_15_160053_alter_cta_type_to_nullable_for_notifications',19),(167,'2021_10_15_173053_add_last_interact_at_to_plant_user_summary_progress',19),(168,'2021_10_18_181415_alter_unique_key_for_daily_challenges_and_daily_core_ars',20),(169,'2021_10_19_154729_add_token_img_path_to_plant_supplements',20),(170,'2021_10_24_014347_add_img_landing_path_to_daily_challenges',21),(172,'2021_10_25_215831_create_qr_scan_logs_table',22),(173,'2021_10_26_104507_create_merchants_table',22),(174,'2021_10_15_121757_create_point_transactions_table',23),(175,'2021_10_18_174535_create_exclusive_reward_redemptions_table',23),(176,'2021_10_21_020206_create_referrer_code_logs_table',23),(177,'2021_10_26_120046_add_referrer_code_in_user_table',24),(178,'2021_11_03_174320_add_index_to_necessary_table',25),(179,'2021_11_05_100812_add_day_week_settings_to_daily_challenges',26),(180,'2021_11_11_012133_create_plant_users_table',27),(181,'2021_11_17_102857_add_key_value_column_index_to_user_details',27),(182,'2021_11_17_103434_drop_duplicate_user_id_index_from_plant_user_summary_progress',27),(183,'2021_11_18_115103_add_necessary_index_to_table',28),(186,'2021_11_23_152304_add_column_membership_synced_date_in_users_table',29),(187,'2021_11_26_114010_add_is_membership_auto_sync_mode_to_users_and_plant_users',30),(189,'2021_12_13_234355_add_dob_column_in_user_table',31),(195,'2021_12_14_170313_create_products_table',32),(196,'2021_12_14_225251_add_status_column_in_referrer_code_logs_table',32),(197,'2021_12_15_024004_add_products_column_in_dsc_entry_table',32),(198,'2021_12_16_182927_add_state_column_in_business_assets_table',33),(212,'2021_12_17_011505_add_product_group_id_in_stores_table',34),(213,'2021_12_17_012341_create_product_groups_table',34),(214,'2021_12_17_024757_add_product_group_slug_in_products_table',34),(216,'2021_12_21_001835_add_voucher_type_column_in_voucher_series_table',35),(218,'2021_12_22_182654_add_mobile_verified_column_in_users_table',36),(219,'2021_12_29_141104_add_dob_column_in_plant_and_dsc_users_table',37),(220,'2022_01_05_130534_create_ocr_negative_keywords_table',38),(221,'2022_01_05_134815_add_ocr_columns_in_dsc_entries_table',39),(222,'2014_04_02_193005_create_translations_table',40),(223,'2021_09_06_011955_add_columns_in_category_groups',40),(224,'2021_09_06_022950_create_campaigns_table',40),(225,'2021_09_06_025318_create_campaign_voucher_series_table',40),(226,'2021_09_26_003414_create_category_criterias_table',40),(227,'2021_09_28_174535_add_column_is_downloadable_to_voucher_series',40),(228,'2021_09_29_144046_update_column_redeem_max_in_voucher_series_table',40),(229,'2021_10_02_220806_add_voucher_source_column_in_vouchers',40),(230,'2021_10_16_031824_add_vocuher_type_module_columns_in_voucher_series_table',41),(231,'2021_12_09_145933_add_slug_to_business_accounts',41),(232,'2021_12_14_115042_migrate_pnm_table_needed_for_voucher_demo',41),(233,'2021_12_29_121915_create_audit_revisions_table',41),(234,'2022_01_11_101134_add_apple_touch_icon_to_business_account',41),(235,'2022_01_12_205717_create_merchant_details_table',41),(236,'2022_01_19_100928_create_store_details_table',42),(237,'2022_01_11_162928_create_notification_template_unsubscribes_table',43),(238,'2021_11_09_144901_create_dstw_items_table',44),(239,'2021_11_09_144931_create_dstw_item_periods_table',44),(240,'2021_11_09_144952_create_dstw_entries_table',44),(241,'2021_11_09_145000_create_dstw_entry_statuses_table',44),(242,'2022_02_14_132952_add_timestamp_column_to_analytics_view',44),(243,'2022_02_17_152649_add_necessary_index_for_analytics',44),(244,'2022_02_24_175842_add_bi_related_columns_to_analytics_view',45),(245,'2022_01_25_182442_add_email_masked_column_in_user',45),(254,'2022_02_22_174226_create_blast_target_groups_table',46),(256,'2022_02_27_214640_create_blasts_table',47),(257,'2022_02_18_192528_alter_structure_voucher_series_table',48),(258,'2022_02_28_230551_create_blast_recipients_table',48),(259,'2022_02_25_160845_create_analytics_bi_summaries_table',49),(260,'2022_03_03_232252_add_index_to_bi_summary_used_table',49),(261,'2022_03_06_213002_create_user_menu_favorites_table',49),(262,'2022_03_11_151928_add_type_column_in_voucher_series_tags_table',50),(263,'2022_03_14_183252_alter_column_bi_home_order_analytic_view',50),(264,'2022_03_24_084152_add_business_account_id_to_users',51),(265,'2022_03_24_084401_create_account_user_relations_table',51),(266,'2022_03_28_110943_add_column_last_home_refresh_at_to_users',51),(267,'2022_03_28_185309_add_columns_in_business_accounts_table',51),(268,'2022_03_30_095128_add_column_grouping_slug_to_business_accounts',51),(269,'2022_03_31_143020_create_chance_distribution_transactions_table',51),(270,'2022_04_01_095128_create_user_summaries_table',51),(271,'2022_04_01_101400_rename_plant_token_transactions_to_point_transactions',52),(272,'2022_04_01_182025_add_business_id_to_daily_challenges_table',52),(273,'2022_04_04_123327_add_approval_related_columns_to_point_transactions',53),(274,'2022_04_04_221050_add_columns_to_dstw_items_table',53),(275,'2022_04_06_152240_add_business_account_id_to_questions_table',53),(277,'2022_04_11_145002_add_unique_columns_to_daily_challenges_table',54),(278,'2022_04_12_210641_alter_user_twofa_column',55),(279,'2022_04_12_114237_alter_index_for_enterprise_solution_table',56),(280,'2022_04_13_185910_alter_index_for_enterprise_solution_table_2',57),(281,'2022_04_14_094306_alter_dstw_related_table',57),(282,'2022_04_19_110702_create_user_files_table',58),(283,'2022_04_19_134600_create_approvals_table',59),(284,'2022_04_25_133007_add_ocr_text_column_in_receipts_table',59),(285,'2022_04_25_142044_add_module_identifier_column_in_user_files_table',59),(286,'2022_04_26_103734_add_various_summ_columns_to_user_summaries',60),(287,'2022_04_26_115330_add_business_account_id_to_analytics_view',60),(288,'2022_04_27_123138_alter_struct_for_table_used_for_analystic',60),(289,'2022_04_29_111352_create_business_account_summaries_table',61),(290,'2022_04_29_152155_alter_struct_for_table_used_for_analystic2',61),(291,'2022_05_05_151405_add_column_status_to_table_questions',62),(292,'2022_05_06_095800_add_approval_info_columns_to_dstw_entry_statuses',63),(293,'2022_05_05_155835_add_qr_code_file_url_column_in_business_assets_table',64),(294,'2022_05_06_133454_alter_struct_for_table_used_for_analystic3',65),(295,'2022_04_28_141733_add_business_account_id_in_notification_templates_table',66),(296,'2022_05_13_132606_add_details_column_to_dstw_items_table',67),(297,'2022_05_13_133308_add_updated_at_to_user_question_details',68),(298,'2022_05_13_134325_update_business_account_id_in_notification_templates_table',68),(299,'2022_05_14_171815_add_updated_at_to_qr_scan_logs',69),(300,'2022_05_14_184215_add_last_blast_log_date_to_user_summaries',69),(301,'2022_05_17_132839_add_description_order_column_in_notification_templates_table',70),(302,'2022_05_17_135549_add_shortname_column_in_daily_challenges_table',70),(303,'2022_05_18_110733_add_column_first_onboard_module_to_user_summaries',71),(304,'2022_05_18_121748_create_raw_keywords_table',71),(305,'2022_05_18_181024_alter_struct_receipt_entries',72),(306,'2022_05_25_105226_create_domains_table',73),(307,'2022_05_25_110400_create_external_a_p_is_table',73),(308,'2022_05_25_110538_create_subdomains_table',73),(316,'2022_05_25_093911_create_event_tag_categories_table',74),(317,'2022_05_25_093922_create_event_tag_type_slugs_table',74),(318,'2022_05_25_093923_create_event_tag_types_table',74),(319,'2022_05_25_102224_create_user_event_tags_table',74),(320,'2022_05_27_162906_add_approval_user_id_to_transaction_table',74),(321,'2022_05_31_184623_add_group_columns_to_analytics_bi_summaries_table',74),(322,'2022_06_01_143937_add_total_voucher_download_to_user_summaries',74),(323,'2022_06_03_141839_add_module_into_table_user_event_tags',75),(324,'2022_06_08_094239_add_modal_type_column_to_transaction_related_table',76),(325,'2022_06_08_142459_add_business_account_id_to_audit_revisions',77),(326,'2022_06_08_221125_create_user_daily_challenge_reward_summaries_table',78),(327,'2022_06_10_181242_add_dstw_entry_status_id_to_user_daily_challenges',79),(328,'2022_06_12_164750_create_daily_check_in_summaries_table',79),(329,'2022_06_13_120704_add_module_model_type_to_user_files',79),(330,'2022_06_13_160149_add_slug_index_to_event_tag_type_slugs',79),(331,'2022_06_14_145631_add_column_avg_transaction_amount_to_transaction_items',80),(332,'2022_06_13_133955_add_column_receipt_url_in_receipt_entries_table',81),(333,'2022_06_15_112542_add_promotion_type_column_in_voucher_series_table',81),(334,'2022_06_15_111606_create_voucher_series_summaries_table',82),(335,'2022_06_16_102617_add_transaction_code_to_transactions',82),(336,'2022_06_16_133246_create_jobs_table',82),(337,'2022_06_16_133303_create_failed_jobs_table',82),(338,'2022_06_16_143924_add_serial_index_to_vouchers',82),(353,'2022_06_17_094816_create_user_session_logs_table',83),(354,'2022_06_17_122533_create_user_active_sessions_table',83),(355,'2022_06_28_162905_add_is_agency_to_business_accounts',84),(356,'2022_07_03_162032_add_creation_info_columns_to_business_accounts',85),(357,'2022_07_01_161958_add_columns_to_user_session_logs',86),(358,'2022_07_07_154310_add_anonymous_user_to_user_active_sessions',87),(359,'2022_07_08_144850_add_unique_index_to_business_accounts',88),(360,'2022_07_08_165651_add_alias_to_business_accounts',89),(361,'2022_07_13_193534_create_user_utm_tracks_table',90),(362,'2022_07_15_120322_add_label_to_roles',91),(364,'2022_07_14_143529_create_user_event_tag_stats_table',92),(365,'2022_07_18_103935_add_status_to_business_accounts',93),(366,'2022_07_20_104100_add_index_to_user_addresses',94),(368,'2022_07_19_170952_create_billing_period_logs_table',95),(369,'2022_07_25_190643_add_index_to_blast_related_table',96),(370,'2022_08_11_115841_create_webhook_logs_table',97),(371,'2022_08_15_130415_add_src_receipt_info_to_receipt_entries',97),(372,'2022_09_06_103026_add_index_to_approval_table',98),(373,'2022_09_02_152814_create_custom_pop_up_settings_table',99),(374,'2022_09_12_153747_add_expired_at_to_chance_distribution_transactions',100),(375,'2022_09_19_144250_add_challenge_question_to_questions',101),(376,'2022_09_28_094745_update_is_private_default_val_to_voucher_series',102),(377,'2022_09_26_110807_create_raw_receipts_table',103),(378,'2022_10_12_153403_add_doc_ai_json_to_raw_receipts',104),(379,'2022_11_10_095419_add_item_group_to_dstw_items',105),(380,'2022_11_11_011758_alter_columns_to_nullable_in_sso_tokens_table',105),(381,'2022_11_12_145010_add_column_transaction_uid_in_chance_distribution_transactions',105),(382,'2022_11_14_163532_create_api_logs_table',105),(383,'2022_11_25_101931_alter_index_in_receipt_entries',105),(384,'2022_12_16_095109_add_column_register_at_to_users',105),(385,'2023_01_17_190432_add_soft_delete_to_transaction_items',105),(386,'2023_01_19_102755_alter_smart_receipt_related_table',105),(387,'2023_02_09_145124_add_address_related_column_to_dstw_items',105),(388,'2023_02_21_093143_create_generic_taggables_table',105),(389,'2023_03_07_114946_add_uploaded_at_to_receipt_entries',105),(390,'2023_03_10_142006_add_ip_address_to_ocr_request_logs',105),(391,'2023_04_07_120243_add_whatsapp_to_blasts',105),(392,'2023_04_12_120233_create_ocr_criteria_configs_table',105),(393,'2023_05_05_110141_create_receipt_entry_user_inputs_table',105),(394,'2023_05_26_092908_create_asset_paths_table',105),(395,'2023_05_31_092234_support_dsc_challenge_requirements',105),(396,'2023_05_31_160822_update_stampcard_module_tables',105),(397,'2023_06_01_155951_add_attemps_column_in_blast_recipient_table',105),(398,'2023_06_05_184025_create_voucher_distribution_transactions_table',105),(399,'2023_06_05_191349_alter_user_summaries_table_add_column_total_voucher_provisioned',105),(400,'2023_06_06_142731_create_bonus_modules_table',105),(401,'2023_06_06_214914_create_dsc_tables',105),(402,'2023_06_09_181718_add_grid_image_column_to_dsc_grid_table',105),(403,'2023_06_12_103245_alter_notification_add_cta_target_noti_info',105),(404,'2023_06_14_144344_create_user_device_infos_table',105),(405,'2023_06_15_182230_add_pii_into_user_addresses',105),(406,'2023_06_27_103935_create_user_unsubscriptions_table',105),(407,'2023_07_03_142546_create_pivot_challenges_table',105),(408,'2023_07_07_094402_create_store_types_table',105),(409,'2023_07_11_094337_alter_add_use_by_date_days_to_voucher_series',105),(410,'2023_07_12_151935_create_dstw_item_multipliers_table',105),(411,'2023_07_18_095412_create_dstw_item_vouchers_table',105),(412,'2023_07_18_160250_add_column_max_download_per_series_per_user_in_voucher_series_table',105),(413,'2023_07_18_162632_add_column_allow_download_after_expired_to_voucher_series_table',105),(414,'2023_07_21_115742_add_allow_download_after_used_column_to_voucher_series_table',105),(415,'2023_07_21_154621_add_notif_sms_column_to_voucher_series_table',105),(416,'2023_07_24_145339_add_model_type_column_into_notification_templates',105),(417,'2023_08_01_175818_add_full_address_column_to_business_assets_table',105),(418,'2023_08_03_101715_alter_action_link_column_in_banner_settings_table',105),(419,'2023_08_15_164649_add_receipt_summ_columns_in_user_summaries_table',105),(420,'2023_08_23_143622_create_pivot_date_formats_table',105),(421,'2023_08_29_124109_create_user_short_links_table',105),(422,'2023_08_29_162150_update_dsc_grid_for_chinese_support',105),(423,'2023_09_01_102027_create_dstw_item_slots_table',105),(424,'2023_09_12_093023_add_textract_json_to_raw_receipts',105),(425,'2023_09_19_121726_create_ocr_request_log_variants',105),(426,'2023_09_19_131523_update_dsc_user_cards_columns',105),(427,'2023_09_22_161211_alter_dyn_redeem_code_tbl',105),(428,'2023_10_14_020713_update_dsc_grid_for_chinese_support_title',105),(429,'2023_10_18_225534_add_additional_fields_to_receipt_entry_ocr_summaries_table',105),(430,'2023_10_27_003703_add_analytics_column_to_receipt_entry_product_relations_table',105),(431,'2023_11_01_094526_update_users_table_for_passcode_registrations',105),(432,'2023_11_06_141952_add_year_col_to_users_table',105),(433,'2023_11_15_144020_add_group_column_in_dstw_item_vouchers_table',105),(434,'2024_01_10_184401_create_menuses_table',105),(435,'2024_01_19_144834_create_business_account_details_table',105),(436,'2024_01_19_144834_create_business_account_groups_table',105),(437,'2024_01_19_144835_add_color_column_in_menus_table',105),(438,'2024_03_04_231359_add_birth_month_and_birth_year_fields_to_users_table',105),(439,'2024_03_13_162452_add_qualifying_spend_total_column_to_receipt_entry_ocr_summaries_table',105),(440,'2024_03_18_184344_alter_name_column_in_products_table',105),(441,'2024_04_30_182051_add_image_column_in_business_account_details_table',105),(442,'2024_04_30_183043_delete_addiotnal_column_in_business_account_details',105),(443,'2024_06_03_172516_add_is_admin_email_column_in_notification_templates',105),(444,'2024_06_07_190848_add_product_group_id_to_products_table',105),(445,'2024_06_07_205456_add_product_group_id_to_stores_table',105),(446,'2024_06_15_002321_add_foreign_key_constraint_to_product_group_id_in_products_table',105),(447,'2024_06_15_002343_add_foreign_key_constraint_to_product_group_id_in_stores_table',105),(448,'2024_07_01_021613_create_reward_group_table',105),(449,'2024_07_19_123905_alter_columns_notification_templates_in_voucher_series_table',105),(450,'2024_07_25_143429_add_column_status_messages_in_dsc_grids_table',105),(451,'2024_07_26_140852_add_column_grid_completion_limit_in_dsc_grid_table',105),(452,'2024_07_30_172839_add_column_rejected_grid_message_in_dsc_grids_table',105),(453,'2024_08_07_164110_create_import_merchant_and_product_logs_table',105),(454,'2024_08_15_144018_move_hostname_column_to_after_id_in_business_accounts_table',105),(455,'2024_09_02_125301_create_verification_codes_table',105),(456,'2024_09_18_162900_create_user_notifications_table',105),(457,'2024_09_19_103150_alter_content_column_in_notification_logs',105),(458,'2024_09_24_211847_add_column_skale_vlm_json_in_raw_receipts_table',105),(459,'2024_10_03_175025_create_user_fund_transfer_details',105),(460,'2024_10_14_171510_add_is_pool_in_voucher_series_table',105),(461,'2024_10_17_132642_add_foreign_index_in_voucher_series_table',105),(462,'2024_10_17_133202_create_voucher_series_limit_schedules_table',105),(463,'2024_10_22_164247_add_column_last_name_to_users_table',105),(464,'2024_10_23_172341_add_extra_fields_to_receipt_entry_user_inputs_table',105),(465,'2024_10_25_170456_add_additional_fields_to_receipt_entries_table',105),(466,'2024_11_05_120955_create_sessions_table',105),(467,'2024_11_11_144008_create_game_session_states_table',105),(468,'2024_12_03_112357_add_provisioned_voucher_to_game_session_states_table',105),(469,'2024_12_16_152459_create_variants_table',105),(470,'2024_12_16_152505_create_variant_values_table',105),(471,'2024_12_16_152513_create_variant_combinations_table',105),(472,'2024_12_18_184840_add_variant_combination_id_to_vouchers_table',105),(473,'2025_01_06_002116_add_user_address_id_to_vouchers_table',105),(474,'2025_01_06_002412_add_city_to_user_addresses_table',105),(475,'2025_01_09_125151_create_tags_table',105),(476,'2025_01_09_130635_create_tag_users_table',105),(477,'2025_01_09_131957_create_tag_receipts_table',105),(478,'2025_01_09_153709_create_draw_tables',105),(479,'2025_01_10_161444_add_business_account_id_to_tags_table',105),(480,'2025_01_12_170557_add_google_analytics_cookies_to_user_utm_tracks_table',105),(481,'2025_01_22_001634_add_type_to_user_addresses_table',105),(482,'2025_04_05_135400_add_wa_username_to_users_table',105),(484,'2026_04_14_172033_add_wa_bsuid_to_users_table',106);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` int unsigned NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` VALUES (4,'App\\User',1),(5,'App\\User',1),(4,'App\\User',2),(5,'App\\User',2),(8,'App\\User',2),(4,'App\\User',8),(5,'App\\User',8),(8,'App\\User',8);

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` int unsigned NOT NULL,
  `model_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\User',1),(4,'App\\User',1),(1,'App\\User',2),(4,'App\\User',2),(1,'App\\User',8),(4,'App\\User',8);

--
-- Table structure for table `modules`
--

CREATE TABLE `modules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'disabled',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `modules_business_account_id_index` (`business_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `modules`
--


--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `request_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `newsletters`
--


--
-- Table structure for table `notification_logs`
--

CREATE TABLE `notification_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_logs_template_slug(11)_index` (`template_slug`(11)),
  KEY `notification_logs_user_id_index` (`user_id`),
  KEY `notification_logs_type(2)_status(4)_user_id_index` (`type`(2),`status`(4),`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_logs`
--

INSERT INTO `notification_logs` VALUES (1,8,'6363','receipt_approval_approved','whatsapp','{\"locale\":\"en\",\"template_slug\":\"UserName Testing Upload Receipt Approved\",\"recipient_mobile\":\"63\",\"parameters\":{\"number_of_chance\":1,\"number_of_points\":0,\"number_of_voucher\":0,\"use_voucher_link\":\"-\",\"login_url\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/uid\\/T16ZM2JP04\"}}','sent','2026-05-12 04:06:28','2026-05-12 04:06:28'),(2,8,'6363','receipt_approval_approved','whatsapp','{\"locale\":\"en\",\"template_slug\":\"UserName Testing Upload Receipt Approved\",\"recipient_mobile\":\"63\",\"parameters\":{\"number_of_chance\":1,\"number_of_points\":0,\"number_of_voucher\":0,\"use_voucher_link\":\"-\",\"login_url\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/uid\\/T16ZM2JP04\"}}','sent','2026-05-12 04:23:05','2026-05-12 04:23:05'),(3,8,'6363','receipt_approval_approved','whatsapp','{\"locale\":\"en\",\"template_slug\":\"UserName Testing Upload Receipt Approved\",\"recipient_mobile\":\"63\",\"parameters\":{\"number_of_chance\":1,\"number_of_points\":0,\"number_of_voucher\":0,\"use_voucher_link\":\"-\",\"login_url\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/uid\\/T16ZM2JP04\"}}','sent','2026-05-12 05:15:53','2026-05-12 05:15:53'),(4,8,'6363','receipt_approval_approved','whatsapp','{\"locale\":\"en\",\"template_slug\":\"UserName Testing Upload Receipt Approved\",\"recipient_mobile\":\"63\",\"parameters\":{\"number_of_chance\":1,\"number_of_points\":0,\"number_of_voucher\":0,\"use_voucher_link\":\"-\",\"login_url\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/uid\\/T16ZM2JP04\"}}','sent','2026-05-12 05:31:48','2026-05-12 05:31:48'),(5,8,'@wi**********ne','receipt_approval_approved','whatsapp','{\"locale\":\"en\",\"template_slug\":\"UserName Testing Upload Receipt Approved\",\"recipient_mobile\":\"@wilson_nophone\",\"parameters\":{\"number_of_chance\":1,\"number_of_points\":0,\"number_of_voucher\":0,\"use_voucher_link\":\"-\",\"login_url\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/uid\\/T16ZM2JP04\"}}','sent','2026-05-12 05:47:26','2026-05-12 05:47:26'),(6,8,'@wi**********ne','receipt_approval_approved','whatsapp','{\"locale\":\"en\",\"template_slug\":\"UserName Testing Upload Receipt Approved\",\"recipient_mobile\":\"@wilson_nophone\",\"parameters\":{\"number_of_chance\":1,\"number_of_points\":0,\"number_of_voucher\":0,\"use_voucher_link\":\"-\",\"login_url\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/uid\\/T16ZM2JP04\"}}','sent','2026-05-12 05:50:15','2026-05-12 05:50:15'),(7,8,'@wi**********ne','receipt_approval_approved','whatsapp','{\"locale\":\"en\",\"template_slug\":\"UserName Testing Upload Receipt Approved\",\"recipient_mobile\":\"@wilson_nophone\",\"parameters\":{\"number_of_chance\":1,\"number_of_points\":0,\"number_of_voucher\":0,\"use_voucher_link\":\"-\",\"login_url\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/uid\\/T16ZM2JP04\"}}','sent','2026-05-12 08:23:19','2026-05-12 08:23:19'),(8,8,'@wi**********ne','receipt_approval_approved','whatsapp','{\"locale\":\"en\",\"template_slug\":\"UserName Testing Upload Receipt Approved\",\"recipient_mobile\":\"@wilson_nophone\",\"parameters\":{\"number_of_chance\":1,\"number_of_points\":0,\"number_of_voucher\":0,\"use_voucher_link\":\"-\",\"login_url\":\"https:\\/\\/wa-username-testing.growthdesk.dev\\/uid\\/T16ZM2JP04\"}}','sent','2026-05-13 09:09:25','2026-05-13 09:09:25');

--
-- Table structure for table `notification_template_unsubscribes`
--

CREATE TABLE `notification_template_unsubscribes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `template_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `notification_template_unsubscribes_template_id_user_id_index` (`template_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_template_unsubscribes`
--


--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL,
  `cta_action` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cta_target` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_id` bigint DEFAULT NULL,
  `admin_email_to` text COLLATE utf8mb4_unicode_ci,
  `admin_email_cc` text COLLATE utf8mb4_unicode_ci,
  `admin_email_bcc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `business_account_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `account_slug_type_index` (`business_account_id`,`slug`(20),`type`(6))
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_templates`
--

INSERT INTO `notification_templates` VALUES (1,'welcome_with_otp_retry','sms',NULL,'WA Username Test: OTP: {{otp_code}} Thank you for registering with us! Enter the OTP or verify via this link: {{login_url}}',0,NULL,NULL,'en','active','Sent upon registration with OTP password for mobile verification ',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(2,'welcome_with_otp','sms',NULL,'WA Username Test: {{otp_code}} Thank you for registering with us! Enter the OTP or verify via this link: {{login_url}}',0,NULL,NULL,'en','active','Sent upon registration with OTP password for mobile verification ',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(3,'user_relogin','sms',NULL,'WA Username Test: Login to your account via this link: {{login_url}}',0,NULL,NULL,'en','active','Sent when user is logged out and attempts to relogin to platform',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(4,'user_login_via_otp','sms',NULL,'WA Username Test: Your OTP To Login is: {{otp_code}}',0,NULL,NULL,'en','active','Sent when user is logged out and attempts to relogin to platform via OTP',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(5,'receipt_approval_approved','sms',NULL,'WA Username Test: Your receipt has been approved. Login to your account via this link:{{login_url}}',0,NULL,NULL,'en','inactive','Shown when receipt uploaded is approved ',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(6,'receipt_approval_approved','in-app',NULL,'WA Username Test: Your receipt has been approved.',0,NULL,NULL,'en','inactive','Shown when receipt uploaded is approved ',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(7,'receipt_approval_rejected','in-app',NULL,'WA Username Test: Your receipt has been rejected.',0,NULL,NULL,'en','inactive','Shown when receipt uploaded is rejected ',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(8,'referral_success','in-app',NULL,'WA Username Test: Congratulations! Someone registered using your referral link. You have been credited with additional tokens.',0,'referral',NULL,'en','active','Shown when user successfully refers new prospect and prospect registers for platform',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(9,'referral_limit_reached','in-app',NULL,'WA Username Test: You have reached the maximum referral reward limit of {{limit}}. Thank you for spreading the word!',0,NULL,NULL,'en','active','Shown when referrer reaches maximum referral reward limit',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(10,'main_game_reward','in-app',NULL,'',0,NULL,NULL,'en','inactive','Shown when user played main game regardless of win or lose',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(11,'main_game_reward_won','in-app',NULL,'',0,NULL,NULL,'en','inactive','Shown when user played main game and win the game',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(12,'main_game_reward_lose','in-app',NULL,'',0,NULL,NULL,'en','inactive','Shown when user played main game and lose the game',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(13,'bonus_reward_voucher_provisioning','in-app',NULL,'',0,NULL,NULL,'en','inactive','Shown when user received reward by completed X number of grid',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(14,'upon_check_in','in-app',NULL,'',0,NULL,NULL,'en','inactive','Shown when user successfully check in',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(15,'upon_big_giveaway_challenge','in-app',NULL,'',0,NULL,NULL,'en','inactive','Shown when user successfully scan a QR code',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(16,'upon_login','in-app',NULL,'',0,NULL,NULL,'en','inactive','Shown when user successfully login',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(17,'receipt_approval_approved','whatsapp',NULL,'UserName Testing Upload Receipt Approved',0,NULL,NULL,'en','active','Shown when receipt uploaded is approved ',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1),(18,'receipt_approval_rejected','whatsapp',NULL,'UserName Testing Upload Receipt Rejected',0,NULL,NULL,'en','active','Shown when receipt uploaded is rejected ',NULL,NULL,NULL,NULL,NULL,'2026-04-07 06:36:24','2026-04-07 06:36:24',1);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `issue_module` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cta_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cta_target` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_date` date NOT NULL,
  `issue_time` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_cta_clicked` tinyint(1) NOT NULL DEFAULT '0',
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `is_notify` tinyint(1) NOT NULL DEFAULT '0',
  `notification_template_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_issue_module_user_id_index` (`issue_module`,`user_id`),
  KEY `notifications_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `client_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--


--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--


--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `ocr_criteria_configs`
--

CREATE TABLE `ocr_criteria_configs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `upload_date_from` date NOT NULL,
  `upload_date_to` date NOT NULL,
  `receipt_date_from` date NOT NULL,
  `receipt_date_to` date NOT NULL,
  `data_setting_json` longtext COLLATE utf8mb4_unicode_ci,
  `reward_setting_json` longtext COLLATE utf8mb4_unicode_ci,
  `configurable_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `configurable_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `upload_period_index` (`business_account_id`,`upload_date_from`,`upload_date_to`),
  KEY `configurable_index` (`configurable_type`,`configurable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ocr_criteria_configs`
--


--
-- Table structure for table `ocr_job_requests`
--

CREATE TABLE `ocr_job_requests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_account_id` bigint unsigned NOT NULL,
  `service_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempt_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `job_uuid` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `requester_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `requester_id` bigint unsigned DEFAULT NULL,
  `ocr_request_log_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `main_index` (`business_account_id`,`uuid`),
  KEY `requester_index` (`requester_type`,`requester_id`),
  KEY `ocr_job_requests_ocr_request_log_id_index` (`ocr_request_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ocr_job_requests`
--


--
-- Table structure for table `ocr_keywords`
--

CREATE TABLE `ocr_keywords` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ocr_keywords_business_account_id_type_index` (`business_account_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ocr_keywords`
--


--
-- Table structure for table `ocr_negative_keywords`
--

CREATE TABLE `ocr_negative_keywords` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keyword` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ocr_negative_keywords`
--


--
-- Table structure for table `ocr_request_log_variants`
--

CREATE TABLE `ocr_request_log_variants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ocr_request_log_id` bigint unsigned NOT NULL,
  `service_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ocr_result` longtext COLLATE utf8mb4_unicode_ci,
  `process_time_took` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ocr_request_log_variants_ocr_request_log_id_index` (`ocr_request_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ocr_request_log_variants`
--


--
-- Table structure for table `ocr_request_logs`
--

CREATE TABLE `ocr_request_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `raw_receipt_id` bigint unsigned NOT NULL,
  `ocr_result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `user_id` bigint unsigned DEFAULT NULL,
  `service_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `process_time_took` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `response_time_took` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `response_payload` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_hybrid` tinyint(1) NOT NULL DEFAULT '0',
  `is_internal` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ocr_request_logs_business_account_id_index` (`business_account_id`),
  KEY `ocr_request_logs_raw_receipt_id_index` (`raw_receipt_id`),
  KEY `ocr_request_logs_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ocr_request_logs`
--


--
-- Table structure for table `ocr_samples`
--

CREATE TABLE `ocr_samples` (
  `id` int NOT NULL AUTO_INCREMENT,
  `receipt_url` text NOT NULL,
  `requirements` text,
  `image_to_text` text NOT NULL,
  `remark` text NOT NULL,
  `ocr_result` longtext,
  `receipt_uid` varchar(20) DEFAULT NULL,
  `retail_partner` varchar(50) DEFAULT NULL,
  `dsc_merchant_sn_detected` int DEFAULT NULL,
  `dsc_merchant_sid_expected` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ocr_samples_dsc_merchant_sn_detected_index` (`dsc_merchant_sn_detected`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ocr_samples`
--


--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'menu access permission','web','2022-06-30 14:18:29','2022-06-30 14:18:29'),(2,'all asset sub menu access','web','2022-06-30 14:18:29','2022-06-30 14:18:29'),(3,'verify asset sub menu access','web','2022-06-30 14:18:29','2022-06-30 14:18:29'),(4,'blast-btn-send-test','web','2022-07-25 08:20:31','2022-07-25 08:20:31'),(5,'blast-btn-create-schedule','web','2022-07-25 08:20:32','2022-07-25 08:20:32'),(6,'customise-project','web','2026-04-07 06:34:04','2026-04-07 06:34:04'),(7,'can-create-project','web','2026-04-07 06:34:04','2026-04-07 06:34:04'),(8,'can-manage-smart-receipt-service','web','2026-04-07 06:34:04','2026-04-07 06:34:04'),(9,'can-manage-smart-receipt-engine','web','2026-04-07 06:34:04','2026-04-07 06:34:04');

--
-- Table structure for table `pivot_challenges`
--

CREATE TABLE `pivot_challenges` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `challenge_id` bigint unsigned NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `reward_details` text COLLATE utf8mb4_unicode_ci,
  `setting_details` text COLLATE utf8mb4_unicode_ci,
  `pivot_details` longtext COLLATE utf8mb4_unicode_ci,
  `order` int DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `foreign_link_index` (`model_type`,`model_id`),
  KEY `pivot_challenges_challenge_id_index` (`challenge_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pivot_challenges`
--


--
-- Table structure for table `pivot_date_formats`
--

CREATE TABLE `pivot_date_formats` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `dateable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dateable_id` bigint unsigned NOT NULL,
  `format_json` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dateable_index` (`dateable_type`,`dateable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pivot_date_formats`
--


--
-- Table structure for table `plant_growth_token_transactions`
--

CREATE TABLE `plant_growth_token_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `receipt_uid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `num_token_issued` decimal(8,2) NOT NULL DEFAULT '0.00',
  `issue_datetime` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plant_growth_token_transactions_user_id_id_index` (`user_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plant_growth_token_transactions`
--


--
-- Table structure for table `plant_summary_user_plant_progress`
--

CREATE TABLE `plant_summary_user_plant_progress` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `plant_user_plant_id` int unsigned NOT NULL,
  `progress_date` date NOT NULL,
  `progress_earned` decimal(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plant_summary_user_plant_progress_plant_user_plant_id_index` (`plant_user_plant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plant_summary_user_plant_progress`
--


--
-- Table structure for table `plant_supplement_transactions`
--

CREATE TABLE `plant_supplement_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `plant_supplement_id` int unsigned NOT NULL,
  `plant_user_plant_id` int unsigned NOT NULL,
  `trans_amount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `trans_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `issue_date` date NOT NULL,
  `issue_time` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `issue_module` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `trans_link_model` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trans_link_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plant_supplement_transactions_plant_supplement_id_index` (`plant_supplement_id`),
  KEY `user_plant_supplement_idx` (`plant_user_plant_id`,`plant_supplement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plant_supplement_transactions`
--


--
-- Table structure for table `plant_supplements`
--

CREATE TABLE `plant_supplements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `img_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img_token_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_unit_per_day` int unsigned NOT NULL,
  `max_unit_per_day` int unsigned NOT NULL,
  `token_per_refill` decimal(8,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `sorting` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plant_supplements_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plant_supplements`
--


--
-- Table structure for table `plant_user_plants`
--

CREATE TABLE `plant_user_plants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `plant_growth_token_id` int unsigned DEFAULT NULL,
  `plant_seed_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `plant_progress` decimal(8,2) NOT NULL,
  `plant_level` int unsigned NOT NULL,
  `plant_growth_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plant_user_plants_user_id_index` (`user_id`),
  KEY `plant_user_plants_plant_growth_token_id_index` (`plant_growth_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plant_user_plants`
--


--
-- Table structure for table `plant_user_summary_progress`
--

CREATE TABLE `plant_user_summary_progress` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `growth_token_balance` decimal(8,2) NOT NULL DEFAULT '0.00',
  `supplement_balance_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `plugin_interact_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_interact_at` datetime DEFAULT NULL,
  `reset_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `plant_user_summary_progress_user_id_unique` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plant_user_summary_progress`
--


--
-- Table structure for table `plant_users`
--

CREATE TABLE `plant_users` (
  `sn` int NOT NULL AUTO_INCREMENT,
  `mobile_verified` tinyint(1) NOT NULL DEFAULT '0',
  `user_uid` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_email` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_mobile` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_email_masked` text NOT NULL,
  `user_mobile_masked` text NOT NULL,
  `user_avatar` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `dob` date DEFAULT NULL,
  `state` varchar(191) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `user_membership_id` text CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `membership_synced_date` datetime DEFAULT NULL,
  `is_membership_auto_sync_mode` tinyint(1) DEFAULT NULL,
  `user_details` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_progress` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `user_reg_timestamp` timestamp NULL DEFAULT NULL,
  `user_last_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_last_active_timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_last_use_timestamp` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_verified_timestamp` timestamp NULL DEFAULT NULL,
  `user_activated_timestamp` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`sn`),
  KEY `plant_users_user_uid(6)_index` (`user_uid`(6))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `plant_users`
--


--
-- Table structure for table `point_transactions`
--

CREATE TABLE `point_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `trans_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `trans_amount` decimal(8,2) NOT NULL,
  `trans_remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `issue_date` date NOT NULL,
  `issue_time` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `issue_module` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_auto_approved` tinyint NOT NULL DEFAULT '1',
  `approval_at` timestamp NULL DEFAULT NULL,
  `approver_user_id` bigint unsigned DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `trans_link_model` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trans_link_id` bigint unsigned DEFAULT NULL,
  `forfeit_link_model` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forfeit_link_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `plant_token_transactions_user_id_trans_type_index` (`user_id`,`trans_type`),
  KEY `user_status_index` (`status`,`user_id`),
  KEY `foreign_link_index` (`status`,`trans_type`,`trans_link_id`),
  KEY `point_transactions_approver_user_id_index` (`approver_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `point_transactions`
--


--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `user_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_categories_business_account_id_index` (`business_account_id`),
  KEY `product_categories_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--


--
-- Table structure for table `product_categories_voucher_series_relation`
--

CREATE TABLE `product_categories_voucher_series_relation` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `voucher_series_id` int NOT NULL,
  `category_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories_voucher_series_relation`
--


--
-- Table structure for table `product_groups`
--

CREATE TABLE `product_groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_groups_business_account_id_slug(6)_index` (`business_account_id`,`slug`(6))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_groups`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_group_slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `negative_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `point` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `retail_partner` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `discounted_price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rrp` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sku` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ocr_criteria_json` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `product_group_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_product_group_slug_index` (`product_group_slug`),
  KEY `products_product_group_id_index` (`product_group_id`),
  FULLTEXT KEY `name` (`name`),
  CONSTRAINT `products_product_group_id_foreign` FOREIGN KEY (`product_group_id`) REFERENCES `product_groups` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `qr_scan_logs`
--

CREATE TABLE `qr_scan_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `qr_key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `qr_value` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_date` date NOT NULL,
  `created_time` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `source_model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source_model_id` bigint unsigned NOT NULL,
  `user_daily_challenge_id` bigint unsigned DEFAULT NULL,
  `file_hash` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `qr_scan_logs_user_id_qr_key(10)_index` (`user_id`,`qr_key`(10)),
  KEY `source_model_index` (`source_model_type`,`source_model_id`),
  KEY `qr_scan_logs_user_daily_challenge_id_index` (`user_daily_challenge_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qr_scan_logs`
--


--
-- Table structure for table `question_choices`
--

CREATE TABLE `question_choices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `question_id` int unsigned NOT NULL,
  `choice_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `choice_img_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_choices_question_id_index` (`question_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `question_choices`
--

INSERT INTO `question_choices` VALUES (1,1,'Egg',NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(2,1,'Heart',NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(3,1,'Head',NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(4,1,'Brain',NULL,'2026-04-07 06:36:25','2026-04-07 06:36:25'),(5,2,'Cat',NULL,'2026-04-13 09:10:24','2026-04-13 09:10:24'),(6,2,'Dog',NULL,'2026-04-13 09:10:24','2026-04-13 09:10:24'),(7,2,'Both',NULL,'2026-04-13 09:10:24','2026-04-13 09:10:24'),(8,2,'Neither',NULL,'2026-04-13 09:10:24','2026-04-13 09:10:24'),(9,6,'<1 year',NULL,'2026-04-16 00:12:50','2026-04-16 00:12:50'),(10,6,'1-5 years',NULL,'2026-04-16 00:12:50','2026-04-16 00:12:50'),(11,6,'5-10 years',NULL,'2026-04-16 00:12:51','2026-04-16 00:12:51'),(12,6,'10 years+',NULL,'2026-04-16 00:12:51','2026-04-16 00:12:51'),(13,7,'Yes',NULL,'2026-04-16 00:12:51','2026-04-16 00:12:51'),(14,7,'No',NULL,'2026-04-16 00:12:51','2026-04-16 00:12:51');

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `business_account_id` bigint unsigned NOT NULL,
  `question_title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `question_choice_id` int unsigned DEFAULT NULL,
  `daily_challenge_id` bigint unsigned DEFAULT NULL,
  `setting_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `questions_question_choice_id_index` (`question_choice_id`),
  KEY `questions_business_account_id_status(3)_index` (`business_account_id`,`status`(3))
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` VALUES (1,1,'What has to be broken before you can use it!',1,NULL,NULL,'active','2026-04-07 06:36:25','2026-04-07 06:36:25'),(2,1,'Are you a cat or a dog person?',NULL,NULL,NULL,'active','2026-04-13 09:10:24','2026-04-13 09:10:24'),(3,1,'Which pet clinic or pet expo did you register from? (Reply ‘NONE’ if you did not register from any.)',NULL,NULL,NULL,'active','2026-04-16 00:11:54','2026-04-16 00:11:54'),(4,1,'What is the breed of your pet?',NULL,NULL,NULL,'active','2026-04-16 00:12:14','2026-04-16 00:12:14'),(5,1,'What is the name of your pet? (Just reply your pet name)',NULL,NULL,NULL,'active','2026-04-16 00:12:50','2026-04-16 00:12:50'),(6,1,'How old is your pet?',NULL,NULL,NULL,'active','2026-04-16 00:12:50','2026-04-16 00:12:50'),(7,1,'Are you a multiple pet household? (more than 1 pet)',NULL,NULL,NULL,'active','2026-04-16 00:12:51','2026-04-16 00:12:51');

--
-- Table structure for table `raw_keywords`
--

CREATE TABLE `raw_keywords` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `raw_keywords_key_index` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `raw_keywords`
--

INSERT INTO `raw_keywords` VALUES (1,'user-name-word','eyJpdiI6ImMyaGxjbTl4ZFdWbGJtaGhhR0ZvWVE9PSIsInZhbHVlIjoiYWwyeE9Od2ZXMFwvdjZKamI5ZHVJUEE9PSIsIm1hYyI6Ijc0NzVmM2NiMWVkMGI3YWM4NzZlMmJmMzk0MGM4MWVkZWEyZmIyYTdhYjU3NjY4MDIxNTEwYzc3NGU1MmEyZjUifQ==','2022-11-09 03:05:34','2022-11-09 03:05:34'),(2,'user-name-word','eyJpdiI6ImMyaGxjbTl4ZFdWbGJtaGhhR0ZvWVE9PSIsInZhbHVlIjoiaWpsMG1vQWx1YWJhbDZwUUxMQ1NKdz09IiwibWFjIjoiYThhYWY3NjExOGM4OTZhZjU1NDVlNjQ3MTk0ZmUwMzFkNjU0MjFiMDQwMWJhOWNiNzMwMGE2MjU1MjZmNDliMSJ9','2022-11-09 03:05:34','2022-11-09 03:05:34'),(3,'user-email-word','eyJpdiI6ImMyaGxjbTl4ZFdWbGJtaGhhR0ZvWVE9PSIsInZhbHVlIjoiSlhXQnJ3akxmZkFpRzVvXC9lQ2FLQUE9PSIsIm1hYyI6IjVjZDI0YjkzNDM4ZjU1Mjc4NmRmYWE3NWVlZDFlYjZiNjZlMDk0ODM2OWQwZGIyMGY2NGFhNDUwNjBhYTY5ZGMifQ==','2022-11-09 03:05:34','2022-11-09 03:05:34'),(4,'user-email-word','eyJpdiI6ImMyaGxjbTl4ZFdWbGJtaGhhR0ZvWVE9PSIsInZhbHVlIjoiZWZlQmVxa2p1SFpIbGhnRUxpYWh3dz09IiwibWFjIjoiMDg3NTVlMzI3MzY0Nzk4N2JlZDVkNzk3ODlkOWQ5OTcxNjZkNzAzNDdiZjlmMmY3ODdmMGJhOWZiYzM0MDRkMiJ9','2022-11-09 03:05:34','2022-11-09 03:05:34'),(5,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiSFJlSmxFWmxaam9rT21xUzZrbHpEZz09IiwibWFjIjoiY2RjMjcxYjAyODY4MmU4MTU4NzkyOWQ0YTY3ODBmNjZjNTFmOGIzNTYyOTdhZTQzZjljZDBhYWQ2MTY5ZWU4NSJ9','2026-04-07 06:38:12','2026-04-07 06:38:12'),(6,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoieFQ1XC9aUldJNHBzY3JONTJxOXlXSUE9PSIsIm1hYyI6IjkyZmRmN2FkNWM0YTZkZTVkODhhMzM1NDljNWM5MTJjMGJjNGU3NDdmOWJlZDRkMWIzNzkwMTJjOGI1MDVjZmQifQ==','2026-04-07 06:38:12','2026-04-07 06:38:12'),(7,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiSGF3cDdzcG1NcXFiOFhTMUJRTDMydz09IiwibWFjIjoiZDY5ZDliZjU2NTYwMWFhNDcyMGY1OTZlMDljM2JkYTY0N2FiMDk3NTJmN2Y1MGMzM2U5YzAzMWExNDM3MTQ3ZCJ9','2026-04-07 06:38:12','2026-04-07 06:38:12'),(8,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiSEtweDJuTzNoTHY2dm5Ld2QyeDlUbWJCOFoxZmRCSWgxMld1UFwvMFV0VkxPdTZvRjJ1SjVaMTBoT2gwbXhuRmgxS0IrUGZqT0d0Z0QwUXl0MytXUUcreHJmVFp5TzBISW9UMlNsOGV5SzRBUXBMcmZPajhNbE9GV0RNTXpTQjlrU1N1ckhycThJbmhcL3R2SlVxa3dndlwvRk9rd2FIenNUeGhRMmlEK0ZcL0JYaWEzb0JCY0QwYmpENmVybDNwekxmWmZOOWc2ZUpzbTZKSUV2ajR1RFFaOVRGTkdqaVdrTDJLUUpxYldcL0MyTk5PWTVoWCtraHlURFVESmtzd1NDaElvV1FrWTBPZEU3NUVQYXlYSkJMRGxZUT09IiwibWFjIjoiY2YyZTkwNjNkZDhiOWFhZTY1NzkzMzM0YmU5MTEyZjcyYWIwNWI3NmY1OTI4MjA5ZDQ1YmZhZTNlODI1MTRjZCJ9','2026-04-07 07:02:48','2026-04-07 07:02:48'),(9,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoicmpoQ2ZBRFwvbmlRQlVqbWQyTEdkWkE9PSIsIm1hYyI6IjYzMjlhMTUxYTcxZjZlYzNiMzE1OGE5NjhlNDVlNTc4ZDU1MjQ5ZmE2M2I0OTA4NWI4MjAxNzg5NmZjOWViZWEifQ==','2026-04-07 07:02:48','2026-04-07 07:02:48'),(10,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoicElUSGVTTTNnYSs0Nkt5UVlOVGdzUT09IiwibWFjIjoiOGRjZWM0MjY3ZGU3MTk5ZmU2YWMxNzZiYzk4ZmJlNmRkZDdlM2MwYWQzNGJhZjU2OTEwNGI3OGU2OTEyYjVlYyJ9','2026-04-07 07:02:48','2026-04-07 07:02:48'),(11,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiMjl1Nmlmcml2RkFyaDE1Y1AzaXRTZz09IiwibWFjIjoiMzRjNzA4ZjQ0YzU1YWM2MTNjMDhjYjkxMGIyZjg5Y2JiZTM4Y2RlZDFkNzhiYTMzZjg5NjkwOTI0NWZjM2M4NCJ9','2026-04-07 07:14:17','2026-04-07 07:14:17'),(12,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiS0h6UFFlRzlYQVhZSmJzd1FWTzJmUT09IiwibWFjIjoiMmQ5YzE3MWE5NzE0MTdlOWRiYjFmNmNlMjgzYjcyNjY2N2Y0OWQxMTM4MzgxNGNjOGVjNDQzMTAyYWUyMTc2ZiJ9','2026-04-07 07:14:17','2026-04-07 07:14:17'),(13,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoidXFKd0RIY2VzY0V4VDl4XC9tc0hSRXc9PSIsIm1hYyI6ImVmZWY2ZDM3NzM2NjZhMjA5MDQ1ZTUxZjlhNGJlODczNmQ5NTI4OWYxOGQyNDllNjhkZWRlNTg0YmVmNzEyZjEifQ==','2026-04-07 07:14:17','2026-04-07 07:14:17'),(14,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiWmlyRTVDOFZia2tHQ3p6OGFia21jUT09IiwibWFjIjoiZTlmOGE0N2MzOTExNzQzMWU0M2YxYWY5YWU5ZWQ5ODg2MmIxZGIxZTc3NDk3Yzk2OTRjY2U3NjI0OTMxNzQ2OCJ9','2026-04-16 00:11:35','2026-04-16 00:11:35'),(15,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiWmlyRTVDOFZia2tHQ3p6OGFia21jUT09IiwibWFjIjoiZTlmOGE0N2MzOTExNzQzMWU0M2YxYWY5YWU5ZWQ5ODg2MmIxZGIxZTc3NDk3Yzk2OTRjY2U3NjI0OTMxNzQ2OCJ9','2026-04-16 00:11:41','2026-04-16 00:11:41'),(16,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiUHBWQzJsQ3NHUDV6R2R3a0ZkSUIwUT09IiwibWFjIjoiMDdhZjY5ZmJiODQ2NDk4MDAxNjRiOTE4ZDVhZDc1ZGYyOWE4ZGYyZDYzMzcwNDgxYzYyNDhmODk3YTQwYzIyOSJ9','2026-04-16 00:11:41','2026-04-16 00:11:41'),(17,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiT2JPVkdmMVwva2R3aXRCY1NrSGRWTXc9PSIsIm1hYyI6IjkwMGU0MjE5MjBlNjM1NjAwNGFmNTEwYzVlMTM5MDYzNDMwM2I1YTc3ZWM4YTQ5MmIwNDAyMmY3YTg0OTU2YzQifQ==','2026-04-16 03:16:49','2026-04-16 03:16:49'),(18,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiTEJ4K3B2SjF6TldHY01wK3dlV0dOdz09IiwibWFjIjoiZjEzOTRhY2Q5MjM2ZDIzOTVmNTIzOWI5OTg2YjQ0YjUxMzYwYzU0NmEwOTIzOGYyNTUzY2Q1YjAyMTM4ZDU2NCJ9','2026-04-16 03:17:10','2026-04-16 03:17:10'),(19,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiY25lNVlWNmxnZ1NsZXRRV2lKa3gzUT09IiwibWFjIjoiNTdkZWUzOGNiN2RmYmUwZjFhMzNmYzY2ZDhiZDM1NWZlYzBmYTQ4N2E5MWM0NWEzMTBlNjc3NjA1NTYyZjY1ZCJ9','2026-05-07 10:26:31','2026-05-07 10:26:31'),(20,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQVRtU05JWWxrM2Z5XC9ESzdUK2E4THc9PSIsIm1hYyI6IjFiOTMwZjM4YTQwZTk0MGUzZDA4OTQxMjdmYWQwNmIxMGQ5Nzg4ZDZjZTQxYjczOTdiYmU0YWI1YTkyNGYyZGQifQ==','2026-05-07 10:26:45','2026-05-07 10:26:45'),(21,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiOHRMQXRmQm9lMnJnbVhlUDI5aytyQT09IiwibWFjIjoiMDQ1ZTVhNTZlNjI0ZTZkZDkwMzc5MGNhYmEzN2Q2ZTgzNzczODEyYTVhMzVlNzdiNDA3OGQ5MjE3YjM3NjA4YyJ9','2026-05-07 10:26:45','2026-05-07 10:26:45'),(22,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiQXlSc1E4dkU4cjhva0NEM0NNblBBQT09IiwibWFjIjoiN2MwYmNjMTg0OWQzZGE0MzVmODA3NjYyNjYwZmM3NDc3ZGRiYmM4ZWZkYjc3ZGYyY2Q1ZjE4ZGFmNDI0ODM4NCJ9','2026-05-08 09:06:18','2026-05-08 09:06:18'),(23,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiRkk3Z01jUjJSMmhPbHByendDZ2Y1dz09IiwibWFjIjoiYWJiODY4ZWM0YTg3MDU3NTZiNjlkZGUyNzE3MGMyNTViMTYzNGM1ZGJkOWM4OTA0MzFiOGI4NDU5ZjZhN2UzYiJ9','2026-05-08 09:06:18','2026-05-08 09:06:18'),(24,'user-name-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiYm50SjFzTUZqYUxQUFY2bWxNNVwveWc9PSIsIm1hYyI6IjhhNzRhMzUyNmI5Y2JjYmY3NjdlNGMxZjdhZjJlNmQyNGM3MjNmOGYwMTUwODY2MWFhOWYzODRmNGRkOGM3ZjMifQ==','2026-05-08 09:06:18','2026-05-08 09:06:18'),(25,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiZWRQSjlOM1lERXFcLzRKMjBzTzJHR0E9PSIsIm1hYyI6ImM2ZjdlMWVhMjFhZDYxOTgyNWRhMzQzMDI0NmIzMzdhMzJlZDliZTRlY2Q3ZWQ2Y2JlNDNiODdhNTQ2YWE1MWYifQ==','2026-05-08 09:06:43','2026-05-08 09:06:43'),(26,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoiVFlpbjYrbjhoTmNIODlnXC9nTmswZHc9PSIsIm1hYyI6ImU0NDVhYzYxYWQxMjc1YjE4MmIzMjYwYTk1MWRjNmYxNmI4ZTkwMTUyMTZmZTY2NmRkNDdhYzMxNTk5MWRhZDUifQ==','2026-05-12 00:49:46','2026-05-12 00:49:46'),(27,'user-email-word','eyJpdiI6ImMydGhiR1V0Wlc1MGMyOHRNakF5TWc9PSIsInZhbHVlIjoibEN0eDBOTWozcXZUOE9YV0c2Y2VJZ2x2NEVUbE5rcDJySkdzd3pBRURVND0iLCJtYWMiOiI2MTllM2Q5ZjE0ZTlkZDk0MmM2Y2M1NWE0ZWNlMWJiNmYxZDgyMWVjNTU2OTcxNTJmNTE0MjcwYmNkNWUxNzM3In0=','2026-05-12 08:20:52','2026-05-12 08:20:52');

--
-- Table structure for table `raw_receipts`
--

CREATE TABLE `raw_receipts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `annotations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `doc_ai_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `textract_json` longtext COLLATE utf8mb4_unicode_ci,
  `skale_vlm_json` longtext COLLATE utf8mb4_unicode_ci,
  `ocr_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `formatted_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `parsed_result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `added_by_business_account_id` bigint unsigned DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `raw_receipts_hash(12)_index` (`hash`(12)),
  KEY `raw_receipts_added_by_business_account_id_index` (`added_by_business_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `raw_receipts`
--


--
-- Table structure for table `receipt_entries`
--

CREATE TABLE `receipt_entries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `module` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_identifier` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `business_asset_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `receipt_path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `receipt_url` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ocr_text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `merchants` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `products` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ocr_result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `transaction_amount` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ocr_appv_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `src_receipt_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `uploaded_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `outlet_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `receipt_entries_user_id_index` (`user_id`),
  KEY `receipt_entries_business_asset_id_index` (`business_asset_id`),
  KEY `receipt_entries_foreign_link_index` (`module`(20),`module_identifier`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `receipt_entries`
--

INSERT INTO `receipt_entries` VALUES (1,8,'daily_challenge','34','1','9GyvPOwU7y','public/business_account/1WAUsernameTest/receipts/9GyvPOwU7y-a1c243c5-521e-4149-afa0-b98131e490d2.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/9GyvPOwU7y-a1c243c5-521e-4149-afa0-b98131e490d2.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c242c3-db45-4067-afb2-92bf465ea369\\/a1c243a8-36e3-49d4-813a-0b91932f8b04.jpeg\"],\"upload_at\":\"2026-05-12T03:41:49.000000Z\"}','2026-05-12 03:42:07','2026-05-12 03:42:07','2026-05-12 03:43:46',NULL,NULL,NULL),(2,8,'daily_challenge','35','1','6nt66dgyBL','public/business_account/1WAUsernameTest/receipts/6nt66dgyBL-a1c244a9-42e7-46db-bcdc-30bdfc0db42c.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/6nt66dgyBL-a1c244a9-42e7-46db-bcdc-30bdfc0db42c.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c242c3-db45-4067-afb2-92bf465ea369\\/a1c2448f-5544-4931-a687-3c169662b82b.jpeg\"],\"upload_at\":\"2026-05-12T03:44:20.000000Z\"}','2026-05-12 03:44:36','2026-05-12 03:44:36','2026-05-12 04:06:28',NULL,NULL,NULL),(3,8,'daily_challenge','36','1','wJlNWy85QF','public/business_account/1WAUsernameTest/receipts/wJlNWy85QF-a1c24dbf-52d3-4488-8e20-3c5846179fab.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/wJlNWy85QF-a1c24dbf-52d3-4488-8e20-3c5846179fab.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c242c3-db45-4067-afb2-92bf465ea369\\/a1c24c3b-e32e-4821-964f-de50a12489ff.jpeg\"],\"upload_at\":\"2026-05-12T04:05:48.000000Z\"}','2026-05-12 04:10:01','2026-05-12 04:10:01','2026-05-12 04:23:04',NULL,NULL,NULL),(4,8,'daily_challenge','37','1','ua00kCvK9g','public/business_account/1WAUsernameTest/receipts/ua00kCvK9g-a1c24dd8-f2df-488e-a8e5-4dfe4dfcd1ae.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/ua00kCvK9g-a1c24dd8-f2df-488e-a8e5-4dfe4dfcd1ae.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c242c3-db45-4067-afb2-92bf465ea369\\/a1c24dc9-7679-45a3-944b-f17d360346f1.jpeg\"],\"upload_at\":\"2026-05-12T04:10:08.000000Z\"}','2026-05-12 04:10:17','2026-05-12 04:10:17','2026-05-12 05:15:53',NULL,NULL,NULL),(5,8,'daily_challenge','38','1','1Et31gAOYf','public/business_account/1WAUsernameTest/receipts/1Et31gAOYf-a1c267ae-77e4-4323-9e2b-e1257aa5c606.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/1Et31gAOYf-a1c267ae-77e4-4323-9e2b-e1257aa5c606.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c242c3-db45-4067-afb2-92bf465ea369\\/a1c2679b-9b26-4149-93df-8e0c1d062623.jpeg\"],\"upload_at\":\"2026-05-12T05:22:21.000000Z\"}','2026-05-12 05:22:32','2026-05-12 05:22:32','2026-05-12 05:31:46',NULL,NULL,NULL),(6,8,'daily_challenge','39','1','MM8RuAeraN','public/business_account/1WAUsernameTest/receipts/MM8RuAeraN-a1c2705b-0013-42d8-ad9c-5827e4dd9aaf.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/MM8RuAeraN-a1c2705b-0013-42d8-ad9c-5827e4dd9aaf.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c242c3-db45-4067-afb2-92bf465ea369\\/a1c2704c-f1ff-4777-870f-960c4c08fed2.jpeg\"],\"upload_at\":\"2026-05-12T05:46:39.000000Z\"}','2026-05-12 05:46:47','2026-05-12 05:46:47','2026-05-12 05:47:24',NULL,NULL,NULL),(7,8,'daily_challenge','40','1','SaCtfMdh9j','public/business_account/1WAUsernameTest/receipts/SaCtfMdh9j-a1c2717d-06fc-4b5e-8b79-df3dad1e017c.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/SaCtfMdh9j-a1c2717d-06fc-4b5e-8b79-df3dad1e017c.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c242c3-db45-4067-afb2-92bf465ea369\\/a1c2716f-a608-4bc6-a5a0-bfbcdae8d893.jpeg\"],\"upload_at\":\"2026-05-12T05:49:49.000000Z\"}','2026-05-12 05:49:57','2026-05-12 05:49:57','2026-05-12 05:50:13',NULL,NULL,NULL),(8,8,'daily_challenge','41','1','vHkWp7QyCP','public/business_account/1WAUsernameTest/receipts/vHkWp7QyCP-a1c2a83a-9416-47b0-94d0-f2388e973b1b.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/vHkWp7QyCP-a1c2a83a-9416-47b0-94d0-f2388e973b1b.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c29d2b-82a8-4344-8010-b2f1184c972d\\/a1c2a82c-bd5a-41d5-9178-a58b9413fcc5.jpeg\"],\"upload_at\":\"2026-05-12T08:22:52.000000Z\"}','2026-05-12 08:23:01','2026-05-12 08:23:01','2026-05-12 08:23:17',NULL,NULL,NULL),(9,11,'daily_challenge','46','1','5U2zY9GGMB','public/business_account/1WAUsernameTest/receipts/5U2zY9GGMB-a1c2a99c-c5ae-4079-93fe-948ad98a99fe.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/5U2zY9GGMB-a1c2a99c-c5ae-4079-93fe-948ad98a99fe.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c134d0-fce0-469a-b823-984c8a8a579b\\/a1c2a976-1bb4-4ce1-8483-d023ddb72ee7.jpeg\"],\"upload_at\":\"2026-05-12T08:26:29.000000Z\"}','2026-05-12 08:26:53','2026-05-12 08:26:53','2026-05-12 08:29:55',NULL,NULL,NULL),(10,11,'daily_challenge','48','1','ZUgMoJyQas','public/business_account/1WAUsernameTest/receipts/ZUgMoJyQas-a1c45654-fdc8-44db-b765-d4a71ead768a.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/ZUgMoJyQas-a1c45654-fdc8-44db-b765-d4a71ead768a.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c134d0-fce0-469a-b823-984c8a8a579b\\/a1c4563b-2e86-4032-80cf-f1abb50145bf.jpeg\"],\"upload_at\":\"2026-05-13T04:25:25.000000Z\"}','2026-05-13 04:25:40','2026-05-13 04:25:40','2026-05-13 05:54:44',NULL,NULL,NULL),(11,8,'daily_challenge','50','1','vd62sQ4DAz','public/business_account/1WAUsernameTest/receipts/vd62sQ4DAz-a1c4bb86-3e78-41b0-8172-a86a2a68869b.jpeg','https://wa-username-testing.growthdesk.dev/file/receipts/vd62sQ4DAz-a1c4bb86-3e78-41b0-8172-a86a2a68869b.jpeg',NULL,'{\"id\":1,\"value\":\"Test Outlet 1\"}','',NULL,'0','pending',NULL,'{\"receipt_url\":[\"https:\\/\\/wa-username.growthdesk.dev\\/storage\\/channel\\/43\\/recipient\\/a1c29d2b-82a8-4344-8010-b2f1184c972d\\/a1c4bb72-1f77-4143-8825-ee45deacefa6.jpeg\"],\"upload_at\":\"2026-05-13T09:08:25.000000Z\"}','2026-05-13 09:08:38','2026-05-13 09:08:38','2026-05-13 09:09:23',NULL,NULL,NULL);

--
-- Table structure for table `receipt_entry_ocr_summaries`
--

CREATE TABLE `receipt_entry_ocr_summaries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `receipt_entry_id` bigint unsigned NOT NULL,
  `ocr_request_log_id` bigint unsigned NOT NULL,
  `store_id` bigint unsigned DEFAULT NULL,
  `business_asset_id` bigint unsigned DEFAULT NULL,
  `duplicate_summ_id` bigint unsigned DEFAULT NULL,
  `receipt_date` date DEFAULT NULL,
  `receipt_time` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receipt_refno` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_sku_qty` int DEFAULT NULL,
  `qualifying_spend_total` decimal(8,2) unsigned NOT NULL,
  `payment_method` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_a_receipt` tinyint DEFAULT NULL,
  `is_criteria_pass` tinyint(1) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `receipt_entry_ocr_summaries_receipt_entry_id_index` (`receipt_entry_id`),
  KEY `receipt_entry_ocr_summaries_ocr_request_log_id_index` (`ocr_request_log_id`),
  KEY `receipt_entry_ocr_summaries_store_id_index` (`store_id`),
  KEY `receipt_entry_ocr_summaries_business_asset_id_index` (`business_asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `receipt_entry_ocr_summaries`
--


--
-- Table structure for table `receipt_entry_product_relations`
--

CREATE TABLE `receipt_entry_product_relations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `receipt_entry_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `fill_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sku_unit_price` decimal(8,2) DEFAULT NULL,
  `sku_unit_qty` int DEFAULT NULL,
  `total_spent_per_sku` decimal(9,2) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `receipt_entry_product_relations_receipt_entry_id_index` (`receipt_entry_id`),
  KEY `receipt_entry_product_relations_product_id_index` (`product_id`),
  KEY `receipt_entry_product_relations_sku_unit_price_index` (`sku_unit_price`),
  KEY `receipt_entry_product_relations_sku_unit_qty_index` (`sku_unit_qty`),
  KEY `receipt_entry_product_relations_total_spent_per_sku_index` (`total_spent_per_sku`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `receipt_entry_product_relations`
--


--
-- Table structure for table `receipt_entry_user_inputs`
--

CREATE TABLE `receipt_entry_user_inputs` (
  `receipt_entry_id` bigint unsigned NOT NULL,
  `business_asset_id` bigint unsigned DEFAULT NULL,
  `merchants` longtext COLLATE utf8mb4_unicode_ci,
  `products` longtext COLLATE utf8mb4_unicode_ci,
  `transaction_amount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `outlet_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sponsor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`receipt_entry_id`),
  KEY `receipt_entry_user_inputs_business_asset_id_index` (`business_asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `receipt_entry_user_inputs`
--

INSERT INTO `receipt_entry_user_inputs` VALUES (1,NULL,NULL,NULL,NULL,'2026-05-12 03:42:09','2026-05-12 03:42:09',NULL,NULL,NULL,NULL),(2,NULL,NULL,NULL,NULL,'2026-05-12 03:44:37','2026-05-12 03:44:37',NULL,NULL,NULL,NULL),(3,NULL,NULL,NULL,NULL,'2026-05-12 04:10:01','2026-05-12 04:10:01',NULL,NULL,NULL,NULL),(4,NULL,NULL,NULL,NULL,'2026-05-12 04:10:18','2026-05-12 04:10:18',NULL,NULL,NULL,NULL),(5,NULL,NULL,NULL,NULL,'2026-05-12 05:22:32','2026-05-12 05:22:32',NULL,NULL,NULL,NULL),(6,NULL,NULL,NULL,NULL,'2026-05-12 05:46:47','2026-05-12 05:46:47',NULL,NULL,NULL,NULL),(7,NULL,NULL,NULL,NULL,'2026-05-12 05:49:57','2026-05-12 05:49:57',NULL,NULL,NULL,NULL),(8,NULL,NULL,NULL,NULL,'2026-05-12 08:23:01','2026-05-12 08:23:01',NULL,NULL,NULL,NULL),(9,NULL,NULL,NULL,NULL,'2026-05-12 08:26:53','2026-05-12 08:26:53',NULL,NULL,NULL,NULL),(10,NULL,NULL,NULL,NULL,'2026-05-13 04:25:41','2026-05-13 04:25:41',NULL,NULL,NULL,NULL),(11,NULL,NULL,NULL,NULL,'2026-05-13 09:08:38','2026-05-13 09:08:38',NULL,NULL,NULL,NULL);

--
-- Table structure for table `referrer_code_logs`
--

CREATE TABLE `referrer_code_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `referrer_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `referrer_user_id` bigint unsigned NOT NULL,
  `is_notified` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `referrer_code_logs_user_id_index` (`user_id`),
  KEY `referrer_code_logs_referrer_user_id_index` (`referrer_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
