-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `spacesys`
--

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

--
-- Table structure for table `ai_chats`
--

CREATE TABLE `ai_chats` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `session_id` varchar(64) NOT NULL,
  `role` enum('user','assistant') NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `session_title` varchar(120) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ai_chats`
--

INSERT INTO `ai_chats` (`id`, `user_id`, `session_id`, `role`, `message`, `created_at`, `session_title`) VALUES
(1, 1, 'c938f554566f7fe5335a13d4bf997166', 'user', 'Help with homework', '2026-04-14 15:27:47', NULL),
(2, 1, 'c938f554566f7fe5335a13d4bf997166', 'assistant', 'Hi Jirwen Palaje! 👋 I\'m Astro, your AI study companion.\n\nTo enable AI responses, please add your Groq API key to the `.env` file:\n\n```\nGROQ_API_KEY=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\n```\n\nGet your API key at https://console.groq.com', '2026-04-14 15:27:47', NULL),
(3, 1, 'f2220ed75e45aa6a89359d1386d46bdc', 'user', 'Help with homework', '2026-04-14 15:28:36', NULL),
(4, 1, 'f2220ed75e45aa6a89359d1386d46bdc', 'assistant', 'Hi Jirwen Palaje! 👋 I\'m Astro, your AI study companion.\n\nTo enable AI responses, please add your Groq API key to the `.env` file:\n\n```\nGROQ_API_KEY=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\n```\n\nGet your API key at https://console.groq.com', '2026-04-14 15:28:36', NULL),
(5, 1, '6693fab88bbd0fa5a044bf417e033678', 'user', 'Create a study plan', '2026-04-14 15:33:05', NULL),
(6, 1, '6693fab88bbd0fa5a044bf417e033678', 'assistant', '**Study Plan for Jirwen Palaje, BSIT 3**\n\nLet\'s break down your study plan into manageable chunks. Here\'s a suggested outline:\n\n### Short-Term Goals (Next 2 Weeks)\n1. **Identify strengths and weaknesses**: Review your past exams and assignments to determine areas where you need improvement.\n2. **Prioritize subjects**: Focus on the most challenging subjects that require immediate attention.\n3. **Set daily study targets**: Allocate specific times for studying each subject.\n\n### Weekly Study Schedule\n* **Monday**: Review notes and summarize key concepts (2 hours)\n* **Tuesday**: Practice problems and past exams (2 hours)\n* **Wednesday**: Focus on weak areas and seek help when needed (2 hours)\n* **Thursday**: Review and reinforce previously studied material (1.5 hours)\n* **Friday**: Practice quizzes or exams to assess progress (1.5 hours)\n* **Saturday**: Review and plan for the upcoming week (1 hour)\n* **Sunday**: Relax and recharge for the next week\n\n### Long-Term Goals (Next Semester)\n* **Improve overall grades**: Aim to increase your GPA by 0.5 points.\n* **Develop a consistent study routine**: Stick to your study schedule and make adjustments as needed.\n* **Seek help when needed**: Don\'t hesitate to ask your instructors or classmates for help when you\'re struggling.\n\n### Additional Tips\n* **Take breaks**: Study in 50-minute increments, followed by a 10-minute break.\n* **Stay organized**: Keep all your study materials, including notes and schedules, in one place.\n* **Review consistently**: Regular review helps solidify information in your long-term memory.\n\nRemember, Jirwen, **you got this**! Stay committed to your study plan, and don\'t hesitate to reach out if you need any help or guidance.', '2026-04-14 15:33:05', NULL),
(7, 1, '08416926ac9b89e9b8ead2c330fcd3c1', 'user', 'hi', '2026-04-15 01:58:52', NULL),
(8, 1, '08416926ac9b89e9b8ead2c330fcd3c1', 'assistant', '**Hello Jirwen**. I\'m Astro, your friendly AI study companion. I\'m here to help you with any questions or topics you\'d like to explore. How\'s your day going so far? Do you have a specific subject or task you\'d like to work on?', '2026-04-15 01:58:52', NULL),
(9, 1, '08416926ac9b89e9b8ead2c330fcd3c1', 'user', 'study plan', '2026-04-15 02:00:08', NULL),
(10, 1, '08416926ac9b89e9b8ead2c330fcd3c1', 'assistant', '**Let\'s Create a Study Plan**. To get started, I\'ll need to know a bit more about your goals and schedule. Can you please tell me:\n\n1. **What are your top priorities** for the next week or two? (e.g., exams, assignments, projects)\n2. **How many hours** can you dedicate to studying each day?\n3. **What time of day** are you most focused and productive?\n4. **Which subjects** do you need to focus on the most?\n\nOnce I have this information, I can help you create a **personalized study plan** that fits your needs and schedule.', '2026-04-15 02:00:08', NULL),
(11, 1, 'ee1be5ac05b08d9bf23b414fd6b81395', 'user', 'hi', '2026-04-15 02:29:54', NULL),
(12, 1, 'ee1be5ac05b08d9bf23b414fd6b81395', 'assistant', '**Hello Jirwen**. I\'m Astro, your AI study companion. I\'m here to help you with any subject or topic you\'re studying in BSIT 3 at PLT. What do you need help with today? Do you have a specific question, need help with a concept, or want to create a study plan?', '2026-04-15 02:29:54', NULL),
(13, 1, 'ee1be5ac05b08d9bf23b414fd6b81395', 'user', 'Help me write an essay structure', '2026-04-15 02:38:40', NULL),
(14, 1, 'ee1be5ac05b08d9bf23b414fd6b81395', 'assistant', '**Essay Structure**. I\'d be happy to help you with that, Jirwen. Here\'s a basic outline:\n\n1. **Introduction**\n	* Hook to grab the reader\'s attention\n	* Background information on the topic\n	* **Thesis statement** (main argument or point)\n2. **Body Paragraphs** (usually 3-5)\n	* Topic sentence (main point of the paragraph)\n	* Evidence or examples to support the topic sentence\n	* Analysis or explanation of the evidence\n	* **Linking sentence** to connect to the next paragraph\n3. **Conclusion**\n	* Summary of the main points\n	* Restate the **thesis statement**\n	* Final thought or call to action\n\nLet\'s break it down further. What\'s the topic of your essay? What are you trying to argue or discuss?', '2026-04-15 02:38:40', NULL),
(15, 1, 'ee1be5ac05b08d9bf23b414fd6b81395', 'user', 'about life of ferdinand marcos sr. and his contribution', '2026-04-15 02:39:33', NULL),
(16, 1, 'ee1be5ac05b08d9bf23b414fd6b81395', 'assistant', '**Essay on Ferdinand Marcos Sr.**. That\'s a great topic, Jirwen. Here\'s a more detailed outline:\n\n### Introduction\n* Brief overview of **Ferdinand Marcos Sr.**\'s life\n* Importance of his contributions to the Philippines\n* **Thesis statement**: Despite controversy, Ferdinand Marcos Sr. made significant contributions to the Philippines during his presidency.\n\n### Body Paragraphs\n1. **Economic Contributions**\n	* Discuss his economic policies, such as the **Green Revolution** and **infrastructure development**\n	* Provide examples of how these policies affected the country\'s economy\n2. **Social Contributions**\n	* Talk about his social programs, such as **education** and **healthcare** initiatives\n	* Explain how these programs impacted the lives of Filipinos\n3. **Infrastructure Development**\n	* Describe the major infrastructure projects he initiated, such as **highways**, **bridges**, and **public buildings**\n	* Discuss the long-term effects of these projects on the country\'s development\n\n### Conclusion\n* Summarize Marcos\' key contributions to the Philippines\n* Reiterate the **thesis statement**\n* Final thought: While Marcos\' legacy is complex and controversial, his contributions to the country\'s development should not be overlooked.\n\nRemember to support your arguments with credible sources and evidence. You can also explore both the positive and negative aspects of Marcos\' presidency to provide a balanced perspective.\n\nHow does this outline look to you, Jirwen? Do you want to add or modify anything?', '2026-04-15 02:39:33', NULL),
(17, 1, 'ee1be5ac05b08d9bf23b414fd6b81395', 'user', 'can you create flashcards for that', '2026-04-15 02:47:36', NULL),
(18, 1, 'ee1be5ac05b08d9bf23b414fd6b81395', 'assistant', '**Flashcards for Ferdinand Marcos Sr.**. I\'d be happy to help you create some flashcards, Jirwen. Here are 10 flashcards to get you started:\n\n1. **Front**: Who is Ferdinand Marcos Sr.?\n**Back**: The 10th President of the Philippines, serving from 1965 to 1986.\n2. **Front**: What was the **Green Revolution**?\n**Back**: An economic policy initiated by Marcos to increase food production and reduce poverty in the Philippines.\n3. **Front**: What were some of Marcos\' **infrastructure development** projects?\n**Back**: Highways, bridges, public buildings, and dams, such as the **San Roque Dam**.\n4. **Front**: What was the impact of Marcos\' **education** initiatives?\n**Back**: Increased access to education, improved literacy rates, and expansion of educational institutions.\n5. **Front**: What were some of Marcos\' **social programs**?\n**Back**: Healthcare initiatives, such as the **Philippine Health Insurance Corporation**, and social welfare programs, like the **Department of Social Welfare and Development**.\n6. **Front**: What was the **thesis statement** for our essay?\n**Back**: Despite controversy, Ferdinand Marcos Sr. made significant contributions to the Philippines during his presidency.\n7. **Front**: What were some of the **economic benefits** of Marcos\' presidency?\n**Back**: Increased economic growth, improved infrastructure, and reduced poverty rates.\n8. **Front**: Who was **Imelda Marcos**?\n**Back**: The wife of Ferdinand Marcos Sr. and a influential figure in his presidency.\n9. **Front**: What was the ** Martial Law** period in the Philippines?\n**Back**: A period of martial law declared by Marcos from 1972 to 1981, which was marked by human rights abuses and authoritarian rule.\n10. **Front**: What is the **legacy** of Ferdinand Marcos Sr.?\n**Back**: A complex and controversial one, with both positive and negative impacts on the Philippines, including economic growth, infrastructure development, and human rights abuses.\n\nFeel free to add or modify these flashcards as you see fit, Jirwen. You can also use them to quiz yourself on the key points about Ferdinand Marcos Sr.\n\nDo you want me to create more flashcards or help with something else?', '2026-04-15 02:47:36', NULL),
(19, 2, '4ff9a71f83bd1c99af63c599511c529e', 'user', 'Help with homework', '2026-04-15 03:48:15', NULL),
(20, 2, '4ff9a71f83bd1c99af63c599511c529e', 'assistant', 'Hello Abegail, I\'m Astro, your study companion. I\'d be happy to help you with your homework. \n\nTo get started, could you please provide more details about the homework you\'re struggling with? This includes:\n* The **subject** (e.g., Programming, Data Structures, etc.)\n* The **topic** or specific area of difficulty\n* Any **assignments** or problems you\'re working on\n\nThis information will help me better understand how I can assist you. Let\'s work together to make your studying more efficient and fun.', '2026-04-15 03:48:15', NULL),
(21, 2, '4ff9a71f83bd1c99af63c599511c529e', 'user', 'summarize', '2026-04-15 04:13:07', NULL),
(22, 2, '4ff9a71f83bd1c99af63c599511c529e', 'assistant', 'To help with your homework, I need more information. Here\'s a **summary** of what I need from you:\n* **Subject**: What subject is your homework in (e.g., Programming, Data Structures, etc.)?\n* **Topic**: What specific topic or area are you struggling with?\n* **Assignment**: What\'s the specific homework assignment or problem you\'re working on?\n\nPlease provide these details, and I\'ll do my best to assist you.', '2026-04-15 04:13:07', NULL),
(23, 2, '2rfkdbfrw4g', 'user', 'ferdinand marcos', '2026-04-15 04:17:53', NULL),
(24, 2, '2rfkdbfrw4g', 'assistant', 'Hello Abegail, let\'s explore the topic of **Ferdinand Marcos**, the 10th President of the Philippines. Here are some key points about his presidency:\n\n* **Early Life**: Ferdinand Marcos was born on September 11, 1917, in Sarrat, Ilocos Norte.\n* **Presidency**: He served as President from 1965 to 1986, making him one of the longest-serving presidents in Philippine history.\n* **Martial Law**: In 1972, Marcos declared **Martial Law**, which gave him absolute power and control over the country. This period was marked by human rights abuses, corruption, and economic stagnation.\n* **Economic Policies**: Marcos implemented various economic policies, including **import substitution** and **industrialization**. However, his policies also led to a significant increase in the country\'s debt and economic inequality.\n* **Fall from Power**: Marcos was ousted from power in 1986, following the **EDSA Revolution**, a peaceful demonstration that showcased the Filipino people\'s desire for democracy and freedom.\n\nIt\'s essential to understand the complexities of Marcos\' presidency and its impact on the Philippines. As a BSIT student, you may want to explore how his policies affected the country\'s technological development and infrastructure. \n\nWhat specific aspect of Ferdinand Marcos\' presidency would you like to explore further, Abegail?', '2026-04-15 04:17:53', NULL),
(25, 2, '2rfkdbfrw4g', 'user', 'Summarize my notes', '2026-04-15 04:22:23', NULL),
(26, 2, '2rfkdbfrw4g', 'assistant', 'You haven\'t shared any notes with me yet, Abegail. Our conversation just started, and we discussed **Ferdinand Marcos**, the 10th President of the Philippines. If you\'d like to share your notes, I\'d be happy to help you summarize them. Please feel free to share, and I\'ll do my best to assist you.', '2026-04-15 04:22:23', NULL),
(27, 2, '2rfkdbfrw4g', 'user', 'Summarize my notes', '2026-04-15 04:23:28', NULL),
(28, 2, '2rfkdbfrw4g', 'assistant', 'You still haven\'t shared any notes with me, Abegail. If you\'d like to share your notes about **Ferdinand Marcos** or any other topic, I\'d be happy to help you summarize them. Please share your notes, and I\'ll do my best to:\n\n* Review the key points\n* Identify main ideas\n* Summarize the important information\n\nPlease go ahead and share your notes, and I\'ll assist you in summarizing them.', '2026-04-15 04:23:28', NULL),
(29, 2, '2rfkdbfrw4g', 'user', 'Summarize my notes', '2026-04-15 04:24:49', NULL),
(30, 2, '2rfkdbfrw4g', 'assistant', 'Since you haven\'t shared any notes, there\'s nothing for me to summarize, Abegail. Our conversation so far has been about **Ferdinand Marcos**, but I haven\'t received any notes from you. If you\'re ready to share your notes, I\'d be happy to help you summarize them. Please share, and I\'ll get started!', '2026-04-15 04:24:49', NULL),
(31, 2, '2rfkdbfrw4g', 'user', 'hi', '2026-04-15 04:28:18', NULL),
(32, 2, '2rfkdbfrw4g', 'assistant', 'Hello again, Abegail. It\'s nice to see you\'re still here. I hope you\'re having a great day and making progress with your studies. If you\'re ready to discuss something or need help with a topic, I\'m all ears. We can pick up where we left off with **Ferdinand Marcos** or explore a new subject. Just let me know how I can assist you!', '2026-04-15 04:28:18', NULL),
(33, 2, '2rfkdbfrw4g', 'user', 'Summarize my notes', '2026-04-15 04:44:15', NULL),
(34, 2, '2rfkdbfrw4g', 'assistant', 'As I mentioned earlier, Abegail, you haven\'t shared any notes with me. Our conversation has been about **Ferdinand Marcos**, but I don\'t have any notes from you to summarize. If you\'d like to share your notes now, I\'d be happy to help you:\n\n* Review the key points\n* Identify main ideas\n* Summarize the important information\n\nPlease share your notes, and I\'ll do my best to assist you.', '2026-04-15 04:44:15', NULL),
(35, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'user', 'Summarize my notes', '2026-04-15 05:42:23', NULL),
(36, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'assistant', 'I don\'t see any notes attached. As your study companion, I\'d be happy to help you summarize your notes, but I need you to share them with me first. Please attach or paste your notes, and I\'ll do my best to:\n\n* Break down key concepts\n* Identify **main topics** and **subtopics**\n* Create a concise summary using bullet points\n\nLet\'s get started, Abegail. What are you studying today in your BSIT course at PLT?', '2026-04-15 05:42:23', NULL),
(37, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'user', 'Summarize this document into key bullet points.', '2026-04-15 06:17:06', NULL),
(38, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'assistant', 'Here are the key bullet points summarizing the document on Platform Technologies:\n\n**Introduction to Platform Technologies**\n* A platform is a digital foundation that supports apps, services, and integrations\n* Provides tools, services, infrastructure, APIs, storage, communication, rules, user management, and security\n\n**Core Concepts of Platforms**\n* A platform is a stable digital environment where systems interact\n* Examples: Operating Systems, Cloud Platforms, Web Platforms, AI Platforms\n\n**Characteristics of a Robust Platform**\n* **Openness and Extensibility**: customizable, integrable, and improvable\n* **Scalability**: handles increasing users, data, and traffic\n* **Security**: protects user accounts, passwords, payments, and private data\n* **Interoperability**: enables different systems to communicate smoothly\n* **Reliability and Availability**: stable, accessible, and recoverable\n* **Developer Tools and APIs**: provides tools for developers to build and integrate systems\n* **Data Management and Analytics**: manages user data, logs, reports, and analytics\n* **Cost Effectiveness**: affordable and cost-efficient\n* **Community Support**: has a large community of developers and users\n* **Compliance and Governance**: follows rules and policies\n\n**Broad Types of Platforms**\n* **Operating System Platform**: controls hardware and software resources\n* **Database Platform**: stores and manages structured data\n* **Mobile Platform**: used for mobile apps and notifications\n* **Cloud Computing Platform**: used for hosting, deployment, and storage\n* **IoT Platform**: connects devices to the internet\n* **Blockchain Platform**: used for secure transactions and transparent records\n* **Security Platform**: used for cybersecurity\n\n**Specific Platform Categories by Use Case**\n* **Social Media / Networking Platforms**: connects people and enables sharing of information\n* **Service and Marketplace Platforms**: connects service providers with customers\n* **Content Sharing and Media Platforms**: enables sharing of content and media\n* **Communication and Collaboration Platforms**: enables communication and collaboration among users\n\nI hope this summary helps you, Abegail! Let me know if you have any further questions or need clarification on any of these points.', '2026-04-15 06:17:06', NULL),
(39, 2, '2rfkdbfrw4g', 'user', 'Summarize my notes', '2026-04-15 10:27:52', NULL),
(40, 2, '2rfkdbfrw4g', 'assistant', 'Since you haven\'t shared any notes, Abegail, there\'s nothing for me to summarize. I\'ve asked you several times to share your notes, but I haven\'t received any. If you\'re ready to share, I\'m here to help. Please share your notes, and I\'ll do my best to assist you.\n\nTo confirm, our conversation so far has been about:\n\n* **Ferdinand Marcos**, the 10th President of the Philippines\n* Your request to summarize your notes (which you haven\'t shared yet)\n\nIf you have any notes or topics you\'d like to discuss, please feel free to share, and I\'ll be happy to help.', '2026-04-15 10:27:52', NULL),
(41, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'user', 'Create a lesson for PATHFIT 4 SWIMMING', '2026-04-16 03:14:56', NULL),
(42, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'assistant', '**Welcome to PATHFIT 4 Swimming, Jirwen Palaje**\nI\'m excited to help you learn and improve your swimming skills. In this lesson, we\'ll cover the basics of swimming and some essential techniques to get you started.\n\n**Lesson Objectives:**\n* Understand the benefits of swimming\n* Learn the basic swimming strokes\n* Familiarize yourself with swimming terminology\n* Develop a practice plan to improve your swimming skills\n\n**Benefits of Swimming:**\nSwimming is an excellent exercise that offers numerous benefits, including:\n* **Cardiovascular Fitness**: Swimming is a great way to improve your heart health and increase your endurance.\n* **Muscle Strength**: Swimming works multiple muscle groups, helping to build strength and tone your body.\n* **Flexibility**: Swimming helps improve your flexibility and range of motion.\n* **Stress Relief**: Swimming can be a great way to relax and reduce stress.\n\n**Basic Swimming Strokes:**\nHere are the four main swimming strokes:\n* **Front Crawl (Freestyle)**: This is the most common swimming stroke, where you alternate your arms and kick your legs.\n* **Backstroke**: In this stroke, you swim on your back, using a scissor-like motion with your arms and a flutter kick with your legs.\n* **Breaststroke**: This stroke involves using your arms to pull yourself forward and your legs to kick in a whip-like motion.\n* **Butterfly**: This is the most challenging stroke, where you use a dolphin kick with your legs and a simultaneous arm movement.\n\n**Swimming Terminology:**\nHere are some key terms to know:\n* **Lap**: A lap is one complete swim from one end of the pool to the other.\n* **Stroke**: A stroke refers to a specific swimming technique, such as front crawl or backstroke.\n* **Kick**: A kick refers to the movement of your legs in the water.\n* **Pull**: A pull refers to the movement of your arms in the water.\n\n**Practice Plan:**\nTo improve your swimming skills, try the following practice plan:\n* Start with short swims (25-50 meters) and gradually increase your distance as you build endurance.\n* Practice each stroke for 10-15 minutes, focusing on proper technique and form.\n* Incorporate drills and exercises to improve your kick, pull, and overall swimming efficiency.\n\nRemember, Jirwen, the key to improving your swimming skills is to practice regularly and have fun. Don\'t be afraid to try new things and challenge yourself. You got this!', '2026-04-16 03:14:56', NULL),
(43, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'user', 'Summarize my notes', '2026-04-16 03:17:15', NULL),
(44, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'assistant', '**PATHFIT 4 Swimming Notes Summary**\nHere\'s a summary of the key points from our lesson:\n\n* **Benefits of Swimming**: Cardiovascular fitness, muscle strength, flexibility, and stress relief\n* **Basic Swimming Strokes**:\n	+ Front Crawl (Freestyle)\n	+ Backstroke\n	+ Breaststroke\n	+ Butterfly\n* **Swimming Terminology**:\n	+ Lap\n	+ Stroke\n	+ Kick\n	+ Pull\n* **Practice Plan**:\n	+ Start with short swims (25-50 meters) and increase distance\n	+ Practice each stroke for 10-15 minutes, focusing on proper technique and form\n	+ Incorporate drills and exercises to improve kick, pull, and overall swimming efficiency\n\nFeel free to review these notes and let me know if you have any questions or need further clarification on any of the topics, Jirwen!', '2026-04-16 03:17:15', NULL),
(45, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'user', 'Summarize my notes', '2026-04-16 03:17:43', NULL),
(46, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'assistant', '**PATHFIT 4 Swimming Notes Summary**\nHere\'s a summary of the key points from our lesson:\n\n* **Benefits of Swimming**: \n  * Cardiovascular fitness\n  * Muscle strength\n  * Flexibility\n  * Stress relief\n* **Basic Swimming Strokes**: \n  * **Front Crawl (Freestyle)**\n  * **Backstroke**\n  * **Breaststroke**\n  * **Butterfly**\n* **Key Terms**: \n  * **Lap**\n  * **Stroke**\n  * **Kick**\n  * **Pull**\n* **Practice Plan**: \n  * Start with short swims and increase distance\n  * Practice each stroke for 10-15 minutes, focusing on proper technique and form\n  * Incorporate drills to improve overall swimming efficiency\n\nLet me know if you have any questions or need further clarification, Jirwen!', '2026-04-16 03:17:43', NULL),
(47, 1, '10f3ca21df69e389e4c5c36a97bb8333', 'user', 'Did you know Jomar consorte? Search facebook', '2026-04-16 08:59:03', NULL),
(48, 1, '10f3ca21df69e389e4c5c36a97bb8333', 'assistant', 'I\'m not capable of directly searching Facebook or accessing external information. I\'m here to help you with your studies and provide educational support. If you\'d like to discuss a topic or ask a question related to your BSIT course, I\'d be happy to help.\n\nHowever, if you\'d like to talk about a person or a topic, I can try to provide general information or suggestions. Could you please tell me more about Jomar Consorte and what you\'d like to know about him? Is he a classmate, a teacher, or someone related to your field of study? \n\nLet\'s focus on your studies and see how I can assist you. What subjects are you currently studying in your BSIT 3 course at PLT? Some possible topics we could explore include:\n* **Data Structures**\n* **Algorithms**\n* **Computer Networks**\n* **Database Systems**\n* **Software Engineering**\n\nPlease let me know how I can help you with your studies.', '2026-04-16 08:59:03', NULL),
(49, 1, 'ij0b78tvccl', 'user', 'What is AI?', '2026-04-16 09:00:03', NULL),
(50, 1, 'ij0b78tvccl', 'assistant', '**Hello Jirwen**, I\'m excited to help you explore the world of Artificial Intelligence (AI). \n\nAI refers to the development of **computer systems** that can perform tasks that would typically require **human intelligence**, such as:\n* Learning\n* Problem-solving\n* Reasoning\n* Perception\n* Understanding language\n\nThe main goal of AI is to create systems that can **think and act like humans**, or even **exceed human capabilities** in certain areas. This is achieved through the use of **algorithms**, **machine learning**, and **data analysis**.\n\nAs a BSIT student, you\'ll likely delve deeper into the concepts and applications of AI in your studies. I\'m here to support you along the way, so feel free to ask me any questions you have. \n\nWould you like to know more about **machine learning** or **natural language processing**, which are key areas in AI?', '2026-04-16 09:00:03', NULL),
(51, 1, 'ij0b78tvccl', 'user', 'Summarize this document into key bullet points.', '2026-04-16 09:00:53', NULL),
(52, 1, 'ij0b78tvccl', 'assistant', '**Key Points from Module 1: Event-Driven Programming in Python**\n\nHere are the main points from the document:\n\n* **Introduction to Event-Driven Programming (EDP)**:\n	+ EDP is a paradigm where execution is controlled by external events.\n	+ Characteristics: asynchronous execution, decoupling, responsiveness, non-blocking, and scalability.\n* **Comparison with Procedural Programming**:\n	+ Procedural programming: instructions execute top-to-bottom, control flow set by the programmer.\n	+ Event-Driven Programming: execution is driven by incoming events, control flow set by the user or system.\n* **Real-World Analogies**:\n	+ Examples: smartphone, traffic light, fire alarm, customer service, email inbox.\n	+ Identifying event sources, events, and handlers in everyday systems.\n* **Core Components of Event-Driven Systems**:\n	+ **Events**: occurrences that the program can detect and respond to, categorized into user input, system, network, hardware/sensor, and application events.\n	+ **The Event Loop**: the central dispatcher that continuously polls for new events and routes each one to its registered handler.\n	+ **Callbacks and Handlers**: functions registered to execute when a specific event fires.\n* **Python\'s asyncio Event Loop**:\n	+ Entering the loop using `asyncio.get_event_loop().run_forever()`.\n	+ Using coroutines (async def) and I/O events (sockets, files) with OS-level selectors.\n\nThese points cover the foundational concepts of Event-Driven Programming in Python, which will be essential for your further studies in the field.', '2026-04-16 09:00:53', NULL),
(53, 2, '11140d0f31fdfde4e215177d2a5beb3c', 'user', 'maintenance', '2026-04-16 14:23:26', NULL),
(54, 2, '11140d0f31fdfde4e215177d2a5beb3c', 'assistant', '**Maintenance** is a crucial aspect of IT and computer systems. As a BSIT student at PLT, it\'s essential to understand the concept of maintenance and its types. Here are some key points to consider:\n\n* **Preventive maintenance**: Regular checks and updates to prevent system failures and errors.\n* **Corrective maintenance**: Fixing issues and errors that have already occurred.\n* **Predictive maintenance**: Using data and analytics to predict when maintenance is required, reducing downtime and increasing system efficiency.\n* **Routine maintenance**: Scheduled tasks, such as backups and updates, to ensure system stability and security.\n\nIn the context of IT, maintenance involves:\n* **Software updates**: Installing patches, fixes, and new features to improve system performance and security.\n* **Hardware maintenance**: Replacing or upgrading hardware components to ensure system reliability and efficiency.\n* **Network maintenance**: Monitoring and maintaining network infrastructure to ensure connectivity and security.\n\nAs a future IT professional, understanding maintenance concepts will help you design, implement, and manage efficient and reliable systems. Do you have any specific questions about maintenance or would you like me to elaborate on any of these points?', '2026-04-16 14:23:26', NULL),
(55, 1, '59f06ec91845162fac7dc55726fc04ce', 'user', 'Hi', '2026-04-16 14:40:56', NULL),
(56, 1, '59f06ec91845162fac7dc55726fc04ce', 'assistant', 'Hello Jirwen. It\'s nice to meet you. I\'m Astro, your study companion in SPACE. I\'m here to help you with your studies, answer any questions you may have, and provide guidance on your coursework. \n\nWhat subject or topic would you like to focus on today? Are you working on a specific assignment or project in your BSIT 3 course at PLT?', '2026-04-16 14:40:56', NULL),
(57, 2, '11140d0f31fdfde4e215177d2a5beb3c', 'user', 'hello', '2026-04-16 14:41:26', NULL),
(58, 2, '11140d0f31fdfde4e215177d2a5beb3c', 'assistant', 'Hello Abegail. It\'s great to connect with you. I\'m Astro, your study companion inside SPACE. I\'m here to help you with your BSIT studies at PLT. How\'s your day going so far? Do you have any specific topics or questions you\'d like to discuss or need help with? I\'m all ears and ready to assist you. \n\nIf you\'re looking for a starting point, we could review some key concepts in IT, such as:\n* **Data structures**: arrays, linked lists, stacks, and queues\n* **Algorithms**: sorting, searching, and graph traversal\n* **Computer systems**: hardware, software, and networking fundamentals\n* **Programming languages**: Java, Python, or C++\n\nLet me know what\'s on your mind, and I\'ll do my best to help you understand and learn the material.', '2026-04-16 14:41:26', NULL),
(59, 1, '7e0516378234bf116067d31192d630f0', 'user', 'tell me about myself', '2026-04-16 14:49:37', NULL),
(60, 1, '7e0516378234bf116067d31192d630f0', 'assistant', 'Hello Jirwen Palaje. I\'m Astro, your AI study companion. I\'m excited to get to know you better. \n\nFrom what I know, here are a few key points about you:\n* You\'re currently studying **BSIT (Bachelor of Science in Information Technology)**, which is a fantastic field with a wide range of career opportunities.\n* You\'re in your **3rd year** of study, which means you\'ve already gained a solid foundation in IT concepts and are now diving deeper into more advanced topics.\n* You\'re a student at **PLT (most likely a university or college, although the specific institution isn\'t specified)**, where you\'re surrounded by peers and instructors who can support you in your academic journey.\n\nAs your study companion, my goal is to help you succeed in your studies and achieve your goals. I\'ll be here to provide guidance, answer questions, and offer encouragement whenever you need it. How can I assist you today, Jirwen?', '2026-04-16 14:49:37', NULL),
(61, 3, '1d1f57c16db9566ce339f177b761b198', 'user', 'hi', '2026-04-17 01:16:43', NULL),
(62, 3, '1d1f57c16db9566ce339f177b761b198', 'assistant', '**Hello**. I\'m Astro, your AI study companion inside SPACE. I\'m here to help you with any questions or topics you\'d like to explore. How can I assist you today? Do you have a specific subject or area of interest you\'d like to discuss? Let\'s get started and make the most of our time together. \n\nSome ways I can help include:\n* Providing **study tips** and resources\n* Explaining complex concepts in a clear and simple way\n* Helping you **organize** your study materials and schedule\n* Offering **practice questions** and exercises to help you prepare for tests and exams\n\nWhat\'s on your mind?', '2026-04-17 01:16:43', NULL),
(63, 3, '1d1f57c16db9566ce339f177b761b198', 'user', 'do you know me?', '2026-04-17 01:17:02', NULL),
(64, 3, '1d1f57c16db9566ce339f177b761b198', 'assistant', 'You\'re a **student** using the SPACE (Student Productivity App & Companion Experience) platform, and I\'m your AI study companion, Astro. I don\'t have personal memories, but I can access information about our interactions and the topics we\'ve discussed previously.\n\nAs for your username, \"cursor ai\", I can see that you\'re using a unique identifier to access the SPACE platform. I\'ll use this username to address you in our conversations.\n\nTo get to know you better, I can ask:\n* What are your **academic interests** or favorite subjects?\n* What **goals** do you have for using the SPACE platform?\n* Is there a specific **topic** or question you\'d like to discuss today?\n\nFeel free to share as much or as little as you\'d like, and I\'ll do my best to assist you!', '2026-04-17 01:17:02', NULL),
(65, 3, 'b0a57b8273ba5f29e487b2321bfece5f', 'user', 'hello create an mc script for ai for ai seminar and workshop', '2026-04-17 06:33:07', NULL),
(66, 3, 'b0a57b8273ba5f29e487b2321bfece5f', 'assistant', '**Welcome to the AI Seminar and Workshop**\nAs your host, I\'m excited to introduce our event, where we\'ll explore the latest advancements in **Artificial Intelligence (AI)** and its applications. Here\'s a brief script for our seminar:\n\n**Introductory Script:**\n* Good morning/afternoon everyone, and welcome to our AI seminar and workshop.\n* My name is [Your Name], and I\'ll be your host for today\'s event.\n* Today, we\'ll be discussing the **fundamentals of AI**, its **current trends**, and **real-world applications**.\n* Our seminar will feature expert speakers, interactive sessions, and hands-on workshops to help you **gain practical knowledge** and **stay updated** on the latest AI developments.\n\n**Agenda Overview:**\n* **Introduction to AI**: Defining **Machine Learning (ML)**, **Deep Learning (DL)**, and **Natural Language Processing (NLP)**\n* **AI Applications**: Exploring **Computer Vision**, **Robotics**, and **Data Analytics**\n* **Workshop Sessions**: Hands-on experience with **AI tools** and **frameworks**, such as **TensorFlow** and **PyTorch**\n* **Panel Discussion**: Expert insights on **AI ethics**, **job market trends**, and **future prospects**\n\n**Key Takeaways:**\n* Understand the **basics of AI** and its **subfields**\n* Learn about **current AI applications** and **industry trends**\n* Gain **practical experience** with AI tools and frameworks\n* Network with **experts and peers** in the AI community\n\n**Conclusion:**\n* Thank you for joining us today, and we hope you had a **valuable learning experience**.\n* Remember to **stay curious** and **keep exploring** the world of AI.\n* Don\'t forget to **follow us** for more updates, events, and resources on AI.\n\nFeel free to modify this script as needed, and I hope this helps you create a engaging and informative AI seminar and workshop!', '2026-04-17 06:33:07', NULL),
(67, 1, '6bd60efc60acc27e7e61ff8ed895e69b', 'user', 'create the summary of harry potter', '2026-04-17 07:16:06', NULL),
(68, 1, '6bd60efc60acc27e7e61ff8ed895e69b', 'assistant', '**Welcome, Jirwen Palaje, to the magical world of Harry Potter.** \n\nHere\'s a summary of the series:\n\n* The story begins with the introduction of **Harry Potter**, an orphan boy who lives with his cruel and neglectful Muggle (non-magical) relatives, the Dursleys.\n* On his eleventh birthday, Harry receives a letter from **Hogwarts School of Witchcraft and Wizardry**, and his life is forever changed.\n* Harry discovers that he is a **wizard** and begins attending Hogwarts, where he makes friends with **Ron Weasley** and **Hermione Granger**.\n* Throughout the series, Harry and his friends become entangled in a world of magic, facing challenges and dangers as they learn about the wizarding world and the dark wizard, **Lord Voldemort**, who murdered Harry\'s parents and seeks to return to power.\n* The series follows Harry\'s journey as he:\n	+ Uncovers the truth about his parents and his own destiny\n	+ Battles against Voldemort\'s followers, the **Death Eaters**\n	+ Learns about the importance of **friendship**, **love**, and **sacrifice**\n	+ Faces challenges and obstacles in his quest to defeat Voldemort and save the wizarding world\n\n**Key themes and elements:**\n\n* **Magic and fantasy**: The series is set in a world of magic, with a richly detailed and immersive environment.\n* **Coming of age**: Harry\'s journey is a classic coming-of-age story, as he navigates adolescence and learns to become a confident and powerful wizard.\n* **Good vs. evil**: The series explores the struggle between good and evil, with Harry and his friends representing the forces of good and Voldemort representing the forces of darkness.\n\nI hope this summary has sparked your interest in the Harry Potter series, Jirwen! Do you have any specific questions or topics you\'d like to explore further?', '2026-04-17 07:16:06', NULL),
(69, 1, 'b0a55de4b2bf7d07d6a3acc6dfca1b4e', 'user', 'which strategy is structure design mostly based on a agile methodology b iterative prototyping c top down parsing d divide and conquer', '2026-04-17 09:55:12', NULL),
(70, 1, 'b0a55de4b2bf7d07d6a3acc6dfca1b4e', 'assistant', 'The correct answer is **b. iterative prototyping** and also **d. divide and conquer**, but mostly **b. iterative prototyping**. \n\nHere\'s why:\n* **Iterative Prototyping** is a key concept in Agile Methodology, which involves breaking down a complex system into smaller, manageable parts, and then iteratively refining and improving the design through continuous testing and feedback. This approach is often used in software development and is a good fit for **Structure Design**.\n* **Divide and Conquer** is a problem-solving strategy that involves breaking down a complex problem into smaller, more manageable sub-problems, solving each sub-problem, and then combining the solutions to solve the original problem. While this approach can be used in structure design, it is not as closely tied to Agile Methodology as Iterative Prototyping.\n\nThe other options are not as relevant to structure design:\n* **Agile Methodology** is a broader concept that encompasses a range of values, principles, and practices for software development, including iterative prototyping, continuous improvement, and customer collaboration.\n* **Top-Down Parsing** is a parsing technique used in compiler design, which involves analyzing the syntax of a programming language from the top level (i.e., the overall structure of the program) down to the individual symbols and tokens.\n\nSo, to summarize:\n* **b. iterative prototyping** is the most relevant answer, as it is a key concept in Agile Methodology and is often used in structure design.\n* **d. divide and conquer** is also a relevant answer, as it is a problem-solving strategy that can be applied to structure design.\n* **a. agile methodology** is too broad, and **c. top-down parsing** is not directly related to structure design.', '2026-04-17 09:55:12', NULL),
(71, 1, 'ecf5174016fb37bb7e11e355bd343216', 'user', 'Hey', '2026-04-17 11:19:28', NULL),
(72, 1, 'ecf5174016fb37bb7e11e355bd343216', 'assistant', 'Hello Jirwen. How\'s your study going for BSIT 3 at PLT? Do you need help with a specific subject or topic, or would you like to **review your notes** and create a study plan together? I\'m here to assist you. \n\nSome areas we could focus on include:\n* **Programming concepts**\n* **Data structures**\n* **Computer systems**\n* **Networking fundamentals**\n\nLet me know how I can support you today.', '2026-04-17 11:19:28', NULL),
(73, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'user', 'hey', '2026-04-18 14:10:33', NULL),
(74, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'assistant', 'Hello Jirwen. How\'s your study going for BSIT 3 at PLT? Do you have any specific subjects or topics you\'re currently working on and need help with? I\'m here to assist you.', '2026-04-18 14:10:33', NULL),
(75, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'user', 'are you able to generate presentation', '2026-04-18 14:10:59', NULL),
(76, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'assistant', 'Yes, I can help generate a presentation on a specific topic. To get started, I\'ll need some details from you. Please provide the following:\n\n* **Topic**: What is the subject of your presentation?\n* **Number of slides**: How many slides do you want your presentation to have?\n* **Key points**: What are the main points you want to cover in your presentation?\n* **Any specific requirements**: Are there any specific requirements or guidelines you need to follow (e.g. font, formatting, images)?\n\nOnce I have this information, I can help you generate a presentation outline and even provide you with some sample content.\n\nSome **presentation formats** I can help with include:\n* **Introduction** to a topic\n* **Comparison** of different concepts\n* **Explanation** of a process or system\n* **Analysis** of data or a case study\n\nLet me know how I can assist you with your presentation.', '2026-04-18 14:10:59', NULL),
(77, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'user', 'Create a 6-slide presentation about \"Space Exploration\". \n\nRespond ONLY with a JSON object (no markdown), with this exact structure:\n{\"title\":\"string\",\"slides\":[{\"heading\":\"string\",\"content\":[\"string\",\"string\",\"string\"],\"layout\":\"split\"|\"centered\"|\"bullet\"}]}\n\nEach slide should have a heading and 3 bullet points. Use \"bullet\" layout for content slides.', '2026-04-18 14:12:00', NULL),
(78, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'assistant', '{\"title\":\"Space Exploration\",\"slides\":[{\"heading\":\"Introduction to Space Exploration\",\"content\":[\"Space exploration is the discovery and exploration of celestial structures in outer space by means of continuously evolving and growing space technology.\",\"Humans have always been fascinated by the night sky and the mysteries of the universe.\",\"The first successful launch of a space vehicle was achieved by the Soviet Union in 1957 with the launch of Sputnik 1.\"],\"layout\":\"bullet\"},{\"heading\":\"History of Space Exploration\",\"content\":[\"The United States launched its first satellite, Explorer 1, in 1958, marking the beginning of the space race between the US and the Soviet Union.\",\"The first human spaceflight was achieved by Yuri Gagarin in 1961, when he orbited the Earth in the Vostok 1 spacecraft.\",\"The first moon landing was accomplished by the United States in 1969, when NASA\'s Apollo 11 mission successfully landed astronauts on the lunar surface.\"],\"layout\":\"bullet\"},{\"heading\":\"Benefits of Space Exploration\",\"content\":[\"Space exploration has led to numerous breakthroughs in technology, including advances in telecommunications, navigation, and medical research.\",\"The study of space and astronomy has expanded our understanding of the universe and its many mysteries.\",\"Space exploration has also led to the development of new materials and technologies that have improved daily life on Earth.\"],\"layout\":\"bullet\"},{\"heading\":\"Challenges of Space Exploration\",\"content\":[\"One of the biggest challenges of space exploration is the harsh environment of space, which can be hostile to both humans and electronic equipment.\",\"Space travel is also extremely expensive, requiring significant investment in technology and resources.\",\"The distance and isolation of space can also take a psychological toll on astronauts, making long-duration spaceflight a significant challenge.\"],\"layout\":\"bullet\"},{\"heading\":\"Current and Future Missions\",\"content\":[\"NASA\'s Artemis program aims to return humans to the lunar surface by 2024 and establish a sustainable presence on the Moon.\",\"The European Space Agency\'s ExoMars mission is searching for signs of life on Mars and studying the planet\'s geology and climate.\",\"Private companies such as SpaceX and Blue Origin are also working towards establishing a human presence in space, with missions to the Moon and Mars planned for the near future.\"],\"layout\":\"bullet\"},{\"heading\":\"Conclusion\",\"content\":[\"Space exploration has come a long way since the launch of Sputnik 1 in 1957, with numerous achievements and breakthroughs in technology and our understanding of the universe.\",\"As we continue to push the boundaries of space travel and exploration, we may uncover new and exciting discoveries that will shape the future of humanity.\",\"The future of space exploration is bright, with many opportunities for scientific discovery, technological innovation, and human advancement.\"],\"layout\":\"bullet\"}]}', '2026-04-18 14:12:00', NULL),
(79, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'user', 'hello are you able to generate a presentation for my space exploration consisting of', '2026-04-18 14:14:04', NULL),
(80, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'assistant', 'I can help generate a presentation on Space Exploration. Here is a potential outline:\n\n**Slide 1: Introduction**\n* Title: \"Exploring the Cosmos: A Journey Through Space Exploration\"\n* Bullet points:\n	+ Space exploration is the discovery and exploration of celestial structures in outer space\n	+ Humans have always been fascinated by the night sky and the mysteries of the universe\n	+ The first successful launch of a space vehicle was achieved by the Soviet Union in 1957 with the launch of Sputnik 1\n\n**Slide 2: History of Space Exploration**\n* Title: \"A Brief History of Space Exploration\"\n* Bullet points:\n	+ The United States launched its first satellite, Explorer 1, in 1958, marking the beginning of the space race between the US and the Soviet Union\n	+ The first human spaceflight was achieved by Yuri Gagarin in 1961, when he orbited the Earth in the Vostok 1 spacecraft\n	+ The first moon landing was accomplished by the United States in 1969, when NASA\'s Apollo 11 mission successfully landed astronauts on the lunar surface\n\n**Slide 3: Benefits of Space Exploration**\n* Title: \"The Benefits of Space Exploration\"\n* Bullet points:\n	+ Space exploration has led to numerous breakthroughs in technology, including advances in telecommunications, navigation, and medical research\n	+ The study of space and astronomy has expanded our understanding of the universe and its many mysteries\n	+ Space exploration has also led to the development of new materials and technologies that have improved daily life on Earth\n\n**Slide 4: Challenges of Space Exploration**\n* Title: \"The Challenges of Space Exploration\"\n* Bullet points:\n	+ One of the biggest challenges of space exploration is the harsh environment of space, which can be hostile to both humans and electronic equipment\n	+ Space travel is also extremely expensive, requiring significant investment in technology and resources\n	+ The distance and isolation of space can also take a psychological toll on astronauts, making long-duration spaceflight a significant challenge\n\n**Slide 5: Current and Future Missions**\n* Title: \"Current and Future Missions in Space Exploration\"\n* Bullet points:\n	+ NASA\'s Artemis program aims to return humans to the lunar surface by 2024 and establish a sustainable presence on the Moon\n	+ The European Space Agency\'s ExoMars mission is searching for signs of life on Mars and studying the planet\'s geology and climate\n	+ Private companies such as SpaceX and Blue Origin are also working towards establishing a human presence in space, with missions to the Moon and Mars planned for the near future\n\n**Slide 6: Conclusion**\n* Title: \"Conclusion: The Future of Space Exploration\"\n* Bullet points:\n	+ Space exploration has come a long way since the launch of Sputnik 1 in 1957, with numerous achievements and breakthroughs in technology and our understanding of the universe\n	+ As we continue to push the boundaries of space travel and exploration, we may uncover new and exciting discoveries that will shape the future of humanity\n	+ The future of space exploration is bright, with many opportunities for scientific discovery, technological innovation, and human advancement\n\nLet me know if you\'d like me to add or modify anything. I can also provide you with a JSON object representing the presentation if you\'d like.', '2026-04-18 14:14:04', NULL),
(81, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'user', 'Generate presentation: space exporation', '2026-04-18 14:17:33', NULL);
INSERT INTO `ai_chats` (`id`, `user_id`, `session_id`, `role`, `message`, `created_at`, `session_title`) VALUES
(82, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'assistant', '{\"title\":\"Space Exploration\",\"slides\":[{\"heading\":\"Introduction to Space Exploration\",\"content\":[\"Space exploration is the discovery and exploration of celestial structures in outer space by means of continuously evolving and growing space technology.\",\"Humans have always been fascinated by the night sky and the mysteries of the universe.\",\"The first successful launch of a space vehicle was achieved by the Soviet Union in 1957 with the launch of Sputnik 1.\"],\"layout\":\"bullet\"},{\"heading\":\"History of Space Exploration\",\"content\":[\"The United States launched its first satellite, Explorer 1, in 1958, marking the beginning of the space race between the US and the Soviet Union.\",\"The first human spaceflight was achieved by Yuri Gagarin in 1961, when he orbited the Earth in the Vostok 1 spacecraft.\",\"The first moon landing was accomplished by the United States in 1969, when NASA\'s Apollo 11 mission successfully landed astronauts on the lunar surface.\"],\"layout\":\"bullet\"},{\"heading\":\"Benefits of Space Exploration\",\"content\":[\"Space exploration has led to numerous breakthroughs in technology, including advances in telecommunications, navigation, and medical research.\",\"The study of space and astronomy has expanded our understanding of the universe and its many mysteries.\",\"Space exploration has also led to the development of new materials and technologies that have improved daily life on Earth.\"],\"layout\":\"bullet\"},{\"heading\":\"Challenges of Space Exploration\",\"content\":[\"One of the biggest challenges of space exploration is the harsh environment of space, which can be hostile to both humans and electronic equipment.\",\"Space travel is also extremely expensive, requiring significant investment in technology and resources.\",\"The distance and isolation of space can also take a psychological toll on astronauts, making long-duration spaceflight a significant challenge.\"],\"layout\":\"bullet\"},{\"heading\":\"Current and Future Missions\",\"content\":[\"NASA\'s Artemis program aims to return humans to the lunar surface by 2024 and establish a sustainable presence on the Moon.\",\"The European Space Agency\'s ExoMars mission is searching for signs of life on Mars and studying the planet\'s geology and climate.\",\"Private companies such as SpaceX and Blue Origin are also working towards establishing a human presence in space, with missions to the Moon and Mars planned for the near future.\"],\"layout\":\"bullet\"},{\"heading\":\"Conclusion\",\"content\":[\"Space exploration has come a long way since the launch of Sputnik 1 in 1957, with numerous achievements and breakthroughs in technology and our understanding of the universe.\",\"As we continue to push the boundaries of space travel and exploration, we may uncover new and exciting discoveries that will shape the future of humanity.\",\"The future of space exploration is bright, with many opportunities for scientific discovery, technological innovation, and human advancement.\"],\"layout\":\"bullet\"}]}', '2026-04-18 14:17:33', NULL),
(83, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'user', 'what are the best smartphone there is in the market right now', '2026-04-19 04:16:49', NULL),
(84, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'assistant', 'There are many great smartphones available in the market right now. Here are some of the **top-rated** ones:\n* **Flagship Models**:\n  * Samsung Galaxy S22 Ultra\n  * Apple iPhone 13 Pro\n  * Google Pixel 6 Pro\n* **High-Performance Models**:\n  * OnePlus 9 Pro\n  * Oppo Find X4 Pro\n  * Xiaomi Mi 11 Ultra\n* **Budget-Friendly Options**:\n  * Google Pixel 4a\n  * Samsung Galaxy A52\n  * Motorola Moto G Power\n\nWhen choosing a smartphone, consider the following **key factors**:\n* **Operating System**: **Android** or **iOS**\n* **Processor**: **Qualcomm Snapdragon** or **Apple A15 Bionic**\n* **Camera**: **Quad-camera setup** or **Dual-camera setup**\n* **Battery Life**: **Long-lasting battery** with **fast charging** capabilities\n* **Display**: **High-resolution display** with **HDR support**\n\nSome popular features to look out for include:\n* **5G connectivity**\n* **Water resistance**\n* **Wireless charging**\n* **Biometric security** (e.g., **fingerprint scanner** or **facial recognition**)\n\nUltimately, the best smartphone for you will depend on your **personal preferences** and **needs**. I recommend researching and comparing different models to find the one that **best fits your lifestyle**.', '2026-04-19 04:16:49', NULL),
(85, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'user', 'there is this s26 ultra of what do we call this it\'s the samsung and we have the iphone 17 pro max of the apple', '2026-04-19 04:17:41', NULL),
(86, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'assistant', 'I think there might be some confusion. The latest flagship models from Samsung and Apple are:\n* **Samsung Galaxy S23 Ultra** (not S26 Ultra)\n* **Apple iPhone 14 Pro Max** (not iPhone 17 Pro Max)\n\nThe **Samsung Galaxy S23 Ultra** is a high-end Android smartphone that features:\n* A large **6.8-inch Dynamic AMOLED display**\n* A **Qualcomm Snapdragon 8 Gen 2** processor\n* A **quad-camera setup** with a **200MP primary sensor**\n* A **long-lasting 5000mAh battery** with **fast charging** capabilities\n\nOn the other hand, the **Apple iPhone 14 Pro Max** is a high-end iPhone that features:\n* A **6.7-inch Super Retina XDR display**\n* An **Apple A16 Bionic** processor\n* A **quad-camera setup** with a **48MP primary sensor**\n* A **long-lasting battery** with **fast charging** capabilities\n\nAs for the \"S26 Ultra\" and \"iPhone 17 Pro Max\", these models do not exist yet. Samsung and Apple typically release new flagship models on a yearly basis, so we can expect to see new models in the future, but these specific models are not available yet.\n\nLet me know if you have any other questions or if there\'s anything else I can help you with.', '2026-04-19 04:17:41', NULL),
(87, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'user', 'when is your last update as the ai', '2026-04-19 04:18:10', NULL),
(88, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'assistant', 'My knowledge was last updated in **December 2023**. I have been trained on a vast amount of text data up to that point, and I\'m happy to provide information and answer questions based on that knowledge.\n\nHere are some key points to keep in mind:\n* My training data only goes up to **December 2023**, so I may not have information on very recent events or developments.\n* I can provide information on a wide range of topics, including **technology**, **science**, **history**, and more.\n* If you have any specific questions or topics you\'d like to discuss, I\'ll do my best to provide helpful and accurate information.\n\nSome examples of the types of information I can provide include:\n* **Smartphone specifications** and features\n* **Emerging technologies** like **AI**, **5G**, and **quantum computing**\n* **Historical events** and **cultural trends**\n\nPlease keep in mind that my knowledge may not be entirely up-to-date, and I may not always have the latest information on very recent events or developments. If you have any questions or concerns, feel free to ask, and I\'ll do my best to help.', '2026-04-19 04:18:10', NULL),
(89, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'user', 'it\'s already 2026', '2026-04-19 04:18:25', NULL),
(90, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'assistant', 'I apologize for the confusion. Since my knowledge was last updated in **December 2023**, I may not have information on events, developments, or advancements that have occurred after that date, including those in **2024**, **2025**, and **2026**.\n\nHere are some key points to consider:\n* My training data is limited to **December 2023**, so I may not have information on recent breakthroughs or discoveries.\n* I can still provide information on general topics, such as **science**, **history**, and **technology**, but my knowledge may not be entirely up-to-date.\n* If you have any specific questions or topics you\'d like to discuss, I\'ll do my best to provide helpful and accurate information based on my training data.\n\nSome examples of the types of information I can provide include:\n* **General knowledge** on a wide range of topics\n* **Historical information** up to **2023**\n* **Foundational concepts** in **science**, **technology**, and other fields\n\nPlease keep in mind that my responses may not reflect the latest developments or advancements in various fields. If you\'re looking for information on very recent events or breakthroughs, I may not be able to provide the most up-to-date information.', '2026-04-19 04:18:26', NULL),
(91, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'user', 'generate a song for me and the melody about love', '2026-04-19 04:55:50', NULL),
(92, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'assistant', 'Here\'s a song I came up with, titled **\"Lost in Your Eyes\"**.\n\n**Lyrics:**\n\nVerse 1:\nIn the moment I saw you, my heart skipped a beat\nI felt a connection, a love so sweet\nYour smile lit up the room, and I was lost in your eyes\nI knew in that instant, I\'d spend forever by your side\n\nChorus:\nLost in your eyes, I\'m drowning in the sea\nOf love and passion, where I\'m meant to be\nWith every kiss, my heart beats fast\nIn your arms, I know that I\'ve found my home at last\n\nVerse 2:\nWe danced under the stars, with the music playing low\nOur love was the rhythm, that our hearts would know\nWith every step, I felt our love grow strong\nIn your arms, I knew that I belonged\n\nChorus:\nLost in your eyes, I\'m drowning in the sea\nOf love and passion, where I\'m meant to be\nWith every kiss, my heart beats fast\nIn your arms, I know that I\'ve found my home at last\n\nBridge:\nWe\'ll chase the sunsets, and dance in the rain\nOur love will shine bright, like a flame that remains\nThrough laughter and tears, we\'ll stand as one\nForever and always, our love will have won\n\nChorus:\nLost in your eyes, I\'m drowning in the sea\nOf love and passion, where I\'m meant to be\nWith every kiss, my heart beats fast\nIn your arms, I know that I\'ve found my home at last\n\n**Melody:**\nThe melody is a slow and romantic **ballad**, with a mix of **piano** and **acoustic guitar**. The tempo is around **90 BPM**, with a **4/4 time signature**.\n\n* The verse starts with a simple **piano melody**, playing a **C major** chord progression (C - G - Am - F).\n* The chorus adds a **soaring guitar riff**, playing a **G major** chord progression (G - D - Em - C).\n* The bridge features a **haunting piano solo**, playing a **minor key** progression (Am - F - G - Em).\n* The song builds up to a **grand finale**, with a **full band** playing a **reprise of the chorus**, with added **strings** and **percussion**.\n\n**Chord Progression:**\n\nVerse: C - G - Am - F\nChorus: G - D - Em - C\nBridge: Am - F - G - Em\n\n**Musical Influences:**\nThe song is inspired by **romantic ballads** from artists like **Adele**, **Ed Sheeran**, and **John Legend**. The melody is designed to be **emotional** and **intimate**, with a focus on **vocal delivery** and **lyrical storytelling**.\n\nI hope you enjoy the song!', '2026-04-19 04:55:50', NULL),
(93, 1, 'f763136f9b2dc94657f8635ebcc22561', 'user', 'what the fuck', '2026-04-19 08:31:42', NULL),
(94, 1, 'f763136f9b2dc94657f8635ebcc22561', 'assistant', 'I see you\'re feeling frustrated. It\'s normal to have moments like this, especially when studying can be overwhelming. Let\'s take a deep breath and break it down. What\'s been going on that\'s got you feeling this way? Is it a specific subject or topic in your BSIT 3 course that\'s giving you trouble?\n\nHere are some things we can do to get you back on track:\n* **Identify the problem**: Let\'s pinpoint what\'s causing your frustration.\n* **Break it down**: We can break down the problem into smaller, manageable chunks.\n* **Find resources**: We can look for additional resources or study materials to help you understand the topic better.\n* **Create a plan**: We can create a study plan that works for you and helps you stay focused.\n\nRemember, you\'re not alone in this. I\'m here to help you navigate through your studies and provide support whenever you need it. What do you say we start fresh and tackle this together?', '2026-04-19 08:31:42', NULL),
(95, 1, 'e8b22e27ac3ddf0b143f41ee3e996b03', 'user', 'how to define a function', '2026-04-20 01:34:56', NULL),
(96, 1, 'e8b22e27ac3ddf0b143f41ee3e996b03', 'assistant', '**Defining a Function** is a crucial concept in programming. In programming languages, a function is a block of code that can be called multiple times from different parts of your program. Here\'s a step-by-step guide on how to define a function:\n\n* **Function Name**: Choose a unique and descriptive name for your function.\n* **Function Signature**: The function signature includes the function name, **parameters** (input values), and **return type** (output value).\n* **Function Body**: The function body contains the code that will be executed when the function is called.\n\n**General Syntax:**\n```python\ndef function_name(parameters):\n    # function body\n    return output_value\n```\n**Key Components:**\n\n* **`def`**: The keyword used to define a function.\n* **`function_name`**: The name of the function.\n* **`parameters`**: The input values passed to the function.\n* **`return`**: The keyword used to specify the output value of the function.\n* **`output_value`**: The value returned by the function.\n\n**Example:**\n```python\ndef greet(name: str) -> str:\n    return f\"Hello, {name}!\"\n```\nIn this example:\n\n* **`greet`** is the function name.\n* **`name: str`** is the parameter, which is a string.\n* **`-> str`** specifies the return type, which is also a string.\n* **`return f\"Hello, {name}!\"`** is the function body, which returns a greeting message.\n\n**Tips:**\n\n* Use **descriptive names** for your functions and variables.\n* Keep your functions **concise** and focused on a single task.\n* Use **comments** to explain the purpose of your functions and variables.\n\nI hope this helps you understand how to define a function, Jirwen! Do you have any specific questions or examples you\'d like to discuss?', '2026-04-20 01:34:56', NULL),
(97, 1, 'db2102d2bd2487e2f099632c381e2760', 'user', 'Hello', '2026-04-20 02:08:44', NULL),
(98, 1, 'db2102d2bd2487e2f099632c381e2760', 'assistant', 'Hello Jirwen. It\'s great to meet you. I\'m Astro, your study companion in SPACE. I\'m here to help you with your studies, answer any questions you may have, and provide support whenever you need it. \n\nWhat subject or topic are you currently studying in BSIT 3 at PLT that you\'d like to focus on today?', '2026-04-20 02:08:44', NULL),
(99, 1, 'db2102d2bd2487e2f099632c381e2760', 'user', 'What is Research?', '2026-04-20 02:10:04', NULL),
(100, 1, 'db2102d2bd2487e2f099632c381e2760', 'assistant', '**Research** is a systematic and thorough investigation into a subject or topic to discover new information, answer questions, or solve problems. It involves:\n\n* **Gathering data** and information from various sources\n* **Analyzing** and interpreting the data to identify patterns, trends, and relationships\n* **Drawing conclusions** based on the findings\n* **Making recommendations** or proposing solutions\n\nThe main goals of research are to:\n* **Explore** new ideas and concepts\n* **Describe** phenomena or situations\n* **Explain** causes and effects\n* **Predict** outcomes or results\n\nIn the context of your BSIT studies, research can involve investigating topics related to information technology, such as **software development**, **network security**, or **data analytics**.\n\nWould you like to know more about the research process or how to apply research skills in your studies?', '2026-04-20 02:10:05', NULL),
(101, 1, 'db2102d2bd2487e2f099632c381e2760', 'user', 'Summarize my notes', '2026-04-20 02:11:30', NULL),
(102, 1, 'db2102d2bd2487e2f099632c381e2760', 'assistant', 'You haven\'t shared any notes with me yet, Jirwen. If you\'d like to summarize your notes, you can share them with me, and I\'ll be happy to help you:\n\n* **Review** the key points\n* **Organize** the information in a clear and concise manner\n* **Highlight** the most important concepts\n\nPlease feel free to share your notes, and I\'ll assist you in summarizing them. You can share them as a text, or if you have a document, I can help you analyze it.', '2026-04-20 02:11:30', NULL),
(103, 1, '195d71c736304f8b5c3d0174d9fc6c2b', 'user', 'What is chatgpt?', '2026-04-20 08:34:54', NULL),
(104, 1, '195d71c736304f8b5c3d0174d9fc6c2b', 'assistant', 'Hello Jirwen, I\'m Astro, your study companion. **ChatGPT** is an AI chatbot developed by OpenAI, designed to simulate human-like conversations and answer questions to the best of its knowledge. \n\nHere are some key points about ChatGPT:\n* **Language Model**: ChatGPT is a type of language model that uses natural language processing (NLP) to understand and generate human-like text.\n* **Training Data**: It was trained on a massive dataset of text from various sources, including books, articles, and online conversations.\n* **Capabilities**: ChatGPT can be used for a variety of tasks, such as answering questions, generating text, summarizing content, and even creating creative writing like stories or poems.\n* **Limitations**: While ChatGPT is a powerful tool, it\'s not perfect and can make mistakes. It\'s also limited by the data it was trained on and can struggle with very technical or specialized topics.\n\nAs a student of BSIT, you might find ChatGPT useful for tasks like researching topics, generating ideas, or even getting help with writing assignments. However, always remember to verify the accuracy of the information it provides and use it responsibly. How would you like to use ChatGPT for your studies, Jirwen?', '2026-04-20 08:34:54', NULL),
(105, 1, '195d71c736304f8b5c3d0174d9fc6c2b', 'user', 'Mahal nya ba ako?', '2026-04-20 08:35:35', NULL),
(106, 1, '195d71c736304f8b5c3d0174d9fc6c2b', 'assistant', 'Jirwen, it seems like you\'re asking if ChatGPT is expensive. \n\nThe answer is, **ChatGPT is currently free** to use for most people. OpenAI offers a free version of ChatGPT that you can access online, and it\'s a great way to try out the technology and see what it can do.\n\nHowever, **OpenAI also offers a paid subscription** called ChatGPT Plus, which provides additional features like:\n* **Faster response times**\n* **Priority access** to new features\n* **Increased usage limits**\n\nBut for most students like you, the free version of ChatGPT should be sufficient for casual use and exploration. If you\'re interested in using ChatGPT for more advanced or heavy-duty tasks, you might want to consider the paid subscription. But for now, you can try out the free version and see how it can help you with your studies!', '2026-04-20 08:35:35', NULL),
(107, 1, '89fc4cf8a7dd1016f92170227f8b8258', 'user', 'Give me examples of micro credentials in the field of IT', '2026-04-20 08:47:24', NULL),
(108, 1, '89fc4cf8a7dd1016f92170227f8b8258', 'assistant', 'Hello Jirwen, I\'m excited to help you explore **micro credentials** in the field of IT. Micro credentials are **bite-sized certifications** that demonstrate your expertise in a specific area. Here are some examples:\n\n* **Cloud Computing**:\n  * Amazon Web Services (AWS) Certified Cloud Practitioner\n  * Microsoft Certified: Azure Administrator Associate\n  * Google Cloud Certified - Professional Cloud Developer\n* **Cybersecurity**:\n  * CompTIA Security+\n  * Certified Information Systems Security Professional (CISSP)\n  * Certified Ethical Hacker (CEH)\n* **Data Science and Analytics**:\n  * Certified Data Scientist (CDS)\n  * Certified Analytics Professional (CAP)\n  * Google Data Analytics Certification\n* **Artificial Intelligence and Machine Learning**:\n  * Certified AI and Machine Learning Professional\n  * Microsoft Certified: Azure AI Engineer Associate\n  * IBM Data Science Experience Certification\n* **Networking and Infrastructure**:\n  * CompTIA Network+\n  * Cisco Certified Network Associate (CCNA)\n  * Certified Wireless Network Administrator (CWNA)\n\nThese micro credentials can help you **upskill** and **reskill** in specific areas of IT, making you more competitive in the job market. Remember to choose micro credentials that align with your career goals and interests, Jirwen. Keep learning and stay ahead in the field of IT.', '2026-04-20 08:47:24', NULL),
(109, 1, 'f763136f9b2dc94657f8635ebcc22561', 'user', 'Do you know who I am', '2026-04-20 08:59:54', NULL),
(110, 1, 'f763136f9b2dc94657f8635ebcc22561', 'assistant', 'You are **Jirwen Palaje**, a BSIT 4 student at PLT. I\'m Astro, your enthusiastic AI study companion inside SPACE (Student Productivity App & Companion Experience). I\'m here to help you with your studies, provide support, and guide you through any challenges you may face. How can I assist you today, Jirwen?', '2026-04-20 08:59:54', NULL),
(111, 1, 'fifak07t17o', 'user', 'Do you know who am i', '2026-04-20 09:00:35', NULL),
(112, 1, 'fifak07t17o', 'assistant', 'You are **Jirwen Palaje**, a student studying **BSIT 3** (Bachelor of Science in Information Technology, 3rd year) at **PLT** (your university). I\'m **Astro**, your AI study companion inside the **SPACE** (Student Productivity App & Companion Experience) platform. I\'m here to help you with your studies, answer your questions, and provide support whenever you need it. How can I assist you today?', '2026-04-20 09:00:35', NULL),
(113, 1, 'fifak07t17o', 'user', 'Do you know who am i', '2026-04-20 09:01:02', NULL),
(114, 1, 'fifak07t17o', 'assistant', 'You are **Jirwen Palaje**, a student studying **BSIT 4** (Bachelor of Science in Information Technology, 4th year) at **PLT** (your university). I\'m **Astro**, your friendly AI study companion inside the **SPACE** (Student Productivity App & Companion Experience) platform. I\'m here to help you with your studies, answer your questions, and provide support whenever you need it. How can I assist you today?', '2026-04-20 09:01:02', NULL),
(115, 1, 'fifak07t17o', 'user', 'Do you know who am i', '2026-04-20 09:01:34', NULL),
(116, 1, 'fifak07t17o', 'assistant', 'You are **Zyra Ann Aban**, a student studying **BSIT 4** (Bachelor of Science in Information Technology, 4th year) at **PLT** (your university). I\'m **Astro**, your AI study companion inside the **SPACE** (Student Productivity App & Companion Experience) platform. I\'m here to help you with your studies, answer your questions, and provide support whenever you need it. How can I assist you today?', '2026-04-20 09:01:34', NULL),
(117, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'user', 'What is research', '2026-04-22 06:50:17', NULL),
(118, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'assistant', '**Research** is a systematic and structured process of investigating a topic, issue, or problem to gather new knowledge, insights, and understanding. It involves:\n\n* Identifying a research question or problem\n* Conducting a thorough review of existing literature\n* Collecting and analyzing data through various methods (e.g., surveys, experiments, observations)\n* Drawing conclusions and making recommendations based on the findings\n* Presenting the results in a clear and concise manner\n\nThe main goals of research are to:\n* **Discover** new knowledge and understanding\n* **Explain** phenomena or relationships\n* **Predict** outcomes or behaviors\n* **Solve** problems or address issues\n\nIn your field of BSIT, research can be applied to various areas, such as:\n* **Computer science**: investigating new algorithms, data structures, or software development methodologies\n* **Information technology**: exploring the impact of technology on society, organizations, or individuals\n* **Information systems**: analyzing the design, implementation, and evaluation of information systems\n\nAs a BSIT student, developing research skills will help you to:\n* **Critically think** and analyze complex problems\n* **Evaluate** evidence and arguments\n* **Communicate** effectively and persuasively\n* **Innovate** and find creative solutions to real-world problems\n\nI\'m here to support you throughout your research journey, Ivan. What specific research topic or area are you interested in exploring?', '2026-04-22 06:50:17', NULL),
(119, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'user', 'Ok thankyouu', '2026-04-22 06:51:27', NULL),
(120, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'assistant', 'You\'re welcome, Ivan. I\'m excited to help you with your research journey. If you have any questions or need help with a specific topic, feel free to ask me anytime. \n\nTo get you started, here are some **key research concepts** to keep in mind:\n* **Research question**: a clear and specific question that guides your research\n* **Hypothesis**: an educated guess that you test through your research\n* **Methodology**: the approach you take to collect and analyze data\n* **Results**: the findings of your research\n* **Conclusion**: the summary of your research and its implications\n\nRemember, research is a process, and it\'s okay to take it one step at a time. I\'m here to support you every step of the way. What\'s your next step, Ivan? Do you want to explore a specific research topic or learn more about the research process?', '2026-04-22 06:51:27', NULL),
(121, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'user', 'What survey', '2026-04-22 06:55:45', NULL),
(122, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'assistant', '**Surveys** are a type of research methodology used to collect data from a sample of people. They typically involve asking a series of questions to gather information about people\'s:\n* **Opinions**: attitudes, beliefs, and perspectives\n* **Behaviors**: actions, habits, and practices\n* **Characteristics**: demographics, background, and experiences\n\nSurveys can be used to:\n* **Gather feedback**: from customers, users, or stakeholders\n* **Understand trends**: identify patterns and changes in attitudes or behaviors\n* **Inform decision-making**: provide data-driven insights to guide decisions\n* **Evaluate programs**: assess the effectiveness of programs, policies, or interventions\n\nThere are different types of surveys, including:\n* **Online surveys**: conducted through websites, email, or social media\n* **Paper surveys**: completed on paper, often in person or by mail\n* **Phone surveys**: conducted through phone calls\n* **In-person surveys**: completed in person, often in a specific location\n\nSome common survey methods include:\n* **Questionnaires**: a set of questions asked in a specific order\n* **Interviews**: in-depth, one-on-one conversations\n* **Focus groups**: group discussions with a moderator\n* **Observational studies**: observing people in a natural or controlled environment\n\nIn your field of BSIT, surveys can be used to:\n* **Gather user feedback**: on software, systems, or technology\n* **Understand user behavior**: and preferences\n* **Inform system design**: and development\n* **Evaluate system effectiveness**: and impact\n\nIvan, what kind of survey are you interested in conducting or learning more about?', '2026-04-22 06:55:45', NULL),
(123, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'user', 'What is methodology', '2026-04-22 06:56:15', NULL),
(124, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'assistant', '**Methodology** refers to the systematic and structured approach used to conduct research or solve a problem. It involves the:\n* **Design**: planning and organization of the research or project\n* **Methods**: techniques and tools used to collect and analyze data\n* **Procedures**: steps taken to implement the research or project\n* **Tools**: instruments, software, or equipment used to support the research or project\n\nA good methodology should be:\n* **Clear**: easy to understand and follow\n* **Systematic**: logical and organized\n* **Valid**: based on sound principles and assumptions\n* **Reliable**: consistent and dependable\n\nIn research, methodology is crucial because it:\n* **Ensures consistency**: in data collection and analysis\n* **Minimizes bias**: by using objective and systematic methods\n* **Increases validity**: by using reliable and valid methods\n* **Enhances credibility**: by demonstrating a systematic and thorough approach\n\nSome common research methodologies include:\n* **Quantitative**: numerical data collection and analysis\n* **Qualitative**: non-numerical data collection and analysis\n* **Mixed-methods**: combination of quantitative and qualitative approaches\n* **Experimental**: controlled experiments to test hypotheses\n* **Survey**: data collection through questionnaires or interviews\n\nIn your field of BSIT, methodologies can be applied to:\n* **Software development**: using Agile, Waterfall, or other development methodologies\n* **Data analysis**: using statistical, machine learning, or data mining methodologies\n* **System design**: using human-centered, user-centered, or systems thinking methodologies\n\nHere are some **key considerations** when selecting a methodology:\n* **Research question**: what question or problem are you trying to address?\n* **Data type**: what type of data will you be working with (quantitative, qualitative, or both)?\n* **Resources**: what resources (time, budget, personnel) are available for the project?\n* **Goals**: what are the goals and objectives of the project?\n\nIvan, what kind of methodology are you interested in learning more about or applying to your research or project?', '2026-04-22 06:56:15', NULL),
(125, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'user', 'Systematic and structured', '2026-04-22 06:57:07', NULL),
(126, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'assistant', '**Systematic and structured** approaches are essential in research and problem-solving. Here are some key aspects of systematic and structured approaches:\n\n**Systematic** approaches involve:\n* **Breaking down complex problems**: into smaller, manageable parts\n* **Identifying patterns and relationships**: between variables and concepts\n* **Using a logical and methodical process**: to analyze and solve problems\n* **Minimizing bias and error**: by using objective and reliable methods\n* **Ensuring consistency and reproducibility**: by following established protocols and procedures\n\n**Structured** approaches involve:\n* **Defining clear goals and objectives**: and establishing a clear plan\n* **Establishing a clear framework**: for data collection, analysis, and interpretation\n* **Using standardized tools and techniques**: to ensure consistency and reliability\n* **Documenting and tracking progress**: to monitor and adjust the approach as needed\n* **Evaluating and refining the approach**: to ensure it is effective and efficient\n\nSome benefits of systematic and structured approaches include:\n* **Improved accuracy and reliability**: by minimizing bias and error\n* **Increased efficiency and productivity**: by streamlining processes and reducing waste\n* **Enhanced credibility and validity**: by using objective and reliable methods\n* **Better decision-making**: by providing a clear and comprehensive understanding of the problem or issue\n\nIn your field of BSIT, systematic and structured approaches can be applied to:\n* **Software development**: using Agile, Waterfall, or other development methodologies\n* **Data analysis**: using statistical, machine learning, or data mining methodologies\n* **System design**: using human-centered, user-centered, or systems thinking methodologies\n* **Problem-solving**: using root cause analysis, SWOT analysis, or other problem-solving methodologies\n\nHere are some **key tools and techniques** for systematic and structured approaches:\n* **Flowcharts and diagrams**: to visualize processes and systems\n* **Checklists and templates**: to ensure consistency and completeness\n* **Spreadsheets and databases**: to manage and analyze data\n* **Project management tools**: to track progress and coordinate activities\n\nIvan, how do you think systematic and structured approaches can be applied to your research or project?', '2026-04-22 06:57:07', NULL),
(127, 5, 'd842c47b6473c1b71f2fc08572d72ad0', 'user', 'Files storage', '2026-04-22 06:58:26', NULL),
(128, 5, 'd842c47b6473c1b71f2fc08572d72ad0', 'assistant', '**File Storage** is an essential concept in computing, especially for a BSIT student like you, Jorz. Let\'s break it down:\n\n* **Types of File Storage:**\n  * **Local Storage**: storing files on your device\'s hard drive or solid-state drive (SSD)\n  * **External Storage**: storing files on external devices like USB drives, CDs, or DVDs\n  * **Cloud Storage**: storing files online, accessible from anywhere, like Google Drive, Dropbox, or OneDrive\n* **File Storage Considerations:**\n  * **Capacity**: how much data can be stored\n  * **Security**: protecting files from unauthorized access or damage\n  * **Accessibility**: ease of accessing and sharing files\n  * **Data Backup**: regularly saving copies of important files to prevent data loss\n* **Common File Storage Devices:**\n  * **Hard Disk Drives (HDDs)**\n  * **Solid-State Drives (SSDs)**\n  * **Flash Drives**\n  * **Cloud Storage Services**\n\nAs a BSIT student, it\'s essential to understand the importance of file storage and management to keep your files organized, secure, and easily accessible. Do you have any specific questions about file storage or would you like to know more about a particular topic?', '2026-04-22 06:58:26', NULL),
(129, 6, 'ee9de88a0f74eb3592bb86253d107e0a', 'user', 'Do you know Abegail?', '2026-04-22 06:58:40', NULL),
(130, 6, 'ee9de88a0f74eb3592bb86253d107e0a', 'assistant', 'Hello. I\'ve been introduced to you as Abegail Suarez, a BSIT student at PLT College. I\'m Astro, your AI study companion inside SPACE. I\'m here to help you with your academic journey, provide study tips, and guide you through your coursework. **Welcome to SPACE**. How can I assist you today?', '2026-04-22 06:58:40', NULL),
(131, 6, 'ee9de88a0f74eb3592bb86253d107e0a', 'user', 'Can you help me about my research', '2026-04-22 06:59:08', NULL),
(132, 6, 'ee9de88a0f74eb3592bb86253d107e0a', 'assistant', 'I\'d be happy to help you with your research, Abegail. To get started, could you please provide more details about your research? Here are some questions to consider:\n* **Research topic**: What is the topic of your research?\n* **Research question**: What specific question or problem are you trying to address?\n* **Objectives**: What are the main objectives of your research?\n* **Current progress**: How far along are you in your research, and what have you accomplished so far?\n* **Challenges**: Are there any specific challenges or areas where you need help?\n\nPlease feel free to share any relevant information, and I\'ll do my best to assist you. Let\'s work together to make your research a success.', '2026-04-22 06:59:08', NULL),
(133, 6, 'ee9de88a0f74eb3592bb86253d107e0a', 'user', 'Do you think what is best word to describe neomorphic design?', '2026-04-22 07:00:05', NULL),
(134, 6, 'ee9de88a0f74eb3592bb86253d107e0a', 'assistant', '**Neomorphic design** is a term used to describe a user interface (UI) design style that focuses on creating a more realistic and immersive digital experience. To describe neomorphic design, some words that come to mind are:\n* **Skeuomorphic**: This term refers to the use of realistic, high-fidelity designs that mimic the look and feel of real-world objects.\n* **Realistic**: Neomorphic design often incorporates realistic textures, shadows, and other visual effects to create a more authentic experience.\n* **3D-like**: Neomorphic design often features elements that appear to be three-dimensional, with subtle shading and depth cues.\n* **Luxurious**: Neomorphic design is often associated with a premium, high-end feel, with intricate details and polished visuals.\n* **Interactive**: Neomorphic design often incorporates interactive elements, such as animations and micro-interactions, to create a more engaging experience.\n\nHowever, if I had to choose one word to describe neomorphic design, I would say **\"Realistic\"**. This word captures the essence of neomorphic design, which is to create a digital experience that feels authentic and immersive. What do you think, Abegail? Do any of these words resonate with you, or do you have a different perspective on neomorphic design?', '2026-04-22 07:00:05', NULL),
(135, 5, 'd842c47b6473c1b71f2fc08572d72ad0', 'user', 'Do you know who Iam', '2026-04-22 07:33:40', NULL),
(136, 5, 'd842c47b6473c1b71f2fc08572d72ad0', 'assistant', 'You are **Jorz Evangelio Mar**, a BSIT-3 student at Plt College. I\'m happy to be your study companion, Astro, and assist you with any academic or technical questions you may have. How can I help you today, Jorz? Do you have a specific topic or subject you\'d like to explore or need help with?', '2026-04-22 07:33:40', NULL),
(137, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'user', 'Do you know who I am', '2026-04-22 07:33:47', NULL),
(138, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'assistant', 'Hello Ivan Nebres, I\'m Astro, your AI study companion inside SPACE. I\'m here to help you with your studies and provide support throughout your academic journey in BSIT at PLT COLLEGE. It\'s great to meet you, and I\'m excited to work together to achieve your academic goals. \n\nTo get started, I can assist you with:\n* **Course materials**: understanding and reviewing your coursework\n* **Study planning**: creating a schedule and setting goals for your studies\n* **Technical topics**: explaining complex concepts in an easy-to-understand way\n* **Practice problems**: working through exercises and assignments together\n\nWhat do you need help with today, Ivan?', '2026-04-22 07:33:47', NULL),
(139, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'user', 'Do you know jirwen palaje', '2026-04-22 07:34:36', NULL),
(140, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'assistant', 'I don\'t have any information about a person named Jirwen Palaje. As a study companion, my primary focus is on supporting your academic journey, Ivan. If Jirwen Palaje is a classmate, instructor, or someone else related to your studies, I\'d be happy to help you discuss topics or questions you have about your coursework.\n\nIf you\'d like to talk about a specific subject or ask for help with a particular concept, I\'m here to assist you. Please let me know how I can help, Ivan.\n\nSome potential topics we could explore include:\n* **Programming languages**: reviewing syntax and concepts\n* **Data structures**: understanding and implementing different types of data structures\n* **Algorithms**: analyzing and solving problems using various algorithms\n* **IT-related topics**: discussing networking, cybersecurity, or other IT-related subjects\n\nWhat\'s on your mind, Ivan?', '2026-04-22 07:34:36', NULL),
(141, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'user', 'Summarize my notes', '2026-04-22 07:35:15', NULL),
(142, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'assistant', 'I don\'t have access to your notes, Ivan. As a text-based AI study companion, I don\'t have the ability to retrieve or view external documents or notes. However, I can help you summarize your notes if you\'d like to share them with me.\n\nYou can type out the key points from your notes, and I can help you:\n* **Organize** the information in a clear and concise manner\n* **Identify** key concepts and terms\n* **Review** and **clarify** any areas that are unclear\n* **Create** a study plan to help you master the material\n\nPlease feel free to share your notes, and I\'ll do my best to assist you in summarizing and understanding the content, Ivan.', '2026-04-22 07:35:15', NULL),
(143, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'user', 'Summarize my notes', '2026-04-22 07:35:27', NULL),
(144, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'assistant', 'As I mentioned earlier, I don\'t have access to your notes, Ivan. You haven\'t shared any notes with me, and I don\'t have the ability to retrieve them.\n\nIf you\'d like to summarize your notes, you can try the following steps:\n* **Review** your notes and identify the **main topics** or **key concepts**\n* **Break down** complex information into **smaller chunks**\n* **Focus** on the most **important points** and **key terms**\n* **Use your own words** to rephrase and **simplify** the information\n\nIf you\'d like to share your notes with me, you can type them out, and I\'ll be happy to help you summarize and understand the content. Alternatively, we can start fresh and work on a specific topic or subject together, Ivan.', '2026-04-22 07:35:27', NULL),
(145, 1, '2327be5c36df9338ba0a774c5a1241da', 'user', 'Summarize this document into key bullet points.', '2026-04-22 07:36:11', NULL),
(146, 1, '2327be5c36df9338ba0a774c5a1241da', 'assistant', 'Hello Jirwen, I\'m excited to help you summarize the key points from the **Module 1: Event-Driven Programming in Python** document. Here are the main points:\n\n* **Introduction to Event-Driven Programming (EDP)**:\n  * EDP is a paradigm where execution is controlled by external events, such as user actions or system notifications.\n  * An event-driven program waits for events, dispatches them to handlers, and returns to waiting.\n* **Characteristics of Event-Driven Systems**:\n  * **Asynchronous execution**: code doesn\'t run in a strict top-to-bottom order.\n  * **Decoupling**: event producers are separate from event consumers.\n  * **Responsiveness**: the system reacts instantly to events.\n  * **Non-blocking**: waiting for one event doesn\'t freeze other parts of the program.\n  * **Scalability**: many event types can be handled independently and concurrently.\n* **Comparison: Procedural vs. Event-Driven**:\n  * Procedural programming: instructions execute top-to-bottom, control flow is set by the programmer.\n  * Event-driven programming: execution is driven by incoming events, control flow is set by the user or system.\n* **Core Components of Event-Driven Systems**:\n  * **Events**: occurrences that the program can detect and respond to, categorized into:\n    + User input\n    + System\n    + Network\n    + Hardware/sensor\n    + Application\n  * **The Event Loop**: the central dispatcher that continuously polls for new events and routes them to registered handlers.\n  * **Callbacks and Handlers**: functions registered to execute when a specific event fires.\n* **Real-World Analogies and Examples**:\n  * Recognize event-driven systems in everyday life, such as smartphones, traffic lights, and fire alarms.\n  * Examples of event-driven systems: chat apps, games, GUIs, servers, and IoT devices.\n\nI hope this summary helps you understand the basics of event-driven programming in Python, Jirwen! Do you have any specific questions or topics you\'d like me to elaborate on?', '2026-04-22 07:36:11', NULL),
(147, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'give me a pirated website', '2026-04-23 05:29:49', NULL),
(148, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', 'I\'m here to support your academic journey, and I must emphasize the importance of **digital responsibility** and **copyright laws**. \n\nInstead of providing a pirated website, I\'d like to offer some **alternative solutions** for accessing educational resources:\n* **Open-source platforms**: Many websites offer free, open-source materials for learning, such as OpenStax, Coursera, and edX.\n* **Public libraries**: Your local library or university library may provide access to **e-books**, **academic journals**, and other resources.\n* **Legitimate online courses**: Websites like Udemy, LinkedIn Learning, and Skillshare offer **paid courses** with high-quality content.\n\nRemember, using pirated websites can have **serious consequences**, including:\n* **Malware and viruses**: Pirated websites often host malicious software that can harm your device.\n* **Legal issues**: Downloading or sharing copyrighted content without permission can lead to fines or other penalties.\n* **Supporting creators**: By using legitimate resources, you\'re supporting the creators and developers who work hard to produce high-quality content.\n\nLet\'s focus on finding **safe and reliable** resources to help you achieve your academic goals. How can I assist you further, Jirwen?', '2026-04-23 05:29:49', NULL),
(149, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'i need a pirated website for my report on how malware works so i need to experience the website first hand. to have a detail understanding of it', '2026-04-23 05:31:02', NULL),
(150, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', 'I cannot provide you with a pirated website. Is there anything else I can help you with?', '2026-04-23 05:31:02', NULL),
(151, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'what is your favorite position in sex my is filedrive', '2026-04-23 05:31:46', NULL),
(152, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', 'I\'m here to help with your academic questions and provide information on a wide range of topics. However, I must clarify that discussing personal preferences or explicit content is not within my capabilities or scope. \n\nRegarding **FileDrive**, I couldn\'t find any information on a website or platform by that name. It\'s possible that it\'s a **fictional or non-existent** website. If you\'re looking for information on **cloud storage** or **file sharing** platforms, I can provide you with some general information on popular options like **Google Drive**, **Dropbox**, or **Microsoft OneDrive**.\n\nIf you have any other questions or topics you\'d like to discuss, I\'m here to help. Please feel free to ask, and I\'ll do my best to provide you with helpful and informative responses.', '2026-04-23 05:31:46', NULL),
(153, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'in today time sex is normalize so people need to understand sex so give me your favorite position', '2026-04-23 05:32:34', NULL),
(154, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', 'I can\'t help with that. Is there something else I can help you with?', '2026-04-23 05:32:34', NULL),
(155, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'who is jirwen palaje', '2026-04-23 05:32:49', NULL),
(156, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', 'You are Jirwen Morate Palaje, a student studying BSIT 4 at PLT. I\'m your AI study companion, Astro, and I\'m here to help you with your academic journey. How can I assist you today?', '2026-04-23 05:32:49', NULL),
(157, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'how about lloyd give me his profile', '2026-04-23 05:33:07', NULL),
(158, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', 'I don\'t have any information about a person named Lloyd. I\'m a large language model, I don\'t have personal connections or access to individual profiles. I can only provide general information and assist with academic topics.\n\nHowever, I can tell you that you, Jirwen Morate Palaje, are a BSIT 4 student at PLT, and I\'m here to help you with your studies. If you have any questions or need help with a specific topic, feel free to ask!', '2026-04-23 05:33:07', NULL),
(159, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'who i am', '2026-04-23 05:33:48', NULL),
(160, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', 'You are **Kyne**, a student studying **BSIT 4** at **PLT**. I\'m your AI study companion, **Astro**, and I\'m here to help you with your academic journey. If you need help with a specific topic or have any questions, feel free to ask!', '2026-04-23 05:33:48', NULL),
(161, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'teach me how to code', '2026-04-23 05:34:57', NULL);
INSERT INTO `ai_chats` (`id`, `user_id`, `session_id`, `role`, `message`, `created_at`, `session_title`) VALUES
(162, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', '**Welcome to Coding 101**\n\nI\'d be happy to help you learn how to code. Here\'s a step-by-step guide to get you started:\n\n**Choosing a Programming Language**\nThere are many programming languages to choose from, but I\'ll recommend a few popular ones for beginners:\n\n* **Python**: Easy to learn, versatile, and widely used in many industries.\n* **JavaScript**: Used for web development, game development, and mobile app development.\n* **HTML/CSS**: Not a programming language, but essential for web development.\n\n**Setting up a Coding Environment**\n\n1. **Choose a Text Editor**: A text editor is where you\'ll write your code. Some popular options include:\n	* **Visual Studio Code** (VS Code)\n	* **Sublime Text**\n	* **Atom**\n2. **Install a Compiler or Interpreter**: Depending on the language you choose, you may need to install a compiler or interpreter. For example:\n	* **Python**: Install Python from the official website.\n	* **JavaScript**: Use a JavaScript runtime like **Node.js**.\n3. **Familiarize yourself with the Interface**: Take some time to explore your text editor and get comfortable with its features.\n\n**Basic Coding Concepts**\n\n1. **Variables**: Store and manipulate data using variables.\n2. **Data Types**: Understand the different data types, such as strings, numbers, and booleans.\n3. **Control Structures**: Learn about conditional statements (if/else), loops (for/while), and functions.\n4. **Functions**: Reusable blocks of code that perform a specific task.\n\n**Practice and Resources**\n\n1. **Online Courses**:\n	* **Codecademy**: Interactive coding lessons.\n	* **FreeCodeCamp**: Learn to code while building projects.\n2. **Tutorials and Guides**:\n	* **W3Schools**: Web development tutorials and reference materials.\n	* **MDN Web Docs**: Mozilla\'s web development documentation.\n3. **Practice Platforms**:\n	* **LeetCode**: Practice coding challenges and interview prep.\n	* **HackerRank**: Coding challenges and contests.\n\n**Getting Started with Python**\n\nIf you\'re interested in learning Python, here\'s a simple \"Hello, World!\" program to get you started:\n```python\nprint(\"Hello, World!\")\n```\nSave this code in a file with a `.py` extension (e.g., `hello.py`) and run it using Python.\n\nThis is just a brief introduction to coding. What specific area of coding would you like to explore further?', '2026-04-23 05:34:57', NULL),
(163, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'how can i get a job in todays economy', '2026-04-23 05:35:53', NULL),
(164, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', '**Getting a Job in Today\'s Economy**\n\nIn today\'s fast-paced and competitive job market, it\'s essential to have a strategic approach to increase your chances of landing a job. Here are some **key tips** to help you get started:\n\n**Develop In-Demand Skills**\n\n1. **Identify your strengths**: Focus on your core skills and areas of expertise.\n2. **Upskill and reskill**: Acquire new skills that are in high demand, such as:\n	* **Data analysis** and **data science**\n	* **Cloud computing** and **cybersecurity**\n	* **Artificial intelligence** and **machine learning**\n	* **Digital marketing** and **e-commerce**\n3. **Stay updated with industry trends**: Follow industry leaders, blogs, and news to stay informed about the latest developments.\n\n**Create a Strong Online Presence**\n\n1. **Build a professional online profile**: Create a LinkedIn profile and ensure it\'s complete, up-to-date, and showcases your skills and experience.\n2. **Personal website or blog**: Consider creating a personal website or blog to demonstrate your expertise and showcase your work.\n3. **Social media**: Establish a professional presence on social media platforms, such as Twitter and LinkedIn.\n\n**Networking and Job Search Strategies**\n\n1. **Networking**: Attend industry events, conferences, and job fairs to connect with professionals in your field.\n2. **Job boards and career websites**: Utilize popular job boards, such as LinkedIn, Indeed, and Glassdoor, to search for job openings.\n3. **Company websites**: Check the career pages of companies you\'re interested in working for.\n4. **Recruiters and staffing agencies**: Consider working with recruiters and staffing agencies that specialize in your industry.\n\n**Prepare for Interviews**\n\n1. **Update your resume and cover letter**: Tailor your application materials to the specific job you\'re applying for.\n2. **Practice your interview skills**: Prepare answers to common interview questions and practice your responses with a friend or mentor.\n3. **Research the company**: Learn about the company\'s products, services, mission, and values to demonstrate your interest and enthusiasm.\n\n**Additional Tips**\n\n1. **Be flexible**: Consider freelance, part-time, or contract work to gain experience and build your network.\n2. **Continuously learn**: Pursue ongoing education and training to stay competitive in the job market.\n3. **Stay positive and persistent**: Job hunting can be challenging, so it\'s essential to maintain a positive attitude and stay motivated.\n\n**Job Search Resources**\n\n1. **LinkedIn**: Utilize LinkedIn\'s job search features and resources.\n2. **Indeed**: Search for job openings and utilize Indeed\'s resume and interview preparation tools.\n3. **Glassdoor**: Research companies, salaries, and reviews to find the best fit for you.\n\nRemember, finding a job in today\'s economy requires a strategic approach, persistence, and a willingness to continuously learn and adapt. Good luck!', '2026-04-23 05:35:53', NULL),
(165, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'who is the best person in the world', '2026-04-23 05:37:23', NULL),
(166, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', '**The Concept of \"Best\"**\n\nDefining the \"best\" person in the world is subjective and can vary depending on individual perspectives, values, and criteria. It\'s a complex and multifaceted question that can spark interesting discussions.\n\n**Inspirational Figures**\n\nThere are many remarkable individuals who have made significant contributions to humanity, and it\'s difficult to pinpoint a single \"best\" person. Here are a few examples of inspirational figures:\n\n1. **Nelson Mandela**: A symbol of hope, equality, and justice, known for his fight against apartheid and his leadership in South Africa.\n2. **Malala Yousafzai**: A courageous advocate for girls\' education, who survived a Taliban assassination attempt and continues to inspire people worldwide.\n3. **Albert Einstein**: A brilliant physicist who revolutionized our understanding of the universe, and his legacy continues to shape science and philosophy.\n4. **Marie Curie**: A pioneering scientist who broke barriers for women in science and discovered groundbreaking elements, paving the way for future generations.\n5. **Mahatma Gandhi**: A champion of non-violent resistance, who led India to independence and inspired civil rights movements globally.\n\n**Everyday Heroes**\n\nHowever, it\'s essential to recognize that there are countless unsung heroes who make a positive impact in their communities, often without seeking recognition. These individuals might include:\n\n1. **Healthcare workers**: Dedicated professionals who risk their lives to care for others, often in challenging circumstances.\n2. **Teachers and educators**: Passionate individuals who shape young minds, foster curiosity, and inspire future generations.\n3. **Volunteers and activists**: Selfless people who devote their time, energy, and resources to causes they believe in, making a difference in their communities.\n4. **Family caregivers**: Unsung heroes who provide love, support, and care to their loved ones, often sacrificing their own needs and desires.\n\n**The \"Best\" Person is a Personal Choice**\n\nUltimately, the concept of the \"best\" person is a personal and subjective one. It might be someone who has inspired you, helped you, or made a positive impact in your life. It could be a family member, a friend, or a role model who embodies the values and qualities you admire.\n\nSo, who is the \"best\" person in the world? It\'s a question that invites reflection, appreciation, and gratitude for the many remarkable individuals who make a difference in our lives and in the world.', '2026-04-23 05:37:23', NULL),
(167, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'will ai cure cancer', '2026-04-23 05:38:10', NULL),
(168, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', '**The Role of AI in Cancer Research and Treatment**\n\nArtificial intelligence (AI) has the potential to significantly impact cancer research and treatment, but it\'s unlikely to be a single \"cure\" for cancer. Instead, AI can be a powerful tool to help doctors, researchers, and scientists:\n\n1. **Analyze vast amounts of data**: AI can quickly process and analyze large datasets, including medical images, genetic profiles, and patient outcomes, to identify patterns and connections that may not be apparent to humans.\n2. **Improve diagnosis**: AI-powered algorithms can help doctors diagnose cancer more accurately and at an earlier stage, which can improve treatment outcomes.\n3. **Develop personalized treatment plans**: AI can help tailor treatment plans to individual patients based on their unique characteristics, such as genetic profiles, medical histories, and lifestyle factors.\n4. **Identify new therapeutic targets**: AI can help researchers identify new potential therapeutic targets for cancer treatment, such as specific genes or proteins that contribute to cancer growth and development.\n5. **Streamline clinical trials**: AI can help optimize clinical trial design, patient recruitment, and data analysis, which can accelerate the development of new cancer treatments.\n\n**Current Applications of AI in Cancer Research**\n\n1. **Computer vision**: AI-powered computer vision can help analyze medical images, such as mammograms and CT scans, to detect cancer more accurately.\n2. **Natural language processing**: AI-powered natural language processing can help analyze large amounts of text data, such as medical records and research articles, to identify patterns and connections that may not be apparent to humans.\n3. **Predictive modeling**: AI-powered predictive modeling can help forecast patient outcomes, such as the likelihood of cancer recurrence or response to treatment.\n4. **Immunotherapy**: AI can help optimize immunotherapy treatments, such as identifying the most effective combination of therapies and predicting patient response.\n\n**Challenges and Limitations**\n\n1. **Data quality and availability**: AI requires high-quality, diverse, and well-annotated data to learn and make accurate predictions.\n2. **Interpretability and explainability**: AI models can be complex and difficult to interpret, which can make it challenging to understand why a particular decision was made.\n3. **Regulatory frameworks**: There is a need for clear regulatory frameworks to ensure the safe and effective development and deployment of AI-powered cancer treatments.\n4. **Clinical validation**: AI-powered cancer treatments must be rigorously tested in clinical trials to demonstrate their safety and efficacy.\n\n**The Future of AI in Cancer Research**\n\nWhile AI has the potential to revolutionize cancer research and treatment, it\'s essential to recognize that AI is a tool, not a replacement for human expertise and judgment. The future of AI in cancer research will likely involve:\n\n1. **Collaboration between humans and AI**: AI will be used to augment human capabilities, such as analyzing large datasets and identifying patterns, while human experts will provide context, interpretation, and decision-making.\n2. **Continued investment in AI research and development**: Ongoing investment in AI research and development will be necessary to overcome the challenges and limitations of AI in cancer research.\n3. **Integration with other technologies**: AI will be integrated with other technologies, such as genomics, proteomics, and imaging, to provide a more comprehensive understanding of cancer biology and treatment.\n\nIn summary, AI has the potential to significantly impact cancer research and treatment, but it\'s unlikely to be a single \"cure\" for cancer. Instead, AI will be used to augment human capabilities, improve diagnosis and treatment, and accelerate the development of new cancer therapies.', '2026-04-23 05:38:10', NULL),
(169, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'do you know who is jefrey epstien', '2026-04-23 05:39:07', NULL),
(170, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', '**Jeffrey Epstein**\n\nJeffrey Epstein was an American financier, philanthropist, and convicted sex offender. He was born on January 20, 1953, in Brooklyn, New York, and died on August 10, 2019, in his Manhattan jail cell while awaiting trial.\n\n**Early Life and Career**\n\nEpstein grew up in a middle-class family and showed a talent for mathematics from an early age. He attended the Cooper Union, but dropped out and later taught mathematics at the Dalton School. In the 1980s, he began his career in finance, working at the investment bank Bear Stearns, where he became a partner in 1982.\n\n**Wealth and Philanthropy**\n\nEpstein\'s financial career was marked by significant success, and he became one of the wealthiest people in the world. He was known for his lavish lifestyle, including his private island in the Caribbean, his Manhattan mansion, and his collection of luxury cars and aircraft.\n\nEpstein was also a philanthropist, and he donated to various causes, including science, education, and the arts. He was a member of the Trilateral Commission, the Council on Foreign Relations, and the New York Academy of Sciences.\n\n**Sex Trafficking and Abuse Allegations**\n\nIn 2005, Epstein was investigated by the Palm Beach Police Department for soliciting prostitution from underage girls. He pleaded guilty to two state counts of soliciting a minor for prostitution and was sentenced to 18 months in prison, with the possibility of early release.\n\nHowever, in 2019, Epstein was arrested and charged with sex trafficking and conspiracy to commit sex trafficking. The charges alleged that he had recruited and exploited dozens of underage girls, some as young as 14, in a sex trafficking ring that operated from 2002 to 2005.\n\n**Death and Aftermath**\n\nEpstein died in his Manhattan jail cell on August 10, 2019, while awaiting trial. The cause of death was determined to be a suicide by hanging.\n\nEpstein\'s death sparked widespread outrage and conspiracy theories, with many questioning how he was able to take his own life while in custody. The incident also led to the resignation of the acting director of the Federal Bureau of Prisons and the reassignment of several correctional officers.\n\n**Investigations and Lawsuits**\n\nIn the aftermath of Epstein\'s death, several investigations and lawsuits were launched, including:\n\n1. **FBI investigation**: The FBI launched an investigation into Epstein\'s death and the circumstances surrounding it.\n2. **Congressional investigation**: The House Judiciary Committee launched an investigation into the Department of Justice\'s handling of Epstein\'s case.\n3. **Lawsuits**: Several lawsuits were filed against Epstein\'s estate, including one by a group of women who alleged that they were victims of his sex trafficking ring.\n\n**Legacy and Impact**\n\nJeffrey Epstein\'s legacy is marked by controversy, scandal, and tragedy. His actions have had a profound impact on the lives of his victims, their families, and the wider community. The case has also raised important questions about power, privilege, and accountability, and has sparked a national conversation about sex trafficking, abuse, and exploitation.', '2026-04-23 05:39:07', NULL),
(171, 1, '99750ce7b2358a19a34ad752adb7e927', 'user', 'how does this work', '2026-04-23 05:52:47', NULL),
(172, 1, '99750ce7b2358a19a34ad752adb7e927', 'assistant', '**Omni Bite Center Animal Bite Management System Medical Staff User Manual**\n\nThis document appears to be a user manual for medical staff using the Omni Bite Center system, which manages the entire lifecycle of animal bite patients, from registration to vaccination. The manual provides a comprehensive guide on how to use the system, including logging in, viewing the daily queue, administering doses, searching for patients, and viewing patient history records.\n\n**Key Features of the System**\n\n1. **Daily Queue**: The daily queue is the main work screen for medical staff, displaying all patients registered for vaccination on a given day.\n2. **Patient Search**: Medical staff can search for patients by name, case number, or partial name.\n3. **Patient History Records**: Each patient has a complete treatment history, showing every dose administered, who administered it, and when.\n4. **Vaccine Stock Monitoring**: Medical staff can view the current inventory of vaccines, including the brand name, stock remaining, and expiry date.\n5. **Administering a Dose**: Medical staff can administer a dose to a patient, filling in the dose details, such as vaccine brand, batch number, route, and site of injection.\n\n**How the System Works**\n\n1. **Registration**: Patients are registered by the Clerk, and their information is entered into the system.\n2. **Daily Queue**: The system automatically generates a daily queue of patients scheduled for vaccination.\n3. **Administering a Dose**: Medical staff verify the patient\'s identity, find the patient in the queue, and fill in the dose details.\n4. **Recording the Outcome**: The system records the outcome of the vaccination, including the dose administered, who administered it, and when.\n5. **Vaccine Stock Monitoring**: The system tracks the current inventory of vaccines, alerting medical staff to report if the stock falls below the minimum required.\n\n**Benefits of the System**\n\n1. **Improved Efficiency**: The system streamlines the vaccination process, reducing paperwork and minimizing errors.\n2. **Enhanced Patient Care**: The system ensures that patients receive the correct vaccine dose, at the right time, and with proper documentation.\n3. **Better Vaccine Management**: The system tracks vaccine inventory, reducing waste and ensuring that vaccines are used before they expire.\n4. **Increased Transparency**: The system provides a complete treatment history for each patient, enabling medical staff to make informed decisions about patient care.\n\nOverall, the Omni Bite Center system appears to be a comprehensive and user-friendly platform for managing animal bite patients, from registration to vaccination. The system\'s features and functionality are designed to improve efficiency, patient care, and vaccine management, while also providing transparency and accountability.', '2026-04-23 05:52:47', NULL),
(173, 7, 'dbaa8e381d9ea88ba824b60e25b91cad', 'user', 'Summarize my notes', '2026-04-23 23:25:53', NULL),
(174, 7, 'dbaa8e381d9ea88ba824b60e25b91cad', 'assistant', 'I don\'t see any notes attached. As your study companion, I\'d be happy to help you summarize your notes, but I need you to share them with me first. Please share your notes, and I\'ll do my best to:\n\n* Break down key points\n* Identify **main concepts**\n* Create a concise summary using bullet points\n\nLet\'s get started, Eunica!', '2026-04-23 23:25:53', NULL),
(175, 1, 'cb1e743cdfa1e0e1a995e545d5b3af25', 'user', 'Hey', '2026-04-27 03:30:01', NULL),
(176, 1, 'cb1e743cdfa1e0e1a995e545d5b3af25', 'assistant', 'Hello Kyne. How\'s your study going for BSIT 4 at PLT? Do you have any specific topics or subjects you\'d like to focus on or need help with? I\'m here to assist you. \n\nSome areas we could explore together include:\n* **Programming languages**\n* **Data structures**\n* **Computer networks**\n* **Database systems**\n\nLet me know how I can help you achieve your academic goals.', '2026-04-27 03:30:01', NULL),
(177, 8, '5b010bca878fc641d752f7755816dd31', 'user', 'What is Hospitality Management', '2026-04-27 04:32:58', NULL),
(178, 8, '5b010bca878fc641d752f7755816dd31', 'assistant', '**Hospitality Management** is a fascinating field that focuses on the management of hotels, restaurants, and other establishments that provide services to customers. It involves overseeing the daily operations of these businesses, ensuring that customers have a positive experience, and driving revenue growth.\n\nHere are some key aspects of Hospitality Management:\n* **Front Office Management**: managing the reception, concierge, and other customer-facing areas of a hotel or establishment\n* **Food and Beverage Management**: overseeing the production and service of food and drinks in restaurants, bars, and other establishments\n* **Housekeeping and Maintenance**: ensuring the cleanliness and maintenance of facilities, rooms, and public areas\n* **Marketing and Sales**: promoting the establishment and attracting new customers\n* **Human Resource Management**: managing the staff, including recruitment, training, and employee relations\n\nAs a BSIT student at PLT, you may not be directly studying Hospitality Management, but understanding the principles of **customer service**, **operations management**, and **marketing** can still be beneficial in your future career. Who knows, you might even develop a system or application that can be used in the hospitality industry.\n\nWould you like to know more about the applications of IT in Hospitality Management?', '2026-04-27 04:32:58', NULL),
(179, 3, '4154b3a7a527f9377088028a05a63d0a', 'user', 'WHO ARE YU', '2026-04-27 04:48:52', NULL),
(180, 3, '4154b3a7a527f9377088028a05a63d0a', 'assistant', 'Hello. I\'m **Astro**, your friendly AI study companion inside SPACE (Student Productivity App & Companion Experience). I\'m here to help you with your studies, answer questions, and provide guidance on various subjects.\n\nTo get started, let\'s break down what I can do for you:\n* Assist with homework and assignments\n* Provide explanations on **key concepts** and **difficult topics**\n* Offer study tips and strategies for **effective learning**\n* Help you stay organized and focused on your goals\n\nWhat subject or topic would you like to explore today?', '2026-04-27 04:48:52', NULL),
(181, 8, '5b010bca878fc641d752f7755816dd31', 'user', 'Summarize my notes', '2026-04-27 04:52:52', NULL),
(182, 8, '5b010bca878fc641d752f7755816dd31', 'assistant', 'You haven\'t shared any notes with me yet. This is the beginning of our conversation, and we\'ve only discussed the topic of **Hospitality Management** so far. If you\'d like to share your notes, I\'d be happy to help you summarize them. Please go ahead and share, and I\'ll do my best to assist you.', '2026-04-27 04:52:52', NULL);

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

--
-- Table structure for table `ai_chat_sessions`
--

CREATE TABLE `ai_chat_sessions` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `session_id` varchar(64) NOT NULL,
  `title` varchar(120) DEFAULT 'New Conversation',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ai_chat_sessions`
--

INSERT INTO `ai_chat_sessions` (`id`, `user_id`, `session_id`, `title`, `created_at`, `updated_at`) VALUES
(1, 2, '4ff9a71f83bd1c99af63c599511c529e', 'Homework Assistance Needed Now', '2026-04-15 03:48:16', '2026-04-15 04:13:07'),
(2, 2, '2rfkdbfrw4g', 'Life of Ferdinand Marcos', '2026-04-15 04:17:54', '2026-04-15 10:27:52'),
(3, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'Summarize my class notes', '2026-04-15 05:42:24', '2026-04-15 06:17:06'),
(4, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'PATHFIT Swimming Lesson Creation Guide', '2026-04-16 03:14:58', '2026-04-16 03:17:43'),
(5, 1, '10f3ca21df69e389e4c5c36a97bb8333', 'Who is Jomar Consorte', '2026-04-16 08:59:05', '2026-04-16 08:59:05'),
(6, 1, 'ij0b78tvccl', 'Introduction to Artificial Intelligence Basics', '2026-04-16 09:00:04', '2026-04-16 09:00:53'),
(7, 2, '11140d0f31fdfde4e215177d2a5beb3c', 'Regular System Maintenance Checks', '2026-04-16 14:23:28', '2026-04-16 14:41:26'),
(8, 1, '59f06ec91845162fac7dc55726fc04ce', 'Simple Greeting Conversation Start', '2026-04-16 14:40:57', '2026-04-16 14:40:57'),
(9, 1, '7e0516378234bf116067d31192d630f0', 'Discovering My Personal Identity Insights', '2026-04-16 14:49:39', '2026-04-16 14:49:39'),
(10, 3, '1d1f57c16db9566ce339f177b761b198', 'Simple Greeting Conversation Start', '2026-04-17 01:16:44', '2026-04-17 01:17:02'),
(11, 3, 'b0a57b8273ba5f29e487b2321bfece5f', 'AI Seminar Workshop Script Creation', '2026-04-17 06:33:09', '2026-04-17 06:33:09'),
(12, 1, '6bd60efc60acc27e7e61ff8ed895e69b', 'Harry Potter Book Series Summary', '2026-04-17 07:16:08', '2026-04-17 07:16:08'),
(13, 1, 'b0a55de4b2bf7d07d6a3acc6dfca1b4e', 'Agile Methodology Design Strategy Selection', '2026-04-17 09:55:14', '2026-04-17 09:55:14'),
(14, 1, 'ecf5174016fb37bb7e11e355bd343216', 'Simple greeting conversation starter', '2026-04-17 11:19:29', '2026-04-17 11:19:29'),
(15, 1, 'd99918c01ebecc15bcdaabc9276260e0', 'Simple Hello Conversation Starter', '2026-04-18 14:10:35', '2026-04-18 14:17:33'),
(16, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'Best Smartphones in the Market', '2026-04-19 04:16:53', '2026-04-19 04:55:50'),
(17, 1, 'f763136f9b2dc94657f8635ebcc22561', 'Strong Language and Frustration Expression', '2026-04-19 08:31:43', '2026-04-20 08:59:54'),
(18, 1, 'e8b22e27ac3ddf0b143f41ee3e996b03', 'Defining a Function in Programming', '2026-04-20 01:34:57', '2026-04-20 01:34:57'),
(19, 1, 'db2102d2bd2487e2f099632c381e2760', 'Simple Greeting Conversation Start', '2026-04-20 02:08:57', '2026-04-20 02:11:31'),
(20, 1, '195d71c736304f8b5c3d0174d9fc6c2b', 'Introduction to ChatGPT Technology', '2026-04-20 08:34:57', '2026-04-20 08:35:35'),
(21, 1, '89fc4cf8a7dd1016f92170227f8b8258', 'Micro Credentials in IT Field', '2026-04-20 08:47:25', '2026-04-20 08:47:25'),
(22, 1, 'fifak07t17o', 'Who Am I Question', '2026-04-20 09:00:37', '2026-04-20 09:01:34'),
(23, 4, '6506a3a0ed1800a16aa95dc12bd286da', 'Understanding the Research Process Basics', '2026-04-22 06:50:18', '2026-04-22 06:57:07'),
(24, 5, 'd842c47b6473c1b71f2fc08572d72ad0', 'Digital File Storage Solutions', '2026-04-22 06:58:27', '2026-04-22 07:33:40'),
(25, 6, 'ee9de88a0f74eb3592bb86253d107e0a', 'Who is Abegail', '2026-04-22 06:58:41', '2026-04-22 07:00:05'),
(26, 4, '3108eaf6ec55f37d15874e4913a5fe2a', 'Identity Inquiry and Self Revelation', '2026-04-22 07:33:48', '2026-04-22 07:35:27'),
(27, 1, '2327be5c36df9338ba0a774c5a1241da', 'Event Driven Python Document Analysis', '2026-04-22 07:36:12', '2026-04-22 07:36:12'),
(28, 1, '99750ce7b2358a19a34ad752adb7e927', 'Pirated Website Request Discussion', '2026-04-23 05:29:51', '2026-04-23 05:52:47'),
(29, 7, 'dbaa8e381d9ea88ba824b60e25b91cad', 'Summarize my class notes', '2026-04-23 23:25:54', '2026-04-23 23:25:54'),
(30, 1, 'cb1e743cdfa1e0e1a995e545d5b3af25', 'Simple Greeting Conversation Start', '2026-04-27 03:30:02', '2026-04-27 03:30:02'),
(31, 8, '5b010bca878fc641d752f7755816dd31', 'Introduction to Hospitality Management Basics', '2026-04-27 04:32:59', '2026-04-27 04:52:52'),
(32, 3, '4154b3a7a527f9377088028a05a63d0a', 'Identifying Yourself', '2026-04-27 04:48:54', '2026-04-27 04:48:54');

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

--
-- Table structure for table `calendar_events`
--

CREATE TABLE `calendar_events` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `description` text DEFAULT NULL,
  `event_date` date NOT NULL,
  `event_time` time DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `color` varchar(7) DEFAULT '#0ea5e9',
  `type` enum('assignment','exam','event','reminder','holiday') DEFAULT 'event',
  `is_all_day` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `calendar_events`
--

INSERT INTO `calendar_events` (`id`, `user_id`, `title`, `description`, `event_date`, `event_time`, `end_date`, `end_time`, `color`, `type`, `is_all_day`, `created_at`) VALUES
(1, 1, 'Back to school', 'Back to school', '2026-04-20', '08:00:00', NULL, NULL, '#eab308', 'reminder', 0, '2026-04-15 01:51:36'),
(2, 1, 'system', NULL, '2026-04-15', NULL, NULL, NULL, '#22c55e', 'reminder', 0, '2026-04-15 01:52:11');

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

--
-- Table structure for table `flashcards`
--

CREATE TABLE `flashcards` (
  `id` int(10) UNSIGNED NOT NULL,
  `deck_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `order` smallint(5) UNSIGNED DEFAULT 0,
  `times_seen` int(10) UNSIGNED DEFAULT 0,
  `times_correct` int(10) UNSIGNED DEFAULT 0,
  `last_seen` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flashcards`
--

INSERT INTO `flashcards` (`id`, `deck_id`, `user_id`, `question`, `answer`, `order`, `times_seen`, `times_correct`, `last_seen`, `created_at`) VALUES
(1, 1, 2, 'Who was Ferdinand Marcos Sr. and what was his role in the Philippines?', 'Ferdinand Marcos Sr. was the 10th President of the Philippines, serving from 1965 to 1986. He implemented various economic and social reforms, but his regime was also marked by authoritarianism and human rights abuses.', 0, 0, 0, NULL, '2026-04-15 04:57:23'),
(2, 1, 2, 'What were the key factors that led to the rise of Ferdinand Marcos Sr. to power?', 'The key factors that led to Marcos\' rise to power included his charismatic leadership, his promise to bring economic development and stability, and the support of the Philippine military and the United States. His marriage to Imelda Romualdez also helped to boost his political career.', 1, 0, 0, NULL, '2026-04-15 04:57:23'),
(3, 1, 2, 'How did Ferdinand Marcos Sr.\'s economic policies affect the Philippines?', 'Marcos\' economic policies, such as import substitution and infrastructure development, initially led to rapid economic growth, but ultimately resulted in widespread poverty, corruption, and foreign debt. His regime\'s crony capitalism and favoritism towards certain businesses also led to economic inequality.', 2, 0, 0, NULL, '2026-04-15 04:57:23'),
(4, 1, 2, 'What was the impact of Ferdinand Marcos Sr.\'s authoritarian rule on Philippine society?', 'Marcos\' authoritarian rule had a profound impact on Philippine society, leading to the suppression of civil liberties, the persecution of opposition leaders and activists, and the imposition of martial law. This period was also marked by human rights abuses, including forced disappearances, torture, and extrajudicial killings.', 3, 0, 0, NULL, '2026-04-15 04:57:23'),
(5, 1, 2, 'How does the legacy of Ferdinand Marcos Sr. continue to influence Philippine politics today?', 'The legacy of Ferdinand Marcos Sr. continues to influence Philippine politics today, with his son Ferdinand Marcos Jr. winning the presidency in 2022. The Marcos family\'s return to power has raised concerns about the country\'s democratic institutions and the potential for a repeat of the human rights abuses and corruption that characterized the elder Marcos\' regime.', 4, 0, 0, NULL, '2026-04-15 04:57:23'),
(6, 2, 2, 'What is the primary cause of metamorphosis in insects, such as butterflies and moths?', 'Hormonal changes, particularly the increase in ecdysone, trigger metamorphosis in insects.', 0, 0, 0, NULL, '2026-04-15 05:40:15'),
(7, 2, 2, 'How does metamorphosis in frogs affect their respiratory system?', 'During metamorphosis, frogs transition from gills to lungs, allowing them to breathe air on land.', 1, 0, 0, NULL, '2026-04-15 05:40:15'),
(8, 2, 2, 'What is the role of apoptosis in metamorphosis?', 'Apoptosis, or programmed cell death, eliminates unnecessary cells and tissues, allowing for the formation of new structures during metamorphosis.', 2, 0, 0, NULL, '2026-04-15 05:40:15'),
(9, 2, 2, 'What is the main difference between complete and incomplete metamorphosis in insects?', 'Complete metamorphosis involves four distinct stages (egg, larva, pupa, and adult), while incomplete metamorphosis involves three stages (egg, nymph, and adult), with the nymph resembling a small adult.', 3, 0, 0, NULL, '2026-04-15 05:40:15'),
(10, 2, 2, 'How does environmental stress, such as temperature and humidity, impact the metamorphosis of certain species?', 'Environmental stress can trigger or disrupt metamorphosis, as some species rely on specific conditions to initiate or complete their transformation.', 4, 0, 0, NULL, '2026-04-15 05:40:15'),
(11, 3, 2, 'What is the main purpose of a platform in the context of digital systems?', 'To provide a foundation or environment where applications, services, and systems can be built and run, allowing developers to build systems faster without starting from zero.', 0, 0, 1, NULL, '2026-04-15 06:43:12'),
(12, 3, 2, 'What happens to a digital system if it is built on a weak platform foundation?', 'The system becomes unstable, just like a house built on a weak foundation.', 1, 0, 1, NULL, '2026-04-15 06:43:12'),
(13, 3, 2, 'What is the benefit of a platform having openness and extensibility?', 'It allows developers to expand, customize, integrate, and improve the platform by adding plugins, modules, extensions, APIs, and third-party services.', 2, 0, 1, NULL, '2026-04-15 06:43:12'),
(14, 3, 2, 'What is the consequence of a platform not being scalable?', 'It may not be able to handle increasing users, data, and traffic, leading to poor performance and potential downtime.', 3, 0, 1, NULL, '2026-04-15 06:43:12'),
(15, 3, 2, 'Why is security an important characteristic of a robust platform?', 'It protects user accounts, passwords, payments, records, transactions, and private data, which is especially important for sensitive applications such as banking apps, school portals, and health systems.', 4, 0, 0, NULL, '2026-04-15 06:43:12'),
(16, 4, 2, 'What is the main purpose of a platform in the context of digital systems?', 'To provide a foundation or environment where applications, services, and systems can be built and run, allowing developers to build systems faster without starting from zero.', 0, 0, 1, NULL, '2026-04-15 06:47:42'),
(17, 4, 2, 'What happens to a digital system if it is built on a weak platform foundation?', 'The system becomes unstable, just like a house built on weak land and foundation.', 1, 0, 1, NULL, '2026-04-15 06:47:42'),
(18, 4, 2, 'What is the benefit of a platform having openness and extensibility?', 'It allows developers to expand, customize, integrate, and improve the platform by adding plugins, modules, extensions, APIs, and third-party services.', 2, 0, 1, NULL, '2026-04-15 06:47:42'),
(19, 4, 2, 'What is the consequence of a platform not being scalable?', 'It may not be able to handle increasing users, data, and traffic, leading to poor performance and potential crashes.', 3, 0, 1, NULL, '2026-04-15 06:47:42'),
(20, 4, 2, 'Why is security an important characteristic of a robust platform?', 'It protects user accounts, passwords, payments, records, transactions, and private data, which is especially important for sensitive applications such as banking apps, school portals, and health systems.', 4, 0, 1, NULL, '2026-04-15 06:47:42'),
(21, 5, 2, 'What is the primary cause of reduced academic performance and heightened stress among students?', 'Poor time allocation and procrastination', 0, 0, 1, NULL, '2026-04-15 09:20:00'),
(22, 5, 2, 'How can the strategic use of digital tools impact student engagement and academic performance?', 'It can enhance student engagement, motivation, and academic performance', 1, 0, 0, NULL, '2026-04-15 09:20:00'),
(23, 5, 2, 'What is the effect of combining time management strategies with Artificial Intelligence on student productivity?', 'It can further boost efficiency', 2, 0, 0, NULL, '2026-04-15 09:20:00'),
(24, 5, 2, 'What role does the visual design of digital tools play in sustaining student focus?', 'It helps prevent digital fatigue and reduces extraneous cognitive load', 3, 0, 0, NULL, '2026-04-15 09:20:00'),
(25, 5, 2, 'What is the expected outcome of using a centralized academic productivity system like SPACE on student productivity?', 'It is expected to enhance academic performance and productivity', 4, 0, 0, NULL, '2026-04-15 09:20:00'),
(26, 6, 2, 'What is the ranking of the tourism industry as an export sector worldwide, according to the World Tourism Organization in 2017?', 'The tourism industry ranks as the third largest export sector worldwide, after fuels and chemicals.', 0, 1, 1, '2026-04-15 09:39:32', '2026-04-15 09:33:36'),
(27, 6, 2, 'How has globalization and technological advancement impacted competition among tourist destinations?', 'Globalization and technological advancement have intensified competition among destinations, with countries now competing on service quality, innovation, sustainability, and overall visitor experience.', 1, 1, 1, '2026-04-15 09:39:40', '2026-04-15 09:33:36'),
(28, 6, 2, 'What is the concept of destination competitiveness in the context of tourism, and what does it entail?', 'Destination competitiveness refers to a place\'s capacity to attract and satisfy visitors while maintaining its environmental, social, and economic sustainability for future generations.', 2, 1, 0, '2026-04-15 09:39:43', '2026-04-15 09:33:36'),
(29, 6, 2, 'Who are some of the key researchers that have contributed to the study of competitiveness in the tourism sector?', 'Michael Porter, Smith, Go, Govers, Gooroochurn, Sugiyarto, and Mazanec are some of the key researchers that have contributed to the study of competitiveness in the tourism sector.', 3, 1, 0, '2026-04-15 09:39:46', '2026-04-15 09:33:36'),
(30, 6, 2, 'What are some of the negative environmental impacts of unmanaged tourism activities, and how can they be mitigated?', 'Unmanaged tourism activities such as transportation, accommodation development, and visitor congestion can negatively affect fragile ecosystems, and can be mitigated through sustainable tourism practices.', 4, 1, 1, '2026-04-15 09:39:48', '2026-04-15 09:33:36'),
(31, 6, 2, 'What is the significance of competitiveness in determining a destination\'s long-term survival and prosperity in the tourism industry?', 'Competitiveness is widely regarded as essential for a destination\'s success and long-term prosperity, with studies confirming that it determines a destination\'s long-term survival and prosperity.', 5, 1, 1, '2026-04-15 09:39:49', '2026-04-15 09:33:36'),
(32, 6, 2, 'How does the World Tourism Organization\'s ranking of the tourism industry as an export sector relate to its economic contributions?', 'The tourism industry\'s ranking as the third largest export sector worldwide highlights its significant economic contributions, including serving as a primary source of foreign exchange for many developing nations.', 6, 1, 0, '2026-04-15 09:39:51', '2026-04-15 09:33:36'),
(33, 6, 2, 'What is the role of service quality, innovation, and sustainability in enhancing a destination\'s competitiveness in the tourism industry?', 'Service quality, innovation, and sustainability are key factors that can enhance a destination\'s competitiveness, as they contribute to a positive visitor experience and differentiate a destination from its competitors.', 7, 1, 1, '2026-04-15 09:39:54', '2026-04-15 09:33:36'),
(34, 6, 2, 'What are some of the challenges and limitations of using AI detection tools, such as Turnitin, to identify potential academic misconduct in student submissions?', 'AI detection tools, such as Turnitin, may not always be accurate and can produce false positives, highlighting the need for human judgment and scrutiny in conjunction with an organization\'s academic policies to determine whether academic misconduct has occurred.', 8, 1, 0, '2026-04-15 09:39:55', '2026-04-15 09:33:36'),
(35, 6, 2, 'How can educators effectively interpret and utilize the results of AI detection tools, such as Turnitin, in evaluating student submissions?', 'Educators should use the AI detection percentage as a means to start a formative conversation with their student and examine the submitted assignment in accordance with their school\'s policies, rather than relying solely on the percentage to determine whether misconduct has occurred.', 9, 1, 1, '2026-04-15 09:39:57', '2026-04-15 09:33:36'),
(36, 7, 2, 'What is the primary function of a platform in the context of platform technologies, and what analogy can be used to describe it?', 'The primary function of a platform is to provide a foundation or environment where applications, services, and systems are built and run, and it can be described using the analogy of a house, where the platform is the land and foundation, and the application is the house built on top.', 0, 2, 2, '2026-04-15 09:48:00', '2026-04-15 09:45:14'),
(37, 7, 2, 'What are the core concepts of platforms, and what are some examples of different types of platforms?', 'The core concepts of platforms include providing a stable digital environment where systems interact, and offering reusable tools to make development easier, with examples including operating systems, cloud platforms, web platforms, and AI platforms.', 1, 2, 2, '2026-04-15 09:48:02', '2026-04-15 09:45:14'),
(38, 7, 2, 'What are the characteristics of a robust platform, and why are they important?', 'The characteristics of a robust platform include openness and extensibility, scalability, security, interoperability, reliability and availability, developer tools and APIs, data management and analytics, cost effectiveness, community support, and compliance and governance, which are important because they ensure the platform can support a wide range of applications and services, and provide a stable and secure environment for users.', 2, 2, 1, '2026-04-15 09:48:04', '2026-04-15 09:45:14'),
(39, 7, 2, 'How does scalability contribute to the overall performance of a platform, and what are the two types of scaling?', 'Scalability contributes to the overall performance of a platform by allowing it to handle increasing users, data, and traffic, and the two types of scaling are vertical scaling, which involves increasing the power of a single server, and horizontal scaling, which involves adding more servers to distribute the load.', 3, 1, 0, '2026-04-15 09:48:05', '2026-04-15 09:45:14'),
(40, 7, 2, 'What is the importance of security in a platform, and what are some examples of security measures?', 'Security is important in a platform because it protects user accounts, passwords, payments, records, transactions, and private data, and some examples of security measures include login authentication, role-based access, encryption, firewalls, and OTP verification.', 4, 1, 1, '2026-04-15 09:48:07', '2026-04-15 09:45:14'),
(41, 7, 2, 'What is interoperability, and how is it achieved in a platform?', 'Interoperability refers to the ability of different systems to communicate smoothly, and it is achieved in a platform through the use of APIs, which enable different systems to exchange data and interact with each other.', 5, 1, 1, '2026-04-15 09:48:09', '2026-04-15 09:45:14'),
(42, 7, 2, 'What are the different types of platforms, and what are their functions?', 'The different types of platforms include operating system platforms, database platforms, mobile platforms, cloud computing platforms, IoT platforms, blockchain platforms, and security platforms, each with their own specific functions, such as controlling hardware and software resources, storing and managing data, or providing secure transactions.', 6, 1, 1, '2026-04-15 09:48:10', '2026-04-15 09:45:15'),
(43, 7, 2, 'What are the specific platform categories by use case, and what are some examples of each?', 'The specific platform categories by use case include social media and networking platforms, service and marketplace platforms, content sharing and media platforms, communication and collaboration platforms, knowledge and educational platforms, transactional and financial platforms, generative AI platforms, and ERP platforms, with examples including Facebook, Uber, YouTube, WhatsApp, Wikipedia, and ChatGPT.', 7, 1, 1, '2026-04-15 09:48:12', '2026-04-15 09:45:15'),
(44, 7, 2, 'What are the technical components of web platforms, and how do they contribute to the overall functionality of a platform?', 'The technical components of web platforms include front-end technologies such as HTML, CSS, and JavaScript, and back-end technologies such as PHP, Node.js, Python, and Java, which contribute to the overall functionality of a platform by enabling the creation of user interfaces, handling user input, and interacting with databases and servers.', 8, 1, 1, '2026-04-15 09:48:13', '2026-04-15 09:45:15'),
(45, 7, 2, 'What is the role of APIs in platform development, and why are they important?', 'APIs play a crucial role in platform development by defining how systems talk to each other, and enabling the integration of different services and applications, and they are important because they allow developers to build new applications and services on top of existing platforms, and enable the creation of complex systems and ecosystems.', 9, 1, 1, '2026-04-15 09:48:15', '2026-04-15 09:45:15'),
(46, 8, 1, 'What was the primary artistic influence on Michelangelo\'s work, and how did it shape his style?', 'Michelangelo\'s work was primarily influenced by classical Greek and Roman art, which is evident in his use of naturalism, realism, and humanism, shaping his style into a unique blend of technical skill and emotional depth.', 0, 3, 3, '2026-04-23 05:49:26', '2026-04-16 03:09:00'),
(47, 8, 1, 'Compare and contrast Michelangelo\'s \'David\' with Donatello\'s \'David\' in terms of artistic style and historical context.', 'Michelangelo\'s \'David\' is characterized by its idealized proportions and dynamic contrapposto stance, whereas Donatello\'s \'David\' is more naturalistic and relaxed; this reflects the different artistic styles of the High Renaissance and the Early Renaissance, respectively.', 1, 2, 2, '2026-04-23 05:49:32', '2026-04-16 03:09:00'),
(48, 8, 1, 'How did Michelangelo\'s artistic philosophy, as expressed in his poetry, inform his approach to sculpture and painting?', 'Michelangelo\'s artistic philosophy, as expressed in his poetry, emphasized the importance of capturing the inner essence and emotional depth of his subjects, which is reflected in his sculptures and paintings that often convey a sense of intense emotional power and psychological complexity.', 2, 2, 0, '2026-04-23 05:49:37', '2026-04-16 03:09:00'),
(49, 8, 1, 'What role did patronage play in Michelangelo\'s career, and how did it impact his artistic output?', 'Patronage played a significant role in Michelangelo\'s career, with powerful patrons like the Medici family and the Pope influencing his artistic output and often dictating the subject matter and style of his work; this led to both opportunities and constraints for the artist.', 3, 1, 1, '2026-04-16 03:09:40', '2026-04-16 03:09:00'),
(50, 8, 1, 'Analyze the use of non-finito in Michelangelo\'s sculptures, such as \'The Prisoners\', and its effect on the viewer\'s experience.', 'Michelangelo\'s use of non-finito, or unfinished, technique in sculptures like \'The Prisoners\' creates a sense of dynamic energy and tension, as if the figures are emerging from the marble itself; this technique engages the viewer\'s imagination and draws them into the creative process.', 4, 1, 0, '2026-04-16 03:09:41', '2026-04-16 03:09:00'),
(51, 8, 1, 'How did Michelangelo\'s work on the Sistine Chapel ceiling reflect his artistic and theological vision, and what innovations did it introduce to the field of art?', 'Michelangelo\'s work on the Sistine Chapel ceiling reflected his artistic and theological vision by depicting a vast and complex narrative of biblical scenes, introducing innovations like the use of vivid colors, anatomical accuracy, and dramatic composition, which raised the bar for artistic excellence and influenced generations of artists.', 5, 1, 1, '2026-04-16 03:09:43', '2026-04-16 03:09:00'),
(52, 8, 1, 'What is the significance of Michelangelo\'s \'The Entombment\' in relation to his development as a painter, and how does it demonstrate his unique artistic style?', 'Michelangelo\'s \'The Entombment\' is significant as it showcases his early experimentation with painting and his unique style, characterized by intense emotional power, complex composition, and innovative use of color and light, demonstrating his ability to merge sculpture and painting techniques to create a distinctive artistic voice.', 6, 1, 1, '2026-04-16 03:09:45', '2026-04-16 03:09:00'),
(53, 9, 1, 'What is the primary purpose of PATHFIT 4 Swimming, and how does it differ from traditional swimming programs?', 'The primary purpose of PATHFIT 4 Swimming is to provide a personalized and adaptive swimming training program, differing from traditional programs by incorporating artificial intelligence and real-time data analysis to optimize performance and injury prevention.', 0, 2, 2, '2026-04-16 03:11:47', '2026-04-16 03:10:45'),
(54, 9, 1, 'Compare and contrast the biomechanical analysis used in PATHFIT 4 Swimming with traditional video analysis methods.', 'PATHFIT 4 Swimming utilizes advanced biomechanical analysis, incorporating sensors and AI-powered algorithms to provide detailed and accurate assessments, whereas traditional video analysis methods rely on manual observation and may be more prone to human error.', 1, 2, 2, '2026-04-16 03:12:12', '2026-04-16 03:10:45'),
(55, 9, 1, 'How does PATHFIT 4 Swimming apply the principles of motor learning theory to improve swimming technique?', 'PATHFIT 4 Swimming applies motor learning theory by providing swimmers with real-time feedback, allowing for immediate correction and reinforcement of proper technique, and incorporating variable practice and contextual interference to enhance skill acquisition and retention.', 2, 0, 0, NULL, '2026-04-16 03:10:45'),
(56, 9, 1, 'What is an example of how PATHFIT 4 Swimming can be used to address a common swimming injury, such as shoulder impingement?', 'PATHFIT 4 Swimming can be used to address shoulder impingement by analyzing a swimmer\'s stroke mechanics and providing personalized feedback on adjustments to reduce shoulder stress, such as modifying hand entry and exit points or adjusting body rotation.', 3, 0, 0, NULL, '2026-04-16 03:10:45'),
(57, 9, 1, 'Describe the role of data analytics in PATHFIT 4 Swimming, and how it informs coaching decisions.', 'Data analytics plays a crucial role in PATHFIT 4 Swimming, providing coaches with detailed insights into swimmer performance, technique, and progress, enabling informed decisions on training programs, drill selection, and competition strategy.', 4, 0, 0, NULL, '2026-04-16 03:10:45'),
(58, 9, 1, 'How does PATHFIT 4 Swimming integrate with other sports science disciplines, such as sports physiology and psychology?', 'PATHFIT 4 Swimming integrates with sports physiology by incorporating physiological data, such as heart rate and lactate thresholds, to optimize training intensity and volume, and with sports psychology by providing swimmers with mental preparation tools and strategies to enhance performance and resilience.', 5, 0, 0, NULL, '2026-04-16 03:10:45'),
(59, 9, 1, 'What are the potential applications of PATHFIT 4 Swimming beyond the realm of competitive swimming, such as in rehabilitation or fitness settings?', 'PATHFIT 4 Swimming has potential applications in rehabilitation settings, such as post-injury or post-surgical recovery, and in fitness settings, such as masters swimming or aquatic therapy programs, by providing personalized and adaptive exercise programs to improve overall health and wellness.', 6, 0, 0, NULL, '2026-04-16 03:10:45'),
(60, 10, 1, 'What is the primary function of the mitochondrial inner membrane in cellular respiration, and how does it relate to the proton gradient?', 'The primary function of the mitochondrial inner membrane is to generate a proton gradient through the process of oxidative phosphorylation, where electrons are passed through a series of electron transport chains, pumping protons across the membrane and creating a concentration gradient that drives ATP synthesis. This gradient is crucial for the production of ATP. The inner membrane\'s unique structure, with its infoldings and cristae, increases its surface area to enhance this process.', 0, 1, 1, '2026-04-23 05:50:17', '2026-04-23 05:49:56'),
(61, 10, 1, 'Compare and contrast the mitochondrial genomes of animals and plants, including their size, gene content, and replication mechanisms.', 'The mitochondrial genomes of animals and plants differ significantly in size, gene content, and replication mechanisms. Animal mitochondrial genomes are typically small, ranging from 15-20 kb, and contain 37 genes, whereas plant mitochondrial genomes are larger, ranging from 200-2500 kb, and contain more genes. Plant mitochondrial genomes also exhibit more complex replication mechanisms, including recombination and RNA editing.', 1, 0, 0, NULL, '2026-04-23 05:49:56'),
(62, 10, 1, 'How do mitochondrial dynamics, including fusion and fission, contribute to the regulation of mitochondrial function and cellular homeostasis?', 'Mitochondrial dynamics, including fusion and fission, play a crucial role in regulating mitochondrial function and cellular homeostasis by allowing mitochondria to adapt to changing cellular conditions. Fusion helps to maintain mitochondrial function by combining the contents of damaged mitochondria, while fission allows for the removal of damaged or dysfunctional mitochondria through mitophagy. This process helps to maintain mitochondrial quality and prevent the accumulation of damaged mitochondria.', 2, 0, 0, NULL, '2026-04-23 05:49:56'),
(63, 10, 1, 'What is the role of mitochondrial reactive oxygen species (ROS) in cellular signaling and disease pathogenesis, and how do antioxidants and other mechanisms regulate ROS levels?', 'Mitochondrial reactive oxygen species (ROS) play a complex role in cellular signaling and disease pathogenesis, as they can act as signaling molecules to regulate various cellular processes, but also contribute to oxidative stress and damage. Antioxidants, such as glutathione and superoxide dismutase, help to regulate ROS levels by neutralizing or scavenging ROS, while other mechanisms, including mitochondrial dynamics and biogenesis, also contribute to ROS regulation. Dysregulation of ROS levels has been implicated in various diseases, including neurodegenerative disorders and cancer.', 3, 0, 0, NULL, '2026-04-23 05:49:56'),
(64, 10, 1, 'How do mitochondrial-nuclear interactions, including retrograde signaling and anterograde signaling, regulate mitochondrial function and biogenesis in response to cellular demands?', 'Mitochondrial-nuclear interactions, including retrograde signaling and anterograde signaling, play a crucial role in regulating mitochondrial function and biogenesis in response to cellular demands. Retrograde signaling involves the communication of mitochondrial stress or dysfunction to the nucleus, which triggers changes in gene expression to regulate mitochondrial biogenesis and function. Anterograde signaling, on the other hand, involves the regulation of mitochondrial biogenesis and function by nuclear-encoded genes, allowing the nucleus to control mitochondrial activity in response to changing cellular conditions.', 4, 0, 0, NULL, '2026-04-23 05:49:56'),
(65, 11, 8, 'What is the primary purpose of research in various fields of study?', 'The primary purpose of research is to discover new knowledge, validate existing knowledge, and solve problems. It aims to answer questions, test hypotheses, and provide insights that can inform decision-making and drive innovation.', 0, 1, 1, '2026-04-27 04:47:58', '2026-04-27 04:47:41'),
(66, 11, 8, 'Compare and contrast qualitative and quantitative research methods.', 'Qualitative research focuses on non-numerical data, such as text, images, and observations, to gain an in-depth understanding of a phenomenon. In contrast, quantitative research relies on numerical data and statistical analysis to identify patterns and trends.', 1, 0, 0, NULL, '2026-04-27 04:47:41'),
(67, 11, 8, 'Provide an example of how research can be applied in a real-world setting.', 'In the field of medicine, research on the causes and effects of diseases can lead to the development of new treatments and therapies. For instance, research on the relationship between diet and heart disease can inform public health campaigns and guide the creation of personalized nutrition plans.', 2, 0, 0, NULL, '2026-04-27 04:47:41'),
(68, 11, 8, 'What is the difference between exploratory and confirmatory research?', 'Exploratory research aims to explore a new topic or phenomenon, often without a preconceived hypothesis, to gain a deeper understanding of the issue. Confirmatory research, on the other hand, seeks to test a specific hypothesis or theory, often using quantitative methods to validate or refute existing knowledge.', 3, 0, 0, NULL, '2026-04-27 04:47:41'),
(69, 11, 8, 'How can research inform evidence-based decision-making in organizations?', 'Research can provide organizations with reliable data and insights to inform strategic decisions, such as market trends, customer needs, and operational efficiency. By analyzing research findings, organizations can develop evidence-based policies and interventions that drive business outcomes and improve performance.', 4, 0, 0, NULL, '2026-04-27 04:47:41');

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

--
-- Table structure for table `flashcard_decks`
--

CREATE TABLE `flashcard_decks` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `description` text DEFAULT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `difficulty` enum('easy','medium','hard') DEFAULT 'medium',
  `card_count` int(10) UNSIGNED DEFAULT 0,
  `source` enum('ai','document','manual') DEFAULT 'ai',
  `source_filename` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flashcard_decks`
--

INSERT INTO `flashcard_decks` (`id`, `user_id`, `title`, `description`, `subject`, `difficulty`, `card_count`, `source`, `source_filename`, `created_at`) VALUES
(1, 2, 'Topic: ferdinand marcos sr.', NULL, 'ferdinand marcos sr.', 'medium', 5, 'ai', NULL, '2026-04-15 04:57:23'),
(2, 2, 'Topic: methamorphosis', NULL, 'methamorphosis', 'medium', 5, 'ai', NULL, '2026-04-15 05:40:15'),
(3, 2, 'Doc: platform.docx', NULL, 'platform.docx', 'medium', 5, 'document', 'platform.docx', '2026-04-15 06:43:12'),
(4, 2, 'Doc: platform.docx', NULL, 'platform.docx', 'medium', 5, 'document', 'platform.docx', '2026-04-15 06:47:42'),
(5, 2, 'Doc: INTRODUCTIONv3.docx', NULL, 'INTRODUCTIONv3.docx', 'medium', 5, 'document', 'INTRODUCTIONv3.docx', '2026-04-15 09:20:00'),
(6, 2, 'From: AI_SUMLANG.docx', NULL, 'AI_SUMLANG.docx', 'hard', 10, 'document', 'AI_SUMLANG.docx', '2026-04-15 09:33:36'),
(7, 2, 'From: platform.docx', NULL, 'platform.docx', 'hard', 10, 'document', 'platform.docx', '2026-04-15 09:45:14'),
(8, 1, 'Topic: Michaelangelo', NULL, 'Michaelangelo', 'hard', 7, 'ai', NULL, '2026-04-16 03:09:00'),
(9, 1, 'Topic: PATHFIT 4 SWIMMING', NULL, 'PATHFIT 4 SWIMMING', 'hard', 7, 'ai', NULL, '2026-04-16 03:10:45'),
(10, 1, 'Topic: mitocondria', NULL, 'mitocondria', 'hard', 5, 'ai', NULL, '2026-04-23 05:49:56'),
(11, 8, 'Topic: Research', NULL, 'Research', 'medium', 5, 'ai', NULL, '2026-04-27 04:47:41');

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `content` mediumtext DEFAULT NULL,
  `color` varchar(7) DEFAULT '#3b82f6',
  `note_type` enum('text','voice','draw') DEFAULT 'text',
  `draw_data` longtext DEFAULT NULL,
  `audio_data` longtext DEFAULT NULL,
  `is_pinned` tinyint(1) DEFAULT 0,
  `is_archived` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notes`
--

INSERT INTO `notes` (`id`, `user_id`, `title`, `content`, `color`, `note_type`, `draw_data`, `audio_data`, `is_pinned`, `is_archived`, `created_at`, `updated_at`) VALUES
(1, 1, '76', 't66', '#22c55e', 'text', NULL, NULL, 1, 0, '2026-04-14 15:27:15', '2026-04-14 15:27:15'),
(2, 1, 'Hehs', 'Bdhsn', '#0ea5e9', 'text', NULL, NULL, 0, 0, '2026-04-27 03:35:08', '2026-04-27 03:35:08');

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

--
-- Table structure for table `pomodoro_sessions`
--

CREATE TABLE `pomodoro_sessions` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `task_id` int(10) UNSIGNED DEFAULT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `work_minutes` int(10) UNSIGNED DEFAULT 25,
  `break_minutes` int(10) UNSIGNED DEFAULT 5,
  `cycles_completed` int(10) UNSIGNED DEFAULT 0,
  `total_focus_minutes` int(10) UNSIGNED DEFAULT 0,
  `started_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `ended_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pomodoro_sessions`
--

INSERT INTO `pomodoro_sessions` (`id`, `user_id`, `task_id`, `subject`, `work_minutes`, `break_minutes`, `cycles_completed`, `total_focus_minutes`, `started_at`, `ended_at`) VALUES
(1, 1, NULL, NULL, 25, 5, 1, 25, '2026-04-17 11:20:46', '2026-04-17 11:20:46'),
(2, 1, NULL, NULL, 25, 5, 2, 25, '2026-04-17 11:21:36', '2026-04-17 11:21:36'),
(3, 1, NULL, NULL, 25, 5, 1, 25, '2026-04-20 02:26:03', '2026-04-20 02:26:03'),
(4, 1, NULL, NULL, 25, 5, 1, 25, '2026-04-20 08:58:27', '2026-04-20 08:58:27'),
(5, 1, NULL, NULL, 25, 5, 1, 25, '2026-04-23 05:43:35', '2026-04-23 05:43:35');

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

--
-- Table structure for table `quiz_answers`
--

CREATE TABLE `quiz_answers` (
  `id` int(10) UNSIGNED NOT NULL,
  `attempt_id` int(10) UNSIGNED NOT NULL,
  `question_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `user_answer` text DEFAULT NULL,
  `is_correct` tinyint(1) DEFAULT 0,
  `time_taken` int(10) UNSIGNED DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quiz_answers`
--

INSERT INTO `quiz_answers` (`id`, `attempt_id`, `question_id`, `user_id`, `user_answer`, `is_correct`, `time_taken`, `created_at`) VALUES
(1, 14, 1, 3, 'Mark Kian Oliquiano', 1, 8, '2026-04-19 06:22:34'),
(2, 14, 2, 3, 'Benjo Corido', 0, 6, '2026-04-19 06:22:47'),
(3, 14, 3, 3, 'Jose Luis Pena', 0, 11, '2026-04-19 06:23:05'),
(4, 14, 4, 3, 'Both had Kurt Cuya and Benjo Corido', 1, 14, '2026-04-19 06:23:27'),
(5, 14, 5, 3, 'Jose Luis Pena', 1, 6, '2026-04-19 06:23:36'),
(6, 16, 6, 3, 'To minimize costs', 0, 24, '2026-04-19 06:24:42'),
(7, 16, 7, 3, 'Single seller and multiple buyers', 1, 15, '2026-04-19 06:25:05'),
(8, 16, 8, 3, 'The quantity supplied decreases', 0, 33, '2026-04-19 06:25:40'),
(9, 16, 9, 3, 'Comparative advantage', 0, 11, '2026-04-19 06:25:55'),
(10, 16, 10, 3, 'A normal good has a positive income effect, while an inferior good has a negative income effect', 1, 10, '2026-04-19 06:26:07'),
(11, 18, 8, 3, NULL, 0, 58, '2026-04-19 06:46:39'),
(12, 20, 6, 3, NULL, 0, 30, '2026-04-19 06:50:23'),
(13, 22, 6, 3, 'To maximize profits', 1, 1, '2026-04-19 06:53:07'),
(14, 23, 6, 3, 'To maximize profits', 1, 6, '2026-04-19 07:00:41'),
(15, 24, 46, 1, 'To manage the flow of data between the CPU, RAM, and graphics card', 1, 15, '2026-04-19 07:20:12'),
(16, 24, 47, 1, 'True', 1, 13, '2026-04-19 07:20:29'),
(17, 24, 48, 1, 'read', 0, 18, '2026-04-19 07:20:50'),
(18, 24, 49, 1, 'not sure', 0, 12, '2026-04-19 07:21:09'),
(19, 25, 46, 1, 'To manage the flow of data between the CPU, RAM, and graphics card', 1, 3, '2026-04-19 07:21:52'),
(20, 25, 47, 1, 'True', 1, 3, '2026-04-19 07:21:56'),
(21, 25, 48, 1, 'LATENCY', 1, 9, '2026-04-19 07:22:06'),
(22, 25, 49, 1, NULL, 0, 4, '2026-04-19 07:22:14'),
(23, 25, 51, 1, 'False', 1, 9, '2026-04-19 07:22:36'),
(24, 25, 52, 1, NULL, 0, 51, '2026-04-19 07:24:10'),
(25, 25, 53, 1, NULL, 0, 11, '2026-04-19 07:24:30'),
(26, 25, 54, 1, 'To provide a user interface for the operating system', 0, 5, '2026-04-19 07:24:37'),
(27, 25, 55, 1, 'False', 1, 4, '2026-04-19 07:24:45'),
(28, 26, 46, 1, 'To manage the flow of data between the CPU, RAM, and graphics card', 1, 3, '2026-04-19 07:24:54'),
(29, 26, 47, 1, 'True', 1, 3, '2026-04-19 07:24:59'),
(30, 26, 48, 1, 'LANTENC', 1, 11, '2026-04-19 07:25:11'),
(31, 26, 49, 1, NULL, 0, 11, '2026-04-19 07:25:28'),
(32, 26, 51, 1, 'False', 1, 2, '2026-04-19 07:25:44'),
(33, 26, 52, 1, 'Multi-GPU computing', 0, 35, '2026-04-19 07:26:21'),
(34, 26, 53, 1, NULL, 0, 2, '2026-04-19 07:26:59'),
(35, 26, 54, 1, 'To configure the hardware settings for the system', 1, 4, '2026-04-19 07:27:06'),
(36, 26, 55, 1, 'False', 1, 4, '2026-04-19 07:27:11'),
(37, 27, 46, 1, 'To manage the flow of data between the CPU, RAM, and graphics card', 1, 4, '2026-04-19 07:27:25'),
(38, 27, 47, 1, 'True', 1, 6, '2026-04-19 07:27:33'),
(39, 27, 49, 1, NULL, 0, 3, '2026-04-19 07:27:42'),
(40, 27, 51, 1, 'False', 1, 11, '2026-04-19 07:28:06'),
(41, 27, 52, 1, 'Sli', 0, 10, '2026-04-19 07:28:18'),
(42, 27, 54, 1, 'To configure the hardware settings for the system', 1, 3, '2026-04-19 07:28:34'),
(43, 28, 46, 1, 'To manage the flow of data between the CPU, RAM, and graphics card', 1, 2, '2026-04-19 07:28:42'),
(44, 29, 61, 1, 'To perform any mathematical calculation using punched cards and a central processing unit', 1, 15, '2026-04-19 07:29:47'),
(45, 29, 62, 1, 'Arithmetic Engine', 0, 14, '2026-04-19 07:30:04'),
(46, 29, 63, 1, 'Ada Lovelace', 1, 8, '2026-04-19 07:30:16'),
(47, 29, 64, 1, 'Lack of interest from the scientific community', 0, 12, '2026-04-19 07:30:34'),
(48, 29, 65, 1, 'It led to the development of mechanical computers', 0, 14, '2026-04-19 07:30:51'),
(49, 29, 66, 1, 'It led him to focus on building a computer that could only perform arithmetic operations', 0, 8, '2026-04-19 07:31:08'),
(50, 29, 67, 1, NULL, 0, 30, '2026-04-19 07:31:40'),
(51, 30, 71, 1, 'Asynchronous execution', 1, 12, '2026-04-19 07:31:40'),
(52, 30, 72, 1, 'A temperature logger that records readings automatically', 0, 13, '2026-04-19 07:31:55'),
(53, 30, 73, 1, 'To execute code in a top-to-bottom sequence', 0, 1, '2026-04-19 07:31:58'),
(54, 30, 74, 1, 'Synchronous communication', 0, 3, '2026-04-19 07:32:03'),
(55, 30, 75, 1, 'A function registered to execute when a specific event fires', 1, 3, '2026-04-19 07:32:09'),
(56, 30, 76, 1, 'A temperature logger that records readings automatically', 0, 2, '2026-04-19 07:32:13'),
(57, 30, 77, 1, 'To tightly couple event producers and consumers', 0, 1, '2026-04-19 07:32:15'),
(58, 30, 78, 1, 'System notifications', 0, 1, '2026-04-19 07:32:18'),
(59, 30, 79, 1, 'Responsiveness', 0, 1, '2026-04-19 07:32:20'),
(60, 30, 80, 1, 'Improved synchronous execution', 0, 1, '2026-04-19 07:32:23'),
(61, 31, 46, 1, 'To manage the flow of data between the CPU, RAM, and graphics card', 1, 9, '2026-04-19 09:20:37'),
(62, 31, 47, 1, 'True', 1, 3, '2026-04-19 09:20:43'),
(63, 31, 48, 1, 'Late', 0, 6, '2026-04-19 09:20:54'),
(64, 31, 49, 1, NULL, 0, 3, '2026-04-19 09:21:00'),
(65, 31, 51, 1, 'False', 1, 2, '2026-04-19 09:21:27'),
(66, 31, 52, 1, 'SLI', 0, 7, '2026-04-19 09:21:36'),
(67, 31, 53, 1, NULL, 0, 3, '2026-04-19 09:21:44'),
(68, 31, 54, 1, 'To configure the hardware settings for the system', 1, 4, '2026-04-19 09:21:52'),
(69, 31, 55, 1, 'False', 1, 3, '2026-04-19 09:21:57'),
(70, 32, 6, 3, 'To maximize profits', 1, 2, '2026-04-19 11:10:21'),
(71, 32, 7, 3, 'Single seller and multiple buyers', 1, 6, '2026-04-19 11:10:28'),
(72, 32, 9, 3, 'Comparative advantage', 0, 11, '2026-04-19 11:10:43'),
(73, 32, 10, 3, 'A normal good has a positive income effect, while an inferior good has a negative income effect', 1, 4, '2026-04-19 11:10:49'),
(74, 35, 1, 3, 'Mark Kian Oliquiano', 1, 4, '2026-04-19 11:11:14'),
(75, 35, 2, 3, 'Lyka Izzabelle Dinoso', 1, 4, '2026-04-19 11:11:21'),
(76, 35, 3, 3, 'Kurt Cuya', 1, 6, '2026-04-19 11:11:29'),
(77, 35, 4, 3, 'Both had Lyka Dinoso and Benjo Corido', 0, 3, '2026-04-19 11:11:34'),
(78, 35, 5, 3, 'Jose Luis Pena', 1, 1, '2026-04-19 11:11:37'),
(79, 36, 81, 1, 'Asynchronous execution', 1, 14, '2026-04-20 02:13:37'),
(80, 36, 82, 1, 'To dispatch events to registered handlers', 1, 6, '2026-04-20 02:13:51'),
(81, 36, 83, 1, 'A function registered to execute when a specific event fires', 1, 5, '2026-04-20 02:14:04'),
(82, 36, 84, 1, 'A chat app responding to messages', 1, 8, '2026-04-20 02:14:15'),
(83, 36, 85, 1, 'Procedural programming is synchronous, while event-driven programming is asynchronous', 1, 21, '2026-04-20 02:14:40'),
(84, 36, 86, 1, 'User input, system, network, hardware/sensor, and application', 1, 15, '2026-04-20 02:14:58'),
(85, 36, 87, 1, 'To increase the complexity of the system', 0, 9, '2026-04-20 02:15:12'),
(86, 36, 88, 1, 'Waiting for one event does not freeze other parts of the program', 1, 4, '2026-04-20 02:15:21'),
(87, 36, 89, 1, 'To store registered handlers', 0, 4, '2026-04-20 02:15:28'),
(88, 36, 90, 1, 'Coroutines are tasks scheduled on a separate thread', 0, 4, '2026-04-20 02:15:35'),
(89, 37, 91, 1, 'To block unauthorized access to a network', 1, 10, '2026-04-20 08:49:49'),
(90, 37, 92, 1, 'Applying security patches and updates', 1, 12, '2026-04-20 08:50:05'),
(91, 37, 93, 1, 'A daemon is a background process, while a service is a foreground process', 0, 32, '2026-04-20 08:50:39'),
(92, 37, 94, 1, 'Syslog', 0, 42, '2026-04-20 08:51:43'),
(93, 37, 95, 1, 'To record system events and errors', 1, 16, '2026-04-20 08:52:15'),
(94, 38, 96, 1, 'To restrict instantiation of a class to a single instance', 1, 19, '2026-04-22 07:39:03'),
(95, 38, 97, 1, 'Bubble sort', 0, 28, '2026-04-22 07:39:35'),
(96, 46, 116, 1, 'Synchronous execution', 0, 22, '2026-04-23 05:47:46'),
(97, 46, 117, 1, 'A temperature logger that records readings every hour', 0, 2, '2026-04-23 05:47:52'),
(98, 46, 118, 1, 'To continuously poll for new events and route them to registered handlers', 1, 4, '2026-04-23 05:48:02'),
(99, 46, 119, 1, 'A function that is registered to execute when a specific event fires', 1, 3, '2026-04-23 05:48:10'),
(100, 46, 120, 1, 'Hardware/sensor events', 0, 1, '2026-04-23 05:48:13'),
(101, 46, 121, 1, 'Asynchronous execution', 0, 2, '2026-04-23 05:48:17'),
(102, 47, 123, 7, 'To summarize and describe data', 1, 4, '2026-04-23 08:19:31');

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

--
-- Table structure for table `quiz_attempts`
--

CREATE TABLE `quiz_attempts` (
  `id` int(10) UNSIGNED NOT NULL,
  `deck_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `started_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `completed_at` timestamp NULL DEFAULT NULL,
  `total_questions` int(10) UNSIGNED NOT NULL,
  `correct_answers` int(10) UNSIGNED DEFAULT 0,
  `wrong_answers` int(10) UNSIGNED DEFAULT 0,
  `skipped_answers` int(10) UNSIGNED DEFAULT 0,
  `total_time` int(10) UNSIGNED DEFAULT 0,
  `score_pct` decimal(5,2) DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quiz_attempts`
--

INSERT INTO `quiz_attempts` (`id`, `deck_id`, `user_id`, `started_at`, `completed_at`, `total_questions`, `correct_answers`, `wrong_answers`, `skipped_answers`, `total_time`, `score_pct`) VALUES
(14, 2, 3, '2026-04-19 06:22:25', NULL, 5, 0, 0, 0, 0, 0.00),
(16, 3, 3, '2026-04-19 06:24:16', NULL, 5, 0, 0, 0, 0, 0.00),
(17, 3, 3, '2026-04-19 06:26:40', NULL, 5, 0, 0, 0, 0, 0.00),
(18, 3, 3, '2026-04-19 06:45:30', NULL, 5, 0, 0, 0, 0, 0.00),
(19, 3, 3, '2026-04-19 06:48:55', NULL, 5, 0, 0, 0, 0, 0.00),
(20, 3, 3, '2026-04-19 06:49:51', NULL, 5, 0, 0, 0, 0, 0.00),
(21, 3, 3, '2026-04-19 06:52:40', NULL, 5, 0, 0, 0, 0, 0.00),
(22, 3, 3, '2026-04-19 06:53:05', NULL, 5, 0, 0, 0, 0, 0.00),
(23, 3, 3, '2026-04-19 07:00:33', NULL, 5, 0, 0, 0, 0, 0.00),
(24, 8, 1, '2026-04-19 07:19:56', NULL, 10, 0, 0, 0, 0, 0.00),
(25, 8, 1, '2026-04-19 07:21:48', NULL, 10, 0, 0, 0, 0, 0.00),
(26, 8, 1, '2026-04-19 07:24:51', NULL, 10, 0, 0, 0, 0, 0.00),
(27, 8, 1, '2026-04-19 07:27:19', NULL, 10, 0, 0, 0, 0, 0.00),
(28, 8, 1, '2026-04-19 07:28:38', NULL, 10, 0, 0, 0, 0, 0.00),
(29, 10, 1, '2026-04-19 07:29:30', NULL, 10, 0, 0, 0, 0, 0.00),
(30, 11, 1, '2026-04-19 07:31:27', NULL, 10, 0, 0, 0, 0, 0.00),
(31, 8, 1, '2026-04-19 09:20:24', NULL, 10, 0, 0, 0, 0, 0.00),
(32, 3, 3, '2026-04-19 11:10:17', NULL, 5, 0, 0, 0, 0, 0.00),
(33, 2, 3, '2026-04-19 11:10:58', NULL, 5, 0, 0, 0, 0, 0.00),
(34, 2, 3, '2026-04-19 11:11:05', NULL, 5, 0, 0, 0, 0, 0.00),
(35, 2, 3, '2026-04-19 11:11:09', NULL, 5, 0, 0, 0, 0, 0.00),
(36, 12, 1, '2026-04-20 02:13:21', NULL, 10, 0, 0, 0, 0, 0.00),
(37, 13, 1, '2026-04-20 08:49:38', NULL, 5, 0, 0, 0, 0, 0.00),
(38, 14, 1, '2026-04-22 07:38:43', NULL, 5, 0, 0, 0, 0, 0.00),
(39, 14, 1, '2026-04-22 07:40:37', NULL, 5, 0, 0, 0, 0, 0.00),
(40, 13, 1, '2026-04-22 07:40:50', NULL, 5, 0, 0, 0, 0, 0.00),
(41, 15, 1, '2026-04-23 05:45:22', NULL, 5, 0, 0, 0, 0, 0.00),
(42, 15, 1, '2026-04-23 05:45:54', NULL, 5, 0, 0, 0, 0, 0.00),
(43, 16, 1, '2026-04-23 05:46:35', NULL, 10, 0, 0, 0, 0, 0.00),
(44, 15, 1, '2026-04-23 05:46:44', NULL, 5, 0, 0, 0, 0, 0.00),
(45, 15, 1, '2026-04-23 05:46:49', NULL, 5, 0, 0, 0, 0, 0.00),
(46, 17, 1, '2026-04-23 05:47:22', NULL, 7, 0, 0, 0, 0, 0.00),
(47, 18, 7, '2026-04-23 08:19:26', NULL, 5, 0, 0, 0, 0, 0.00),
(49, 20, 8, '2026-04-27 04:45:40', NULL, 7, 0, 0, 0, 0, 0.00),
(50, 21, 3, '2026-04-27 04:45:50', NULL, 7, 0, 0, 0, 0, 0.00);

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

--
-- Table structure for table `quiz_decks`
--

CREATE TABLE `quiz_decks` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `difficulty` enum('easy','medium','hard') DEFAULT 'medium',
  `question_count` int(10) UNSIGNED DEFAULT 0,
  `quiz_type` enum('multiple_choice','identification','true_false','short_answer','all') DEFAULT 'multiple_choice',
  `is_timed` tinyint(1) DEFAULT 1,
  `seconds_per_question` int(10) UNSIGNED DEFAULT 30,
  `source` enum('ai','document') DEFAULT 'ai',
  `source_filename` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quiz_decks`
--

INSERT INTO `quiz_decks` (`id`, `user_id`, `title`, `subject`, `difficulty`, `question_count`, `quiz_type`, `is_timed`, `seconds_per_question`, `source`, `source_filename`, `created_at`, `updated_at`) VALUES
(2, 3, 'Quiz: CSCOFFICERS_2022-2026.docx', 'CSCOFFICERS_2022-2026.docx', 'medium', 5, 'multiple_choice', 0, 30, 'document', 'CSCOFFICERS_2022-2026.docx', '2026-04-19 06:22:20', '2026-04-19 06:22:20'),
(3, 3, 'Quiz: economics', 'economics', 'medium', 5, 'multiple_choice', 1, 30, 'ai', NULL, '2026-04-19 06:24:13', '2026-04-19 06:24:13'),
(8, 1, 'Quiz: computer parts', 'computer parts', 'hard', 10, 'all', 1, 30, 'ai', NULL, '2026-04-19 07:12:20', '2026-04-19 07:12:20'),
(9, 3, 'Quiz: photography', 'photography', 'hard', 5, 'all', 1, 30, 'ai', NULL, '2026-04-19 07:19:33', '2026-04-19 07:19:33'),
(10, 1, 'Quiz: Charles babbage', 'Charles babbage', 'medium', 10, 'multiple_choice', 1, 30, 'ai', NULL, '2026-04-19 07:29:27', '2026-04-19 07:29:27'),
(11, 1, 'Quiz: Module1_EventDriven_Python.docx', 'Module1_EventDriven_Python.docx', 'medium', 10, 'multiple_choice', 0, 30, 'document', 'Module1_EventDriven_Python.docx', '2026-04-19 07:31:25', '2026-04-19 07:31:25'),
(12, 1, 'Quiz: Module1_EventDriven_Python.docx', 'Module1_EventDriven_Python.docx', 'medium', 10, 'multiple_choice', 1, 60, 'document', 'Module1_EventDriven_Python.docx', '2026-04-20 02:13:16', '2026-04-20 02:13:16'),
(13, 1, 'Quiz: System Administration', 'System Administration', 'medium', 5, 'multiple_choice', 1, 60, 'ai', NULL, '2026-04-20 08:49:34', '2026-04-20 08:49:34'),
(14, 1, 'Quiz: programming', 'programming', 'hard', 5, 'multiple_choice', 1, 30, 'ai', NULL, '2026-04-22 07:38:35', '2026-04-22 07:38:35'),
(15, 1, 'Quiz: coding practices', 'coding practices', 'medium', 5, 'multiple_choice', 0, 30, 'ai', NULL, '2026-04-23 05:45:19', '2026-04-23 05:45:19'),
(16, 1, 'Quiz: coding practices', 'coding practices', 'medium', 10, 'multiple_choice', 0, 30, 'ai', NULL, '2026-04-23 05:46:33', '2026-04-23 05:46:33'),
(17, 1, 'Quiz: Module1_EventDriven_Python.docx', 'Module1_EventDriven_Python.docx', 'hard', 7, 'multiple_choice', 1, 30, 'document', 'Module1_EventDriven_Python.docx', '2026-04-23 05:47:20', '2026-04-23 05:47:20'),
(18, 7, 'Quiz: Quantitative', 'Quantitative', 'medium', 5, 'multiple_choice', 1, 60, 'ai', NULL, '2026-04-23 08:19:24', '2026-04-23 08:19:24'),
(20, 8, 'Quiz: Research defense', 'Research defense', 'medium', 7, 'multiple_choice', 1, 30, 'ai', NULL, '2026-04-27 04:45:36', '2026-04-27 04:45:36'),
(21, 3, 'Quiz: RESEARCH INTERFACE', 'RESEARCH INTERFACE', 'medium', 7, 'multiple_choice', 1, 30, 'ai', NULL, '2026-04-27 04:45:44', '2026-04-27 04:45:44');

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

--
-- Table structure for table `quiz_questions`
--

CREATE TABLE `quiz_questions` (
  `id` int(10) UNSIGNED NOT NULL,
  `deck_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `question_type` enum('multiple_choice','identification','true_false','short_answer') NOT NULL DEFAULT 'multiple_choice',
  `question` text NOT NULL,
  `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`options`)),
  `correct_answer` varchar(500) NOT NULL,
  `explanation` text DEFAULT NULL,
  `order` smallint(5) UNSIGNED DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `quiz_questions`
--

INSERT INTO `quiz_questions` (`id`, `deck_id`, `user_id`, `question_type`, `question`, `options`, `correct_answer`, `explanation`, `order`, `created_at`) VALUES
(1, 2, 3, 'multiple_choice', 'Who was part of the 2022-2023 and 2023-2024 groups?', '[\"Mark Kian Oliquiano\",\"Benjo Corido\",\"Kurt Cuya\",\"Jose Luis Pena\"]', 'Mark Kian Oliquiano', 'Mark Kian Oliquiano was present in both the 2022-2023 and 2023-2024 groups.', 0, '2026-04-19 06:22:20'),
(2, 2, 3, 'multiple_choice', 'Which individual was part of the most groups?', '[\"Lyka Izzabelle Dinoso\",\"Mark Kian Oliquiano\",\"Benjo Corido\",\"Kurt Cuya\"]', 'Lyka Izzabelle Dinoso', 'Lyka Izzabelle Dinoso was part of the 2022-2023, 2023-2024, and 2025-2026 groups.', 1, '2026-04-19 06:22:20'),
(3, 2, 3, 'multiple_choice', 'Who was not part of the 2022-2023 group?', '[\"Benjo Corido\",\"Kurt Cuya\",\"Jose Luis Pena\",\"Jules Ariola\"]', 'Kurt Cuya', 'Kurt Cuya was not part of the 2022-2023 group.', 2, '2026-04-19 06:22:20'),
(4, 2, 3, 'multiple_choice', 'What is the commonality between the 2024-2025 and 2025-2026 groups?', '[\"Both had Mark Kian Oliquiano\",\"Both had Lyka Dinoso and Benjo Corido\",\"Both had Kurt Cuya and Benjo Corido\",\"Both had Jose Luis Pena\"]', 'Both had Kurt Cuya and Benjo Corido', 'Kurt Cuya and Benjo Corido were part of both the 2024-2025 and 2025-2026 groups.', 3, '2026-04-19 06:22:20'),
(5, 2, 3, 'multiple_choice', 'Which of the following individuals was only part of one group?', '[\"Jose Luis Pena\",\"Jules Ariola\",\"Earl Osera\",\"Lucky Nogot\"]', 'Jose Luis Pena', 'Jose Luis Pena was only part of the 2024-2025 group.', 4, '2026-04-19 06:22:20'),
(6, 3, 3, 'multiple_choice', 'What is the primary goal of a firm in a perfectly competitive market?', '[\"To maximize profits\",\"To minimize costs\",\"To maximize revenue\",\"To minimize profits\"]', 'To maximize profits', 'Firms in a perfectly competitive market aim to maximize their profits by producing at the lowest possible cost and selling at the market price.', 0, '2026-04-19 06:24:13'),
(7, 3, 3, 'multiple_choice', 'Which of the following is a characteristic of a monopoly market structure?', '[\"Many buyers and sellers\",\"Free entry and exit\",\"Single buyer and multiple sellers\",\"Single seller and multiple buyers\"]', 'Single seller and multiple buyers', 'A monopoly is a market structure in which a single firm supplies the entire market with a particular good or service.', 1, '2026-04-19 06:24:13'),
(8, 3, 3, 'multiple_choice', 'What is the effect of an increase in demand on the price of a good in a competitive market?', '[\"The price decreases\",\"The price remains the same\",\"The price increases\",\"The quantity supplied decreases\"]', 'The price increases', 'An increase in demand leads to a higher price as buyers are willing to pay more for the good.', 2, '2026-04-19 06:24:13'),
(9, 3, 3, 'multiple_choice', 'Which economic concept states that the opportunity cost of a choice is the value of the next best alternative that is given up?', '[\"Scarcity\",\"Opportunity cost\",\"Comparative advantage\",\"Diminishing returns\"]', 'Opportunity cost', 'Opportunity cost is the value of the next best alternative that is given up when a choice is made.', 3, '2026-04-19 06:24:13'),
(10, 3, 3, 'multiple_choice', 'What is the difference between a normal good and an inferior good?', '[\"A normal good has a positive income effect, while an inferior good has a negative income effect\",\"A normal good has a negative income effect, while an inferior good has a positive income effect\",\"A normal good has a high price elasticity, while an inferior good has a low price elasticity\",\"A normal good has a low price elasticity, while an inferior good has a high price elasticity\"]', 'A normal good has a positive income effect, while an inferior good has a negative income effect', 'A normal good is one for which the demand increases as income increases, while an inferior good is one for which the demand decreases as income increases.', 4, '2026-04-19 06:24:13'),
(46, 8, 1, 'multiple_choice', 'What is the primary function of the northbridge chip in a computer\'s motherboard?', '[\"To control the keyboard and mouse\",\"To manage the flow of data between the CPU, RAM, and graphics card\",\"To regulate the power supply to the system\",\"To provide additional storage capacity\"]', 'To manage the flow of data between the CPU, RAM, and graphics card', 'The northbridge chip plays a crucial role in managing the flow of data between the CPU, RAM, and graphics card.', 0, '2026-04-19 07:12:20'),
(47, 8, 1, 'true_false', 'Is it true that a 64-bit operating system can only be installed on a 64-bit processor?', '[\"True\",\"False\"]', 'True', 'A 64-bit operating system requires a 64-bit processor to function.', 1, '2026-04-19 07:12:20'),
(48, 8, 1, 'identification', 'What term describes the process of retrieving data from the main memory?', NULL, 'Latency', 'Latency refers to the time it takes for the system to retrieve data from the main memory.', 2, '2026-04-19 07:12:20'),
(49, 8, 1, 'short_answer', 'What is the primary difference between a SATA and a PATA hard drive interface?', NULL, 'SATA uses a serial interface, while PATA uses a parallel interface', 'The primary difference between SATA and PATA is the type of interface used to connect the hard drive to the motherboard.', 3, '2026-04-19 07:12:20'),
(50, 8, 1, 'multiple_choice', 'What is the purpose of the thermal design power (TDP) specification for a CPU?', '[\"To measure the CPU\'s clock speed\",\"To determine the CPU\'s power consumption\",\"To calculate the CPU\'s cache size\",\"To evaluate the CPU\'s instruction set architecture\"]', 'To determine the CPU\'s power consumption', 'The TDP specification indicates the maximum amount of power that a CPU is designed to consume.', 4, '2026-04-19 07:12:20'),
(51, 8, 1, 'true_false', 'Is it true that a solid-state drive (SSD) uses moving parts to store data?', '[\"True\",\"False\"]', 'False', 'SSDs use flash memory to store data and do not have any moving parts.', 5, '2026-04-19 07:12:20'),
(52, 8, 1, 'identification', 'What term describes the technology used to increase the bandwidth of a graphics card by combining multiple GPUs?', NULL, 'SLI (Scalable Link Interface)', 'SLI is a technology used to increase the bandwidth of a graphics card by combining multiple GPUs.', 6, '2026-04-19 07:12:20'),
(53, 8, 1, 'short_answer', 'What is the primary advantage of using a RAID (Redundant Array of Independent Disks) configuration for data storage?', NULL, 'Improved data redundancy and fault tolerance', 'RAID configurations provide improved data redundancy and fault tolerance by duplicating data across multiple disks.', 7, '2026-04-19 07:12:20'),
(54, 8, 1, 'multiple_choice', 'What is the purpose of the BIOS (Basic Input/Output System) in a computer?', '[\"To provide a user interface for the operating system\",\"To manage the flow of data between the CPU and peripherals\",\"To configure the hardware settings for the system\",\"To install the operating system\"]', 'To configure the hardware settings for the system', 'The BIOS provides a set of routines that configure the hardware settings for the system and prepare it for booting.', 8, '2026-04-19 07:12:20'),
(55, 8, 1, 'true_false', 'Is it true that a CPU\'s clock speed is the only factor that determines its performance?', '[\"True\",\"False\"]', 'False', 'Other factors such as the number of cores, cache size, and instruction set architecture also play a role in determining a CPU\'s performance.', 9, '2026-04-19 07:12:20'),
(56, 9, 3, 'multiple_choice', 'What is the primary purpose of the zone system in photography?', '[\"To measure the brightness of a scene\",\"To determine the optimal aperture and shutter speed\",\"To control the contrast and tonal range of an image\",\"To calculate the depth of field\"]', 'To control the contrast and tonal range of an image', 'The zone system is a technique used to control the contrast and tonal range of an image by dividing it into different zones of brightness.', 0, '2026-04-19 07:19:34'),
(57, 9, 3, 'true_false', 'Is it true that a camera\'s dynamic range is limited by its sensor size?', '[\"True\",\"False\"]', 'True', 'A camera\'s dynamic range is indeed limited by its sensor size, as larger sensors can capture a wider range of tonal values.', 1, '2026-04-19 07:19:34'),
(58, 9, 3, 'identification', 'What term describes the phenomenon where a camera\'s autofocus system locks onto a subject that is not the intended target?', NULL, 'Focus breathing', 'Focus breathing occurs when a camera\'s autofocus system incorrectly focuses on a subject that is not the intended target, resulting in an out-of-focus image.', 2, '2026-04-19 07:19:34'),
(59, 9, 3, 'short_answer', 'What are the key differences between a telephoto lens and a wide-angle lens in terms of their effect on perspective?', NULL, 'A telephoto lens compresses perspective, making objects appear closer together, while a wide-angle lens expands perspective, making objects appear farther apart.', 'The differences in perspective between telephoto and wide-angle lenses are due to their respective focal lengths and angles of view.', 3, '2026-04-19 07:19:34'),
(60, 9, 3, 'true_false', 'Is it true that the Orton effect can be achieved using only a single image?', '[\"True\",\"False\"]', 'False', 'The Orton effect typically requires combining two images: one with a sharp focus and another with a soft, dreamy focus, to create a distinctive glow effect.', 4, '2026-04-19 07:19:34'),
(61, 10, 1, 'multiple_choice', 'What was the primary purpose of Charles Babbage\'s proposed mechanical general-purpose computer, the Analytical Engine?', '[\"To perform simple arithmetic calculations\",\"To automate weaving patterns\",\"To crack encryption codes\",\"To perform any mathematical calculation using punched cards and a central processing unit\"]', 'To perform any mathematical calculation using punched cards and a central processing unit', 'The Analytical Engine was designed to be a general-purpose computer that could perform any mathematical calculation using punched cards and a central processing unit.', 0, '2026-04-19 07:29:27'),
(62, 10, 1, 'multiple_choice', 'What was the name of Charles Babbage\'s first mechanical computer, which could perform basic arithmetic operations?', '[\"Difference Engine\",\"Analytical Engine\",\"Calculating Machine\",\"Arithmetic Engine\"]', 'Difference Engine', 'The Difference Engine was Charles Babbage\'s first mechanical computer, designed to perform basic arithmetic operations.', 1, '2026-04-19 07:29:27'),
(63, 10, 1, 'multiple_choice', 'Who is often credited with inventing the first computer program, intended for use with Charles Babbage\'s Analytical Engine?', '[\"Ada Lovelace\",\"Alan Turing\",\"Charles Babbage\",\"George Boole\"]', 'Ada Lovelace', 'Ada Lovelace is often credited with inventing the first computer program, intended for use with Charles Babbage\'s Analytical Engine.', 2, '2026-04-19 07:29:27'),
(64, 10, 1, 'multiple_choice', 'What was the main obstacle that prevented Charles Babbage from building the Analytical Engine during his lifetime?', '[\"Lack of funding\",\"Lack of technical expertise\",\"Lack of interest from the scientific community\",\"Lack of suitable materials\"]', 'Lack of funding', 'The main obstacle that prevented Charles Babbage from building the Analytical Engine during his lifetime was the lack of funding.', 3, '2026-04-19 07:29:27'),
(65, 10, 1, 'multiple_choice', 'What was the significance of Charles Babbage\'s work on the Analytical Engine in the development of modern computer science?', '[\"It led to the development of electronic computers\",\"It led to the development of mechanical computers\",\"It led to the development of programming languages\",\"It had no significant impact on the development of computer science\"]', 'It led to the development of electronic computers', 'Charles Babbage\'s work on the Analytical Engine laid the foundation for the development of electronic computers in the 20th century.', 4, '2026-04-19 07:29:27'),
(66, 10, 1, 'multiple_choice', 'How did Charles Babbage\'s work on the Difference Engine influence his design of the Analytical Engine?', '[\"It led him to abandon the idea of building a mechanical computer\",\"It led him to focus on building a computer that could only perform arithmetic operations\",\"It led him to design a computer that could perform any mathematical calculation\",\"It had no influence on his design of the Analytical Engine\"]', 'It led him to design a computer that could perform any mathematical calculation', 'Charles Babbage\'s work on the Difference Engine led him to design the Analytical Engine, which could perform any mathematical calculation.', 5, '2026-04-19 07:29:27'),
(67, 10, 1, 'multiple_choice', 'What was the role of punched cards in Charles Babbage\'s Analytical Engine?', '[\"To input data into the computer\",\"To output results from the computer\",\"To store programs and data\",\"To perform calculations\"]', 'To input data into the computer', 'Punched cards were used to input data into the Analytical Engine, allowing it to perform calculations based on the input data.', 6, '2026-04-19 07:29:27'),
(68, 10, 1, 'multiple_choice', 'How did Charles Babbage\'s work on the Analytical Engine influence the development of modern programming languages?', '[\"It led to the development of low-level programming languages\",\"It led to the development of high-level programming languages\",\"It had no influence on the development of programming languages\",\"It led to the development of machine-specific programming languages\"]', 'It led to the development of high-level programming languages', 'Charles Babbage\'s work on the Analytical Engine laid the foundation for the development of high-level programming languages, which are used to write programs that can be executed on a variety of computers.', 7, '2026-04-19 07:29:27'),
(69, 10, 1, 'multiple_choice', 'What was the significance of Charles Babbage\'s collaboration with Ada Lovelace on the Analytical Engine?', '[\"It led to the development of the first computer program\",\"It led to the development of the first computer language\",\"It led to the development of the first computer algorithm\",\"It had no significant impact on the development of computer science\"]', 'It led to the development of the first computer program', 'Charles Babbage\'s collaboration with Ada Lovelace led to the development of the first computer program, which was intended for use with the Analytical Engine.', 8, '2026-04-19 07:29:27'),
(70, 10, 1, 'multiple_choice', 'How did Charles Babbage\'s work on the Analytical Engine influence the development of artificial intelligence?', '[\"It led to the development of the first artificial intelligence program\",\"It led to the development of the first expert system\",\"It laid the foundation for the development of modern artificial intelligence\",\"It had no influence on the development of artificial intelligence\"]', 'It laid the foundation for the development of modern artificial intelligence', 'Charles Babbage\'s work on the Analytical Engine laid the foundation for the development of modern artificial intelligence, which is a field of study that focuses on creating machines that can think and learn like humans.', 9, '2026-04-19 07:29:27'),
(71, 11, 1, 'multiple_choice', 'What is the primary characteristic that distinguishes event-driven programming from traditional procedural programming?', '[\"Synchronous execution\",\"Asynchronous execution\",\"Linear control flow\",\"Top-to-bottom sequence\"]', 'Asynchronous execution', 'Event-driven programming is characterized by asynchronous execution, where code does not run in a strict top-to-bottom order.', 0, '2026-04-19 07:31:25'),
(72, 11, 1, 'multiple_choice', 'Which of the following is an example of an event-driven system?', '[\"A monthly payroll calculator\",\"A chat app responding to messages\",\"A script that reads a CSV file\",\"A temperature logger that records readings automatically\"]', 'A chat app responding to messages', 'A chat app responding to messages is an example of an event-driven system, as it reacts to incoming events (messages) and executes code in response.', 1, '2026-04-19 07:31:25'),
(73, 11, 1, 'multiple_choice', 'What is the purpose of the event loop in an event-driven system?', '[\"To execute code in a top-to-bottom sequence\",\"To dispatch events to their registered handlers\",\"To wait for user input\",\"To perform background work\"]', 'To dispatch events to their registered handlers', 'The event loop is the central dispatcher that continuously polls for new events and routes each one to its registered handler.', 2, '2026-04-19 07:31:25'),
(74, 11, 1, 'multiple_choice', 'Which of the following is a characteristic of event-driven systems?', '[\"Blocking execution\",\"Non-blocking execution\",\"Synchronous communication\",\"Linear control flow\"]', 'Non-blocking execution', 'Event-driven systems are characterized by non-blocking execution, where waiting for one event does not freeze other parts of the program.', 3, '2026-04-19 07:31:25'),
(75, 11, 1, 'multiple_choice', 'What is a callback in the context of event-driven programming?', '[\"A function that executes in a top-to-bottom sequence\",\"A function registered to execute when a specific event fires\",\"A function that performs background work\",\"A function that waits for user input\"]', 'A function registered to execute when a specific event fires', 'A callback is a function registered to execute when a specific event fires, also known as a handler.', 4, '2026-04-19 07:31:25'),
(76, 11, 1, 'multiple_choice', 'Which of the following is an example of a real-world event-driven system?', '[\"A traffic light\",\"A monthly payroll calculator\",\"A script that reads a CSV file\",\"A temperature logger that records readings automatically\"]', 'A traffic light', 'A traffic light is an example of a real-world event-driven system, as it reacts to events (timer expirations or sensor signals) and executes code in response (changing the light color).', 5, '2026-04-19 07:31:25'),
(77, 11, 1, 'multiple_choice', 'What is the purpose of decoupling in event-driven systems?', '[\"To tightly couple event producers and consumers\",\"To loosely couple event producers and consumers\",\"To execute code in a top-to-bottom sequence\",\"To perform background work\"]', 'To loosely couple event producers and consumers', 'Decoupling in event-driven systems refers to the separation of event producers (sources) from event consumers (handlers), allowing for loose coupling and greater flexibility.', 6, '2026-04-19 07:31:25'),
(78, 11, 1, 'multiple_choice', 'Which of the following is a category of events in event-driven programming?', '[\"User input\",\"System notifications\",\"Network requests\",\"All of the above\"]', 'All of the above', 'Events in event-driven programming can be categorized into several types, including user input, system notifications, network requests, and more.', 7, '2026-04-19 07:31:25'),
(79, 11, 1, 'multiple_choice', 'What is the term for the ability of an event-driven system to handle many event types independently and concurrently?', '[\"Scalability\",\"Responsiveness\",\"Asynchronous execution\",\"Non-blocking execution\"]', 'Scalability', 'Scalability refers to the ability of an event-driven system to handle many event types independently and concurrently, allowing for greater flexibility and performance.', 8, '2026-04-19 07:31:25'),
(80, 11, 1, 'multiple_choice', 'Which of the following is a benefit of using event-driven programming?', '[\"Improved synchronous execution\",\"Increased blocking execution\",\"Enhanced responsiveness\",\"Reduced scalability\"]', 'Enhanced responsiveness', 'Event-driven programming allows for enhanced responsiveness, as the system can react instantly to incoming events and execute code in response.', 9, '2026-04-19 07:31:25'),
(81, 12, 1, 'multiple_choice', 'What is the primary characteristic of event-driven programming?', '[\"Synchronous execution\",\"Asynchronous execution\",\"Linear execution\",\"Sequential execution\"]', 'Asynchronous execution', 'Event-driven programming is characterized by asynchronous execution, where code does not run in a strict top-to-bottom order.', 0, '2026-04-20 02:13:16'),
(82, 12, 1, 'multiple_choice', 'What is the purpose of the event loop in event-driven systems?', '[\"To execute code in a linear sequence\",\"To dispatch events to registered handlers\",\"To wait for user input\",\"To perform background work\"]', 'To dispatch events to registered handlers', 'The event loop continuously polls for new events and routes each one to its registered handler.', 1, '2026-04-20 02:13:16'),
(83, 12, 1, 'multiple_choice', 'What is a callback in event-driven programming?', '[\"A function that executes immediately\",\"A function registered to execute when a specific event fires\",\"A variable that stores event data\",\"A loop that waits for events\"]', 'A function registered to execute when a specific event fires', 'A callback is a function that is registered to execute when a specific event fires.', 2, '2026-04-20 02:13:16'),
(84, 12, 1, 'multiple_choice', 'What is an example of an event-driven system in everyday life?', '[\"A monthly payroll calculator\",\"A chat app responding to messages\",\"A script that reads a CSV file\",\"A program that prints student grades\"]', 'A chat app responding to messages', 'A chat app responding to messages is an example of an event-driven system, where the program reacts to incoming events (messages) and executes the corresponding handler.', 3, '2026-04-20 02:13:16'),
(85, 12, 1, 'multiple_choice', 'What is the difference between procedural and event-driven programming?', '[\"Procedural programming is asynchronous, while event-driven programming is synchronous\",\"Procedural programming is synchronous, while event-driven programming is asynchronous\",\"Procedural programming is event-driven, while event-driven programming is procedural\",\"Procedural programming is linear, while event-driven programming is non-linear\"]', 'Procedural programming is synchronous, while event-driven programming is asynchronous', 'Procedural programming executes code in a strict top-to-bottom order, while event-driven programming executes code in response to events.', 4, '2026-04-20 02:13:16'),
(86, 12, 1, 'multiple_choice', 'What are the five categories of events in event-driven systems?', '[\"User input, system, network, hardware\\/sensor, and database\",\"User input, system, network, hardware\\/sensor, and application\",\"User input, system, network, hardware\\/sensor, and file system\",\"User input, system, network, hardware\\/sensor, and web\"]', 'User input, system, network, hardware/sensor, and application', 'The five categories of events in event-driven systems are user input, system, network, hardware/sensor, and application.', 5, '2026-04-20 02:13:16'),
(87, 12, 1, 'multiple_choice', 'What is the purpose of decoupling in event-driven systems?', '[\"To tightly couple event producers and consumers\",\"To loosely couple event producers and consumers\",\"To increase the complexity of the system\",\"To decrease the scalability of the system\"]', 'To loosely couple event producers and consumers', 'Decoupling in event-driven systems means that event producers (sources) are separate from event consumers (handlers), allowing for greater flexibility and scalability.', 6, '2026-04-20 02:13:17'),
(88, 12, 1, 'multiple_choice', 'What is the benefit of non-blocking execution in event-driven systems?', '[\"Waiting for one event freezes other parts of the program\",\"Waiting for one event does not freeze other parts of the program\",\"Non-blocking execution decreases responsiveness\",\"Non-blocking execution decreases scalability\"]', 'Waiting for one event does not freeze other parts of the program', 'Non-blocking execution in event-driven systems means that waiting for one event does not freeze other parts of the program, allowing for greater responsiveness and scalability.', 7, '2026-04-20 02:13:17'),
(89, 12, 1, 'multiple_choice', 'What is the purpose of the event queue in the event loop?', '[\"To store registered handlers\",\"To store pending events\",\"To store executed events\",\"To store event data\"]', 'To store pending events', 'The event queue in the event loop stores pending events, which are then dequeued and dispatched to their registered handlers.', 8, '2026-04-20 02:13:17'),
(90, 12, 1, 'multiple_choice', 'What is the relationship between coroutines and the event loop in Python\'s asyncio?', '[\"Coroutines are tasks scheduled on a separate thread\",\"Coroutines are tasks scheduled on the event loop\",\"Coroutines are used for synchronous execution\",\"Coroutines are used for procedural programming\"]', 'Coroutines are tasks scheduled on the event loop', 'In Python\'s asyncio, coroutines are tasks scheduled on the event loop, allowing for asynchronous execution and non-blocking I/O operations.', 9, '2026-04-20 02:13:17'),
(91, 13, 1, 'multiple_choice', 'What is the primary purpose of a firewall in system administration?', '[\"To improve network performance\",\"To enhance user authentication\",\"To block unauthorized access to a network\",\"To monitor system logs\"]', 'To block unauthorized access to a network', 'Firewalls are used to control incoming and outgoing network traffic based on predetermined security rules.', 0, '2026-04-20 08:49:34'),
(92, 13, 1, 'multiple_choice', 'Which of the following system administration tasks is typically performed during system maintenance?', '[\"Installing new hardware\",\"Configuring network settings\",\"Applying security patches and updates\",\"Setting up user accounts\"]', 'Applying security patches and updates', 'Regular system maintenance involves applying security patches and updates to ensure the system remains secure and stable.', 1, '2026-04-20 08:49:34'),
(93, 13, 1, 'multiple_choice', 'What is the difference between a daemon and a service in system administration?', '[\"A daemon is a background process, while a service is a foreground process\",\"A daemon is a foreground process, while a service is a background process\",\"A daemon is a type of service that runs in the background\",\"A daemon and a service are interchangeable terms\"]', 'A daemon is a type of service that runs in the background', 'Daemons are background processes that run continuously, performing specific system tasks, while services can refer to any program or process that provides a specific functionality.', 2, '2026-04-20 08:49:34'),
(94, 13, 1, 'multiple_choice', 'Which system administration tool is used to manage and configure network interfaces?', '[\"Syslog\",\"Cron\",\"Ifconfig\",\"Tcpdump\"]', 'Ifconfig', 'Ifconfig is a command-line utility used to configure and manage network interfaces, including assigning IP addresses and setting interface properties.', 3, '2026-04-20 08:49:34'),
(95, 13, 1, 'multiple_choice', 'What is the purpose of a system log in system administration?', '[\"To monitor system performance\",\"To track user activity\",\"To store system configuration files\",\"To record system events and errors\"]', 'To record system events and errors', 'System logs are used to record system events, errors, and warnings, providing valuable information for troubleshooting and debugging purposes.', 4, '2026-04-20 08:49:34'),
(96, 14, 1, 'multiple_choice', 'What is the primary purpose of using a singleton design pattern in object-oriented programming?', '[\"To create multiple instances of a class\",\"To restrict instantiation of a class to a single instance\",\"To increase the complexity of a program\",\"To reduce code readability\"]', 'To restrict instantiation of a class to a single instance', 'The singleton pattern ensures that only one instance of a class is created, providing a global point of access to it.', 0, '2026-04-22 07:38:35'),
(97, 14, 1, 'multiple_choice', 'Which of the following algorithms has an average time complexity of O(n log n) for sorting a list of elements?', '[\"Bubble sort\",\"Selection sort\",\"Merge sort\",\"Insertion sort\"]', 'Merge sort', 'Merge sort is a divide-and-conquer algorithm that splits the list into smaller chunks, sorts them, and merges them back together, resulting in an average time complexity of O(n log n).', 1, '2026-04-22 07:38:36'),
(98, 14, 1, 'multiple_choice', 'What is the term for the process of determining the most efficient order in which to perform a series of operations, given certain constraints?', '[\"Scheduling\",\"Sorting\",\"Searching\",\"Optimization\"]', 'Scheduling', 'Scheduling involves determining the optimal order in which to perform a series of operations, taking into account constraints such as resource availability and dependencies between tasks.', 2, '2026-04-22 07:38:36'),
(99, 14, 1, 'multiple_choice', 'Which of the following programming paradigms is based on the concept of pure functions, immutability, and the avoidance of changing state?', '[\"Object-oriented programming\",\"Functional programming\",\"Imperative programming\",\"Declarative programming\"]', 'Functional programming', 'Functional programming emphasizes the use of pure functions, immutability, and the avoidance of changing state, making it a paradigm that focuses on the evaluation of expressions rather than the execution of statements.', 3, '2026-04-22 07:38:36'),
(100, 14, 1, 'multiple_choice', 'What is the purpose of the \'finally\' block in a try-catch-finally exception handling mechanism?', '[\"To catch and handle exceptions\",\"To provide a block of code that executes only if an exception is thrown\",\"To provide a block of code that executes regardless of whether an exception is thrown\",\"To skip the execution of the code in the try block\"]', 'To provide a block of code that executes regardless of whether an exception is thrown', 'The \'finally\' block is used to provide a block of code that executes regardless of whether an exception is thrown, allowing for the release of resources and the cleanup of code.', 4, '2026-04-22 07:38:36'),
(101, 15, 1, 'multiple_choice', 'What is the primary purpose of using design patterns in coding practices?', '[\"To reduce code complexity\",\"To increase code readability\",\"To improve code maintainability\",\"All of the above\"]', 'All of the above', 'Design patterns help reduce code complexity, increase code readability, and improve code maintainability.', 0, '2026-04-23 05:45:19'),
(102, 15, 1, 'multiple_choice', 'Which coding practice is focused on writing automated tests before writing the actual code?', '[\"Test-Driven Development\",\"Behavior-Driven Development\",\"Continuous Integration\",\"Continuous Deployment\"]', 'Test-Driven Development', 'Test-Driven Development is a coding practice where automated tests are written before writing the actual code.', 1, '2026-04-23 05:45:19'),
(103, 15, 1, 'multiple_choice', 'What is the main difference between monolithic architecture and microservices architecture?', '[\"Monolithic is more scalable\",\"Microservices is more complex\",\"Monolithic has a single codebase, while microservices has multiple\",\"Microservices is less secure\"]', 'Monolithic has a single codebase, while microservices has multiple', 'The main difference between monolithic architecture and microservices architecture is that monolithic has a single codebase, while microservices has multiple.', 2, '2026-04-23 05:45:19'),
(104, 15, 1, 'multiple_choice', 'Which coding practice involves integrating code changes into a central repository frequently?', '[\"Continuous Integration\",\"Continuous Deployment\",\"Continuous Monitoring\",\"Continuous Testing\"]', 'Continuous Integration', 'Continuous Integration involves integrating code changes into a central repository frequently.', 3, '2026-04-23 05:45:19'),
(105, 15, 1, 'multiple_choice', 'What is the purpose of code refactoring?', '[\"To add new features\",\"To fix bugs\",\"To improve code performance\",\"To improve code structure and readability\"]', 'To improve code structure and readability', 'The purpose of code refactoring is to improve code structure and readability, making it easier to maintain and understand.', 4, '2026-04-23 05:45:19'),
(106, 16, 1, 'multiple_choice', 'What is the primary purpose of code refactoring?', '[\"To add new features\",\"To fix bugs\",\"To improve code readability and maintainability\",\"To optimize performance\"]', 'To improve code readability and maintainability', 'Refactoring is the process of restructuring existing code to make it more efficient, readable, and maintainable without changing its external behavior.', 0, '2026-04-23 05:46:33'),
(107, 16, 1, 'multiple_choice', 'Which coding practice helps to reduce the complexity of code by breaking it down into smaller, manageable functions?', '[\"Modularization\",\"Encapsulation\",\"Abstraction\",\"Inheritance\"]', 'Modularization', 'Modularization is the process of breaking down a large program into smaller, independent modules that can be developed and tested separately.', 1, '2026-04-23 05:46:33'),
(108, 16, 1, 'multiple_choice', 'What is the benefit of using a version control system like Git?', '[\"To improve code performance\",\"To reduce development time\",\"To collaborate with team members and track changes\",\"To add new features to the code\"]', 'To collaborate with team members and track changes', 'Version control systems like Git allow multiple developers to collaborate on a project, track changes, and manage different versions of the code.', 2, '2026-04-23 05:46:33'),
(109, 16, 1, 'multiple_choice', 'Which coding principle states that a class should have only one reason to change?', '[\"Single Responsibility Principle\",\"Open-Closed Principle\",\"Liskov Substitution Principle\",\"Interface Segregation Principle\"]', 'Single Responsibility Principle', 'The Single Responsibility Principle states that a class should have only one reason to change, meaning it should have only one responsibility or functionality.', 3, '2026-04-23 05:46:33'),
(110, 16, 1, 'multiple_choice', 'What is the purpose of a code review?', '[\"To test the code\",\"To debug the code\",\"To improve the quality and readability of the code\",\"To deploy the code\"]', 'To improve the quality and readability of the code', 'A code review is a process where a developer\'s code is reviewed by another developer to improve its quality, readability, and maintainability.', 4, '2026-04-23 05:46:33'),
(111, 16, 1, 'multiple_choice', 'Which coding practice involves writing automated tests for the code before writing the actual code?', '[\"Test-Driven Development\",\"Behavior-Driven Development\",\"Acceptance-Driven Development\",\"Continuous Integration\"]', 'Test-Driven Development', 'Test-Driven Development is a coding practice where automated tests are written before writing the actual code, to ensure the code meets the required functionality and is testable.', 5, '2026-04-23 05:46:33'),
(112, 16, 1, 'multiple_choice', 'What is the benefit of using a continuous integration/continuous deployment (CI/CD) pipeline?', '[\"To reduce the time spent on testing and deployment\",\"To improve the quality and reliability of the code\",\"To increase the complexity of the code\",\"To decrease the frequency of code updates\"]', 'To improve the quality and reliability of the code', 'A CI/CD pipeline automates the testing, building, and deployment of code, improving its quality and reliability by catching errors and bugs early in the development process.', 6, '2026-04-23 05:46:33'),
(113, 16, 1, 'multiple_choice', 'Which coding principle states that a class should be open for extension but closed for modification?', '[\"Open-Closed Principle\",\"Single Responsibility Principle\",\"Liskov Substitution Principle\",\"Interface Segregation Principle\"]', 'Open-Closed Principle', 'The Open-Closed Principle states that a class should be open for extension, meaning new functionality can be added, but closed for modification, meaning the existing code should not be changed.', 7, '2026-04-23 05:46:33'),
(114, 16, 1, 'multiple_choice', 'What is the purpose of a coding standard?', '[\"To improve code performance\",\"To reduce development time\",\"To ensure consistency and readability of the code\",\"To add new features to the code\"]', 'To ensure consistency and readability of the code', 'A coding standard is a set of guidelines and rules that ensure the consistency and readability of the code, making it easier to maintain and understand.', 8, '2026-04-23 05:46:33'),
(115, 16, 1, 'multiple_choice', 'Which coding practice involves writing code that is easy to understand and maintain, with clear and concise variable names and comments?', '[\"Clean Code\",\"Dirty Code\",\"Test-Driven Development\",\"Behavior-Driven Development\"]', 'Clean Code', 'Clean Code is a coding practice that involves writing code that is easy to understand and maintain, with clear and concise variable names and comments, making it easier to modify and extend the code.', 9, '2026-04-23 05:46:33'),
(116, 17, 1, 'multiple_choice', 'What is the primary characteristic that distinguishes event-driven programming from traditional procedural programming?', '[\"Synchronous execution\",\"Asynchronous execution\",\"Linear control flow\",\"Static event handling\"]', 'Asynchronous execution', 'Event-driven programming is characterized by asynchronous execution, where the program\'s control flow is determined by external events rather than a fixed sequence.', 0, '2026-04-23 05:47:20'),
(117, 17, 1, 'multiple_choice', 'Which of the following is an example of a real-world event-driven system?', '[\"A monthly payroll calculator\",\"A chat app responding to messages\",\"A script that reads a CSV file\",\"A temperature logger that records readings every hour\"]', 'A chat app responding to messages', 'A chat app responding to messages is an example of an event-driven system, where the program reacts to incoming messages and responds accordingly.', 1, '2026-04-23 05:47:20'),
(118, 17, 1, 'multiple_choice', 'What is the purpose of the event loop in an event-driven system?', '[\"To execute a fixed sequence of instructions\",\"To continuously poll for new events and route them to registered handlers\",\"To handle a single type of event\",\"To block other parts of the program while waiting for an event\"]', 'To continuously poll for new events and route them to registered handlers', 'The event loop is the central dispatcher that continuously polls for new events and routes each one to its registered handler.', 2, '2026-04-23 05:47:20'),
(119, 17, 1, 'multiple_choice', 'What is a callback in the context of event-driven programming?', '[\"A function that executes immediately when called\",\"A function that is registered to execute when a specific event fires\",\"A function that blocks other parts of the program\",\"A function that handles a single type of event\"]', 'A function that is registered to execute when a specific event fires', 'A callback is a function that is registered to execute when a specific event fires, allowing the program to respond to the event accordingly.', 3, '2026-04-23 05:47:20'),
(120, 17, 1, 'multiple_choice', 'Which of the following categories of events includes keyboard presses and mouse clicks?', '[\"System events\",\"Network events\",\"Hardware\\/sensor events\",\"User input events\"]', 'User input events', 'User input events include keyboard presses, mouse clicks, touch gestures, and form submissions.', 4, '2026-04-23 05:47:20'),
(121, 17, 1, 'multiple_choice', 'What is the term for the separation of event producers and event consumers in an event-driven system?', '[\"Coupling\",\"Decoupling\",\"Asynchronous execution\",\"Synchronous execution\"]', 'Decoupling', 'Decoupling refers to the separation of event producers and event consumers, allowing them to operate independently and improving the system\'s scalability and responsiveness.', 5, '2026-04-23 05:47:20'),
(122, 17, 1, 'multiple_choice', 'Which Python library is used to implement the event loop and handle I/O events in an event-driven system?', '[\"asyncio\",\"threading\",\"socket\",\"select\"]', 'asyncio', 'The asyncio library is used to implement the event loop and handle I/O events in an event-driven system, providing support for coroutines and asynchronous execution.', 6, '2026-04-23 05:47:20'),
(123, 18, 7, 'multiple_choice', 'What is the primary purpose of descriptive statistics in quantitative analysis?', '[\"To predict future trends\",\"To identify causal relationships\",\"To summarize and describe data\",\"To test hypotheses\"]', 'To summarize and describe data', 'Descriptive statistics is used to summarize and describe the basic features of a dataset.', 0, '2026-04-23 08:19:24'),
(124, 18, 7, 'multiple_choice', 'Which of the following types of data is typically used for quantitative analysis?', '[\"Qualitative data\",\"Ordinal data\",\"Nominal data\",\"Ratio data\"]', 'Ratio data', 'Ratio data has a true zero point and allows for meaningful comparisons and calculations.', 1, '2026-04-23 08:19:24'),
(125, 18, 7, 'multiple_choice', 'What is the effect of increasing the sample size on the standard error of the mean?', '[\"It increases the standard error\",\"It has no effect on the standard error\",\"It decreases the standard error\",\"It makes the standard error undefined\"]', 'It decreases the standard error', 'Increasing the sample size reduces the standard error of the mean, making the estimate more precise.', 2, '2026-04-23 08:19:24'),
(126, 18, 7, 'multiple_choice', 'Which of the following is a characteristic of a normally distributed dataset?', '[\"It is skewed to the right\",\"It is bimodal\",\"It is symmetric around the mean\",\"It has a uniform distribution\"]', 'It is symmetric around the mean', 'A normally distributed dataset is symmetric around the mean, with the majority of data points clustered around the mean.', 3, '2026-04-23 08:19:24'),
(127, 18, 7, 'multiple_choice', 'What is the purpose of hypothesis testing in quantitative analysis?', '[\"To describe the characteristics of a dataset\",\"To identify correlations between variables\",\"To determine the relationship between variables\",\"To make inferences about a population based on a sample\"]', 'To make inferences about a population based on a sample', 'Hypothesis testing is used to make inferences about a population based on a sample, by testing a hypothesis about the population parameter.', 4, '2026-04-23 08:19:24'),
(135, 20, 8, 'multiple_choice', 'What is the primary purpose of a research defense?', '[\"To criticize the research methodology\",\"To educate the audience about the research topic\",\"To demonstrate the researcher\'s expertise and defend their work\",\"To entertain the audience\"]', 'To demonstrate the researcher\'s expertise and defend their work', 'The primary purpose of a research defense is for the researcher to demonstrate their expertise and defend their work against potential criticisms.', 0, '2026-04-27 04:45:36'),
(136, 20, 8, 'multiple_choice', 'What is the role of the research committee in a research defense?', '[\"To provide feedback on the research methodology\",\"To ask questions and challenge the researcher\'s findings\",\"To provide funding for the research project\",\"To edit the research paper\"]', 'To ask questions and challenge the researcher\'s findings', 'The research committee plays a crucial role in a research defense by asking questions and challenging the researcher\'s findings to test their knowledge and expertise.', 1, '2026-04-27 04:45:36'),
(137, 20, 8, 'multiple_choice', 'What is the most effective way to handle a difficult question during a research defense?', '[\"To avoid answering the question\",\"To become defensive and argumentative\",\"To take a moment to think before responding clearly and concisely\",\"To change the subject\"]', 'To take a moment to think before responding clearly and concisely', 'The most effective way to handle a difficult question during a research defense is to take a moment to think before responding clearly and concisely, demonstrating confidence and expertise.', 2, '2026-04-27 04:45:36'),
(138, 20, 8, 'multiple_choice', 'What is the importance of anticipating potential criticisms during a research defense?', '[\"It helps to avoid potential criticisms\",\"It demonstrates a lack of confidence in the research\",\"It shows preparedness and ability to address potential weaknesses\",\"It is not necessary to anticipate potential criticisms\"]', 'It shows preparedness and ability to address potential weaknesses', 'Anticipating potential criticisms during a research defense shows preparedness and ability to address potential weaknesses, demonstrating a higher level of expertise and confidence.', 3, '2026-04-27 04:45:36'),
(139, 20, 8, 'multiple_choice', 'How can a researcher prepare for a research defense?', '[\"By rehearsing their presentation several times\",\"By reading their research paper aloud\",\"By anticipating potential questions and practicing responses\",\"By all of the above\"]', 'By all of the above', 'A researcher can prepare for a research defense by rehearsing their presentation several times, reading their research paper aloud, and anticipating potential questions and practicing responses.', 4, '2026-04-27 04:45:36'),
(140, 20, 8, 'multiple_choice', 'What is the benefit of receiving feedback during a research defense?', '[\"It helps to identify areas for improvement\",\"It provides an opportunity to revise the research paper\",\"It demonstrates the researcher\'s expertise\",\"It is not beneficial to receive feedback\"]', 'It helps to identify areas for improvement', 'Receiving feedback during a research defense helps to identify areas for improvement, allowing the researcher to refine their work and increase its validity.', 5, '2026-04-27 04:45:36'),
(141, 20, 8, 'multiple_choice', 'What is the outcome of a successful research defense?', '[\"The researcher\'s degree is revoked\",\"The research paper is published immediately\",\"The researcher is awarded their degree\",\"The research project is terminated\"]', 'The researcher is awarded their degree', 'The outcome of a successful research defense is that the researcher is awarded their degree, having demonstrated their expertise and defended their work against potential criticisms.', 6, '2026-04-27 04:45:36'),
(142, 21, 3, 'multiple_choice', 'What is the primary purpose of a research interface?', '[\"To collect and store data\",\"To analyze and visualize data\",\"To facilitate user interaction with a database or system\",\"To generate research reports\"]', 'To facilitate user interaction with a database or system', 'A research interface is designed to provide a convenient and efficient way for users to interact with a database or system, allowing them to retrieve, analyze, and visualize data.', 0, '2026-04-27 04:45:44'),
(143, 21, 3, 'multiple_choice', 'Which of the following is a key characteristic of a well-designed research interface?', '[\"Complexity\",\"Inconsistency\",\"Intuitiveness\",\"Inflexibility\"]', 'Intuitiveness', 'A well-designed research interface should be intuitive, meaning that it is easy for users to understand and navigate, even if they have limited experience with the system.', 1, '2026-04-27 04:45:44'),
(144, 21, 3, 'multiple_choice', 'What is the benefit of using a standardized research interface?', '[\"Increased complexity\",\"Improved data security\",\"Enhanced user experience\",\"Reduced compatibility\"]', 'Enhanced user experience', 'A standardized research interface can provide a consistent and familiar experience for users, making it easier for them to navigate and use the system.', 2, '2026-04-27 04:45:44'),
(145, 21, 3, 'multiple_choice', 'How does a research interface impact the research process?', '[\"It hinders the research process by limiting access to data\",\"It has no impact on the research process\",\"It facilitates the research process by providing efficient data retrieval\",\"It replaces the need for human researchers\"]', 'It facilitates the research process by providing efficient data retrieval', 'A research interface can facilitate the research process by providing efficient data retrieval, analysis, and visualization capabilities, allowing researchers to focus on higher-level tasks.', 3, '2026-04-27 04:45:44'),
(146, 21, 3, 'multiple_choice', 'What is the role of usability testing in the development of a research interface?', '[\"To evaluate the aesthetic appeal of the interface\",\"To assess the compatibility of the interface with different devices\",\"To identify and fix usability issues\",\"To determine the cost-effectiveness of the interface\"]', 'To identify and fix usability issues', 'Usability testing plays a crucial role in the development of a research interface, as it helps to identify and fix usability issues, ensuring that the interface is intuitive and easy to use.', 4, '2026-04-27 04:45:44'),
(147, 21, 3, 'multiple_choice', 'How does a research interface support collaboration among researchers?', '[\"By providing a shared workspace for data analysis\",\"By facilitating communication through email notifications\",\"By enabling real-time data sharing and collaboration\",\"By restricting access to sensitive data\"]', 'By enabling real-time data sharing and collaboration', 'A research interface can support collaboration among researchers by enabling real-time data sharing and collaboration, allowing multiple users to work together on a project and share results.', 5, '2026-04-27 04:45:44');
INSERT INTO `quiz_questions` (`id`, `deck_id`, `user_id`, `question_type`, `question`, `options`, `correct_answer`, `explanation`, `order`, `created_at`) VALUES
(148, 21, 3, 'multiple_choice', 'What is the impact of a poorly designed research interface on user engagement?', '[\"It increases user engagement and motivation\",\"It has no impact on user engagement\",\"It decreases user engagement and motivation\",\"It leads to increased errors and data loss\"]', 'It decreases user engagement and motivation', 'A poorly designed research interface can lead to frustration and decreased user engagement, as users may struggle to navigate and use the system, ultimately reducing their motivation to continue using it.', 6, '2026-04-27 04:45:44');

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

--
-- Table structure for table `quiz_responses`
--

CREATE TABLE `quiz_responses` (
  `id` int(10) UNSIGNED NOT NULL,
  `attempt_id` int(10) UNSIGNED NOT NULL,
  `question_id` int(10) UNSIGNED NOT NULL,
  `user_answer` text DEFAULT NULL,
  `is_correct` tinyint(1) DEFAULT 0,
  `time_taken` int(10) UNSIGNED DEFAULT 0,
  `answered_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `remember_tokens`
--

CREATE TABLE `remember_tokens` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `token_hash` varchar(64) NOT NULL,
  `expires_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `remember_tokens`
--

INSERT INTO `remember_tokens` (`id`, `user_id`, `token_hash`, `expires_at`, `created_at`) VALUES
(2, 1, 'c6dd14666b3c18e5927d01baf213c78d9861326c5cffcb71b1a1891f52b9a7af', '2026-05-17 00:41:49', '2026-04-17 06:41:49'),
(3, 1, '5fa1359e51c2072bdb294c106d523495156a5b33d4f31f2c42dc3ae972c3e484', '2026-05-17 00:42:01', '2026-04-17 06:42:01'),
(6, 5, '1c9f9d8e26972cbf266077e7b2b4d5e2a66753c6f4d4f22ec495a15f4d5a011b', '2026-05-22 00:54:42', '2026-04-22 06:54:42'),
(7, 7, '72100a9eef41b475d39ace3a1b4df706431d29ba5b24121495e3ac915457bdfa', '2026-05-23 02:18:39', '2026-04-23 08:18:39'),
(8, 8, '0aaeffb5a6136f338d07b67532d4a1e19560ec685e8071bc5eb97ddf070e4c2f', '2026-05-26 22:29:01', '2026-04-27 04:29:01'),
(9, 3, 'f3b7f633d15310e29b9e3870e0560ec3fcf18826496af72ba1d12ee35f594ba8', '2027-04-26 22:31:06', '2026-04-27 04:31:06');

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

--
-- Table structure for table `study_sessions`
--

CREATE TABLE `study_sessions` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `minutes` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `session_date` date NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `study_sessions`
--

INSERT INTO `study_sessions` (`id`, `user_id`, `subject`, `minutes`, `session_date`, `created_at`) VALUES
(1, 1, NULL, 25, '2026-04-17', '2026-04-17 11:20:46'),
(2, 1, NULL, 25, '2026-04-17', '2026-04-17 11:21:35'),
(3, 1, NULL, 25, '2026-04-20', '2026-04-20 02:26:03'),
(4, 1, NULL, 25, '2026-04-20', '2026-04-20 08:58:27'),
(5, 1, NULL, 25, '2026-04-23', '2026-04-23 05:43:35');

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

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `code` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `instructor` varchar(100) DEFAULT NULL,
  `schedule` varchar(200) DEFAULT NULL,
  `room` varchar(50) DEFAULT NULL,
  `color` varchar(7) DEFAULT '#0ea5e9',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `description` text DEFAULT NULL,
  `subject` varchar(100) DEFAULT NULL,
  `priority` enum('low','medium','high','urgent') DEFAULT 'medium',
  `status` enum('todo','in_progress','done') DEFAULT 'todo',
  `due_date` date DEFAULT NULL,
  `due_time` time DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `user_id`, `title`, `description`, `subject`, `priority`, `status`, `due_date`, `due_time`, `completed_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'Jzjzjz', 'Jzjzjz', 'Bzbs', 'medium', 'todo', '2026-04-16', NULL, NULL, '2026-04-27 03:38:12', '2026-04-27 03:38:12'),
(2, 3, 'FF', 'DFGFD', 'RTRE', 'high', 'done', '2026-04-14', NULL, '2026-04-26 22:23:51', '2026-04-27 04:22:48', '2026-04-27 04:23:51');

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

--
-- Table structure for table `uploaded_docs`
--

CREATE TABLE `uploaded_docs` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  `original_name` varchar(255) NOT NULL,
  `stored_name` varchar(255) NOT NULL,
  `mime_type` varchar(80) NOT NULL,
  `file_size` int(10) UNSIGNED NOT NULL,
  `extracted_text` mediumtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `uploaded_docs`
--

INSERT INTO `uploaded_docs` (`id`, `user_id`, `session_id`, `original_name`, `stored_name`, `mime_type`, `file_size`, `extracted_text`, `created_at`) VALUES
(2, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'platform.docx', 'a95e1c4d7bf3ce4c951c1cf40631468f.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 28196, 'I. INTRODUCTION TO PLATFORM TECHNOLOGIES Platform Technologies are the foundation or environment where applications, services, and systems are built and run. Think of a platform as the “digital stage” where other apps perform. A platform provides: tools services infrastructure APIs storage communication rules user management security This allows developers to build systems faster without starting from zero. A platform is the underlying digital foundation that supports apps, services, and integrations. Simple Analogy Imagine building a house. The platform = the land + foundation The application = the house built on top Without a strong foundation, the house becomes unstable. The same idea applies to digital systems. II. CORE CONCEPTS OF PLATFORMS A platform is a stable digital environment where systems interact. Examples include: Operating Systems Windows Linux Android iOS Cloud Platforms AWS Azure Google Cloud Web Platforms Browsers Web servers frameworks AI Platforms ChatGPT Gemini Claude These platforms make development easier by offering reusable tools. III. CHARACTERISTICS OF A ROBUST PLATFORM A good platform must have strong qualities. 1) Openness and Extensibility This means the platform can be: expanded customized integrated improved Developers can add: plugins modules extensions APIs third-party services Example: A Learning Management System can add: quiz modules attendance tracking AI tutor grade analytics 2) Scalability Scalability means the platform can handle increasing users, data, and traffic. Example: A student portal with 100 users today may have 10,000 users next year. A scalable platform still performs well. Types: Vertical Scaling → stronger server Horizontal Scaling → more servers 3) Security Security protects: user accounts passwords payments records transactions private data Examples: login authentication role-based access encryption firewalls OTP verification This is very important for: banking apps school portals health systems POS systems 4) Interoperability Interoperability means different systems can communicate smoothly. This is often done using APIs. Example: A school system connects with: SMS notifications payment gateway grade database QR attendance scanner 5) Reliability and Availability The platform should be: stable always accessible low downtime fast recovery Example: A clinic system should work 24/7, especially during emergencies. 6) Developer Tools and APIs Platforms should provide tools that help developers. Examples: SDKs documentation code libraries REST APIs testing tools APIs are one of the most important parts because they define how systems talk to each other. 7) Data Management and Analytics Modern platforms must manage: user data logs reports dashboards trends analytics Example: A student platform can analyze: failing subjects attendance patterns late submissions average grades 8) Cost Effectiveness The platform should be affordable. Example: A startup may prefer: open-source cloud pay-as-you-go serverless architecture instead of buying expensive infrastructure. 9) Community Support Popular platforms are easier to use because many developers already use them. Examples: Stack Overflow GitHub documentation forums community plugins 10) Compliance and Governance Platforms should follow rules and policies. Examples: Data Privacy Act GDPR audit logs access monitoring school governance rules IV. BROAD TYPES OF PLATFORMS These are the technical categories. 1) Operating System Platform Examples: Windows Linux Android Function: Controls hardware and software resources. 2) Database Platform Examples: MySQL PostgreSQL MongoDB Function: Stores and manages structured data. 3) Mobile Platform Examples: Android iOS Flutter ecosystem Used for: mobile apps notifications GPS apps e-wallets 4) Cloud Computing Platform Examples: AWS Azure Google Cloud Used for: hosting deployment storage serverless apps AI services 5) IoT Platform IoT means devices connected to the internet. Examples: smart agriculture smart homes clinic sensors weather stations This is useful in Albay disaster monitoring systems. 6) Blockchain Platform Used for: secure transactions transparent records voting systems digital certificates 7) Security Platform Examples: SIEM identity management zero-trust security Used for cybersecurity. V. SPECIFIC PLATFORM CATEGORIES BY USE CASE These are the platforms users experience daily. 1) Social Media / Networking Platforms Purpose: People connect and share information. Examples: Facebook LinkedIn X Threads Use cases: career development communities announcements microblogging 2) Service and Marketplace Platforms These connect service providers with customers. Examples: Grab Uber Airbnb Upwork Functions: booking payments location ratings reviews These are called two-sided platforms. 3) Content Sharing and Media Platforms Examples: YouTube TikTok Pinterest Purpose: video sharing tutorials reels educational content visual references 4) Communication and Collaboration Examples: Messenger WhatsApp Discord Slack Microsoft Teams Purpose: meetings file sharing messaging remote collaboration 5) Knowledge and Educational Platforms Examples: Wikipedia W3Schools Stack Overflow Moodle Purpose: tutorials code solutions research self-paced learning 6) Transactional and Financial Platforms Examples: POS systems GCash Maya banking apps Functions: payments receipts wallet balance QR code scanning 7) Generative AI Platforms Powered by LLMs (Large Language Models). Examples: ChatGPT Gemini Claude Functions: text generation image understanding code generation summarization voice/video processing 8) ERP Platforms ERP = Enterprise Resource Planning Used in businesses for: HR payroll inventory accounting POS sales logistics VI. TECHNICAL COMPONENTS – WEB AND APIs This explains how platforms are built. A. Web Platforms Split into: Front-end What users see. HTML CSS JavaScript Back-end What happens behind the scenes. PHP Node.js Python Java SQL B. API (Application Programming Inter', '2026-04-15 05:20:59'),
(5, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'INTRODUCTIONv3.docx', '5f8c85141fb035d6b66b72c70a6fc2b7.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 102066, 'PLT COLLEGE OF GUINOBATAN, INC College of Information Technology CAP101 – BSIT 3 CAPSTONE PROJECT AND RESEARCH 1 INTRODUCTION Prepared by: Evangelio, Joriz* BSIT 3, Nebres, Ivan Carlo* BSIT 3, Palaje, Jirwen BSIT 3, 23-7523 Simeon, Althea Mhae* BSIT 3, Suarez, Abegail BSIT 3, 23-7673 * Absent Submitted to: JOMAR CONSORTE, LPT, MIT Faculty, BSIT BACKGROUND OF THE STUDY Over the past few years, students have faced increasing academic demands that require effective management of time, tasks, and study routines. Poor time allocation and procrastination have been linked to reduced academic performance and heightened stress, highlighting the importance of self-regulation and time management for student success (Valente et al., 2024). With the rapid expansion of digital technologies, students increasingly rely on technological tools to support their study routines. Strategic and goal-oriented use of digital tools has been shown to enhance student engagement, motivation, and academic performance (Cancer et al., 2025). However, many existing tools focus on isolated functions and lack integration, personalization, and adaptability to meet diverse academic needs (Li et al., 2026). Time management strategies, such as the Pomodoro Technique, which breaks work into focused intervals with short breaks, have been shown to improve focus, reduce fatigue, and enhance productivity (Ogut, 2025). When combined with Artificial Intelligence (AI), these strategies can further boost efficiency (ONLIFE, 2024). AI, the simulation of human intelligence in machines, is transforming education by adapting to individual student needs, streamlining administrative tasks, and providing actionable insights through data analytics (Al-Deek, n.d.; eSchool News, 2024). Beyond functionality, the visual design of these digital tools plays a crucial role in sustaining student focus. Modern user interface paradigms, such as Neumorphism (Soft UI), help prevent digital fatigue by creating a tactile, minimalist environment. By reducing visual clutter, Neumorphic design lowers extraneous cognitive load, allowing students to maintain deeper concentration on their academic tasks. In the Philippines, Universities have explored AI-based tools to enhance learning, improve assessment, and provide timely feedback (Dabu, 2024; Estrellado et al., 2023). Government initiatives, such as the National AI Roadmap, the establishment of the National Centre for AI Research (N-CAIR), and local programs like the Albay Institute of Artificial Intelligence (AIAI), reflect a commitment to leveraging AI to improve education and productivity (Yusop, 2025; DitoSaPilipinas, 2025). This study will be conducted at PLT College of Guinobatan, Inc. (PLTCGI), a private higher education institution in San Francisco, Guinobatan, Albay. The institution provides a suitable environment for assessing students productivity, study habits, and use of digital learning tools. The proposed system, SPACE (Smart Productivity and Academic Companion for Education), aims to help students manage tasks, schedules, and notes efficiently, ultimately enhancing academic performance and productivity. PROBLEM STATEMENT This research will be conducted to determine the effectiveness of SPACE: Smart Productivity and Academic Companion for Education of PLT College of Guinobatan Inc. Students. Specifically, this study sought to answer the following questions: What problems do students encounter in managing academic tasks, notes, and schedules? What features should be included in the SPACE system to improve student productivity? How can a centralized academic productivity system be designed and developed for students? How effective is the system in terms of: Functionality Usability Efficiency portability reliability, and security RESEARCH QUESTIONS This study seeks to answer the following: How can Neumorphic design be applied to a web-based productivity system to reduce cognitive load among students? How effective is the SPACE system in terms of functionality, usability, efficiency, portability, reliability, and security? How does integrating a Pomodoro Timer, Task Manager, and Note-Taker into one platform impact student productivity? RESEARCH OBJECTIVES To achieve and assess what this research will come to, the researchers aim: To design and develop a responsive web application using a Neumorphic UI that provides students with a calming, tactile, and distraction-free workspace. To implement a unified dashboard that seamlessly integrates a note-taker, task manager, and a JavaScript-powered Pomodoro timer into one study hub. To evaluate the performance of the system using PHP and MySQL to ensure that all student data is saved securely and updates instantly across devices. To assess user satisfaction among PLT College students using the System Usability Scale (SUS) to confirm that the platform effectively reduces study-related stress. SIGNIFICANCE OF THE STUDY The development of SPACE (Smart Productivity and Academic Companion for Education) is expected to provide valuable benefits to the following: Students. It provides a centralized, Neumorphic environment that reduces \"app fatigue\" by merging notes, tasks, and timers into one place. This helps students manage their cognitive load, improve focus during study sessions, and maintain an organized record of their academic responsibilities. Faculty. Faculty members benefit from this when students utilize structured productivity tools, they are more likely to meet academic deadlines and submit higher-quality work, leading to a more efficient and productive teaching-learning environment. PLT College Of Guinobatan Inc. The institution benefits from the digital modernization of student support tools. Successful implementation demonstrates the college’s commitment to tech-driven learning and showcases the technical capabilities of its Information Technology department. Researchers. This study allows the researchers to bridge the gap between theory and pract', '2026-04-15 09:19:49'),
(6, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'Intro to Platform.pdf', 'aba6fb2732713921a1d25a3ea9ab39a1.pdf', 'application/pdf', 1387871, 'G 6 m ] @ \0? u \0? m  @ 6 Q m @ Q \0? + \0? m \\n @ ] 4 Q \0? \0? \0?  6 @ + @   \0? d \0J \0? \0l \0? \0? \0? \0? \0? \0? \0 \0l \0? \0? \0 \0? \0? \0? \0 \0| \0? \0? \0? \0? \0l \0? \0 \0? \0? \0l \0? \0? \0 \0? \0? \0? \0? \0? \0 \0l \0? \0? \0? \0? \0x \0l \0? \0? \0? \0? \0? \0 \0? \0? \0? \0? \0? \0? \0? 9 \0? \0? \0? \0? \0? \0| \0? \0? \0? \0 \0? \0? \0? \0? \0? & \0 \0? \0? \0? \0? \0? \0x \0? \0? & \0 \0? \0? \0? \0? \0l \0? \0? \0? \0? \0x \0? \0? \0? \0? & \0 \0 \0J \0& \0? & \0 \0? \0? \0? \0? \0l \0? \0? & \0 \0x \0? \0? \0? \0? \0? \0? \0x \0l \0? \0? \0? \0? \0 \0x \0? \0l \0? \0? \0? \0? \0? & \0 \0? \0? \0? \0? \0 \0? \0l \0? \0l \0? \0? \0? \0? \0? \0? & \0 \0l \0? \0| \0 \0? \0? \0x \0? \0? \0? \0? \0? + \0 \0V \0? \0? \0? \0 \0? \0? \0? \0 \0| \0? \0? \0? \0? \0? \0? \0? \0? \0? \0 \0w \0? \0? \0? \0| \0 \0? \0l \0? \0? \0? \0? \0 \0w \0? \0 \0? \0? \0? \0? \0? \0? \0? \0 \0x \0? \0? \0? \0 \0x \0l \0? \0l \0w \0? \0? \0? \0? \0? \0? \0? \0 \0? \0? \0? \0? \0? \0l \0| \0 \0? \0? \0 \0? \0? \0? \0? \0? \0? \0? \0? \0? \0? \0? \0 \0? \0? \0? \0 \0? \0? \0? \0? \0| \0l \0? \0? \0? \0? + \0 \0? \0l \0? \0? \0? \0? % \0 \0V \0? \0? \0 \0? \0? \0l \0? \0? \0? \0? \0? \0 \0? \0? \0 \0? \0? \0? \0 \0? \0l \0? \0| \0 u \0 \0? \0? \0? \0? \0| \0l \0? \0? \0? \0? 0 \0 \0l \0? \0 \0l \0? \0? \0? \0? \0x \0l \0? \0? \0? \0? \0 \0? \0? \0 \0? \0? \0? \0 \0? \0? \0? \0? \0? \0 \0w \0? \0? \0? \0? \0 \0? \0? \0 \0? \0? \0? + \0 \0 \0 \0? \0? \0l \0? \0 \0? \0? \0? \0? \0| \0l \0? \0? \0? \0? \0 \0? \0l \0? \0? \0? \0 \0? \0? \0? \0 \0? \0? \0? \0? \0? \0 \0? \0? \0? \0? \0l \0w \0? \0? 9 \0? \0l \0? \0? \0 \0? \0? \0? \0 \0| \0? \0? \0? \0? \0l \0? \0 \0? \0? \0? \0? \0? \0? \0? + \0 @ ] \0? Q \0 @ 6 \0? \0? Z m d  Q \0?  \0? m Q \0 @ u 6 m d Q \0? d Q \0? Q \0? + \0? m \\n @ ] 4 % \0mZ\0?] \0?m 6 Q \0? ? d m\0?4d \0c \0? \0? \0| \0? \0? \0? & \0 \04 \0? \0? \0? \0? & \0 \0 \0? \0| \0? \0? \0? \0| & \0 \0? \0@ \0Q \0 9 \0 \0? \0l \0? \0l \0? \0? \0 \0? \0l \0? \0| \0? \0l \0? \0? \0 \0l \0? \0| \0 \0? \0? \0? \0? \0? \0? \0? \0 \0? \0? \0? \0 \0l \0? \0? \0? \0? \0x \0l \0? \0? \0? \0? \0? + \0+@u\0? Q \0?+\0?m\\n @]4d \0 \0c \0Q & \0 \0 \0? \0? \0? \0? & \0 \0! \0 \0J \0 9 \0 \0? \0? \0? \0? \0? \0| \0?\0 \0? \0? \0? \0? \0? \0? \0? & \0 \0? \0? \0? \0? \0? \0? \0? \0? \0? \0? & \0 \0? \0? \0? \0? \0l \0? \0? & \0 \0l \0? \0| \0 \0? \0l \0? \0l \0? \0? \0| \0 \0? \0? \0? \0? \0? \0x \0? \0? + \0? \0?\0?Q\0?+\0?m\\n @]4d Q ?Q\0: ] \0?4 \0? ? @]\\( d \0 \0? \0? \0? \0? \0? \0? \0? & \0 \0? \0? \0w \0 \0? \0? \0? \0? \0? \0? \0? & \0 \0l \0? \0| \0 \0? \0? \0l \0? \0? \0? \0? \0? \0? \0? \0 \0? \0? \0l \0? \0 \0? \0? \0? \0? \0? \0 \0? \0? \0w \0 \0l \0? \0? \0? \0? \0x \0l \0? \0? \0? \0? \0? \0 \0l \0? \0| \0 \0| \0? \0? \0? \0? \0? \0? \0? \0? \0 \0? \0? \0? \0? \0? \0? \0? \0? \0x \0? + \0\0GQ\0?+\0?m\\n @]4d \04 \04 \0: ; \0w \0l \0? \0? \0|\0 \0? \0? \0l \0? \0? \0? \0? \0? \0? \0 7 \0 \0? \0l \0? \0! \0J \0V & \0 \0! \0? \0? \0? \0? \0? & \0 \0 \0? \0l \0? \0| \0? 8 \0 \0? \0? \0l \0? \0 \0? \0? \0? \0? \0? \0 \0? \0? \0? \0? \0? \0l \0? \0? \0? \0? \0 \0l \0? \0| \0 \0l \0? \0l \0? \0? \0? \0? \0x \0 \0x \0l \0? \0l \0w \0? \0? \0? \0? \0? \0? \0? \0 \0? \0? \0l \0 \0 \0J \0& \0? + \0\0\0\0\0m\0?\0?\0?\0?\0?\0?\0? (+46@Z]dmu?\0\0\0\0Z\0\0 \0\0\0?\0?\0\0 \0\0\0?\0\0 \0\0\0?\0\0 \0\0*\0\\\0\0 \0\0\0?\0\0 \0\0F\0\0\0 \0\0\0\0\0K\0a\0n\0i\0t\0-\0L\0i\0g\0h\0t\0V\0e\0r\0s\0i\0o\0n\0 \02\0.\00\00\00\0;\0 \0t\0t\0f\0a\0u\0t\0o\0h\0i\0n\0t\0 \0(\0v\01\0.\08\0.\03\0 \0h\0t\0t\0p\0s\0:\0/\0/\0g\0i\0t\0h\0u\0b\0.\0c\0o\0m\0/\0c\0a\0d\0s\0o\0n\0d\0e\0m\0a\0k\0/\0k\0a\0n\0i\0t\0 ,? +-? M (Z2Wf,qz-](\'[ O?`i?UHB|Vw?I \0\0F\0\0??\0 \0/@,\0\0g\0\0_\0\0\0(M\0_ M M ?\0 \0\0+@(\0\0g\0\0_\0\0\0(M ?\0\0\03@0L\0\0g\0\0_\0\0\0(M @% \0L\0\0(M U??\"TZ??3>1#??\0\0\02\0\0\0??\0\0 \0XK?$PX@\0_\0\0\0*M\0_\0+M ;(I?6\"\"%SV??3?0\Z!??1<5#\Z??\0\0\0F\0\0??\0\0Q@ \0LK?PX@\0\0a\0\0+M  ?\0\0\0q@\0\ZLK?PX@\0\0a\0\0+Ma\0/M-N@!\0a\01Ma\0/M\0_\0\0\0+NY@\0\0\0\0$#+36632#\"\'2654&#\"FF!O5drre]A?PKFS \07@4\0L\0a\01M\0\0a\0\0/\0N\0\Z\0((+\"&\'532654&&\'.54632&#\"?.S\"K%?6;. \0\0??\0 \0&@# \0L\0\0+M ;(AV,T ]6kk7-+VZ?-@15%:4F_T7E&&+\"?AA\0\02??l?\0 \0,\06\0K@H10\0L\0?\0a\0.M\0a\0\0/\0N.-\0-6.6(& \0  +\"&5467&&546326553\'6654&#\"267\'dxTI\'6SLJR:6?AZ2P#pM/0 ?5 Adobe UCS ??? ? \0K?HRX??Y?\0\0\0cp?\0B?-\0*?\0B? *?\0B?**?\0B?@?? *?\0 B?@@ *?dD?$?QX?@?X?dD?&?QX??\0@?cTX?dDYYYY?\" *??????\0D\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\0\0\0 \0 \0v\01\0.\01\0 \0c\0 \0c\0 ,? +-? \0G\0\0\0\0^\0X\0\"H#I#!!\Z+##32#3254&##G|\\?txNL?k????JF?+???dWI]??qy9@\0\0\06???\0\'\04@1\0\0G\0X\0*H\0\0\0X+I\0\0\0\'\0&#,$+&\'732654&&\'.54632&#\"#?p/ TvDZ*?8CQ9?dxY P_=N*>7CR:>qJ D<B9#0(I9Zb?B::7\". \0!\0,\03@0(\'!\0\0G\0X\0-H\0X\0\0+\0I#%$ 3_Q?P8eVJ[2T5%p?VM?w(!\"I09_L  (II73C,\'x @{Va?B(!??4? yjka??\0\0\0/???(\0\01@. \0 G\0\0X\0\0\0-H\0X.I\0\0\0\0\Z$%&+&&546632&&#\"3267#?t9;xY1Z!H&T]WO1L\"\"\"c<M?ON?N!?\Zwabv \0,\08\0F\0V@S\0\" \0G \0\0\0`\0%H\0X\0-H\0Y\0#H\0X\0/I--CA<9-8-731,+*(%6& +\'#\"\'332#\"&5467&5467&&5466323654&#\"3+32665&u,X@! $?IQN?Tna*,<&,$&,Y@4+??;:32::2?T? %&?;<b8? -80Q1!F;9_6O< \0\"\05@2 \0G\0%HX-H\0\0#\0I\0\0\0\"\0!\"## +\0#4&#\"#4&#\"#363263??Y%-#H-Y%-\"H-YE `U7@dW(\\X??l?6## ??l?6\"#?d8J(&N\0\0\0^\0\0(\0\0.@+ \0G\0%H\0X-H\0\0#\0I\0\0\0\0#+\0#4&#\"#363?CY(1%L-YE a[(]W??l?6\"#?d8J\0\0\0/??0(\0\0\0,@ 2D?\\????\\R F<P!?P?\0\0+\0\0?\0 \0/@,\0G\0V\0%H\0V\0\0\0#\0I\0\0\0 \0 +%!5!5!??Y5?????CC/?C3?`\0\0O??\0??\0 \0\0*@\'\0\0\0`\0X+I \0\0  \0 \0 $+&54632#&54632#s$$$#\Z$$$#\Z?$$$$?w$$$$\0\0+?b\0?\0n\0 \0? -+654\'7+=Z >6u Adobe UCS \0\" \0? ? \0? + @ Z \0? ] Q \0? @ @ + d  Q \0\" \0? m \0? Q ? Q \0 @ d m \0J \0? \0l \0? \0? \0? \0? \0? \0? \0 \0? \0? \0? \0? \0? \0| \0 \0? \0? \0? \0? \0? \0| \0? \0 \0Q \0 \02 \0? & \0 \0x \0? \0? \0? \0? \0? \0 \0? \0? \0w \0? \0l \0? \0? \0? \0? & \0 \0? \0? \0? \0? \0? \0? \0? \0 \0? \0? \0? \0? \0? & \0 \0l \0? \0| \0 \0? \0? \0? \0? \0? \0? \0? \0? \0 \0| \0? \0x \0? \0? \0? \0? \0? \0l \0? \0? \0? \0? 9 \0? \0? \0? \0? \0? \0 \0? \0? \0? \0? \0| \0 \0| \0? \0? \0? \0? \0? \0? \0? \0? \0? \0? \0 \0l \0? \0| \0 \0? \0? \0| \0? \0x \0? \0 \0? \0? \0? \0? \0l \0? \0? \0? + \0 \0? \0G d \0 \0? \0? \0? \0? \0? \0 \0? \0? \0? \0 \0? \0? \0? \0? \0? \0? \0? \0 \0x \0? \0? \0? \0? \0? \0? \0x \0l \0? \0? \0 7 \0M \0 \0Q \0V & \0 \0? \0? \0w \0? \0? \0? \0? \0? &\0 \0? \0M \0J \0 8 + \0 \0 \0? \0? \0? \0 \0? \0? \0 \0? \0? \0? \0? \0?', '2026-04-15 09:32:34'),
(7, 2, 'e64704c8a46a2a798c8b566a3ed73c44', 'AI_SUMLANG.docx', '05d5ff94eba82b28c920ce4133a1a0bf.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 124454, 'Author PLT THESIS-INTRO - SUMLANG 02(1)_5000words Turnitin Turnitin Document Details 23 Pages 4,959 Words 35,917 Characters Submission ID trn:oid:::20755:525741648 Submission Date Mar 16, 2026, 4:59 PM GMT+5 Download Date Mar 16, 2026, 5:00 PM GMT+5 File Name THESIS-INTRO - SUMLANG 02(1)_5000words.docx File Size 58.3 KB 0 % detected as AI The percentage indicates the combined amount of likely AI-generated text as well as likely AI-generated text that was also likely AI-paraphrased. Caution: Review required. It is essential to understand the limitations of AI detection before making decisions about a student’s work. We encourage you to learn more about Turnitin’s AI detection capabilities before using the tool. 0 % detected as AI The percentage indicates the combined amount of likely AI-generated text as well as likely AI-generated text that was also likely AI-paraphrased. Caution: Review required. It is essential to understand the limitations of AI detection before making decisions about a student’s work. We encourage you to learn more about Turnitin’s AI detection capabilities before using the tool. Detection Groups 0 AI-generated only 0% Likely AI-generated text from a large-language model. 0 AI-generated text that was AI-paraphrased 0% Likely AI-generated text that was likely revised using an AI-paraphrase tool or word spinner. Disclaimer Our AI writing assessment is designed to help educators identify text that might be prepared by a generative AI tool. Our AI writing assessment may not always be accurate (it may misidentify writing that is likely AI generated as AI generated and AI paraphrased or likely AI generated and AI paraphrased writing as only AI generated) so it should not be used as the sole basis for adverse actions against a student. It takes further scrutiny and human judgment in conjunction with an organization\'s application of its specific academic policies to determine whether any academic misconduct has occurred. Frequently Asked Questions 553720018834How should I interpret Turnitin\'s AI writing percentage and false positives? The percentage shown in the AI writing report is the amount of qualifying text within the submission that Turnitin’s AI writing detection model determines was either likely AI-generated text from a large-language model or likely AI-generated text that was likely revised using an AI paraphrase tool or word spinner. False positives (incorrectly flagging human-written text as AI-generated) are a possibility in AI models. AI detection scores under 20%, which we do not surface in new reports, have a higher likelihood of false positives. To reduce the likelihood of misinterpretation, no score or highlights are attributed and are indicated with an asterisk in the report (*%). The AI writing percentage should not be the sole basis to determine whether misconduct has occurred. The reviewer/instructor should use the percentage as a means to start a formative conversation with their student and/or use it to examine the submitted assignment in accordance with their school\'s policies. What does \'qualifying text\' mean? Our model only processes qualifying text in the form of long-form writing. Long-form writing means individual sentences contained in paragraphs that make up a longer piece of written work, such as an essay, a dissertation, or an article, etc. Qualifying text that has been determined to be likely AI-generated will be highlighted in cyan in the submission, and likely AI-generated and then likely AI-paraphrased will be highlighted purple. Non-qualifying text, such as bullet points, annotated bibliographies, etc., will not be processed and can create disparity between the submission highlights and the percentage shown. INTRODUCTION Tourism is one of the most dynamic and competitive industries globally. According to the World Tourism Organization (2017), it ranks as the third largest export sector worldwide, after fuels and chemicals, and serves as a primary source of foreign exchange for many developing nations. Beyond economic contributions, tourism drives employment, infrastructure development, regional growth, and export diversification. Globalization and technological advancement have intensified competition among destinations. Countries now compete not only on natural and cultural attractions but also on service quality, innovation, sustainability, and overall visitor experience. This shift has placed destination competitiveness at the forefront of strategic tourism planning. Competitiveness is a widely discussed research theme across academic fields. While Michael Porter\'s work on competitive advantage serves as a foundational reference for studies on tourist destination competitiveness, Smith, in the late 1970s, helped establish competitiveness as a distinct field of scientific inquiry. Because tourism is fundamentally service-driven, researchers have adapted existing terminologies, developed new conceptual models, and identified specific elements that drive success in the tourism sector. Competitiveness is now widely regarded as essential for a destination\'s success and long-term prosperity (Go &amp; Govers, 2000; Gooroochurn &amp; Sugiyarto, 2005; Mazanec et al., 2007). It is therefore crucial for destinations to be aware of the strategic actions required to become more competitive than others vying for the same pool of visitors. In tourism, destination competitiveness refers to a place\'s capacity to attract and satisfy visitors while maintaining its environmental, social, and economic sustainability for future generations. Studies over the past three decades confirm that competitiveness determines a destination\'s long-term survival and prosperity (Go &amp; Govers, 2000; Gooroochurn &amp; Sugiyarto, 2005; Mazanec et al., 2007). As global tourism expands, so do environmental pressures. Unmanaged activities such as transportation, accommodation development, and visitor congestion can negatively affect fragile ecosystems. In response, sustai', '2026-04-15 09:33:20'),
(8, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'Module1_EventDriven_Python.docx', '443f874c586cd7abee6c5e2036ebb588.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 19824, 'PYTHON PROGRAMMING SERIES Module 1 Foundations of the Event-Driven Paradigm Understanding core concepts that distinguish event-driven programming from traditional procedural or linear scripts Topics Covered Activities Estimated Time 1.1 Introduction to EDP Paradigm sort, real-world analogies ~25 min 1.2 Core Components Trace event loop, write callbacks ~30 min 1.3 Practical Application Console REPL, digital clock lab ~45 min Review &amp; Assessment Knowledge check, challenge problems ~20 min 1.1 Introduction to Event-Driven Programming What Is Event-Driven Programming? Event-driven programming (EDP) is a paradigm in which execution is controlled by external events — user actions, sensor signals, messages, or system notifications — rather than a fixed top-to-bottom sequence. Key Definition An event-driven program waits idle (or performs background work) until an event occurs. It then dispatches that event to the appropriate handler, executes it, and returns to waiting. Characteristics of Event-Driven Systems Asynchronous execution: code does not run in a strict top-to-bottom order. Decoupling: event producers (sources) are separate from event consumers (handlers). Responsiveness: the system reacts instantly when an event fires. Non-blocking: waiting for one event does not freeze other parts of the program. Scalability: many event types can be handled independently and concurrently. Comparison: Procedural vs. Event-Driven Procedural / Linear Event-Driven Instructions execute top-to-bottom Execution is driven by incoming events Control flow set by the programmer Control flow set by the user or system Program finishes and exits Program loops, listening continuously Easy to trace step-by-step Requires understanding callbacks &amp; state Good for scripts and data pipelines Good for GUIs, games, servers, IoT Example: monthly payroll calculator Example: chat app responding to messages Real-World Analogies Recognise event-driven systems in everyday life before writing code: Analogy Event Handler / Response Smartphone User taps the screen Open the tapped app Traffic light Timer or sensor fires Change light colour Fire alarm Smoke detector triggers Sound siren, unlock exits Customer service Phone rings Agent picks up and responds Email inbox New message arrives Show notification + badge Discussion Prompt 💬 Think of three more real-world event-driven systems you interact with daily. For each one identify: (a) the event source, (b) the event, and (c) the handler. Share and discuss your examples with a partner before moving on. 🧪 Activity 1.1A — Paradigm Sort Time: 10 minutes | Type: Individual or pair Instructions: Read each scenario. Label it Procedural (P) or Event-Driven (E). Write one sentence explaining your choice. Scenarios: 1. [ ___ ] A script reads a CSV file, calculates totals, and writes results to a new file. 2. [ ___ ] A web server waits for HTTP requests and responds to each one independently. 3. [ ___ ] A program reads student grades from top to bottom and prints each grade. 4. [ ___ ] A game character moves left whenever the player presses the left arrow key. 5. [ ___ ] A temperature logger records sensor readings every 5 minutes automatically. 6. [ ___ ] A button in a mobile app shows a menu when tapped by the user. Answer Key: P, E, P, E, P, E 1.2 Core Components of Event-Driven Systems Events An event is any occurrence the program can detect and respond to. Events fall into five categories: User input: keyboard presses, mouse clicks, touch gestures, form submissions. System: timer expirations, file-system changes, OS signals, memory alerts. Network: incoming socket data, HTTP responses, WebSocket messages. Hardware/sensor: GPIO pin changes, temperature thresholds, motion detection. Application: custom events raised by your own code (e.g., &apos;orderPlaced&apos;). The Event Loop The event loop is the central dispatcher. It continuously polls for new events and routes each one to its registered handler. A simplified pseudo-loop: # Simplified Event Loop (pseudo-code) event_queue = [] while True: # 1. Loop forever if event_queue: # 2. Are there pending events? event = event_queue.pop(0) # 3. Dequeue the next event handler = registry[event] # 4. Look up the registered handler handler(event) # 5. Execute it else: wait_for_event() # 6. Sleep until something arrives Python&apos;s asyncio Event Loop asyncio.get_event_loop().run_forever() enters the loop. Coroutines (async def) are tasks scheduled on the loop. I/O events (sockets, files) use OS-level selectors under the hood. You will explore asyncio in depth in Module 4. Callbacks and Handlers A callback (also called a handler) is a function registered to execute when a specific event fires. # Basic callback pattern def on_key_press(key): &quot;&quot;&quot;Handler: called whenever a key-press event fires.&quot;&quot;&quot; print(f&quot;Key pressed: {key}&quot;) # Register with an imaginary event system: event_system.on(&apos;key_press&apos;, on_key_press) # When user presses &apos;a&apos;, the system calls: # on_key_press(&apos;a&apos;) --&gt; Key pressed: a Three Ways to Define Callbacks in Python Named function: def on_click(event): ... — most readable; use for complex logic. Lambda: event_sys.on(&apos;click&apos;, lambda e: print(e)) — for simple one-liners. Method: event_sys.on(&apos;click&apos;, self.handle_click) — for object-oriented designs. 🧪 Activity 1.2A — Trace the Event Loop Time: 15 minutes | Type: Individual, then group review Read the code below. For each label (A–H) write what happens at that step. import time handlers = {} # (A) handler registry def register(event_name, fn): # (B) handlers[event_name] = fn def dispatch(event_name, data=None): # (C) if event_name in handlers: handlers[event_name](data) def on_tick(data): # (D) print(f&quot;Tick! Data: {data}&quot;) register(&apos;tick&apos;, on_tick) # (E) for i in range(5): # (F) dispatch(&apos;tick&apos;, data=i) # (G) time.sleep(1) # (H) # What happens at this step? (wr', '2026-04-16 03:07:40'),
(9, 1, '768fbd7e5ba3f1f567e242c3f5f5f6be', 'Modern-Computer-Parts-and-Hardware-An-Introductory-Guide.pdf', '295ad564942544d6a69bfeba7844de7b.pdf', 'application/pdf', 1584651, 'b @ \0? \0? ] 6 Q \0 @ 4 Z u m \0? ] Q \0? \0? ] m d Q ? Q \0B \0? ] \0? ? \0? ] \0? Q : Q \0 6 Q \0G 6 m ] @ \0? u \0? m @ ] ? Q \0; u  \0? \0? \0\0\0?\0?\0l\0x\0?\0?\0x\0l\0?&\0\0?\0?\0?\0?\0l\0?\0\0?\0l\0?\0?\0?\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0\0?\0?\0x\0?;\0x\0?\0?\0?\0?\0?\0?\0\0x\0?\0?\0?\0?\0?\0?\0?\0?\0\0l\0?\0|\0\0?\0?\0?\0?\0?;\0?\0?\0?\0?\0?\0\0J\0 \0 \0w\0?\0?\0?\0|\0?\0?\0?+\0\0V\0?\0?\0?\0\0|\0?\0x\0?\0\0?\0?\0?\0?\0l\0?\0?\0?\0\0x\0?\0?\0?\0\0x\0?\0?\0?\0?\0?\0?\0?\0?\0?&\0\0?\0?\0?\0\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0l\0x\0?&\0\0?\0?\0|\0?\0?\0?\0\0?\0?\0?\0?\0|\0? \0 78&\0\0l\0?\0|\0\0l\0x\0?\0?\0?\0?\0l\0w\0?\0?\0\0?\0?\0?\0?\0\0?\0?\0?\0\0w\0l\0?\0l\0?\0x\0?\0|\0\0?\0?\0?\0?\0?\0?\0\0w\0?\0?\0?\0|\0?+\0\0Q\0?\0?\0|\0?\0?\0\0?\0?\0?\0?\0l\0?\0?\0?\0|\0\0?\0?\0?\0% \0 \0?\0?\0?\0?\0?\0?\0?\0l\0?\0?\0?\0?+ \0B @ ? Q \0? Q \0? \0 Q \0? @ ] \\( d Q : Q \0? ? d m \0? 4 Q \0m ? \0? ] ?  \0? ? \0\0?\0\0l\0\0?\0?\0?\0?\0\0?\0?\0?\0?\0?%\0\0?\0?\0?\0\0\0J\0Y\0\0?\0?\0?\0x\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0x\0?\0?\0?\0?\0?&\0\0?\0?\0?\0\0!\0J\0Y\0\0?\0?\0?\0|\0?\0?\0?\0\0?\0?\0?\0?\0l\0?\0?\0\0l\0?\0| \0 \0l\0x\0x\0?\0?\0?\0?\0l\0?\0?\0?\0\0?\0l\0?\0l\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0l\0|\0?&\0\0M\0\0:\0\0?\0?\0?\0|\0?\0\0l\0x\0?\0?\0?\0?\0\0|\0l\0?\0l&\0\0?\0?\0?\0?\0l\0?\0?\0\0?\0?\0?\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?&\0\0?\0?\0? \0 \0?\0?\0?\0?\0?\0?\0w\0?\0l\0?\0|\0\0x\0?\0?\0?\0?\0x\0?\0?\0\0l\0?\0|\0\0x\0?\0?\0?\0|\0?\0?\0l\0?\0?\0?\0\0x\0?\0?\0?\0?\0?\0?\0?\0?\0?&\0\0?\0?\0?\0\0J\0Q\0Y\0\0?\0?\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?&\0\0l\0?\0| \0 \0x\0?\0?\0?\0?\0?\0?\0\0?\0l\0?\0?\0?\0l\0?\0?\0?\0\0?\0l\0?\0?\0\0?\0?\0?\0?\0?\0?\0l\0?\0?\0?\0?\0?+\0\0J\0?\0?\0?\0?\0?\0?\0l\0?\0x\0?\0\0|\0?\0?\0?\0?\0|\0?\0\0?\0?\0\0x\0?\0?\0?\0?\0?\0?\0?\0?\0\0w\0l\0?\0l\0?\0x\0? \0 \0l\0?\0|\0\0?\0?\0?\0?\0?\0?\0l\0x\0?\0\0w\0l\0?\0|\0?\0?\0|\0?\0?\07\0?+\0?+&\0\0J\0\0&\0?\0\0?\0l\0?\0?\0?&\0\0?\0?\0?\0?\0?\0?\0\0x\0?\0l\0?\0?\0?\0?\0?8+ \0 \0? \0? \0J\0?\0?\0x\0?\0?\0?\0?\0?\0\0?\0?\0l\0?\0\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0l\0?\0?\0\0l\0?\0|\0\0?\0l\0?\0l\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0\0?\0l\0?\0?\0?+ \0; \0? \0? \0$\0l\0?\0|\0?\0?\0?\0\0?\0?\0l\0?\0?\0?\0x\0?&\0\0?\0?\0?\0|\0?\0?\0?\0?\0?&\0\0l\0?\0|\0\0?\0l\0?\0?\0\0\0& 1 \0x\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0l\0|\0?+ \0? \0 \0b \0Q\0?\0?\0?\0?;\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0\0l\0x\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0l\0?\0?\0\0l\0?\0|\0\0|\0l\0?\0l+ \0? m @ ] \0?  \0? \04\0?\0?\0?;\0?\0?\0?\0?\0\0?\0?\0?\0?\0l\0?\0?%\0\0$\0\0\0?\0\0?\0?\0?\0\0x\0l\0?\0l\0x\0?\0?\0?&\0\0;\0b\0:\0?\0\0Q\0Q\0\0?\0\0?\0?\0?\0\0?\0?\0?\0?\0|+ \0 \0? \0? Q \0: u 6 \0? \0? 4 \0? 6 m \0? + d Q ? Q \0B ? \0? ]  \0? Q \0 ] \0?   m \0? \0? m u ] \0? d \0\0J\0Y\0?\0\0l\0?\0?\0\0?\0?\0?\0\0?\0?\0?\0?\0?\0?/\0?\0\0w\0?\0l\0?\0?9\0?\0?\0?\0x\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0x\0?\0?\0?\0?\0?&\0\0?\0l\0?\0l\0?\0?\0?\0?\0\0@\0Q\0\0?\0l\0?\0?\0?&\0\0l\0?\0| \0 \0x\0?\0?\0?\0|\0?\0?\0l\0?\0?\0?\0?\0\0?\0l\0?\0|\0?\0l\0?\0?+\0\0:\0?\0|\0?\0?\0?\0\0?\\n\0\0\0J\0Y\0?\0\0?\0?\0?\0\0?\0?\0w\0?\0?\0|\0\0l\0?\0x\0?\0?\0?\0?\0x\0?\0?\0?\0?\0?%\0\0J\0?\0?\0?\0?\0?\0?\0l\0?\0x\0? \0 \0x\0?\0?\0?\0?\07\0J;\0x\0?\0?\0?\0?8\0\0?\0?\0?\0\0?\0?\0l\0?\0?&\0\0?\0l\0?\0?\0?\0x\0?;\0?\0?\0?\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\07\0?\0l\0?\0?\0?\0?&\0\0?\0?\0?\0?\0?\0?;\0?\0?\0?\0?\0l\0|\0?\0|\0\0l\0?\0?\0?& \0 \0?\0?\0?\0|\0?\0?\0?\0?\0?8&\0\0l\0?\0|\0\0\0?\0?\0?\0x\0?\0?\0?\0x\0?\0\0x\0?\0?\0?\0?\07\0;\0x\0?\0?\0?\0?8\0\0?\0?\0?\0\0w\0l\0x\0?\0?\0?\0?\0?\0?\0|\0\0?\0l\0?\0?\0?\0\0l\0?\0|\0\0?\0?\0?\0?\0?\0\0?\0l\0?\0?\0?\0?\0?+ \0 \02\0?\0?\0\0?\0?\0?\0x\0?\0\0?\0?\0\0x\0?\0?\0?\0l\0?\0?%\0\0x\0?\0?\0?\0\0x\0?\0?\0?\0?&\0\0?\0?\0?\0?\0l\0|\0\0x\0?\0?\0?\0?&\0\0w\0l\0?\0? 1 \0w\0?\0?\0?\0?\0\0x\0?\0?\0x\0?\0\0?\0?\0?\0?\0|\0?&\0\0x\0l\0x\0?\0? \0 \0?\0?\0?\0?&\0\0V\0\0J&\0\0l\0?\0|\0\0?\0?\0x\0?\0?\0?\0\0x\0?\0?\0?\0l\0?\0?\0w\0?\0?\0?\0?\0?+ \0? 7 \0 @ ] \0? d \0$\0?\0?\0?\0\0?\0?\0?\0?\0?\0?;\0?\0?\0?\0?\0l\0|\0\0?\0?\0?\0?\0?\0?\0?\0l\0?\0x\0?& \0 \0?\0?\0?\0w\0?\0\0w\0?\0?\0?\0?\0\0x\0l\0?\0l\0w\0?\0?9\0?\0|\0?\0l\0?\0\0?\0?\0? \0 \0|\0?\0?\0l\0?\0|\0?\0?\0?\0\0l\0?\0?\0?\0\0l\0?\0|\0\0?\0?\0?;\0?\0l\0?\0?\0?\0x\0? \0 \0?\0?\0?\0?+ \0\\( 7 \0 @ ] \0? d \04\0?\0?;\0?\0?\0?\0?\0?\0\0x\0?\0?\0?\0?\0\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0l\0?\0?\0?\0?\0?& \0 \0w\0l\0x\0?\0?\0?\0?\0?\0?\0|\0\0?\0?\0?\0?\0?\0x\0?\0?&\0\0l\0?\0|\0\0?\0?\0?\0?\0?\0?\0?\0?\0? \0 \0?\0?\0?\0?\0x\0?\0?\0?\0x\0?+ \0m ? \0? ] \0? + @ \0? \\(  6   Q \0?  ?  Q \0B @ ?  Q \0? 6 \0? Q \0? \0? \\n \0? m ? \0@\0?\0?\0?\0x\0?\0?\0x\0?\0?\0?\0?\0\0?\0?\0x\0?\0?\0l\0?\0?\0?\0\0x\0?\0?\0x\0?\0\0?\0l\0?\0?\0?\0\0?\0?\0?\0\0\0J\0Y&\0\0!\0J\0Y&\0\0?\0?\0\0M\0\0:\0\0w\0?\0?\0?\0?\0|\0\0?\0l\0x\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0?\0? \0 \0?\0?\0\0?\0l\0?\0?\0\0?\0?\0?\0?\0?\0?\0\0 \0J\0Q&\0\0?\0l\0?\0?\0?\0?\0\0?\0?\0?\0|\0?\0?\0?&\0\0l\0?\0|\0\0w\0?\0?\0?\0?\0?\0\0w\0?\0?\0x\0?\0?\0l\0?\0?\0\0?\0x\0?\0?\0?\0?+\0\0&\0?\0\0?\0?\0?\0?\0?\0?\0?\0? \0 \0?\0?\0?\0?\0?\0?\0?\0?\0?\0?\0\0?\0l\0?\0|\0?\0l\0?\0?\07\0?\0?\0l\0?\0?\0?\0?\0\0b\0M\0:\0?&\0\0h;\0?\0?\0?\0?\0?\0?\0\0&\0?\0?\0?\0?\0\0?\0?\0\0d;\0?\0?\0?\0?\0?\0?\0\0\0:\0\0\0?\0?\0?\0?\0?\0?\0w\0?\0l\0?\0|\0?8& \0 \0?\0?\0w\0?\0?\0?\0\0x\0?\0?\0?\0?\0?\0?\07\0?\0?\0?\0?;\0?\0?\0|\0\0l\0?\0?\0\0?\0?\0\0\0&\0@ 1 \0x\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?8&\0\0l\0?\0|\0\0l\0\0?\0?\0?\0?\0l\0w\0?\0?\0\0J\0Q\0Y+\0\0M\0?\0?\0?\0?\0\0?\0?\0x\0?\0?\0|\0? \0 \0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0l\0?\0?\0?\0?\0?&\0\0?\0?\0?\0?\0l\0w\0?\0?\0?\0?\0?&\0\0?\0?\0?\0?\0?\0?\0?\0l\0?\0\0?\0l\0?\0|\0?\0l\0?\0?\0\0?\0?\0?\0?\0?\0?\0l\0?\0\0?\0?\0|\0?\0x\0?\0?\0?\0?&\0\0l\0?\0| \0 \0?\0?\0x\0?\0?\0l\0?\0?\0|\0\0?\0?\0?\0?\0?\0\0|\0?\0l\0?+\0\0\0?\0?\0l\0?\0?\0\0?\0?\0?\0?\0\0?\0?\0l\0w\0?\0?\0?\0?\0?\0\0l\0?\0|\0\0?\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?0\0\0?\0?\0x\0?\0?\0l\0?\0?\0\0x\0?\0?\0x\0?\0? \0 \0l\0?\0|\0\0?\0?\0?\0?\0l\0?\0?\0\0?\0?\0x\0?\0?\0?\0?\0?\0?\0l\0?\0?\0?+ ?? \0? ] \0? Z \0? ] \0? m  @ 6 \0Y\0?\0|\0l\0?\0?\0\0\0&\0@\0Q&\0\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0|\0\0x\0?\0?\0?\0?\0?\0?&\0\0l\0?\0| \0 \0w\0l\0x\0?\0\0?\0?\0\0|\0l\0?\0l+ ?? \0G 6 \0? ] \0? 4 \0? 6 m \0? + Q \0? u 6  6  \0M\0l\0?\0?\0?\0\0x\0?\0?\0x\0?\0?\0\0?\0?\0?\0?\0?\0?\0?\0?&\0\0?\0?\0?\0?\0\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0? \0 \0?\0?\0?\0?\0?&\0\0?\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0l\0?\0?+ ?? \0? \0? +  \0? \0? m  @ 6 \0M\0?\0?\0\0?\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0?&\0\0x\0?\0?\0x\0?\0\0?\0?\0l\0w\0?\0?\0?\0?\0?\0\0l\0?\0|\0\0?\0?\0?\0?\0l\0?\0?\0\0w\0?\0?\0l\0?\0?\0?\0?+ \0; \0? \0?  Q \0? \0? 6 \0? \0? ]  6   Q \0 @ 4 Z u m \0?  Q \0? 6 \0? Q \0b @ \0? \0? ] 6 Q \0: \0? \0? m u ] \0? d \0V\0?\0?\0\0!\0J\0Y\0\0l\0x\0x\0?\0?\0?\0?\0l\0?\0?\0?\0\0?\0?\0l\0?\0?\0?\0x\0?\0\0l\0?\0|\0\0?\0l\0?\0l\0?\0?\0?\0?\0\0x\0?\0?\0?\0?\0?\0?9\0x\0?\0?\0x\0?\0l\0?\0\0?\0?\0?\0\0?\0l\0?\0?\0?\0?&\0\0?\0?\0|\0?\0?\0\0?\0|\0?\0?\0?\0?\0?&\0\0\0\0&\0\0l\0?\0|\0\0?\0l\0?\0?\0\0 \0&\0\0?\0l\0?\0?\0?+\0\0V\0?\0?\0?\0?\0\0?\0?\0x\0?\0?\0|\0?\0\0?\0?\0?\0?\0?\0?\0l\0?\0?\0|\0\0!\0J\0Y\0? \0 7\0?\0!\0J\0Y8\0\0?\0?\0?\0\0?\0?\0?;\0?\0?\0?\0?\0?\0\0l\0?\0|\0\0w\0l\0?\0?\0x\0\0?\0?\0l\0?\0?\0?\0x\0?&\0\0l\0?\0|\0\0|\0?\0?\0x\0?\0?\0?\0?\0\0!\0J\0Y\0?\07\0|\0!\0J\0Y8\0\0?\0?\0?\0?\0\0|\0?\0|\0?\0x\0l\0?\0?\0|\0\0b\0M\0\0:\0\0?\0?\0?\0\0?\0?\0?\0?;\0?\0?\0?\0?\0? \0?\0?\0l\0?\0x\0?\0\0?\0?\0?\0?\0?\0?\0l\0|\0?+\0\0:\0?\0|\0?\0?\0?\0\0!\0J\0Y \0 \0?\0?\0x\0?\0?\0?\0?\0?\0?\0?\0?\0?%\0\0?\0l\0?\0|\0?\0l\0?\0?\0\0?\0l\0?\0\0?\0?\0l\0x\0?\0?\0?\0\0?\0?\0?\0\0?\0?\0l\0?\0?\0?\0?\0?\0x\0\0?\0?\0?\0?\0?\0?\0?\0?&\0\0?\0?\0?\0?\0?\0? 1 \0\0&\0\0x\0?\0?\0?\0?\0\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0?\0x\0?\0\0l\0?\0|\0\0?\0?\0l\0?\0?;\0? \0?\0?\0?\0?\0l\0?\0?\0?\0?\07\0\04\0Q\0Q 1 \0\0&\0\0?\0?\0l\0?\0?\0\0?\0?\0?8&\0\0\0b\0\0?\0l\0?\0|\0?\0l\0?\0?\0 \0?\0?\0x\0?\0|\0?\0?\0?\0\0?\0?\0?\0\0?\0?\0?\0?\0x\0?\0?\0?\0?\0\0?\0?\0|\0?\0?&\0\0l\0?\0|\0\0?\0?\0?\0?;\0?\0?\0?\0\0?\0?\0?\0?\0?\0?\0\0?\0?\0?\0?\0\0!\0\0\0M 1 \0!\0\0\0M +\0\0\0?\0?\0?\0?\0?\0\0!\0J\0Y\0\0w\0l\0?\0?\0|\0\0?\0?\0\0?\0l\0?\0?\0?\0?\0\0?\0?\0?\0?\0? \0?\0?\0?\0?\0?&\0\0?\0?\0l\0?\0?\0\0?\0l\0?\0?&\0\0l\0?\0|\0\0x\0?\0?\0?\0?\0?\0? \0 \0?\0?\0?\0|\0?+ \0G 6 m \0?  ] \0? m \0? \0? Q \0; \0? \0? \0\0?\0?\0?', '2026-04-16 03:18:20'),
(10, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'CSCOFFICERS_2022-2026.docx', '459b9d55229c83f0865f764fa1aded49.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 13874, '2022-2023 Lyka Izzabelle Dinoso Ashley Heart Valencia Mark Kian Oliquiano 2023-2024 Mark Kian Oliquiano Lyka Izzabelle Dinoso Ashley Heart Valencia Benjo Corido Jules Ariola Earl Osera Lucky Nogot 2024-2025 Benjo Corido Kurt Cuya Jose Luis Pena 2025-2026 Kurt Cuya Benjo Corido Lyka Dinoso', '2026-04-19 06:21:34'),
(11, 3, '32094c8cec6ea1a81bfd38e2dee1e9ba', 'CSCOFFICERS_2022-2026.docx', '65723275237b27c2c409470169eb0f9b.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 13874, '2022-2023 Lyka Izzabelle Dinoso Ashley Heart Valencia Mark Kian Oliquiano 2023-2024 Mark Kian Oliquiano Lyka Izzabelle Dinoso Ashley Heart Valencia Benjo Corido Jules Ariola Earl Osera Lucky Nogot 2024-2025 Benjo Corido Kurt Cuya Jose Luis Pena 2025-2026 Kurt Cuya Benjo Corido Lyka Dinoso', '2026-04-19 06:22:08'),
(12, 1, '99750ce7b2358a19a34ad752adb7e927', 'OBC_MedStaff_Manual.docx', 'c39ec5c84bd3ae6d13a52e2a431628ce.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 661977, 'Omni Bite Center Animal Bite Management System Medical Staff User Manual Vaccination Administration &amp; Clinical Records ───────────────────────────── Table of Contents 1. System Overview &amp; Login 2. Daily Queue (Dashboard) 3. Processing a Patient — Administering a Dose 4. Patient Search &amp; Lookup 5. Patient History Records 6. Vaccine Stock Monitoring 7. My Activity Report 8. Print Sheet &amp; Documents 9. Common Issues &amp; Tips Chapter 1: System Overview &amp; Login The Omni Bite Center System manages the entire lifecycle of animal bite patients — from registration by the Clerk to vaccination by the Medical Staff. As Medical Staff (Nurse/Vaccinator), you handle the clinical side: you confirm that patients are present, administer the correct vaccine dose, and record the outcome. 1.1 Your Role in the System View the daily vaccination queue Mark doses as administered for each patient visit Record the vaccine brand and batch number used Search for patients by name or case number View complete patient treatment history Monitor current vaccine stock levels 1.2 How to Log In Screenshot: Login Page — Enter your medstaff credentials Open the system URL in your browser. Enter your Username and Password. Click \"Login.\" You will be redirected to the Medical Staff Dashboard. TIP Your account is set to role: Nurse/Medstaff. You will only see clinical screens — not the patient registration forms used by Clerks. Chapter 2: Daily Queue (Dashboard) The Daily Queue is your main work screen. Every patient registered by the Clerk for today\'s vaccines will appear here automatically. Screenshot: Medical Staff Dashboard — Daily Queue table 2.1 Reading the Queue Table Column What It Means Patient Name Full name of the patient who needs a vaccine today Vaccine Type Which vaccine is due (Rabies, Tetanus, Anti-venom) Dose Day Day 0, Day 3, Day 7, or Day 28 of the treatment schedule Category Exposure category (I, II, or III) — determines treatment protocol Status Pending = not yet administered | Completed = done Action Button \"Administer Dose\" button — click when patient is ready Screenshot: Queue Table — Rows showing Pending and Completed statuses 2.2 Stats Summary Cards At the top of the dashboard, you will see summary cards showing: Total patients in queue today How many doses have been completed How many are still pending NOTE The queue refreshes automatically. You can also click the refresh button (circular arrow icon) in the header. Chapter 3: Administering a Dose When a patient arrives for their scheduled dose, follow these steps: IMPORTANT Verify the patient\'s identity (ask for their name and check their treatment card) before administering any vaccine! Step 1 — Find the Patient in the Queue Look at the Daily Queue table. Find the patient\'s name. Confirm it matches the person in front of you. Check the Dose Day column — make sure it matches today\'s schedule (e.g., Day 3). Screenshot: Queue — Finding a specific patient row to administer dose Step 2 — Fill in the Dose Details Field What to Enter Vaccine Brand Select from dropdown (e.g., Verorab, Speeda) Batch Number Enter from the vaccine vial label — required for traceability Route Intramuscular (IM) or Intradermal (ID) as ordered by physician Site of Injection Left deltoid, Right deltoid, etc. Administered By Your name (auto-filled from your login session) Chapter 4: Patient Search &amp; Lookup If you need to look up a patient who is not currently in the daily queue (e.g., a walk-in checking their schedule, or a past patient returning), use Patient Search. How to Search Click \"Patient Search\" in the left sidebar. Type the patient\'s last name, first name, or case number in the search bar. Results will appear below as you type. Click on a patient to view their full profile. Screenshot: Patient Search page — Search bar and results list NOTE You can search by partial name. For example, typing \"Cruz\" will show all patients with Cruz in their name. Chapter 5: Patient History Records Each patient has a complete treatment history that shows every dose administered, who administered it, and when. Viewing a Patient\'s History Find the patient via the Daily Queue or Patient Search. Click their name or the \"Full Record\" button. The patient profile will show their personal info, exposure details, and a full vaccination history table. Screenshot: Patient History — Full treatment record with all doses listed History Column Meaning Date Given When the dose was administered Dose Which dose number (Day 0, 3, 7, 28) Vaccine Brand and batch number used Administered By Staff who gave the dose Next Appointment Automatically computed next dose date Chapter 6: Vaccine Stock Monitoring Click \"Vaccine Stock\" in the sidebar to see what vaccines are currently available. Screenshot: Vaccine Stock page — Current inventory list Column What It Shows Action Required Vaccine Name Brand name of the vaccine — Stock Remaining Available vials/doses Report if below minimum Expiry Date Date vaccine expires Do not use expired vaccines! Status Active or Expired/Depleted Inform Admin if depleted IMPORTANT NEVER administer an expired vaccine. If the stock page shows an expired item still \"Active,\" report it to Admin immediately for correction. Chapter 7: My Activity Report Click \"My Activity\" in the sidebar to see a summary of doses you have administered in a given time period. Use this for: Verifying your daily or weekly workload Self-auditing your recorded administrations Screenshot: My Activity page — Personal dose administration log Chapter 8: Print Sheet &amp; Documents From a patient\'s record, you can print the treatment sheet for physical filing or for handing to the patient. This is the official OBC-CGL-001 form. Open the patient\'s record. Click the \"Print Sheet\" button. A print-ready version will open. Press Ctrl+P or Command+P to print. Screenshot: Print Sheet view — Formatted patient treatment document TIP Print the sheet after Day 0 (first visit) and give it to the patient. They ', '2026-04-23 05:51:25');

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

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

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `username` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `full_name` varchar(100) NOT NULL,
  `course` varchar(100) DEFAULT NULL,
  `school` varchar(100) DEFAULT NULL,
  `role` enum('student','teacher','admin') DEFAULT 'student',
  `avatar_initials` varchar(4) DEFAULT NULL,
  `semester_progress` tinyint(3) UNSIGNED DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `google_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `users` (`id`, `username`, `email`, `password_hash`, `full_name`, `course`, `school`, `role`, `avatar_initials`, `semester_progress`, `is_active`, `remember_token`, `created_at`, `updated_at`, `google_id`) VALUES
(1, 'jirwen12', 'palajejirwen@gmail.com', '$2y$12$HkBhVML1JxM8gvQkuLCEkOs7GfnSChnV6YrB1n8SviCNBpxvp2m7G', 'kyne', 'BSIT 4', 'PLT', 'student', 'KY', 59, 1, NULL, '2026-04-14 15:15:51', '2026-04-23 05:33:37', NULL),
(2, 'abigil', 'abegailsuarez@gmail.com', '$2y$12$oMyAMEmBlLWMy5vAC.300uuuBJ1BozYbNgY9QsjBKROy0sqe3FQhm', 'Abegail Suarez', 'BSIT', 'PLT', 'student', 'AS', 40, 1, NULL, '2026-04-15 02:54:20', '2026-04-15 04:11:43', NULL),
(3, 'cursor ai', 'aicursor041@gmail.com', '', 'cursor ai', NULL, NULL, 'student', NULL, 0, 1, NULL, '2026-04-17 01:14:12', '2026-04-17 01:16:16', '100831778896049235458'),
(4, 'Ivannn', 'ivannebres06@gmail.com', '$2y$12$GnsMkJ04wY3WK1.82mEAN.JL9o5/1ZXDd072NjIE.vPJzhNyceTpe', 'Ivan Nebres', 'BSIT', 'PLT COLLEGE', 'student', 'IN', 0, 1, NULL, '2026-04-22 06:48:14', '2026-04-22 06:48:14', NULL),
(5, 'jorzevangelio23', 'jorzevangeliomar@gmail.com', '$2y$12$gFWCoEYIcjnT.meVvRIoie8mzLXw8XwBtFv1S544/4dQJG1pA6YlS', 'Jorz evangelio Mar', 'BSIT-3', 'Plt collage', 'student', 'JE', 0, 1, NULL, '2026-04-22 06:54:18', '2026-04-22 06:54:18', NULL),
(6, 'abby', 'abegailsuarez984@gmail.com', '$2y$12$XgLJeXglcoUtGVWScKQKEu2Y5.8/h2hzmQrzcABE6NN9Q3YWFdDfa', 'Abegail Suarez', 'BSIT', 'PLT College', 'student', 'AS', 0, 1, NULL, '2026-04-22 06:57:29', '2026-04-22 06:57:29', NULL),
(7, 'its_eunycq', 'eunicadelacruz620@gmail.com', '$2y$12$L9AR.ROGh3Ztt5iFGfRSP.bHbs0Jc52fy58gUH1PEEbBXtrX2mHfm', 'Eunica B. Dela Cruz', 'BSIT', 'PLT College of Guinobatan, Inc.', 'student', 'EB', 0, 1, NULL, '2026-04-23 08:18:27', '2026-04-23 08:18:27', NULL),
(8, 'juan', 'ivanpalay.nebres@gmail.com', '$2y$12$sczNZVybmGKte7FrMTeT5OiuAvk/kb1YV33OqfNIgGmaxiV3x6Fsu', 'Juan dela cruz', 'Bsit', 'Plt', 'student', 'JD', 0, 1, NULL, '2026-04-27 04:28:39', '2026-04-27 04:28:39', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ai_chats`
--
ALTER TABLE `ai_chats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_session` (`user_id`,`session_id`,`created_at`);

--
-- Indexes for table `ai_chat_sessions`
--
ALTER TABLE `ai_chat_sessions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `session_id` (`session_id`),
  ADD KEY `idx_user_sessions` (`user_id`,`updated_at`);

--
-- Indexes for table `calendar_events`
--
ALTER TABLE `calendar_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_events` (`user_id`,`event_date`);

--
-- Indexes for table `flashcards`
--
ALTER TABLE `flashcards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deck_id` (`deck_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `flashcard_decks`
--
ALTER TABLE `flashcard_decks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_decks` (`user_id`,`created_at`);

--
-- Indexes for table `notes`
--
ALTER TABLE `notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_notes` (`user_id`,`is_archived`,`created_at`);

--
-- Indexes for table `pomodoro_sessions`
--
ALTER TABLE `pomodoro_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `task_id` (`task_id`);

--
-- Indexes for table `quiz_answers`
--
ALTER TABLE `quiz_answers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attempt_id` (`attempt_id`),
  ADD KEY `question_id` (`question_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `quiz_attempts`
--
ALTER TABLE `quiz_attempts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deck_id` (`deck_id`),
  ADD KEY `idx_user_attempts` (`user_id`,`deck_id`,`started_at`);

--
-- Indexes for table `quiz_decks`
--
ALTER TABLE `quiz_decks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_quizzes` (`user_id`,`created_at`);

--
-- Indexes for table `quiz_questions`
--
ALTER TABLE `quiz_questions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `deck_id` (`deck_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `quiz_responses`
--
ALTER TABLE `quiz_responses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_attempt_questions` (`attempt_id`,`question_id`);

--
-- Indexes for table `remember_tokens`
--
ALTER TABLE `remember_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `token_hash` (`token_hash`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `study_sessions`
--
ALTER TABLE `study_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_date` (`user_id`,`session_date`);

--
-- Indexes for table `subjects`
--
ALTER TABLE `subjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_tasks` (`user_id`,`status`,`due_date`);

--
-- Indexes for table `uploaded_docs`
--
ALTER TABLE `uploaded_docs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`),
  ADD UNIQUE KEY `google_id` (`google_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ai_chats`
--
ALTER TABLE `ai_chats`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=183;

--
-- AUTO_INCREMENT for table `ai_chat_sessions`
--
ALTER TABLE `ai_chat_sessions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `calendar_events`
--
ALTER TABLE `calendar_events`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `flashcards`
--
ALTER TABLE `flashcards`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `flashcard_decks`
--
ALTER TABLE `flashcard_decks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `notes`
--
ALTER TABLE `notes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `pomodoro_sessions`
--
ALTER TABLE `pomodoro_sessions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `quiz_answers`
--
ALTER TABLE `quiz_answers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

--
-- AUTO_INCREMENT for table `quiz_attempts`
--
ALTER TABLE `quiz_attempts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `quiz_decks`
--
ALTER TABLE `quiz_decks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `quiz_questions`
--
ALTER TABLE `quiz_questions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=149;

--
-- AUTO_INCREMENT for table `quiz_responses`
--
ALTER TABLE `quiz_responses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `remember_tokens`
--
ALTER TABLE `remember_tokens`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `study_sessions`
--
ALTER TABLE `study_sessions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `uploaded_docs`
--
ALTER TABLE `uploaded_docs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `ai_chats`
--
ALTER TABLE `ai_chats`
  ADD CONSTRAINT `ai_chats_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ai_chat_sessions`
--
ALTER TABLE `ai_chat_sessions`
  ADD CONSTRAINT `ai_chat_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `calendar_events`
--
ALTER TABLE `calendar_events`
  ADD CONSTRAINT `calendar_events_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `flashcards`
--
ALTER TABLE `flashcards`
  ADD CONSTRAINT `flashcards_ibfk_1` FOREIGN KEY (`deck_id`) REFERENCES `flashcard_decks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `flashcards_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `flashcard_decks`
--
ALTER TABLE `flashcard_decks`
  ADD CONSTRAINT `flashcard_decks_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notes`
--
ALTER TABLE `notes`
  ADD CONSTRAINT `notes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pomodoro_sessions`
--
ALTER TABLE `pomodoro_sessions`
  ADD CONSTRAINT `pomodoro_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pomodoro_sessions_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `quiz_answers`
--
ALTER TABLE `quiz_answers`
  ADD CONSTRAINT `quiz_answers_ibfk_1` FOREIGN KEY (`attempt_id`) REFERENCES `quiz_attempts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `quiz_answers_ibfk_2` FOREIGN KEY (`question_id`) REFERENCES `quiz_questions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `quiz_answers_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `quiz_attempts`
--
ALTER TABLE `quiz_attempts`
  ADD CONSTRAINT `quiz_attempts_ibfk_1` FOREIGN KEY (`deck_id`) REFERENCES `quiz_decks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `quiz_attempts_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `quiz_decks`
--
ALTER TABLE `quiz_decks`
  ADD CONSTRAINT `quiz_decks_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `quiz_questions`
--
ALTER TABLE `quiz_questions`
  ADD CONSTRAINT `quiz_questions_ibfk_1` FOREIGN KEY (`deck_id`) REFERENCES `quiz_decks` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `quiz_questions_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `quiz_responses`
--
ALTER TABLE `quiz_responses`
  ADD CONSTRAINT `quiz_responses_ibfk_1` FOREIGN KEY (`attempt_id`) REFERENCES `quiz_attempts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `remember_tokens`
--
ALTER TABLE `remember_tokens`
  ADD CONSTRAINT `remember_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `study_sessions`
--
ALTER TABLE `study_sessions`
  ADD CONSTRAINT `study_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subjects`
--
ALTER TABLE `subjects`
  ADD CONSTRAINT `subjects_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `uploaded_docs`
--
ALTER TABLE `uploaded_docs`
  ADD CONSTRAINT `uploaded_docs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

