--
-- Host: localhost    Database: desafiointeligencias
-- ------------------------------------------------------


--
-- Table structure for table `achievements`
--

CREATE TABLE `achievements` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `description` text,
  `category` enum('seed','sprout','tree','special') NOT NULL,
  `intelligence_id` int DEFAULT NULL,
  `threshold` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `intelligence_id` (`intelligence_id`),
  CONSTRAINT `achievements_ibfk_1` FOREIGN KEY (`intelligence_id`) REFERENCES `intelligences` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `achievements`
--

INSERT INTO `achievements` VALUES (1,'Primeiro Passo','Complete o primeiro dia de jornada','seed',1,1,'2025-11-15 15:54:03'),(2,'Equipe Afinada','Finalize um desafio em família','sprout',2,1,'2025-11-15 15:54:03');

--
-- Table structure for table `announcement_reads`
--

CREATE TABLE `announcement_reads` (
  `id` int NOT NULL AUTO_INCREMENT,
  `announcement_id` int NOT NULL,
  `user_id` int NOT NULL,
  `seen_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_announcement_user` (`announcement_id`,`user_id`),
  KEY `fk_announcement_reads_user` (`user_id`),
  CONSTRAINT `fk_announcement_reads_announcement` FOREIGN KEY (`announcement_id`) REFERENCES `announcements` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_announcement_reads_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcement_reads`
--

INSERT INTO `announcement_reads` VALUES (1,1,47,'2025-11-26 10:34:06','2025-11-26 13:34:06'),(2,1,45,'2025-11-27 22:21:18','2025-11-28 01:21:18'),(3,1,49,'2025-11-28 00:01:17','2025-11-28 03:01:17'),(4,1,11,'2025-11-28 00:07:23','2025-11-28 03:07:23'),(5,1,51,'2025-11-28 23:24:17','2025-11-29 02:24:17'),(6,1,52,'2025-11-28 23:58:45','2025-11-29 02:58:45'),(7,1,53,'2025-11-29 10:58:08','2025-11-29 13:58:08'),(8,1,60,'2025-11-29 15:15:08','2025-11-29 18:15:08'),(9,1,61,'2025-11-29 16:17:26','2025-11-29 19:17:26'),(10,1,62,'2025-12-01 09:46:48','2025-12-01 12:46:48'),(11,1,50,'2025-12-01 15:03:31','2025-12-01 18:03:31'),(12,1,64,'2025-12-01 22:46:47','2025-12-02 01:46:47');

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `activated_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_announcements_created_by` (`created_by`),
  CONSTRAINT `fk_announcements_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `announcements`
--

INSERT INTO `announcements` VALUES (1,'Teste de aviso','Este é um teste de avisos públicos que chegam para todos os usuários','admin_panel/uploads/announcements/announcement_692701bd833f23.37351734.png',1,'2025-11-26 10:33:49',1,'2025-11-26 13:33:49','2025-11-26 13:33:49');

--
-- Table structure for table `challenge_responses`
--

CREATE TABLE `challenge_responses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `challenge_id` int NOT NULL,
  `response_text` text,
  `response_audio_url` varchar(255) DEFAULT NULL,
  `response_image_url` varchar(255) DEFAULT NULL,
  `validation_status` enum('pending','valid','invalid','manual_review') NOT NULL DEFAULT 'manual_review',
  `validation_feedback` text,
  `submitted_at` datetime NOT NULL,
  `validated_at` datetime DEFAULT NULL,
  `points_earned` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `challenge_id` (`challenge_id`),
  CONSTRAINT `challenge_responses_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `challenge_responses_ibfk_2` FOREIGN KEY (`challenge_id`) REFERENCES `challenges` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `challenge_responses`
--

INSERT INTO `challenge_responses` VALUES (1,2,1,'Compartilhei minhas emoções em casa.',NULL,NULL,'valid','Excelente abertura para o diálogo!','2025-11-15 12:05:00','2025-11-15 12:45:00',20),(2,6,1,NULL,NULL,NULL,'manual_review',NULL,'2025-11-17 22:38:40',NULL,20),(3,6,2,NULL,NULL,NULL,'manual_review',NULL,'2025-11-17 22:38:47',NULL,30),(4,6,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-17 22:38:56',NULL,25),(5,8,2,NULL,NULL,NULL,'manual_review',NULL,'2025-11-17 23:28:28',NULL,30),(6,8,1,NULL,NULL,NULL,'manual_review',NULL,'2025-11-17 23:28:36',NULL,20),(7,12,1,NULL,NULL,NULL,'manual_review',NULL,'2025-11-18 19:49:59',NULL,20),(8,12,1,NULL,NULL,NULL,'manual_review',NULL,'2025-11-18 19:50:08',NULL,20),(9,12,2,NULL,NULL,NULL,'manual_review',NULL,'2025-11-18 19:50:15',NULL,30),(10,15,2,NULL,NULL,NULL,'manual_review',NULL,'2025-11-23 11:36:22',NULL,30),(11,16,2,NULL,NULL,NULL,'manual_review',NULL,'2025-11-23 13:48:11',NULL,30),(12,26,1,NULL,NULL,NULL,'manual_review',NULL,'2025-11-23 19:29:11',NULL,20),(13,8,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-23 20:14:26',NULL,25);

--
-- Table structure for table `challenges`
--

CREATE TABLE `challenges` (
  `id` int NOT NULL AUTO_INCREMENT,
  `day_id` int DEFAULT NULL,
  `title` varchar(150) NOT NULL,
  `description` text,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `points` int NOT NULL DEFAULT '0',
  `is_special` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `day_id` (`day_id`),
  CONSTRAINT `challenges_ibfk_1` FOREIGN KEY (`day_id`) REFERENCES `days` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `challenges`
--

INSERT INTO `challenges` VALUES (1,NULL,'Mapa das Emoções','Liste três emoções sentidas hoje e compartilhe com alguém.','2025-11-10 09:00:00','2025-12-31 21:00:00',20,0,'2025-11-15 15:54:03'),(2,NULL,'Missão Colaborativa','Planeje uma atividade em grupo onde cada pessoa tenha um papel.','2025-11-12 09:00:00','2025-12-31 21:00:00',30,1,'2025-11-15 15:54:03'),(3,NULL,'Gratidão em Família','Escreva ou grave um agradecimento para alguém e compartilhe.','2025-11-15 09:00:00','2025-12-31 21:00:00',25,0,'2025-11-15 15:54:03');

--
-- Table structure for table `classes`
--

CREATE TABLE `classes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `school_id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `school_id` (`school_id`),
  CONSTRAINT `classes_ibfk_1` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` VALUES (1,1,'Turma 1A','Turma do primeiro ano A','2025-11-15 15:54:03'),(2,1,'Turma 1B','Turma do primeiro ano B','2025-11-15 15:54:03'),(3,2,'Turma 2A','Turma do segundo ano A','2025-11-15 15:54:03');

--
-- Table structure for table `coins_transactions`
--

CREATE TABLE `coins_transactions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `amount` int NOT NULL,
  `transaction_type` enum('earned','spent','reverted') NOT NULL,
  `source` varchar(50) NOT NULL,
  `reference_id` int DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `coins_transactions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `coins_transactions`
--

INSERT INTO `coins_transactions` VALUES (1,2,30,'earned','day_completion',1,'Concluiu o Dia 1 e recebeu moedas.','2025-11-15 11:05:00'),(2,2,10,'spent','reward_redeem',1,'Resgatou o pôster digital.','2025-11-15 12:40:00'),(3,6,20,'earned','challenge',1,'Pontuação por desafio','2025-11-18 01:38:40'),(4,6,30,'earned','challenge',2,'Pontuação por desafio','2025-11-18 01:38:47'),(5,6,25,'earned','challenge',3,'Pontuação por desafio','2025-11-18 01:38:56'),(6,6,-10,'spent','reward',1,'Resgate de recompensa','2025-11-18 01:44:26'),(7,8,30,'earned','challenge',2,'Pontuação por desafio','2025-11-18 02:28:28'),(8,8,20,'earned','challenge',1,'Pontuação por desafio','2025-11-18 02:28:36'),(9,8,1,'earned','quiz',3,'Pontuação por quiz','2025-11-18 18:56:57'),(10,8,1,'earned','quiz',3,'Pontuação por quiz','2025-11-18 19:10:18'),(11,8,1,'earned','quiz',4,'Pontuação por quiz','2025-11-18 19:10:22'),(12,8,1,'earned','quiz',3,'Pontuação por quiz','2025-11-18 20:10:15'),(13,8,1,'earned','quiz',4,'Pontuação por quiz','2025-11-18 20:10:18'),(14,9,1,'earned','quiz',3,'Pontuação por quiz','2025-11-18 21:33:45'),(15,9,1,'earned','quiz',4,'Pontuação por quiz','2025-11-18 21:33:47'),(16,10,1,'earned','quiz',3,'Pontuação por quiz','2025-11-18 21:51:30'),(17,10,1,'earned','quiz',4,'Pontuação por quiz','2025-11-18 21:51:33'),(18,11,1,'earned','quiz',3,'Pontuação por quiz','2025-11-18 22:06:38'),(19,11,1,'earned','quiz',4,'Pontuação por quiz','2025-11-18 22:06:41'),(20,12,1,'earned','quiz',3,'Pontuação por quiz','2025-11-18 22:45:51'),(21,12,1,'earned','quiz',4,'Pontuação por quiz','2025-11-18 22:46:00'),(22,12,1,'earned','quiz',5,'Pontuação por quiz','2025-11-18 22:46:52'),(23,12,20,'earned','challenge',1,'Pontuação por desafio','2025-11-18 22:49:59'),(24,12,20,'earned','challenge',1,'Pontuação por desafio','2025-11-18 22:50:08'),(25,12,30,'earned','challenge',2,'Pontuação por desafio','2025-11-18 22:50:15'),(26,11,1,'earned','quiz',5,'Pontuação por quiz','2025-11-19 13:07:56'),(27,15,1,'earned','quiz',3,'Pontuação por quiz','2025-11-23 14:31:35'),(28,15,1,'earned','quiz',5,'Pontuação por quiz','2025-11-23 14:32:29'),(29,15,30,'earned','challenge',2,'Pontuação por desafio','2025-11-23 14:36:22'),(30,15,-10,'spent','reward',1,'Resgate de recompensa','2025-11-23 14:39:55'),(31,16,1,'earned','quiz',5,'Pontuação por quiz','2025-11-23 14:49:10'),(32,16,1,'earned','quiz',3,'Pontuação por quiz','2025-11-23 16:23:36'),(33,16,1,'earned','quiz',4,'Pontuação por quiz','2025-11-23 16:23:41'),(34,16,30,'earned','challenge',2,'Pontuação por desafio','2025-11-23 16:48:11'),(35,16,-10,'spent','reward',1,'Resgate de recompensa','2025-11-23 16:59:07'),(36,26,20,'earned','challenge',1,'Pontuação por desafio','2025-11-23 22:29:11'),(37,8,25,'earned','challenge',3,'Pontuação por desafio','2025-11-23 23:14:26'),(38,8,20,'earned','daily_challenge',1,'Pontuação por desafio diário','2025-11-23 23:39:14'),(39,8,20,'earned','daily_challenge',1,'Pontuação por desafio diário','2025-11-23 23:39:14'),(40,8,25,'earned','daily_challenge',2,'Pontuação por desafio diário','2025-11-23 23:39:38'),(41,8,15,'earned','daily_challenge',3,'Pontuação por desafio diário','2025-11-23 23:41:00'),(42,8,10,'earned','daily_challenge',4,'Pontuação por desafio diário (quiz)','2025-11-24 00:53:00'),(43,27,15,'earned','daily_challenge',3,'Pontuação por desafio diário','2025-11-24 01:04:04'),(44,27,10,'earned','daily_challenge',4,'Pontuação por desafio diário (quiz)','2025-11-24 01:04:22'),(45,28,10,'earned','daily_challenge',4,'Pontuação por desafio diário (quiz)','2025-11-24 01:08:33'),(46,28,10,'earned','daily_challenge',4,'Pontuação por desafio diário','2025-11-24 01:08:34'),(47,28,15,'earned','daily_challenge',3,'Pontuação por desafio diário (quiz)','2025-11-24 01:12:43'),(48,28,15,'earned','daily_challenge',3,'Pontuação por desafio diário','2025-11-24 01:12:43'),(49,31,1,'earned','quiz',3,'Pontuação por quiz','2025-11-24 12:17:25'),(50,31,1,'earned','quiz',4,'Pontuação por quiz','2025-11-24 12:17:29'),(51,31,1,'earned','quiz',5,'Pontuação por quiz','2025-11-24 12:18:13'),(52,32,1,'earned','quiz',5,'Pontuação por quiz','2025-11-24 12:45:38'),(53,33,1,'earned','quiz',5,'Pontuação por quiz','2025-11-24 12:49:00'),(54,34,1,'earned','quiz',5,'Pontuação por quiz','2025-11-24 12:57:51'),(55,35,1,'earned','quiz',5,'Pontuação por quiz','2025-11-24 13:02:47'),(56,35,1,'earned','quiz',3,'Pontuação por quiz','2025-11-24 13:06:28'),(57,35,1,'earned','quiz',3,'Pontuação por quiz','2025-11-24 13:07:21'),(58,35,1,'earned','quiz',4,'Pontuação por quiz','2025-11-24 13:07:24'),(59,36,1,'earned','quiz',3,'Pontuação por quiz','2025-11-24 13:22:29'),(60,36,1,'earned','quiz',4,'Pontuação por quiz','2025-11-24 13:22:33'),(61,36,1,'earned','quiz',5,'Pontuação por quiz','2025-11-24 13:24:40'),(62,36,1,'earned','quiz',6,'Pontuação por quiz','2025-11-24 13:25:08'),(63,37,1,'earned','quiz',3,'Pontuação por quiz','2025-11-24 13:36:07'),(64,37,1,'earned','quiz',4,'Pontuação por quiz','2025-11-24 13:36:09'),(65,37,1,'earned','quiz',5,'Pontuação por quiz','2025-11-24 13:36:28'),(66,37,1,'earned','quiz',6,'Pontuação por quiz','2025-11-24 13:36:53'),(67,42,15,'earned','daily_challenge',3,'Pontuação por desafio diário (quiz)','2025-11-25 14:33:57'),(68,42,15,'earned','daily_challenge',3,'Pontuação por desafio diário','2025-11-25 14:33:57'),(69,42,10,'earned','daily_challenge',4,'Pontuação por desafio diário (quiz)','2025-11-25 14:34:44'),(70,42,10,'earned','daily_challenge',4,'Pontuação por desafio diário','2025-11-25 14:34:44'),(71,45,10,'earned','referral',20,'Indicação aceita','2025-11-26 12:28:06'),(72,47,1,'earned','quiz',3,'Pontuação por quiz','2025-11-26 13:40:30'),(73,47,1,'earned','quiz',4,'Pontuação por quiz','2025-11-26 13:40:32'),(74,47,1,'earned','quiz',5,'Pontuação por quiz','2025-11-26 13:52:05'),(75,47,1,'earned','quiz',14,'Pontuação por quiz','2025-11-26 13:52:31'),(76,51,1,'earned','quiz',3,'Pontuação por quiz','2025-11-29 02:26:58'),(77,51,15,'earned','daily_challenge',3,'Pontuação por desafio diário (quiz)','2025-11-29 02:44:46'),(78,51,15,'earned','daily_challenge',3,'Pontuação por desafio diário','2025-11-29 02:44:46'),(79,51,10,'earned','daily_challenge',4,'Pontuação por desafio diário (quiz)','2025-11-29 02:47:54'),(80,51,10,'earned','daily_challenge',4,'Pontuação por desafio diário','2025-11-29 02:47:54'),(81,51,-10,'spent','reward',1,'Resgate de recompensa','2025-11-29 02:52:39'),(82,51,-10,'spent','reward',1,'Resgate de recompensa','2025-11-29 02:52:39'),(83,51,-10,'spent','reward',1,'Resgate de recompensa','2025-11-29 02:52:40'),(84,51,-10,'spent','reward',1,'Resgate de recompensa','2025-11-29 02:52:40'),(85,52,15,'earned','daily_challenge',3,'Pontuação por desafio diário (quiz)','2025-11-29 03:06:04'),(86,52,15,'earned','daily_challenge',3,'Pontuação por desafio diário','2025-11-29 03:06:05'),(87,52,10,'earned','daily_challenge',4,'Pontuação por desafio diário (quiz)','2025-11-29 03:06:33'),(88,52,10,'earned','daily_challenge',4,'Pontuação por desafio diário','2025-11-29 03:06:34'),(89,53,1,'earned','quiz',3,'Pontuação por quiz','2025-11-29 14:02:22'),(90,53,1,'earned','quiz',4,'Pontuação por quiz','2025-11-29 14:02:29'),(91,53,15,'earned','daily_challenge',3,'Pontuação por desafio diário (quiz)','2025-11-29 14:08:28'),(92,53,15,'earned','daily_challenge',3,'Pontuação por desafio diário','2025-11-29 14:08:28'),(93,53,10,'earned','daily_challenge',4,'Pontuação por desafio diário (quiz)','2025-11-29 14:08:38'),(94,53,10,'earned','daily_challenge',4,'Pontuação por desafio diário','2025-11-29 14:08:38'),(95,11,1,'earned','quiz',20,'Pontuação por quiz','2025-12-01 12:56:44'),(96,62,1,'earned','quiz',20,'Pontuação por quiz','2025-12-01 13:40:54'),(97,62,1,'earned','quiz',21,'Pontuação por quiz','2025-12-01 13:40:58'),(98,62,1,'earned','quiz',22,'Pontuação por quiz','2025-12-01 13:41:48'),(99,62,1,'earned','quiz',29,'Pontuação por quiz','2025-12-01 14:19:02'),(100,50,1,'earned','quiz',21,'Pontuação por quiz','2025-12-01 18:04:07'),(101,50,10,'earned','daily_challenge',5,'Pontuação por desafio diário (quiz)','2025-12-01 18:04:36'),(102,50,1,'earned','quiz',22,'Pontuação por quiz','2025-12-01 18:06:04'),(103,50,1,'earned','quiz',29,'Pontuação por quiz','2025-12-01 18:08:53'),(104,64,10,'earned','daily_challenge',5,'Pontuação por desafio diário (quiz)','2025-12-02 01:55:23'),(105,64,10,'earned','daily_challenge',5,'Pontuação por desafio diário','2025-12-02 01:55:37'),(106,64,1,'earned','quiz',23,'Pontuação por quiz','2025-12-02 01:56:53'),(107,64,1,'earned','quiz',23,'Pontuação por quiz','2025-12-02 01:57:11');

--
-- Table structure for table `daily_challenge_contents`
--

CREATE TABLE `daily_challenge_contents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `daily_challenge_id` int NOT NULL,
  `content_type` enum('text','image','audio','video','pdf','link','quiz','movie','challenge') NOT NULL DEFAULT 'text',
  `language` enum('pt','es','en') NOT NULL DEFAULT 'pt',
  `order_index` smallint NOT NULL DEFAULT '0',
  `title` varchar(150) DEFAULT NULL,
  `body_text` text,
  `media_url` varchar(255) DEFAULT NULL,
  `reference_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `daily_challenge_id` (`daily_challenge_id`),
  CONSTRAINT `fk_daily_contents_daily` FOREIGN KEY (`daily_challenge_id`) REFERENCES `daily_challenges` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `daily_challenge_contents`
--

INSERT INTO `daily_challenge_contents` VALUES (4,3,'audio','pt',1,'Compartilhe gratidão','Grave um áudio agradecendo alguém especial e envie para a família.',NULL,NULL,'2025-11-22 23:00:00'),(5,4,'text','pt',1,'Teste titulo','teste descrição',NULL,NULL,'2025-11-24 00:51:23'),(6,5,'text','pt',1,NULL,'Assista ao video: Acredite daBondade.','https://drive.google.com/file/d/1bNbm6N_BXCHUmp765hyojoHLWU1kWkaS/view',NULL,'2025-12-01 17:19:47');

--
-- Table structure for table `daily_challenge_responses`
--

CREATE TABLE `daily_challenge_responses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `daily_challenge_id` int NOT NULL,
  `response_text` text,
  `response_audio_url` varchar(255) DEFAULT NULL,
  `response_image_url` varchar(255) DEFAULT NULL,
  `validation_status` enum('pending','valid','invalid','manual_review') NOT NULL DEFAULT 'manual_review',
  `validation_feedback` text,
  `submitted_at` datetime NOT NULL,
  `validated_at` datetime DEFAULT NULL,
  `points_earned` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `daily_challenge_id` (`daily_challenge_id`),
  CONSTRAINT `fk_daily_resp_challenge` FOREIGN KEY (`daily_challenge_id`) REFERENCES `daily_challenges` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_daily_resp_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `daily_challenge_responses`
--

INSERT INTO `daily_challenge_responses` VALUES (4,8,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-23 20:41:00',NULL,15),(5,27,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-23 22:04:04',NULL,15),(6,28,4,NULL,NULL,NULL,'manual_review',NULL,'2025-11-23 22:08:34',NULL,10),(7,28,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-23 22:12:43',NULL,15),(8,42,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-25 11:33:57',NULL,15),(9,42,4,NULL,NULL,NULL,'manual_review',NULL,'2025-11-25 11:34:44',NULL,10),(10,51,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-28 23:44:46',NULL,15),(11,51,4,NULL,NULL,NULL,'manual_review',NULL,'2025-11-28 23:47:54',NULL,10),(12,52,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-29 00:06:05',NULL,15),(13,52,4,NULL,NULL,NULL,'manual_review',NULL,'2025-11-29 00:06:34',NULL,10),(14,53,3,NULL,NULL,NULL,'manual_review',NULL,'2025-11-29 11:08:28',NULL,15),(15,53,4,NULL,NULL,NULL,'manual_review',NULL,'2025-11-29 11:08:38',NULL,10),(16,64,5,NULL,NULL,NULL,'manual_review',NULL,'2025-12-01 22:55:37',NULL,10);

--
-- Table structure for table `daily_challenges`
--

CREATE TABLE `daily_challenges` (
  `id` int NOT NULL AUTO_INCREMENT,
  `challenge_date` date NOT NULL,
  `title` varchar(150) NOT NULL,
  `description` text,
  `intelligence_id` int DEFAULT NULL,
  `language` enum('pt','es','en') NOT NULL DEFAULT 'pt',
  `points` int NOT NULL DEFAULT '0',
  `video_url` varchar(255) DEFAULT NULL,
  `video_duration` varchar(50) DEFAULT NULL,
  `badge_label` varchar(120) DEFAULT NULL,
  `response_type` enum('text','audio','image','video','upload','quiz','mixed') NOT NULL DEFAULT 'text',
  `quiz_id` int DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `intelligence_id` (`intelligence_id`),
  CONSTRAINT `fk_daily_challenges_intelligence` FOREIGN KEY (`intelligence_id`) REFERENCES `intelligences` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `daily_challenges`
--

INSERT INTO `daily_challenges` VALUES (3,'2025-11-23','Gratidão em Família','Escreva ou grave um agradecimento para alguém e compartilhe. 2',1,'pt',5,NULL,NULL,'Trabalha: Empatia','audio',18,1,'2025-11-22 23:00:00','2025-12-01 17:21:42'),(4,'2025-11-23','Teste Desafio diario','Teste Desafio diario',1,'pt',5,'https://www.youtube.com/watch?v=2tBm6fLRuKU',NULL,'Trabalha inteligência emocional','text',17,1,'2025-11-24 00:51:23','2025-12-01 17:21:54'),(5,'2025-12-01','Inteligência Interpessoal','🧠 Desafio Day 4 (2/2)\r\nViu o vídeo de hoje? Como é emocionante colher felicidade e amor 🧡\r\nE o que você está disposto a priorizar na sua vida para ter uma consciência mais profunda e receber inúmeras\r\nvezes o amor❓',1,'pt',10,'https://drive.google.com/file/d/1bNbm6N_BXCHUmp765hyojoHLWU1kWkaS/view',NULL,'Trabalha inteligência emocional','text',33,1,'2025-12-01 17:19:47','2025-12-01 17:22:56');

--
-- Table structure for table `day_contents`
--

CREATE TABLE `day_contents` (
  `id` int NOT NULL AUTO_INCREMENT,
  `day_id` int NOT NULL,
  `content_type` enum('text','image','audio','video','pdf','link','quiz','movie','challenge') DEFAULT NULL,
  `language` enum('pt','es','en') NOT NULL DEFAULT 'pt',
  `order_index` smallint NOT NULL DEFAULT '0',
  `title` varchar(150) DEFAULT NULL,
  `body_text` text,
  `media_url` varchar(255) DEFAULT NULL,
  `reference_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `day_id` (`day_id`),
  CONSTRAINT `day_contents_ibfk_1` FOREIGN KEY (`day_id`) REFERENCES `days` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `day_contents`
--

INSERT INTO `day_contents` VALUES (8,8,'image','pt',1,'Inteligência Intrapessoal','Foi dada a largada e a 1a inteligência a ser desenvolvida, é a Inteligência Intrapessoal.\r\nNesta semana o objetivo dos desafios serão o autoconhecimento, um treinamento para você se conhecer um\r\npouco mais. Vamos?\r\n\r\n⚠️  ATENÇÃO : Os desafios valem \"gamepoints\" e ao final iremos premiar os 3 primeiros colocados. E se\r\npostar no Instagram e marcar @teenmentors e @somosmissãoteen ganhará pontos dobrados.\r\n\r\n#sou5% #souescolhido #somosmissãoteen #desafiodavidareal','https://cliente.carmeltec.com.br/desafio-inteligencias/admin_panel/uploads/day_contents/8/day8_20251201_095104_98caac3e.jpg',NULL,'2025-12-01 12:27:38'),(9,9,'video','pt',1,NULL,'Vídeo ilustrado com o resumo do livro “O Poder do Subconsciente”. \r\nAssista antes de responder as perguntas reflexivas do dia.','https://www.youtube.com/watch?v=L-UPDDoPOd0&authuser=0',NULL,'2025-12-01 13:21:33'),(10,10,'video','pt',1,'Cine Sabedoria – Reflexão com o Filme','Dia de Cine Sabedoria! Hoje o desafio é aprender por meio de um filme.\r\n\r\nAssista ao filme “Poder Além da Vida” e reflita sobre as lições de autoconhecimento presentes na história.\r\nDepois, poste sua resposta do desafio e, se puder, uma foto da sua família curtindo o momento.\r\n\r\nLembre-se: a Inteligência Intrapessoal envolve introspecção, reflexão e autoconhecimento.','https://www.youtube.com/watch?v=0XxCLLrWXxE&authuser=0',NULL,'2025-12-01 13:29:31'),(11,11,'video','pt',1,NULL,'Então o desafio de hoje é para você responder as 4 perguntas do post e também fazer com pelo menos mais\r\nduas pessoas da sua family responda as 4 perguntas.\r\nIsso mesmo, faça o seu e depois o de mais duas pessoas. Combinado?',NULL,NULL,'2025-12-01 13:36:15');

--
-- Table structure for table `days`
--

CREATE TABLE `days` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trail_id` int NOT NULL,
  `day_number` tinyint NOT NULL,
  `day_type` enum('content','family_challenge','special') NOT NULL DEFAULT 'content',
  `release_time` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `activated_at` datetime DEFAULT NULL,
  `manual_override` enum('auto','force_on','force_off') NOT NULL DEFAULT 'auto',
  `description` text,
  `video_url` varchar(255) DEFAULT NULL,
  `title` varchar(150) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `trail_id` (`trail_id`),
  CONSTRAINT `days_ibfk_1` FOREIGN KEY (`trail_id`) REFERENCES `trails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `days`
--

INSERT INTO `days` VALUES (8,3,1,'content','2025-12-01 09:10:00',1,'2025-12-01 17:32:45','force_on','🧠  Desafio Day 1 (1/3)\r\n1) Leia o post explicativo sobre a Inteligência Intrapessoal;\r\n2) Veja o video ilustrado do resumo do livro Ö Poder do Subconsiente\";\r\n3) Responda as duas perguntas sobre o conteúdo do livro;\r\n4) Missão dada, missão cumprida. Agora só falta nos marcar no instagram.',NULL,'Dia 1 - Inteligência Intrapessoal','2025-12-01 12:27:38'),(9,3,2,'content','2025-12-01 10:00:00',1,'2025-12-01 17:32:45','force_on','🧠  Desafio Day 1 (2/3)\r\n1) Leia o post explicativo sobre a Inteligência Intrapessoal;\r\n2) Veja o video ilustrado do resumo do livro Ö Poder do Subconsiente\";\r\n3) Responda as duas perguntas sobre o conteúdo do livro;\r\n4) Missão dada, missão cumprida. Agora só falta nos marcar no instagram.','https://www.youtube.com/watch?v=L-UPDDoPOd0&authuser=0','Dia 2 - Inteligência Intrapessoal','2025-12-01 13:21:33'),(10,3,3,'content','2025-12-01 10:00:00',1,'2025-12-01 17:32:45','force_on','🧠 Desafio Day 3\r\nDia de Cine Sabedoria!!! ️\r\nDia de curtir uma \"preguicinha de leve\", mas não vamos deixar de aprender algo. Afinal somos os escolhidos,\r\nos jardineiros e estamos empenhados em cultivar nosso jardim. 🌱 🌱 🌱 🌱 🌱 🌱\r\nComo nossa semana é Inteligência Intrapessoal, que tal um filmaço para gerar aquela reflexão que muda a\r\nvida?\r\n▪️ Filme: Poder além da vida\r\n▪️ Direção: Kevin Bernhardt\r\nFaz uma pipoca, brigadeiro, pizza, sorvete... E se divirta aprendendooooo... . Combinado? 🍿 🍫 🍕 🍩 🍟 🥤 🍰\r\n🍉 🍌\r\nAh! Posta sua resposta, mas também uma fotinha da sua family se divertindo no Cine Sabedoria!!!!\r\nUhuuuuuu...\r\n\r\n#sou5% #souescolhido #desafiodasinteligências #missãoteen','https://www.youtube.com/watch?v=0XxCLLrWXxE&authuser=0','Dia 3 - Inteligência Intrapessoal','2025-12-01 13:29:31'),(11,3,4,'family_challenge','2025-12-01 10:30:00',1,'2025-12-01 17:32:45','force_on','🧠 Desafio Day 2 \r\nFeliz Sábado!!! Sabadouuu... 🎉\r\nNo fim de semana vamos sempre pensar em desafios para a família se envolver ainda mais. Uhuuu!\r\nMostre a seus pais como funciona o desafio, compartilhe com ele o que já aprendeu em apenas 1 dia.\r\nComo vimos a Inteligência Intrapessoal nos ajuda olhar para dentro de nós, é o habito da introspecção, do\r\npensar, do refletir que é tão importante para tomada de decisões responsáveis .\r\nEntão o desafio de hoje é para você responder as 4 perguntas do post e também fazer com pelo menos mais\r\nduas pessoas da sua family responda as 4 perguntas.\r\nIsso mesmo, faça o seu e depois o de mais duas pessoas. Combinado?\r\nVamos conhecer mais profundamente a si próprio e o outro. 😉\r\n⚠️  ATENÇÃO : Os desafios valem \"gamepoints\" e ao final iremos premiar os 3 primeiros colocados. Precisa\r\npostar no Instagram e marcar @teenmentors e @somosmissãoteen para pontuar.',NULL,'Dia 4 - Inteligência Intrapessoal','2025-12-01 13:36:15');

--
-- Table structure for table `device_tokens`
--

CREATE TABLE `device_tokens` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `device_token` varchar(255) NOT NULL,
  `platform` enum('android','ios','web') NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `last_active` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_device_token` (`device_token`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `device_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `device_tokens`
--


--
-- Table structure for table `families`
--

CREATE TABLE `families` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `families`
--

INSERT INTO `families` VALUES (1,'Família Massari','2025-11-15 15:54:03'),(2,'Família Omar Wael','2025-11-28 02:59:21'),(3,'Família Camilla','2025-11-28 03:00:28'),(4,'Família 566556 556h','2025-11-28 03:01:10'),(5,'Família Camilla Carla do Nascimento','2025-11-29 02:21:47'),(6,'Família Valdirene dos Santos','2025-11-29 13:57:59'),(7,'Família efhew wueifhewiuh','2025-11-29 14:50:38'),(8,'Família Teste Pagamento','2025-11-29 14:52:44'),(9,'Família Teste Pagamento','2025-11-29 17:13:28'),(10,'Família Philipe Teste x','2025-11-29 17:14:57'),(11,'Família kpokpok opkpok','2025-11-29 17:36:03'),(12,'Família Teste Gil','2025-11-29 17:50:46'),(13,'Família Teste Pagamento Gil','2025-11-29 17:55:02'),(14,'Família eihwu wiefhiweuhfuiew','2025-11-29 18:15:51'),(15,'Família Camilla Carla Massari','2025-12-01 18:02:00');

--
-- Table structure for table `intelligences`
--

CREATE TABLE `intelligences` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_pt` varchar(100) NOT NULL,
  `name_es` varchar(100) NOT NULL,
  `name_en` varchar(100) NOT NULL,
  `description` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `intelligences`
--

INSERT INTO `intelligences` VALUES (1,'Autoconhecimento','Autoconocimiento','Self Awareness','Aprender a identificar as próprias emoções.','2025-11-15 15:54:03'),(2,'Colaboração','Colaboración','Collaboration','Desenvolver habilidades para trabalhar em equipe.','2025-11-15 15:54:03');

--
-- Table structure for table `mentors`
--

CREATE TABLE `mentors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mentors`
--

INSERT INTO `mentors` VALUES (1,'Philipe Massari','philipe.massari12@gmail.com','2025-11-26 13:08:43','2025-11-26 13:08:43');

--
-- Table structure for table `movies`
--

CREATE TABLE `movies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `day_id` int NOT NULL,
  `title` varchar(150) NOT NULL,
  `description` text,
  `video_url` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `day_id` (`day_id`),
  CONSTRAINT `movies_ibfk_1` FOREIGN KEY (`day_id`) REFERENCES `days` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `movies`
--


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

CREATE TABLE `notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `message` text NOT NULL,
  `send_time` datetime NOT NULL,
  `language` enum('pt','es','en') NOT NULL DEFAULT 'pt',
  `target_type` enum('all','class','family','user') NOT NULL,
  `target_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `notifications` VALUES (1,'Novo dia liberado','O Dia 2 já está disponível para você continuar sua jornada.','2025-11-11 08:00:00','pt','user',2,'2025-11-11 08:00:00');

--
-- Table structure for table `pagseguro_authorizations`
--

CREATE TABLE `pagseguro_authorizations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `notification_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `authorization_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions_json` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status_label` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `raw_xml` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_authorization_notification` (`notification_code`),
  KEY `idx_authorization_code` (`authorization_code`),
  KEY `idx_authorization_email` (`account_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pagseguro_authorizations`
--


--
-- Table structure for table `pagseguro_notifications`
--

CREATE TABLE `pagseguro_notifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `received_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `notification_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notification_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `raw_body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `http_headers` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `consulted` tinyint(1) NOT NULL DEFAULT '0',
  `consult_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `consult_http_code` int DEFAULT NULL,
  `consult_response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `transaction_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_code` tinyint DEFAULT NULL,
  `status_label` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gross_amount` decimal(12,2) DEFAULT NULL,
  `paid` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_notification_code` (`notification_code`),
  KEY `idx_notification_received` (`received_at`),
  KEY `idx_notification_type` (`notification_type`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pagseguro_notifications`
--

INSERT INTO `pagseguro_notifications` VALUES (1,'2025-11-29 14:18:04','2D5272-47A12BA12B6D-7444164FB4BC-DC50BC','transaction','45.175.221.29','notificationCode=2D5272-47A12BA12B6D-7444164FB4BC-DC50BC&notificationType=transaction','{\"Accept\":\"*/*\",\"Content-Type\":\"application/x-www-form-urlencoded;charset=UTF-8\",\"Accept-Encoding\":\"gzip,deflate\",\"traceparent\":\"00-3483ca5be930c2850f452fa11a57cde4-8c5ade785e7b4c31-01\",\"Content-Length\":\"85\",\"Host\":\"cliente.carmeltec.com.br\",\"Connection\":\"keep-alive\",\"User-Agent\":\"Apache-HttpClient/5.2.3 (Java/17.0.11)\"}',1,'https://ws.pagseguro.uol.com.br/v2/transactions/notifications/2D5272-47A12BA12B6D-7444164FB4BC-DC50BC?email=***&token=*** [accept=application/xml; charset=ISO-8859-1]',200,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:16:48.000-03:00</date><code>3F2275F2-2355-468B-8237-FFF3128BD2FA</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>7</status><cancellationSource>INTERNAL</cancellationSource><lastEventDate>2025-11-29T14:18:03.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.00</feeAmount><netAmount>5.00</netAmount><extraAmount>0.00</extraAmount><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Camilla Carla</name><email>carmeltecsoftware@gmail.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation/></transaction>','3F2275F2-2355-468B-8237-FFF3128BD2FA','LINK_PAGAE=81ghaLqVp',7,'Cancelada',5.00,0),(2,'2025-11-29 14:18:23','79B4B2-7F8EE68EE6AB-CEE466AF9F74-E7BEC6','transaction','45.175.221.29','notificationCode=79B4B2-7F8EE68EE6AB-CEE466AF9F74-E7BEC6&notificationType=transaction','{\"Accept\":\"*/*\",\"Content-Type\":\"application/x-www-form-urlencoded;charset=UTF-8\",\"Accept-Encoding\":\"gzip,deflate\",\"traceparent\":\"00-97cd9dec31bea4cc51ed2dc2528428d1-476afaa69eb8b877-01\",\"Content-Length\":\"85\",\"Host\":\"cliente.carmeltec.com.br\",\"Connection\":\"keep-alive\",\"User-Agent\":\"Apache-HttpClient/5.2.3 (Java/17.0.11)\"}',1,'https://ws.pagseguro.uol.com.br/v2/transactions/notifications/79B4B2-7F8EE68EE6AB-CEE466AF9F74-E7BEC6?email=***&token=*** [accept=application/xml; charset=ISO-8859-1]',200,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:17:48.000-03:00</date><code>49B46FF8-BCEF-4D85-B0CC-50E338874598</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>3</status><lastEventDate>2025-11-29T14:18:23.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.65</feeAmount><netAmount>4.35</netAmount><extraAmount>0.00</extraAmount><escrowEndDate>2025-12-13T14:17:48.000-03:00</escrowEndDate><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Camilla Carla</name><email>carmeltecsoftware@gmail.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation><contractType>FULL</contractType><contractDescription>Tipo de contrato quando a liquidação ocorre internamente</contractDescription></liquidation></transaction>','49B46FF8-BCEF-4D85-B0CC-50E338874598','LINK_PAGAE=81ghaLqVp',3,'Paga',5.00,1),(3,'2025-11-29 14:39:19','A2294C-7AD889D889E7-0BB4CA8FA9F2-DA9F4C','transaction','45.175.221.29','notificationCode=A2294C-7AD889D889E7-0BB4CA8FA9F2-DA9F4C&notificationType=transaction','{\"Accept\":\"*/*\",\"Content-Type\":\"application/x-www-form-urlencoded;charset=UTF-8\",\"Accept-Encoding\":\"gzip,deflate\",\"traceparent\":\"00-8f3afe67192f77fb562856b86898e045-ceabf7a178173086-01\",\"Content-Length\":\"85\",\"Host\":\"cliente.carmeltec.com.br\",\"Connection\":\"keep-alive\",\"User-Agent\":\"Apache-HttpClient/5.2.3 (Java/17.0.11)\"}',1,'https://ws.pagseguro.uol.com.br/v2/transactions/notifications/A2294C-7AD889D889E7-0BB4CA8FA9F2-DA9F4C?email=***&token=*** [accept=application/xml; charset=ISO-8859-1]',200,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:38:12.000-03:00</date><code>5EDF25FF-DB60-44EC-8061-9873839E9FC0</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>7</status><cancellationSource>INTERNAL</cancellationSource><lastEventDate>2025-11-29T14:39:17.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.00</feeAmount><netAmount>5.00</netAmount><extraAmount>0.00</extraAmount><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Joicemara Massari</name><email>kopkop@kopkop.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation/></transaction>','5EDF25FF-DB60-44EC-8061-9873839E9FC0','LINK_PAGAE=81ghaLqVp',7,'Cancelada',5.00,0),(4,'2025-11-29 14:40:05','573BB8-9307BB07BB71-ACC440EFB81E-5AD45E','transaction','45.175.221.29','notificationCode=573BB8-9307BB07BB71-ACC440EFB81E-5AD45E&notificationType=transaction','{\"Accept\":\"*/*\",\"Content-Type\":\"application/x-www-form-urlencoded;charset=UTF-8\",\"Accept-Encoding\":\"gzip,deflate\",\"traceparent\":\"00-0b91f2feeb6e7d961664843340f7af7d-0295a1d99f89ac64-01\",\"Content-Length\":\"85\",\"Host\":\"cliente.carmeltec.com.br\",\"Connection\":\"keep-alive\",\"User-Agent\":\"Apache-HttpClient/5.2.3 (Java/17.0.11)\"}',1,'https://ws.pagseguro.uol.com.br/v2/transactions/notifications/573BB8-9307BB07BB71-ACC440EFB81E-5AD45E?email=***&token=*** [accept=application/xml; charset=ISO-8859-1]',200,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:39:02.000-03:00</date><code>085DD3A7-B50E-49C6-A524-73C4A2DAEED1</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>7</status><cancellationSource>INTERNAL</cancellationSource><lastEventDate>2025-11-29T14:40:04.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.00</feeAmount><netAmount>5.00</netAmount><extraAmount>0.00</extraAmount><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Joicemara Massari</name><email>kopkop@kopkop.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation/></transaction>','085DD3A7-B50E-49C6-A524-73C4A2DAEED1','LINK_PAGAE=81ghaLqVp',7,'Cancelada',5.00,0),(5,'2025-11-29 14:40:25','A4BA25-5004E404E410-7334832F90B1-1701D2','transaction','45.175.221.29','notificationCode=A4BA25-5004E404E410-7334832F90B1-1701D2&notificationType=transaction','{\"Accept\":\"*/*\",\"Content-Type\":\"application/x-www-form-urlencoded;charset=UTF-8\",\"Accept-Encoding\":\"gzip,deflate\",\"traceparent\":\"00-0d05145fffd3a9b78bcae85088b17844-699189b3d381decf-01\",\"Content-Length\":\"85\",\"Host\":\"cliente.carmeltec.com.br\",\"Connection\":\"keep-alive\",\"User-Agent\":\"Apache-HttpClient/5.2.3 (Java/17.0.11)\"}',1,'https://ws.pagseguro.uol.com.br/v2/transactions/notifications/A4BA25-5004E404E410-7334832F90B1-1701D2?email=***&token=*** [accept=application/xml; charset=ISO-8859-1]',200,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:39:49.000-03:00</date><code>2AE4EDF4-E076-4F1B-BA67-2D7702703760</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>7</status><cancellationSource>EXTERNAL</cancellationSource><lastEventDate>2025-11-29T14:40:24.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.00</feeAmount><netAmount>5.00</netAmount><extraAmount>0.00</extraAmount><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Joicemara Massari</name><email>kopkop@kopkop.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation/></transaction>','2AE4EDF4-E076-4F1B-BA67-2D7702703760','LINK_PAGAE=81ghaLqVp',7,'Cancelada',5.00,0),(6,'2025-11-29 14:57:46','853E29-BCB301B301EE-B554319F99F1-2B3D4B','transaction','45.175.221.29','notificationCode=853E29-BCB301B301EE-B554319F99F1-2B3D4B&notificationType=transaction','{\"Accept\":\"*/*\",\"Content-Type\":\"application/x-www-form-urlencoded;charset=UTF-8\",\"Accept-Encoding\":\"gzip,deflate\",\"traceparent\":\"00-74d16539d23837463e277d051b97649b-6eee2815969ff935-01\",\"Content-Length\":\"85\",\"Host\":\"cliente.carmeltec.com.br\",\"Connection\":\"keep-alive\",\"User-Agent\":\"Apache-HttpClient/5.2.3 (Java/17.0.11)\"}',1,'https://ws.pagseguro.uol.com.br/v2/transactions/notifications/853E29-BCB301B301EE-B554319F99F1-2B3D4B?email=***&token=*** [accept=application/xml; charset=ISO-8859-1]',200,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:57:11.000-03:00</date><code>749A34B6-381C-4510-8A2E-E823615CC8DC</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>3</status><lastEventDate>2025-11-29T14:57:45.000-03:00</lastEventDate><paymentMethod><type>1</type><code>101</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.65</feeAmount><netAmount>4.35</netAmount><extraAmount>0.00</extraAmount><escrowEndDate>2025-12-13T14:57:11.000-03:00</escrowEndDate><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Gilberto Aparecido Massari</name><email>testegil@gmail.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation><contractType>FULL</contractType><contractDescription>Tipo de contrato quando a liquidação ocorre internamente</contractDescription></liquidation></transaction>','749A34B6-381C-4510-8A2E-E823615CC8DC','LINK_PAGAE=81ghaLqVp',3,'Paga',5.00,1);

--
-- Table structure for table `pagseguro_transactions`
--

CREATE TABLE `pagseguro_transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `transaction_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` tinyint DEFAULT NULL,
  `status_code` tinyint DEFAULT NULL,
  `status_label` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_date` datetime DEFAULT NULL,
  `last_event_at` datetime DEFAULT NULL,
  `payment_method_type` tinyint DEFAULT NULL,
  `payment_method_code` int DEFAULT NULL,
  `gross_amount` decimal(12,2) DEFAULT NULL,
  `discount_amount` decimal(12,2) DEFAULT NULL,
  `fee_amount` decimal(12,2) DEFAULT NULL,
  `net_amount` decimal(12,2) DEFAULT NULL,
  `extra_amount` decimal(12,2) DEFAULT NULL,
  `installment_count` int DEFAULT NULL,
  `item_count` int DEFAULT NULL,
  `payment_link` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payer_document` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paid` tinyint(1) DEFAULT NULL,
  `raw_xml` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_transaction_code` (`transaction_code`),
  KEY `idx_transaction_status` (`status_code`),
  KEY `idx_transaction_reference` (`reference`),
  KEY `idx_transaction_email` (`payer_email`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pagseguro_transactions`
--

INSERT INTO `pagseguro_transactions` VALUES (1,'2025-11-29 14:18:06','2025-11-29 14:18:06','3F2275F2-2355-468B-8237-FFF3128BD2FA','LINK_PAGAE=81ghaLqVp',1,7,'Cancelada','2025-11-29 14:16:48','2025-11-29 14:18:03',1,102,5.00,0.00,0.00,5.00,0.00,1,1,NULL,'Camilla Carla','carmeltecsoftware@gmail.com',NULL,0,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:16:48.000-03:00</date><code>3F2275F2-2355-468B-8237-FFF3128BD2FA</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>7</status><cancellationSource>INTERNAL</cancellationSource><lastEventDate>2025-11-29T14:18:03.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.00</feeAmount><netAmount>5.00</netAmount><extraAmount>0.00</extraAmount><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Camilla Carla</name><email>carmeltecsoftware@gmail.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation/></transaction>'),(2,'2025-11-29 14:18:24','2025-11-29 14:18:24','49B46FF8-BCEF-4D85-B0CC-50E338874598','LINK_PAGAE=81ghaLqVp',1,3,'Paga','2025-11-29 14:17:48','2025-11-29 14:18:23',1,102,5.00,0.00,0.65,4.35,0.00,1,1,NULL,'Camilla Carla','carmeltecsoftware@gmail.com',NULL,1,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:17:48.000-03:00</date><code>49B46FF8-BCEF-4D85-B0CC-50E338874598</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>3</status><lastEventDate>2025-11-29T14:18:23.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.65</feeAmount><netAmount>4.35</netAmount><extraAmount>0.00</extraAmount><escrowEndDate>2025-12-13T14:17:48.000-03:00</escrowEndDate><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Camilla Carla</name><email>carmeltecsoftware@gmail.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation><contractType>FULL</contractType><contractDescription>Tipo de contrato quando a liquidação ocorre internamente</contractDescription></liquidation></transaction>'),(3,'2025-11-29 14:39:20','2025-11-29 14:39:20','5EDF25FF-DB60-44EC-8061-9873839E9FC0','LINK_PAGAE=81ghaLqVp',1,7,'Cancelada','2025-11-29 14:38:12','2025-11-29 14:39:17',1,102,5.00,0.00,0.00,5.00,0.00,1,1,NULL,'Joicemara Massari','kopkop@kopkop.com',NULL,0,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:38:12.000-03:00</date><code>5EDF25FF-DB60-44EC-8061-9873839E9FC0</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>7</status><cancellationSource>INTERNAL</cancellationSource><lastEventDate>2025-11-29T14:39:17.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.00</feeAmount><netAmount>5.00</netAmount><extraAmount>0.00</extraAmount><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Joicemara Massari</name><email>kopkop@kopkop.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation/></transaction>'),(4,'2025-11-29 14:40:06','2025-11-29 14:40:06','085DD3A7-B50E-49C6-A524-73C4A2DAEED1','LINK_PAGAE=81ghaLqVp',1,7,'Cancelada','2025-11-29 14:39:02','2025-11-29 14:40:04',1,102,5.00,0.00,0.00,5.00,0.00,1,1,NULL,'Joicemara Massari','kopkop@kopkop.com',NULL,0,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:39:02.000-03:00</date><code>085DD3A7-B50E-49C6-A524-73C4A2DAEED1</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>7</status><cancellationSource>INTERNAL</cancellationSource><lastEventDate>2025-11-29T14:40:04.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.00</feeAmount><netAmount>5.00</netAmount><extraAmount>0.00</extraAmount><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Joicemara Massari</name><email>kopkop@kopkop.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation/></transaction>'),(5,'2025-11-29 14:40:26','2025-11-29 14:40:26','2AE4EDF4-E076-4F1B-BA67-2D7702703760','LINK_PAGAE=81ghaLqVp',1,7,'Cancelada','2025-11-29 14:39:49','2025-11-29 14:40:24',1,102,5.00,0.00,0.00,5.00,0.00,1,1,NULL,'Joicemara Massari','kopkop@kopkop.com',NULL,0,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:39:49.000-03:00</date><code>2AE4EDF4-E076-4F1B-BA67-2D7702703760</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>7</status><cancellationSource>EXTERNAL</cancellationSource><lastEventDate>2025-11-29T14:40:24.000-03:00</lastEventDate><paymentMethod><type>1</type><code>102</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.00</feeAmount><netAmount>5.00</netAmount><extraAmount>0.00</extraAmount><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Joicemara Massari</name><email>kopkop@kopkop.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation/></transaction>'),(6,'2025-11-29 14:57:48','2025-11-29 14:57:48','749A34B6-381C-4510-8A2E-E823615CC8DC','LINK_PAGAE=81ghaLqVp',1,3,'Paga','2025-11-29 14:57:11','2025-11-29 14:57:45',1,101,5.00,0.00,0.65,4.35,0.00,1,1,NULL,'Gilberto Aparecido Massari','testegil@gmail.com',NULL,1,'<?xml version=\"1.0\" encoding=\"ISO-8859-1\" standalone=\"yes\"?><transaction><date>2025-11-29T14:57:11.000-03:00</date><code>749A34B6-381C-4510-8A2E-E823615CC8DC</code><reference>LINK_PAGAE=81ghaLqVp</reference><type>1</type><status>3</status><lastEventDate>2025-11-29T14:57:45.000-03:00</lastEventDate><paymentMethod><type>1</type><code>101</code></paymentMethod><grossAmount>5.00</grossAmount><discountAmount>0.00</discountAmount><feeAmount>0.65</feeAmount><netAmount>4.35</netAmount><extraAmount>0.00</extraAmount><escrowEndDate>2025-12-13T14:57:11.000-03:00</escrowEndDate><installmentCount>1</installmentCount><itemCount>1</itemCount><items><item><id>AUTO_ID 0</id><description>Desafio das inteligências 30 dias</description><quantity>1</quantity><amount>5.00</amount></item></items><sender><name>Gilberto Aparecido Massari</name><email>testegil@gmail.com</email><phone><areaCode>43</areaCode><number>984874300</number></phone></sender><liquidation><contractType>FULL</contractType><contractDescription>Tipo de contrato quando a liquidação ocorre internamente</contractDescription></liquidation></transaction>');

--
-- Table structure for table `progress_intelligence`
--

CREATE TABLE `progress_intelligence` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `intelligence_id` int NOT NULL,
  `progress_percent` decimal(5,2) NOT NULL DEFAULT '0.00',
  `streak_days` int NOT NULL DEFAULT '0',
  `last_activity` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_progress` (`user_id`,`intelligence_id`),
  KEY `intelligence_id` (`intelligence_id`),
  CONSTRAINT `progress_intelligence_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `progress_intelligence_ibfk_2` FOREIGN KEY (`intelligence_id`) REFERENCES `intelligences` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `progress_intelligence`
--

INSERT INTO `progress_intelligence` VALUES (1,2,1,75.00,3,'2025-11-17','2025-11-15 18:00:00'),(2,6,1,28.58,1,'2025-11-17','2025-11-18 01:41:59'),(4,7,1,75.00,3,'2025-11-17','2025-11-18 01:54:25'),(5,8,1,42.87,2,'2025-11-18','2025-11-18 02:16:02'),(6,9,1,14.29,1,'2025-11-18','2025-11-18 21:33:47'),(7,10,1,14.29,1,'2025-11-18','2025-11-18 21:51:34'),(8,11,1,57.16,1,'2025-11-23','2025-11-18 22:06:41'),(9,12,1,42.87,1,'2025-11-25','2025-11-18 22:46:00'),(10,3,1,14.29,1,'2025-11-19','2025-11-19 13:46:23'),(11,13,1,14.29,1,'2025-11-23','2025-11-23 14:21:10'),(12,15,1,28.58,1,'2025-11-23','2025-11-23 14:31:42'),(13,16,1,57.16,1,'2025-11-23','2025-11-23 14:49:35'),(14,31,1,14.29,1,'2025-11-24','2025-11-24 12:18:53'),(15,32,1,14.29,1,'2025-11-24','2025-11-24 12:46:36'),(16,33,1,14.29,1,'2025-11-24','2025-11-24 12:49:33'),(17,34,1,14.29,1,'2025-11-24','2025-11-24 12:58:06'),(18,35,1,28.58,1,'2025-11-24','2025-11-24 13:03:13'),(19,36,1,28.58,1,'2025-11-24','2025-11-24 13:22:49'),(20,37,1,14.29,1,'2025-11-24','2025-11-24 13:37:10'),(21,47,1,28.58,1,'2025-11-26','2025-11-26 13:40:38'),(22,51,1,14.29,1,'2025-11-28','2025-11-29 02:27:39'),(23,52,1,42.87,1,'2025-11-29','2025-11-29 03:03:08'),(24,53,1,14.29,1,'2025-11-29','2025-11-29 14:02:42'),(25,62,1,57.16,1,'2025-12-01','2025-12-01 13:40:58'),(26,50,1,57.16,1,'2025-12-01','2025-12-01 18:04:36'),(27,64,1,14.29,1,'2025-12-01','2025-12-02 01:57:18');

--
-- Table structure for table `quiz_options`
--

CREATE TABLE `quiz_options` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quiz_id` int NOT NULL,
  `option_text` varchar(255) NOT NULL,
  `is_correct` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `quiz_id` (`quiz_id`),
  CONSTRAINT `quiz_options_ibfk_1` FOREIGN KEY (`quiz_id`) REFERENCES `quizzes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `quiz_options`
--

INSERT INTO `quiz_options` VALUES (10,3,'Conhecimento de si mesmo',1,'2025-11-18 18:48:39'),(11,3,'Conhecimento dos outros',0,'2025-11-18 18:48:39'),(12,3,'Conhecimentos gerais',0,'2025-11-18 18:48:39'),(13,3,'Conhecimento sobre pessoas',0,'2025-11-18 18:48:39'),(14,4,'Verdadeiro',1,'2025-11-18 18:56:42'),(15,4,'Falso',0,'2025-11-18 18:56:42'),(16,5,'Verdadeiro',1,'2025-11-18 22:35:23'),(17,5,'Falso',0,'2025-11-18 22:35:23'),(18,17,'Verdadeiro',1,'2025-11-24 00:52:27'),(19,17,'Falso',0,'2025-11-24 00:52:27'),(20,18,'Verdadeiro',1,'2025-11-24 01:12:01'),(21,18,'Falso',0,'2025-11-24 01:12:01'),(26,21,'Verdadeiro',1,'2025-12-01 12:56:11'),(27,21,'Falso',0,'2025-12-01 12:56:11'),(28,20,'Conhecimento de si mesmo.',1,'2025-12-01 12:57:55'),(29,20,'Não olhar para si mesmo, para dentro.',0,'2025-12-01 12:57:55'),(30,20,'Não saber o que deseja, seus gostos e motivações.',0,'2025-12-01 12:57:55'),(31,20,'Consciência de suas obrigações.',0,'2025-12-01 12:57:55'),(32,22,'Trabalhar mais horas todos os dias.',0,'2025-12-01 13:22:49'),(33,22,'Alimentar a mente apenas com pensamentos positivos.',1,'2025-12-01 13:22:49'),(34,22,'Repetir afirmações sem acreditar nelas.',0,'2025-12-01 13:22:49'),(35,22,'Ignorar emoções negativas e seguir em frente',0,'2025-12-01 13:22:49'),(36,23,'Verdadeiro',1,'2025-12-01 13:23:27'),(37,23,'Falso',0,'2025-12-01 13:23:27');

--
-- Table structure for table `quiz_pairs`
--

CREATE TABLE `quiz_pairs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quiz_id` int NOT NULL,
  `prompt` varchar(255) NOT NULL,
  `match` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `quiz_id` (`quiz_id`),
  CONSTRAINT `quiz_pairs_ibfk_1` FOREIGN KEY (`quiz_id`) REFERENCES `quizzes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `quiz_pairs`
--


--
-- Table structure for table `quizzes`
--

CREATE TABLE `quizzes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `day_id` int DEFAULT NULL,
  `daily_challenge_id` int DEFAULT NULL,
  `quiz_type` enum('multiple_choice','true_false','match','fill_in','essay','photo','audio') NOT NULL,
  `question` text NOT NULL,
  `language` enum('pt','es','en') NOT NULL DEFAULT 'pt',
  `points` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `day_id` (`day_id`),
  KEY `daily_challenge_id` (`daily_challenge_id`),
  CONSTRAINT `quizzes_ibfk_1` FOREIGN KEY (`day_id`) REFERENCES `days` (`id`) ON DELETE SET NULL,
  CONSTRAINT `quizzes_ibfk_2` FOREIGN KEY (`daily_challenge_id`) REFERENCES `daily_challenges` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `quizzes`
--

INSERT INTO `quizzes` VALUES (3,NULL,NULL,'multiple_choice','É considerado inteligência interpessoal:','pt',1,'2025-11-18 18:48:39'),(4,NULL,NULL,'true_false','Você sente que se conhece melhor agora que  adquiriu estes conhecimentos de inteligência intrapessoal?','pt',1,'2025-11-18 18:56:42'),(5,NULL,NULL,'true_false','O subconsciente influencia nossas decisões mesmo quando não percebemos','pt',1,'2025-11-18 22:35:23'),(6,NULL,NULL,'essay','O que você aprendeu nesta lição?','pt',1,'2025-11-19 13:07:16'),(7,NULL,NULL,'essay','Qual seu maior sonho a realizar?','pt',1,'2025-11-19 13:43:00'),(8,NULL,NULL,'essay','Qual sua comida favorita?','pt',1,'2025-11-19 13:43:22'),(9,NULL,NULL,'essay','Qual seu maior medo?','pt',1,'2025-11-19 13:43:47'),(10,NULL,NULL,'essay','Qual foi o dia mais feliz da sua vida?','pt',1,'2025-11-19 13:44:23'),(11,NULL,NULL,'essay','O que mais gostou no filme?','pt',1,'2025-11-19 13:51:24'),(12,NULL,NULL,'essay','Como vai aplicar este conhecimento na sua vida?','pt',1,'2025-11-19 13:51:47'),(13,NULL,NULL,'photo','Envie uma foto da sua familia assistindo ao filme da semana!','pt',1,'2025-11-23 14:17:43'),(14,NULL,NULL,'photo','Teste foto','pt',1,'2025-11-23 14:47:58'),(16,NULL,NULL,'audio','teste audio','pt',1,'2025-11-23 16:35:31'),(17,NULL,4,'true_false','Teste vdd ou falso','pt',1,'2025-11-24 00:52:27'),(18,NULL,3,'true_false','Teste','pt',1,'2025-11-24 01:12:01'),(19,NULL,NULL,'essay','O que aprendeu nesta lição?','pt',10,'2025-11-24 13:07:02'),(20,8,NULL,'multiple_choice','Inteligência Intrapessoal é','pt',1,'2025-12-01 12:31:05'),(21,8,NULL,'true_false','A Inteligência Intrapessoal é sobre conhecer a si mesmo.','pt',1,'2025-12-01 12:56:11'),(22,9,NULL,'multiple_choice','Segundo o vídeo “O Poder do Subconsciente”, qual é o ponto central para transformar sua vida?','pt',1,'2025-12-01 13:22:49'),(23,9,NULL,'true_false','O subconsciente aceita qualquer ideia que você alimenta repetidamente, seja ela boa ou ruim.','pt',1,'2025-12-01 13:23:27'),(24,9,NULL,'essay','Após assistir ao vídeo, qual frase mais gostou?','pt',1,'2025-12-01 13:24:05'),(25,10,NULL,'essay','O que mais gostou?','pt',1,'2025-12-01 13:30:06'),(26,10,NULL,'essay','Como vai aplicar este conhecimento na sua vida?','pt',2,'2025-12-01 13:30:54'),(27,10,NULL,'photo','Mande uma foto da sua family se divertindo no Cine Sabedoria!!!','pt',1,'2025-12-01 13:32:13'),(28,11,NULL,'essay','Qual seu maior sonho a realizar?','pt',1,'2025-12-01 13:36:45'),(29,11,NULL,'essay','Qual sua comida favorita?','pt',1,'2025-12-01 13:37:13'),(30,11,NULL,'essay','Qual seu maior medo?','pt',1,'2025-12-01 13:37:43'),(31,11,NULL,'photo','Mande uma foto,fazendo o quizz com a sua familia.','pt',1,'2025-12-01 13:38:29'),(32,8,5,'essay','Priorizando Prioridades: O que é mais importante?','pt',5,'2025-12-01 17:21:15'),(33,11,5,'photo','Manda uma foto das pessoas que voce mais ama.','pt',1,'2025-12-01 17:22:56');

--
-- Table structure for table `referrals`
--

CREATE TABLE `referrals` (
  `id` int NOT NULL AUTO_INCREMENT,
  `referrer_id` int NOT NULL,
  `referral_code` varchar(20) NOT NULL,
  `referred_email` varchar(150) DEFAULT NULL,
  `referred_user_id` int DEFAULT NULL,
  `status` enum('pending','accepted','rejected') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `accepted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `referrer_id` (`referrer_id`),
  KEY `referred_user_id` (`referred_user_id`),
  KEY `idx_referrals_code` (`referral_code`),
  CONSTRAINT `referrals_ibfk_1` FOREIGN KEY (`referrer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `referrals_ibfk_2` FOREIGN KEY (`referred_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `referrals`
--

INSERT INTO `referrals` VALUES (1,2,'65230E84',NULL,NULL,'pending','2025-11-15 16:02:15',NULL),(2,6,'35040DC7',NULL,NULL,'pending','2025-11-15 18:27:14',NULL),(3,7,'A95ECE53',NULL,NULL,'pending','2025-11-18 01:54:44',NULL),(4,9,'B3F68F20',NULL,NULL,'pending','2025-11-18 20:58:21',NULL),(5,10,'CDC8B42C',NULL,NULL,'pending','2025-11-18 21:50:55',NULL),(6,8,'D1F288F5',NULL,NULL,'pending','2025-11-18 22:05:41',NULL),(7,11,'3CC75B2C',NULL,NULL,'pending','2025-11-19 13:14:06',NULL),(8,15,'C02DC784',NULL,NULL,'pending','2025-11-23 14:37:40',NULL),(9,17,'73329C51',NULL,NULL,'pending','2025-11-23 14:50:32',NULL),(10,16,'E1FF2ACF',NULL,NULL,'pending','2025-11-23 16:58:46',NULL),(11,19,'D1E2727A',NULL,NULL,'pending','2025-11-23 20:55:34',NULL),(12,22,'FD14B780',NULL,NULL,'pending','2025-11-23 22:07:45',NULL),(13,23,'41916539',NULL,NULL,'pending','2025-11-23 22:10:13',NULL),(14,25,'619154D0',NULL,NULL,'pending','2025-11-23 22:28:08',NULL),(15,26,'7A06D0F9',NULL,NULL,'pending','2025-11-23 22:28:30',NULL),(16,28,'5825C70A',NULL,NULL,'pending','2025-11-24 01:13:15',NULL),(17,12,'493CF3BE',NULL,NULL,'pending','2025-11-24 02:06:47',NULL),(18,29,'DBE292EF',NULL,NULL,'pending','2025-11-24 10:50:54',NULL),(19,42,'5828E720',NULL,NULL,'pending','2025-11-25 14:38:05',NULL),(20,45,'949EDF47',NULL,46,'accepted','2025-11-26 12:28:06','2025-11-26 09:28:06');

--
-- Table structure for table `rewards`
--

CREATE TABLE `rewards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `description` text,
  `cost_coins` int NOT NULL,
  `available_quantity` int DEFAULT NULL,
  `valid_from` date DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rewards`
--

INSERT INTO `rewards` VALUES (1,'Poster Digital','Arte exclusiva do desafio para imprimir em casa.',10,93,'2025-11-10','2025-12-31','2025-11-15 15:54:03');

--
-- Table structure for table `schools`
--

CREATE TABLE `schools` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `location` varchar(150) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `schools`
--

INSERT INTO `schools` VALUES (1,'Escola Alfa','Cidade A','2025-11-15 15:54:03'),(2,'Escola Beta','Cidade B','2025-11-15 15:54:03');

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `rating` tinyint NOT NULL,
  `comment` text NOT NULL,
  `approved` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `testimonials_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` VALUES (1,2,5,'Aplicativo incrível para conversar sobre sentimentos.',1,'2025-11-15 13:00:00'),(2,15,4,'Achei o aplicativo bacana.',1,'2025-11-23 14:37:30'),(3,51,3,'ejndjendjendjend',1,'2025-11-29 02:48:51'),(4,52,5,'sqdsdwcwdcefcfec',1,'2025-11-29 02:59:25'),(5,53,5,'App bacana!',1,'2025-11-29 14:21:52'),(6,62,3,'sxsaxsxsaxsxsaxasxaxa',1,'2025-12-01 16:51:27');

--
-- Table structure for table `trails`
--

CREATE TABLE `trails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `intelligence_id` int NOT NULL,
  `week_number` int NOT NULL,
  `title` varchar(150) NOT NULL,
  `description` text,
  `featured_intelligence_name` varchar(150) DEFAULT NULL,
  `featured_intelligence_icon` varchar(60) DEFAULT NULL,
  `available_from` date NOT NULL,
  `available_to` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `intelligence_id` (`intelligence_id`),
  CONSTRAINT `trails_ibfk_1` FOREIGN KEY (`intelligence_id`) REFERENCES `intelligences` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `trails`
--

INSERT INTO `trails` VALUES (3,1,1,'Semana 1 - Autoconhecimento','Primeiros passos para identificar e nomear emoções. Inclui exercícios guiados e atividades com a família.',NULL,NULL,'2025-12-01','2025-12-07','2025-12-01 12:06:28'),(4,1,1,'Inteligência Intrapessoal',NULL,'Inteligência Intrapessoal','intrapessoal','2025-12-01',NULL,'2025-12-01 17:29:50');

--
-- Table structure for table `user_achievements`
--

CREATE TABLE `user_achievements` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `achievement_id` int NOT NULL,
  `earned_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_user_achievement` (`user_id`,`achievement_id`),
  KEY `achievement_id` (`achievement_id`),
  CONSTRAINT `user_achievements_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_achievements_ibfk_2` FOREIGN KEY (`achievement_id`) REFERENCES `achievements` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_achievements`
--

INSERT INTO `user_achievements` VALUES (1,2,1,'2025-11-17 22:50:27'),(4,7,1,'2025-11-17 22:54:24');

--
-- Table structure for table `user_challenges`
--

CREATE TABLE `user_challenges` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `challenge_id` int NOT NULL,
  `started_at` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `points_earned` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `challenge_id` (`challenge_id`),
  CONSTRAINT `user_challenges_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_challenges_ibfk_2` FOREIGN KEY (`challenge_id`) REFERENCES `challenges` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_challenges`
--

INSERT INTO `user_challenges` VALUES (1,2,1,'2025-11-15 12:00:00','2025-11-15 12:30:00',20,'2025-11-15 12:30:00'),(2,6,1,'2025-11-17 22:38:40','2025-11-17 22:38:40',20,'2025-11-18 01:38:40'),(3,6,2,'2025-11-17 22:38:47','2025-11-17 22:38:47',30,'2025-11-18 01:38:47'),(4,6,3,'2025-11-17 22:38:56','2025-11-17 22:38:56',25,'2025-11-18 01:38:56'),(5,8,2,'2025-11-17 23:28:28','2025-11-17 23:28:28',30,'2025-11-18 02:28:28'),(6,8,1,'2025-11-17 23:28:36','2025-11-17 23:28:36',20,'2025-11-18 02:28:36'),(7,12,1,'2025-11-18 19:49:59','2025-11-18 19:50:08',20,'2025-11-18 22:49:59'),(8,12,2,'2025-11-18 19:50:15','2025-11-18 19:50:15',30,'2025-11-18 22:50:15'),(9,15,2,'2025-11-23 11:36:22','2025-11-23 11:36:22',30,'2025-11-23 14:36:22'),(10,16,2,'2025-11-23 13:48:11','2025-11-23 13:48:11',30,'2025-11-23 16:48:11'),(11,26,1,'2025-11-23 19:29:11','2025-11-23 19:29:11',20,'2025-11-23 22:29:11'),(12,8,3,'2025-11-23 20:14:26','2025-11-23 20:14:26',25,'2025-11-23 23:14:26');

--
-- Table structure for table `user_classes`
--

CREATE TABLE `user_classes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `class_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `class_id` (`class_id`),
  CONSTRAINT `user_classes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_classes_ibfk_2` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_classes`
--

INSERT INTO `user_classes` VALUES (1,6,1,'2025-11-15 18:26:36'),(2,7,1,'2025-11-18 01:54:08'),(3,8,1,'2025-11-18 02:15:36'),(4,9,1,'2025-11-18 20:57:45'),(5,10,1,'2025-11-18 21:50:26'),(6,11,1,'2025-11-18 22:06:28'),(7,12,1,'2025-11-18 22:45:10'),(8,13,1,'2025-11-23 14:20:00'),(9,15,1,'2025-11-23 14:22:40'),(10,16,1,'2025-11-23 14:48:41'),(11,17,1,'2025-11-23 14:50:13'),(12,18,1,'2025-11-23 14:51:58'),(13,19,1,'2025-11-23 20:54:46'),(14,20,1,'2025-11-23 21:32:18'),(15,21,1,'2025-11-23 22:07:16'),(16,22,1,'2025-11-23 22:07:22'),(17,23,1,'2025-11-23 22:08:50'),(18,25,1,'2025-11-23 22:27:19'),(19,26,1,'2025-11-23 22:27:33'),(20,27,1,'2025-11-24 01:03:22'),(21,28,1,'2025-11-24 01:08:15'),(22,29,1,'2025-11-24 10:50:05'),(23,30,1,'2025-11-24 11:16:18'),(24,31,1,'2025-11-24 11:18:35'),(25,32,1,'2025-11-24 12:45:27'),(26,33,1,'2025-11-24 12:48:45'),(27,34,1,'2025-11-24 12:57:36'),(28,35,1,'2025-11-24 13:02:32'),(29,36,1,'2025-11-24 13:22:14'),(30,37,1,'2025-11-24 13:35:56'),(31,38,1,'2025-11-24 13:50:13'),(32,40,1,'2025-11-25 12:53:17'),(33,41,1,'2025-11-25 14:04:49'),(34,42,1,'2025-11-25 14:08:22'),(35,43,1,'2025-11-25 14:54:38'),(36,44,1,'2025-11-25 14:55:46'),(37,45,1,'2025-11-26 11:55:50'),(38,46,1,'2025-11-26 12:28:06'),(39,47,1,'2025-11-26 13:10:17');

--
-- Table structure for table `user_daily_challenges`
--

CREATE TABLE `user_daily_challenges` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `daily_challenge_id` int NOT NULL,
  `started_at` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `points_earned` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_user_daily` (`user_id`,`daily_challenge_id`),
  KEY `daily_challenge_id` (`daily_challenge_id`),
  CONSTRAINT `fk_user_daily_challenge` FOREIGN KEY (`daily_challenge_id`) REFERENCES `daily_challenges` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_user_daily_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_daily_challenges`
--

INSERT INTO `user_daily_challenges` VALUES (3,8,3,'2025-11-23 20:41:00','2025-11-23 20:41:00',15,'2025-11-23 23:41:00'),(4,8,4,'2025-11-23 21:53:00','2025-11-23 21:53:00',10,'2025-11-24 00:53:00'),(5,27,3,'2025-11-23 22:04:04','2025-11-23 22:04:04',15,'2025-11-24 01:04:04'),(6,27,4,'2025-11-23 22:04:22','2025-11-23 22:04:22',10,'2025-11-24 01:04:22'),(7,28,4,'2025-11-23 22:08:33','2025-11-23 22:08:34',10,'2025-11-24 01:08:33'),(8,28,3,'2025-11-23 22:12:43','2025-11-23 22:12:43',15,'2025-11-24 01:12:43'),(9,42,3,'2025-11-25 11:33:57','2025-11-25 11:33:57',15,'2025-11-25 14:33:57'),(10,42,4,'2025-11-25 11:34:44','2025-11-25 11:34:44',10,'2025-11-25 14:34:44'),(11,51,3,'2025-11-28 23:44:46','2025-11-28 23:44:46',15,'2025-11-29 02:44:46'),(12,51,4,'2025-11-28 23:47:54','2025-11-28 23:47:54',10,'2025-11-29 02:47:54'),(13,52,3,'2025-11-29 00:06:04','2025-11-29 00:06:05',15,'2025-11-29 03:06:04'),(14,52,4,'2025-11-29 00:06:33','2025-11-29 00:06:34',10,'2025-11-29 03:06:33'),(15,53,3,'2025-11-29 11:08:28','2025-11-29 11:08:28',15,'2025-11-29 14:08:28'),(16,53,4,'2025-11-29 11:08:38','2025-11-29 11:08:38',10,'2025-11-29 14:08:38'),(17,50,5,'2025-12-01 15:04:36','2025-12-01 15:04:36',10,'2025-12-01 18:04:36'),(18,64,5,'2025-12-01 22:55:23','2025-12-01 22:55:37',10,'2025-12-02 01:55:23');

--
-- Table structure for table `user_day_progress`
--

CREATE TABLE `user_day_progress` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `day_id` int NOT NULL,
  `status` enum('locked','unlocked','completed') NOT NULL DEFAULT 'locked',
  `started_at` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  `points_earned` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_day_user` (`user_id`,`day_id`),
  KEY `day_id` (`day_id`),
  CONSTRAINT `user_day_progress_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_day_progress_ibfk_2` FOREIGN KEY (`day_id`) REFERENCES `days` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_day_progress`
--

INSERT INTO `user_day_progress` VALUES (41,62,8,'completed',NULL,'2025-12-01 10:40:58',10,'2025-12-01 13:40:58'),(42,62,9,'completed',NULL,'2025-12-01 10:42:21',10,'2025-12-01 13:42:21'),(43,62,10,'completed',NULL,'2025-12-01 10:44:59',10,'2025-12-01 13:44:59'),(44,62,11,'completed',NULL,'2025-12-01 11:19:34',10,'2025-12-01 14:19:34'),(45,50,8,'completed',NULL,'2025-12-01 15:04:36',10,'2025-12-01 18:04:36'),(46,50,9,'completed',NULL,'2025-12-01 15:06:30',10,'2025-12-01 18:06:30'),(47,50,10,'completed',NULL,'2025-12-01 15:07:53',10,'2025-12-01 18:07:53'),(48,50,11,'completed',NULL,'2025-12-01 15:09:36',10,'2025-12-01 18:09:36'),(49,64,9,'completed',NULL,'2025-12-01 22:57:18',10,'2025-12-02 01:57:18');

--
-- Table structure for table `user_families`
--

CREATE TABLE `user_families` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `family_id` int NOT NULL,
  `role` enum('parent','teen') NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `family_id` (`family_id`),
  CONSTRAINT `user_families_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_families_ibfk_2` FOREIGN KEY (`family_id`) REFERENCES `families` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_families`
--

INSERT INTO `user_families` VALUES (1,2,1,'teen','2025-11-15 15:54:03'),(2,5,2,'parent','2025-11-28 02:59:21'),(3,47,2,'parent','2025-11-28 02:59:21'),(4,17,3,'parent','2025-11-28 03:00:28'),(5,48,3,'teen','2025-11-28 03:00:28'),(6,49,4,'parent','2025-11-28 03:01:10'),(7,51,5,'parent','2025-11-29 02:21:47'),(8,52,5,'teen','2025-11-29 02:58:36'),(9,53,6,'parent','2025-11-29 13:57:59'),(10,54,7,'parent','2025-11-29 14:50:38'),(11,55,8,'parent','2025-11-29 14:52:44'),(12,56,9,'parent','2025-11-29 17:13:28'),(13,57,10,'parent','2025-11-29 17:14:57'),(14,58,11,'parent','2025-11-29 17:36:03'),(15,59,12,'parent','2025-11-29 17:50:46'),(16,60,13,'parent','2025-11-29 17:55:02'),(17,61,14,'parent','2025-11-29 18:15:51'),(18,62,6,'teen','2025-12-01 12:42:29'),(19,63,15,'parent','2025-12-01 18:02:00'),(20,64,15,'teen','2025-12-01 18:42:53');

--
-- Table structure for table `user_mentors`
--

CREATE TABLE `user_mentors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `mentor_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_mentor` (`user_id`,`mentor_id`),
  KEY `mentor_id` (`mentor_id`),
  CONSTRAINT `user_mentors_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_mentors_ibfk_2` FOREIGN KEY (`mentor_id`) REFERENCES `mentors` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_mentors`
--

INSERT INTO `user_mentors` VALUES (1,47,1,'2025-11-26 13:10:17');

--
-- Table structure for table `user_notifications`
--

CREATE TABLE `user_notifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `notification_id` int NOT NULL,
  `delivered_at` datetime NOT NULL,
  `read_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `notification_id` (`notification_id`),
  CONSTRAINT `user_notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_notifications_ibfk_2` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_notifications`
--

INSERT INTO `user_notifications` VALUES (1,2,1,'2025-11-11 08:01:00','2025-11-11 08:05:00');

--
-- Table structure for table `user_quiz_answers`
--

CREATE TABLE `user_quiz_answers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `quiz_id` int NOT NULL,
  `selected_option_id` int DEFAULT NULL,
  `answer_text` text,
  `answer_audio_url` varchar(255) DEFAULT NULL,
  `answer_image_url` varchar(255) DEFAULT NULL,
  `is_correct` tinyint(1) DEFAULT NULL,
  `validation_status` enum('pending','valid','invalid','manual_review') DEFAULT NULL,
  `validation_feedback` text,
  `ai_model` varchar(80) DEFAULT NULL,
  `ai_confidence` decimal(5,3) DEFAULT NULL,
  `ai_response_json` mediumtext,
  `answered_at` datetime NOT NULL,
  `points_earned` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `quiz_id` (`quiz_id`),
  KEY `selected_option_id` (`selected_option_id`),
  CONSTRAINT `user_quiz_answers_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_quiz_answers_ibfk_2` FOREIGN KEY (`quiz_id`) REFERENCES `quizzes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_quiz_answers_ibfk_3` FOREIGN KEY (`selected_option_id`) REFERENCES `quiz_options` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_quiz_answers`
--

INSERT INTO `user_quiz_answers` VALUES (3,8,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 15:56:57',1,'2025-11-18 18:56:57'),(4,8,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 16:10:18',1,'2025-11-18 19:10:18'),(5,8,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 16:10:22',1,'2025-11-18 19:10:22'),(6,8,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 17:10:15',1,'2025-11-18 20:10:15'),(7,8,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 17:10:18',1,'2025-11-18 20:10:18'),(8,9,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 18:33:45',1,'2025-11-18 21:33:45'),(9,9,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 18:33:47',1,'2025-11-18 21:33:47'),(10,10,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 18:51:30',1,'2025-11-18 21:51:30'),(11,10,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 18:51:33',1,'2025-11-18 21:51:33'),(12,11,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 19:06:38',1,'2025-11-18 22:06:38'),(13,11,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 19:06:41',1,'2025-11-18 22:06:41'),(14,12,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 19:45:51',1,'2025-11-18 22:45:51'),(15,12,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 19:46:00',1,'2025-11-18 22:46:00'),(16,12,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-18 19:46:52',1,'2025-11-18 22:46:52'),(17,11,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-19 10:07:56',1,'2025-11-19 13:07:56'),(18,11,6,NULL,'A conhecer melhor a mim mesmo, e que nem tudo acontece só de forma consciente, mas também inconsciente.',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-19 10:08:24',0,'2025-11-19 13:08:24'),(19,3,7,NULL,'Ir para a disney',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-19 10:45:32',0,'2025-11-19 13:45:32'),(20,3,8,NULL,'Chocolate.',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-19 10:45:50',0,'2025-11-19 13:45:50'),(21,3,9,NULL,'Lobisomem.',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-19 10:46:02',0,'2025-11-19 13:46:02'),(22,3,10,NULL,'Quando fui na praia com meus avós.',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-19 10:46:22',0,'2025-11-19 13:46:22'),(23,11,11,NULL,'A historia',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 11:18:09',0,'2025-11-23 14:18:09'),(24,11,12,NULL,'Prestar mais atenção em meus sentimentos',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 11:18:28',0,'2025-11-23 14:18:28'),(25,13,11,NULL,'Tudo, principalmente o protagonista',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 11:20:30',0,'2025-11-23 14:20:30'),(26,13,12,NULL,'Vou prestar mais atenção nas minhas emoções',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 11:20:43',0,'2025-11-23 14:20:43'),(27,13,13,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2025-11-23 11:21:09',0,'2025-11-23 14:21:09'),(28,15,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 11:31:35',1,'2025-11-23 14:31:35'),(29,15,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 11:32:29',1,'2025-11-23 14:32:29'),(30,15,6,NULL,'aprendi que não aprendi nada',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 11:32:52',0,'2025-11-23 14:32:52'),(31,11,11,NULL,'wqde2d3 fewfwefwef',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 11:37:59',0,'2025-11-23 14:37:59'),(32,11,12,NULL,'wefwef wefwefewf wefewfwef',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 11:38:03',0,'2025-11-23 14:38:03'),(33,11,13,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2025-11-23 11:38:31',0,'2025-11-23 14:38:31'),(34,16,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 11:49:10',1,'2025-11-23 14:49:10'),(35,16,6,NULL,'Muitas coisas, principalmente sobre mim mesmo',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 11:49:21',0,'2025-11-23 14:49:21'),(36,16,14,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2025-11-23 11:49:35',0,'2025-11-23 14:49:35'),(37,16,11,NULL,'we8fgweihf iweufhiweufh iuwefhiwufh',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:30:14',0,'2025-11-23 15:30:14'),(38,16,12,NULL,'efiuwhewiufhw weiufhweiufhiwhf weifhiweuh',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:30:22',0,'2025-11-23 15:30:22'),(39,16,11,NULL,'ewiufhuwefhw fwehfiuwehf weiufhweifhu',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:45:39',0,'2025-11-23 15:45:39'),(40,16,12,NULL,'efiuhewfhwe weufhiewufh weufhweiufh',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:45:44',0,'2025-11-23 15:45:44'),(41,16,11,NULL,'efwfe wefewfew wefwef',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:48:02',0,'2025-11-23 15:48:02'),(42,16,12,NULL,'wefwfe wefwefwef wefwef',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:48:05',0,'2025-11-23 15:48:05'),(43,16,11,NULL,'ewfewf wefwefew wefwefw',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:52:26',0,'2025-11-23 15:52:26'),(44,16,12,NULL,'ewfewfwef wefwefwef wfwefwefwef',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:52:36',0,'2025-11-23 15:52:36'),(45,16,13,NULL,NULL,NULL,'uploads/quiz_answers/image_20251123_125253_c91c7a7f.png',NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 12:52:53',0,'2025-11-23 15:52:53'),(46,16,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 13:23:36',1,'2025-11-23 16:23:36'),(47,16,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 13:23:41',1,'2025-11-23 16:23:41'),(49,16,7,NULL,'wfewfwef wefwefwefwef wfeewfwef',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:35:57',0,'2025-11-23 16:35:57'),(50,16,8,NULL,'wfwefwfew wefewfweef wefwefwefwefwef',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:36:04',0,'2025-11-23 16:36:04'),(51,16,9,NULL,'fwefewfewf wefewfwefwef weft',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:36:14',0,'2025-11-23 16:36:14'),(52,16,10,NULL,'fweewfcewefwefwef wefwefwef',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:36:19',0,'2025-11-23 16:36:19'),(53,16,7,NULL,'efwefewf wfwefewf fewf',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:40:08',0,'2025-11-23 16:40:08'),(54,16,8,NULL,'efwefewf wfwefewf fewf',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:40:14',0,'2025-11-23 16:40:14'),(55,16,9,NULL,'efwefewf wfwefewf fewfefwefewf wfwefewf fewf',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:40:26',0,'2025-11-23 16:40:26'),(56,16,10,NULL,'efwefewf wfwefewf fewf',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:40:29',0,'2025-11-23 16:40:29'),(57,16,7,NULL,'The method or property expo-file-system.getInfoAsync is not available on web, are you sure you\'ve linked all the native dependencies properly?',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:43:56',0,'2025-11-23 16:43:56'),(58,16,8,NULL,'The method or property expo-file-system.getInfoAsync is not available on web, are you sure you\'ve linked all the native dependencies properly?',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:43:59',0,'2025-11-23 16:43:59'),(59,16,9,NULL,'The method or property expo-file-system.getInfoAsync is not available on web, are you sure you\'ve linked all the native dependencies properly?',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:44:03',0,'2025-11-23 16:44:03'),(60,16,10,NULL,'The method or property expo-file-system.getInfoAsync is not available on web, are you sure you\'ve linked all the native dependencies properly?',NULL,NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:44:06',0,'2025-11-23 16:44:06'),(61,16,16,NULL,NULL,'uploads/quiz_answers/audio_20251123_134425_ab0df827.m4a',NULL,NULL,'manual_review',NULL,NULL,NULL,NULL,'2025-11-23 13:44:25',0,'2025-11-23 16:44:25'),(62,8,17,18,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 21:53:00',1,'2025-11-24 00:53:00'),(63,27,17,18,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 22:04:22',1,'2025-11-24 01:04:22'),(64,27,17,18,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 22:04:29',1,'2025-11-24 01:04:29'),(65,28,17,18,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 22:08:33',1,'2025-11-24 01:08:33'),(66,28,18,20,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-23 22:12:43',1,'2025-11-24 01:12:43'),(67,31,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 09:17:25',1,'2025-11-24 12:17:25'),(68,31,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 09:17:29',1,'2025-11-24 12:17:29'),(69,31,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 09:18:13',1,'2025-11-24 12:18:13'),(70,31,6,NULL,'Sobre como o subconsciente influencia nas minhas decisões',NULL,NULL,NULL,'manual_review','Avaliação automática indisponível.',NULL,NULL,NULL,'2025-11-24 09:18:35',0,'2025-11-24 12:18:35'),(71,31,14,NULL,NULL,NULL,'uploads/quiz_answers/image_20251124_091853_23d06e1b.png',NULL,'manual_review','Avaliação automática indisponível.',NULL,NULL,NULL,'2025-11-24 09:18:53',0,'2025-11-24 12:18:53'),(72,32,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 09:45:38',1,'2025-11-24 12:45:38'),(73,32,6,NULL,'Aprendi sobre como meu subconsciente e influente',NULL,NULL,NULL,'manual_review','Avaliação automática indisponível.',NULL,NULL,NULL,'2025-11-24 09:46:22',0,'2025-11-24 12:46:22'),(74,32,14,NULL,NULL,NULL,'uploads/quiz_answers/image_20251124_094635_c7e886e6.png',NULL,'manual_review','Avaliação automática indisponível.',NULL,NULL,NULL,'2025-11-24 09:46:35',0,'2025-11-24 12:46:35'),(75,33,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 09:49:00',1,'2025-11-24 12:49:00'),(76,33,6,NULL,'o video me ensinou sobre como o subconsciente me influencia',NULL,NULL,NULL,'manual_review','Avaliação automática indisponível.',NULL,NULL,NULL,'2025-11-24 09:49:20',0,'2025-11-24 12:49:20'),(77,33,14,NULL,NULL,NULL,'uploads/quiz_answers/image_20251124_094933_cdd8f8ca.png',NULL,'manual_review','Avaliação automática indisponível.',NULL,NULL,NULL,'2025-11-24 09:49:33',0,'2025-11-24 12:49:33'),(78,34,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 09:57:51',1,'2025-11-24 12:57:51'),(79,34,6,NULL,'ewfouhwef weouifhweioufhwiuehf weufhiweuhf',NULL,NULL,NULL,'manual_review','Falha ao contatar o serviço de IA.',NULL,NULL,NULL,'2025-11-24 09:57:55',0,'2025-11-24 12:57:55'),(80,34,14,NULL,NULL,NULL,'uploads/quiz_answers/image_20251124_095804_11df6994.png',NULL,'manual_review','Falha ao contatar o serviço de IA.',NULL,NULL,NULL,'2025-11-24 09:58:05',0,'2025-11-24 12:58:05'),(81,35,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:02:47',1,'2025-11-24 13:02:47'),(82,35,6,NULL,'ewilqfhiwoef weuihfiuwehfwe',NULL,NULL,NULL,'manual_review','Falha ao contatar o serviço de IA.',NULL,NULL,NULL,'2025-11-24 10:02:58',0,'2025-11-24 13:02:58'),(83,35,14,NULL,NULL,NULL,'uploads/quiz_answers/image_20251124_100312_f28ed94c.png',NULL,'manual_review','Falha ao contatar o serviço de IA.',NULL,NULL,NULL,'2025-11-24 10:03:12',0,'2025-11-24 13:03:12'),(84,35,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:06:28',1,'2025-11-24 13:06:28'),(85,35,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:07:21',1,'2025-11-24 13:07:21'),(86,35,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:07:24',1,'2025-11-24 13:07:24'),(87,35,19,NULL,'iufweiojfwefj woifjiowejfiowefjweiofjiweo',NULL,NULL,NULL,'manual_review','Falha ao contatar o serviço de IA.',NULL,NULL,NULL,'2025-11-24 10:07:33',0,'2025-11-24 13:07:33'),(88,36,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:22:29',1,'2025-11-24 13:22:29'),(89,36,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:22:33',1,'2025-11-24 13:22:33'),(90,36,19,NULL,'ewifjweijf iwfjweoifj owejfoweij',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda a pergunta e parece ser um texto aleatório, sem conteúdo relevante sobre o que foi aprendido.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta não aborda a pergunta e parece ser um texto aleatório, sem conteúdo relevante sobre o que foi aprendido.\"}','2025-11-24 10:22:49',0,'2025-11-24 13:22:49'),(91,36,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:24:40',1,'2025-11-24 13:24:40'),(92,36,6,NULL,'Aprendi a importancia do autoconhecimento, que isso me ajuda a tomar melhores decisões e entender minhas emoções',NULL,NULL,1,'valid','A resposta aborda o aprendizado sobre autoconhecimento e suas implicações, o que está alinhado com a pergunta.','gpt-4o-mini',0.900,'{\"is_correct\":true,\"confidence\":0.9,\"feedback\":\"A resposta aborda o aprendizado sobre autoconhecimento e suas implicações, o que está alinhado com a pergunta.\"}','2025-11-24 10:25:08',1,'2025-11-24 13:25:08'),(93,36,14,NULL,NULL,NULL,'uploads/quiz_answers/image_20251124_102527_8bfb3bc7.jpg',0,'invalid','A imagem não pode ser analisada em relação ao que foi pedido, pois não há informações suficientes sobre o que deveria ser atendido.','gpt-4o-mini',0.700,'{\"is_correct\":false,\"confidence\":0.7,\"feedback\":\"A imagem não pode ser analisada em relação ao que foi pedido, pois não há informações suficientes sobre o que deveria ser atendido.\"}','2025-11-24 10:25:28',0,'2025-11-24 13:25:28'),(94,37,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:36:07',1,'2025-11-24 13:36:07'),(95,37,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:36:09',1,'2025-11-24 13:36:09'),(96,37,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-24 10:36:28',1,'2025-11-24 13:36:28'),(97,37,6,NULL,'Aprendi sobre a importancia do autoconhecimento e como isso pode ajudar a entende melhor meus sentimentos',NULL,NULL,1,'valid','A resposta aborda o tema do autoconhecimento e sua relação com a compreensão dos sentimentos, o que está alinhado com a pergunta.','gpt-4o-mini',0.900,'{\"is_correct\":true,\"confidence\":0.9,\"feedback\":\"A resposta aborda o tema do autoconhecimento e sua relação com a compreensão dos sentimentos, o que está alinhado com a pergunta.\"}','2025-11-24 10:36:53',1,'2025-11-24 13:36:53'),(98,37,14,NULL,NULL,NULL,'uploads/quiz_answers/image_20251124_103706_454a395b.jpg',0,'invalid','Confiança baixa: Não é possível avaliar se a imagem atende ao que foi pedido sem informações adicionais sobre o que deveria ser analisado.','manual-admin',NULL,NULL,'2025-11-24 10:37:09',0,'2025-11-24 13:37:09'),(99,12,11,NULL,'Amei! É importante',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda especificamente o que foi gostado no filme, apenas expressa uma opinião positiva.','gpt-4o-mini',0.500,'{\"is_correct\":false,\"confidence\":0.5,\"feedback\":\"A resposta não aborda especificamente o que foi gostado no filme, apenas expressa uma opinião positiva.\"}','2025-11-25 10:18:02',0,'2025-11-25 13:18:02'),(100,42,18,20,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-25 11:33:57',1,'2025-11-25 14:33:57'),(101,42,17,18,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-25 11:34:44',1,'2025-11-25 14:34:44'),(102,47,3,10,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-26 10:40:30',1,'2025-11-26 13:40:30'),(103,47,4,14,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-26 10:40:32',1,'2025-11-26 13:40:32'),(104,47,19,NULL,'f3434f4f 34f34f34f34',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda o que foi aprendido na lição, apresentando apenas uma sequência de caracteres sem sentido.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta não aborda o que foi aprendido na lição, apresentando apenas uma sequência de caracteres sem sentido.\"}','2025-11-26 10:40:37',0,'2025-11-26 13:40:37'),(105,47,5,16,NULL,NULL,NULL,1,'valid',NULL,NULL,NULL,NULL,'2025-11-26 10:52:05',1,'2025-11-26 13:52:05'),(106,47,6,NULL,'Muitas coisas, muitas coisas',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta é vaga e não fornece informações específicas sobre o que foi aprendido na lição.','gpt-4o-mini',0.200,'{\"is_correct\":false,\"confidence\":0.2,\"feedback\":\"A resposta é vaga e não fornece informações específicas sobre o que foi aprendido na lição.\"}','2025-11-26 10:52:17',0,'2025-11-26 13:52:17'),(107,47,14,NULL,NULL,NULL,'uploads/quiz_answers/image_20251126_105228_7fb2ad8c.png',1,'valid','Muito bom! Parabéns!','manual-admin',NULL,NULL,'2025-11-26 10:52:31',1,'2025-11-26 13:52:31'),(108,51,3,10,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-11-28 23:26:58',1,'2025-11-29 02:26:58'),(109,52,6,NULL,'bhjbhbhbhbhvfcdx',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta enviada não aborda a pergunta e parece ser um texto aleatório, sem relação com o conteúdo da lição.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta enviada não aborda a pergunta e parece ser um texto aleatório, sem relação com o conteúdo da lição.\"}','2025-11-29 00:02:44',0,'2025-11-29 03:02:44'),(110,52,19,NULL,'sdfdfergrrgbrb',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda o que foi aprendido na lição, apresentando apenas uma sequência de caracteres sem sentido.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta não aborda o que foi aprendido na lição, apresentando apenas uma sequência de caracteres sem sentido.\"}','2025-11-29 00:05:14',0,'2025-11-29 03:05:14'),(111,52,11,NULL,'hhhhhhhhhhhhh',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda a pergunta sobre o que o participante gostou no filme, limitando-se a uma sequência de letras sem conteúdo relevante.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta não aborda a pergunta sobre o que o participante gostou no filme, limitando-se a uma sequência de letras sem conteúdo relevante.\"}','2025-11-29 00:07:08',0,'2025-11-29 03:07:08'),(112,52,12,NULL,'wdqewdededefrfrf',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda a pergunta e parece ser um texto aleatório, sem relação com a aplicação do conhecimento.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta não aborda a pergunta e parece ser um texto aleatório, sem relação com a aplicação do conhecimento.\"}','2025-11-29 00:07:15',0,'2025-11-29 03:07:15'),(113,53,3,10,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-11-29 11:02:22',1,'2025-11-29 14:02:22'),(114,53,4,14,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-11-29 11:02:29',1,'2025-11-29 14:02:29'),(115,53,19,NULL,'jhuhuhuhuhuhuhuhuh',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda o que foi aprendido na lição, apresentando apenas uma sequência de caracteres sem sentido.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta não aborda o que foi aprendido na lição, apresentando apenas uma sequência de caracteres sem sentido.\"}','2025-11-29 11:02:41',0,'2025-11-29 14:02:41'),(116,53,17,18,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-11-29 11:08:38',1,'2025-11-29 14:08:38'),(117,53,11,NULL,'wffrfrfrefreferfr',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda a pergunta sobre o que o participante gostou no filme, apresentando apenas uma sequência de letras sem sentido.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta não aborda a pergunta sobre o que o participante gostou no filme, apresentando apenas uma sequência de letras sem sentido.\"}','2025-11-29 11:37:55',0,'2025-11-29 14:37:55'),(118,11,20,NULL,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-12-01 09:56:44',1,'2025-12-01 12:56:44'),(119,62,20,28,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-12-01 10:40:54',1,'2025-12-01 13:40:54'),(120,62,21,26,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-12-01 10:40:58',1,'2025-12-01 13:40:58'),(121,62,22,33,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-12-01 10:41:48',1,'2025-12-01 13:41:48'),(122,62,26,NULL,'Nao consigo imaginar como posso aplicar.',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não atende à pergunta, pois não apresenta uma aplicação do conhecimento na vida do participante.','gpt-4o-mini',0.200,'{\"is_correct\":false,\"confidence\":0.2,\"feedback\":\"A resposta não atende à pergunta, pois não apresenta uma aplicação do conhecimento na vida do participante.\"}','2025-12-01 10:44:44',0,'2025-12-01 13:44:44'),(123,62,29,NULL,'Hambúrguer e lasanha',NULL,NULL,1,'valid','A resposta atende à pergunta, pois o participante mencionou suas comidas favoritas, mesmo que sejam duas.','gpt-4o-mini',0.900,'{\"is_correct\":true,\"confidence\":0.9,\"feedback\":\"A resposta atende à pergunta, pois o participante mencionou suas comidas favoritas, mesmo que sejam duas.\"}','2025-12-01 11:19:02',1,'2025-12-01 14:19:02'),(124,62,30,NULL,'ddewdewdedewded',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta não aborda a pergunta sobre o maior medo, apresentando um texto sem sentido.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta não aborda a pergunta sobre o maior medo, apresentando um texto sem sentido.\"}','2025-12-01 11:19:17',0,'2025-12-01 14:19:17'),(125,50,21,26,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-12-01 15:04:07',1,'2025-12-01 18:04:07'),(126,50,32,NULL,'Amar a Deus',NULL,NULL,1,'valid','A resposta \'Amar a Deus\' reflete uma prioridade espiritual que pode ser considerada muito importante para muitas pessoas, embora a importância das prioridades possa variar de acordo com crenças pessoais.','gpt-4o-mini',0.800,'{\"is_correct\":true,\"confidence\":0.8,\"feedback\":\"A resposta \'Amar a Deus\' reflete uma prioridade espiritual que pode ser considerada muito importante para muitas pessoas, embora a importância das prioridades possa variar de acordo com crenças pessoais.\"}','2025-12-01 15:04:36',5,'2025-12-01 18:04:36'),(127,50,22,33,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-12-01 15:06:04',1,'2025-12-01 18:06:04'),(128,50,29,NULL,'Gosto muito de gorgonzola',NULL,NULL,1,'valid','A resposta atende à pergunta, pois o participante expressou sua preferência por uma comida específica.','gpt-4o-mini',0.900,'{\"is_correct\":true,\"confidence\":0.9,\"feedback\":\"A resposta atende à pergunta, pois o participante expressou sua preferência por uma comida específica.\"}','2025-12-01 15:08:53',1,'2025-12-01 18:08:53'),(129,64,32,NULL,'ewfef ewfewfwefew',NULL,NULL,NULL,'manual_review','Confiança baixa: A resposta enviada não aborda a pergunta sobre o que é mais importante, apresentando apenas texto irrelevante.','gpt-4o-mini',0.100,'{\"is_correct\":false,\"confidence\":0.1,\"feedback\":\"A resposta enviada não aborda a pergunta sobre o que é mais importante, apresentando apenas texto irrelevante.\"}','2025-12-01 22:55:23',0,'2025-12-02 01:55:23'),(130,64,23,36,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-12-01 22:56:53',1,'2025-12-02 01:56:53'),(131,64,23,36,NULL,NULL,NULL,1,'valid','Mandou bem! Você acertou esta pergunta.',NULL,NULL,NULL,'2025-12-01 22:57:11',1,'2025-12-02 01:57:11'),(132,64,24,NULL,'ewfenwjkfnwejkfnewfjnweknjf wefjnwekjfnkjwef',NULL,NULL,1,'valid','Muito legal!','manual-admin',NULL,NULL,'2025-12-01 22:57:18',1,'2025-12-02 01:57:18');

--
-- Table structure for table `user_rewards`
--

CREATE TABLE `user_rewards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `reward_id` int NOT NULL,
  `redeemed_at` datetime NOT NULL,
  `voucher_code` varchar(50) NOT NULL,
  `status` enum('pending','delivered','used') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `reward_id` (`reward_id`),
  CONSTRAINT `user_rewards_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_rewards_ibfk_2` FOREIGN KEY (`reward_id`) REFERENCES `rewards` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_rewards`
--

INSERT INTO `user_rewards` VALUES (1,2,1,'2025-11-15 12:35:00','PSTR-AB12','delivered','2025-11-15 12:35:00'),(2,6,1,'2025-11-17 22:44:26','7CF6392DB473','pending','2025-11-18 01:44:26'),(3,15,1,'2025-11-23 11:39:55','99A5F328BC92','pending','2025-11-23 14:39:55'),(4,16,1,'2025-11-23 13:59:07','58647BD4012D','pending','2025-11-23 16:59:07'),(5,51,1,'2025-11-28 23:52:39','9130DCABE1ED','pending','2025-11-29 02:52:39'),(6,51,1,'2025-11-28 23:52:39','DBCCB6BBCF34','pending','2025-11-29 02:52:39'),(7,51,1,'2025-11-28 23:52:40','21C922BCED9E','pending','2025-11-29 02:52:40'),(8,51,1,'2025-11-28 23:52:40','7570EC312CEB','pending','2025-11-29 02:52:40');

--
-- Table structure for table `user_tokens`
--

CREATE TABLE `user_tokens` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `token` varchar(128) NOT NULL,
  `expires_at` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `user_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_tokens`
--

INSERT INTO `user_tokens` VALUES (1,2,'1916f6dc8a371078d62de7b669fe266410aa5f0889f8a276bfd7b6fd8256f9b8','2025-11-22 16:01:52','2025-11-15 16:01:52'),(2,6,'f3257828bb65b85d455a3c9cd69812ba90b9d9bf2c96a646f01c5aa7f22da63a','2025-11-22 18:26:36','2025-11-15 18:26:36'),(3,7,'2dc73f4ec021eccb1de06dfe3e3b91f7c225ca86c1b30dfeaed04c61d07ffe0c','2025-11-25 01:54:09','2025-11-18 01:54:09'),(4,8,'e66ea631ee0d4b32dcee3f53b4cc9cfefe3ae7a1aabc47e4daf6238047369adf','2025-11-25 02:15:37','2025-11-18 02:15:37'),(5,9,'5c0ffe490fe492890ee1e486fe4433d426258aea1025c8b9fd3c9a8458f82287','2025-11-25 20:57:45','2025-11-18 20:57:45'),(6,10,'b6b4fc6e06bd288e101bc460f11bc568a709c2a37a010600c88d09f0f1acf4f0','2025-11-25 21:50:27','2025-11-18 21:50:27'),(7,8,'48edd90420b9b90307b43fc49fe51c8da5deaeb0cbbd4e5991b4f1cc02ac6425','2025-11-25 22:05:17','2025-11-18 22:05:17'),(8,11,'4746051bc601aab4ff7c17aac2bee7c6a2613896bca72a0113f6b9e7ae3b70fa','2025-11-25 22:06:28','2025-11-18 22:06:28'),(9,10,'0bbae90bf421ad58857ae1088115b09e5dce32e6766c38eb0aa07764a7ed525a','2025-11-25 22:09:02','2025-11-18 22:09:02'),(10,12,'f82934b9ed7838edbab7ff1e0e240a9870cbc190c4f4389d8552565a36e3dd5c','2025-11-25 22:45:10','2025-11-18 22:45:10'),(11,11,'aec9a6de56ea52ba6c4c388b9ea7288f03232f2926abbb07439c96be5a703ea6','2025-11-26 13:17:03','2025-11-19 13:17:03'),(12,3,'3ea9a4d723de8bd0e1d918818a4c230ff7a5c5fae2f042f5e954c4961a00dbd6','2025-11-26 13:45:11','2025-11-19 13:45:11'),(13,13,'de1e26e39a978bce514f849250bc6cfc577f024d0a4c0926c037afb352a20b44','2025-11-30 14:20:00','2025-11-23 14:20:00'),(14,15,'d8a78305043487b84b9d567eff512f9a4e7a5d505bab69f12889e3fb68151f61','2025-11-30 14:22:40','2025-11-23 14:22:40'),(15,16,'383c385f72ac6fa069ba768bb8737893e3160b6db2e1bf831e9ff37cdbb7b032','2025-11-30 14:48:42','2025-11-23 14:48:42'),(16,17,'63f3eb3cb90b0fcc8ae74e48a5a80de5dcaf30bdb4845e94fe6fe3e0dff24e68','2025-11-30 14:50:13','2025-11-23 14:50:13'),(17,18,'5a95e95b8f7df8ba1c9bac363c6f2c07ed3d54b766b644ae18683ab6a4105742','2025-11-30 14:51:58','2025-11-23 14:51:58'),(18,19,'2d92319c3b9308948888498e8d8f8dcba45d7ce671a977293ed9e9d22be9251f','2025-11-30 20:54:46','2025-11-23 20:54:46'),(19,20,'a55b147a2b2e7c1ee3e33adf6daf6072cfc80094dbe5a30b946fd2c9cd1a3ba0','2025-11-30 21:32:18','2025-11-23 21:32:18'),(20,21,'319068d0a7bb75632187b466a0b4da7fda1bb588abf3e5a8162310ebb7fb6c61','2025-11-30 22:07:17','2025-11-23 22:07:17'),(21,22,'71e004a14dadfce4d1da4bbea584d0f719371ae91aecd38eda791fe0ae01fada','2025-11-30 22:07:23','2025-11-23 22:07:23'),(22,23,'9d87c67485bf53f92407cbcac70802c735850ab7f671c7e220360d2dbfbd5cfe','2025-11-30 22:08:50','2025-11-23 22:08:50'),(23,25,'25c948277fd51350f944e2e2a1c3665144ccb5bcc65d0585b296f33c0cd367a4','2025-11-30 22:27:19','2025-11-23 22:27:19'),(24,26,'dae080de8b3f7ef524b389729cb162a035ff6341cf0e95e28fb36037733c19ab','2025-11-30 22:27:33','2025-11-23 22:27:33'),(25,8,'93d8f836408c248e46874a59c09a587fb474fc54814dae8264d0090874c57b0f','2025-11-30 22:29:54','2025-11-23 22:29:54'),(26,27,'e513ff692b29e579f9a1cbc27193cc8c77c174a086e7f04e1535ff16d4d1d888','2025-12-01 01:03:22','2025-11-24 01:03:22'),(27,28,'5b8a24b87e92b74aab670cf8cef004adb0434dfd687ffe4681d153ed4f3bb967','2025-12-01 01:08:15','2025-11-24 01:08:15'),(28,11,'e28aee56df732f59066636688fccfafa06d78cbc7caad82e7efe8d8bc7ad00bd','2025-12-01 10:48:52','2025-11-24 10:48:52'),(29,29,'a67c2e454af0ca20ec3ee5b06c866ee223604d2014deb3aad885317d11c0f372','2025-12-01 10:50:05','2025-11-24 10:50:05'),(30,30,'525af96881dc06270a583699d0cd0e158800616477c7d5ef89ac1c9308d561fc','2025-12-01 11:16:18','2025-11-24 11:16:18'),(31,31,'058e96b0c2e2b7c4ea67970f8f67e7a734c3bd6a2e9105944e39001628b9108b','2025-12-01 11:18:35','2025-11-24 11:18:35'),(32,32,'c6f067c7d0317d513e251af327eafc94f5eb6ef016df811a8d0d156bed1a4205','2025-12-01 12:45:27','2025-11-24 12:45:27'),(33,33,'16757bb4286fc77fa5b3f13fea941cacdbc81d15d8097e5a9e379911c9c3fd2d','2025-12-01 12:48:46','2025-11-24 12:48:46'),(34,34,'0212126a37a1123ddc710f6979b761cca1ca841a23e5343713ac982ca223fc26','2025-12-01 12:57:37','2025-11-24 12:57:37'),(35,35,'5c8be775cbd39ce916570c9031922c7af856c8d714135f45fe0890cb230111fb','2025-12-01 13:02:33','2025-11-24 13:02:33'),(36,36,'138b5cd8f7c6dfab648b901346c19bf2430a3e5e91e112c140a54382a5e45f1a','2025-12-01 13:22:15','2025-11-24 13:22:15'),(37,37,'26bf38c3c02be2739c1aa059378c3df781812bee873678ace3ea5a13e6a3841d','2025-12-01 13:35:57','2025-11-24 13:35:57'),(38,38,'ada94a419d7fbcbee5372f09ec8d817324886fbab36fa5136f75abb341af7861','2025-12-01 13:50:14','2025-11-24 13:50:14'),(39,40,'30b4ca148c22cf39be9b530382b02101512249e9e416b469bbacdc3207ca5d5d','2025-12-02 12:53:18','2025-11-25 12:53:18'),(40,41,'c75fde218fd8710583e3c6f54c5188702d8aca334605643a03643e11d53a2ca1','2025-12-02 14:04:50','2025-11-25 14:04:50'),(41,42,'862c3c138383873c6e682dded0694d220a0291385967c51e8ddfdb0eafed2430','2025-12-02 14:08:23','2025-11-25 14:08:23'),(42,43,'a43522a1a6d4ea4cabbc0372484ac43e43b1ae95344e02ea5b839e7dc77308e6','2025-12-02 14:54:38','2025-11-25 14:54:38'),(43,44,'047e43f70632c1b0204f4fdf6811a3e3d8055665bec484c2086d442607d78f11','2025-12-02 14:55:46','2025-11-25 14:55:46'),(44,11,'eaa2ce7602668500c85c5d4c378e7995a4daba571cdee2325ad3f75039f7852d','2025-12-02 15:15:17','2025-11-25 15:15:17'),(45,45,'15b5fb5d552f1a8b2f87f274ca7ccc9d3e4216def03ce88704f3968c77339a12','2025-12-03 11:55:51','2025-11-26 11:55:51'),(46,46,'cc33597b6ebfdff098c8de061befdb969cb7730a88de65f5c25f4f6d048c947c','2025-12-03 12:28:06','2025-11-26 12:28:06'),(47,45,'e31585e45ad4bc3f50fc8e00bb260639b19a91050e7d03c82315f887250b1a0e','2025-12-03 12:28:33','2025-11-26 12:28:33'),(48,47,'260419a96238f0275f90958bba92da3810dd3d849d27c00861cd15541b5b55d9','2025-12-03 13:10:17','2025-11-26 13:10:17'),(49,45,'e714b971581d927a6e9220cee4c9ef094bdedc2bdee617b16f665db58a8602d4','2025-12-05 01:21:12','2025-11-28 01:21:12'),(50,48,'d7983252d88e6afb37191c96c3ccf42b204a95e0571c37635de5bd470807287b','2025-12-05 03:00:28','2025-11-28 03:00:28'),(51,49,'de5e690e50b52ec3f992a06f5d358dda7044c38b606b5f9ded488cdf8bb6d2ef','2025-12-05 03:01:11','2025-11-28 03:01:11'),(52,51,'615913813ad8225dc82d2fcf4b3e631d07c0e7498c91e154c45b22ed7c6cb8d7','2025-12-06 02:21:48','2025-11-29 02:21:48'),(53,52,'57c0ae02869d11b98b9e3722e94c4f4b419598b296c396fd0dac26721602f207','2025-12-06 02:58:36','2025-11-29 02:58:36'),(54,53,'1766354993184511b12106abc13009580b298a26284f5f436e3365f2dce0f625','2025-12-06 13:57:59','2025-11-29 13:57:59'),(55,60,'ee5ce85f85c8b4bbea3b542dd11f4a60e1541834ecab852fdd056b01ae67a9ed','2025-12-06 18:14:59','2025-11-29 18:14:59'),(56,61,'d50c92c4fe4dfd501f102fef337d72b2909e74423affc6927a003d5a49dea4e9','2025-12-06 19:17:23','2025-11-29 19:17:23'),(57,11,'36f6f6ce87c1a7c8636c497904dbd32583ea518c31cb341fa9c16b21795f0d16','2025-12-08 12:31:32','2025-12-01 12:31:32'),(58,62,'5a29f7bdaef609bb7bfa51b03a51d0c4c8a89e3ed35289d680f001cb7827e042','2025-12-08 12:46:44','2025-12-01 12:46:44'),(59,50,'3a91faf3eae1f8c21d4f2aaf9830d1ef0297ae24f1f12181ad215516e7d8ab02','2025-12-08 18:03:06','2025-12-01 18:03:06'),(60,64,'0770bafae2c329e8b8dc0840d95dfb0171263168c61351e91839426c8048bcef','2025-12-09 01:46:44','2025-12-02 01:46:44'),(61,50,'f68a84fe02294599a36a63b13c9cc74d3314b56e3567c4c537b1ac3e812d5868','2025-12-09 02:12:45','2025-12-02 02:12:45');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `email` varchar(150) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `user_type` enum('responsible','teen','admin') NOT NULL DEFAULT 'teen',
  `language` enum('pt','es','en') NOT NULL DEFAULT 'pt',
  `referral_code` varchar(20) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `reminder_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `payment_status` enum('pending','paid','failed','canceled') NOT NULL DEFAULT 'pending',
  `is_paid` tinyint(1) NOT NULL DEFAULT '0',
  `paid_at` datetime DEFAULT NULL,
  `payment_reference` varchar(64) DEFAULT NULL,
  `payment_link` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `users_referral_code_unique` (`referral_code`),
  KEY `idx_users_payment_status` (`payment_status`),
  KEY `idx_users_payment_reference` (`payment_reference`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'Administrador','admin@admin.com','$2y$10$iptExju8.EopdDIBGCNrA.YueUAIUviX/eUkGifJB3LkwWlTB1w4i','admin','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-15 15:54:03','2025-11-29 14:46:22'),(2,'Karina Mendes','wfijweie@efieiofje.com','$2y$10$iptExju8.EopdDIBGCNrA.YueUAIUviX/eUkGifJB3LkwWlTB1w4i','teen','pt','65230E84',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-15 16:01:10','2025-11-29 17:12:53'),(3,'Lucas Morales','teste@teste.com','$2y$10$iptExju8.EopdDIBGCNrA.YueUAIUviX/eUkGifJB3LkwWlTB1w4i','teen','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-15 17:48:51','2025-11-29 14:46:22'),(4,'Gilberto Aparecido','tteste@teste.com','$2y$10$iptExju8.EopdDIBGCNrA.YueUAIUviX/eUkGifJB3LkwWlTB1w4i','teen','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-15 18:03:19','2025-11-29 14:46:22'),(5,'Omar Wael','camillateste@teste.com','$2y$10$iptExju8.EopdDIBGCNrA.YueUAIUviX/eUkGifJB3LkwWlTB1w4i','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-15 18:13:23','2025-11-29 14:46:22'),(6,'Junior Vidal','teste3@teste.com','$2y$10$iptExju8.EopdDIBGCNrA.YueUAIUviX/eUkGifJB3LkwWlTB1w4i','responsible','pt','35040DC7',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-15 18:26:35','2025-11-29 14:46:22'),(7,'Camilla Carla','camillacarla21@gmail.com','$2y$10$4ldf2yPPRRvlVo8daDDzQ./RJMQ.1XH/48et.lFmS5jHKDA8/MwL.','responsible','pt','A95ECE53',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-18 01:54:08','2025-11-29 14:46:22'),(8,'Gerson Santos','teste@gerson.com','$2y$10$XSUQQkNAC43TZIQppG5J7.Vd6xxUmnBxANnYO.dzafKhATSDuIMj2','responsible','pt','D1F288F5',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-18 02:15:36','2025-11-29 14:46:22'),(9,'Joicemara Saraiva','joicemara@gmail.com','$2y$10$GII.Y1C1Vo/eeW7uIjTQX.uNMqC4GTZa2gUQ8Hbvi22kYnWmI6q8K','responsible','pt','B3F68F20',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-18 20:57:44','2025-11-29 14:46:22'),(10,'Vitória Salles','vitoria@gmail.com','$2y$10$Og27iWqNuPO080EFvFiqHujoga0I0ivWXtQf7YhnCfdqPAYsCs.kC','responsible','pt','CDC8B42C',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-18 21:50:26','2025-11-29 14:46:22'),(11,'Expedita Mandela','expedita@gmail.com','$2y$10$kc.SKTjF8tIgokzYR4FmGeN9/VwKf.wSmIci56em0aacFIU8EX8z2','responsible','pt','3CC75B2C',NULL,1,'paid',1,'2025-11-29 11:46:22','USR-000011','https://pagseguro.uol.com.br/v2/checkout/payment.html?code=91DF4626B1B11D1114D94FBE4343995C','2025-11-18 22:06:27','2025-12-01 12:31:32'),(12,'Paty Star','vivendofeliz@gmail.com','$2y$10$4Xh0NVkzltr9X1mHip5yY.qz5DueJsDjBq90y6vqn//9fPWKNnOdu','teen','pt','493CF3BE',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-18 22:45:09','2025-11-29 14:46:22'),(13,'Joicemara Silva','philipe.massari13@gmail.com','$2y$10$cYC0itXjTmKoXVi4rMgUfeTVm1oU/h8ShAlOmJHABhVmAQVWCcvja','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 14:19:59','2025-11-29 14:46:22'),(14,'Camilla Carla do Nascimento','camillacarla25@gmail.com','$2y$10$mcNQJRfJfSCUwnx23z/RH.nlZx0MMQY6N5suFOGFWcXFFqVd/ohnG','teen','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 14:22:05','2025-11-29 14:46:22'),(15,'Camilla Carla do Nascimento','camilla.carla1998@gmail.com','$2y$10$vPTNJUung/GjSrBYRhrw6.qqjDJJS3loKv59yxcf.N/T5RS4WzIHq','teen','pt','C02DC784',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 14:22:40','2025-11-29 14:46:22'),(16,'Felipe Oliveira','felipeoliveira@gmail.om','$2y$10$Rlr74ZmRw/QQHp7mriflU.NGsAJpKT4Tz6/AOUWJNjVq1Xo9DyPL2','responsible','pt','E1FF2ACF',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 14:48:41','2025-11-29 14:46:22'),(17,'Camilla','camilla.nascimento21@gmail.com','$2y$10$5.oLU2D2eiBCA/0tabQsd.HigAjMgK4xUbbXRjRLjkIt383XCKW6W','responsible','pt','73329C51',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 14:50:13','2025-11-29 14:46:22'),(18,'sadsdwsd','dwedwedewd','$2y$10$Metlpzn55Jw6PJNsuKi0/uQhxMf.io9WsbW/W0ov6KONM3v9IQ2Y6','teen','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 14:51:57','2025-11-29 14:46:22'),(19,'vb vbgb','gbgfgb fg','$2y$10$Gp1x4FWu/An73LVocXPqvOy13LwSEAozalestni3.UuE6aTkxt1Ta','teen','pt','D1E2727A',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 20:54:46','2025-11-29 14:46:22'),(20,'ghhhb','fgbnfgbnfgnb','$2y$10$N1iDgqK1J3T8HM8fPYKFm.MphKcfh3hl5/U64IMdpc7vCJC.6yqOu','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 21:32:17','2025-11-29 14:46:22'),(21,'Teste teste','testeteste@gmail.com','$2y$10$5TbhD8CunyVkY7R/j6cUr.5.CxBOZt6j7FV6UprXaBpG3MBnIhbiC','responsible','es',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 22:07:16','2025-11-29 14:46:22'),(22,'casacdsad','asdasdasd','$2y$10$H2xg35/NJLhU0bw8ApbJEOt2abIpnN7iHYP/wflCKiO2O81QDFWUu','responsible','es','FD14B780',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 22:07:22','2025-11-29 14:46:22'),(23,'dfgvgdg','dsfgfsdgfg','$2y$10$72c1thVm9cw4wgNauwupOOzZECIJRRGJaBp9ErENAhn0JkAqdMTWC','responsible','pt','41916539',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 22:08:49','2025-11-29 14:46:22'),(24,'rtgrgregt','ertgfertert','$2y$10$NvDYJiuAzHkEBJbBXr4eaewW3.UspVL1qXbxXHuuWm6o.p4q8DN8y','responsible','es',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 22:27:13','2025-11-29 14:46:22'),(25,'Pablo Teste','pablo@gmail.com','$2y$10$wgR1SvQzY3AGb9qqwi0.C.sGTL0y2a.QmaflVqipmCoGqwHL768Cy','responsible','es','619154D0',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 22:27:19','2025-11-29 14:46:22'),(26,'dsfdsfdsf','ertgfertertsfdsdfsdf','$2y$10$lw6NFyrCtx5GjPjnbnGIjOCTqzKFHMkTw9McnE3jAimiaf1P.PQIi','responsible','es','7A06D0F9',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-23 22:27:32','2025-11-29 14:46:22'),(27,'Guilherme Lemos','gui@gmail.com','$2y$10$CzcgzmXiWX6ndWoreb4sZevKPrmjNF35VgU3uSqKUKaZpgfCEwFYS','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 01:03:21','2025-11-29 14:46:22'),(28,'Leonardo Gabriel','leeo@gmail.com','$2y$10$Kn87vIPnOPzmtAtTvcqgzOV6hm3yzn8fW0DOzYFnC1DlkAaKP91S2','responsible','pt','5825C70A',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 01:08:14','2025-11-29 14:46:22'),(29,'Giovana Zanin','gi@gmail.com','$2y$10$G5Cu3MLLjfNeLO4QYRXVWevEWTaO5nL6bN9NtRKbNttk/nOacuUIe','responsible','pt','DBE292EF',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 10:50:04','2025-11-29 14:46:22'),(30,'Eduardo Silva','patrick@teste.com','$2y$10$FARpwPj6xYf8VAnnTJbhNOcKGYgx7ZwpNwssVgoUu7eSmg387Jj.K','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 11:16:17','2025-11-29 14:46:22'),(31,'Dieiza Souza','dieiza@gmail.com','$2y$10$N1kBWmhbVTh3Lt7ea/S4uu6gV4taeUtxhmOrQhAFU90Rtc4BxGOgi','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 11:18:35','2025-11-29 14:46:22'),(32,'Teste IA','testeia@gmail.com','$2y$10$Wg2fUWJKDzvJqKrAmI4exe3ExL.DWKUNK0xxgpWsrf7yHLEpnphoG','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 12:45:26','2025-11-29 14:46:22'),(33,'Teste IA 2','testeia2@gmail.com','$2y$10$e31WAKoDCuDsKCXO.wKI7OEdg.jtX2ktxNde0c7ElUgkRt6XACiBq','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 12:48:45','2025-11-29 14:46:22'),(34,'tesdte ia 3','testeia3@gmail.com','$2y$10$ZIvcc3Mb0L3TkmDs1n6Co.ccXrtg76ac/p2z8VIih3SqNr62qNm9i','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 12:57:36','2025-11-29 14:46:22'),(35,'wefioewf weuhfuiweh','testeai4@gmail.com','$2y$10$s68xglvWio4tBIQygj6geOowSBRhvJrWrf2BIkPPsqI0qJt7u.zla','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 13:02:32','2025-11-29 14:46:22'),(36,'wefwef wfwf','wefe@fewfw.com','$2y$10$pvYOkskq71rbqVdqI0dayOPTos/GrmalPdWCwjAe5WytXTiBsU62m','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 13:22:14','2025-11-29 14:46:22'),(37,'wrfgwgrw wfwefee','testeia5@gmail.com','$2y$10$ovZLqxtBEB.YZmsx24MKBOy9iMdRgizsJMGhbIS7f7AE.coNpPZGy','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 13:35:56','2025-11-29 14:46:22'),(38,'opokpkk pokpkpokpo','kopko@gmail.com','$2y$10$RwxJWmh5XUoJlkc66bIBBuZhG46VzdsV/DQ4H3idmpXr8spkpgBZy','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-24 13:50:13','2025-11-29 14:46:22'),(39,'Teste teste','testeteste22@gmail.com','$2y$10$2rkAWJav/Og7xtJs3.ucZOh3IvuGkEpch5RyKyWVDUg/VcQbX0.Zq','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-25 12:52:59','2025-11-29 14:46:22'),(40,'Teste teste','testeteste222@gmail.com','$2y$10$pxAMbFKTGO4b1/dLLXaCZ.Zu3xCEZrK2BJ.R1aKTUGLf/ru7ftF5y','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-25 12:53:17','2025-11-29 14:46:22'),(41,'Teste Espanhol','testeespanhol@gmail.com','$2y$10$st9eTQowdoLb570KuVSr6egErgrxO7rQ7R4nuOlsS.kf/bLJeJWsO','responsible','es',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-25 14:04:49','2025-11-29 14:46:22'),(42,'Teste Ptbr','testeptbr@gmail.com','$2y$10$htBEHxLv7LU2ukQe4s1kqe08UxS8xA1eoly3/KBhFTRPmYWa/e6DO','responsible','pt','5828E720',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-25 14:08:22','2025-11-29 14:46:22'),(43,'Teste teste','testepag@gmail.com','$2y$10$ayK/p/Qokrfv9JNsAIQEZuo5wN9/RqkaoXzh4w4bWFKK29ucss5B.','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-25 14:54:37','2025-11-29 14:46:22'),(44,'Teste teste','testeteste2@gmail.com','$2y$10$y84lyRwnL.1/wcp0SM0e3eakvMPMdpKsiaL7dgQ.bcn7/zPqQbhni','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-25 14:55:45','2025-11-29 14:46:22'),(45,'Teste Phi','testephi@gmail.com','$2y$10$w7cidci9sMDGvL9137Af3.l70jLzLXtfjHMbh/x/g7hD3.LozlEpe','responsible','pt','949EDF47',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-26 11:55:50','2025-11-29 14:46:22'),(46,'Natalia Teste','naty@gmail.com','$2y$10$4TgACQIJ3GzW9RoOsBEAduoQUcgD15IK2Nf0tt5VE0etP6MPCHbhi','responsible','pt','A98A8D95',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-26 12:28:06','2025-11-29 14:46:22'),(47,'Philipe Teste','testehk@teste.com','$2y$10$ke8lAZ4HN9wD8z7Z5hNcEe9d4JBFBGt6ydoGRI50FVB6yaIvTmTAS','responsible','pt','EAEA81E7',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-26 13:10:17','2025-11-29 14:46:22'),(48,'ijeioer rfeijooerijoerio','rfhierh@evioerio.com','$2y$10$HhYZW.Fg6igC10.y1Xx.buQakBHC1h/Q5zK0yOlH.RJF3Y.LQILmm','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-28 03:00:27','2025-11-29 14:46:22'),(49,'566556 556h','g4g5@534t34.com','$2y$10$Z1xnTz5V6qWSo9uXjECHU.qe4t8gziJZbxPPK7u48vrinpu7esGnW','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-28 03:01:10','2025-11-29 14:46:22'),(50,'Camilla Carla do Nascimento','camilla@camilla.com','$2y$10$UxKKaVp3k.YD5oXjPZQne.pMy9SF3kcnD1LzEQMGymkzqT69dRIze','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22','USR-000050','https://pagseguro.uol.com.br/v2/checkout/payment.html?code=210EE210737390F664DC3FB00D3EF393','2025-11-29 02:20:28','2025-12-01 18:03:06'),(51,'Camilla Carla do Nascimento','camilla_carla98@gmail.com','$2y$10$GnU8SLwIFpbmPQIqwDKZt.2B38q8Z7fjWBTe2WpCBSTRC/c4.B1iS','responsible','pt','1F866C65',NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-29 02:21:47','2025-11-29 14:46:22'),(52,'Nataly Nascimento','nataly@vitoria.com','$2y$10$jbrl7xAdT3Pg05RFjf5fP.20pqZgF23fv3okDgjSLjt0nCsS.V52S','teen','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-29 02:58:35','2025-11-29 14:46:22'),(53,'Valdirene dos Santos','val@val.com','$2y$10$1ON3fbZ8QGMC2F.GKp8QDu/20H.U20OY97PzzxFuqcTgRZVawkQTa','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 11:46:22',NULL,NULL,'2025-11-29 13:57:58','2025-11-29 14:46:22'),(54,'efhew wueifhewiuh','testeteste3434344@gmail.com','$2y$10$cBxNFxMww8Cax77q/ERKH.5GE51/3dkqc8w8VoH/nNabpXfKA1LLy','responsible','pt',NULL,NULL,1,'pending',0,NULL,'USR-000054','https://pag.ae/81a8TK_2H','2025-11-29 14:50:38','2025-11-29 14:50:38'),(55,'Teste Pagamento','camillacarla98@unifiil.edu.br','$2y$10$ctIf509p3FqcOk./R1P/2uRKDbXnZ1GjZl9MRJ.T.z3lWnugNdCe.','responsible','pt',NULL,NULL,1,'pending',0,NULL,'USR-000055','https://pag.ae/81a8TK_2H','2025-11-29 14:52:44','2025-11-29 14:52:44'),(56,'Teste Pagamento','philipe.massari12@gmail.com','$2y$10$jJ/TSI/l8AZaQP2F7s29LOVVQp8ucNIwl17CTKhZbx/m27.7d12k2','responsible','pt',NULL,NULL,1,'pending',0,NULL,'USR-000056','https://pag.ae/81ghaLqVp','2025-11-29 17:13:28','2025-11-29 17:13:28'),(57,'Philipe Teste x','carmeltecsoftware@gmail.com','$2y$10$Vm0nRiRAl3xkXzy9MVtDA.IFqhKvxGniBYp21J2AK9LBppA/Ko1D6','responsible','pt',NULL,NULL,1,'pending',0,NULL,'USR-000057','https://pag.ae/81ghaLqVp','2025-11-29 17:14:56','2025-11-29 17:14:56'),(58,'kpokpok opkpok','kopkop@kopkop.com','$2y$10$rpJECYjiLnCzwn8riMePf.IWjE9n0LqdmBHKLf7yWFzzUl7qPOdrC','responsible','pt',NULL,NULL,1,'pending',0,NULL,'USR-000058','https://pag.ae/81ghaLqVp','2025-11-29 17:36:03','2025-11-29 17:36:03'),(59,'Teste Gil','gilberto@gmail.com','$2y$10$sx/q1wHLTYpQOeE1lin28OU5OG4wYXPymxnXvAF2kh6sm.THDJDB.','responsible','pt',NULL,NULL,1,'pending',0,NULL,'USR-000059','https://pag.ae/81ghaLqVp','2025-11-29 17:50:45','2025-11-29 17:50:45'),(60,'Teste Pagamento Gil','testegil@gmail.com','$2y$10$DxzMh29DMdPdOfI/8ENsJO1DL5DsSWib3qkfDPIaalFLiwtFHl8wG','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 15:14:52','USR-000060','https://pagseguro.uol.com.br/v2/checkout/payment.html?code=2A83AB9543435B2334C1BFBACB81BB2C','2025-11-29 17:55:02','2025-11-29 18:14:52'),(61,'eihwu wiefhiweuhfuiew','kiki@gmail.com','$2y$10$BQ5s7DJNj8dFxgGcXRzhTehzFa0uIJZvrZ6K2sg7jtS/2pPi6NLxC','responsible','pt',NULL,NULL,1,'paid',1,'2025-11-29 16:16:51','USR-000061','https://pagseguro.uol.com.br/v2/checkout/payment.html?code=14D69A17CCCC047BB4B12FA92C1AC005','2025-11-29 18:15:50','2025-11-29 19:16:51'),(62,'Vitoria do Nascimento','vitoria@vitoria.com','$2y$10$k2zhb/SGUTrdKnoOyMcX3uewyz/1GEvSMmiRPyxnNa.u6V7/M0XO2','teen','pt',NULL,NULL,1,'paid',1,'2025-12-01 09:46:11','USR-000062','https://pagseguro.uol.com.br/v2/checkout/payment.html?code=9629B8F803034E844436BF908C8F23DA','2025-12-01 12:42:28','2025-12-01 12:46:11'),(63,'Camilla Carla Massari','camilla@massari.com','$2y$10$1QYWgbV.dumK/2T1Wv/jveFqL7Uz5HkZcvJZrkRQOKv.UZLLld.G2','responsible','pt',NULL,NULL,1,'paid',1,'2025-12-01 15:02:25','USR-000063','https://pagseguro.uol.com.br/v2/checkout/payment.html?code=1E86D40A2929207AA4513FB64F14B151','2025-12-01 18:01:59','2025-12-01 18:02:25'),(64,'Esther Massari','esther@massari.com','$2y$10$VN6.Wr38ktfdRInyOSU40.bN2xh.ee7.Az7c6FuEk8n794F6Dp2Ju','teen','pt',NULL,NULL,1,'paid',1,'2025-12-01 22:45:58','USR-000064','https://pagseguro.uol.com.br/v2/checkout/payment.html?code=8C6089805E5E41A664CFBFAFFB46F53A','2025-12-01 18:42:52','2025-12-02 01:45:58');


